updating timestamp field in mysql using joomla component

Question

I'm working on joomla component (com_book) version 3.0. In that I'm trying to insert books using form to database, in database I'm having updated_at column for that column I'm using timestamp datatype. Here updated_at column working fine when i'm inserting and updating books using database and inserting books using forms then it's working fine but when I'm trying updating books using forms that time update_at column not updating.

Can anyone explain what mistake I made in that process?

updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP; This statement i am using for that updated_at coloumn. — srinu, Dec 24 '12 at 12:52
Can you place your query in the question so we can figure it out — Toretto, Dec 24 '12 at 13:04

score 2 · Answer 1 · answered Dec 25 '12 at 13:06

Another method is creating a custom field for that,

use this field code in your book.xml form file

<fieldset
addfieldpath="/administrator/components/com_book/models/fields"
>
..
..
<field name="timestamp" type="lastmodified"
label="" description="" />
..
..
</fieldset>

and create a file called, lastmodified.php in your /administrator/components/com_book/models/fields folder

<?php

defined('JPATH_BASE') or die;

jimport('joomla.form.formfield');

/**
 * Supports an HTML form field
 */
class JFormFieldLastModified extends JFormField
{
    /**
     * The form field type.
     *
     * @var        string
     * @since    1.6
     */
    protected $type = 'lastmodified';

    /**
     * Method to get the field input lastmodified.
     *
     */
    protected function getInput()
    {
        // Initialize variables.
        $html = array();
        $old_time_updated = $this->value;
        if ($old_time_updated) {
            $jdate = new JDate($old_time_updated);
            $pretty_date = $jdate->format(JText::_('DATE_FORMAT_LC2'));
        }
        $time_updated = date("Y-m-d H:i:s");
        $html = '<input type="hidden" name="'.$this->name.'" value="'.$time_updated.'" />';

        return $html;
    }
}

?>

score 1 · Answer 2 · answered Dec 25 '12 at 07:09

Paste this function in the Table file, of your table for example Joomla-Root/Administrator/com_book/table/book.php if there is already a store function, then edit that and add these lines alone man, that will do the job,

    public function store($updateNulls = false)
{
    $date   = JFactory::getDate();
               // this is your primary key maybe id or book_id
    if ($this->book_id) {
        // Assigning the last modified date to your timestamp field
        $this->timestamp    = $date->toSql();
    }

    // Attempt to store the user data. - just leave the rest to parent function
    return parent::store($updateNulls);
}

score 0 · Answer 3 · answered Dec 25 '12 at 07:09

0

In save function after data binding you can set the updated_at

// Bind the data to the table
if (!$table->bind($post))
{
//display error
}
//after binding write this line-
$table->updated_at  = date('Y-m-d H:i:s');

let me know if this not work.

answered Dec 25 '12 at 07:09

Irfan

7,029
3
42
57

Hello Irfan,I am using joomla version 3.0.In that components no need to write save funtion.so i don't have save function in my component. – srinu Dec 25 '12 at 07:48

score 0 · Answer 4 · answered Dec 25 '12 at 08:40

The Joomla Component Creator can build Joomla 3.0 components and save you messing with simple stuff like this.

Take a look: http://www.notwebdesign.com/joomla-component-creator/

It's free for one table. If nothing else you can copy paste code from that or peak and see how to develop yourself.

updating timestamp field in mysql using joomla component

4 Answers4