function updateTransactionsTable($dateFrom, $sum)
{
//Check if the date exists in the transactions table
$dateInTable = PDO_FetchAll("SELECT * FROM transactions WHERE OrderDate =:Date", array("Date" => $dateFrom));
if (count($dateInTable) > 0) {
//Do an update
PDO_Execute("UPDATE transactions SET OrderValue =:OrderValue WHERE OrderDate =:OrderDate", array("OrderDate" => $dateFrom, "OrderValue" => $sum));
} else {
//Do insert
PDO_Execute("INSERT INTO transactions (OrderDate,OrderValue) VALUES (:OrderDate, :OrderValue)", array("OrderDate" => $dateFrom, "OrderValue" => $sum));
}
}
function handleSignup()
{
//Already checked the post is not empty
//Get the required vars
$email = $_POST['email'];
$fname = $_POST['fname'];
$password = $_POST['password'];
$phone = $_POST['phone'];
$password = password_hash($_POST['password'], PASSWORD_DEFAULT);
PDO_Execute("INSERT INTO user(email,fname,password,phone) VALUES (:email,:fname,:password,:phone )", array("email" => $email, "fname" => $fname, "password" => $password, "phone" => $phone));
$_SESSION['user'] = 0;
header('Location: login.php');
}
function saveTransactionToDb()
{
$transaction = json_decode($_POST['json']);
$order_type = $_POST['ordertype'];
$traxn_id = $_POST['transactionid'];
$totalValue = $_POST['totalVal'];
$date = $_POST['date'];
$mydate = getdate(date("U"));
// echo "$mydate[weekday], $mydate[month] $mydate[mday], $mydate[year]";
// "Aug 23 2015";
// $date = $mydate[mday]."-".substr( $mydate[month],0,3 ) ."-".$mydate[year];
$date = substr($mydate['month'], 0, 3) . " " . $mydate['mday'] . " " . $mydate['year'];
// echo $date;
foreach ($transaction as $eachitem) {
$str = "";
$item_name = "";
$item_price = "";
foreach ($eachitem as $key => $val) {
if ($key == "Name") {
$item_name = $val;
} else {
if ($key == "Price") {
$item_price = $val;
} else {
if ($key == "TypeOfOrder") {
}
}
}
// $str = $str . $val ;
}
// echo $str. "</br>";
// echo "Name " . $item_name . " Price " . $item_price ."</br>";
PDO_Execute("INSERT INTO neworder (typeoforder,item,txnid,price ) VALUES (:typeoforder,:item,:txnid,:price)", array("typeoforder" => $order_type, "item" => $item_name, "txnid" => $traxn_id, "price" => $item_price));
}
// save total value of transaction in dailytransactions
PDO_Execute("INSERT INTO dailytransactions (transactionID,Items,totalValue,Date) VALUES (:transactionID, :Items, :totalValue , :Date)", array("transactionID" => $traxn_id, "Items" => "", "totalValue" => $totalValue, "Date" => $date));
saveTransactionToCloud();
print '{}';
}
//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>";
//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>";
function pushToDB()
{
//echo "Hello"
$item_name = $_POST['Item_name'];
$item_price = $_POST['Item_price'];
$order_type = $_POST['Order_type'];
$traxn_id = $_POST['txnId'];
//$id = $_POST['id'];
//echo $item_name;
PDO_Execute("INSERT INTO neworder (typeoforder,item,txnid,price ) VALUES (:typeoforder,:item,:txnid,:price)", array("typeoforder" => $order_type, "item" => $item_name, "txnid" => $traxn_id, "price" => $item_price));
}
//echo $QNameStr;
if ($name == '') {
$create = "Create table IDs (Id INTEGER PRIMARY KEY)";
PDO_Execute($create);
//print $create;
}
if ($e == null) {
try {
//$dbh->exec("Delete from IDs");
//$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;
}
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 updateUserDetails()
{
$fname = $_POST['fname'];
$enteremail = $_POST['email'];
PDO_Execute("UPDATE user SET fname=:fname WHERE email=:email", array("fname" => $fname, "email" => $enteremail));
}
<?php
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
include "./pdo.php";
$db_file = "./restaurant.sqlite3";
PDO_Connect("sqlite:{$db_file}");
PDO_Execute("INSERT INTO tax(servicetax,vat,date) VALUES (:servicetax,:vat,:date )", array("servicetax" => $_POST['servicetax'], "vat" => $_POST['vat'], "date" => $_POST['date']));
