<!DOCTYPE html> <html lang="en"> <head> </head> <body> <div class="page-content"> <?php require_once 'dbinterface.php'; $db_handle = new dbinterface\PDO_handle(); $db_handle->set_target("store-cakes"); $products = $db_handle->pull("2 3"); print_r($products); $db_handle = null; ?> </div> </body> </html>
<?php header('Content-Type: application/json'); header('Cache-Control: no-cache, must-revalidate'); require_once 'dbinterface.php'; $unsafe_un = isset($_POST['u_n']) ? $_POST['u_n'] : false; $result = ['valid' => "false"]; if ($unsafe_un) { $db_handle = new dbinterface\PDO_handle(); $record = $db_handle->pull("1 2 3", ['Username' => "{$unsafe_un}"], $exists); if (!empty($record)) { $result = ['valid' => "true", 'fname' => $record[0]['FirstName'], 'lname' => $record[0]['LastName']]; $record = null; $db_handle = null; } } echo json_encode($result);