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 a helping hand in fixing your website issues?

If you are facing any problems in implementing these code snippets and tutorials, you can hire us to fix your website issues.

Hire Us