コード例 #1
0
#
#
#
#
#
#
#
#
#
#
#
require "settings.php";
require "libs/ext.lib.php";
require_lib("validate");
if (isset($_GET['addcontact'])) {
    $OUTPUT = AddContact($_GET);
    $OUTPUT .= printCust($_GET);
} else {
    # show current stock
    $OUTPUT = printCust($_GET);
}
require "template.php";
# show stock
function printCust($_GET)
{
    # get vars
    foreach ($_GET as $key => $value) {
        ${$key} = $value;
    }
    if (isset($filter) && !isset($all)) {
        $sqlfilter = " AND lower({$filter}) LIKE lower('%{$fval}%')";
コード例 #2
0
#
#
#
#
#
#
#
#
#
#
#
require "settings.php";
require "libs/ext.lib.php";
require_lib("validate");
if (isset($_GET['addcontact'])) {
    $OUTPUT = AddContact();
    $OUTPUT .= printCust();
} else {
    # show current stock
    $OUTPUT = printCust();
}
require "template.php";
# show stock
function printCust()
{
    # Set up table to display in
    $printCust = "\r\n\t\t\t\t\t<center>\r\n\t\t\t\t\t<h3>Current Customers</h3>\r\n\t\t\t\t\t<table border='1' cellpadding='3' cellspacing='0'>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<th>Department</th>\r\n\t\t\t\t\t\t\t<th>Acc no.</th>\r\n\t\t\t\t\t\t\t<th>Surname/Company</th>\r\n\t\t\t\t\t\t\t<th>Business Tel</th>\r\n\t\t\t\t\t\t\t<th>Home Tel</th>\r\n\t\t\t\t\t\t\t<th>Category</th>\r\n\t\t\t\t\t\t\t<th>Classification</th>\r\n\t\t\t\t\t\t\t<th>Balance</th>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t";
    # Query server
    $tot = 0;
    $i = 0;
    # connect to database
コード例 #3
0
ファイル: instance.php プロジェクト: pmolfese/nidb
$contactemail1 = GetVariable("contactemail1");
$contactemail2 = GetVariable("contactemail2");
$contactemail3 = GetVariable("contactemail3");
$contactwebsite = GetVariable("contactwebsite");
$contactcompany = GetVariable("contactcompany");
$contactdepartment = GetVariable("contactdepartment");
/* determine action */
switch ($action) {
    case 'addcontactform':
        DisplayContactForm("add", $id);
        break;
    case 'editcontactform':
        DisplayContactForm("edit", $id, $contactid);
        break;
    case 'add':
        AddContact($id, $contactfullname, $contacttitle, $contactaddress1, $contactaddress2, $contactaddress3, $contactcity, $contactstate, $contactcountry, $contactphone1, $contactphone2, $contactphone3, $contactemail1, $contactemail2, $contactemail3, $contactwebsite, $contactcompany, $contactdepartment);
        break;
    default:
        DisplayInstanceControlPanel($id);
}
/* ------------------------------------ functions ------------------------------------ */
/* -------------------------------------------- */
/* ------- UpdateContact ---------------------- */
/* -------------------------------------------- */
function UpdateContact($id, $contactid, $contactfullname, $contacttitle, $contactaddress1, $contactaddress2, $contactaddress3, $contactcity, $contactstate, $contactcountry, $contactphone1, $contactphone2, $contactphone3, $contactemail1, $contactemail2, $contactemail3, $contactwebsite, $contactcompany, $contactdepartment)
{
    /* perform data checks */
    $contactfullname = mysql_real_escape_string($contactfullname);
    $contacttitle = mysql_real_escape_string($contacttitle);
    $contactaddress1 = mysql_real_escape_string($contactaddress1);
    $contactaddress2 = mysql_real_escape_string($contactaddress2);