本文整理汇总了PHP中get_records_csv函数的典型用法代码示例。如果您正苦于以下问题：PHP get_records_csv函数的具体用法？PHP get_records_csv怎么用？PHP get_records_csv使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了get_records_csv函数的6个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: main_upgrade
//.........这里部分代码省略.........
if ($oldversion < 2005032600) {
execute_sql('DROP TABLE ' . $CFG->prefix . 'dst_preset', false);
modify_database('', "CREATE TABLE prefix_timezone (\n id SERIAL PRIMARY KEY,\n name varchar(100) NOT NULL default '',\n year integer NOT NULL default '0',\n rule varchar(20) NOT NULL default '',\n gmtoff integer NOT NULL default '0',\n dstoff integer NOT NULL default '0',\n dst_month integer NOT NULL default '0',\n dst_startday integer NOT NULL default '0',\n dst_weekday integer NOT NULL default '0',\n dst_skipweeks integer NOT NULL default '0',\n dst_time varchar(5) NOT NULL default '00:00',\n std_month integer NOT NULL default '0',\n std_startday integer NOT NULL default '0',\n std_weekday integer NOT NULL default '0',\n std_skipweeks integer NOT NULL default '0',\n std_time varchar(5) NOT NULL default '00:00'\n );");
}
if ($oldversion < 2005032800) {
modify_database('', "CREATE TABLE prefix_grade_category (\n id SERIAL PRIMARY KEY,\n name varchar(64) default NULL,\n courseid integer NOT NULL default '0',\n drop_x_lowest integer NOT NULL default '0',\n bonus_points integer NOT NULL default '0',\n hidden integer NOT NULL default '0',\n weight decimal(4,2) default '0.00'\n );");
modify_database('', "CREATE INDEX prefix_grade_category_courseid_idx ON prefix_grade_category (courseid);");
modify_database('', "CREATE TABLE prefix_grade_exceptions (\n id SERIAL PRIMARY KEY,\n courseid integer NOT NULL default '0',\n grade_itemid integer NOT NULL default '0',\n userid integer NOT NULL default '0'\n );");
modify_database('', "CREATE INDEX prefix_grade_exceptions_courseid_idx ON prefix_grade_exceptions (courseid);");
modify_database('', "CREATE TABLE prefix_grade_item (\n id SERIAL PRIMARY KEY,\n courseid integer default NULL,\n category integer default NULL,\n modid integer default NULL,\n cminstance integer default NULL,\n scale_grade float(11) default '1.0000000000',\n extra_credit integer NOT NULL default '0',\n sort_order integer NOT NULL default '0'\n );");
modify_database('', "CREATE INDEX prefix_grade_item_courseid_idx ON prefix_grade_item (courseid);");
modify_database('', "CREATE TABLE prefix_grade_letter (\n id SERIAL PRIMARY KEY,\n courseid integer NOT NULL default '0',\n letter varchar(8) NOT NULL default 'NA',\n grade_high decimal(6,2) NOT NULL default '100.00',\n grade_low decimal(6,2) NOT NULL default '0.00'\n );");
modify_database('', "CREATE INDEX prefix_grade_letter_courseid_idx ON prefix_grade_letter (courseid);");
modify_database('', "CREATE TABLE prefix_grade_preferences (\n id SERIAL PRIMARY KEY,\n courseid integer default NULL,\n preference integer NOT NULL default '0',\n value integer NOT NULL default '0'\n );");
modify_database('', "CREATE UNIQUE INDEX prefix_grade_prefs_courseidpref_uk ON prefix_grade_preferences (courseid,preference);");
}
if ($oldversion < 2005033100) {
// Get rid of defunct field from course modules table
delete_records('course_modules', 'deleted', 1);
// Delete old records we don't need any more
execute_sql('DROP INDEX ' . $CFG->prefix . 'course_modules_deleted_idx;');
// Old index
execute_sql('ALTER TABLE ' . $CFG->prefix . 'course_modules DROP deleted;');
// Old field
}
if ($oldversion < 2005040800) {
table_column('user', 'timezone', 'timezone', 'varchar', '100', '', '99');
execute_sql(" ALTER TABLE {$CFG->prefix}user DROP timezonename ");
}
if ($oldversion < 2005041101) {
require_once $CFG->libdir . '/filelib.php';
if (is_readable($CFG->dirroot . '/lib/timezones.txt')) {
// Distribution file
if ($timezones = get_records_csv($CFG->dirroot . '/lib/timezones.txt', 'timezone')) {
$db->debug = false;
update_timezone_records($timezones);
notify(count($timezones) . ' timezones installed');
$db->debug = true;
}
}
}
if ($oldversion < 2005041900) {
// Copy all Dialogue entries into Messages, and hide Dialogue module
if ($entries = get_records_sql('SELECT e.id, e.userid, c.recipientid, e.text, e.timecreated
FROM ' . $CFG->prefix . 'dialogue_conversations c,
' . $CFG->prefix . 'dialogue_entries e
WHERE e.conversationid = c.id')) {
foreach ($entries as $entry) {
$message = NULL;
$message->useridfrom = $entry->userid;
$message->useridto = $entry->recipientid;
$message->message = addslashes($entry->text);
$message->format = FORMAT_HTML;
$message->timecreated = $entry->timecreated;
$message->messagetype = 'direct';
insert_record('message_read', $message);
}
}
set_field('modules', 'visible', 0, 'name', 'dialogue');
notify('The Dialogue module has been disabled, and all the old Messages from it copied into the new standard Message feature. If you really want Dialogue back, you can enable it using the "eye" icon here: Admin >> Modules >> Dialogue');
}
if ($oldversion < 2005042100) {
$result = table_column('event', '', 'repeatid', 'int', '10', 'unsigned', '0', 'not null', 'userid') && $result;
}
if ($oldversion < 2005042400) {
// Add user tracking prefs field.示例2: install_site
/**
* Perform a fresh test site installation
*
* Note: To be used from CLI scripts only.
*
* @static
* @return void may terminate execution with exit code
*/
public static function install_site()
{
global $DB, $CFG;
if (!self::is_test_site()) {
phpunit_bootstrap_error(PHPUNIT_EXITCODE_CONFIGERROR, 'Can not install on non-test site!!');
}
if ($DB->get_tables()) {
list($errorcode, $message) = phpunit_util::testing_ready_problem();
if ($errorcode) {
phpunit_bootstrap_error(PHPUNIT_EXITCODE_REINSTALL, 'Database tables already present, Moodle PHPUnit test environment can not be initialised');
} else {
phpunit_bootstrap_error(0, 'Moodle PHPUnit test environment is already initialised');
}
}
$options = array();
$options['adminpass'] = 'admin';
$options['shortname'] = 'phpunit';
$options['fullname'] = 'PHPUnit test site';
install_cli_database($options, false);
// Disable all logging for performance and sanity reasons.
set_config('enabled_stores', '', 'tool_log');
// We need to keep the installed dataroot filedir files.
// So each time we reset the dataroot before running a test, the default files are still installed.
self::save_original_data_files();
// install timezone info
$timezones = get_records_csv($CFG->libdir . '/timezone.txt', 'timezone');
update_timezone_records($timezones);
// Store version hash in the database and in a file.
self::store_versions_hash();
// Store database data and structure.
self::store_database_state();
}示例3: install_site
/**
* Perform a fresh test site installation
*
* Note: To be used from CLI scripts only.
*
* @static
* @return void may terminate execution with exit code
*/
public static function install_site()
{
global $DB, $CFG;
if (!self::is_test_site()) {
phpunit_bootstrap_error(PHPUNIT_EXITCODE_CONFIGERROR, 'Can not install on non-test site!!');
}
if ($DB->get_tables()) {
list($errorcode, $message) = phpunit_util::testing_ready_problem();
if ($errorcode) {
phpunit_bootstrap_error(PHPUNIT_EXITCODE_REINSTALL, 'Database tables already present, Moodle PHPUnit test environment can not be initialised');
} else {
phpunit_bootstrap_error(0, 'Moodle PHPUnit test environment is already initialised');
}
}
$options = array();
$options['adminpass'] = 'admin';
$options['shortname'] = 'phpunit';
$options['fullname'] = 'PHPUnit test site';
install_cli_database($options, false);
// install timezone info
$timezones = get_records_csv($CFG->libdir . '/timezone.txt', 'timezone');
update_timezone_records($timezones);
// Store version hash in the database and in a file.
self::store_versions_hash();
// Store database data and structure.
self::store_database_state();
}示例4: main_upgrade
//.........这里部分代码省略.........
}
if ($oldversion < 2005032300) {
table_column('user', 'dstpreset', 'timezonename', 'varchar', '100');
execute_sql('UPDATE `' . $CFG->prefix . 'user` SET timezonename = \'\'');
}
if ($oldversion < 2005032600) {
execute_sql('DROP TABLE ' . $CFG->prefix . 'dst_preset', false);
modify_database('', "CREATE TABLE `prefix_timezone` (\n `id` int(10) NOT NULL auto_increment,\n `name` varchar(100) NOT NULL default '',\n `year` int(11) NOT NULL default '0',\n `rule` varchar(20) NOT NULL default '',\n `gmtoff` int(11) NOT NULL default '0',\n `dstoff` int(11) NOT NULL default '0',\n `dst_month` tinyint(2) NOT NULL default '0',\n `dst_startday` tinyint(3) NOT NULL default '0',\n `dst_weekday` tinyint(3) NOT NULL default '0',\n `dst_skipweeks` tinyint(3) NOT NULL default '0',\n `dst_time` varchar(5) NOT NULL default '00:00',\n `std_month` tinyint(2) NOT NULL default '0',\n `std_startday` tinyint(3) NOT NULL default '0',\n `std_weekday` tinyint(3) NOT NULL default '0',\n `std_skipweeks` tinyint(3) NOT NULL default '0',\n `std_time` varchar(5) NOT NULL default '00:00',\n PRIMARY KEY (`id`)\n ) TYPE=MyISAM COMMENT='Rules for calculating local wall clock time for users';");
}
if ($oldversion < 2005032800) {
execute_sql("CREATE TABLE `{$CFG->prefix}grade_category` (\n `id` int(10) unsigned NOT NULL auto_increment,\n `name` varchar(64) NOT NULL default '',\n `courseid` int(10) unsigned NOT NULL default '0',\n `drop_x_lowest` int(10) unsigned NOT NULL default '0',\n `bonus_points` int(10) unsigned NOT NULL default '0',\n `hidden` int(10) unsigned NOT NULL default '0',\n `weight` decimal(4,2) NOT NULL default '0.00',\n PRIMARY KEY (`id`),\n KEY `courseid` (`courseid`)\n ) TYPE=MyISAM ;");
execute_sql("CREATE TABLE `{$CFG->prefix}grade_exceptions` (\n `id` int(10) unsigned NOT NULL auto_increment,\n `courseid` int(10) unsigned NOT NULL default '0',\n `grade_itemid` int(10) unsigned NOT NULL default '0',\n `userid` int(10) unsigned NOT NULL default '0',\n PRIMARY KEY (`id`),\n KEY `courseid` (`courseid`)\n ) TYPE=MyISAM ;");
execute_sql("CREATE TABLE `{$CFG->prefix}grade_item` (\n `id` int(10) unsigned NOT NULL auto_increment,\n `courseid` int(10) unsigned NOT NULL default '0',\n `category` int(10) unsigned NOT NULL default '0',\n `modid` int(10) unsigned NOT NULL default '0',\n `cminstance` int(10) unsigned NOT NULL default '0',\n `scale_grade` float(11,10) default '1.0000000000',\n `extra_credit` int(10) unsigned NOT NULL default '0',\n `sort_order` int(10) unsigned NOT NULL default '0',\n PRIMARY KEY (`id`),\n KEY `courseid` (`courseid`)\n ) TYPE=MyISAM ;");
execute_sql("CREATE TABLE `{$CFG->prefix}grade_letter` (\n `id` int(10) unsigned NOT NULL auto_increment,\n `courseid` int(10) unsigned NOT NULL default '0',\n `letter` varchar(8) NOT NULL default 'NA',\n `grade_high` decimal(4,2) NOT NULL default '100.00',\n `grade_low` decimal(4,2) NOT NULL default '0.00',\n PRIMARY KEY (`id`),\n KEY `courseid` (`courseid`)\n ) TYPE=MyISAM ;");
execute_sql("CREATE TABLE `{$CFG->prefix}grade_preferences` (\n `id` int(10) unsigned NOT NULL auto_increment,\n `courseid` int(10) unsigned NOT NULL default '0',\n `preference` int(10) NOT NULL default '0',\n `value` int(10) NOT NULL default '0',\n PRIMARY KEY (`id`),\n UNIQUE KEY `courseidpreference` (`courseid`,`preference`)\n ) TYPE=MyISAM ;");
}
if ($oldversion < 2005033100) {
// Get rid of defunct field from course modules table
delete_records('course_modules', 'deleted', 1);
// Delete old records we don't need any more
execute_sql('ALTER TABLE `' . $CFG->prefix . 'course_modules` DROP INDEX `deleted`');
// Old index
execute_sql('ALTER TABLE `' . $CFG->prefix . 'course_modules` DROP `deleted`');
// Old field
}
if ($oldversion < 2005040800) {
table_column('user', 'timezone', 'timezone', 'varchar', '100', '', '99');
execute_sql(" ALTER TABLE `{$CFG->prefix}user` DROP `timezonename` ");
}
if ($oldversion < 2005041101) {
require_once $CFG->libdir . '/filelib.php';
if (is_readable($CFG->dirroot . '/lib/timezones.txt')) {
// Distribution file
if ($timezones = get_records_csv($CFG->dirroot . '/lib/timezones.txt', 'timezone')) {
$db->debug = false;
update_timezone_records($timezones);
notify(count($timezones) . ' timezones installed');
$db->debug = true;
}
}
}
if ($oldversion < 2005041900) {
// Copy all Dialogue entries into Messages, and hide Dialogue module
if ($entries = get_records_sql('SELECT e.id, e.userid, c.recipientid, e.text, e.timecreated
FROM ' . $CFG->prefix . 'dialogue_conversations c,
' . $CFG->prefix . 'dialogue_entries e
WHERE e.conversationid = c.id')) {
foreach ($entries as $entry) {
$message = new object();
$message->useridfrom = $entry->userid;
$message->useridto = $entry->recipientid;
$message->message = addslashes($entry->text);
$message->format = FORMAT_HTML;
$message->timecreated = $entry->timecreated;
$message->messagetype = 'direct';
insert_record('message_read', $message);
}
}
set_field('modules', 'visible', 0, 'name', 'dialogue');
notify('The Dialogue module has been disabled, and all the old Messages from it copied into the new standard Message feature. If you really want Dialogue back, you can enable it using the "eye" icon here: Admin >> Modules >> Dialogue');
}
if ($oldversion < 2005042100) {
$result = table_column('event', '', 'repeatid', 'int', '10', 'unsigned', '0', 'not null', 'userid') && $result;
}
if ($oldversion < 2005042400) {
// Add user tracking prefs field.示例5: fwrite
// Make local copy
fwrite($file, $content);
fclose($file);
if ($timezones = get_records_csv($CFG->dataroot . '/temp/timezone.txt', 'timezone')) {
// Parse it
update_timezone_records($timezones);
$importdone = $source;
}
unlink($CFG->dataroot . '/temp/timezone.txt');
}
}
/// Final resort, use the copy included in Moodle
$source = $CFG->dirroot . '/lib/timezone.txt';
if (!$importdone and is_readable($source)) {
// Distribution file
if ($timezones = get_records_csv($source, 'timezone')) {
update_timezone_records($timezones);
$importdone = $source;
}
}
/// That's it!
if ($importdone) {
$a = null;
$a->count = count($timezones);
$a->source = $importdone;
print_heading(get_string('importtimezonescount', 'admin', $a), '', 3);
print_continue('index.php');
$timezonelist = array();
foreach ($timezones as $timezone) {
if (is_array($timezone)) {
$timezone = (object) $timezone;示例6: install_site
/**
* Perform a fresh test site installation
*
* Note: To be used from CLI scripts only.
*
* @static
* @return void may terminate execution with exit code
*/
public static function install_site()
{
global $DB, $CFG;
if (!self::is_test_site()) {
phpunit_bootstrap_error(PHPUNIT_EXITCODE_CONFIGERROR, 'Can not install on non-test site!!');
}
if ($DB->get_tables()) {
list($errorcode, $message) = phpunit_util::testing_ready_problem();
if ($errorcode) {
phpunit_bootstrap_error(PHPUNIT_EXITCODE_REINSTALL, 'Database tables already present, Moodle PHPUnit test environment can not be initialised');
} else {
phpunit_bootstrap_error(0, 'Moodle PHPUnit test environment is already initialised');
}
}
$options = array();
$options['adminpass'] = 'admin';
$options['shortname'] = 'phpunit';
$options['fullname'] = 'PHPUnit test site';
install_cli_database($options, false);
// install timezone info
$timezones = get_records_csv($CFG->libdir . '/timezone.txt', 'timezone');
update_timezone_records($timezones);
// add test db flag
$hash = phpunit_util::get_version_hash();
set_config('phpunittest', $hash);
// store data for all tables
$data = array();
$structure = array();
$tables = $DB->get_tables();
foreach ($tables as $table) {
$columns = $DB->get_columns($table);
$structure[$table] = $columns;
if (isset($columns['id']) and $columns['id']->auto_increment) {
$data[$table] = $DB->get_records($table, array(), 'id ASC');
} else {
// there should not be many of these
$data[$table] = $DB->get_records($table, array());
}
}
$data = serialize($data);
file_put_contents("{$CFG->dataroot}/phpunit/tabledata.ser", $data);
phpunit_boostrap_fix_file_permissions("{$CFG->dataroot}/phpunit/tabledata.ser");
$structure = serialize($structure);
file_put_contents("{$CFG->dataroot}/phpunit/tablestructure.ser", $structure);
phpunit_boostrap_fix_file_permissions("{$CFG->dataroot}/phpunit/tablestructure.ser");
// hash all plugin versions - helps with very fast detection of db structure changes
file_put_contents("{$CFG->dataroot}/phpunit/versionshash.txt", $hash);
phpunit_boostrap_fix_file_permissions("{$CFG->dataroot}/phpunit/versionshash.txt", $hash);
}