PHP submitquery Examples

Example #1

submitquery("1", "INSERT Telekatalog_TitelData", $sqlStmt);
// --------------------------------------------
$sqlStmt = "INSERT INTO Telekatalog_InstitutionTyp " . "  (,,) " . "VALUES " . "('','','')," . "('','','')," . "('','','')," . "('','','')";
submitquery("1", "INSERT Telekatalog_InstitutionTyp", $sqlStmt);
// ============================================
$sqlStmt = "CREATE TABLE IF NOT EXISTS Telekatalog_TitelData ( " . "  Telekatalog_id SMALLINT NOT NULL REFERENCES Telekatalog (Telekatalog_id), " . "  Titel_id VARCHAR(30) NOT NULL REFERENCES Titel (Titel_id), " . "  PRIMARY KEY (Telekatalog_id,Titel_id) " . ")";
submitquery("1", "CREATE Telekatalog_TitelData", $sqlStmt);
// ============================================
$sqlStmt = "ALTER IGNORE TABLE Telekatalog " . "  CHANGE COLUMN Grupp_id " . "  Grupp_id CHAR(10) NULL";
submitquery("1", "ALTER CHANGE Telekatalog", $sqlStmt);
// --------------------------------------------
$sqlStmt = "ALTER IGNORE TABLE Telekatalog_Titel " . "  ADD COLUMN " . "  Prefekt TINYINT DEFAULT 0  " . "  AFTER BeskrivningENG";
submitquery("1", "ALTER ADD Telekatalog_Titel", $sqlStmt);
// --------------------------------------------
$sqlStmt = "ALTER IGNORE TABLE kalendarium_details " . "  DROP COLUMN Kolumn";
submitquery("1", "ALTER DROP kalendarium_details", $sqlStmt);
// ============================================
$sqlStmt = "SELECT Telekatalog_id,Titel_id FROM Telekatalog WHERE Titel_id != ''";
$result = safe_mysql_query($sqlStmt, "FIX-2");
$antal_rader = @mysql_num_rows($result);
if ($antal_rader > 0) {
    for ($rad = 0; $rad < $antal_rader; $rad++) {
        $res = @mysql_fetch_assoc($result);
        $val[] = "(" . $res["Telekatalog_id"] . "," . $res["Titel_id"] . ")<br>";
    }
    // end for
}
// end if
@mysql_free_result($result);
// ============================================
@mysql_close();

Example #2

File: data.php Project: herndotd/devsec

<?php

include "db_functions.php";
$strSQL = "select \twall.message as post,\n\t\t\t\t\twall.userid walluid,\n\t\t\t\t\tusers.username as username,\n\t\t\t\t\tusers.id as usersuid\n\t\t\tfrom wall \n\t\t\tinner join users \n\t\t\t\twhere wall.userid=users.id";
$results = submitquery($strSQL);
$i = 0;
$printme = "[";
while ($row = mysql_fetch_assoc($results)) {
    if ($i > 0) {
        $printme = $printme . ",";
    }
    $printme = $printme . "{\"user\":\"" . $row['username'] . "\", \"post\": \"" . $row['post'] . "\"}";
    $i++;
}
$printme = $printme . "]";
echo $printme;