session_start();
if(!isset($_SESSION['udesig']) || $_SESSION['udesig']!="admin")
header("Location:loginmain.php");
include "head.inc";
if(!isset($_POST["Submit"]))
{
$usstates = array("AL","AK","AS","AZ","AR","CA","CO","CT","DE","DC","FM","FL","GA","GU","HI","ID","IL","IN","IA","KS","KY","LA","ME","MH","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","MP","OH","OK","OR","PW","PA","PR","RI","SC","SD","TN","TX","UT","VT","VI","VA","WA","WV","WI","WY");
?>
| ::. ADMINISTRATOR>>MAIN>>SEARCH CUSTOMER |
|
|
}
else
{
include "common.php";
dbconnect();
$customer_code = trim($_POST["customer_code"]);
$customer_lastname = trim($_POST["customer_lastname"]);
$sql = "select * from cust_profile where user_Type = 'c'";
if($customer_code!="")
$sql.= " and cust_Code like '$customer_code%'";
if($customer_lastname!="")
$sql.=" and last_Name like '$customer_lastname%'";
$sql.= " order by last_Name ASC";
$result = @mysql_query($sql);
if($result)
{
$numrows = mysql_num_rows($result);
?>
| ::. ADMINISTRATOR>>MAIN>>CUSTOMER(SEARCH RESULT) |
if($numrows<1)
{
?>
| No records available !! |
exit;
}
else
{
?>
while($row=mysql_fetch_row($result))
{
?>
|
=$row[0]?>
|
=$row[2]?>
|
=$row[3]?>
|
=$row[4]?>
|
=$row[5]?>
|
=$row[6]?>
|
=$row[7]?> |
=$row[8]?> |
=$row[9]?> |
=$row[10]?> |
=$row[11]?> |
=$row[12]?>
|
=$row[13]?>
|
$expdt = explode("-",$row[14]);
print $expdt[1]."-".$expdt[0];
?>
|
=$row[15]?>
|
=$row[16]?>
|
=$row[1]?> |
}
}
?>
|
}
else
{
print_msg("Process failed !!".mysql_error(),"admin_main.php");
}
}
include "foot.inc";
?>