//echo "<br>";
//Insert or update to DB
PDO_Execute("INSERT INTO users (name, age) VALUES (:name, :age)", array("name" => "apple", "age" => 150));
PDO_Execute("UPDATE users SET age = 200 WHERE name = 'apple'");
//Last Insert ID
//$id = PDO_LastInsertId();
//print_r($id);
?>
<?php
echo "<br> Using variables in statements ";
$name = "omt";
$tablename = "users";
$selectVar = "age";
$newAge = PDO_FetchOne("SELECT {$selectVar} FROM {$tablename} WHERE name = :name", array("name" => $name));
//Select one column from the row with some specific details know.
print_r("newAge " . $age);
echo "<br>";
?>
<html >
<head>
<script src="jquery-1.10.2.min.js"></script>
<script >
$(document).ready(function(){
$('.button').click(function(){
var clickBtnValue = $(this).val();
var ajaxurl = 'ajax.php',
data = {'action': clickBtnValue};
function table_pk($table)
{
// @pk
$table_columns = table_columns($table);
if (!$table_columns) {
return null;
}
$pk = "";
global $global_columns;
foreach ($global_columns[$table] as $column) {
if ($column["pk"]) {
if ($pk) {
$pk .= ":" . $column["name"];
} else {
$pk = $column["name"];
}
}
}
if ($pk) {
// Possible returns: "col1", "col1:col2", "col1:col2:col3"
return $pk;
}
global $db_driver;
if ("sqlite" == $db_driver) {
// Detect PK for:
// UNIQUE (nagroda, id_gracza)
// When there are multiple pks there is no info about it in PRAGMA table_info.pk,
// we need to get it from the SQL string that was used to create the table.
$sql = PDO_FetchOne("SELECT sql FROM sqlite_master WHERE type = 'view' OR type='table' AND name = :name ", array(":name" => $table));
if (preg_match("#UNIQUE\\s*\\(\\s*(\"?\\w+\"?(\\s*,\\s*\"?\\w+\"?)*)\\s*\\)#i", $sql, $match)) {
$cols = $match[1];
$cols = str_replace("\"", "", $cols);
$cols = preg_replace("#\\s+#", "", $cols);
$cols = str_replace(",", ":", $cols);
return $cols;
// "nagroda:id_gracza"
}
}
foreach ($table_columns as $col => $type) {
return $col;
}
}
}
//print "<table border=1>";
//print "<tr><td>Id</td></tr>";
//$result = $dbh->query('SELECT * FROM IDs');
$result = PDO_FetchAll('SELECT * FROM IDs order by Id');
$option = '';
//print count($result)." - ".print_r($result);
foreach ($result as $row) {
$temp = "<option value='" . $row['Id'] . "'>" . $row['Id'] . "</option>";
$option = $option . $temp;
}
//print "</table>";
}
//End SQLLite Section
$exists = "SELECT count(*) FROM IDs ";
$count = PDO_FetchOne($exists);
if ($count > 20) {
$count = 20;
}
$foot = "";
if ($count > 0) {
$foot = " <form action='SectionI.php' method='post'>";
$foot = $foot . "Next Section<input type='submit' value='Go'></form>\t";
$totals = "<form action='SectionI.php' method='post'><input type='hidden' value='X' name = 'hSectionNo'>Output file<input type = 'submit' value='submit'></form>";
//$foot = $foot.$totals;
}
$dbh = null;
?>
<select size=<?echo $count; ?> width="300">
<?php
echo $option;
//echo "post".$_POST[$id]."<br>";
//**************Are we trying to push data? if so, let's do it!
if ($_POST['id'] != '') {
$sql = "Delete from " . $QName . " Where Id = " . $id;
PDO_Execute($sql);
$sql = "INSERT INTO " . $QName . " (" . $QNameCols . ") Values (" . $id . $values . ")";
//echo $sql;
PDO_Execute($sql);
$sql = "Select Min(id) from Ids where id > " . $id;
//echo $sql;
$id = PDO_FetchOne($sql);
//print "post_Insert: ".$id;
if ($id == '') {
$sql = "Select Min(id) from Ids";
//echo $sql;
$id = PDO_FetchOne($sql);
}
//print $sql;
}
//******* End of push data attempt
}
//($formError>0)
}
//$idlist =
$result = PDO_FetchAll("SELECT * FROM Ids");
foreach ($result as $row) {
if ($id == $row['Id']) {
$idlist = $idlist . "<option value='" . $row['Id'] . "' selected>" . $row['Id'] . "</option>";
} else {
$idlist = $idlist . "<option value='" . $row['Id'] . "'>" . $row['Id'] . "</option>";
}
