ShasScript: mysqli

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

First this is for config file.

mysql

mysqli

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.

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)

fn.php (act as controller)

<?php
$db = DB_con::getInstance();
$mysqli = $db->getConnection();

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">

<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"/>

 <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>

</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.

Pages

Friday, September 27, 2019

Convert mysql to mysqli

connect to MySqli using class

LinkWithin