function generate_insert_query($query) { preg_match("/FROM (.*?) /i", $query, $matches); $table = $matches[1]; preg_match("/WHERE (.*) LIMIT/i", $query, $matches); $where = $matches[1]; $query2 = "SELECT * FROM " . $table . " WHERE " . $where; $row = mysql::query_assoc($query2); foreach ($row as $key => $value) { $values[] = "{$key}=\"{$value}\""; } $values2 = implode(", ", $values); $insert = "INSERT INTO " . $table . " VALUES (" . $values2 . ")"; $insert2 = addslashes($insert); $query3 = "INSERT INTO undo set query=\"{$insert2}\""; // mysql::query_no_result($query3); echo "insert query: <br>{$insert}"; exit; }
<?php require 'mysql.php'; //Se instancia la clase en la variable $main $main = new mysql(); $poll = $_POST["poll"]; $consult = "SELECT contenido FROM encuestas WHERE poll = '{$poll}'"; $res = $main->query_assoc($consult); echo json_encode($res);
<?php require 'mysql.php'; $main = new mysql(); $consult = "SELECT DISTINCT C.poll FROM encuestas C"; echo json_encode($main->query_assoc($consult));
<?php require '../mysql.php'; $main = new mysql(); $con = "SELECT COUNT(*) FROM colonias"; $count = $main->query_assoc($con); $Npags = $count[0]["COUNT(*)"] / 10; $Npags = round($Npags); $Npags = $Npags + 1; $Npags = array('Npags' => $Npags); $num = $_POST["num"]; if ($num != 0) { $num--; } $num = $num * 10; $consult = "SELECT * FROM colonias LIMIT {$num}, 10"; $res = $main->query_assoc($consult); array_push($res, $Npags); echo json_encode($res); //echo json_encode($count);