php programmers nimestack msaada

willy ze great

willy ze great

JF-Expert Member
Apr 30, 2013
1,069
1,302
nafanya my project ya kubid vifaa sasa hapa nachotaka hili file la kwanza mtu akibid now ieende "orderform.php" tatizo ni hilo fail la pili inaexecute 'tv' na linaretrive data za watu waliobid "tv" kwenye database tatizo akibid "watch" au vitu vingine inaleta table bila data ila nikitoa kwenye mfumo wa if....elseif inaretrive viizuri tu na mi nachotaka akibid mfano laptop iretrive bidhaa za watch tu msaada nimekwama
<html>
<div id="col2">
<form action="orderform.php" method="post">
<img src="images/watches.jpeg" width="238" height="212" />watch<br/>
&nbsp;&nbsp;50,000 T.sh &nbsp;&nbsp;bids 8<br />
<input type="submit" name="watch" class="but2" value="bid now">
</form>
</div>
<div id="col3">
<form action="orderform.php" method="post">
<img src="images/computer.jpeg" width="269" height="187" /> laptop<br/>
&nbsp;&nbsp;600,000 T.sh &nbsp;&nbsp;bids 3<br />
<input type="submit" name="laptop" class="but2" value="bid now">
</form>
</div>
</html>






<div id="col1">
<form action="orderform.php" method="post">
<img src="images/1.png" width="236" height="213"/>table<br/>
&nbsp;&nbsp;200,000 T.sh &nbsp;&nbsp;<br />
<input type="submit" name="table" class="but2" value="bid now">
</form>
</div>
<div id="col2">
<form action="orderform.php" method="post">
<img src="images/6.jpg" width="238" height="212" />lokoko table<br/>
&nbsp;&nbsp;150,000 T.sh &nbsp;&nbsp;<br />
<input type="submit" name="lokoko table" class="but2" value="bid now">
</form>
</div>





<?php
$host="localhost";
$user="root";
$password="";
$database="online";
$link= mysqli_connect($host, $user, $password,$database);

if(isset($_POST['tv'])){
$query="select * from registration where product='tv';";
$result= mysqli_query($link, $query);
echo "<table border='1' bgcolor='WHITE'>";
echo "<caption>HIGHEST RANK BIDDER'S TABLE</caption>";
echo "<tr><th>BIDDER NAME</th><th>PRODUCT</th><th>DATE</th>
<th>QUANTITY</th><th>PRICE</th></tr>";
while ($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>".$row['username']."</td>";
echo "<td>".$row['product']."</td>";
echo "<td>".$row['date']."</td>";
echo "<td>".$row['qty']."</td>";
echo "<td>".$row['price']."</td>";
echo "</tr>";
}
echo "</table>";

}elseif(isset ($_post['laptop'])){
$query="select * from registration where product='laptop';";
$result= mysqli_query($link, $query);
echo "<table border='1' bgcolor='WHITE'>";
echo "<caption>HIGHEST RANK BIDDER'S TABLE</caption>";
echo "<tr><th>BIDDER NAME</th><th>PRODUCT</th><th>DATE</th>
<th>QUANTITY</th><th>PRICE</th></tr>";
while ($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>".$row['username']."</td>";
echo "<td>".$row['product']."</td>";
echo "<td>".$row['date']."</td>";
echo "<td>".$row['qty']."</td>";
echo "<td>".$row['price']."</td>";
echo "</tr>";
}
echo "</table>";
}elseif (isset($_post['watch'])){
$query="select * from registration where product='watch';";
$result= mysqli_query($link, $query);
echo "<table border='1' bgcolor='WHITE'>";
echo "<caption>HIGHEST RANK BIDDER'S TABLE</caption>";
echo "<tr><th>BIDDER NAME</th><th>PRODUCT</th><th>DATE</th>
<th>QUANTITY</th><th>PRICE</th></tr>";
while ($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>".$row['username']."</td>";
echo "<td>".$row['product']."</td>";
echo "<td>".$row['date']."</td>";
echo "<td>".$row['qty']."</td>";
echo "<td>".$row['price']."</td>";
echo "</tr>";
}
echo "</table>";
}elseif (isset($_post['ipnone'])){
$query="select * from registration where product='iphone';";
$result= mysqli_query($link, $query);
echo "<table border='1' bgcolor='WHITE'>";
echo "<caption>HIGHEST RANK BIDDER'S TABLE</caption>";
echo "<tr><th>BIDDER NAME</th><th>PRODUCT</th><th>DATE</th>
<th>QUANTITY</th><th>PRICE</th></tr>";
while ($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>".$row['username']."</td>";
echo "<td>".$row['product']."</td>";
echo "<td>".$row['date']."</td>";
echo "<td>".$row['qty']."</td>";
echo "<td>".$row['price']."</td>";
echo "</tr>";
}
echo "</table>";
}elseif (isset($_post['shoes'])){
$query="select * from registration where product='shoes';";
$result= mysqli_query($link, $query);
echo "<table border='1' bgcolor='WHITE'>";
echo "<caption>HIGHEST RANK BIDDER'S TABLE</caption>";
echo "<tr><th>BIDDER NAME</th><th>PRODUCT</th><th>DATE</th>
<th>QUANTITY</th><th>PRICE</th></tr>";
while ($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>".$row['username']."</td>";
echo "<td>".$row['product']."</td>";
echo "<td>".$row['date']."</td>";
echo "<td>".$row['qty']."</td>";
echo "<td>".$row['price']."</td>";
echo "</tr>";
}
echo "</table>";
}elseif (isset($_post['house'])){
$query="select * from registration where product='house';";
$result= mysqli_query($link, $query);
echo "<table border='1' bgcolor='WHITE'>";
echo "<caption>HIGHEST RANK BIDDER'S TABLE</caption>";
echo "<tr><th>BIDDER NAME</th><th>PRODUCT</th><th>DATE</th>
<th>QUANTITY</th><th>PRICE</th></tr>";
while ($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>".$row['username']."</td>";
echo "<td>".$row['product']."</td>";
echo "<td>".$row['date']."</td>";
echo "<td>".$row['qty']."</td>";
echo "<td>".$row['price']."</td>";
echo "</tr>";
}
echo "</table>";
}elseif (isset($_post['samsung'])){
$query="select * from registration where product='samsung';";
$result= mysqli_query($link, $query);
echo "<table border='1' bgcolor='WHITE'>";
echo "<caption>HIGHEST RANK BIDDER'S TABLE</caption>";
echo "<tr><th>BIDDER NAME</th><th>PRODUCT</th><th>DATE</th>
<th>QUANTITY</th><th>PRICE</th></tr>";
while ($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>".$row['username']."</td>";
echo "<td>".$row['product']."</td>";
echo "<td>".$row['date']."</td>";
echo "<td>".$row['qty']."</td>";
echo "<td>".$row['price']."</td>";
echo "</tr>";
}
 
You must log in or register to reply here.

Similar Discussions

Back
Top Bottom
Forums
New posts
Post thread
Back