PHP

Fetch Data From Database With MySQLI

$DBhost = "localhost";
$DBuser = "root";
$DBpassword ="";
$DBname="apifile";

$conn = mysqli_connect($DBhost, $DBuser, $DBpassword, $DBname);

if(!$conn){
    die("Connection failed: " . mysqli_connect_error());
}
$query = mysqli_query($conn,"SELECT * FROM `prop` WHERE propkey='localhost_100100'");
$result = mysqli_fetch_array($query);
var_dump($result['propvalue']);

mysqli fetch query

$check_dublicate = mysqli_fetch_array(mysqli_query($con,"select * from users_users where email='$mail'"));

fetch data mysqli select query

$check_dublicate = mysqli_fetch_array(mysqli_query($con,"select * from users where email='$mail'"));