php db functions

<?php
class MarketplaceWebService_DB {


function __construct($dbHost,$dbUsername,$dbPassword,$dbName){

// Connect database
$conn = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);
if($conn->connect_error){
die("Failed to connect with MySQL: " . $conn->connect_error);
}else{
$this->db = $conn;
}
}

function getRecord($table,$where=array()){
$sql = "SELECT * FROM $table Where 1=1";
if(!empty($where)){
foreach($where as $key=>$val){
$sql .=' AND '.$key." = '".$val."'";
}
}

$query = $this->db->query($sql);
$result = $query->fetch_all();
if($result){
return $result;
}else{
return false;
}
}
function getSingleRecord($table,$where=array()){
$sql = "SELECT * FROM $table Where 1=1";
if(!empty($where)){
foreach($where as $key=>$val){
$sql .=' AND '.$key." = '".$val."'";
}
}
//echo $sql;
$query = $this->db->query($sql);
$result = $query->fetch_assoc();
if($result){
return $result;
}else{
return false;
}
}

function insert($tableName,$records=array()){
$sql = "INSERT INTO $tableName ";
if(empty($records)){
return false;
}
$sql .="( ".
          $this->db->real_escape_string(implode(' , ',array_keys( $records))).
          ") VALUES ( '".
          $this->db->real_escape_string(implode("' , '", array_values($records))).
          "' )";

if($this->db->query($sql)){
return $this->db->insert_id;
}else{
return $this->db->error;
}
}

function update($tableName,$records=array(),$where=array()){
$sql = "UPDATE $tableName SET ";
if(empty($records)){
return false;
}

if(empty($records) ){
return false;
}
foreach($records as $key=>$val){
$sql .=$key." = '".$this->db->real_escape_string($val)."', ";
}
$sql = substr($sql,0,-2);
if(!empty($where)){
$sql .=" WHERE ";
foreach($where as $key=>$val){
$sql .=$key." = '".$this->db->real_escape_string($val)."' ";
}
}

if($this->db->query($sql)){
return true;
}else{
return false;
}
}
}

?>

Comments

Popular posts from this blog

Blogger post using PHP API

Pin payment laravel