Skip to content

Instantly share code, notes, and snippets.

@Badshah1
Created April 4, 2015 13:26
Show Gist options
  • Save Badshah1/41267e6c2ff5c5d6abde to your computer and use it in GitHub Desktop.
Save Badshah1/41267e6c2ff5c5d6abde to your computer and use it in GitHub Desktop.
php oop mysqli database class insert,update,delete,select methods are there in given file if you have easy way then please share your methods thanks alot
<?php
class Database{
private $host="localhost";
private $username="root";
private $password="mysql";
private $database="sale";
private $DbCon;
public function connect(){
$con = new mysqli($this->host,$this->username,$this->password,$this->database);
if($con){
$this->DbCon=$con;
return true;
}else{
return false;
}
}
public function select($table,$row="*",$where=null,$order=null){
$query='SELECT '.$row.' FROM '.$table;
if($where!=null){
$query.=' WHERE '.$where;
}
if($order!=null){
$query.=' ORDER BY ';
}
$Result=$this->DbCon->query($query);
return $Result;
}
public function insert($table,$value,$row=null){
$insert= " INSERT INTO ".$table;
if($row!=null){
$insert.=" (". $row." ) ";
}
for($i=0; $i<count($value); $i++){
if(is_string($value[$i])){
$value[$i]= '"'. $value[$i] . '"';
}
}
$value=implode(',',$value);
$insert.=' VALUES ('.$value.')';
$ins=$this->DbCon->query($insert);
if($ins){
return true;
}else{
return false;
}
}
public function delete($table,$where=null){
if($where == null)
{
$delete = "DELETE ".$table;
}
else
{
$delete = "DELETE FROM ".$table." WHERE ".$where;
}
$del=$this->DbCon->query($delete);
if($del){
return true;
}else{
return false;
}
}
public function update($table,$rows,$where){
// Parse the where values
// even values (including 0) contain the where rows
// odd values contain the clauses for the row
for($i = 0; $i < count($where); $i++)
{
if($i%2 != 0)
{
if(is_string($where[$i]))
{
if(($i+1) != null)
$where[$i] = '"'.$where[$i].'" AND ';
else
$where[$i] = '"'.$where[$i].'"';
}
}
}
$where = implode(" ",$where);
$update = 'UPDATE '.$table.' SET ';
$keys = array_keys($rows);
for($i = 0; $i < count($rows); $i++)
{
if(is_string($rows[$keys[$i]]))
{
$update .= $keys[$i].'="'.$rows[$keys[$i]].'"';
}
else
{
$update .= $keys[$i].'='.$rows[$keys[$i]];
}
// Parse to add commas
if($i != count($rows)-1)
{
$update .= ',';
}
}
$update .= ' WHERE '.$where;
$query = $this->DbCon->query($update);
if($query)
{
return true;
}
else
{
return false;
}
}
};
$a= new Database();
$a->connect();
$upd=array('username'=>'Badshah',
'password'=>'badshah',
'email'=>'badshah@gmail.com');
$a->update('user',$upd,array('id=3','id=4','id=5','id=6'));
//$a->delete('user',' id = 1');
//$ins=array('','Badshah','badshah','badshah@gmail.com');
//$a->insert('user',$ins,null);
//$ab=$a->select('user');
//while($a=$ab->fetch_array()){
// echo $a[0]."<br />";
//}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment