function get_todo_array($user) { todolog("mysql_data_access.php | trying to retrieve todos for user: {$user}"); $query = "SELECT * FROM todo WHERE owner='{$user}'"; $connection = get_connection(); $resultSet = mysqli_query($connection, $query); todolog("mysql_data_access.php | resultset: " . print_r($resultSet, true)); $todos = []; while ($task = mysqli_fetch_array($resultSet)) { $todos[] = convert_mysql_todo_array_to_map($task); } todolog("mysql_data_access.php | resultset: " . print_r($todos, true)); return $todos; }
/** * fetch the todo list from MYSQL database by UserName(Email ID) * @param string $user Email Address * @return array todos */ function get_todo_array($user) { todolog("mysql_data_access.php | trying to retrieve todos for user: {$user}"); $connection = get_connection(); // $query = "SELECT * FROM todo WHERE owner='$user'"; // $resultSet = mysqli_query($connection, $query); // prepare statement $stmt = $connection->prepare("SELECT * FROM todo WHERE owner=?"); $stmt->bind_param("s", $user); //binding the parameters $stmt->execute(); $res = $stmt->get_result(); $todos = []; while ($task = $res->fetch_assoc()) { $todos[] = convert_mysql_todo_array_to_map($task); } $stmt->close(); $connection->close(); // var_dump($todos); // die(); // todolog("mysql_data_access.php | resultset: " . print_r($resultSet, true)); // $todos = []; // while ($task = mysqli_fetch_array($resultSet)) { // $todos[] = convert_mysql_todo_array_to_map($task); // } // var_dump($todos); // die(); todolog("mysql_data_access.php | resultset: " . print_r($todos, true)); return $todos; }