Difference between revisions of "Developing a MVC Component/Using the Database"
From Joomla! Documentation
Line 29: | Line 29: | ||
return $this->greeting; | return $this->greeting; | ||
} | } | ||
+ | |||
+ | Are those file names for "install.utf8.sql" and "uninstall.utf8.sql" correctly written into XML file? I see files "install.sql" and "uninstall.sql", but in the text, there says the files will be named "install.utf8.sql" and "uninstall.utf8.sql"? |
Revision as of 04:08, 21 July 2009
Although it is mentioned in the article, I think it is important to underline where the install.sql and uninstall.sql files have to be placed:
install.sql and uninstall.sql files have to be mentioned in two places:
- In one of the file sections. For example:
<files folder="admin"> <filename>...</filename> <filename>...</filename> <filename>install.sql</filename> <filename>uninstall.sql</filename> </files>
- In the install / uninstall sections.
Of course, the files have to be copied in the correct folder (in the example, it should be the admin folder).
When data is read from a database, it can be retrieved in the class constructor:
// The constructor accesses the database, and retrieves all properties. function __construct($config = array()) { parent::__construct($config); // To transmit configuration to parent class. $db =& JFactory::getDBO(); $query = 'SELECT greeting FROM #__hello'; $db->setQuery( $query ); $this->greeting = $db->loadResult(); } // The private property var $greeting; // The public property accessor function getGreeting() { return $this->greeting; }
Are those file names for "install.utf8.sql" and "uninstall.utf8.sql" correctly written into XML file? I see files "install.sql" and "uninstall.sql", but in the text, there says the files will be named "install.utf8.sql" and "uninstall.utf8.sql"?