php - JSON_Encode returns NULL (Array) -


i trying parse jsonresponse in android studio, , realized json_encode returns null. ideas cause this? using php 5.2.x

here php:

<?php     header('content-type: application/json');     $con = mysqli_connect("myhost", "myuser", "mypass", "a5911579_android");      $statement = mysqli_prepare($con, "select * markers    order marker_id");     mysqli_stmt_execute($statement);      $arrrows = array();     $arryitem = array();     $arrrows["success"] = false;     $arryitem["success"] = false;      while($arr = mysqli_stmt_fetch($statement)) {         $arryitem["marker_id"] = $arr["marker_id"];         $arryitem["lat"] = $arr["lat"];         $arryitem["lng"] = $arr["lng"];         $arryitem["snippet"] = $arr["snippet"];         $arrrows[] = $arryitem;     }      echo json_encode($arrrows); ?>

this response:

{"success":false,"0":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null},"1":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null},"2":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null},"3":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null},"4":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null},"5":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null},"6":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null}}

it returns null both lat, lng, snippet , marker_id, though there values in database (using mysql).

any appreciated!

update: inserted $arr, still getting same result update: using

mysqli_stmt_bind_result($marker_id,$lat,$lng,$snippet);  while(mysqli_stmt_fetch($statement)) { $arrrows[] = compact('marker_id','lat','lng','snippet'); }

gives error (still null returned):

<br><table border='1' cellpadding='2' bgcolor='#ffffdf' bordercolor='#e8b900' align='center'><tr><td><font face='arial' size='1' color='#000000'><b>php error message</b></font></td></tr></table><br /> <b>warning</b>:  mysqli_stmt_bind_result() expects parameter 1 mysqli_stmt, null given in <b>/home/a5911579/public_html/getauction2.php</b> on line <b>16</b><br /> <br><table border='1' cellpadding='2' bgcolor='#ffffdf' bordercolor='#e8b900' align='center'><tr><td><div align='center'><a href='http://www.000webhost.com/'>     <font face='arial' size='1' color='#000000'>free web hosting</font></a></div></td></tr></table>

{"success":false,"0":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null},"1":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null},"2":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null},"3":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null},"4":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null},"5":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null},"6":{"success":false,"marker_id":null,"lat":null,"lng":null,"snippet":null}}

you have use mysqli_stmt_bind_result(...); binding value in listed variables. can use compact() make array variable name

mysqli_stmt_bind_result($marker_id,$lat,$lng,$snippet);  while(mysqli_stmt_fetch($statement)) {     $arrrows[] = compact('marker_id','lat','lng','snippet'); }

-

Comments

Post a Comment

Popular posts from this blog

serialization - Convert Any type in scala to Array[Byte] and back -

i have following question: i have variable value in program declared value. i want convert value byte array.. how can serialize byte array , back? found examples related other types such double or int, not any. this should need. it's pretty similar how 1 in java. import java.io.{bytearrayinputstream, bytearrayoutputstream, objectinputstream, objectoutputstream} object serialization extends app { def serialise(value: any): array[byte] = { val stream: bytearrayoutputstream = new bytearrayoutputstream() val oos = new objectoutputstream(stream) oos.writeobject(value) oos.close stream.tobytearray } def deserialise(bytes: array[byte]): = { val ois = new objectinputstream(new bytearrayinputstream(bytes)) val value = ois.readobject ois.close value } println(deserialise(serialise("my test"))) println(deserialise(serialise(list(1)))) println(deserialise(serialise(map(1 -> 2)))) println(deserialise(seri
Read more

matplotlib support failed in PyCharm on OSX -

any idea how fix ? how can debug might problem ? not seem : https://youtrack.jetbrains.com/issue/py-15520 i in console: python 2.6.9 (unknown, jul 14 2015, 19:46:31) [gcc 4.2.1 compatible apple llvm 6.0 (clang-600.0.39)] on darwin >>> import matplotlib.pyplot plt matplotlib support failed the backend : >>> import matplotlib >>> print(matplotlib.rcparams['backend']) macosx
Read more

python - Matplotlib: TypeError: 'AxesSubplot' object is not callable -

i new programming please pardon me if rookie mistake. i writing python script have defined functions create subplots of distributions. i have slider widget end user change value of variables(mu , sigma) , see effect on distribution. here's code import numpy np print np.__version__ import scipy print scipy.__version__ scipy.stats import norm, lognorm, uniform import matplotlib print matplotlib.__version__ import matplotlib.pyplot plt matplotlib.widgets import slider, button, radiobuttons, checkbuttons #####calculating mean , standard deviation##### global mu_a1 mu_a1 = 1 global mu_b1 mu_b1 = 10 global mu_c1 mu_c1 = -13 global sigma_a1 sigma_a1 = 0.14 global sigma_b1 sigma_b1 = 1.16 global sigma_c1 sigma_c1 = 2.87 mu_x01 = -11 sigma_x01 = 1.9 #####_____##### #####generating random data##### a1 = 0.75*mu_a1 + (1.25 - 0.75)*sigma_a1*np.random.sample(10000) b1 = 8*mu_b1 + (12 - 8)*sigma_b1*np.random.sample(10000) c1 = -12*mu_c1 + 2*sigma_c1*np.random.sample(10000)
Read more