コード例 #1
0
ファイル: class.functions.php プロジェクト: ashiq/PHP_CLASS
 function sigin()
 {
     $dbObj = new Cdb(SERVER, DBNAME, DBUSER, DBPASS);
     $dbObj->connectDB();
     $billingRecord = $dbObj->getRowFromDB("select * from customers  where UserEmail like '" . $_REQUEST['txtusrname'] . "' and UserPassword='******'txtpasswd'] . "' limit 0,1");
     if (count($billingRecord) > 0) {
         $_SESSION['USER_ID'] = $billingRecord['UserID'];
         $_SESSION['BillingFirstName'] = $billingRecord['BillingFirstName'];
         $_SESSION['Email'] = $billingRecord['UserEmail'];
         $error = "";
     } else {
         $error = "Invalid User Email / Password";
     }
     return $error;
 }
コード例 #2
0
 function getUserRecord()
 {
     $ObjDb = new Cdb(SERVER, DBNAME, DBUSER, DBPASS);
     $ObjDb->connectDB();
     $Qry = "SELECT  BillingFirstName, BillingLastName, UserEmail, BillingTelephone  FROM customers where UserID = '" . $_SESSION['USER_ID_GTECH'] . "'";
     $result = $ObjDb->getRowFromDB($Qry);
     return $result;
 }