Downloaded XAMPP and created MySQL database and table using phpMyAdmin. Inserted rows into table from input form in browser using mysqli. Confirmed data was inserted using browse function in phpMyAdmin.
All good.
Trouble comes when I try to retrieve data using mysqli and SELECT statement:
Here is my code:
*********************************************************************************
<?php
$con = new MySQLi("localhost", "xxx", "xxx", "xxx");
if ($con === false) {
die("ERROR no connexion " . mysqli_connect_error());
}
else {
echo "<p> Connect was a success </p>";
};
$sql = "SELECT lastName, firstName, email, gender from tab1";
echo "<p>" . $sql ."</p>";
$result = $con -> query($sql);
$x = var_export($result, TRUE);
echo "<br /><pre>" . $x . "</pre><br />";
echo "hi" . "<br />";
echo "<p>Try to see error" . $con -> error . "</p>";
$con -> close();
?>
******************************************************************************************************
And here is what I see in the browser
***********************************************************************************************************
Connect was a success [so it connected]
SELECT lastName, firstName, email, gender from tab1 [the $sql statement]
mysqli_result::__set_state(array( 'current_field' => NULL, 'field_count' => NULL, 'lengths' => NULL, 'num_rows' => NULL, 'type' => NULL, )) hi Try to see error [No error apparently]
************************************************************************************************************
Nothing in result
Works fine with INSERT
Fails with SELECT
All tips, suggestions welcome.