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.

Page:
1

Forum

Debug

Closed tickets.

[FIXED] Database Name Quote and Value Quote

Time to create page: 0.070 seconds

“

”

Although I found this tool some time ago I just started learning experimenting and building this first component on Monday and now on Thursday afternoon it's already online. Although I already had a working version done with another tool this is much easier to build and at the end you have the freedom to own your own component. Once you know how to use Cook you will boost your productivity as the learning curve is really moderate compared to many other tools.
Giori (Forum)

TOPIC:

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

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

Get Started

Newsletter