Convert mysql to mysqli

Today to want to share how i convert from old system that using mysql to mysqli..

First this is for config file.

mysql

<?php define('DB_SERVER', ''); define('DB_USERNAME', ''); define('DB_PASSWORD', ''); define('DB_DATABASE', ''); class DB_Class { function __construct() { $connection = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die('Oops connection error -> ' . mysql_error()); mysql_select_db(DB_DATABASE, $connection) or die('Database error -> ' . mysql_error()); } } ?>

mysqli

 <?php define('DB_SERVER', ''); define('DB_USERNAME', ''); define('DB_PASSWORD', ''); define('DB_DATABASE', ''); class DB_con { public $connection; private static $_instance; //The single instance function __construct(){ $this->connection = new mysqli(DB_SERVER, DB_USERNAME, DB_PASSWORD,DB_DATABASE); if ($this->connection->connect_error) die('Database error -> ' . $this->connection->connect_error); } function ret_obj(){ return $this->connection; } public static function getInstance() { if(!self::$_instance) { // If no instance then make one self::$_instance = new self(); } return self::$_instance; } private function __clone() { } public function getConnection() { return $this->connection; } } ?>

changes also have to do in fn file

mysql

<?php /*User*/ class User { public function __construct() { $db = new DB_Class(); } public function check_login($username, $password) { function make_safe($variable) { $variable = mysql_real_escape_string(trim($variable)); return $variable;} $username = make_safe($username); $password = make_safe($password); $password = md5($password); $ip=$_SERVER['REMOTE_ADDR']; $date_created = date('Y-m-d H:i:s'); $result = mysql_query("SELECT IdPengguna, Nama, Katanama, Katalaluan, Jawatan, Bahagian, KodThpCapai,KodFasiliti from Pengguna WHERE Katanama='$username' and Katalaluan = '$password'"); $row_pengguna= mysql_fetch_array($result); $totalrow_pengguna = mysql_num_rows($result); if ($totalrow_pengguna >0 ){ $_SESSION['log_stbp'] = true; $_SESSION['IdPengguna'] = $row_pengguna['IdPengguna']; $_SESSION['uname'] = $row_pengguna['Nama']; $_SESSION['ujawatan'] = $row_pengguna['Jawatan']; $_SESSION['ubahagian'] = $row_pengguna['Bahagian']; $_SESSION['ucapai'] = $row_pengguna['KodThpCapai']; $_SESSION['ufasi'] = $row_pengguna['KodFasiliti']; $_SESSION['log_kn'] = $row_pengguna['Katanama']; $_SESSION['log_kl'] = $row_pengguna['Katalaluan']; return TRUE; } else { return FALSE; } } ?>

mysqli

<?php $db = DB_con::getInstance(); $mysqli = $db->getConnection(); class User{ protected $db; public function __construct(){ $this->db = new DB_con(); $this->db = $this->db->ret_obj(); } public function check_login($username, $password) { $password = md5($password); $ip=$_SERVER['REMOTE_ADDR']; $date_created = date('Y-m-d H:i:s'); $query = "SELECT IdPengguna, Nama, Katanama, Katalaluan, Jawatan, Bahagian, KodThpCapai,KodFasiliti from Pengguna WHERE Katanama='$username' and Katalaluan = '$password'"; $q = $this->db->query($query); $row_pengguna = $q->fetch_array(); $totalrow_pengguna = $q->num_rows; if ($totalrow_pengguna >0 ){ $_SESSION['log_stbp'] = true; $_SESSION['IdPengguna'] = $row_pengguna['IdPengguna']; $_SESSION['uname'] = $row_pengguna['Nama']; $_SESSION['ujawatan'] = $row_pengguna['Jawatan']; $_SESSION['ubahagian'] = $row_pengguna['Bahagian']; $_SESSION['ucapai'] = $row_pengguna['KodThpCapai']; $_SESSION['ufasi'] = $row_pengguna['KodFasiliti']; $_SESSION['log_kn'] = $row_pengguna['Katanama']; $_SESSION['log_kl'] = $row_pengguna['Katalaluan']; return TRUE; } else { return FALSE; } } ?>

Can you see the different that you have to add or adjust a bit.

in your files where your actual code to show add those file in the beginning.

<?php
session_start();
include_once 'include/config.php';
include_once 'include/fn.php';
?>

like this.