How to get the data from database and echo on PHP page

Question

How to get the data from database and echo on PHP page?

Mycode :

$emailto = $_POST["email"];
$stmt = $con->prepare("SELECT id from  enseignant where email = $emailto)");
$stmt->bind_param("s",$emailto);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();

but I am getting the following error

Fatal error: Uncaught Error: Call to a member function bind_param()

Please share more details. What does `$con->prepare` return? Also, there's no parameter in the prepared query — Nico Haase, Jun 13 '21 at 11:03
$con connect to my database and the syntax :$mysqli -> prepare(query) — amine, Jun 13 '21 at 11:48
You should study PHP/MySql a little bit more before posting questions here. There's a bunch of tutorials on the web. — AbsoluteBeginner, Jun 13 '21 at 11:52

score 1 · Answer 1 · answered Jun 13 '21 at 11:02

1

You need to use questionmark in place of the parameter you want to set with bind_param(). The following code should work

$emailto=$_POST["email"];
$stmt = $con->prepare("SELECT id from enseignant where email = ?");
$stmt->bind_param("s",$emailto);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();

answered Jun 13 '21 at 11:02

Loupeznik

318
5
8

the same don't work – amine Jun 13 '21 at 11:36

How to get the data from database and echo on PHP page

1 Answers1