Code
โค้ด: เลือกทั้งหมด
<?php
ini_set('display_errors', 1);
error_reporting(~0);
$config = array(
"host"=>"localhost",
"user"=>"root",
"pass"=>"1234",
"dbname"=>"Light_Project",
"charset"=>"utf8"
);
$con = new mysqli($config["host"],$config["user"],$config["pass"],$config["dbname"]);
$con->set_charset($config["charset"]);
$id = "kuadmaster";
$sql = "SELECT * FROM tb_user WHERE UID = ?";
$stmt = $con->stmt_init();
$stmt->prepare($sql);
$stmt->bind_param('s', $id);
$stmt->execute();
$result = $stmt->get_result($stmt);
while($row = $result->fetch_assoc()){
echo $row["UserID"]."<br>";
echo $row["UID"]."<br>";
echo $row["UPASS"]."<br>";
echo $row["Name"]."<br>";
echo $row["Surename"]."<br>";
echo "<hr>";
}
$con->close();
?>