How do you fix mysqli_fetch_array () expects parameter 1 to be Mysqli_result boolean given in?

pritaeas 2,080 ¯\_(ツ)_/¯ Moderator Featured Poster

mysqli_query returns false on failure, indicating something is wrong with your query. See the sticky thread at the top of the PHP forum to find out how you can check for errors (most likely because $criteria is misspelled).

Edited 11 Years Ago by pritaeas because: n/a

11 Years Ago

check your spelling is correct or not for '$crieria' near to ORDER BY

11 Years Ago

mysqli_query returns false on failure, indicating something is wrong with your query. See the sticky thread at the top of the PHP forum to find out how you can check for errors (most likely because $criteria is misspelled).

Sorry pritaeas.. I haven't see your post.

11 Years Ago

I typed myself wrongly, but in my code i checked and there is no misspell.

pritaeas 2,080 ¯\_(ツ)_/¯ Moderator Featured Poster

@Karthik: No need to be sorry. We saw the same thing, and were probably typing at the same time.

@Jiaxin: See the sticky thread first. It tells you how to trap and find errors.

Edited 11 Years Ago by pritaeas because: n/a

11 Years Ago

Replace your query

with

Edited 11 Years Ago by karthik_ppts because: n/a

11 Years Ago

I replaced it but still have the same error.

11 Years Ago

just echo out the query as

before this line

copy the printed query and execute it in the SQL section of your phpmyadmin and see the result. it will tell the error if you have error in your query

ko ko 97 Practically a Master Poster

SELECT $criteria Why dollar sign before 'criteria' after 'SELECT' ?

pritaeas 2,080 ¯\_(ツ)_/¯ Moderator Featured Poster

Only do that if you want to replace it with a variable. If you think it is wrong, replace it with a *

hielo 65 Veteran Poster

try:

11 Years Ago

try:

$result_1= mysqli_query($link, "SELECT $criteria FROM table ORDER BY $crieria ASC") or die( mysqli_error($link) );

Always let PHP display errors for you in development. Another way described in PHP Manual is:

11 Years Ago

because i pass in the user input at the $criteria

11 Years Ago

i have already echo out this
echo "SELECT $criteria FROM table ORDER BY $crieria ASC";

but then the result shown are only:
SELECT FROM criteria ORDER BY ASC

and not the real data from database. what can i do to make it echo out all the data in ASC?

11 Years Ago

i have already echo out this
echo "SELECT $criteria FROM table ORDER BY $crieria ASC";

but then the result shown are only:
SELECT FROM criteria ORDER BY ASC

and not the real data from database. what can i do to make it echo out all the data in ASC?

Then problem is not in query. Problem is in your input $criteria. Check your input or post your all codes.

4 Years Ago

<?php include('server.php');

?>

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\php_crud\index.php on line 8

please solve code above it?

4 Years Ago

My Code:
<?php
include("validation.php");
include("conection.php");
if(isset($_POST["button"]))

$sql="INSERT INTO administrator (adminid, adminname, password, address, contactno)
VALUES
('$_POST[adminid]','$_POST[adminname]','$pwde','$_POST[address]','$_POST[contactno]')";

if (!mysql_query($sql,$con))

die('Error: ' . mysql_error());

else

$result = mysql_query("SELECT * FROM administrator");
while($row1 = mysql_fetch_array($result))

if(isset($_POST["button2"]))

mysql_query("UPDATE administrator SET adminname='$_POST[adminname]', address='$_POST[address]', contactno='$_POST[contactno]'
WHERE adminid = '$_POST[adminid]'");
echo "Record updated successfully";

if($_GET[view] == "administrator")

$result = mysql_query("SELECT * FROM administrator where adminid='$_GET[slid]'");
while($row1 = mysql_fetch_array($result))

$contact = $row1["contactno"];

?>

After execution got below warning:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in

Please Support....