PHP mysqli SELECT query won't execute

Question

$dc=fopen("numeu.txt","rb");
$row1=fgets($dc,120);   
$row2=fgets($dc,120);
$row3=fgets($dc,120);

fclose($dc);

$servername="localhost";
$username="root";
$password='';
$database="Stildev";

$conn = new mysqli($servername, $username, $password, $database);

$sql="SELECT poza1,poza2,poza3,poza4,poza5,poza6 FROM postari WHERE utilizator='".$row2."' AND subiect='".$row1."' AND id2='".$row3."'";


$resultat=$conn->query($sql);

echo $resultat->num_rows;

This piece of code returns 0 rows

There is no error and sql query works just fine in MySQL console.

Also i discovered that withought WHERE clause the code works.How you explain that?

subiect='".$row1."' subject spell is wrong whether its intentionally or it's a mistake ? — Nagendra Nigade
– Nagendra Nigade, Commented May 14, 2015 at 11:02
yes i ve tried and i also paste it into the console after i saw it — Avram Alex
– Avram Alex, Commented May 14, 2015 at 11:08
BTW since you wrap the $sql variable with double quotes (") you can just write ='$row2' instead of ='".$row2."' It may increase code readability (IMHO at least) — user2399035
– user2399035, Commented May 14, 2015 at 11:26

Alex Tartan · Accepted Answer · 2015-05-14 15:23:07Z

2

Is the password empty on purpose?

Try adding

if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') '
        . $mysqli->connect_error);
}

Also, according to https://php.net/manual/ro/mysqli.query.php, this may help:

if ($result = $mysqli->query($sql)) {
    echo $result->num_rows;
    /* close result set */
    $result->close();
}

If you are using several result-returning queries, close previous results with ->close();

edited May 14, 2015 at 15:23

answered May 14, 2015 at 12:00

Alex Tartan

6,84410 gold badges37 silver badges47 bronze badges

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

5 Comments

Seer Over a year ago

You should update your answer to use the OO style, as he is using that. That'd be $conn->connect_errno in that case.

vaso123 Over a year ago

this should be a comment also.

Avram Alex Over a year ago

yes it is empty because i use wamp server and i never changed the pass

Avram Alex Over a year ago

the default pass is ''

Alex Tartan Over a year ago

My last update does not fit properly in a comment. Please see updated answer

Collectives™ on Stack Overflow

PHP mysqli SELECT query won't execute

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related