[go: up one dir, main page]
Menu ▾ ▴

[r19]: / supplierTable.php  Maximize  Restore  History

Download this file

29 lines (25 with data), 1.6 kB 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
<?php 

include('includes/databaseLogin.php'); 

include('includes/installedLanguage.php'); 

echo "<!DOCTYPE html>";

?>



<html>

<head>

	<link rel="stylesheet" href="css/style.css" />

</head>



<body>

<?php

	if(isset($_POST[sCode])){

		echo "<table style=\"width: 100%;\">";

		echo "<tr><td style=\"width: 15%;\" align=\"center\"><b>" . _T("Name") . "</b></td><td style=\"width: 15%;\" align=\"center\"><b>" . _T("Referent") . "</b></td><td style=\"width: 15%;\" align=\"center\"><b>" . _T("Telephone") . "</b></td><td style=\"width: 15%;\" align=\"center\"><b>" . _T("Fax") . "</b></td><td style=\"width: 15%;\" align=\"center\"><b>" . _T("Mobile") . "</b></td><td style=\"width: 15%;\" align=\"center\"><b>" . _T("Website") . "</b></td></tr>";

		$getSuppliers = mysql_query("SELECT * FROM suppliers WHERE supplierName REGEXP '^$_POST[pName]' AND supplierReferent REGEXP '^$_POST[pReferent]'");

		while($row = mysql_fetch_array($getSuppliers)) {

			echo "<tr><td align=\"center\"><a class=\"aSupplierNominative\" name=\"" . $row[supplierId] . "\" href=\"#\">" . $row[supplierName] . "</a></td><td align=\"center\">" . $row[supplierReferent] . "</td><td align=\"center\">" . $row[supplierTelephone] . "</td><td align=\"center\">" . $row[supplierFax] . "</td><td align=\"center\">" . $row[supplierMobile] . "</td><td align=\"center\"><a class=\"aSupplierWebsite\" target=_blank href=\"http://" . $row[supplierWebsite] . "\">" . $row[supplierName] . "</a></td></tr>";

		}

		echo "</table>";

	}else{

		//ERROR

	}

?>

</body>

</html>