php - why fetch_assoc work on while? -


#1 code

$row = $result->fetch_assoc()); while ($row) { // code here }

#2 code

while ($row = $result->fetch_assoc());) { // code here }

why #1 code , #2 code give different result?

because in #1 execute fetch_assoc() once, while in #2 execute on every loop iteration.

in other words, in #2 fetch_assoc() keep on returning rows long there rows available in result set. #1 enter infinite loop if there @ least 1 row available.


Comments

Post a Comment

Popular posts from this blog

string - Using python and postgres, variables within execute function? -

i had question regarding usage of variables inside python function accesses postgresql server. example, following: def delete(): cur.execute( """delete potluck name = var_1;""" however, if wanted update function take in variables var_1, how so? for example, want function in form: def delete(var_1): cur.execute( """delete potluck name = %s;""", (var_1)) however, typing didn't work. in addition, how in case when: def delete(name, var_1): cur.execute( """delete potluck %s = %s;""", (name, var_1)) where don't want "name" have quotation marks when inserted string? any appreciated! to pass identifiers use psycopg2.extensions.asis from psycopg2.extensions import asis def update(table_name, var_1, var_2): cur.execute(""" update %s set %s = 'y' %s = 'john'; ...
Read more

android - How to get the Uri path from a ImageView? -

i trying create wallpaper application. images come internet. before of set background, need crop image. , this, using api named androidimagecropper. api need of uri object execute crop. how can uri imageview? because image internet. image not on drawable folder. confusing. maybe guys can me. public class mainactivity extends appcompatactivity { private networkimageview imageview; private uri mcropimageuri; public static final string url_photo = "http://cdn.wonderfulengineering.com/wp-content/uploads/2016/02/iron-man-wallpaper-42-610x1084.jpg"; @override protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_main); imageview = (networkimageview) findviewbyid(r.id.image_view); // singleton volley api, load image internet imageloader loader = mysingleton.getinstance(this).getimageloader(); loader.get(url_photo, imageloader.getimagelistener(imageview, r.drawable.temp_picture, ...
Read more