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>'; }