| Server IP : 172.67.216.113 / Your IP : 104.23.243.32 [ Web Server : Apache System : Linux cpanel01wh.bkk1.cloud.z.com 2.6.32-954.3.5.lve1.4.59.el6.x86_64 #1 SMP Thu Dec 6 05:11:00 EST 2018 x86_64 User : cp648411 ( 1354) PHP Version : 7.2.34 Disable Function : NONE Domains : 0 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home2/cp648411/public_html/simded.com/class2/ |
Upload File : |
<?php
class User extends Connect
{
public function cus_user($table,$user)
{
$this->setconnect();
$query = 'SELECT COUNT(id) AS count_id FROM '.$table.' WHERE '.$user;
$result = mysqli_query($this->setconnect(), $query);
$row = mysqli_fetch_assoc($result);
return $row['count_id'];
}
public function cus_pass($pass)
{
$pass_md5 = md5($pass."SimDed");
return $pass_md5;
}
public function pass_random()
{
$gen = 8;
$char_pass = "1234567890";
$password = "";
$pass_str = 1;
while(strlen($password) < $gen && $pass_str > 0)
{
$password .= $char_pass[rand()%strlen($char_pass)];
$pass_str = substr($password, 0, 1);
}
return $password;
}
public function ck_mail($table,$date)
{
$this->setconnect();
echo $query = 'SELECT COUNT(id) AS count_id FROM '.$table.' WHERE email = "'.$date.'"';
$result = mysqli_query($this->setconnect(), $query);
//print_r($query);
$row = mysqli_fetch_assoc($result);
return $row['count_id'];
}
public function ck_phonenumber($table,$date)
{
$this->setconnect();
$query = 'SELECT COUNT(id) AS count_id FROM '.$table.' WHERE phonenumber = "'.$date.'"';
$result = mysqli_query($this->setconnect(), $query);
$row = mysqli_fetch_assoc($result);
return $row['count_id'];
}
public function ck_idcard($table,$date)
{
$idcard = substr($date, 0, 1).'-'.substr($date, 2, 4).'-'.substr($date, 7, 5).'-'.substr($date, 13, 2).'-'.substr($date, 16, 1);//1-1111-11111-11-1
$this->setconnect();
$query = 'SELECT COUNT(id) AS count_id FROM '.$table.' WHERE idcard = "'.$idcard.'"';
$result = mysqli_query($this->setconnect(), $query);
$row = mysqli_fetch_assoc($result);
return $row['count_id'];
}
public function ck_codename($table,$date)
{
$this->setconnect();
if($table == 'shop')
{
$query = 'SELECT COUNT(id) AS count_id FROM '.$table.' WHERE codeshop = "'.$date.'"';
}
else
{
$query = 'SELECT COUNT(id) AS count_id FROM '.$table.' WHERE code = "'.$date.'"';
}
$result = mysqli_query($this->setconnect(), $query);
$row = mysqli_fetch_assoc($result);
return $row['count_id'];
}
public function log_Admin($id_admin,$name_admin,$page,$management)
{
$datetime = date("Y-m-d H:i:s");
$sql = " INSERT INTO log_admin (id_admin,name_admin,page,management,date_time) VALUES ('".$id_admin."','".$name_admin."','".$page."','".$management."','".$datetime."');";
$result = mysqli_query($this->setconnect(), $sql);
if($result){
$data['suc']=1;//สำเร็จ
}else{
$data['suc']=2; //ไม่สำเร็จ
}
$data['sql']=$sql;
return $data;
}
public function log_Admin2($id_admin,$name_admin,$page,$management)
{
$con = $this->setconnect();
$datetime = date("Y-m-d H:i:s");
$sql = " INSERT INTO wal_log_admin (id_admin,name_admin,page,management,date_time) VALUES ('".$id_admin."','".$name_admin."','".$page."','".$management."','".$datetime."');";
$result = mysqli_query($con,$sql);
if($result){
$data['suc']=1;//สำเร็จ
}else{
$data['suc']=2; //ไม่สำเร็จ
}
$data['sql']=$sql;
return $data;
}
public function view_ways($hua)
{
if(preg_match('/android|blackberry|ipad|iphone|ipod/i',$hua))
{
if(preg_match('/ipad|iphone|ipod/i', $hua))
{
//echo '<br>ios';
}
else if(preg_match('/Linux|android/i', $hua))
{
//echo '<br>Android';
}
$viewty = 'mobile';
}
else
{
//echo '<br>pc ';
$viewty = 'compc';
}
return $viewty;
}
public function view_phone($id,$ip,$hua)
{
$datetime = date("Y-m-d");
$this->setconnect();
$viewty = $this->view_ways($hua);
$sql = 'SELECT count(id) AS count_v FROM view_phone WHERE ip_add = "'.$ip.'" AND id_phone = "'.$id.'" AND '.$viewty .' = "1" AND datatime = "'.$datetime.'"';
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
if($row['count_v']==0)
{
$sql = " INSERT INTO view_phone (ip_add,id_phone,".$viewty.",datatime) VALUES ('".$ip."','".$id."','1','".$datetime."');";
$result = mysqli_query($this->setconnect(), $sql);
}
$sql1 = 'SELECT count(id) AS count_v FROM view_phone WHERE id_phone = "'.$id.'"';
$result1 = mysqli_query($this->setconnect(), $sql1);
$row1 = mysqli_fetch_assoc($result1);
return $row1['count_v'];
}
public function view_professor($id,$ip,$hua)
{
$datetime = date("Y-m-d");
$this->setconnect();
$viewty = $this->view_ways($hua);
$sql = 'SELECT count(id) AS count_v FROM view_professor WHERE ip_add = "'.$ip.'" AND id_professor = "'.$id.'" AND '.$viewty .' = "1" AND datatime = "'.$datetime.'"';
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
if($row['count_v']==0)
{
$sql = " INSERT INTO view_professor (ip_add,id_professor,".$viewty.",datatime) VALUES ('".$ip."','".$id."','1','".$datetime."');";
$result = mysqli_query($this->setconnect(), $sql);
}
$sql1 = 'SELECT count(id) AS count_v FROM view_professor WHERE id_professor = "'.$id.'"';
$result1 = mysqli_query($this->setconnect(), $sql1);
$row1 = mysqli_fetch_assoc($result1);
return $row1['count_v'];
}
public function view_shop($id,$ip,$hua)
{
$datetime = date("Y-m-d");
$this->setconnect();
$viewty = $this->view_ways($hua);
$sql = 'SELECT count(id) AS count_v FROM view_shop WHERE ip_add = "'.$ip.'" AND id_shop = "'.$id.'" AND '.$viewty .' = "1" AND datatime = "'.$datetime.'"';
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
if($row['count_v']==0)
{
$sql = " INSERT INTO view_shop (ip_add,id_shop,".$viewty.",datatime) VALUES ('".$ip."','".$id."','1','".$datetime."');";
$result = mysqli_query($this->setconnect(), $sql);
}
$sql1 = 'SELECT count(id) AS count_v FROM view_shop WHERE id_shop = "'.$id.'"';
$result1 = mysqli_query($this->setconnect(), $sql1);
$row1 = mysqli_fetch_assoc($result1);
return $row1['count_v'];
}
public function view_article($id,$ip,$hua)
{
$datetime = date("Y-m-d");
$this->setconnect();
$viewty = $this->view_ways($hua);
$sql = 'SELECT count(id) AS count_v FROM view_article WHERE ip_add = "'.$ip.'" AND id_article = "'.$id.'" AND '.$viewty .' = "1" AND datatime = "'.$datetime.'"';
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
if($row['count_v']==0)
{
$sql = " INSERT INTO view_article (ip_add,id_article,".$viewty.",datatime) VALUES ('".$ip."','".$id."','1','".$datetime."');";
$result = mysqli_query($this->setconnect(), $sql);
}
$sql1 = 'SELECT count(id) AS count_v FROM view_article WHERE id_article = "'.$id.'"';
$result1 = mysqli_query($this->setconnect(), $sql1);
$row1 = mysqli_fetch_assoc($result1);
return $row1['count_v'];
}
public function view_teller($id,$ip,$hua)
{
$datetime = date("Y-m-d");
$this->setconnect();
$viewty = $this->view_ways($hua);
$sql = 'SELECT count(id) AS count_v FROM view_teller WHERE ip_add = "'.$ip.'" AND id_teller = "'.$id.'" AND '.$viewty .' = "1" AND datatime = "'.$datetime.'"';
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
if($row['count_v']==0)
{
$sql = " INSERT INTO view_teller (ip_add,id_teller,".$viewty.",datatime) VALUES ('".$ip."','".$id."','1','".$datetime."');";
$result = mysqli_query($this->setconnect(), $sql);
}
$sql1 = 'SELECT count(id) AS count_v FROM view_teller WHERE id_teller = "'.$id.'"';
$result1 = mysqli_query($this->setconnect(), $sql1);
$row1 = mysqli_fetch_assoc($result1);
return $row1['count_v'];
}
}
?>