Problem with Mysqli (Password-reset script)

[requinix]

24 minutes ago, Daniii said:

Output: SQL error 2- 1 (2)

$sql = "SELECT * FROM users WHERE email = $email";
$stmt = mysqli_stmt_init($conn);
if (!mysqli_stmt_prepare($stmt, $sql)) {
	echo 'SQL error 2';
	$my = mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT); 
	echo "- $my (2)";
	exit();

[Daniii]

   $email = $row['email'];
                $sql = "SELECT * FROM users WHERE email = $email";
                $stmt = mysqli_stmt_init($conn);
                if (!mysqli_stmt_prepare($stmt, $sql)) {
                    echo 'SQL error 2';
                    $my = mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT); 
                    echo "- $my (2)";
                    exit();

i don't see any difference between your code and mine @requinix

[requinix]

There is no difference. I just posted the problematic code. For reference. Ideally you would take another look at it and realize what the problem is, but if not you, someone will.

[Daniii]

okay thanks I still do not find any error

[requinix]

Let me put it this way:

Is $sql supposed to be a prepared statement or not?

[Daniii]

yes i think is should be a prepared statement

[Barand]

Then read this