Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Debug
Closed tickets.
[FIXED] Database Name Quote and Value Quote
  • Page:
  • 1

TOPIC:

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

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
  • admin's Avatar
  • Offline
  • Administrator
  • 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.347 seconds
“
”

This Component Generator is the REAL component generator. This tool is very easy to use and in a matter of minutes I was building a fully working extension. I was amazed with the end result... worth every cent...
Griiettner (JED)

         

Get Started

Log In Sign In