Location: PHPKode > projects > Shell Providers Customer/Accounts DB > shelldb/process/bill_search.php
<?php include("$DOCUMENT_ROOT/includes/includes.php"); ?> 

<!-- Head -->
<?php include("$DOCUMENT_ROOT/style/head.php"); ?> 

<!-- Navbar -->
<?php include("$DOCUMENT_ROOT/includes/navbar.php"); ?>

<!-- End of NavBar -->

<IMG height=5 alt="" src="/images/blank.gif" width=100><BR>

<!-- Body of Page -->

<?php include("$DOCUMENT_ROOT/style/page-body.php"); ?>

<?php
			  
if(!is_user()) {
echo '<a href="/login.php">Sorry please login</a>';
exit;
}

			  /* Connect To Database */
			 
			  mysql_connect ($shelldb_host, $shelldb_user, $shelldb_pass);
			  mysql_select_db ($shelldb_db);
			  
			 /* Determain what to search for and where */
			  
			  $query = mysql_query("SELECT * FROM bill order by bill_date");
			   
			  
			 
			 /* Determain Number Of Results */
			 
			 $num_results = mysql_num_rows($query); 
			 echo "Number of  Results Found: <B> $num_results </B><BR>";
			  
			 /* Print Results */
			 
			 for ($i=0; $i <$num_results; $i++)
			 {
			 	$row = mysql_fetch_array($query);
				echo "<p><strong>".($i+1).". Bill Id: ";
				echo htmlspecialchars( stripslashes($row["bill_id"]));
				echo "</strong><BR> Bill Amount:";
				echo htmlspecialchars( stripslashes($row["bill_amount"])) . " " . htmlspecialchars( stripslashes($row["bill_currency"])) ;
				echo "<BR> Bill Paid: ";
				echo htmlspecialchars( stripslashes($row["bill_paid"]));
				echo "<BR> Account ID: ";
				$ID = htmlspecialchars( stripslashes($row["acc_id"]));
				echo '<A HREF="/reports/acc_info.php?id='. $ID .'">' . $ID . '</A>';
				echo "<BR> Bill Date: ";
				echo htmlspecialchars( stripslashes($row["bill_date"]));
			 }
			 
			 ?>

<!-- End of Body -->


<!-- End of Body -->

<?php include("$DOCUMENT_ROOT/style/page-body-end.php"); ?>

<!-- themed page footer -->

<?php include("$DOCUMENT_ROOT/includes/footer.php"); ?>

<?php include("$DOCUMENT_ROOT/style/footer.php"); ?>

             
			
Return current item: Shell Providers Customer/Accounts DB