<?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);
?>