MySQLi Issue

MySQli GetName.php

 <?php 
 
	
	$con = new mysqli("localhost", "root", "password", "database");
	if($con)
	{
		$username = "use124";
		$password = "pass123";
		$sql = "select * from userdata where username ='$username' and password = '$password'";
		$stmt = $con->query($sql);
		
		if($stmt)
		{
			if($stmt->num_rows>0)
			{
				$value  = $stmt->fetch_assoc();
				//$value  = $stmt->fetch_object();
				
				echo "Hellow ".$value['name'];
				//echo "Hellow ".$value->name; if you use fetch_object
				
				
				//I usually use this type and pattern for coding
				//regards www.phpdark.com
			}else{
				echo "No Data Found";
			}
		}
	}else{
		echo "Failed To connect database"
	}
   
   
   ?>