MySql query not in working in PHP but works in phpMyAdmin

Question

At first I'm sorry for posting duplicate question I always try to find answers and never to ask. But nothing solved my problem. I have a MySql DB with table named data. I cannot change the table name. When I execute SELECT * FROM `data` or SELECT * FROM data in phpMyAdmin, the query works correctly but when I execute it in PHP script the query() returns false

<?php

$conn = new mysqli('localhost', 'username', 'pswd', 'dbname');
if ($conn->connect_error) {
    die('connection error');
}
$result = $conn->query("SELECT * FROM `data`");

var_dump($result);

echo "-".$conn->error."-";

I have looked at these questions:

Mysql query works in phpmyadmin but not in php (due to date)

Mysql query works in Phpmyadmin but not works in PHP

MySQL query working in phpmyadmin but not in php

and some others...

check error by $conn->query("SELECT * FROM data") or die ($conn->error); — Nitish Kumar Diwakar
– Nitish Kumar Diwakar, Commented Jan 10, 2018 at 9:36

Mazhar Hussain · Accepted Answer · 2018-01-10 09:56:10Z

0

$result ="SELECT * FROM `data`";
$row=mysqli_query($conn,$result);
while($row_result=$row->fetch_assoc())
print_r($row_result);

answered Jan 10, 2018 at 9:56

Mazhar Hussain

1251 silver badge11 bronze badges

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

4 Comments

Martin Bodický Over a year ago

the $row variable is set to false as result of mysqli_query

Mazhar Hussain Over a year ago

you can fetch data with while loop i check it is ok

Martin Bodický Over a year ago

no i can't, when i var_dump($row) i get returned bool(false)

Toby Speight Over a year ago

Thank you for this code snippet, which might provide some limited short-term help. A proper explanation would greatly improve its long-term value by showing why this is a good solution to the problem, and would make it more useful to future readers with other, similar questions. Please edit your answer to add some explanation, including the assumptions you've made.

Martin Bodický · Accepted Answer · 2018-01-10 10:16:39Z

0

With your replies I've got some idea what to try next.I've created copy of the table on my own server and tried changing data types. One of data types in original table is set as JSON, when i changed it to TEXT it started to work.

answered Jan 10, 2018 at 10:16

Martin Bodický

569 bronze badges

Collectives™ on Stack Overflow

MySql query not in working in PHP but works in phpMyAdmin

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related