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; }