TOPIC:

Database Name Quote and Value Quote 03 Oct 2011 17:48 #89

griiettner
Topic Author
Offline
Senior Member
Posts: 73
Thank you received: 12

MySQL uses backticks `` for names and single quotes ‘‘ for values. On the generated component I got form Cook, I noticed that the databases does not have any quote at all.

There is a recommended way to work with this situation, by adding $db->nameQuote($name) to embrace names or values... a database query would be like this:

$query = "
  SELECT * 
    FROM ".$db->nameQuote('#__example_table')."  
    WHERE ".$db->nameQuote('id')." = ".$db->quote('999999').";
  ";

I think this would be a good thing to be added to follow the standards and avoid compatibility issues...

Paulo Griiettner

The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

Re: Database Name Quote and Value Quote 05 Oct 2011 12:51 #103

admin Offline Administrator Chef Posts: 3711 Thank you received: 986	You are right. Sometimes, we used hard writed `, but never with the native function as you describe. We will make a global check on this. Coding is now a piece of cake
	Please Log in or Create an account to join the conversation.