Here i am getting error so help me

Question

<?php
     $conn=mysqli_connect("localhost","root","","telephasic");
     if(isset($_GET['role']))
     {
        $role1=$_GET['role'];
        $query = "SELECT * FROM register WHERE id='$role1'";
        while($row=mysql_fetch_object($query))
        {
            $role_var=$row->role;
            if($role_var=='1')
            {
                $role_state="NULL";
            } else {
                $role_state="0";
            }
            $update=mysql_query("update register set status='$role_state' where id='$role1' ");
            if($update)
            {
               header("Location:admin.php");
            } else {
               echo mysql_error();
            }
       }
?>
<?php } ?>

I am getting error here so help me please

Fatal error: Uncaught Error: Call to undefined function mysql_fetch_object() in C:\xampp\htdocs\telephasic\action.php:7 Stack trace: #0 {main} thrown in C:\xampp\htdocs\telephasic\action.php on line 7

you should use `mysqli_fetch_object` instead of `mysql_fetch_object`, [here is doc](http://php.net/manual/en/function.mysql-fetch-object.php) — Alexandre Painchaud, Jul 27 '18 at 07:19
Also if you are using mysqli for connection don't use mysql after — Oleksandr Pobuta, Jul 27 '18 at 07:20
@AlexandrePainchaud That alone won't make the code work. There's still `mysql_query()` and `mysql_error()`. — brombeer, Jul 27 '18 at 07:23

MorganFreeFarm · Accepted Answer · 2018-07-27T07:33:05.253

1

Try with this code:

   <?php
         $conn=mysqli_connect("localhost","root","","telephasic");
         if(isset($_GET['role']))
         {
            $role1=$_GET['role'];
            $query = "SELECT * FROM register WHERE id='$role1'";
            $result=mysqli_query($conn,$query); // u need to execute query first!!
            while($row=mysqli_fetch_object($result))
            {
                $role_var=$row->role;
                if($role_var=='1')
                {
                    $role_state="NULL";
                } else {
                    $role_state="0";
                }
                $update=mysqli_query($conn, "update register set status='$role_state' where id='$role1' ");
                if($update)
                {
                   header("Location:admin.php");
                } else {
                   echo mysqli_error();
                }
           }
    ?>
    <?php } ?>

edited Jul 27 '18 at 07:33

answered Jul 27 '18 at 07:27

MorganFreeFarm

3,811
8
23
46

Parse error: syntax error, unexpected 'while' (T_WHILE) in C:\xampp\htdocs\telephasic\action.php on line 8 – Thakur Jul 27 '18 at 07:29
Try again, i edited the code! – MorganFreeFarm Jul 27 '18 at 07:30
1

yes it works thanks alot – Thakur Jul 27 '18 at 07:32
can you please help me? – Thakur Jul 27 '18 at 07:57

Here i am getting error so help me

1 Answers1