PHP Error: Call to a member function fetch_assoc() on a non-object in PHP Error: Sejħa għal membru funzjoni fetch_assoc () fuq bażi non-oġġett fil -

Posted on 23. Posted on 23. Jun, 2009 by Dragos in Coding , PHP Ġunju, 2009 minn Dragos fl-Kodifika, 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. Jekk ikollok dan l-iżball: Sejħa għal membru funzjoni fetch_assoc () fuq bażi non-oġġett fil ..., dan ifisser li għandek żball fil-sintassi mysql tiegħek. Supposing that $mysqli is your database connection object, put echo $mysqli->error; just before the line you're getting the error on. $ Mysqli jekk jitqies li huwa oġġett tiegħek konnessjoni database, ippreżentati eku $ mysqli-> żball; eżatt qabel il-linja int jkollna l-iżball fuq.

$mysqli=new mysqli(HOST,USER,PASS,DB); mysqli $ = mysqli ġodda (HOST, QED JAGĦMEL UŻU MINNU, PASS, DB);
$mQuery=$mysqli->query('select `data` from `this_table` where `id`=1'); $ mQuery = $ mysqli-> query ( "jagħżel" data "mill` this_table "fejn" id = "1");
echo $mysqli->error; //echoes that column `data` does not exist in table `this_table` eku $ mysqli-> iżball; / / itenni li "data kolonna" ma teżistix fit-tabella "this_table`
$row=$mQuery->fetch_assoc(); //gives error as the column `data` is in table `that_table`, not in table `this_table` ringiela $ = $ mQuery-> fetch_assoc (); / / tagħti żball bħala l-kolonna "data" tiġi fit-tabella "that_table", mhux fit-tabella "this_table`
$mysqli->close(); $ mysqli->-qrib ();