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']));