asked on
Getting error that does not match code
Here is the code from the page:
echo "fred";
$SqlString1 = "SELECT * FROM survey_data WHERE SEQ like \"".$strt."%\" and CITY != \"\" and STAT != \"\" and ZIP != \"\"";
$survey_data = $conn->query($SqlString1);
$row_survey_data = $survey_data->fetch();
This is the display from the page:
fred
Fatal error: Call to undefined method mysqli_result::fetch() in /home/langsyst/public_html
Line 54 is the $row_survey_data fetch
Where the hell is it getting "mysqli"?
echo "fred";
$SqlString1 = "SELECT * FROM survey_data WHERE SEQ like \"".$strt."%\" and CITY != \"\" and STAT != \"\" and ZIP != \"\"";
$survey_data = $conn->query($SqlString1);
$row_survey_data = $survey_data->fetch();
This is the display from the page:
fred
Fatal error: Call to undefined method mysqli_result::fetch() in /home/langsyst/public_html
Line 54 is the $row_survey_data fetch
Where the hell is it getting "mysqli"?
PHP
Last Comment
Ray Paseur
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
That often means your query above it did not succeed. 'mysqli_result::fetch' is the name of the actual function used by fetch() with the 'mysqli' driver. http://php.net/manual/en/mysqli-stmt.fetch.php
That error is the often the signal taht the query fails: try to run the query in phpMyAdmin (or equivalent) and see what's happen.
Also you should use mysqli_error( $conn ); to get the error:
Also you should use mysqli_error( $conn ); to get the error:
echo "fred";
$SqlString1 = "SELECT * FROM survey_data WHERE SEQ like \"".$strt."%\" and CITY != \"\" and STAT != \"\" and ZIP != \"\"";
echo $SqlString1 . '<br>';
$survey_data = $conn->query($SqlString1);
if ($survey_data){
$row_survey_data = $survey_data->fetch();
}else{
echo mysqli_error( $conn );
}
How to use the MySQL extensions, including:
The article includes tested-and-working code examples you can copy for your own use.
- Conversion from MySQL to modern extensions
- How to test for query success or failure and visualize any errors
- How to retrieve results
- How to avoid trip-wires such as mixing procedural and object-oriented code
The article includes tested-and-working code examples you can copy for your own use.
ASKER
Sometimes I'm a moron. Changed it to fetch_array() and it worked. Stared at this all afternoon!!!
Thanks
Thanks
Fetch_Array() is an anti-pattern. Unless you deliberately tell it otherwise, It returns twice as much information as needed, making it the least efficient way to acquire information from the results set.
in my experience, the best function (correct amount of data, easy-to-use syntax) is Fetch_Object()
in my experience, the best function (correct amount of data, easy-to-use syntax) is Fetch_Object()