The Joomla! Forum™

I assumed there is always an ID being passed along, if not then you insert new data rather then update the current. The id can be placed in the hidden input field like a few posts up. Usually when binding does not work for me, it's because I have mistyped the name of a database field in the table cl...

Well Store is a nice and easy way to bind data to a table, but you don't have to use it, you can use your own sql inserts. Where you have your store function I believe you can get all the posted variables by using JRequest::getVar maybe something like: $db = & JFactory::getDBO(); $title = JReque...

administrator > components > com_categories > admin.categories.html.php

Around line 45 you will see <?php echo JText::_( 'Filter' ); ?>:

<input class="inputbox" type="text" name="title" size="40" maxlength="255" value="<?php echo $this->row->title; ?>" /> name="title" in the input field <-- binds to a database field named "title" Yes saving decides withe...

The ? is like an "if statement"
is the same as

If your after a calendar, you can just use <?php echo JHTML::_('calendar', $this->row->created, 'created', 'created', '%Y-%m-%d %H:%M:%S', array('class'=>'inputbox', 'size'=>'25', 'maxlength'=>'19')); ?> this will echo out a input filed and the DHTML date selector. If you prefer to merge post data f...

If you have phpMyAdmin on the server, it allows you to export tables to a heap of different formats like CSV, Excel etc...

If you do have it, you will be able to find guides on how to export data

I believe if your setting you params in the component .xml then their generally preset unless its a core list like Joomla's categories. You can create custom radio options, or drop downs from within your component by using the mosHTML class for Joomla 1.0.x. You can find a list of it's functions and...

Well you don't have to use MooTools, but since it's included with Joomla it would be recommended.

I have not tried it myself but this topic explains the basics to adding some Ajax to the Hello World component, which would apply to a module as well.

Docs maybe of interest too.

You could create the options in your view like this based on the database call to pull the required items.

Well something like that is way off from what Joomla does by default. From my thinking you would first write a component to store and display this data. Then you would need to write a custom search mambot (plugin) for that component. I think it would be much more difficult to hack Joomla to do somet...

The code uses " $db->setQuery($sql);"

so you will need to include $db =& JFactory::getDBO();
before the posted code.

It's the "state" field in the "jos_content table"

In my viewhtml.php I built the list like this: // build the catagory list $sql = 'SELECT id, cattitle' . ' FROM #__whosracing_cat' ; $db->setQuery($sql); $catlist[] = JHTML::_('select.option', '0', JText::_( '- Select Category -' ), 'id', 'cattitle' ); $catlist = array_merge( $catlist, $db->loadObje...

Just before you store your data, intercept the text area content like so: $data = JRequest::get( 'post' ); $data['ingredients'] = JRequest::getVar( 'ingredients, '', 'post', 'string', JREQUEST_ALLOWRAW ); // Bind the form fields to the table if (!$row->bind($data)) { $this->setError($this->_db->getE...

OK, I got it by placing this in my view.html $sql = 'SELECT id, cattitle' . ' FROM #__customcategories' ; $db->setQuery($sql); $catlist[] = JHTML::_('select.option', '0', JText::_( '- Select Category -' ), 'id', 'cattitle' ); $catlist = array_merge( $catlist, $db->loadObjectList() ); $lists['catid']...

With 1.0.x it was just placed in the .html.php output file like: <table class="adminheading"> <tr> <th> Weblink: <small> <?php echo $row->id ? 'Edit' : 'New';?> </small> </th> </tr> </table> I find that browsing the source files of the "Weblinks" or "Banners" components...

Put this in your view.html.php file

Hey Guys and Gals, I have my own Categories table in the database that I need to display in the drop down list. Could someone please give me a hand with this. I found this in the weblinks component: $lists['catid'] = JHTML::_('list.category', 'filter_catid', $option, intval( $filter_catid ), $javasc...