php - two while loop fetching data from two queries only show one result -


i have code use fetch data database:

function show_volanti($data){      $con = $data;       // passo connessione     $id = 1;            // 1 volante     $visibile = 1;      // variabile di visibilita'      $rows1 = array();   // preparo array 1 per id articoli volante     $rows2 = array();   // preparo array 2 per le foto volanti      $id_articoli = '';  // riferimento articoli per seconda query galleria     $g = '';            // riferimento associazione gallery viewer     //$rif_id = '';     // rif_id se ok da cancellare       $query1 = "select articoli.id id_articoli,                                       articoli.titolo,                                       articoli.descrizione                                       articoli                                       articoli.genere1 = ?                                       , articoli.visibile = ?";      $query2 = "select galleria.id id_galleria,                                     galleria.foto,                                     galleria.rif_id                                     galleria                                     galleria.rif_id = ?";      $stmt = mysqli_stmt_init($con);     // inizializzo la connessione      mysqli_stmt_prepare($stmt,$query1);      mysqli_stmt_bind_param($stmt,'ii',$id,$visibile);   // lego parametri      mysqli_stmt_execute($stmt);     // eseguo la query      mysqli_stmt_bind_result($stmt,                             $rows1['id_articoli'],                             $rows1['titolo'],                             $rows1['descrizione']);     // creo riferimento per galleria nel viewer      $html = "";     $html .= "<div class='container'>";      while (mysqli_stmt_fetch($stmt)){          $id_articoli = $rows1['id_articoli'];           $html .= "  <div class='row'>";         $html .= "    <div class='col-sm-12'>";         $html .= "      <div class='panel panel-default'>";         $html .= "        <div class='panel-body'>";           $html .= "            <div class='col'>";         $html .= "              <div class='panel panel-default'>";         $html .= "                <div class='panel-heading'><b>$rows1[titolo]</b></div>";         $html .= "                  <div class='panel-body'>";         $html .= "                      <div class='row'>";         $html .= "                          <div class='class_p'>$rows1[descrizione]</div>";         $html .= "                      <div> <!-- end first row -->";          $html .= "                      <div class='class_container clearfix'>";           mysqli_stmt_prepare($stmt,$query2);          mysqli_stmt_bind_param($stmt,'i',$id_articoli);     // lego parametri          mysqli_stmt_execute($stmt);     // eseguo la query          mysqli_stmt_bind_result($stmt,                                 $rows2['id_galleria'],                                 $rows2['foto'],                                 $rows2['rif_id']);                                            while(mysqli_stmt_fetch($stmt)){              $g = '';             $g .= "g";             $g .= $rows2['rif_id'];              $html .= "<div class='thumbnail col-sm-2'>";             $html .= "<div class='class_img'>";             $html .= "<a href='$rows2[foto]' data-toggle='lightbox' data-gallery='$g' >";             $html .= "<img src='$rows2[foto]' class='img-fluid'>";             $html .= "</a>";             $html .= "</div> <!-- end class_img -->";             $html .= "</div> <!-- end thumbnail col-sm-2- -->";          }          $html .= "</div> <!-- end class_container -->";          $html .= "</div> <!-- end panel body -->";         $html .= "</div> <!-- end panel panel-default -->";         $html .= "</div> <!-- end col -->";         $html .= "</div> <!-- end panel-body -->";         $html .= "</div> <!-- end panel panel-default -->";         $html .= "</div> <!-- end col-sm-12 -->";         $html .= "</div> <!-- end row -->";     }      mysqli_stmt_close($stmt);   // chiudo lo statement     mysqli_close($con);         // chiudo connessione        return $html; }

the code partially works because show result show 1 result , inside database have more results show doesn't work should.. may me find error?

it seems you're reusing same variables both external , internal loop. example, you're using $stmt both of them. i'm not sure if that's why you're getting 1 result (as may depend on amount of results received each of them), that.

as debug tip, remove code relevant external loop , first print out results of external ones properly. once have working, start adding internal loop code , make sure works. not reuse same variables though.


-

Comments

Post a Comment

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

Image
i'm using qt framework build graphical user interface. use qgridlayout position qwidgets neatly. gui looks this: my application regularly adds new widgets gui @ runtime. these new widgets not added @ end of qlayout, somewhere in middle. the procedure bit cumbersome. applied on figure above, need take out widg_c , widg_d , ... qgridlayout. next, add widg_x and widg_y , , put other widgets again. how remove widgets qgridlayout: for in reversed(range(mygridlayout.count())): self.itemat(i).widget().setparent(none) ### as long you're dealing small amount of widgets, procedure not disaster. in application display lot of small widgets - perhaps 50 or more! application freezes second while procedure ongoing, annoying user. there way insert widgets somewhere in qlayout, without need take out other widgets? edit: apparently solution qvboxlayout simple. use function insertwidget(..) instead of addwidget(..) . docs can found link: http://doc.qt.io/qt-5/qboxlayou
Read more

python - serve multiple gunicorn django instances under nginx ubuntu -

i need serve 2 webs apps (django) on gunicorn under different domain names using nginx on ubuntu. started using tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 it worked fine 1 using that. tried same thing second gives me 502 gateway second domain. tried following tutorial: http://michal.karzynski.pl/blog/2013/10/29/serving-multiple-django-applications-with-nginx-gunicorn-supervisor/ i'm @ part run gunicorn start script: sudo bin/gunicorn_start i response: starting webuildblack root traceback (most recent call last): file "/home/devin/webuildblack/bin/gunicorn", line 7, in <module> gunicorn.app.wsgiapp import run importerror: no module named 'gunicorn.app'; 'gunicorn' not package you have named program gunicorn.py gunicorn -package. rename file , remove gunicorn.pyc file.
Read more

module - Prestashop displayPaymentReturn hook url -

i new prestashop developer , trying create paymentmodule. have got show payment method can not proceed purchase because not know hot works. does know should redirect run hooddisplaypaymentreturn method? i happy if explain me complete navigation map make purchase. anyway, can find relation between hooks , pages? when have new module payment rely on simplest provided prestashop: bankwire. inside can find 3 hooks. hookpayment: public function hookpayment($params) { if (!$this->active) return; if (!$this->checkcurrency($params['cart'])) return; $this->smarty->assign(array( 'this_path' => $this->_path, 'this_path_bw' => $this->_path, 'this_path_ssl' => tools::getshopdomainssl(true, true).__ps_base_uri__.'modules/'.$this->name.'/' )); return $this->display(__file__, 'payment.tpl'); } hookdisplaypaymenteu: public fun
Read more