Using AI

[Raymond Jender]

AI appears to be a great learning tool! As a newbie, it helps a lot. I simply want to see if the provided "jobnumber" exists in the database. I most likely would not have used this, but is the following AI generated code secure?

$stmt = $conn->prepare("SELECT COUNT(*) FROM orderform WHERE jobnumber = ?");
$stmt->bind_param("s", $jobnumber);
$stmt->execute();
$stmt->bind_result($count);
$stmt->fetch();
$stmt->close();

if ($count > 0) {
echo "Job number $jobnumber exists in the database.";
} else {
echo "Job number $jobnumber does not exist in the database.";
}
Thanks.