Jump to content

stevenlmeyer

New Members
  • Posts

    2
  • Joined

  • Last visited

Everything posted by stevenlmeyer

  1. OK I've solved the problem. My own stupidity.
  2. 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.
  3. 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
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.