esien
August 16, 2011, 7:00am
1
for($k=1;$k<5;$k++)
{
if($y[$k]==$k)
{
$query="SELECT * from booking_user, booking_roominfo where booking_roominfo.roominfo_userID=booking_user.user_ID and roominfo_ and roominfo_slotID='$y[$k]' and roominfo_roomID='$roomid'";
$result=mysql_query($query);
while($row= mysql_fetch_array($result))
{
echo "<td height='40' bgcolor='#FF3366' style='border:1px solid black'><center>".$row['user_name']."<br></td>";
}
}
else
{
echo "<td height='40' bgcolor='#3399FF' style='border:1px solid black'>".$form->checkBox($model,'roominfo_slotID', array('value' => $k, 'name'=>'checkbox[$k]'))."$slottime[$k]</td>";
}
}
$y="";
how should i add the data into mysql table if multiple checkbox is checked?
p/s: each checkbox represent a row in the table…
thanks guys.appreciate the helps.
ivica
August 16, 2011, 7:48am
2
First you are mixing views and controller(model) items in one file, no matter if file from which you pasted code is controller or view.
And answer to your question:
$model->attributes=$_POST['FormName'];
$model->save();
You can find more details here:
http://www.yiiframework.com/doc/guide/1.1/en/form.action
esien
August 16, 2011, 8:06am
3
Ivica:
First you are mixing views and controller(model) items in one file, no matter if file from which you pasted code is controller or view.
And answer to your question:
$model->attributes=$_POST['FormName'];
$model->save();
You can find more details here:
http://www.yiiframework.com/doc/guide/1.1/en/form.action
Thanks Ivica.I will try see whether my problem is solved or not.
esien
August 16, 2011, 9:23am
4
<?php echo $form->hiddenField($model,'roominfo_date',array('value'=>'2011-08-14'));?>
<?php echo $form->hiddenField($model,'roominfo_userID',array('value'=>Yii::app()->user->id)); ?>
<?php echo $form->hiddenField($model,'roominfo_roomID',array('value'=>$roomid)); ?>
<?php foreach($_POST['checkbox'] as $checkbox)
{
echo $form->hiddenField($model,'roominfo_slotID',array('value'=>1));
} ?>
<div class="row buttons">
<?php echo CHtml::submitButton($model->isNewRecord ? 'Create' : 'Save'); ?>
</div>
actually the problem I face is when I want to get the value from one or more checkbox. How can I save each value of the checkbox per 1 row in the table of mysql?? my checkbox is build dynamically.(e.g. 1 checkbox selected -> 1 data created and stored 1 row in database, 5 checkbox selected -> 5 data created and stored 5 row in database.)
