Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- namespace IPHP\DATABASE
- {
- class mysql
- {
- private static CONNECTION_TYPE = "";
- private static CONNECTION;
- private DB_HOST = "";
- private DB_USER = "";
- private DB_PASS = "";
- private DB_NAME = "";
- public class __construct()
- {
- if(isset(self::$CONNECTION)
- {
- switch(self::$CONNECTION_TYPE)
- {
- case 'mysql':
- {
- self::$CONNECTION = new \mysql($this->DB_HOST,$this->DB_USER,$this->DB_PASS,$this->DB_NAME);
- if(self::self::$CONNECTION->connect_errn)
- {
- die();
- }
- else
- {
- return self::$CONNECTION;
- }
- }
- }
- }
- else
- {
- return self::$CONNECTION_TYPE;
- }
- }
- public function get($row,$table,$arr = false)
- {
- if($query = $this->DB_CONN->prepare('SELECT * FROM '.$table)){
- $query->execute();
- $result = $query->get_result();
- foreach($result as $rowc)
- {
- if($arr == true)
- {
- return $rowc;
- }
- else
- {
- if(isset($rowc[$row]))
- {
- return $rowc[$row];
- }
- }
- }
- }
- }
- public function insert($table,$args)
- {
- $columns = implode(", ",array_keys($args));
- $escaped_values = array_map('mysql_real_escape_string', array_values($args));
- $values = implode(", ", $escaped_values);
- if($query = $this->DB_CONN->prepare('INSERT INTO '.$table.' ('.$columns.') VALUES ('.$values.')'))
- {
- $query->execute();
- }
- else
- {
- print $this->DB_CONN->error;
- }
- $this->DB_CONN->query('COMMIT');
- }
- }
- }
- /*Usage*/
- use \IPHP\DATABASE;
- $DB = new mysql();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement