/**
* This file is a part of MyWebSQL package
*
* @file: modules/query.php
* @author Samnan ur Rehman
* @copyright (c) 2008-2012 Samnan ur Rehman
* @web http://mywebsql.net
* @license http://mywebsql.net/license
*/
function processRequest(&$db)
{
// first time query will be from request, then we will get it from session (applying limit scenario)
$table_select = v($_REQUEST["id"]) == 'table' ? true : false;
if ($table_select) {
$query = selectFromTable($db);
} else {
$query = simpleQuery($db);
}
if (!$query) {
createErrorGrid($db, $query);
return;
}
loadDbVars($db);
if ($db->query($query)) {
if (!$db->hasResult()) {
$info = getCommandInfo($query);
if ($info['dbAltered']) {
Session::set('db', 'altered', true);
} else {
if ($info['setvar'] == TRUE) {
setDbVar($info['variable'], $info['value']);
}
}
createInfoGrid($db);
} else {
createResultGrid($db);
}
} else {
createErrorGrid($db, $query);
}
}
/**
* This file is a part of MyWebSQL package
*
* @file: modules/query.php
* @author Samnan ur Rehman
* @copyright (c) 2008-2014 Samnan ur Rehman
* @web http://mywebsql.net
* @license http://mywebsql.net/license
*/
function processRequest(&$db)
{
// first time query will be from request, then we will get it from session (applying limit scenario)
$table_select = v($_REQUEST["id"]) == 'table' ? true : false;
if ($table_select) {
$query = selectFromTable($db);
} else {
$query = simpleQuery($db);
}
if (!$query) {
createErrorGrid($db, $query);
return;
}
loadDbVars($db);
if ($db->query($query)) {
if (!$db->hasResult()) {
$info = getCommandInfo($query);
if ($info['dbAltered']) {
Session::set('db', 'altered', true);
} else {
if ($info['setvar'] == TRUE && is_scalar($info['variable']) && is_scalar($info['value'])) {
setDbVar($info['variable'], $info['value']);
}
}
createInfoGrid($db);
} else {
// if it is a data result set, show it as result grid, otherwise in simple grid layout
$query_type = getQueryType($query);
if ($query_type['can_limit']) {
createResultGrid($db);
} else {
createSimpleGrid($db, __('Query') . ': ' . $query);
}
}
} else {
createErrorGrid($db, $query);
}
}
if (isset($_POST['Name']) && isset($_POST['phoneNumber'])) {
require 'insert.php';
$status = insertIntoTable($_POST['Name'], $_POST['phoneNumber']);
$statusObj = json_encode($status);
?>
<script type="text/javascript">
alert(<?php
echo $statusObj;
?>
);
</script>
<?php
}
if (isset($_GET['ID'])) {
require 'select.php';
$result = selectFromTable($_GET['ID']);
if ($result == false) {
?>
<script type="text/javascript">
alert("no entry for id = <?php
echo $_GET['ID'];
?>
");
</script>
<?php
} else {
$decoded_result = json_decode($result);
?>
<script type="text/javascript">
var alertString = "id = <?php
echo $decoded_result->ID;
$m = 7;
break;
case 7:
$n = 8;
$m = 8;
break;
case 8:
$n = 9;
$m = 9;
break;
case 9:
$n = 10;
$m = 10;
break;
}
$e = selectFromTable($id);
$finalArray = array('N' => $n, 'M' => $m, 'E' => $e);
echo json_encode($finalArray);
}
if ($command == 'submit') {
$id = $_GET["graph_id"];
$matchArray = json_decode($_GET['solution']);
$e = selectEdges($id);
$diff = array();
for ($i = 0; $i < count($matchArray); $i++) {
if (!in_array($matchArray[$i], $e)) {
array_push($diff, $matchArray[$i]);
}
}
if (!empty($diff)) {
$finalArray = array('graph_id' => $id, 'new_best' => NULL, 'num_match' => 'DNE', 'match_score' => $diff);
die("ERROR: recordset_to_htmltable: missing arguments");
} else {
//Set the counter. This is used later to set the first row as headers.
$counter = 0;
$textOutput = "";
//Begin constructing the string which will contain the HTML code for the table. Each new line will be concatenated on to this variable
//Loop trough the recordset.
while ($row = mysql_fetch_array($recordSet)) {
//Extract the values and add them to the HTML.
for ($column = 0; $column < count($row) / 2; $column++) {
$textOutput .= $row[$column] . "\n";
}
//Increment counter
$counter += 1;
}
return $textOutput;
}
}
$dbConnection = connectDb('localhost', 'webapp', 'vmJ0@DE4sH6NKp4%HD%shF7BJWSIvU', 'content');
$resultsRecordSet = selectFromTable('content_table', 'string', $dbConnection);
if (!empty($resultsRecordSet)) {
echo recordsetToText($resultsRecordSet, $dbConnection);
} else {
echo "Failure!\n";
echo "<p>Unable to retrieve results:</p>\n";
echo "<p>Error Code:" . mysql_errno() . "</p>\n";
echo "<p>Error Message:" . mysql_error() . "</p>\n";
}
?>
