The mysqli_query()
method returns an object resource to your $result
variable, not a string.
You need to loop it up and then access the records. You just can’t directly use it as your $result
variable.
while ($row = $result->fetch_assoc()) { echo $row['classtype']."<br>"; }
Related Posts:
- Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
- mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
- Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given in
- mysqli_real_connect(): (HY000/2002): No such file or directory
- Fatal error: Call to undefined function mysqli_connect()
- mysqli_real_connect(): (HY000/2002): No such file or directory
- Fatal error: Call to undefined function mysqli_connect()
- Fatal error: Call to a member function bind_param() on boolean [duplicate]
- MySqli Commands out of sync; you can’t run this command now
- Commands out of sync; you can’t run this command now
- Call to undefined method mysqli_stmt::get_result
- Call to undefined method mysqli_stmt::get_result
- Fatal error: Cannot use object of type mysqli_result
- How to solve “Fatal error: Class ‘MySQLi’ not found”?
- mysql_field_name to the new mysqli
- mysqli_select_db() expects parameter 1 to be mysqli, string given
- mysqli::query(): Couldn’t fetch mysqli
- phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
- Warning: mysqli_query() expects at least 2 parameters, 1 given. What? [duplicate]
- Deprecated: mysql_query() [duplicate]
- Fatal error: Call to a member function fetch_assoc() on a non-object
- Having a problem getting mysqli_query to execute
- CodeIgniter: Unable to connect to your database server using the provided settings Error Message
- Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given… what I do wrong?
- Call to a member function fetch_assoc() on boolean in
[duplicate] - PHP variables don’t evaluate in the query [duplicate]
- What’s the net::ERR_HTTP2_PROTOCOL_ERROR about?
- PHP “or” Syntax
- S_SESSION variable (user role) not recognised
- Is SAJAX dead? What to replace with?
- Invalid column count in CSV input on line 1 Error
- How to check if a string starts with a specified string?
- What is difference between PHP cli and PHP cgi?
- $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
- Why use $_SERVER[‘PHP_SELF’] instead of “”
- phpMyAdmin: secret passphrase?
- Are there dictionaries in php?
- laravel updateOrCreate method
- How to listen messageSent event in laravel 5.5
- Make a HTTPS request through PHP and get response
- How to insert an item at the beginning of an array in PHP?
- PHP Deprecated: Methods with the same name
- How do the PHP equality (== double equals) and identity (=== triple equals) comparison operators differ?
- How do I pass JavaScript variables to PHP?
- Call to undefined function curl_init().?
- pdo – Call to a member function prepare() on a non-object
- Compare given date with today
- Multi-line strings in PHP
- cURL error 60: SSL certificate: unable to get local issuer certificate
- Replace spaces with a dash in a URL
- Are PDO prepared statements sufficient to prevent SQL injection?
- Message: Trying to access array offset on value of type null [duplicate]
- SSL error SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
- retrieve data from db and display it in table in php .. see this code whats wrong with it?
- PDO closing connection
- “Valid CSRF Token Required” in Osticket After login?
- Count how many files in directory PHP
- Simple PHP calculator
- Convert from MySQL datetime to another format with PHP
- php foreach with multidimensional array
- header location not working in my php code
- PHP Error: Function name must be a string
- Uncaught Error: Call to undefined function mysql_escape_string()
- PHP cURL custom headers
- Parsing domain from a URL
- PHP class not found but it’s included
- How to fix the session_register() deprecated issue?
- Laravel 5 MethodNotAllowedHttpException in RouteCollection.php line 201:
- PHP “&” operator
- What is ?
- Connection reset by peer: mod_fcgid: error reading data from FastCGI server
- How to import csv file in PHP?
- What is the syntax for accessing PHP object properties?
- * failed to open vchiq instance
- Mysql where id is in array
- How to extract and access data from JSON with PHP?
- The character encoding of the HTML document was not declared
- Warning “Do not Access Superglobal $_POST Array Directly” on Netbeans 7.4 for PHP
- Notice: Undefined offset: 0 in
- How to Sort a Multi-dimensional Array by Value
- How to get time difference in minutes in PHP
- How to write a link like which link to the same page in PHP?
- Insert string at specified position
- How to install a specific version of package using Composer?
- PHP + JQuery – How to use these two together? Please see my example
- A non well formed numeric value encountered
- Data extraction from /Filter /FlateDecode PDF stream in PHP
- Getting a 500 Internal Server Error on Laravel 5+ Ubuntu 14.04
- Access PHP variable in JavaScript
- How to use data-saferedirecturl in a tag in PHP?
- CSS background images in WordPress
- Reset PHP Array Index
- PHP date yesterday [duplicate]
- Clear cache in Symfony: `cache:clear` or `rm -rf`?
- create php live clock
- Converting a UNIX Timestamp to Formatted Date String
- PHP Call to undefined function
- Formatting a number with leading zeros in PHP
- POST an array from an HTML form without javascript
- WordPress get_template_directory_uri() not returning https and only return http