php mysql select not working on field "name"

Question

I know it's strange but I have a select that returns null if the field named name is used. If I remove it then it works, and I already changed the data in the table. If I make a direct query to mysql it works. There might be something in the contents but I can't see anything strange.

Any suggestion that could help me investigate is welcome :(

class go { 
   function Query($sql){

       $results = $this->db->query($sql);

       if (mysqli_num_rows($results)<1){    
           throw new Exception('No Results');       
       }    

       $out = array();

       while ($r = $results->fetch_object()){       
           $out[] = $r;  
       } 

       return json_encode($out);    

       $out = null;
    }
}

$client = new go;

//not working
$sql = "select name from books limit 10"; 
$sql = "select name,description from books limit 10";
$sql = "select * from books limit 10";

// works!
$sql = "select description from books limit 10"; 

$data = $client->Query( $sql );

UPDATE

I found that the problem comes out due to some latin accented characters like ó ñ é

you must use `` for exp : select \`name\`,\`description\` from \`books\` limit 10 — hosein in jast, Feb 18 '20 at 10:25
Does this answer your question? [UTF-8 all the way through](https://stackoverflow.com/questions/279170/utf-8-all-the-way-through) — Cid, Feb 18 '20 at 10:34

score 0 · Answer 1 · answered Feb 18 '20 at 10:27

0

DBMS some reserved keywords. Name is a reserved name in MYsQL. Change the name to another column name, maybe name1. I think that should work.Check list of reserved keywords for mysql https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-N.

answered Feb 18 '20 at 10:27

Arthurofos

198
1
12

Then why `select *` doesn't work ? – Cid Feb 18 '20 at 10:33
in * is the name inside. Because * select all your columns. – Arthurofos Feb 18 '20 at 10:36
Well, no. `select *` selects all fields, no matter how they are named. *Name* is not a reserved word, the issue is in fact about character encoding – Cid Feb 18 '20 at 10:47

dearsina · Answer 2 · 2020-02-18T10:37:10.730

0

Update

Try setting the charset when initialising the connection to your mySQL server usg set_charset() method. I use the following charset:

$this->db->set_charset('utf8mb4');

This may resolve your issue.

edited Feb 18 '20 at 10:37

answered Feb 18 '20 at 10:28

dearsina

4,774
2
28
34

1

@Cid, I have updated my answer to correct the nomenclature. – dearsina Feb 18 '20 at 10:31
I found that the problem comes out due to some latin accented characters like ó ñ é - How can I solve it? – Robert Feb 18 '20 at 10:32

score 0 · Answer 3 · answered Feb 18 '20 at 10:37

0

Solved with mysqli_set_charset($db, "utf8");

answered Feb 18 '20 at 10:37

Robert

59
1
5

php mysql select not working on field "name"

3 Answers3