stevenlmeyer
-
Posts
2 -
Joined
-
Last visited
Posts posted by 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,
))
hiTry to see error [No error apparently]
************************************************************************************************************Nothing in resultWorks fine with INSERTFails with SELECTAll tips, suggestions welcome. -
Hi I'm Steven, 68 yo from Melbourne, Australia. Very - and I mean VERY - new to PHP.
Need to retrain for a new career.
Posted a query elsewhere
mysqli
in PHP Coding Help
Posted
OK I've solved the problem. My own stupidity.