How to fix: mysqli_query() expects parameter 1 to be mysqli and mysqli_fetch_array() expects parameter 1 to be mysqli_result

Question

0.00/5 (No votes)

See more:

require_once 'db.php';

$query = "SELECT = FROM quotes ORDER By rand() LIMIT 1";

$result = mysqli_query($con, $query);

while($row = mysqli_fetch_array($result)) {
print(json_encode($row['quote']));
}

?>

What I have tried:

I am no sure what to do as i am not experienced with PHP coding, help required URGENTLY!

Posted 6-Apr-16 1:28am

Member 12440221

Updated 6-Apr-16 1:38am

v3

Add a Solution

Comments

phil.o 6-Apr-16 7:30am

Look at your SQL query ; there is a huge and obvious mistake.

Member 12440221 6-Apr-16 7:58am

plz tell me

Member 12440221 6-Apr-16 8:08am

i dont know what to do please tell me

phil.o 6-Apr-16 8:13am

Did you have a look at the SQL query yet?

Member 12440221 6-Apr-16 8:27am

yes but i dont get what is wrong. i replaced the second equal sign in the code but same warnings show up.

phil.o 6-Apr-16 8:42am

How are you initializing your $con variable?

Member 12440221 6-Apr-16 9:04am

i connected it on the dp.php file

phil.o 6-Apr-16 9:17am

It may be a problem. At least this is exactly what the error message is telling you: the mysqli_query method expects a valid mysqli object as first parameter (i.e., your $con variable). If that fails, the $result variable is not well assigned, and the mysqli_fetch_array is fed with an incorrect $result parameter.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2016-04-06T01:38:00

Solution 1

Um.

SQL

SELECT = FROM quotes ORDER By rand() LIMIT 1

Try

SQL

SELECT * FROM quotes ORDER By rand() LIMIT 1

But better, specify the list of columns. That way, you only get the ones you need so the transfer is more efficient, you know the order in which they will arrive, and your app doesn't crash if the DB design is tweaked.

Posted 6-Apr-16 1:38am

OriginalGriff

Comments

Member 12440221 6-Apr-16 7:44am

I dont get this stuff.
can you tell me what to edit or write the code so i can copy it.
:)

OriginalGriff 6-Apr-16 7:48am

You are kidding, aren't you?
You need to identify the one and only, single character difference between two lines of code and make that change in your app, and you can't do it when they are both written down in front of you?
Development is about two things: details, and thinking.
You need to drink another coffee, I suspect...

Member 12440221 6-Apr-16 7:50am

i dont know about coding. i got this code of a tuorial.

OriginalGriff 6-Apr-16 7:58am

Then you need to go back to the start of the whole tutorial and work your way through it - you aren't going to learn anything useful if you skip ahead and don't fully understand the earlier stuff!

Member 12440221 6-Apr-16 8:03am

i have, i did every thing he explaied, but it is an old tutorial

OriginalGriff 6-Apr-16 8:11am

Then find a better tutorial - because if it hasn't taught you how to cope with a simple one character replacement, then it hasn't taught you anything! :laugh:

Member 12440221 6-Apr-16 8:12am

please tell me

OriginalGriff 6-Apr-16 8:18am

Tell you? :sigh:
Please, consider thinking for a minute...it will help your career even if it's in fast food...
OK: "replace the second equals sign in your code fragment with a star"

Member 12440221 6-Apr-16 8:28am

I did but same problem
:sad: