Hi All
I had problem in DateTimePicker I need to get date value and insert in database but result null .
form.php
......
<div class="row">
<?php echo $form->labelEx($model,'Bday'); ?>
<?php
$this->widget(
'ext.jui.EJuiDateTimePicker',
array(
'model' => $model,
'attribute' => 'birth_date',
'language'=> 'en',//default Yii::app()->language
'mode' => 'date',//'datetime' or 'time' ('datetime' default)
'options' => array(
'dateFormat' => 'dd-mm-yy',
//'timeFormat' => '',//'hh:mm tt' default
),
)
);
?>
<?php echo $form->error($model,'birth_date'); ?>
</div>
...
Controller :
.....
if(isset($_POST['Users']))
{
$model->attributes=$_POST['Users'];
if($model->validate())
{
.....
$birth_date=$_POST['Users']['birth_date'];
Yii::app()->db->createCommand(" INSERT INTO `tbl_users` (`user_id`, `first_name`, `last_name`, `password`, `active_key`, `email`,`city`,`country`,`birth_date`,`gender`,`reg_date`)
values(NULL,'$first_name','$last_name','$password','$active_key','$email','$city','$country','$birth_date','$gender',NOW()) ")
->query();
// form inputs are valid, do something here
}
else{
echo " Error";
}
}
$this->render('index',array('model'=>$model));
}
....
Thanks in advance .