<?php
class database
{
public $host = "localhost";
public $user = "root";
public $pass = "";
public $db = "db";
public $link;
public function __construct()
{
$this->connect();
}
private function connect()
{
$this->link = new mysqli
($this->host, $this->user, $this->pass, $this->db); }
public function select($query)
{
$result = $this->link->query($query) or
die($this->link->error.__LINE__); if($result->num_rows > 0)
{
return $result;
}
else
{
return false;
}
}
public function insert($query)
{
$insert_row = $this->link->query($query) or
die($this->link->error.__LINE__);
if($insert_row)
{
= echo "Insert Successfully ";
}
else
{
die('Error : ('. $this->link->errno .') '. $this->link->error); }
}
public function update($query)
{
$update_row = $this->link->query($query) or
die($this->link->error.__LINE__);
//Validate Insert
if($update_row)
{
echo "Update Successfully";
}
else
{
die('Error : ('. $this->link->errno .') '. $this->link->error); }
}
public function delete($query)
{
$delete_row = $this->link->query($query) or
die($this->link->error.__LINE__);
if($delete_row)
{
echo "Delete Successfully";
}
else
{
die('Error : ('. $this->link->errno .') '. $this->link->error); }
}
}
?>
Cjw/cGhwCmNsYXNzIGRhdGFiYXNlCnsKCXB1YmxpYyAkaG9zdCA9ICJsb2NhbGhvc3QiOwoJcHVibGljICR1c2VyID0gInJvb3QiOwoJcHVibGljICRwYXNzID0gIiI7CglwdWJsaWMgJGRiICAgPSAiZGIiOwoJcHVibGljICRsaW5rOwoKCglwdWJsaWMgZnVuY3Rpb24gX19jb25zdHJ1Y3QoKQoJewoJCSAgICR0aGlzLT5jb25uZWN0KCk7Cgl9CgkKCgkgcHJpdmF0ZSBmdW5jdGlvbiBjb25uZWN0KCkKCSB7CgkJICAgJHRoaXMtPmxpbmsgPSBuZXcgbXlzcWxpKCR0aGlzLT5ob3N0LCAkdGhpcy0+dXNlciwgJHRoaXMtPnBhc3MsICR0aGlzLT5kYik7CgkJICAgcmV0dXJuICR0aGlzLT5saW5rOwoJIH0KCgkgcHVibGljIGZ1bmN0aW9uIHNlbGVjdCgkcXVlcnkpCgkgewoJCQkkcmVzdWx0ID0gJHRoaXMtPmxpbmstPnF1ZXJ5KCRxdWVyeSkgb3IgZGllKCR0aGlzLT5saW5rLT5lcnJvci5fX0xJTkVfXyk7CgkJCWlmKCRyZXN1bHQtPm51bV9yb3dzID4gMCkKCQkJewoJCQkJcmV0dXJuICRyZXN1bHQ7CgkJCX0gCgkJCWVsc2UgCgkJCXsKCQkJCXJldHVybiBmYWxzZTsKCQkJfQoJICB9CgoJIAoJICAgcHVibGljIGZ1bmN0aW9uIGluc2VydCgkcXVlcnkpCgkgICB7CgkJCSRpbnNlcnRfcm93ID0gJHRoaXMtPmxpbmstPnF1ZXJ5KCRxdWVyeSkgb3IgZGllKCR0aGlzLT5saW5rLT5lcnJvci5fX0xJTkVfXyk7CgkJCQoJCQlpZigkaW5zZXJ0X3JvdykKCQkJewo9CQkJCSBlY2hvICJJbnNlcnQgU3VjY2Vzc2Z1bGx5ICI7CgkJCX0gCgkJCWVsc2UgCgkJCXsKCQkJCWRpZSgnRXJyb3IgOiAoJy4gJHRoaXMtPmxpbmstPmVycm5vIC4nKSAnLiAkdGhpcy0+bGluay0+ZXJyb3IpOwoJCQl9CgkgICB9CgoJICAgcHVibGljIGZ1bmN0aW9uIHVwZGF0ZSgkcXVlcnkpCgkgICB7CgkJCSR1cGRhdGVfcm93ID0gJHRoaXMtPmxpbmstPnF1ZXJ5KCRxdWVyeSkgb3IgZGllKCR0aGlzLT5saW5rLT5lcnJvci5fX0xJTkVfXyk7CgkJCQoJCQkvL1ZhbGlkYXRlIEluc2VydAoJCQlpZigkdXBkYXRlX3JvdykKCQkJewoJCQkgICAgZWNobyAiVXBkYXRlIFN1Y2Nlc3NmdWxseSI7CgkJCQlleGl0KCk7CgkJCX0gCgkJCWVsc2UgCgkJCXsKCQkJCWRpZSgnRXJyb3IgOiAoJy4gJHRoaXMtPmxpbmstPmVycm5vIC4nKSAnLiAkdGhpcy0+bGluay0+ZXJyb3IpOwoJCQl9CgkgICB9CgkgICAKCgkgICBwdWJsaWMgZnVuY3Rpb24gZGVsZXRlKCRxdWVyeSkKCSAgIHsKCQkJJGRlbGV0ZV9yb3cgPSAkdGhpcy0+bGluay0+cXVlcnkoJHF1ZXJ5KSBvciBkaWUoJHRoaXMtPmxpbmstPmVycm9yLl9fTElORV9fKTsKCgkJCWlmKCRkZWxldGVfcm93KQoJCQl7CgkJCQkgZWNobyAiRGVsZXRlIFN1Y2Nlc3NmdWxseSI7CgkJCX0gCgkJCWVsc2UgCgkJCXsKCQkJCWRpZSgnRXJyb3IgOiAoJy4gJHRoaXMtPmxpbmstPmVycm5vIC4nKSAnLiAkdGhpcy0+bGluay0+ZXJyb3IpOwoJCQl9CgkgICB9Cn0KPz4=