PHP Database::quote_id Examples

Example #1

File: index.php Project: gorvelyfab/pla

         }
         $query .= "PRIMARY KEY (" . $compound_key . "), ";
     }
     $query = substr($query, 0, sizeof($query) - 3);
     $query .= ")";
     $result = $db->query($query);
     if ($result === false) {
         $error = true;
     }
     $completed = $lang['tbl'] . " '" . htmlencode($_POST['tablename']) . "' " . $lang['created'] . ".<br/><span style='font-size:11px;'>" . htmlencode($query) . "</span>";
     $backlinkParameters = "&amp;action=column_view&amp;table=" . urlencode($name);
     break;
     //- Empty table (=table_empty)
 //- Empty table (=table_empty)
 case "table_empty":
     $query = "DELETE FROM " . $db->quote_id($_POST['tablename']);
     $result = $db->query($query);
     if ($result === false) {
         $error = true;
     }
     $query = "VACUUM";
     $result = $db->query($query);
     if ($result === false) {
         $error = true;
     }
     $completed = $lang['tbl'] . " '" . htmlencode($_POST['tablename']) . "' " . $lang['emptied'] . ".<br/><span style='font-size:11px;'>" . htmlencode($query) . "</span>";
     $backlinkParameters = "&amp;action=row_view&amp;table=" . urlencode($name);
     break;
     //- Create view (=view_create)
 //- Create view (=view_create)
 case "view_create":

Example #2

File: phpliteadmin.php Project: rivalinx/php-file-host

             $compound_key .= ($compound_key == "" ? "" : ", ") . $db->quote($primary_key);
         }
         $query .= "PRIMARY KEY (" . $compound_key . "), ";
     }
     $query = substr($query, 0, sizeof($query) - 3);
     $query .= ")";
     $result = $db->query($query);
     if (!$result) {
         $error = true;
     }
     $completed = $lang['tbl'] . " '" . htmlencode($_POST['tablename']) . "' " . $lang['created'] . ".<br/><span style='font-size:11px;'>" . htmlencode($query) . "</span>";
     break;
     /////////////////////////////////////////////// empty table
 /////////////////////////////////////////////// empty table
 case "table_empty":
     $query = "DELETE FROM " . $db->quote_id($_POST['tablename']);
     $result = $db->query($query);
     if (!$result) {
         $error = true;
     }
     $query = "VACUUM";
     $result = $db->query($query);
     if (!$result) {
         $error = true;
     }
     $completed = $lang['tbl'] . " '" . htmlencode($_POST['tablename']) . "' " . $lang['emptied'] . ".<br/><span style='font-size:11px;'>" . htmlencode($query) . "</span>";
     break;
     /////////////////////////////////////////////// create view
 /////////////////////////////////////////////// create view
 case "view_create":
     $query = "CREATE VIEW " . $db->quote($_POST['viewname']) . " AS " . $_POST['select'];