What is error on this code

Question

//what is error on this code

<?php
$dbserver="localhost";
$dbuser="root";
$dbpwd="";
$dbname="sectinfo_aisect";

$cid= new mysqli($dbserver,$dbuser,$dbpwd,$dbname);

if($cid->error){
    die("Connection Faild:". $cid->error);
}

$userName='Devendra';
$result = $cid-> query("SELECT designation, FROM user WHERE subadmin= '22' and username='$userName' ");

$row = $result-> fetch_assoc($result);

echo $row['designation'];

?>

Fatal error: Call to a member function fetch_assoc() on a non-object in

possible duplicate of [Fatal error: Call to a member function fetch\_assoc() on a non-object](http://stackoverflow.com/questions/5121027/fatal-error-call-to-a-member-function-fetch-assoc-on-a-non-object) — Jocelyn, Jun 23 '15 at 10:55

score 1 · Answer 1 · answered Jun 23 '15 at 10:27

1

Fatal error: Call to a member function fetch_assoc() on a non-object

this error is because there is a error in your query $mysqli->query()

for reference - mysqli_query()

To see if your queries are correct.

Echo them directly in your html
copy them and run them into phpmyadmin
it will be more clear what you get output from there (error/data)

answered Jun 23 '15 at 10:27

Meenesh Jain

2,532
2
19
29

now check updated code !! – YOG_PHP Jun 23 '15 at 10:36
dont pass `$result` in your fetch_assoc(), that is only required in procedural style – Meenesh Jain Jun 23 '15 at 10:38

score 0 · Answer 2 · answered Jun 23 '15 at 10:36

0

Now check with this

$result = $cid -> query("SELECT designation FROM user WHERE username= '". $adminName ."'"); if ($result) { $row = $result -> fetch_assoc(); echo $designation = $row['designation']; }

answered Jun 23 '15 at 10:36

Nagarajbgk

31
1

Thanks i got error !! – YOG_PHP Jun 23 '15 at 10:40

score 0 · Accepted Answer · answered Jun 23 '15 at 10:57

0

Try this by editing your lines.

$result = $cid-> query("SELECT designation FROM user WHERE subadmin= '22' and username='".$userName."'");

$row = $result-> fetch_assoc();

answered Jun 23 '15 at 10:57

Riken Shah

87
10

What is error on this code

3 Answers3