Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class User{
- private $dbServer = "sql12.freemysqlhosting.net";
- private $dbHost = "http://www.phpmyadmin.co/";
- private $dbUsername = "sql12168044";
- private $dbPassword = "";
- private $dbName = "sql12168044";
- private $userTbl = "users";
- public function __construct(){
- if(!isset($this->db)){
- // Connect to the database
- $conn = new mysqli($this->dbHost, $this->dbServer, $this->dbUsername, $this->dbPassword, $this->dbName);
- if($conn->connect_error){
- die("Failed to connect with MySQL: " . $conn->connect_error);
- }else{
- $this->db = $conn;
- }
- }
- }
- /*
- * Returns rows from the database based on the conditions
- * @param string name of the table
- * @param array select, where, order_by, limit and return_type conditions
- */
- public function getRows($conditions = array()){
- $sql = 'SELECT ';
- $sql .= array_key_exists("select",$conditions)?$conditions['select']:'*';
- $sql .= ' FROM '.$this->userTbl;
- if(array_key_exists("where",$conditions)){
- $sql .= ' WHERE ';
- $i = 0;
- foreach($conditions['where'] as $key => $value){
- $pre = ($i > 0)?' AND ':'';
- $sql .= $pre.$key." = '".$value."'";
- $i++;
- }
- }
- if(array_key_exists("order_by",$conditions)){
- $sql .= ' ORDER BY '.$conditions['order_by'];
- }
- if(array_key_exists("start",$conditions) && array_key_exists("limit",$conditions)){
- $sql .= ' LIMIT '.$conditions['start'].','.$conditions['limit'];
- }elseif(!array_key_exists("start",$conditions) && array_key_exists("limit",$conditions)){
- $sql .= ' LIMIT '.$conditions['limit'];
- }
- $result = $this->db->query($sql);
- if(array_key_exists("return_type",$conditions) && $conditions['return_type'] != 'all'){
- switch($conditions['return_type']){
- case 'count':
- $data = $result->num_rows;
- break;
- case 'single':
- $data = $result->fetch_assoc();
- break;
- default:
- $data = '';
- }
- }else{
- if($result->num_rows > 0){
- while($row = $result->fetch_assoc()){
- $data[] = $row;
- }
- }
- }
- return !empty($data)?$data:false;
- }
- /*
- * Insert data into the database
- * @param string name of the table
- * @param array the data for inserting into the table
- */
- public function insert($data){
- if(!empty($data) && is_array($data)){
- $columns = '';
- $values = '';
- $i = 0;
- if(!array_key_exists('created',$data)){
- $data['created'] = date("Y-m-d H:i:s");
- }
- if(!array_key_exists('modified',$data)){
- $data['modified'] = date("Y-m-d H:i:s");
- }
- foreach($data as $key=>$val){
- $pre = ($i > 0)?', ':'';
- $columns .= $pre.$key;
- $values .= $pre."'".$val."'";
- $i++;
- }
- $query = "INSERT INTO ".$this->userTbl." (".$columns.") VALUES (".$values.")";
- $insert = $this->db->query($query);
- return $insert?$this->db->insert_id:false;
- }else{
- return false;
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement