PHP PDO::Quote方法代码示例

 // ---------------
 // Add table index
 // ---------------
 $Output->Append("<table>\n");
 $Output->Append("<tr><th><strong>Table</strong></th><th><strong>Description</strong></th><th><strong>Doc Status</strong></th></tr>\n");
 $tables = $db->Query("SHOW TABLE STATUS")->fetchAll();
 $tables_simplified = array();
 foreach ($tables as $table) {
     $tables_simplified[] = $table["Name"];
     $Output->Append("<tr>");
     if (isset($table_doc[$schema][$table["Name"]])) {
         $Output->Append("<td>@subpage {$MakeRef($schema, $table["Name"])} \"{$table["Name"]}\" </td><td>{$table_doc[$schema][$table["Name"]]["brief"]}</td>");
     } else {
         $Output->Append("<td>@subpage {$MakeRef($schema, $table["Name"])} \"{$table["Name"]}\" </td><td></td>");
     }
     $cols_in_table = $db->Query("SELECT COLUMN_NAME FROM `information_schema`.`columns` WHERE `TABLE_SCHEMA` = '{$schema}' AND `TABLE_NAME` = {$db->Quote($table["Name"])}")->fetchAll(PDO::FETCH_NUM);
     $documented_cols = $db->Query("SELECT `column` FROM `documentation`.`column` WHERE `schema` = '{$schema}' AND `table` = {$db->Quote($table["Name"])}")->fetchAll(PDO::FETCH_NUM);
     $real_documented_cols = 0;
     $cols_in_table_simplified = array();
     foreach ($cols_in_table as $col) {
         $cols_in_table_simplified[] = $col[0];
     }
     foreach ($documented_cols as $col) {
         if (!in_array($col[0], $cols_in_table_simplified)) {
             print "WARNING: Column {$col[0]} is documented for table {$table["Name"]} but doesn't exist!\n";
         } else {
             ++$real_documented_cols;
         }
     }
     $pct = $real_documented_cols / count($cols_in_table) * 100;
     //if (ceil($pct) >= 100 && $real_documented_cols < count($cols_in_table))

     unlink($filename);
     die("{$prog}: internal error: no tables for bin: {$bin} (check case is correct)\n");
 }
 if ($export == "all") {
     $cmd = "{$bin_mysqldump} --skip-add-drop-table --default-character-set=utf8mb4 -u{$dbuser} -h {$hostname} {$database} {$string} >> {$filename}";
 } else {
     $cmd = "{$bin_mysqldump} --skip-add-drop-table --no-data --default-character-set=utf8mb4 -u{$dbuser} -h {$hostname} {$database} {$string} >> {$filename}";
 }
 system($cmd);
 /* Now append the dump with TCAT table information */
 $fh = fopen($filename, "a");
 fputs($fh, "\n");
 fputs($fh, "--\n");
 fputs($fh, "-- DMI-TCAT - Update TCAT tables\n");
 fputs($fh, "--\n");
 $sql = "INSERT INTO tcat_query_bins ( querybin, `type`, active, access ) values ( " . $dbh->Quote($bin) . ", " . $dbh->Quote($bintype) . ", 0, 0 );";
 fputs($fh, $sql . "\n");
 if ($bintype == 'track') {
     // Notice: We do not export information from the tcat_captured_phrases table here. Because we allow adding of phrasing and querybins to an existing tcat installation,
     //         the phrase IDs will change and it would not be safe to simply copy the data (phrase id <-> phrase text would no longer match)
     foreach ($phrases as $phrase) {
         $sql = "INSERT INTO tcat_query_phrases ( phrase ) values ( " . $dbh->Quote($phrase) . " );";
         fputs($fh, $sql . "\n");
     }
     foreach ($phrases as $phrase) {
         $starttime = $phrase_starttime[$phrase];
         $endtime = $phrase_endtime[$phrase];
         $sql = "INSERT INTO tcat_query_bins_phrases SET " . " starttime = '{$starttime}', " . " endtime = '{$endtime}', " . " phrase_id = ( select MIN(id) from tcat_query_phrases where phrase = " . $dbh->Quote($phrase) . " ), " . " querybin_id = ( select MAX(id) from tcat_query_bins );";
         fputs($fh, $sql . "\n");
     }
     // we could have just now inserted duplicate phrases in the database, the next two queries resolve that problem

        die("Empty bin name would dump the complete database. Exiting!\n");
    }
    $cmd = "{$bin_mysqldump} --default-character-set=utf8mb4 -u{$dbuser} -h {$hostname} {$database} {$string} > {$filename}";
    system($cmd);
} else {
    touch($filename);
}
/* Now append the dump with TCAT table information */
$fh = fopen($filename, "a");
fputs($fh, "\n");
fputs($fh, "--\n");
fputs($fh, "-- DMI-TCAT - Update TCAT tables\n");
fputs($fh, "--\n");
/* Lock TCAT tables */
fputs($fh, "LOCK TABLES `tcat_query_bins` WRITE, `tcat_query_phrases` WRITE, `tcat_query_bins_periods` WRITE, `tcat_query_users` WRITE, `tcat_query_bins_phrases` WRITE, `tcat_query_bins_users` WRITE;\n");
$sql = "INSERT INTO tcat_query_bins ( querybin, `type`, active, visible ) values ( " . $dbh->Quote($bin) . ", " . $dbh->Quote($bintype) . ", 0, 1 );";
fputs($fh, $sql . "\n");
if ($bintype == 'track') {
    $sql = "CREATE TEMPORARY TABLE temp_phrase_ids ( phrase_id bigint primary key, phrase varchar(512) );";
    fputs($fh, $sql . "\n");
    foreach ($phrases as $phrase) {
        $sql = "INSERT INTO tcat_query_phrases ( phrase ) values ( " . $dbh->Quote($phrase) . " );";
        fputs($fh, $sql . "\n");
        $sql = "INSERT INTO temp_phrase_ids ( phrase_id, phrase ) values ( LAST_INSERT_ID(), " . $dbh->Quote($phrase) . " );";
        fputs($fh, $sql . "\n");
    }
    foreach ($phrases as $phrase) {
        $starttime = $phrase_starttime[$phrase];
        $endtime = $phrase_endtime[$phrase];
        $sql = "INSERT INTO tcat_query_bins_phrases SET " . " starttime = '{$starttime}', " . " endtime = '{$endtime}', " . " phrase_id = ( select phrase_id from temp_phrase_ids where phrase = " . $dbh->Quote($phrase) . " ), " . " querybin_id = ( select MAX(id) from tcat_query_bins );";
        fputs($fh, $sql . "\n");

 /**
  * @param string $input
  * @return string
  */
 public function escape($input)
 {
     if (is_null($this->db)) {
         $this->connect_db();
     }
     return $this->db->Quote($input);
 }