Check if username exists

[Tom10]

I'm trying to use a prepared statement to check if a username exists please can someone explain prepared statements to me i've been on php.net and still don't understand

 

the statement:

$ucheck = $con->prepare("SELECT * FROM users WHERE username=?");
	$ucheck->bind_param("s", $username);
	$ucheck->execute();
	$ucheck->num_rows();

	if(mysqli_num_rows($con) > 0) {

		echo "The username:".$username."already exists!";

		exit();
	}

$username = $_POST['username'];

[Barand]

Before you can get the number of rows you need the results

 

After the execute() either

$res = $smt->get_result();
echo $res->num_rows;

or

$smt->store_result();
echo $smt->num_rows;

[Tom10]

 

Before you can get the number of rows you need the results

 

After the execute() either

$res = $smt->get_result();
echo $res->num_rows;

or

$smt->store_result();
echo $smt->num_rows;

Thanks, Barand i appreciate your help