芝麻web文件管理V1.00

编辑当前文件:/home/sditechnicalteam/socialsolargreens.pk/partial/db.php

<?php  
 
define('HOST', 'localhost');  
define('USER', 'sditechnicalteam_ssg');  
define('PASS', 'sditechnicalteam_ssg');  
define('DB', 'sditechnicalteam_ssg');  
define('ssl', 'https://');  
define('BASE_URL', ssl.'socialsolargreens.pk/'); 
// Set timezone
date_default_timezone_set('Asia/Karachi'); 
if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

class db  
  
{  
    public $con = ''; 
  
    function __construct() {  
          $this->con = mysqli_connect(HOST, USER, PASS, DB);   
    }  
  
      public function test(){
        echo 'test ok.';
      }

public function select_query($query = ''){
        $mysql = mysqli_query($this->con,$query);
        $data = array();
        while($row = mysqli_fetch_assoc($mysql)){
            $data[] = $row;
        }
        return $data;

}

public function insert_query($query = ''){
        mysqli_query($this->con,$query);
        return $this->con->insert_id;
    }

public function getQueryType($sql)
    {
        if (is_array($sql)) $sql = key($sql);
        $matches = null;
        if (!preg_match('/^\s*(SELECT|INSERT|REPLACE|UPDATE|DELETE|TRUNCATE|CALL|DO|HANDLER|LOAD\s+(?:DATA|XML)\s+INFILE|(?:ALTER|CREATE|DROP|RENAME)\s+(?:DATABASE|TABLE|VIEW|FUNCTION|PROCEDURE|TRIGGER|INDEX)|PREPARE|EXECUTE|DEALLOCATE\s+PREPARE|DESCRIBE|EXPLAIN|HELP|USE|LOCK\s+TABLES|UNLOCK\s+TABLES|SET|SHOW|START\s+TRANSACTION|BEGIN|COMMIT|ROLLBACK|SAVEPOINT|RELEASE SAVEPOINT|CACHE\s+INDEX|FLUSH|KILL|LOAD|RESET|PURGE\s+BINARY\s+LOGS|START\s+SLAVE|STOP\s+SLAVE)\b/si', $sql, $matches)) return null;
        $type = strtoupper(preg_replace('/\s++/', ' ', $matches[1]));
        if ($type === 'BEGIN') $type = 'START TRANSACTION';
        return $type;
    }

public function register($trn_date, $username, $email, $password) {

$password = $password;  
        $checkuser ="Select id from signup where email='".$email."'";
         //print_r($checkuser);
        $result = mysqli_query($this->con,$checkuser);

$result2 = $result->num_rows;
        if ($result2 == 0) {

$insertquery = "Insert into signup (Transid, TransDes, TransDate, AccountNo, Dr, Cr, Invid, Vtype,V_No, Comid) VALUES ('".$TranscationDetails_Transid."','".$paidforbank."','".$TranscationDetails_TransDate."','".$TranscationDetails_AccountNo."',0,'".$TranscationDetails_Cr."','-1','BPV','".$TranscationDetails_V_No."','0')";

$register = mysqli_query($this->con,$insertquery);

// print_r($register);
            // die;

if($register == 1){ echo 'User registerd success'; }else{ return 'Error in data process';}  
        } else {  
            return 'Email already exist';  
        }
    //            print_r($result);
    //            die;
    }  
  
    public  
  
    function Index() {  
        // $pass = $password;  
        $check = "Select * from user_info WHERE username= '".$username."' AND password= '".$password."'";
        $data = mysqli_query($this->con, $check);    
         // print_r($data);
        if(mysqli_num_rows($data)== 1)
        { 
            return "succes";
         }
         else{
            return 'user not found';
         }
    }  
  
    public  
  
    function fullname($id) {  
        $result = mysqli_query("Select * from signup where id='$id'");  
        $row = mysqli_fetch_array($result);  
        echo $row['name'];  
    }  
  
    public  
  
    function session() {  
        if (isset($_SESSION['login'])) {  
            return $_SESSION['login'];  
        }  
    }  
  
    public  
  
    function logout() {  
        $_SESSION['login'] = false;  
        session_destroy();  
    }

//   include BASE_ADDRESS.'partial/link.php'; 
  //   $currentpage = ssl.$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF'];
  // if($currentpage == BASE_URL or $currentpage == BASE_URL.'index.php') {
  //   // echo BASE_URL.'index.php <br>' ;
  //   // echo $currentpage;
  // } else {
  //       include BASE_ADDRESS.'partial/sidebar.php';        
  //       include BASE_ADDRESS.'partial/nav.php';
  // }

public function select_table($table)
  {
      global $dbobj;
      if(!empty($table)){
          $query = "select * FROM ".$table;
          if ($query_result = mysqli_query($this->con, $query)) {
            while($row = mysqli_fetch_assoc($query_result)){
                $data[] = $row;
              }
              return $data;
              
          }   else{
              return "Error Code [366] : " . mysqli_error($this->con);
              die;
          }
      }else{
          return '';
      }
      die;
  }
  public function query($query)
  {
      global $dbobj;
      if(!empty($query)){
          if ($query_result = mysqli_query($this->con, $query)) {
                $rowcount=mysqli_num_rows($query_result);
                if($rowcount > 0){
                    if($rowcount = 1){
                        return mysqli_fetch_assoc($query_result);
                    }else{
                        while($row = mysqli_fetch_assoc($query_result)){
                            $data[] = $row;
                        }
                        return $data;
                        die;
                    }
                }else{
                    return "Record not found.";
                    die;
                }
          }   else{
              return "Error Code [71] : " . mysqli_error($this->con);
              die;
          }
      }else{
          return '';
      }
      die;
  }
  public function query_execute($query)
  {
      global $dbobj;
      if(!empty($query)){
          if ($query_result = mysqli_query($this->con, $query)) {
                $rowcount=mysqli_num_rows($query_result);
                if($rowcount > 0){
                    return $query_result;
                }else{
                    return "Record not found.";
                    die;
                }
          }   else{
              return "Error Code [71] : " . mysqli_error($this->con);
              die;
          }
      }else{
          return '';
      }
      die;
  }
  public function insert($query)
  {
      global $dbobj;
      if(!empty($query)){
          if ($query_result = mysqli_query($this->con, $query)) {
              return 'success';
          }   else{
              return "Error Code [921] : " . mysqli_error($this->con);
              die;
          }
      }else{
          return '';
      }
      die;
  }
  public function Delete($query)
  {
      global $dbobj;
      if(!empty($query)){
          if ($query_result = mysqli_query($this->con, $query)) {
              return 'success';
          }   else{
              return "Error Code [881] : " . mysqli_error($this->con);
              die;
          }
      }else{
          return '';
      }
      die;
  }

}      
global $dbobj;
$dbobj = new db();