Different MySQL with MySQLi

Table

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(99) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

INSERT INTO `users` (`id`, `nama`) VALUES
(1, 'zlumberjay');



STEP 2, create file config.php:


<?php
define ('HOST', 'localhost');
define ('USR', 'root');
define ('PASS', '');
define ('DB', 'test');
?>



STEP 2 create file TestMysql.php


<?php
include "config.php";
$mysql = mysql_connect(HOST, USR, PASS)
  or die ("tidak terkoneksi dengan HOST");
mysql_select_db ("test", $mysql)
  or die ("tidak terkoneksi dengan DB");
$query = "SELECT * FROM users";
$result=mysql_query($query);
while($row=mysql_fetch_assoc($result)){
       echo $row['nama'] ."<br/>";
}
?>



STEP 2 create file TestMysqli.php

include "config.php";
$mysqli = new mysqli(HOST, USR, PASS, DB);
if(mysqli_connect_errno()) {
echo "Tidak terkoneksi dengan HOST DB";
}
$query = "SELECT * FROM users";
if ($result = $mysqli->query($query))
{
   while ($row = $result->fetch_assoc())
{
       echo $row['nama'] ."<br/>";
}
   $result->close();
}
$mysqli->close();
?>