public function GetBasicClientDetailByClientHash(&$recordSet, $clh)
{
if ($clh != '') {
$sql = "SELECT\r\n\t\t\t\t\t\ttbl_client.id_client AS 'id_client',\r\n\t\t\t\t\t\ttbl_client.client_name AS 'client_name',\r\n\t\t\t\t\t\ttbl_client.client_email AS 'client_email'\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\tFROM\t\r\n\t\t\t\t\t\ttbl_client \r\n\t\t\t\t\tWHERE\r\n\t\t\t\t\t\ttbl_client.client_hash = '" . mysql_escape_string($clh) . "' \r\n\t\t\t\t\tLIMIT 1";
$errors = PDODB::getInstance()->Query($querySuccess, $sql, $recordSet, $recordSetSize);
}
}
<?php
header('Content-type: text/html; charset=utf-8');
$config = (require './config.php');
require './PDODB.class.php';
$_dao = PDODB::getInstance($config['db']);
$_backAddress = $_POST['BackAddress'];
$_backAccount = $_POST['BackAccount'];
$_backPwd = $_POST['BackPassword'];
$_FTPAddress = $_POST['FTPAddress'];
$_FTPAccount = $_POST['FTPAccount'];
$_FTPPwd = $_POST['FTPPassword'];
$sql = "insert into dos_webinfo (BackAddress,BackAccount,BackPassword,FTPAccount,FTPAddress,FTPPassword) values ('{$_backAddress}','{$_backAccount}','{$_backPwd}','{$_FTPAddress}','{$_FTPAccount}','{$_FTPPwd}')";
$result = $_dao->query($sql);
if ($result) {
header("Location:./index.php");
}
public function __construct($config)
{
$this->config = $config;
$this->_dao = PDODB::getInstance($config['db']);
}
public function StoreNewClient($newClientData)
{
$insertId = 0;
if (sizeof($newClientData) > 0) {
//print_r( $newClientData ); exit;
$errors = PDODB::getInstance('readwrite')->InsertQueryReturnId($insertId, $newClientData, 'tbl_client');
if ($insertId > 0) {
$emailResult = $this->SendConfirmationSignupEmail($newClientData['client_email'], $newClientData);
//echo $emailResult; exit;
}
}
return $insertId;
}
