PHP and SQL -- Select from database

Question

I have a problem with this code. It has syntax error and I don't know what is it.

<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'id1381007_accounts';
$conn = new mysqli($host,$user,$pass,$db) or die($mysqli->error);

if (!$conn) {
die('Could not connect: ' . mysql_error());

$sql  = 'SELECT id FROM users WHERE email=\"[email protected]\"';

echo $sql;
?>

execute your query by mysqli_query($conn,$sql) and change 'SELECT id FROM users WHERE email="[email protected]"' — urfusion
– urfusion, Commented Jul 8, 2017 at 6:04

Vivek Shah · Accepted Answer · 2017-07-08 06:31:54Z

1

There are some issue with the code. First you forgot to close the if condition over here

if (!$conn) {

And then you forgot to execute the sql query

the complete code would be like

<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'id1381007_accounts';
$conn = new mysqli($host,$user,$pass,$db) or die($mysqli->error);

if (!$conn) {
 die('Could not connect: ' . mysql_error());
}
$sql  = 'SELECT id FROM users WHERE email=\"[email protected]\"';
if ($result = $conn->query($sql)) {
   while ( $row = $result->fetch_assoc()) {
        $data[] = $row;
    }
    echo "<pre>";
    print_r($data);
    echo "</pre>";
}
$conn->close();
?>

answered Jul 8, 2017 at 6:31

Vivek Shah

4343 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Donat Treszler Over a year ago

And if I want to change the email address to a variable For example (I know this code isn't good) $email = [email protected] $sql = 'SELECT id FROM users WHERE email=$email';

Vivek Shah Over a year ago

Yes. you can just enclose it with single quotes like "SELECT id FROM users WHERE email='".$emai.l"'" . Something like this. just check and try

urfusion · Accepted Answer · 2017-07-08 06:06:19Z

0

There are two errors

You are missing } closing bracket after die
Mysql query is wrong.

So the code should be

if (!$conn) {
die('Could not connect: ' . mysql_error());
}
$sql  = 'SELECT id FROM users WHERE email="[email protected]"';

echo $sql;

answered Jul 8, 2017 at 6:06

urfusion

5,4995 gold badges56 silver badges91 bronze badges

Collectives™ on Stack Overflow

PHP and SQL -- Select from database

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related