Mysqli_fetch_assoc expects parameter 1 to be mysqli_result

I'd move the actual fetch into the class so you wrap the nature of the db more completely Reply to author. Copy link.

Sign in Email. Forgot your password? Ask a Question. Please Sign up or sign in to vote. See more: SQL. Posted May pm Matas - developer.

Mysqli_fetch_assoc expects parameter 1 to be mysqli_result

The script is basically trying to do a few simple things by connecting to a database and reading off a record, and then getting the results from an array. Once you have it working, you need to use prepared statements instead of just appending strings into your query. Thanks for the reply. The readdb function now looks like this, and at least produces a result:. Thank you for the post; appreciated. For prepared statements, scroll down a bit and browse some threads - there are plenty of examples on here, some in the last few days. But I always have to look up mysqli syntax. Some of my issue had to do with the fact that because I default the ID of the record to 1, when I later try to read the prior record there is none. Also, I have now set the default value of ID as an integer, rather than a string. Update: Ah, figured it out. Thanks for both replies. Yes, can confirm that my code works okay without the semi-colon in the query. Thank you again for your previous assistance droopsnoot; I really do appreciate it. After looking at documentation, it might be that if there is anything between the semicolon and the enclosing quotation marks PHP thinks it is a multi-statement and would error?

Dave Kreskowiak. Hey, yea thanks that fixed that problem

.

Fetches one row of data from the result set and returns it as an associative array. Each subsequent call to this function will return the next row within the result set, or null if there are no more rows. If two or more columns of the result have the same name, the last column will take precedence and overwrite any previous data. Note : Field names returned by this function are case-sensitive. Returns an associative array representing the fetched row, where each key in the array represents the name of one of the result set's columns, null if there are no more rows in the result set, or false on failure. The result set will always be iterated from the first row, regardless of the current position. Submit a Pull Request Report a Bug. Return Values Returns an associative array representing the fetched row, where each key in the array represents the name of one of the result set's columns, null if there are no more rows in the result set, or false on failure. I often like to have my results sent elsewhere in the format of an array although keep in mind that if you just plan on traversing through the array in another part of the script, this extra step is just a waste of time.

Mysqli_fetch_assoc expects parameter 1 to be mysqli_result

This extension was deprecated in PHP 5. Alternatives to this function include:. Returns an associative array that corresponds to the fetched row and moves the internal data pointer ahead. It only returns an associative array. Returns an associative array of strings that corresponds to the fetched row, or false if there are no more rows. If two or more columns of the result have the same field names, the last column will take precedence. Note : Field names returned by this function are case-sensitive. Submit a Pull Request Report a Bug. Warning This extension was deprecated in PHP 5.

Eyüp sultan vapur saatleri

Encode HTML. Sign in Email. Provide an answer or move on to the next question. Yes, can confirm that my code works okay without the semi-colon in the query. For prepared statements, scroll down a bit and browse some threads - there are plenty of examples on here, some in the last few days. Web01 2. Once you have it working, you need to use prepared statements instead of just appending strings into your query. Code block. The script is basically trying to do a few simple things by connecting to a database and reading off a record, and then getting the results from an array. Related Questions. Somthing like this might work better: [code] if! Show original message. But I always have to look up mysqli syntax. I do not think that is what you want.

W3Schools offers a wide range of services and products for beginners and professionals, helping millions of people everyday to learn and master new skills. Create your own website with W3Schools Spaces - no setup required.

Hey, yea thanks that fixed that problem Thank you again for your previous assistance droopsnoot; I really do appreciate it. Encode HTML. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. But it did not fix the problem I have when its all in a class. For prepared statements, scroll down a bit and browse some threads - there are plenty of examples on here, some in the last few days. Treat my content as plain text, not as HTML. Some of my issue had to do with the fact that because I default the ID of the record to 1, when I later try to read the prior record there is none. I'd move the actual fetch into the class so you wrap the nature of the db more completely Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message. Lol it was a typo wasn't it? When answering a question please: Read the question carefully. Matas - developer May pm. After looking at documentation, it might be that if there is anything between the semicolon and the enclosing quotation marks PHP thinks it is a multi-statement and would error?