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.078 seconds
“
”

This is what you call a component builder. I was able to master using this in a very short time and the resulting component works like a charm. Not just a basic component builder but a fully working component builder with forms fields tables all ready to go. You can make the list and item views to display in the front and back end. Also there is a great forum just starting to evolve and I'm sure this will grow very rapidly when you all realise how good this tool is.
Kevin (JED)

         

Get Started

Log In Sign In