This short snippet demonstrates how to insert data into a joomla database table using the built in $database global object. Note that you have to declare the variable if you are making this call from within a function. If this call is being made from within a component or module, then declaring the variable is not required.

global $database; $insertSql = 'insert into table(field1,field2) values($field1,$field2)'; $database->setQuery( $insertSql); if (!$result = $database->query()){ echo $database->stderr(); return false; }

For Joomla 1.5

For Joomla 1.5 the insertObject() and updateObject() functions can be used. 

 insertObject()

For inserting data, set the primary key in the stdClass object to null, then denote the same primary key field name as the third argument in the insertObject function. 

The insertObject function's first argument is the table name, the second is the stdClass object containing the name of the fields as the keys and the value you want to insert on the right hand side of the assignment and as I mentioned before, the third argument is the name of the primary key field, assuming it is an auto_increment in mysql, you can set it to null, and the object will create a new incremented id for you. 

$db = JFactory::getDBO(); $ins = new stdClass(); $ins->alid = null; $ins->header_id = $_REQUEST['header_id']; $ins->tenant_id = $_REQUEST['tenant_id']; $ins->message = serialize($log_arr); $ins->stamp = date("Y-m-d h:i:s"); $ins->type = 'MAIL'; if($db->insertObject("actions_log", $ins, 'alid')){ unset($db); }else{ echo $db->stderr(); }

updateObject()

The updateObject accepts the same number of arguments, the only important thing to note here is that in the stdClass object, the primary key field is set to the ID of the record that you are trying to update. So figure out what the ID is and set it to that numeric value.

$db = JFactory::getDBO(); $ins = new stdClass(); $ins->alid = 1234; $ins->header_id = $_REQUEST['header_id']; $ins->tenant_id = $_REQUEST['tenant_id']; $ins->message = serialize($log_arr); $ins->stamp = date("Y-m-d h:i:s"); $ins->type = 'MAIL'; if($db->updateObject("actions_log", $ins, 'alid')){ unset($db); }else{ echo $db->stderr(); }

Get the Last inserted ID

If you are creating a new record, and want to get the ID of the last inserted record, assuming that the table is set to auto increment on the PK field, call the insertid() method after you do the insert.

This article will briefly explain the Joomla 1.0.x encryption scheme.

This information is useful if you are in a position where you have access to your database, but have forgotten the password to the Joomla administrator. 

In order to create a new password simply add it to the $password variable in the variable that follows.

Joomla Community builder has a built in lost password facility that allows for the automatic reset of the password contained in an email sent to the user. The user can then log in with the new password and change it from within the community builder profile.

Often times people dont remember their usernames, only their email address. However, without the username, the form will not submit and the password will not be sent. 

Let us take a closer look at the code so we can modify it to use just the email address and not the username.