function SignIn()
{
/*$val = $_POST['passwordsignin']; //"rasmuslerdorf";
$hash=password_hash($val, PASSWORD_DEFAULT);
echo "HASH " . $hash;
if (password_verify($val, $hash)) {
echo 'Password is valid!';
} else {
echo 'Invalid password.';
}*/
$enteredpassword = $_POST['passwordsignin'];
$enteremail = $_POST['emailsignin'];
$result = PDO_FetchAll("SELECT password FROM user WHERE email = :email", array("email" => $enteremail));
$hash = '';
foreach ($result as $res) {
foreach ($res as $key => $val) {
//echo $val;
$hash = $val;
}
}
if (password_verify($enteredpassword, $hash)) {
echo "<br>" . $enteredpassword . ' Password is valid!';
$_SESSION['user'] = 1;
$_SESSION['email'] = $enteremail;
header('Location:index.php');
} else {
// password match failed
$_SESSION['error'] = 1;
$_SESSION['user'] = 0;
//echo "Invalid Password";
header('Location: login.php');
}
}
function showOrderdItems()
{
$Ordered_Items = PDO_FetchAll("SELECT * FROM neworder");
//print_r($All);
echo "<table id='order' class='table table-striped table-hover'>\r\n\t\t <thead>\r\n\t\t\t<tr>\r\n\t\t\t <th>id</th>\r\n\t\t\t <th>Order type</th>\r\n\t\t\t <th>Item Name</th>\r\n\t\t\t <th>TransId</th>\r\n\t\t\t <th>Price</th>\r\n\t\t\t \r\n\t\t\t</tr>\r\n\t\t </thead>";
echo "<tbody>";
$completerow = "";
$i = 1;
foreach ($Ordered_Items as $v) {
foreach ($v as $k => $var) {
$completerow = $completerow . "<td>" . $var . "</td>";
}
echo "<tr id=" . $i . " onClick='return alert({$completerow})'>" . $completerow . "</tr>";
$completerow = "";
$i++;
}
echo "</tbody> </table>";
}
function sendUserList()
{
$result = PDO_FetchAll("SELECT email , fname FROM user");
//var_dump($result);
$email = "";
$fname = "";
$str = "";
foreach ($result as $resultObject) {
$str = "<tr>";
foreach ($resultObject as $key => $val) {
if ($key == "email") {
//echo "Email :" .$val;
$email = "<td contenteditable=false >" . $val . "</td>";
} elseif ($key == "fname") {
//echo "fname :" . $val;
$fname = "<td contenteditable=true >" . $val . "</td >";
}
}
$str = $str . $fname . $email . "</tr> <br>";
echo $str;
}
}
/*printer_set_option($handle, PRINTER_MODE, "text");
printer_write($handle, "TEXT To print");
printer_close($handle);
*/
}
?>
<?php
//Using PDO lib PHP desktop has provided.
include "./pdo.php";
$db_file = "./restaurant.sqlite3";
PDO_Connect("sqlite:{$db_file}");
//Fetch data from DB
$All = PDO_FetchAll("SELECT * FROM users WHERE age < :age", array("age" => 20000));
//Array ( [0] => Array ( [name] => dasd [age] => 2000 ) )
// Selects all elements till 20000.
//print_r($All);
//echo "<br>";
$age = PDO_FetchOne("SELECT age FROM users WHERE name = :name", array("name" => "omt"));
//Select one column from the row with some specific details know.
//print_r($age);
//echo "<br>";
$rowdetails = PDO_FetchRow("SELECT * FROM users WHERE name = :name", array("name" => "omt"));
// Select complete row from a table
//print_r($rowdetails);
//echo "<br>";
$association = PDO_FetchAssoc("SELECT name, age FROM users");
//print_r($association);
//echo "<br>";
//$list = substr($list,0,strlen($list)-1);
while (strpos($list, ",") > 0) {
$id = substr($list, 0, strpos($list, ","));
$list = substr($list, strpos($list, ",") + 1);
//print $id;
$sql = "INSERT INTO IDs (Id) Values (" . $id . ")";
PDO_Execute($sql);
//print $sql;
}
} catch (PDOException $e) {
echo "InsertError: " . $e->getMessage() . "<br>";
}
//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 = "";
function computeAndDisplayEachDayTotalSalesAsGraph($dateFrom, $dateTo)
{
$All = PDO_FetchAll("SELECT * FROM transactions WHERE OrderDate BETWEEN :Date AND :Date2 ", array("Date" => $dateFrom, "Date2" => $dateTo));
// print_r($All);
$index = 0;
$stmt = "[";
// For each element in $all, take one as $v
foreach ($All as $v) {
// for each in array $v , take $k as key and $var as value.
foreach ($v as $k => $var) {
// print_r($v);
// echo "Count " . count($v);
if ($k == "OrderValue") {
// echo $var;
// echo $var . "<br>";
$stmt = $stmt . $var . ",";
}
}
}
$stmt = substr_replace($stmt, "", -1);
// $stmt=trim($stmt, ",");
$stmt = $stmt . "]";
echo $stmt;
// Compute for each date, the order value
// now, put these values in the array for Two selected dates.
// 1st day , 2nd day, 3rd day ..
// [100 , 1222, 33344, ]
}
PDO_Connect("sqlite:{$db_file}");
print "PDO_Connect(): successsfully connected<br>";
print "The database file: <b>{$db_file}</b><br>";
$queries = <<<HTML
CREATE TABLE test (id int PRIMARY KEY, name varchar(50));
INSERT INTO test VALUES (1, "Amelia");
INSERT INTO test VALUES (2, "Beatrice");
HTML;
print "<h2>Create table and insert exampe data</h2>";
print "<pre style='background:#ddd'>";
$queries = explode(";", $queries);
foreach ($queries as $query) {
$query = trim($query);
if (!$query) {
continue;
}
$stmt = @PDO_Execute($query);
if (!$stmt || $stmt && $stmt->errorCode() != 0) {
$error = PDO_ErrorInfo();
print_r($error[2]);
break;
}
print $query . "\n";
}
print "</pre>";
print "<h2>Fetch data</h2>";
print "PDO_FetchAll('SELECT * FROM test')";
print "<pre style='background:#ddd'>";
$data = PDO_FetchAll("SELECT * FROM test");
print_r($data);
print "</pre>";
function getBeverages()
{
//Data base beverages are calling from here
$All = PDO_FetchAll("SELECT * FROM beverages ");
echo "<table class='table table-striped table-hover'>\r\n\t\t <thead>\r\n\t\t\t<tr>\r\n\t\t\t <th>#</th>\r\n\t\t\t <th>Item Name</th>\r\n\t\t\t <th>Price</th>\r\n\t\t\t <th>QUANTITY</th>\r\n\t\t\t</tr>\r\n\t\t </thead>";
echo "<tbody>";
$Iprice = "";
$Iname = "";
$desc = "";
$completerow = "";
foreach ($All as $v) {
//echo "Current value of \$All: $v.\n";
foreach ($v as $k => $var) {
//echo "$var";
$completerow = $completerow . "<td>" . $var . "</td>";
if ($var == '$name') {
$Iname = $name;
} else {
if ($var == '$price') {
$Iprice = $price;
} else {
if ($var == '$veg') {
$desc = "Vegetarian";
}
}
}
}
echo "<tr onClick='return AddtoCart({$Iname},{$desc},{$Iprice})'>" . $completerow . "</tr>";
$Iprice = "";
$Iname = "";
$desc = "";
$completerow = "";
}
echo "</tbody> </table>";
}
function getBeverages()
{
$allStarters = PDO_FetchAll("SELECT * FROM beverages");
$ItemPrice = "";
$ItemName = "";
$desc = "";
$completerow = "";
$i = 1;
$str = "<ul class=list-group >";
echo "<table id='fetchedTable' class='table table-hover' > <tbody>";
foreach ($allStarters as $eachItem) {
foreach ($eachItem as $k => $var) {
if (!strpos($var, 'yes') || !strpos($var, 'no')) {
$completerow = $completerow . "<td>" . $var . "</td>";
}
}
//echo "<li class=list-group-item id=".$i ." onClick='return handleAddToCart(this.id)'>". $completerow . "</li>";
echo "<tr class=list-group-item id=" . $i . " onClick='return handleAddToCart(this.id)'> " . $completerow . "</tr>";
$completerow = "";
$i++;
}
echo "</tbody> </table>";
}
function table_structure($table, $type = "table")
{
// @dump
// @export
// @structure
global $db_driver;
if ('mysql' == $db_driver) {
if ("table" == $type) {
$query = "SHOW CREATE TABLE `{$table}`";
$row = db_row_num($query);
echo $row[1] . ';';
echo "\n\n";
} else {
if ("view" == $type) {
$query = "SHOW CREATE VIEW `{$table}`";
$row = db_row_num($query);
echo $row[1] . ';';
echo "\n\n";
} else {
assert(0);
}
}
} else {
if ('pgsql' == $db_driver) {
return;
} else {
if ("sqlite" == $db_driver) {
if ("table" == $type) {
$sql = PDO_FetchOne("SELECT sql FROM sqlite_master WHERE name = :name AND type='table' ", array(":name" => $table));
$sql = str_replace("\r\n", "\n", $sql);
// editplus invalid line endings, strange
echo "{$sql};\n";
} else {
if ("view" == $type) {
$sql = PDO_FetchOne("SELECT sql FROM sqlite_master WHERE name = :name AND type='view' ", array(":name" => $table));
$sql = str_replace("\r\n", "\n", $sql);
// editplus invalid line endings, strange
echo "{$sql};\n";
} else {
assert(0);
}
}
unset($sql);
if ("table" == $type) {
$indexes = PDO_FetchAll("SELECT * FROM sqlite_master WHERE tbl_name = :tbl_name AND type='index' ", array(":tbl_name" => $table));
foreach ($indexes as $index) {
if ($index["sql"]) {
// autoindexes have column "sql" empty
echo "\n-- INDEX: \"{$index['name']}\"\n\n";
echo "{$index['sql']};\n";
}
}
}
echo "\n";
}
}
}
}
<?php
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
include "./pdo.php";
$db_file = "./restaurant.sqlite3";
PDO_Connect("sqlite:{$db_file}");
$result = PDO_FetchAll("SELECT servicetax, vat FROM tax ORDER BY date DESC LIMIT 1");
$serviceTax = 0;
$vat = 0;
foreach ($result as $res) {
foreach ($res as $key => $val) {
// echo "vav" . $val . "<br>";
if ($key == "servicetax") {
$serviceTax = $val;
}
if ($key == "vat") {
$vat = $val;
}
}
}
echo " { " . '"servicetax":' . "{$serviceTax}" . "," . '"vat":' . $vat . " } ";
$sql = "Select * From ids ";
$tables = PDO_FetchAll("SELECT name FROM sqlite_master WHERE type='table' and name not like 'IDs' ");
foreach ($tables as $row) {
foreach ($row as $row2 => $row2_value) {
$sql = $sql . ' inner join ' . $row2_value . ' on ids.id=' . $row2_value . '.id ';
}
}
//print_r($tables);
//echo $sql;
//$result = $dbh->query('SELECT * FROM IDs');
//print 'building';
if (file_exists("datafile.csv")) {
copy("datafile.csv", "datafile_copy.csv");
}
$myfile = fopen("datafile.csv", "w") or die("Unable to open file!");
$result = PDO_FetchAll($sql);
//print_r($result);
//echo $result[1][0].' : '.$result[2][1];
$rows = '';
foreach ($result as $row) {
$cols = '<tr>';
$rows = $rows . '<tr>';
$txt = '';
foreach ($row as $row2 => $row2_value) {
$cols = $cols . '<th>' . $row2 . '</th>';
$rows = $rows . '<td>' . $row2_value . '</td>';
$txt = $txt . $row2_value . '|';
//echo $row2.' : '.$row2_value;
//print_r($row);
//echo '<br>';
}
