mysql - echo PHP array with while loop -


i'm using while loop echo php array :

$connect = mysqli_connect("localhost", "user", "password", "db"); $sql = "select * table order rand() limit 0,4"; $result = mysqli_query($connect, $sql);  if(mysqli_num_rows($result) > 0) {  echo'<section>         <div class="container">            <div class="row">              <h2 class="bold">title</h2>                <hr> ';                  while($row = mysqli_fetch_array($result))                 {                  echo'                 <div class="col-sm-3 col-md-3 col-md-push-3">                     <div class="portfolio-wrapper">                            <div class="portfolio-single">                             <div class="portfolio-thumb">                                 <a href="'.$row['link']." target="_blank">                                                        <img src="'.$row['image'].'" class="img-responsive" alt="'.$row['alt']."></a>                             </div>                         </div>                         <div class="portfolio-info" dir="rtl">                             <a href="'.$row['link2']." target="_self"><h2>                     </h2>                                 <h6>'.$row['title'].</h6>                             </a>                         </div>                     </div>                 </div>';              }                 echo'                 </div>                     </div>                     </section';             }                 ?>

this code works fine me problem need echo 4 different

for example :

   first be: <div class="col-sm-3 col-md-3 col-md-push-9">    second: <div class="col-sm-3 col-md-3 col-md-push-3">    third: <div class="col-sm-3 col-md-3 col-md-pull-3">    last: <div class="col-sm-3 col-md-3 col-md-pull-9">

any ideas how can accomplish structure using while loop ?

use counter, , put classes array this:

$classes = [     "col-sm-3 col-md-3 col-md-push-9",     "col-sm-3 col-md-3 col-md-push-3",     "col-sm-3 col-md-3 col-md-pull-3",     "col-sm-3 col-md-3 col-md-pull-9" ];  $i = 0; while($row = mysqli_fetch_array($result)) {     if ($i > 3) {         $i = 0;     }     ?>     <div class="<?php echo $classes[$i]; ?>">         content comes here     </div>     <?php     $i++; }

note

this resets counter, if there no index in array. script assumes, 4 rows.


-

Comments

Post a Comment

Popular posts from this blog

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more