PHP   

Select Data From Database using PHP, Mysqli

$conn = new mysqli("localhost","root","password","dbname");
if(! $conn ) {
      die('Could not connect to the database ');
}

$selectData = "SELECT * FROM users WHERE username= 'U1T5q'";
$result = $conn->query($selectData);
$totalRecords = mysqli_num_rows($result); // count of selected records
if ($result->num_rows > 0) {
	while($row = $result->fetch_assoc()) {
		echo "Selected Username:". $row['username']." and user email:".$row['user_email'];
	} 
}
Need Professional Support for Your Website Problems?

Whether you're facing website issues or struggling with code implementation, our team is here to assist. Hire us to get your website back on track.

Hire Us