التحقق من وجود اسم في جدول php & mysql

<?php

$con=mysqli_connect("localhost","root","root","departement");

if (mysqli_connect_errno())

{

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

session_start();

$user = $_SESSION['myusername'];

if ($user=="")

header("location:departement.html");

elseif($user !="root01")

{

$result = mysqli_query($con,"SELECT * FROM user where login='".$user."'");

$row = mysqli_fetch_array($result);

$user_id = $row['user_Id'];

echo "<b><h1>No,isn't exist [".$user."].</h1></b>";

}

else

echo "<b><h1>Yes, exist [".$user."].</h1></b>";

?>

انصحك بشكبة عبدالله عيد

<?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");

mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table WHERE name='anyname'", $link);

$num_rows = mysql_num_rows($result);

if ($num_rows > 0) {

echo 'name is exist';

}

?>