Search code examples
phpmysqlsqlmysqlimysql-num-rows

php mysql checking if a record exists

I've got problem with checing if a record exists in database. I guess its problem with incorrect using of mysqli_num_rows

<?php

$mysqli = new mysqli("xxxxxx", "xxxxx", "xxxxxx", "xxxxx");

/* check connection */
if ($mysqli->connect_errno) {
    die("Connect failed: %s\n" . $mysqli->connect_error);
}

$stmt = $mysqli->prepare("INSERT INTO TEST_CHARS (CHAR_NAME) VALUES(?)");
$stmt->bind_param('s', $nick);
$nick  = $_POST['nick'];
$query = mysqli_query("SELECT CHAR_NAME FROM TEST_CHARS WHERE CHAR_NAME ='$nick';");
$count = mysqli_num_rows($query);

if ($count > 0)
{
    die('Error, character exist in database');
}
else
{
    $stmt->execute();
    echo "Character $nick was added successfully";
}
$mysqli->close();

?>
Solution

  • Try with:

    $query = mysqli_query($mysqli, "SELECT CHAR_NAME FROM TEST_CHARS WHERE CHAR_NAME ='$nick';");