php - How to cycle through MySQL rows? -
i trying achieve web php program display data records in mysql database in html form. have couple of navigation buttons wish cycle next , previous records in database.
my problem is, can't seem cycle , forth through records. mysql_fetch_assoc gets 1 row or when comes while loop.
any appreciated! have far...
$page = intval($_get['page']); $limitstart = $page - 1; if($limitstart < 0) { $limitstart = 0; } $query = "select caleadid, region, siteaddr1, siteaddr2, siteaddr3, siteaddr4, sitepcode, "; $query .= "addgennotes, description, value, award, awardaddr1, awardaddr2, awardaddr3, awardaddr4, awardpcode, "; $query .= "phone_number, fax_number, fldawardedwebsite, fldawardedemail, contact_name, date tbltradesman_awarded 1"; $query .= ' limit ' . $limitstart . ',2'; $result = mysqli_query($connection, $query); confirm_query($result); $result_array = array(); while($row = mysqli_fetch_assoc($result)) { $result_array[] = $row; } if(intval($page) === 0) { $previousrecord = null; $currentrecord = $result_array[0]; $nextrecord = $result_array[1]; } else { $previousrecord = $result_array[0]; $currentrecord = $result_array[1]; $nextrecord = $result_array[2]; } if($previousrecord) { } if($nextrecord) { } ?> <?php $caleadid = $currentrecord['caleadid']; $region = $currentrecord['region']; $siteaddr1 = $currentrecord['siteaddr1']; $siteaddr2 = $currentrecord['siteaddr2']; $siteaddr3 = $currentrecord['siteaddr3']; $siteaddr4 = $currentrecord['siteaddr4']; $sitepcode = $currentrecord['sitepcode']; $addgennotes = $currentrecord['addgennotes']; $description = $currentrecord['description']; $value = $currentrecord['value']; $award = $currentrecord['award']; $awardaddr1 = $currentrecord['awardaddr1']; $awardaddr2 = $currentrecord['awardaddr2']; $awardaddr3 = $currentrecord['awardaddr3']; $awardaddr4 = $currentrecord['awardaddr4']; $awardpcode = $currentrecord['awardpcode']; $phone_number = $currentrecord['phone_number']; $fax_number = $currentrecord['fax_number']; $fldawardedwebsite = $currentrecord['fldawardedwebsite']; $fldawardedemail = $currentrecord['fldawardedemail']; $contact_name = $currentrecord['contact_name']; $date = $currentrecord['date']; ?> <div id="tradesmen_data"> <div id="primary"> <label for="caleadid">tradesman lead id: </label> <input type="text" name="caleadid" value="<?php echo $caleadid ?>" /> <label for="value">job value gbp: </label> <input type="text" name="value" value="<?php echo $value ?>" /> <label for="date">tradesman publish date: </label> <input type="text" name="date" value="<?php echo $date ?>" /> </div> <div class="columns"> <fieldset id="site"> <legend>site details</legend> <dl> <dt><label for="siteaddr1">site address: </label></dt> <dd><input type="text" name="siteaddr1" value="<?php echo $siteaddr1 ?>" /></dd> </dl> <dl> <dt><label></label></dt> <dd><input type="text" name="siteaddr2" value="<?php echo $siteaddr2 ?>" /></dd> </dl> <dl> <dt><label></label></dt> <dd><input type="text" name="siteaddr3" value="<?php echo $siteaddr3 ?>" /></dd> </dl> <dl> <dt><label></label></dt> <dd><input type="text" name="siteaddr4" value="<?php echo $siteaddr4 ?>" /></dd> </dl> <dl> <dt><label for="sitepcode">postcode: </label></dt> <dd><input type="text" name="sitepcode" value="<?php echo $sitepcode ?>" /></dd> </dl> <dl> <dt><label for="region">region: </label></dt> <dd><input type="text" name="region" value="<?php echo $region ?>" /></dd> </dl> <dl> <dt><label for="addgennotes">general notes: </label></dt> <dd><textarea rows="4" cols="30" name="addgennotes"><?php echo $addgennotes ?></textarea></dd> </dl> <dl> <dt><label for="description">description: </label></dt> <dd><textarea rows="4" cols="30" name="description"><?php echo $description ?></textarea></dd> </dl> </fieldset> </div> <div class="columns"> <fieldset id="contractor"> <legend>contractor details</legend> <dl> <dt><label for="award">awarded to: </label></dt> <dd><input type="text" name="award" value="<?php echo $award ?>" /></dd> </dl> <dl> <dt><label for="awardaddr1">address: </label></dt> <dd><input type="text" name="awardaddr1" value="<?php echo $awardaddr1 ?>" /></dd> </dl> <dl> <dt><label></label></dt> <dd><input type="text" name="awardaddr2" value="<?php echo $awardaddr2 ?>" /></dd> </dl> <dl> <dt><label></label></dt> <dd><input type="text" name="awardaddr3" value="<?php echo $awardaddr3 ?>" /></dd> </dl> <dl> <dt><label></label></dt> <dd><input type="text" name="awardaddr4" value="<?php echo $awardaddr4 ?>" /></dd> </dl> <dl> <dt><label for="awardpcode">postcode: </label></dt> <dd><input type="text" name="awardpcode" value="<?php echo $awardpcode ?>" /></dd> </dl> <dl> <dt><label for="phone_number">telephone: </label></dt> <dd><input type="text" name="phone_number" value="<?php echo $phone_number ?>" /></dd> </dl> <dl> <dt><label for="fax_number">fax: </label></dt> <dd><input type="text" name="fax_number" value="<?php echo $fax_number ?>" /></dd> </dl> <dl> <dt><label for="fldawardedwebsite">website: </label></dt> <dd><input type="text" name="fldawardedwebsite" value="<?php echo $fldawardedwebsite ?>" /></dd> </dl> <dl> <dt><label for="fldawardedemail">email: </label></dt> <dd><input type="text" name="fldawardedemail" value="<?php echo $fldawardedemail ?>" /></dd> </dl> <dl> <dt><label for="contact_name">contact name: </label></dt> <dd><input type="text" name="contact_name" value="<?php echo $contact_name ?>" /></dd> </dl> </fieldset> <?php $contact_made = true; if ($contact_made) { echo "<div id=\"contact_made\">"; echo "contact has been made"; echo "</div>"; } ?> </div> <div class="clear_float"></div> </div> <div id="tradesmen_data_navigation"> <a href="#"><input type="submit" name="previous" value="previous record" /></a> <a href="#"><input type="submit" name="view_lead" value="generate lead" /></a> <a href="#"><input type="submit" name="next" value="next record" /></a> </div>
the code untested, should point right direction.
the parameter page controls section of result set show set limit of query using value of page.
you select current record db previous , next. way, know if can generate link next/previous record in application.
$page = intval($_get['page']); $limitstart = $page - 1; if($limitstart < 0) { $limitstart = 0; } $query = "select caleadid, region, siteaddr1, siteaddr2, siteaddr3, siteaddr4, sitepcode, "; $query .= "addgennotes, description, value, award, awardaddr1, awardaddr2, awardaddr3, awardaddr4, awardpcode, "; $query .= "phone_number, fax_number, fldawardedwebsite, fldawardedemail, contact_name, date tbltradesman_awarded 1"; $query .= ' limit ' . $limitstart . ',3'; $result = mysqli_query($connection, $query); confirm_query($result); $result_array = array(); while($row = mysqli_fetch_assoc($result)) { $result_array[] = $row; } if(intval($page) === 0) { $previousrecord = null; $currentrecord = $result_array[0]; $nextrecord = $result_array[1]; } else { $previousrecord = $result_array[0]; $currentrecord = $result_array[1]; $nextrecord = $result_array[2]; } if($previousrecord) { $prevpage = $page - 1; if($prevpage < 0) { $pagepage = 0; } echo '<a href="index.php?page=' . $prevpage . '">previous</a>'; } if($nextrecord) { echo '<a href="index.php?page=' . ($page + 1) . '">next</a>'; }
Comments
Post a Comment