Page 1 of 1

shopping cart

Posted: Mon Sep 27, 2010 4:07 am
by rahul1226
hi ya..

this is rahul.....
i need a on-line shopping cart PHP,MySQL code as soon as possible...

cheers..

Re: shopping cart

Posted: Mon Sep 27, 2010 4:13 am
by amargharat
You can use open source cms for shopping cart

visit www.oscommerce.com and download

Re: shopping cart

Posted: Mon Sep 27, 2010 1:59 pm
by arunkusa
hi rahul. dis ia arun kusa.
here is the code for u.....

just try it..
if u have any doubt let me know...

<?php

include ("./common.php");
include ("./Header.php");
include ("./Footer.php");
session_start();
$sFileName = "ShoppingCart.php";
check_security(1);
$sAction = get_param("FormAction");
$sForm = get_param("FormName");
$sMemberErr = "";
switch ($sForm) {
case "Member":
Member_action($sAction);
break;
}

?><html>
<head>
<title>Pet Store</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="cache-control" content="no-cache">
<link href="css.css" rel="stylesheet" type="text/css" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"></head>
<body style="background-color: #FFFFFF; color: #000000; font-family: Arial, Tahoma, Verdana, Helveticabackground-color: #FFFFFF; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica">

<center>
<table>
<tr>
<td valign="top">
<?php Menu_show() ?>

</td>
</tr>
</table>
</center>
<table width="760" align="center">
<tr>
<td align="center">
<hr color="#800000">
<table>
<tr>
<td valign="top">
<?php Member_show() ?> </td>
<td valign="top">
<?php Items_show() ?>

<?php Total_show() ?> </td>
</tr>
</table>

<p><a href="PayBill.php"><img src="images/pay.JPG"/></a></p>
<hr color="#800000" width="60%"></td>
</tr>
</table>
<center>
<table>
<tr>
<td valign="top">
<?php Footer_show() ?>
</td>

</tr>
</table>
</center>

</body>
</html>
<?php

// ShoppingCart Show end

//===============================
// ShoppingCart Close Event begin
// ShoppingCart Close Event end
//===============================
//********************************************************************************


//===============================
// Display Grid Form
//-------------------------------
function Items_show()
{
//-------------------------------
// Initialize variables
//-------------------------------


global $db;
global $sItemsErr;
global $sFileName;
global $styles;
$sWhere = "";
$sOrder = "";
$sSQL = "";
$sFormTitle = "Items";
$HasParam = false;
$bReq = true;
$iRecordsPerPage = 20;
$iCounter = 0;

$transit_params = "";
$form_params = "";

//-------------------------------
// HTML column headers
//-------------------------------
?>
<table style="width:100%">
<tr>
<td style="background-color: #336699; text-align: Center; border-style: outset; border-width: 1" colspan="6"><a name="Items"><font style="font-size: 12pt; color: #FFFFFF; font-weight: bold"><?=$sFormTitle?></font></a></td>
</tr>
<tr>
<td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><font style="font-size: 10pt; color: #CE7E00; font-weight: bold">Details</td>
<td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><font style="font-size: 10pt; color: #CE7E00; font-weight: bold">Order #</td>
<td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><font style="font-size: 10pt; color: #CE7E00; font-weight: bold">Item</td>
<td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><font style="font-size: 10pt; color: #CE7E00; font-weight: bold">Price</td>
<td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><font style="font-size: 10pt; color: #CE7E00; font-weight: bold">Quantity</td>
<td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><font style="font-size: 10pt; color: #CE7E00; font-weight: bold">Total</td>
</tr>
<?

//-------------------------------
// Build WHERE statement
//-------------------------------
$pUserID = get_session("UserID");
if(is_number($pUserID) && strlen($pUserID))
$pUserID = tosql($pUserID, "Number");
else
$pUserID = "";

if(strlen($pUserID))
{
$HasParam = true;
$sWhere = $sWhere . "member_id=" . $pUserID;
}
else
{
$bReq = false;
}


if($HasParam)
$sWhere = " AND (" . $sWhere . ")";


//-------------------------------
// Build base SQL statement
//-------------------------------
$sSQL = "SELECT order_id, name, price, quantity, member_id, quantity*price as sub_total FROM items, orders WHERE orders.item_id=items.item_id";
$sOrder = " ORDER BY order_id";
//-------------------------------

//-------------------------------
// Items Open Event begin
// Items Open Event end
//-------------------------------

//-------------------------------
// Assemble full SQL statement
//-------------------------------
$sSQL .= $sWhere . $sOrder;
//-------------------------------



//-------------------------------
// Process if form has all required parameters
//-------------------------------
if(!$bReq)
{
?>
<tr>
<td colspan="6" style="background-color: #FFFFFF; border-width: 1"><font style="font-size: 10pt; color: #000000">No records</font></td>
</tr>
</table>
<?
return;
}
//-------------------------------

//-------------------------------
// Execute SQL statement
//-------------------------------
$db->query($sSQL);
$next_record = $db->next_record();
//-------------------------------
// Process empty recordset
//-------------------------------
if(!$next_record)
{
?>
<tr>
<td colspan="6" style="background-color: #FFFFFF; border-width: 1"><font style="font-size: 10pt; color: #000000">No records</font></td>
</tr>
<?

?>
</table>
<?

return;
}

//-------------------------------

//-------------------------------
// Initialize page counter and records per page
//-------------------------------
$iRecordsPerPage = 20;
$iCounter = 0;
//-------------------------------

//-------------------------------
// Display grid based on recordset
//-------------------------------
while($next_record && $iCounter < $iRecordsPerPage)
{
//-------------------------------
// Create field variables based on database fields
//-------------------------------
$fldField1_URLLink = "ShoppingCartRecord.php";
$fldField1_order_id = $db->f("order_id");
$flditem_id = $db->f("name");
$fldorder_id = $db->f("order_id");
$fldprice = $db->f("price");
$fldquantity = $db->f("quantity");
$fldsub_total = $db->f("sub_total");
$fldField1= "Details";
$next_record = $db->next_record();


?>
<tr>
<td style="background-color: #FFFFFF; border-width: 1"><font style="font-size: 10pt; color: #000000"><a href="<?=$fldField1_URLLink?>?order_id=<?=$fldField1_order_id?>&<?= $transit_params ?>"><font style="font-size: 10pt; color: #000000"><?=$fldField1?></font></a>&nbsp;</font></td>
<td style="background-color: #FFFFFF; border-width: 1"><font style="font-size: 10pt; color: #000000">
<?= tohtml($fldorder_id) ?>&nbsp;</font></td>
<td style="background-color: #FFFFFF; border-width: 1"><font style="font-size: 10pt; color: #000000">
<?= tohtml($flditem_id) ?>&nbsp;</font></td>
<td style="background-color: #FFFFFF; border-width: 1"><font style="font-size: 10pt; color: #000000">
<?= tohtml($fldprice) ?>&nbsp;</font></td>
<td style="background-color: #FFFFFF; border-width: 1"><font style="font-size: 10pt; color: #000000">
<?= tohtml($fldquantity) ?>&nbsp;</font></td>
<td style="background-color: #FFFFFF; border-width: 1"><font style="font-size: 10pt; color: #000000">
<?= tohtml($fldsub_total) ?>&nbsp;</font></td>
</tr><?


$iCounter++;
}




?>
</table>
<?



}

function Total_show()
{
//-------------------------------
// Initialize variables
//-------------------------------


global $db;
global $sTotalErr;
global $sFileName;
global $styles;
$sWhere = "";
$sOrder = "";
$sSQL = "";
$sFormTitle = "";
$HasParam = false;
$bReq = true;
$iRecordsPerPage = 20;
$iCounter = 0;

$transit_params = "";
$form_params = "";

//-------------------------------
// HTML column headers
//-------------------------------
?>
<table style="width:100%">
<tr>
<td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><font style="font-size: 10pt; color: #CE7E00; font-weight: bold">Total</td>
</tr>
<?

//-------------------------------
// Build WHERE statement
//-------------------------------
$pUserID = get_session("UserID");
if(is_number($pUserID) && strlen($pUserID))
$pUserID = tosql($pUserID, "Number");
else
$pUserID = "";

if(strlen($pUserID))
{
$HasParam = true;
$sWhere = $sWhere . "member_id=" . $pUserID;
}
else
{
$bReq = false;
}


if($HasParam)
$sWhere = " AND (" . $sWhere . ")";


//-------------------------------
// Build base SQL statement
//-------------------------------
$sSQL = "SELECT member_id, sum(quantity*price) as sub_total FROM items, orders WHERE orders.item_id=items.item_id";
$sOrder = " GROUP BY member_id";
//-------------------------------

//-------------------------------
// Total Open Event begin
// Total Open Event end
//-------------------------------

//-------------------------------
// Assemble full SQL statement
//-------------------------------
$sSQL .= $sWhere . $sOrder;
//-------------------------------



//-------------------------------
// Process if form has all required parameters
//-------------------------------
if(!$bReq)
{
?>
<tr>
<td colspan="1" style="background-color: #FFFFFF; border-width: 1"><font style="font-size: 10pt; color: #000000">No records</font></td>
</tr>
</table>
<?
return;
}
//-------------------------------

//-------------------------------
// Execute SQL statement
//-------------------------------
$db->query($sSQL);
$next_record = $db->next_record();
//-------------------------------
// Process empty recordset
//-------------------------------
if(!$next_record)
{
?>
<tr>
<td colspan="1" style="background-color: #FFFFFF; border-width: 1"><font style="font-size: 10pt; color: #000000">No records</font></td>
</tr>
<?

?>
</table>
<?

return;
}

//-------------------------------

//-------------------------------
// Initialize page counter and records per page
//-------------------------------
$iRecordsPerPage = 20;
$iCounter = 0;
//-------------------------------

//-------------------------------
// Display grid based on recordset
//-------------------------------
while($next_record && $iCounter < $iRecordsPerPage)
{
//-------------------------------
// Create field variables based on database fields
//-------------------------------
$fldsub_total = $db->f("sub_total");
$next_record = $db->next_record();

//-------------------------------
// Total Show begin
//-------------------------------

//-------------------------------
// Total Show Event begin
// Total Show Event end
//-------------------------------


//-------------------------------
// Process the HTML controls
//-------------------------------
?>
<tr>
<td style="background-color: #FFFFFF; border-width: 1"><font style="font-size: 10pt; color: #000000">
<?= round(tohtml($fldsub_total), 3) ?> &nbsp;</font></td>
<input type="hidden" name = "total" value="<?= round(tohtml($fldsub_total), 3) ?>">
<? $total = round(tohtml($fldsub_total), 3);
set_session("tt",$total);
?>
</tr><?
//-------------------------------
// Total Show end
//-------------------------------

//-------------------------------
// Move to the next record and increase record counter
//-------------------------------

$iCounter++;
}



//-------------------------------
// Finish form processing
//-------------------------------
?>
</table>
<?


//-------------------------------
// Total Close Event begin
// Total Close Event end
//-------------------------------
}
//===============================


//===============================
// Action of the Record Form
//-------------------------------
function Member_action($sAction)
{
//-------------------------------
// Initialize variables
//-------------------------------
global $db;

global $sForm;
global $sMemberErr;
global $styles;
$bExecSQL = true;
$sActionFileName = "";
$sParams = "?";
$sWhere = "";
$bErr = false;
$pPKmember_id = "";
//-------------------------------

//-------------------------------
// Member Action begin
//-------------------------------
$sActionFileName = "AdminMenu.php";
$sParams .= "UserID=" . urlencode(get_param("Trn_UserID"));

//-------------------------------
// Load all form fields into variables
//-------------------------------
$fldUserID = get_session("UserID");
//-------------------------------
// Member BeforeExecute Event begin
// Member BeforeExecute Event end
//-------------------------------

//-------------------------------
// Execute SQL statement
//-------------------------------
if(strlen($sMemberErr)) return;
if($bExecSQL)
$db->query($sSQL);
header("Location: " . $sActionFileName . $sParams);

//-------------------------------
// Member Action end
//-------------------------------
}

//===============================
// Display Record Form
//-------------------------------
function Member_show()
{
global $db;

global $sAction;
global $sForm;
global $sFileName;
global $sMemberErr;
global $styles;

$fldmember_id = "";
$fldmember_login = "";
$fldname = "";
$fldlast_name = "";
$fldaddress = "";
$fldemail = "";
$fldphone = "";
//-------------------------------
// Member Show begin
//-------------------------------
$sFormTitle = "User Information";
$sWhere = "";
$bPK = true;

?>

<table style="width:100%">

<tr><td style="background-color: #336699; text-align: Center; border-style: outset; border-width: 1" colspan="2"><font style="font-size: 12pt; color: #FFFFFF; font-weight: bold"><?=$sFormTitle?></font></td></tr>
<? if ($sMemberErr) { ?>
<tr><td style="background-color: #FFFFFF; border-width: 1" colspan="2"><font style="font-size: 10pt; color: #000000"><?= $sMemberErr ?></font></td></tr>
<? } ?>
<?

//-------------------------------
// Load primary key and form parameters
//-------------------------------
if($sMemberErr == "")
{
}
else
{
$fldmember_id = strip(get_param("member_id"));
}
//-------------------------------

//-------------------------------
// Load all form fields

//-------------------------------

//-------------------------------
// Build WHERE statement
//-------------------------------

$pmember_id = get_session("UserID");
if( !strlen($pmember_id)) $bPK = false;

$sWhere .= "member_id=" . tosql($pmember_id, "Number");
//-------------------------------
//-------------------------------
// Member Open Event begin
// Member Open Event end
//-------------------------------

//-------------------------------
// Build SQL statement and execute query
//-------------------------------
$sSQL = "select * from members where " . $sWhere;
// Execute SQL statement
$db->query($sSQL);
$bIsUpdateMode = ($bPK && !($sAction == "insert" && $sForm == "Member") && $db->next_record());
//-------------------------------

//-------------------------------
// Load all fields into variables from recordset or input parameters
//-------------------------------
if($bIsUpdateMode)
{
$fldaddress = $db->f("address");
$fldemail = $db->f("email");
$fldname = $db->f("first_name");
set_session("fn",$fldname);
$fldlast_name = $db->f("last_name");
set_session("fl",$fldlast_name);
$fldmember_id = $db->f("member_id");
$fldmember_login_URLLink = "MyInfo.php";
$fldmember_login = $db->f("member_login");
$fldphone = $db->f("phone");
set_session("ph",$fldphone);
$cno = $db->f("card_number");
set_session("cno",$cno);
$ct = $db->f("card_type_id");
if($ct==1){
set_session("ct","American Express");
}
if($ct==2)
set_session("ct","VISA");

//-------------------------------
// Member ShowEdit Event begin
// Member ShowEdit Event end
//-------------------------------
}
else
{
if($sMemberErr == "")
{
$fldmember_id = tohtml(get_session("UserID"));
}
//-------------------------------
// Member ShowInsert Event begin
// Member ShowInsert Event end
//-------------------------------
}
//-------------------------------
// Member Show Event begin
// Member Show Event end
//-------------------------------

//-------------------------------
// Show form field
//-------------------------------
?>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Login</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000"><a href="<?=$fldmember_login_URLLink?>?<?= $transit_params ?>"><font style="font-size: 10pt; color: #000000"><?=$fldmember_login?></font></a>&nbsp;</font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">First Name</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000">
<?= tohtml($fldname) ?>&nbsp;</font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Last Name</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000">
<?= tohtml($fldlast_name) ?>&nbsp;</font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Address</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000">
<?= tohtml($fldaddress) ?>&nbsp;</font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Email</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000">
<?= tohtml($fldemail) ?>&nbsp;</font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Phone</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000">
<?= tohtml($fldphone) ?>&nbsp;</font>
</td>
</tr>
<tr><td colspan="2" align="right">
<input type="hidden" name="FormName" value="Member">
<input type="hidden" name="Trn_UserID" value="<?= $trn_UserID ?>">
<input type="hidden" name="PK_member_id" value="<?= $pmember_id ?>">
<input type="hidden" name="member_id" value="<?= tohtml($fldmember_id)?>">
</td></tr>

</table>
<?



//-------------------------------
// Member Close Event begin
// Member Close Event end
//-------------------------------

//-------------------------------
// Member Show end
//-------------------------------
}
//===============================
?>
<?php
/*********************************************************************************
* Filename: MyInfo.php


*********************************************************************************/

//-------------------------------
// MyInfo CustomIncludes begin

include ("./common.php");
include ("./Header.php");
include ("./Footer.php");

// MyInfo CustomIncludes end
//-------------------------------

session_start();

//===============================
// Save Page and File Name available into variables
//-------------------------------
$sFileName = "MyInfo.php";
//===============================


//===============================
// MyInfo PageSecurity begin
check_security(1);
// MyInfo PageSecurity end
//===============================

//===============================
// MyInfo Open Event begin
// MyInfo Open Event end
//===============================

//===============================
// MyInfo OpenAnyPage Event start
// MyInfo OpenAnyPage Event end
//===============================

//===============================
//Save the name of the form and type of action into the variables
//-------------------------------
$sAction = get_param("FormAction");
$sForm = get_param("FormName");
//===============================

// MyInfo Show begin

//===============================
// Perform the form's action
//-------------------------------
// Initialize error variables
//-------------------------------
$sFormErr = "";

//-------------------------------
// Select the FormAction
//-------------------------------
switch ($sForm) {
case "Form":
Form_action($sAction);
break;
}
//===============================

//===============================
// Display page

//===============================
// HTML Page layout
//-------------------------------
?><html>
<head>
<title>Pet Store</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"></head>
<body style="background-color: #FFFFFF; color: #000000; font-family: Arial, Tahoma, Verdana, Helveticabackground-color: #FFFFFF; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica">
<center>
<table>
<tr>
<td valign="top">
<?php Menu_show() ?>

</td>
</tr>
</table>
</center>
<table width="760" align="center">
<tr>
<td align="center">
<hr color="#800000">
<table>
<tr>

<td valign="top">
<?php Form_show() ?>

</td>
</tr>
</table>

<hr color="#800000" width="60%">
</td>
</tr>
</table>
<center>
<table>
<tr>
<td valign="top">
<?php Footer_show() ?>
</td>

</tr>
</table>
</center>
</body>
</html>
<?php

// MyInfo Show end

//===============================
// MyInfo Close Event begin
// MyInfo Close Event end
//===============================
//********************************************************************************


//===============================
// Action of the Record Form
//-------------------------------
function Form_action($sAction)
{
//-------------------------------
// Initialize variables
//-------------------------------
global $db;

global $sForm;
global $sFormErr;
global $styles;
$bExecSQL = true;
$sActionFileName = "";
$sWhere = "";
$bErr = false;
$pPKmember_id = "";
$fldmember_password = "";
$fldname = "";
$fldlast_name = "";
$fldemail = "";
$fldaddress = "";
$fldphone = "";
$fldnotes = "";
$fldcard_type_id = "";
$fldcard_number = "";
//-------------------------------

//-------------------------------
// Form Action begin
//-------------------------------
$sActionFileName = "ShoppingCart.php";

//-------------------------------
// CANCEL action
//-------------------------------
if($sAction == "cancel")
{

//-------------------------------
// Form BeforeCancel Event begin
// Form BeforeCancel Event end
//-------------------------------
header("Location: " . $sActionFileName);
}
//-------------------------------


//-------------------------------
// Build WHERE statement
//-------------------------------
if($sAction == "update" || $sAction == "delete")
{
$pPKmember_id = get_param("PK_member_id");
if( !strlen($pPKmember_id)) return;
$sWhere = "member_id=" . tosql($pPKmember_id, "Number");
}
//-------------------------------


//-------------------------------
// Load all form fields into variables
//-------------------------------
$fldUserID = get_session("UserID");
$fldmember_password = get_param("member_password");
$fldname = get_param("name");
$fldlast_name = get_param("last_name");
$fldemail = get_param("email");
$fldaddress = get_param("address");
$fldphone = get_param("phone");
$fldnotes = get_param("notes");
$fldcard_type_id = get_param("card_type_id");
$fldcard_number = get_param("card_number");

//-------------------------------
// Validate fields
//-------------------------------
if($sAction == "insert" || $sAction == "update")
{
if(strlen($fldmember_password)>10 || strlen($fldmember_password)<5 )
$sFormErr .= "\nPassword should be in between 5-10 charecters";

if(!strlen($fldname))
$sFormErr .= "The value in field First Name* is required.<br>";

if(!strlen($fldlast_name))
$sFormErr .= "The value in field Last Name* is required.<br>";

if(!strlen($fldemail))
$sFormErr .= "The value in field Email* is required.<br>";

if(!is_number($fldcard_type_id))
$sFormErr .= "The value in field Credit Card Type is incorrect.<br>";




//-------------------------------
// Form Check Event begin
// Form Check Event end
//-------------------------------
if(strlen($sFormErr)) return;
}
//-------------------------------

//-------------------------------
// Create SQL statement
//-------------------------------
switch(strtolower($sAction))
{
case "update":
$fldmember_password=md5($fldmember_password);

if( !preg_match( "/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-])*.([a-zA-Z])+([a-zA-Z]+)+$/", $fldemail))
{
$sFormErr .= "\n Invalid email address";
}

if( !preg_match( "/^([0-9])+([0-9])*+$/", $fldphone)|| strlen($fldphone)>=12 || strlen($fldphone)<10)
{
$sFormErr .= "\n Invalid phone number";
}



$sSQL = "update members set " .
"member_password=" . tosql($fldmember_password, "Text") .
",first_name=" . tosql($fldname, "Text") .
",last_name=" . tosql($fldlast_name, "Text") .
",email=" . tosql($fldemail, "Text") .
",address=" . tosql($fldaddress, "Text") .
",phone=" . tosql($fldphone, "Text") .
",notes=" . tosql($fldnotes, "Text") .
",card_type_id=" . tosql($fldcard_type_id, "Number") .
",card_number=" . tosql($fldcard_number, "Text");
$sSQL .= " where " . $sWhere;
break;
}
//-------------------------------
//-------------------------------
// Form BeforeExecute Event begin
// Form BeforeExecute Event end
//-------------------------------

//-------------------------------
// Execute SQL statement
//-------------------------------
if(strlen($sFormErr)) return;
if($bExecSQL)
$db->query($sSQL);
header("Location: " . $sActionFileName);

//-------------------------------
// Form Action end
//-------------------------------
}

//===============================
// Display Record Form
//-------------------------------
function Form_show()
{
global $db;

global $sAction;
global $sForm;
global $sFileName;
global $sFormErr;
global $styles;

$fldmember_id = "";
$fldmember_login = "";
$fldmember_password = "";
$fldname = "";
$fldlast_name = "";
$fldemail = "";
$fldaddress = "";
$fldphone = "";
$fldnotes = "";
$fldcard_type_id = "";
$fldcard_number = "";
//-------------------------------
// Form Show begin
//-------------------------------
$sFormTitle = "MyInfo";
$sWhere = "";
$bPK = true;
$scard_type_idDisplayValue = "";

?>

<table style="width:100%">
<form method="POST" action="<?= $sFileName ?>" name="Form">
<tr><td style="background-color: #336699; text-align: Center; border-style: outset; border-width: 1" colspan="2"><font style="font-size: 12pt; color: #FFFFFF; font-weight: bold"><?=$sFormTitle?></font></td></tr>
<? if ($sFormErr) { ?>
<tr><td style="background-color: #FFFFFF; border-width: 1" colspan="2"><font style="font-size: 10pt; color: #000000"><?= $sFormErr ?></font></td></tr>
<? } ?>
<?

//-------------------------------
// Load primary key and form parameters
//-------------------------------
if($sFormErr == "")
{
}
else
{
$fldmember_id = strip(get_param("member_id"));
$fldmember_password = strip(get_param("member_password"));
$fldname = strip(get_param("name"));
$fldlast_name = strip(get_param("last_name"));
$fldemail = strip(get_param("email"));
$fldaddress = strip(get_param("address"));
$fldphone = strip(get_param("phone"));
$fldnotes = strip(get_param("notes"));
$fldcard_type_id = strip(get_param("card_type_id"));
$fldcard_number = strip(get_param("card_number"));
}
//-------------------------------

//-------------------------------
// Load all form fields

//-------------------------------

//-------------------------------
// Build WHERE statement
//-------------------------------

$pmember_id = get_session("UserID");
if( !strlen($pmember_id)) $bPK = false;

$sWhere .= "member_id=" . tosql($pmember_id, "Number");
//-------------------------------
//-------------------------------
// Form Open Event begin
// Form Open Event end
//-------------------------------

//-------------------------------
// Build SQL statement and execute query
//-------------------------------
$sSQL = "select * from members where " . $sWhere;
// Execute SQL statement
$db->query($sSQL);
$bIsUpdateMode = ($bPK && !($sAction == "insert" && $sForm == "Form") && $db->next_record());
//-------------------------------

//-------------------------------
// Load all fields into variables from recordset or input parameters
//-------------------------------
if($bIsUpdateMode)
{
$fldmember_id = $db->f("member_id");
$fldmember_login = $db->f("member_login");
//-------------------------------
// Load data from recordset when form displayed first time
//-------------------------------
if($sFormErr == "")
{
//$fldmember_password = $db->f("member_password");
$fldname = $db->f("first_name");
$fldlast_name = $db->f("last_name");
$fldemail = $db->f("email");
$fldaddress = $db->f("address");
$fldphone = $db->f("phone");
$fldnotes = $db->f("notes");
$fldcard_type_id = $db->f("card_type_id");
$fldcard_number = $db->f("card_number");
}
//-------------------------------
// Form ShowEdit Event begin
// Form ShowEdit Event end
//-------------------------------
}
else
{
if($sFormErr == "")
{
$fldmember_id = tohtml(get_session("UserID"));
}
//-------------------------------
// Form ShowInsert Event begin
// Form ShowInsert Event end
//-------------------------------
}
//-------------------------------
// Form Show Event begin
// Form Show Event end
//-------------------------------

//-------------------------------
// Show form field
//-------------------------------
?>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Login</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000">
<?= tohtml($fldmember_login) ?>&nbsp;</font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Password*</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000"><input type="password" name="member_password" maxlength="20" value="<?= tohtml($fldmember_password) ?>" size="20" ></font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">First Name*</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000"><input type="text" name="name" maxlength="50" value="<?= tohtml($fldname) ?>" size="50" ></font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Last Name*</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000"><input type="text" name="last_name" maxlength="50" value="<?= tohtml($fldlast_name) ?>" size="50" ></font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Email*</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000"><input type="text" name="email" maxlength="50" value="<?= tohtml($fldemail) ?>" size="50" ></font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Address</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000"><input type="text" name="address" maxlength="50" value="<?= tohtml($fldaddress) ?>" size="50" ></font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Phone*</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000"><input type="text" name="phone" maxlength="50" value="<?= tohtml($fldphone) ?>" size="50" ></font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Notes</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000"><textarea name="notes" cols="50" rows="5"><?=tohtml($fldnotes)?></textarea></font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Credit Card Type</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000"><select size="1" name="card_type_id">
<?
echo "<option value=\"\">" . $scard_type_idDisplayValue . "</option>";
$lookup_card_type_id = db_fill_array("select card_type_id, name from card_types order by 2");

if(is_array($lookup_card_type_id))
{
reset($lookup_card_type_id);
while(list($key, $value) = each($lookup_card_type_id))
{
if($key == $fldcard_type_id)
$option="<option SELECTED value=\"$key\">$value";
else
$option="<option value=\"$key\">$value";
echo $option;
}
}

?></select></font>
</td>
</tr>
<tr>
<td style="background-color: #FFEAC5; border-style: inset; border-width: 0">
<font style="font-size: 10pt; color: #000000">Credit Card Number</font>
</td>
<td style="background-color: #FFFFFF; border-width: 1">
<font style="font-size: 10pt; color: #000000"><input type="text" name="card_number" maxlength="50" value="<?= tohtml($fldcard_number) ?>" size="50" ></font>
</td>
</tr>
<tr><td colspan="2" align="right">
<? if ($bIsUpdateMode) { ?>
<input type="hidden" value="update" name="FormAction"/>
<input type="submit" value="Update" onClick="document.Form.FormAction.value = 'update';">
<? } ?>
<input type="submit" value="Cancel" onClick="document.Form.FormAction.value = 'cancel';">
<input type="hidden" name="FormName" value="Form">

<input type="hidden" name="PK_member_id" value="<?= $pmember_id ?>">
<input type="hidden" name="member_id" value="<?= tohtml($fldmember_id)?>">
</td></tr>
</form>
</table>
<?



//-------------------------------
// Form Close Event begin
// Form Close Event end
//-------------------------------

//-------------------------------
// Form Show end
//-------------------------------
}
//===============================
?>