| Server IP : 74.208.127.88 / Your IP : 18.117.8.176 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/t/sae/model/ |
Upload File : |
<?php
class sql extends dbconn {
public function __construct()
{
$this->initDBO();
}
public function new_customer($name,$rfc,$email,$country,$phone,$gender)
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("insert into customer(name,email1,rfc,country,phone,gender) values (:name,:email1,:rfc,:country,:phone,:gender)");
$stmt->bindParam("name",$name);
$stmt->bindParam("email1",$email);
$stmt->bindParam("rfc",$rfc);
$stmt->bindParam("country",$country);
$stmt->bindParam("phone",$phone);
$stmt->bindParam("gender",$gender);
$stmt->execute();
$stat[0] = true;
$stat[1] = "Success save customer";
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
return $stat;
}
}
public function list_customer()
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("select * from customer");
$stmt->execute();
$stat[0] = true;
$stat[1] = "List customer";
$stat[2] = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
$stat[2] = [];
return $stat;
}
}
public function edit_customer($id,$name,$rfc,$email,$country,$phone,$gender)
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("update customer set name = :name,rfc = :rfc,email1 = :email1, country = :country, phone = :phone , gender = :gender where id_cust = :id ");
$stmt->bindParam("id",$id);
$stmt->bindParam("name",$name);
$stmt->bindParam("rfc",$rfc);
$stmt->bindParam("email1",$email);
$stmt->bindParam("country",$country);
$stmt->bindParam("phone",$phone);
$stmt->bindParam("gender",$gender);
$stmt->execute();
$stat[0] = true;
$stat[1] = "Success edit customer";
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
return $stat;
}
}
public function delete_customer($id)
{
$db = $this->dblocal;
try
{
$stmt = $db->prepare("delete from customer where id_cust = :id");
$stmt->bindParam("id",$id);
$stmt->execute();
$stat[0] = true;
$stat[1] = "Success delete customer";
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
return $stat;
}
}
public function autoCompleteCustomer($term)
{
$trm = "%".$term."%";
$db = $this->dblocal;
try
{
$stmt = $db->prepare("SELECT a.* FROM customer a WHERE name like :term order by name desc");
$stmt->bindParam("term",$trm);
$stmt->execute();
$stat[0] = true;
$stat[1] = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $stat;
}
catch(PDOException $ex)
{
$stat[0] = false;
$stat[1] = $ex->getMessage();
return $stat;
}
}
}