MySQL query working in phpmyadmin but not in php

Question

I want to select data from a table in MySQL. My code in php:

$conn = mysqli_connect($db_server, $db_benutzer, $db_passwort, $db_name);

$results= mysqli_query($conn, "SELECT * FROM `test` WHERE russia = 'привет'");
if(mysqli_num_rows($results) > 0) { 
    echo "Results";
}
else {
    echo "No results";
}

mysqli_close($conn);

Here I'm getting "No results". But when I run the SELECT-code directly in phpmyadmin i get a result.

What's wrong? Thank you

Really? Here I'm getting 0 results? You should get either Results or No results. — Ankit Singh
– Ankit Singh, Commented Jul 29, 2017 at 10:51
$results= mysqli_query($conn, "SELECT * FROM test WHERE russia = 'привет'") or die(mysqli_error($conn)); please replace this line with mine and see if any error comes ... without an error i am not able to get the issue — Farsay
– Farsay, Commented Jul 29, 2017 at 10:57
@Jay What does the following query print in myadmin? SELECT COUNT(*) FROM test WHERE russia = 'привет' — Darshan Mehta
– Darshan Mehta, Commented Jul 29, 2017 at 11:07

Jirka Hrazdil · Accepted Answer · 2017-07-29 11:15:07Z

4

You have cyrillic characters in your query, so it may be necessary to set mySQL connection encoding. If you are using utf-8, insert following line after mysqli_connect:

mysqli_query($conn, "SET NAMES 'utf8'");

Or if your script is saved in windows-1251, use the following: mysqli_query($conn, "SET NAMES 'cp1251'");

For more information about connection character sets and encodings please see the manual

And why does the query work in phpMyAdmin? Because it probably sets encoding for you in the background.

answered Jul 29, 2017 at 11:15

Jirka Hrazdil

4,0211 gold badge16 silver badges17 bronze badges

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

2 Comments

JAYJKB Over a year ago

Thank you, you helped me a lot :)

Jirka Hrazdil Over a year ago

If my post answers your question, please mark it as accepted. Thanks a lot.

Bishwabikash Das · Accepted Answer · 2017-07-29 11:23:24Z

-2

You won't get 0 results in any way,you either get results or no results. 2.try removing the quotes from the table name
Check for any Encoding issues with the connection encoding and that the data on the value of column russia is parsed as something else. Try executing the following query before executing your main query

mysqli_query($conn,"SET character_set_results='utf8',character_set_client='utf8',character_set_connection='utf8',character_set_database='utf8',character_set_server='utf8'");

The problems arise if there are Encoding issues in the connection.

edited Jul 29, 2017 at 11:23

answered Jul 29, 2017 at 11:04

Bishwabikash Das

306 bronze badges

Collectives™ on Stack Overflow

MySQL query working in phpmyadmin but not in php

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related