0
<html> 
<head> 
<basefont face="Arial"> 
</head> 
<style>
    body { background-color: #E6E6FA; }
</style>

<body>

<?php

error_reporting(E_ALL); 
if (!isset($_POST['Submit'])) { 
// form not submitted 
?>
<H3>Search Records Application</H3>
<form action="search.php" method="post"> 
Search <input type="text" name="search"> 
<select size="1" name="dropdown"> 
<option value="" selected>Search By...</option> 
<option value="BookID">Book Id</option> 
<option value="transactiondate">Transaction Date</option>
<option value="storename">Store Name</option>
<option value="checkdate">Check Date</option> 
<option value="datecashed">Date Cashed</option> 
<option value="datereturn">Date Return</option> 
<option value="checknumber">Check Number</option> 
<option value="makername">Maker Name</option> 
<option value="payeename">Payee Name</option> 
<option value="bankname">Bank Name</option> 
<option value="checkamount">Check Amount</option> 
<option value="returnreason">Return Reason</option> 
<option value="datesolved">Date Solved</option>
<option value="redeposited">Redeposited</option>
<option value="replacement">Replacement</option>
<option value="paidcash">Paid Cash</option>
<option value="balance">Balance</option>
<option value="disposition">Disposition</option>
</select> 
<input type="Submit" value="Submit" name="Submit"> 
</form>

<?php 
}

else {

// form submitted 
// set server access variables 
$host = "localhost"; 
$user = "root"; 
$pass = ""; 
$db = "books";

$search = empty($_POST['search'])? die ("ERROR: Enter Search Criteria") : mysql_escape_string($_POST['search']); 
$dropdown = empty($_POST['dropdown'])? die ("ERROR: Select from dropdown") : mysql_escape_string($_POST['dropdown']);

// Open Connection

$connect = mysql_connect($host, $user, $pass) or die ("Unable to connect to host");

//Select Database

mysql_select_db($db) or die ("Unable to connect to database");

//Create Query

$query = "SELECT * FROM books WHERE $dropdown='$search'" or die (mysql_error());

$result = mysql_query($query) or die (mysql_error());

$num=mysql_numrows($result);

mysql_close($connect);

echo "<b><center>Search Results of Bounced Checks</center></b><br><br>";


$i=0; 
while ($i < $num) {

$bookid=mysql_result($result,$i,"bookid"); 
$transactiondate=mysql_result($result,$i,"transactiondate"); 
$storename=mysql_result($result,$i,"storename"); 
$checkdate=mysql_result($result,$i,"checkdate"); 
$datecashed=mysql_result($result,$i,"datecashed"); 
$datereturn=mysql_result($result,$i,"datereturn"); 
$checknumber=mysql_result($result,$i,"checknumber"); 
$makername=mysql_result($result,$i,"makername"); 
$payeename=mysql_result($result,$i,"payeename"); 
$bankname=mysql_result($result,$i,"bankname"); 
$checkamount=mysql_result($result,$i,"checkamount"); 
$returnreason=mysql_result($result,$i,"returnreason");
$datesolved=mysql_result($result,$i,"datesolved");
$redeposited=mysql_result($result,$i,"redeposited");
$replacement=mysql_result($result,$i,"replacement");
$paidcash=mysql_result($result,$i,"paidcash");
$balance=mysql_result($result,$i,"balance");
$disposition=mysql_result($result,$i,"disposition");



echo "<table width = '1000' align = 'center' border ='1'>";

echo ("<tr><td>Check ID</td><td>Transaction Date</td><td>Store Name</td><td> Check Date</td><td>Date Cashed</td><td>Date Return</td><td>Check Number</td><td>Maker Name</td><td>Payee Name</td><td>Bank Name</td><td>Check Amount</td><td>Return Reason</td><td>Date Solved</td><td>Redeposited</td><td>Replacement</td><td>Paid Cash</td><td>Balance</td><td>Disposition</td></tr>");


    echo "</b></tr>";

echo "<tr>";
            echo "<td>".$bookid."</td>";
            echo "<td>".$transactiondate."</td>";
            //if you want the full date replace the $year_part_of_date[0] with $record->date
            echo "<td>".$storename."</td>";
            echo "<td>".$checkdate."</td>";
            echo "<td>".$datecashed."</td>";
            echo "<td>".$datereturn."</td>";
            echo "<td>".$checknumber."</td>";
            echo "<td>".$makername."</td>";
            echo "<td>".$payeename."</td>";
            echo "<td>".$bankname."</td>";
            echo "<td>".$checkamount."</td>";
            echo "<td>".$returnreason."</td>";
            echo "<td>".$datesolved."</td>";
            echo "<td>".$redeposited."</td>";
            echo "<td>".$replacement."</td>";
            echo "<td>".$paidcash."</td>";
            echo "<td>".$balance."</td>";
            echo "<td>".$disposition."</td>";


echo "</tr>";
echo "</table>";



$i++;

} 
} 
?>

</body> 
</html> 
4
Contributors
6
Replies
12
Views
5 Years
Discussion Span
Last Post by tonyfonseca
0
Yes. My table is repeating the headers information every time it shows a row result.
for exemplo: checkdate, checkamount...
             2012-10-01,  123.00 ....
             checkdate, checkamount...
             2012-10-02,  124.00 ....
 It must be one header only like:
             checkdate, checkamount...
             2012-10-01,  123.00 ....
             2012-10-02,  124.00 ....
 Can you please help me fix the code?
 Thanks
0

Check this

else {

// form submitted 
// set server access variables 
$host = "localhost"; 
$user = "root"; 
$pass = ""; 
$db = "books";

$search = empty($_POST['search'])? die ("ERROR: Enter Search Criteria") : mysql_escape_string($_POST['search']); 
$dropdown = empty($_POST['dropdown'])? die ("ERROR: Select from dropdown") : mysql_escape_string($_POST['dropdown']);

// Open Connection

$connect = mysql_connect($host, $user, $pass) or die ("Unable to connect to host");

//Select Database

mysql_select_db($db) or die ("Unable to connect to database");

//Create Query

$query = "SELECT * FROM books WHERE $dropdown='$search'" or die (mysql_error());

$result = mysql_query($query) or die (mysql_error());

$num=mysql_numrows($result);

mysql_close($connect);

echo "<b><center>Search Results of Bounced Checks</center></b><br><br>";

echo "<table width = '1000' align = 'center' border ='1'>";

echo "<tr><td>Check ID</td><td>Transaction Date</td><td>Store Name</td><td> Check Date</td><td>Date Cashed</td><td>Date Return</td><td>Check Number</td><td>Maker Name</td><td>Payee Name</td><td>Bank Name</td><td>Check Amount</td><td>Return Reason</td><td>Date Solved</td><td>Redeposited</td><td>Replacement</td><td>Paid Cash</td><td>Balance</td><td>Disposition</td></tr>";


$i=0; 
while ($i < $num) {

$bookid=mysql_result($result,$i,"bookid"); 
$transactiondate=mysql_result($result,$i,"transactiondate"); 
$storename=mysql_result($result,$i,"storename"); 
$checkdate=mysql_result($result,$i,"checkdate"); 
$datecashed=mysql_result($result,$i,"datecashed"); 
$datereturn=mysql_result($result,$i,"datereturn"); 
$checknumber=mysql_result($result,$i,"checknumber"); 
$makername=mysql_result($result,$i,"makername"); 
$payeename=mysql_result($result,$i,"payeename"); 
$bankname=mysql_result($result,$i,"bankname"); 
$checkamount=mysql_result($result,$i,"checkamount"); 
$returnreason=mysql_result($result,$i,"returnreason");
$datesolved=mysql_result($result,$i,"datesolved");
$redeposited=mysql_result($result,$i,"redeposited");
$replacement=mysql_result($result,$i,"replacement");
$paidcash=mysql_result($result,$i,"paidcash");
$balance=mysql_result($result,$i,"balance");
$disposition=mysql_result($result,$i,"disposition");

echo "<tr>";
            echo "<td>".$bookid."</td>";
            echo "<td>".$transactiondate."</td>";
            echo "<td>".$storename."</td>";
            echo "<td>".$checkdate."</td>";
            echo "<td>".$datecashed."</td>";
            echo "<td>".$datereturn."</td>";
            echo "<td>".$checknumber."</td>";
            echo "<td>".$makername."</td>";
            echo "<td>".$payeename."</td>";
            echo "<td>".$bankname."</td>";
            echo "<td>".$checkamount."</td>";
            echo "<td>".$returnreason."</td>";
            echo "<td>".$datesolved."</td>";
            echo "<td>".$redeposited."</td>";
            echo "<td>".$replacement."</td>";
            echo "<td>".$paidcash."</td>";
            echo "<td>".$balance."</td>";
            echo "<td>".$disposition."</td>";


echo "</tr>";
$i++;
} 
echo "</table>";
} 
?>

</body> 
</html> 
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.