<?php $link = mysql_connect('localhost', 'root', 'root'); if (!$link) { die('Could not connect: ' . mysql_error()); } else { echo 'Connected successfully' . "<br>"; } $db_selected = mysql_select_db('Test_DB', $link); if (!$db_selected) { die ('Can\'t use Test_DB : ' . mysql_error()); } else { echo 'Test_DB selected' . "<br>"; } // This SQL statement selects ALL from the table 'Contacts' $sql = "SELECT * FROM Contacts"; $result = mysql_query($sql); if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $sql; die($message); } else { echo 'Result: ' . $result; $resultArray = array(); $tempArray = array(); // Loop through each row in the result set while ($row = mysql_fetch_array($result)) { // do stuff - here it works $tempArray = $row; array_push($resultArray, $tempArray); } // Finally, encode the array to JSON and output the results echo json_encode($resultArray); } // Check if there are results // if ($result = mysql_query($link, $sql)) if ($result = mysql_query($sql, $link)) { // If so, then create a results array and a temporary one // to hold the data $resultArray = array(); $tempArray = array(); // Loop through each row in the result set while($row = $result->fetch_object()) { // Add each row into our results array $tempArray = $row; array_push($resultArray, $tempArray); } // Finally, encode the array to JSON and output the results echo json_encode($resultArray); } // Close connections mysql_close($link); ?>
You have javascript disabled. You will not be able to edit any code.