Explore our sites

Stack Exchange
tour help careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

Gentlemen, i am having an error here and your help would be much appreciated

my code is below and this is the error i am getting:

PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/SANDBOX/PHP/.php on line 14

        <?php
        $con=mysqli_connect("localhost","USER","PASSWORD","DATABASE");
        // Check connection
        if (mysqli_connect_errno()){
          echo "Failed to connect to MySQL: " . mysqli_connect_error();
        }

        if($_POST[process]=="btn_add"){
            $result = mysqli_query($con,"INSERT INTO users (user, password, type) VALUES ('".$_POST['user']."','".$_POST['password']."','".$_POST['type']."')" );
        }else if($_POST[process]=="btn_update"){
            $result = mysqli_query($con,"UPDATE users SET user='".$_POST['user']."',  password='".$_POST['password']."', type='".$_POST['type']."' WHERE id='".$_POST['id']."' ;");
        }else if($_POST[process]=="btn_delete"){
            $result = mysqli_query($con,"DELETE FROM  users WHERE id='".$_POST['id']."';");
        }while($result = mysqli_fetch_array($row)){
           echo $row['type'] ;
        }

        mysqli_close($con);
        ?>
share|improve this question
 
I tried all the suggestions below, the error is still appearing, i modified this line as it was an error on my part: –  user1576672 Dec 7 at 13:19
 
why you are using mysql_fetch_array when you are not fetching any record –  Rishabh Raj Dec 7 at 13:23
 
It was written by a freelancer that once paid dropped the ball. I am stuck with troubleshooting everything and i am not a pro. Sorry. If i remove the entire line from while to the bracket it works and no more errors. But the operations take much LONGER to process than before. –  user1576672 Dec 7 at 19:00
add comment

3 Answers

up vote 3 down vote

mysqli_fetch_array($row) to mysqli_fetch_array($result)

share|improve this answer
 
and what about echo $row['type'] ; ?? –  Let me see Dec 7 at 12:49
add comment
up vote 3 down vote 
always pass resource as an argument to mysql_fetch_array

}while($row = mysqli_fetch_array($result)){
           echo $row['type'] ;
        }

But i cant find 'select' in your code,you are using only 'update' and 'delete'.you dont need mysql_fetch_array.

mysql_fetch_array Returns an array that corresponds to the fetched row and moves the internal data pointer ahead.

but you are not selecting anything from database so there is no need to use mysql_fetch_array.

Read manual here

*Dont use mysql_ as they are depracated.*

share|improve this answer
add comment
up vote 1 down vote

syntax error:

 $result = mysqli_query($con,"DELETE FROM  users WHERE id='".$_POST['id']."';");

change to:

 $result = mysqli_query($con,"DELETE FROM  users WHERE id='".$_POST['id']."'");
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.