Ttykuu

Witch one of these methods is better/safer to use? And what benefits i could get using one or other?
I m really new to classes.

Simple mysqli:

connection.php

$DBServer = "localhost";
$DBPort = "3306";
$DBUser = "root";
$DBPass = "";
$DBName = "test";

$conn = new mysqli($DBServer, $DBUser, $DBPass, $DBName, $DBPort);
if ($conn->connect_error) 
 echo "Database connection failed: " . $conn->connect_error, E_USER_ERROR;

mysqli_set_charset($conn,"utf8");

index.php

include_once("connection.php");

$l_name = mysqli_real_escape_string($conn, $_GET['l_name']);

$query = mysqli_query($conn, "SELECT * FROM test WHERE lname='".$l_name."'");
while($row = mysqli_fetch_array($query))
 echo $row['f_name'].' '.$row['l_name'].'<br>';

mysqli with class:

connection.php

class Connect


 var $host = 'localhost';
 var $user = 'root';
 var $pass = '';
 var $db = 'test';
 var $con;

 function connect() 
 $con = mysqli_connect($this->host, $this->user, $this->pass, $this->db);

 if (!$con) 
 //die('Could not connect to database!');
 else 
 $this->con = $con; //echo 'Connection established!';
 
 mysqli_set_charset($this->con,"utf8");

 return $this->con;

 

 function close() 
 mysqli_close($con);
 

index.php

include_once("connection.php");

$con = new Connect();
$con->connect();

$l_name = mysqli_real_escape_string($con->con, $_GET['l_name']);

$query = mysqli_query($con->con, "SELECT * FROM test WHERE lname='".$l_name."'");
while($row = mysqli_fetch_array($query))
 echo $row['f_name'].' '.$row['l_name'].'<br>';

Thanks in advance!