function GetDetail() { if (isset($_REQUEST["bid"])) { $con = new clscon(); $link = $con->db_Connect(); $bid = $_REQUEST["bid"]; $qry = "select * from tbbook where bookid={$bid}"; $res = mysqli_query($link, $qry); $output[] = "<table border=2>"; if ($r = mysqli_fetch_row($res)) { $output[] = "<tr>"; $output[] = "<td>"; $output[] = "<img src={$r['5']} width=70 height=100 >"; $output[] = "</td>"; $output[] = "<td>"; $output[] = "ID: {$r['0']} <br>"; $output[] = "Title: {$r['1']} <br>"; $output[] = "Author: {$r['2']} <br>"; $output[] = "Publisher: {$r['3']} <br>"; $output[] = "Price: {$r['4']} <br>"; $output[] = "<a href=cart.php?bid={$r['0']}&action=add>Add To Cart</a><br>"; $output[] = "</td>"; $output[] = "</tr>"; } $output[] = "</table>"; $con->db_Close(); } echo join($output); }
function Disp_Data() { $con = new clscon(); $link = $con->db_Connect(); $qry = "select * from tbbook"; $res = mysqli_query($link, $qry); $output[] = "<table border=2>"; $i = 1; while ($r = mysqli_fetch_row($res)) { $i++; if ($i == 2) { $output[] = '<tr>'; $i = 0; } $output[] = '<td>'; $output[] = "<img src={$r['5']} height=100 width=75 />"; $output[] = '</td>'; $output[] = '<td>'; $output[] = "Title: <a href=detail.php?bid={$r['0']}>{$r['1']} </a><br>"; $output[] = "Author: {$r['2']} <br>"; $output[] = "Pub: {$r['3']} <br>"; $output[] = "Prc: {$r['4']} <br>"; $output[] = "<a href=cart.php?bid={$r['0']}&action=add><img src=addtocart.jpg height=40 width=130 /></a> <br>"; $output[] = '</td>'; if ($i == 1) { $output[] = '</tr>'; } } $output[] = "</table>"; echo join($output); }