Search the Community
Showing results for tags 'php mysqli pdo'.
Found 1 result
-
This script is running thru without any errors but it is not producing any data but the database is full of data. What am I doing wrong. I am trying to understatnd PDO with MYSQLI <?php include("connect.php"); $pid = $_SESSION['profile']['id']; $sql ="SELECT * FROM signings WHERE pid = \"$pid\" AND done= 0"; $result = $db->query($sql); $out = array(); // Parse the result set foreach($result as $row) { $out[] = array( 'id' => $row->id, 'title' => $row->lname, //'url' => Helper::url($row->id), 'start' => strtotime($row->signstart), 'end' => strtotime($row->signend) ); } echo json_encode(array('success' => 1, 'result' => $out)); exit;
