本文整理汇总了PHP中SQL::error方法的典型用法代码示例。如果您正苦于以下问题:PHP SQL::error方法的具体用法?PHP SQL::error怎么用?PHP SQL::error使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SQL
的用法示例。
在下文中一共展示了SQL::error方法的11个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: connect
public static function connect($server = 'localhost:3306', $username = 'root', $password = '', $database = '')
{
//microtime(get_as_float)
//参数 描述
//get_as_float 如果给出了 get_as_float 参数并且其值等价于 TRUE,该函数将返回一个浮点数。
$timestamp = microtime(true);
SQL::$connection = mysqli_connect($server, $username, $password, $database);
//mysqli_connect(host,username,password,dbname,port,socket);
//参数 描述
//host 可选。规定主机名或 IP 地址。
//username 可选。规定 MySQL 用户名。
//password 可选。规定 MySQL 密码。
//dbname 可选。规定默认使用的数据库。
//port 可选。规定尝试连接到 MySQL 服务器的端口号。
//socket 可选。规定 socket 或要使用的已命名 pipe。
//round(x,prec)
//参数 描述
//x 可选。规定要舍入的数字。
//prec 可选。规定小数点后的位数。
//说明
//返回将 x 根据指定精度 prec (十进制小数点后数字的数目)进行四舍五入的结果。prec 也可以是负数或零(默认值)。
DEBUG::put('Connected: ' . $username . '@' . $server . ' spent: ' . round((microtime(true) - $timestamp) * 1000, 3) . 'ms', 'MySQL');
$err = SQL::error();
if ($err['id'] > 0) {
DEBUG::put(' - Error: #' . $err['id'] . ' ' . $err['error'], 'MySQL');
}
return SQL::$connection;
}
示例2: execute_reader
/**
* execute query and return all data in a reader
*
* @return SQLDataReader
*/
public function execute_reader()
{
$this->parse_query();
if (empty($this->queryParsed)) {
return new SQLDataReader();
}
$close = $this->conn->status() == 'closed';
$this->conn->open();
$res = $this->conn->query($this->queryParsed);
$data = array();
while ($row = $this->conn->fetch_array($res)) {
$data[] = $row;
}
// SQLite causes 'unknown error' after successful fetch of all data.
// Don't have a clue why...
$ret = empty($this->conn->error()) || $this->conn->error() == 'unknown error';
if ($close) {
$this->conn->close();
}
return $ret ? new SQLDataReader($data) : new SQLDataReader();
}
示例3: run_sql_script
function run_sql_script($dbhost, $dbuser, $dbpass, $dbname, $path, $unlink)
{
global $lang_global;
$fp = fopen($path, 'r') or die(error("Couldn't Open File!"));
$sql_1 = new SQL();
$sql_1->connect($dbhost, $dbuser, $dbpass, $dbname);
$query = "";
$queries = 0;
$linenumber = 0;
$inparents = false;
while (!feof($fp)) {
$dumpline = "";
while (!feof($fp) && substr($dumpline, -1) != "\n") {
$dumpline .= fgets($fp, 16384);
}
$dumpline = ereg_replace("\r\n\$", "\n", $dumpline);
$dumpline = ereg_replace("\r\$", "\n", $dumpline);
if (!$inparents) {
$skipline = false;
if (!$inparents && (trim($dumpline) == "" || strpos($dumpline, '#') === 0 || strpos($dumpline, '-- ') === 0)) {
$skipline = true;
}
if ($skipline) {
$linenumber++;
continue;
}
}
$dumpline_deslashed = str_replace("\\\\", "", $dumpline);
$parents = substr_count($dumpline_deslashed, "'") - substr_count($dumpline_deslashed, "\\'");
if ($parents % 2 != 0) {
$inparents = !$inparents;
}
$query .= $dumpline;
if (ereg(";\$", trim($dumpline)) && !$inparents) {
if (!$sql_1->query(trim($query))) {
fclose($fp);
if ($unlink) {
unlink($path);
}
$err = ereg_replace("\n", "", $sql_1->error());
$err = ereg_replace("\r\n\$", "", $err);
$err = ereg_replace("\r\$", "", $err);
error("SQL Error at the line: {$linenumber} in {$path} <br /> {$err}");
break;
}
$queries++;
$query = "";
}
$linenumber++;
}
$sql_1->close();
fclose($fp);
return $queries;
}
示例4: connect
/**
* 连接到数据库
* 成功返回true, 失败返回false
*
* @param string $server
* @param string $username
* @param string $password
* @param string $database
* @return bool
*/
public static function connect($server = 'localhost:3306', $username = 'root', $password = '', $database = '')
{
$timestamp = microtime(true);
SQL::$connection = mysqli_connect($server, $username, $password, $database);
DEBUG::put('Connected: ' . $username . '@' . $server . ' spent: ' . round((microtime(true) - $timestamp) * 1000, 3) . 'ms', 'MySQL');
$err = SQL::error();
if ($err['id'] > 0) {
DEBUG::put(' - Error: #' . $err['id'] . ' ' . $err['error'], 'MySQL');
}
return SQL::$connection;
}
示例5: build
/**
* build one table
*
* Accept following variants:
* - csv - to provide a downloadable csv page
* - json - to provide all values in one column
* - inline - to render tables within articles
* - simple - the legacy fixed table
* - sortable - click on column to sort the row
*
* @param the id of the table to build
* @param string the variant to provide - default is 'simple'
* @return a displayable string
*/
public static function build($id, $variant = 'simple')
{
global $context;
// split parameters
$attributes = preg_split("/\\s*,\\s*/", $id, 3);
$id = $attributes[0];
// get the table object
if (!($table = Tables::get($id))) {
return NULL;
}
// do the SELECT statement
if (!($rows = SQL::query($table['query']))) {
Logger::error(sprintf(i18n::s('Error in table query %s'), $id) . BR . htmlspecialchars($table['query']) . BR . SQL::error());
return NULL;
}
// build the resulting string
$text = '';
switch ($variant) {
// produce a table readable into MS-Excel
case 'csv':
// comma separated values
$separator = ",";
// one row for the title
if ($table['title']) {
$label = preg_replace('/\\s/', ' ', $table['title']);
// encode to ASCII
$label = utf8::to_ascii($label, PRINTABLE_SAFE_ALPHABET);
// escape quotes to preserve them in the data
$label = str_replace('"', '""', $label);
$text .= '"' . $label . '"';
$text .= "\n";
}
// one row for header fields
$index = 0;
while ($field = SQL::fetch_field($rows)) {
if ($index++) {
$text .= $separator;
}
$label = trim(preg_replace('/\\s/', ' ', ucfirst($field->name)));
// encode
$label = utf8::to_ascii($label, PRINTABLE_SAFE_ALPHABET);
// escape quotes to preserve them in the data
$label = str_replace('"', '""', $label);
$text .= '"' . $label . '"';
}
$text .= "\n";
// process every table row
$row_index = 0;
while ($row = SQL::fetch($rows)) {
// one cell at a time
$index = 0;
foreach ($row as $name => $value) {
// glue cells
if ($index++) {
$text .= $separator;
}
// remove HTML tags
$value = strip_tags(str_replace('</', ' </', str_replace(BR, ' / ', $value)));
// clean spaces
$label = trim(preg_replace('/\\s+/', ' ', $value));
// encode
$label = utf8::to_ascii($label, PRINTABLE_SAFE_ALPHABET);
// escape quotes to preserve them in the data
$label = str_replace('"', '""', $label);
// make a link if this is a reference
if ($index == 1 && $table['with_zoom'] == 'Y') {
$label = $context['url_to_home'] . $context['url_to_root'] . $label;
}
// quote data
$text .= '"' . $label . '"';
}
// new line
$text .= "\n";
}
return $text;
// a JSON set of values
// a JSON set of values
case 'json':
// get header labels
$labels = array();
while ($field = SQL::fetch_field($rows)) {
$labels[] = trim(preg_replace('/[^\\w]+/', '', ucfirst($field->name)));
}
// all items
$data = array();
$data['items'] = array();
//.........这里部分代码省略.........
示例6: update_jc_ticket_sp
/**
* 更新moreinfo
* @param unknown_type $id
* @param unknown_type $play_method
* @param unknown_type $codes
* @param unknown_type $ticket_type
*/
public function update_jc_ticket_sp($id, $play_method, $codes, $ticket_type = 1)
{
require_once WEBROOT . 'cron_script/SQL.php';
$sql_obj = new SQL();
$return = array();
$code_a = explode(';', $codes);
$code = $code_a[0];
$match_detail = explode('/', $code);
for ($i = 0; $i < count($match_detail); $i++) {
$match_info = explode('|', $match_detail[$i]);
$match_id = $match_info[0];
preg_match_all("/\\[(.*)\\]/", $match_info[1], $match_result, PREG_SET_ORDER);
$match_results = $match_result[0][1];
$match_results_a = explode(',', $match_results);
$match_result_sp = array();
$select_match_query = 'select comb,goalline from match_datas where ticket_type="' . $ticket_type . '" and play_type="' . $play_method . '" and match_id="' . $match_id . '" limit 1';
$sql_obj->query($select_match_query);
$match_data = $sql_obj->fetch_array();
$sp = $match_data['comb'];
$goalline = $match_data['goalline'];
//var_dump($sp);
$play_config = array();
if ($ticket_type == 1) {
switch ($play_method) {
case 1:
$play_config = array('3' => 'H', '1' => 'D', '0' => 'A');
break;
case 2:
$play_config = array('0' => '0', '1' => '1', '2' => '2', '3' => '3', '4' => '4', '5' => '5', '6' => '6', '7' => '7');
break;
case 3:
$play_config = array('负其它' => '-1:-A', '胜其它' => '-1:-H', '平其它' => '-1:-D', '0:0' => '00:00', '0:1' => '00:01', '0:2' => '00:02', '0:3' => '00:03', '0:4' => '00:04', '0:5' => '00:05', '1:0' => '01:00', '1:1' => '01:01', '1:2' => '01:02', '1:3' => '01:03', '1:4' => '01:04', '1:5' => '01:05', '2:0' => '02:00', '2:1' => '02:01', '2:2' => '02:02', '2:3' => '02:03', '2:4' => '02:04', '2:5' => '02:05', '3:0' => '03:00', '3:1' => '03:01', '3:2' => '03:02', '3:3' => '03:03', '4:0' => '04:00', '4:1' => '04:01', '4:2' => '04:02', '5:0' => '05:00', '5:1' => '05:01', '5:2' => '05:02');
break;
case 4:
$play_config = array('0-0' => 'cc', '0-1' => 'cb', '0-3' => 'ca', '1-0' => 'bc', '1-1' => 'bb', '1-3' => 'ba', '3-0' => 'ac', '3-1' => 'ab', '3-3' => 'aa');
break;
default:
break;
}
}
if ($ticket_type == 6) {
switch ($play_method) {
case 1:
$play_config = array('2' => 'H', '1' => 'D');
break;
case 2:
$play_config = array('2' => 'H', '1' => 'D');
break;
case 3:
$play_config = array('01' => 'u4e3bu80dc1-5', '02' => 'u4e3bu80dc6-10', '03' => 'u4e3bu80dc11-15', '04' => 'u4e3bu80dc16-20', '05' => 'u4e3bu80dc21-25', '06' => 'u4e3bu80dc26+', '11' => 'u5ba2u80dc1-5', '12' => 'u5ba2u80dc6-10', '13' => 'u5ba2u80dc11-15', '14' => 'u5ba2u80dc16-20', '15' => 'u5ba2u80dc21-25', '16' => 'u5ba2u80dc26+');
break;
case 4:
$play_config = array('1' => 'H', '2' => 'D');
break;
default:
break;
}
}
//$sp = '{"cc":{"c":"cc","v":"4.30","s":"1","d":"2011-09-06","t":"05:59:00"},"cb":{"c":"cb","v":"15.00","s":"1","d":"2011-09-06","t":"05:59:00"},"ca":{"c":"ca","v":"28.00","s":"1","d":"2011-09-06","t":"05:59:00"},"bc":{"c":"bc","v":"6.50","s":"1","d":"2011-09-06","t":"05:59:00"},"bb":{"c":"bb","v":"4.50","s":"1","d":"2011-09-06","t":"05:59:00"},"ba":{"c":"ba","v":"5.40","s":"1","d":"2011-09-06","t":"05:59:00"},"ac":{"c":"ac","v":"34.00","s":"1","d":"2011-09-06","t":"05:59:00"},"ab":{"c":"ab","v":"15.00","s":"1","d":"2011-09-06","t":"05:59:00"},"aa":{"c":"aa","v":"3.85","s":"1","d":"2011-09-06","t":"05:59:00"}}';
$sp = json_decode($sp);
$result_sp = array();
foreach ($sp as $key => $val) {
if (isset($val->c)) {
$result_sp[$val->c] = $val->v;
} else {
$result_sp[] = $val->v;
}
}
//var_dump($result_sp);
for ($j = 0; $j < count($match_results_a); $j++) {
$key = $play_config[$match_results_a[$j]];
if (array_key_exists($key, $result_sp)) {
$match_result_sp[] = $result_sp[$key];
}
}
$match_result_sp = implode(',', $match_result_sp);
//$return[] = $match_id.':'.$match_result_sp;
if ($ticket_type == 6 && ($play_method == 2 || $play_method == 4)) {
if ($play_method == 2 && $goalline > 0) {
$goalline = '+' . $goalline;
}
$return[] = $match_id . '(' . $goalline . '):' . $match_result_sp;
} else {
$return[] = $match_id . ':' . $match_result_sp;
}
//var_dump($return);
//echo $i;
}
$return = implode('|', $return);
//var_dump($return);
$sql_obj->query('update ticket_nums set moreinfo="' . $return . '" where id="' . $id . '"');
if (!$sql_obj->error()) {
return true;
//.........这里部分代码省略.........
示例7: post
/**
* post a new server or an updated server
*
* @see servers/edit.php
* @see servers/populate.php
*
* @param array an array of fields
* @return string either a null string, or some text describing an error to be inserted into the html response
**/
public static function post(&$fields)
{
global $context;
// no title
if (!$fields['title']) {
return i18n::s('No title has been provided.');
}
// clear the cache for servers
Cache::clear('servers');
if (isset($fields['id'])) {
Cache::clear('server:' . $fields['id']);
}
// protect from hackers
if (isset($fields['main_url'])) {
$fields['main_url'] = encode_link($fields['main_url']);
}
if (isset($fields['feed_url'])) {
$fields['feed_url'] = encode_link($fields['feed_url']);
}
if (isset($fields['ping_url'])) {
$fields['ping_url'] = encode_link($fields['ping_url']);
}
if (isset($fields['search_url'])) {
$fields['search_url'] = encode_link($fields['search_url']);
}
if (isset($fields['monitor_url'])) {
$fields['monitor_url'] = encode_link($fields['monitor_url']);
}
// make a host name
if (!isset($fields['host_name'])) {
$fields['host_name'] = '';
}
if (!$fields['host_name']) {
if (($parts = parse_url($fields['main_url'])) && isset($parts['host'])) {
$fields['host_name'] = $parts['host'];
}
}
if (!$fields['host_name']) {
if (($parts = parse_url($fields['feed_url'])) && isset($parts['host'])) {
$fields['host_name'] = $parts['host'];
}
}
if (!$fields['host_name']) {
if (($parts = parse_url($fields['ping_url'])) && isset($parts['host'])) {
$fields['host_name'] = $parts['host'];
}
}
if (!$fields['host_name']) {
if (($parts = parse_url($fields['monitor_url'])) && isset($parts['host'])) {
$fields['host_name'] = $parts['host'];
}
}
if (!$fields['host_name']) {
if (($parts = parse_url($fields['search_url'])) && isset($parts['host'])) {
$fields['host_name'] = $parts['host'];
}
}
// set default values
if (!isset($fields['active']) || !$fields['active']) {
$fields['active'] = 'Y';
}
if (!isset($fields['process_ping']) || $fields['process_ping'] != 'Y') {
$fields['process_ping'] = 'N';
}
if (!isset($fields['process_monitor']) || $fields['process_monitor'] != 'Y') {
$fields['process_monitor'] = 'N';
}
if (!isset($fields['process_search']) || $fields['process_search'] != 'Y') {
$fields['process_search'] = 'N';
}
// set default values for this editor
Surfer::check_default_editor($fields);
// update the existing record
if (isset($fields['id'])) {
// id cannot be empty
if (!isset($fields['id']) || !is_numeric($fields['id'])) {
return i18n::s('No item has the provided id.');
}
// update the existing record
$query = "UPDATE " . SQL::table_name('servers') . " SET " . "title='" . SQL::escape($fields['title']) . "', " . "description='" . SQL::escape($fields['description']) . "', " . "main_url='" . SQL::escape($fields['main_url']) . "', " . "anchor='" . SQL::escape(isset($fields['anchor']) ? $fields['anchor'] : '') . "', " . "submit_feed='" . SQL::escape($fields['submit_feed'] == 'Y' ? 'Y' : 'N') . "', " . "feed_url='" . SQL::escape($fields['feed_url']) . "', " . "submit_ping='" . SQL::escape($fields['submit_ping'] == 'Y' ? 'Y' : 'N') . "', " . "ping_url='" . SQL::escape($fields['ping_url']) . "', " . "process_ping='" . SQL::escape($fields['process_ping'] == 'Y' ? 'Y' : 'N') . "', " . "submit_monitor='" . SQL::escape($fields['submit_monitor'] == 'Y' ? 'Y' : 'N') . "', " . "monitor_url='" . SQL::escape($fields['monitor_url']) . "', " . "process_monitor='" . SQL::escape($fields['process_monitor'] == 'Y' ? 'Y' : 'N') . "', " . "submit_search='" . SQL::escape($fields['submit_search'] == 'Y' ? 'Y' : 'N') . "', " . "search_url='" . SQL::escape($fields['search_url']) . "', " . "process_search='" . SQL::escape($fields['process_search'] == 'Y' ? 'Y' : 'N') . "'," . "host_name='" . SQL::escape($fields['host_name']) . "'," . "active='" . SQL::escape($fields['active']) . "'";
// maybe a silent update
if (!isset($fields['silent']) || $fields['silent'] != 'Y') {
$query .= ", " . "edit_name='" . SQL::escape($fields['edit_name']) . "', " . "edit_id=" . SQL::escape($fields['edit_id']) . ", " . "edit_address='" . SQL::escape($fields['edit_address']) . "', " . "edit_date='" . SQL::escape($fields['edit_date']) . "'";
}
$query .= " WHERE id = " . SQL::escape($fields['id']);
if (SQL::query($query) === FALSE) {
return $query . BR . SQL::error();
}
// insert a new record
} else {
// always remember the date
//.........这里部分代码省略.........
示例8: do_run_patch
function do_run_patch()
{
global $output, $lang_run_patch, $world_db, $realm_db, $characters_db, $mmfpm_db;
if (empty($_POST['query']) || empty($_POST['use_db'])) {
redirect('run_patch.php?error=1');
}
$sql = new SQL();
$sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
$use_db = $sql->quote_smart($_POST['use_db']);
$query = $_POST['query'];
if ($use_db == $realm_db['name']) {
$sql->db($realm_db['name']);
} elseif ($use_db == $mmfpm_db['name']) {
$sql->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']);
} else {
foreach ($world_db as $db) {
if ($use_db == $db['name']) {
$sql->connect($db['addr'], $db['user'], $db['pass'], $db['name']);
}
}
foreach ($characters_db as $db) {
if ($use_db == $db['name']) {
$sql->connect($db['addr'], $db['user'], $db['pass'], $db['name']);
}
}
}
unset($use_db);
$new_queries = array();
$line = 0;
$queries = explode("\n", $query);
unset($query);
$n_queries = count($queries);
for ($i = 0; $i < $n_queries; ++$i) {
$queries[$i] = trim($queries[$i]);
if (0 === strpos($queries[$i], '#') || 0 === strpos($queries[$i], '--')) {
++$line;
} else {
array_push($new_queries, $queries[$i]);
}
}
unset($n_queries);
$qr = split(";\n", implode("\n", $new_queries));
unset($new_queries);
$good = 0;
$bad = 0;
foreach ($qr as $qry) {
++$line;
if (trim($qry)) {
$sql->query(trim($qry)) ? ++$good : ++$bad;
}
if ($bad) {
$err = ereg_replace('\\n', '', $sql->error());
$err = ereg_replace('\\r\\n$', '', $err);
$err = ereg_replace('\\r$', '', $err);
error($lang_run_patch['err_in_line'] . ': ' . $line . ' <br />' . $err);
exit;
}
}
unset($qry);
unset($qr);
unset($line);
unset($bad);
if ($queries) {
redirect('run_patch.php?error=2&tot=' . $good . '');
} else {
redirect('run_patch.php?error=3');
}
}
示例9: setup_table
/**
* Create or alter the structure of one table
*
* @param string the name of the table to setup
* @param array of $field_name => $field_declaration
* @param array of $index_name => $index_declaration
* @param array of SQL statements to be executed
* @return a text string to print
*/
public static function setup_table($table, $fields, $indexes, $statements = NULL)
{
global $context;
// sanity check
if (!$table) {
return '';
}
// if the table does not exist
if (!SQL::has_table($table)) {
// create it
$query = "CREATE TABLE " . SQL::table_name($table) . " ( ";
$count = 0;
foreach ($fields as $field => $definition) {
if ($count++) {
$query .= ", ";
}
$query .= '`' . $field . '` ' . $definition;
}
foreach ($indexes as $index => $definition) {
if ($count++) {
$query .= ", ";
}
$query .= $index . ' ' . $definition;
}
$query .= " ) ENGINE MyISAM";
// else if the table exists
} else {
// check its structure
$query = "ALTER TABLE " . SQL::table_name($table) . " ";
// analyse table structure
$query2 = "DESCRIBE " . SQL::table_name($table);
if (!($result = SQL::query($query2))) {
return '<p>' . Logger::error_pop() . "</p>\n";
}
// build the list of fields
while ($row = SQL::fetch($result)) {
$actual[] = $row['Field'];
}
// check all fields
$count = 0;
foreach ($fields as $field => $definition) {
if ($count++) {
$query .= ", ";
}
if (in_array($field, $actual)) {
$query .= "MODIFY";
} else {
$query .= "ADD";
}
$query .= ' `' . $field . '` ' . $definition;
}
// drop the primary index
$query .= ", DROP PRIMARY KEY";
// list existing indexes
$query2 = "SHOW INDEX FROM " . SQL::table_name($table);
if (!($result = SQL::query($query2))) {
return '<p>' . Logger::error_pop() . "</p>\n";
}
// drop other indexes
while ($row = SQL::fetch($result)) {
if ($row['Seq_in_index'] == 1 && $row['Key_name'] != 'PRIMARY') {
$query .= ', DROP INDEX ' . $row['Key_name'];
}
}
SQL::free($result);
// build new indexes
foreach ($indexes as $index => $definition) {
$query .= ", ADD " . $index . ' ' . $definition;
}
}
// execute the query
if (SQL::query($query) !== FALSE) {
// message to the user
$text = BR . i18n::s('The table') . " '" . $table . "'";
// it's a success
if (strpos($query, 'CREATE') === 0) {
$text .= ' ' . i18n::s('has been created');
} else {
$text .= ' ' . i18n::s('has been updated');
}
// ensure utf8 character set for this table
$query = "ALTER TABLE " . SQL::table_name($table) . " DEFAULT CHARACTER SET utf8";
if (SQL::query($query) !== FALSE) {
$text .= ' (utf8)';
}
// silently analyze table
$query = "ANALYZE TABLE " . SQL::table_name($table);
if (($result = SQL::query($query)) && ($row = SQL::fetch($result)) && $row['Msg_type'] == 'status') {
$text .= ' ' . i18n::s('and analyzed');
SQL::free($result);
}
//.........这里部分代码省略.........
示例10: while
while ($tokens = fgetcsv($handle, 2048, $delimiter, $enclosure)) {
// insert one record at a time
$query = "INSERT INTO " . SQL::escape($_REQUEST['table_name']) . " (" . $headers . ") VALUES (";
// use all provided tokens
$index = 0;
foreach ($tokens as $token) {
if ($index++) {
$query .= ', ';
}
$query .= "'" . SQL::escape($token) . "'";
}
// finalize the statement
$query .= ')';
// execute the statement
if (!SQL::query($query, TRUE) && SQL::errno()) {
$context['text'] .= '<p>' . $here . ': ' . $query . BR . SQL::error() . "</p>\n";
}
$queries++;
// ensure we have enough time
if (!($queries % 50)) {
Safe::set_time_limit(30);
}
}
// clear the cache
Cache::clear();
// report of script data
$time = round(get_micro_time() - $context['start_time'], 2);
$context['text'] .= '<p>' . sprintf(i18n::s('%d SQL statements have been processed in %.2f seconds.'), $queries, $time) . '</p>';
// remember this in log as well
Logger::remember('tables/import.php: Data has been imported into ' . $_REQUEST['table_name'], $queries . ' SQL statements have been processed in ' . $time . ' seconds.');
}
示例11: purge
/**
* delete all documentation pages
*/
public static function purge()
{
global $context;
// purge the old documentation
$query = "DELETE FROM " . SQL::table_name('phpdoc');
if (SQL::query($query, TRUE) === FALSE && SQL::errno()) {
echo $query . BR . SQL::error() . BR . "\n";
}
}