tmalhar
(Tmalhar)
March 14, 2012, 12:24pm
1
hello i am newly use yii.
i want to use checkbox to save multiple Records.
here i have one database.
table contact:
id int
name varchar
date date
email varchar
qualification varchar
ref_from varchar
intrested_in_joining varchar
intrested_course varchar // in this field i use six checkbox.then the checkbox checked value are stored into in this
fied.all checkbox checked value are in one field.then How to store the checkbox checked
value into this field ?
bettor
(Live Webscore)
March 14, 2012, 8:08pm
2
hm this is not the ideal approach. why are storing multiple values into one mysql field. You could use serialized data but I strongly suggest you normalize your DB. ie use separate table for the checkboxes
tmalhar
(Tmalhar)
March 15, 2012, 5:24am
3
table contact:
id int
name varchar
date date
email varchar
qualification varchar
ref_from varchar
intrested_in_joining varchar
intrested_course varchar // in this field i use six checkbox.then the checkbox checked value are stored into in this
fied.
Id name date qualific ref_from intrested_in_joining intrested_course
1 abc 2012/03/03 MCA XYZ Today B.E
2 abc 2012/03/03 MCA XYZ Today M.Tech
3 abc 2012/03/03 MCA XYZ Today MBA
the intrested_couorse field are checkbox checked values.they are all time different.
Here the all fields are same but the intrested_course field are change then how to do this…?
how to possible this the all field are same but id and intrested_course are change.
how this will be possible ?
Please help me.