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.
 

connect to MySqli using class

Today I want to show you guys how to connect to mysqli using class. You need to have 3 files.

config.php (your database connection)

<?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; } } ?>

fn.php (act as controller)

<?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; } } ?>

index.php (this is where you files are)

<?php session_start(); include_once 'config.php'; include_once 'fn.php'; $user = new User(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <!-- Design by Syafiah Ahmad http://shasscript.blogspot.com mizsya06@gmail.com/syafiah@moh.gov.my --> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="X-UA-Compatible" content="IE=8" /> <meta HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE"> <meta HTTP-EQUIV="EXPIRES" CONTENT="01 Jan 1970 00:00:00 GMT"> <meta HTTP-EQUIV="PRAGMA" CONTENT="NO-CACHE"> <meta name="title" content="STBP"> <meta name="description" content="Sistem Tabung Bantuan Perubatan"> <meta name="keywords" content="tabung, bantuan, perubatan, ubat"> <title>Sistem Tabung Bantuan Perubatan</title> <link href="style.css" rel="stylesheet" type="text/css" /> <link rel="shortcut icon" href="images/favicon.ico" type="image/vnd.microsoft.icon"/> <link rel="icon" href=URL/favicon.ico type="image/x-ico"/> <!--validation--> <link rel="stylesheet" href="js/validator/css/validationEngine.jquery.css" type="text/css"/> <script src="js/validator/jquery-1.6.min.js" type="text/javascript"></script> <script src="js/validator/languages/jquery.validationEngine-en.js" type="text/javascript" charset="utf-8"></script> <script src="js/validator/jquery.validationEngine.js" type="text/javascript" charset="utf-8"></script> <script> jQuery(document).ready(function(){ // binds form submission and fields to the validation engine jQuery("#form1").validationEngine(); }); </script> <!--end of validation--> </head> <body> <div class="main1"> <div id="<?php echo ((!isset($_GET['reset_password'])) && (!isset($_GET['reset'])))?'ks-box':'ks-box1';?> "> <div class="inbox"> <form method="POST" action="" id="form1" name="form1"> <?php if ((!isset($_GET['reset_password'])) && (!isset($_GET['reset']))){ ?> <table width="100%" border="0" cellspacing="0" cellpadding="10" align="center"> <tr> <td colspan="3" align="center"></td> </tr> <tr height="40"> <td align="right"> </td> <td align="right"> </td> <td align="right"> </td> </tr> <tr> <td width="44%" align="right">KataNama</td> <td width="4%" align="right">:</td> <td width="52%" align="left"> <input name="Katanama" type="text" id="Katanama" size="15" class="validate[required,custom[textarea]]" /></td> </tr> <tr> <td align="right">KataLaluan</td> <td align="right">:</td> <td align="left"><input name="Katalaluan" type="password" id="Katalaluan" size="16" class="validate[required,custom[textarea]]"/></td> </tr> <tr> <td align="right"><a href="?reset">Lupa KataLaluan</a></td> <td> </td> <td align="left"><button type="submit" name="log_in_stbp" class="button1"><img src="images/lock.png" width="15" height="15" border="0" /> Log Masuk</button> </td> </tr> <tr> <td colspan="3"><div id="msg"> <?php if (isset($_GET['msg'])){ if ($_GET['msg']=='failed'){ echo 'KataNama/KataLaluan anda tidak tepat. Sila cuba lagi.'; } else if ($_GET['msg']=='success') echo "KataLaluan anda telah berjaya ditukar. Sila Log Masuk ke Sistem.<br>Sila Klik Lupa Katalaluan jika anda terlupa Katalaluan yang baru.";}?></div> </td> </tr> </table> <?php } if (isset($_GET['reset_password'])){ ?> <table width="100%" border="0" cellspacing="0" cellpadding="10" align="center"> <tr> <td colspan="3" align="center"></td> </tr> <tr height="40"> <td align="right"> </td> <td align="right"> </td> <td align="right"> </td> </tr> <tr> <td width="44%" align="right">KataLaluan</td> <td width="4%" align="right">:</td> <td width="52%" align="left"> <input name="Katalaluan" type="text" id="Katalaluan" size="16" class="validate[required,custom[textarea]]" /> <input name="NoKp" type="hidden" id="NoKp" value="<?php echo $_GET['nokp']; ?>" /></td> </tr> <tr> <td align="right">Sila Masukkan Semula KataLaluan</td> <td align="right">:</td> <td align="left"><input name="Katalaluan1" type="password" id="Katalaluan1" size="16" class="validate[required,custom[textarea]] equals[Katalaluan]"/></td> </tr> <tr> <td align="right"><a href="index.php">Log Masuk</a></td> <td> </td> <td align="left"><button type="submit" name="reset_pwd" class="button1"><img src="images/lock.png" width="15" height="15" border="0" /> Reset</button> </td> </tr> <tr> <td colspan="3"><div id="msg"> <?php if (isset($_GET['msg'])){ echo ($_GET['msg']=='success')?'KataLaluan anda telah berjaya ditukar. Sila Log Masuk ke Sistem.':'Sila gunakan link dari emel anda'; }?></div> </td> </tr> </table> <?php } if (isset($_GET['reset'])){?> <table width="50%" border="0" cellspacing="0" cellpadding="10" align="center"> <tr> <td colspan="3" align="center"></td> </tr> <tr height="40"> <td align="right"> </td> <td align="right"> </td> <td align="left"> </td> </tr> <tr> <td align="right">No. Kad Pengenalan</td> <td align="right">:</td> <td align="left"><input name="NoKp" type="text" id="NoKp" size="20" class="validate[required,custom[onlyNumberSp]]" /></td> </tr> <tr> <td width="33%" align="right">Emel</td> <td width="3%" align="right">:</td> <td width="64%" align="left"><input name="Emel" type="text" id="Emel" size="30" class="validate[required,custom[email]]" /></td> </tr> <tr> <td align="right"><a href="index.php">Log Masuk</a></td> <td align="right"> </td> <td align="left"><button type="submit" name="reset_emel" class="button1"><img src="images/lock.png" width="15" height="15" border="0" /> Hantar</button></td> </tr> <tr> <td colspan="3"><div id="msg"> <?php if (isset($_GET['msg'])){ echo ($_GET['msg']=='success')?'Emel telah berjaya dihantar. Sila Semak Emel Anda.':'Sila Cuba Lagi'; }?></div> </td> </tr> </table> <?php } ?> </form> </div> </div> </div> </body> </html>

I'm using this code when i have to convert the old system in PHP 5.2 to PHP 7.1..
Amazingly it works.

How to create new running number for specific code

 

Hello and Assalamualaikum,

 

 

Here a tip for you guys to try it out..

 

 

Hope it will give some idea for you guys..

 

 

The Code Like This

 

 

JGS0001

 

 

and you have to make it the running number from it.. with code GS is come from the group code (kodkumpulan) on selected value..

 

 

here the code..

 

 

 

the new code will be

 

JGS0002

 

 



Enjoy, Hope this post will be benefit for all of you. Thank You.

Sya Ahmad
Programmer in Ministry of Health