PHP Error: Call to a member function fetch_assoc() on a non-object in PHP Error: Call to členskú funkciu fetch_assoc () na non-objekt

Posted on 23. Publikované dňa 23. Jun, 2009 by Dragos in Coding , PHP Júna 2009 od Dragos v Kódovanie, PHP

If you get this error: Call to a member function fetch_assoc() on a non-object in … , it means that you have an error in your mysql syntax. Ak sa vám táto chyba: Výzva na členskú funkciu fetch_assoc () na non-objekt v ..., to znamená, že máte chybu v mysql syntax. Supposing that $mysqli is your database connection object, put echo $mysqli->error; just before the line you're getting the error on. $ Mysqli za predpokladu, že je vaše pripojenie k databáze objektu, dal echo $ mysqli-> error; tesne pred riadok dostaneš chybe.

 $mysqli=new mysqli(HOST,USER,PASS,DB); $ Mysqli = new mysqli (HOST, USER, PASS, DB); 
 $mQuery=$mysqli->query('select `data` from `this_table` where `id`=1'); mQuery $ = $ mysqli-> query ( 'SELECT `data` z `this_table` kde `id` = 1'); 
 echo $mysqli->error; //echoes that column `data` does not exist in table `this_table` echo $ mysqli-> error; / / echoes, že stĺpec "dáta" neexistuje v tabuľke `` this_table 
 $row=$mQuery->fetch_assoc(); //gives error as the column `data` is in table `that_table`, not in table `this_table` $ Row = $ mQuery-> fetch_assoc (); / / obsahuje chyby stĺpec "dáta" je v tabuľke `that_table", nie je v tabuľke `` this_table 
 $mysqli->close(); $ Mysqli-> close ();