mysqli

[stevenlmeyer]

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.

 

[stevenlmeyer]

OK I've solved the problem. My own stupidity.