Executes the given SQL query and returns a multi-dimensional array
public QueryArray ( string $sql, integer $resultType = MYSQLI_BOTH ) : array | ||
$sql | string | The query string should not end with a semicolon |
$resultType | integer | (Optional) The type of array Values can be: MYSQLI_ASSOC, MYSQLI_NUM, MYSQLI_BOTH |
return | array | A multi-dimensional array containing all the data returned from the query or FALSE on all errors |
public function login($data) { $db = new MySQL(true, 'color64', 'localhost', 'color64', 'nu5Jc4JdtZK4RCHH'); $sql = 'SELECT * FROM `users` WHERE `id` = "' . $data['u'] . '" AND `password` = "' . MD5($data['p']) . '";'; $result = $db->QueryArray($sql); return $result; }
function dumpTableData($table) { $conn = new MySQL(true, DBNAME, DBHOST, DBUSER, DBPASS, "", true); $strTables = "SELECT * FROM `{$table}`"; $conn->QueryArray($strTables); $cntTables = $conn->RowCount(); if ($cntTables) { $num_fields = $conn->GetColumnCount($table); $this->output .= "\n\n"; $this->output .= "-- \n"; $this->output .= "-- Dumping data for table `{$table}` \n"; $this->output .= "-- \n\n"; $fields = ''; $field_type = array(); $i = 0; while ($i < $num_fields) { if (!$fields) { $fields = "`" . $conn->GetColumnName($i, $table) . "`"; } else { $fields .= ", " . "`" . $conn->GetColumnName($i, $table) . "`"; } // array_push($field_type, $conn->GetColumnDataType($i, $table)); $i++; } $conn->MoveFirst(); while (!$conn->EndOfSeek()) { $rsTable = $conn->RowArray(); $this->output .= "INSERT INTO `{$table}` ({$fields}) VALUES ("; for ($i = 0; $i < $num_fields; $i++) { if (is_null($rsTable[$i])) { $this->output .= "null"; } else { switch ($field_type[$i]) { case 'int': $this->output .= $rsTable[$i]; break; case 'string': case 'blob': default: $this->output .= "'" . addslashes($rsTable[$i]) . "'"; break; } } if ($i < $num_fields - 1) { $this->output .= ", "; } } $this->output .= ");\n"; } } $this->output .= "\n"; }
<?php ini_set("display_errors", 0); include "./classes/mysql.class.php"; if ($_GET['pid'] == "") { echo "enter pid in url"; exit; } else { $reqparam = $_GET['pid']; } $db = new MySQL(); $db->Open(); $sql1 = "SELECT p.name, DATE_FORMAT(p.age,'%d-%b-%Y') as dob, floor((((YEAR(NOW()) - YEAR(p.age)))*12 + (((MONTH(NOW()) - MONTH(p.age)))))/12) as age, place FROM person p where p.personid = '" . $reqparam . "'"; $row1 = $db->QueryArray($sql1); ?> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-type" content="text/html;charset=utf-8" /> <meta name="viewport" content="width=360, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0,target-densitydpi=device-dpi, user-scalable=no"> <meta http-equiv="cache-control" content="max-age=0" /> <meta http-equiv="cache-control" content="no-cache" /> <meta http-equiv="expires" content="0" /> <meta http-equiv="expires" content="Tue, 01 Jan 1980 1:00:00 GMT" /> <meta http-equiv="pragma" content="no-cache" /> <title><?php echo $row1[0][0]; ?> - Filmography</title> <!-- / END -->
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_METHOD'])) { header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS"); } if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS'])) { header("Access-Control-Allow-Headers: {$_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']}"); } } include "mysql.class.php"; $database = new MySQL(); global $database; if (!isset($_GET["parametro"])) { if ($database->Query("SELECT\n kiiconnect_setting.nombre,\n kiiconnect_setting.tag,\n kiiconnect_setting.descripcion,\n kiiconnect_setting.icono,\n kiiconnect_setting.link,\n kiiconnect_categoria.nombre AS categoria,\n kiiconnect_categoria.id AS id_categoria,\n kiiconnect_categoria.filecategoria,\n kiiconnect_categoria.filecategoria2,\n kiiconnect_categoria.icono AS categoria_icono\n FROM\n kiiconnect_setting\n INNER JOIN kiiconnect_categoria ON kiiconnect_setting.id_categoria = kiiconnect_categoria.id\n WHERE\n activo = 1\n ORDER BY\n orden ASC")) { echo $database->GetJSON(); } else { echo "<p>Query Failed</p>"; } } else { $temp = $database->QueryArray("SELECT\n kiiconnect_categoria.nombre AS categoria,\n kiiconnect_categoria.id AS id_categoria,\n kiiconnect_categoria.iconodev AS categoria_icono,\n kiiconnect_categoria.filecategoriadev AS filecategoria\n FROM\n kiiconnect_categoria\n WHERE\n activo = 1\n ORDER BY orden2", MYSQL_ASSOC); $temp2 = array(); foreach ($temp as $index => $categoria) { $categoria_id = $categoria['id_categoria']; // CONCAT('" . '<span style="font-weight:bold">' ." ', kiiconnect_setting.nombre, '</span>') AS nombre, $itemsCategoria = $database->QueryArray("SELECT\n kiiconnect_setting.nombre,\n kiiconnect_setting.tag,\n kiiconnect_setting.descripcion,\n kiiconnect_setting.icono,\n kiiconnect_setting.file,\n kiiconnect_setting.link\n FROM\n kiiconnect_setting\n WHERE\n activo = 1 AND id_categoria = {$categoria_id}\n ORDER BY\n orden ASC", MYSQL_ASSOC); if ($itemsCategoria != false) { $categoria['items'] = $itemsCategoria; $temp2[] = $categoria; } } $temp3 = json_encode($temp2); echo $temp3; }
/** * Return all rows for the given sql query. * * @param string $query the sql query to execute * @return array */ public function queryAll($query) { return $this->conn->QueryArray($query); }
//uid //prodcode //descr //model //category //url //price //trade //stocklevel //updated //onorder //webready //supplier //brand $sql = "SELECT * from import_hkstock"; $gethk = $db->QueryArray($sql); $new_id = $db->InsertRow("webstock", $insert); if (!$new_id) { //print_r ($insert); die('Unable to write record to DB.'); } unset($insert); echo '</table>'; //echo('<input type="submit" name="submit" value="submit" />'); echo '</form>'; echo '<br><h4>Finished, you may close this page, </h4></body>'; // If there were no errors... // Commit the transaction and save these records to the database if ($db->TransactionEnd()) { $db->Kill(); $db->Release();
<?php ini_set("display_errors", 0); include "./classes/mysql.class.php"; if ($_GET['y'] == "") { $reqparam = "2015"; } else { $reqparam = $_GET['y']; } $db = new MySQL(); $db->Open(); $sql7 = "SELECT count(*) as cnt FROM movie m;"; $row7 = $db->QueryArray($sql7); ?> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-type" content="text/html;charset=utf-8" /> <meta name="viewport" content="width=360, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0,target-densitydpi=device-dpi, user-scalable=no"> <meta http-equiv="cache-control" content="max-age=0" /> <meta http-equiv="cache-control" content="no-cache" /> <meta http-equiv="expires" content="0" /> <meta http-equiv="expires" content="Tue, 01 Jan 1980 1:00:00 GMT" /> <meta http-equiv="pragma" content="no-cache" /> <title><?php echo $reqparam; ?> - Year in Film</title> <link href="css/helper.css" media="screen" rel="stylesheet" type="text/css" /> <!-- Beginning of compulsory code below -->