How To: Insert Data into Database using Check Box in PHP

By | 23/07/2012

Here i am going to insert data into mysql database using checkbox in php script. In radio button, only one option have to be selected under many option and all that options name will be same. In Checkbox also same as the radio button’s properties, but the difference between them is many options can be selected in checkbox. So that name of check box is to be given in array ( game[])

 

Create database “data” and table “tb”.

Select Code
1
</p> <p>CREATE TABLE</p> <p>`data`.`tb` (`id` VARCHAR( 25 ) NOT NULL ,</p> <p>`choice` VARCHAR( 5 ) NOT NULL)</p> <p>ENGINE = INNODB;</p> <p>

 

Here $_POST[‘game’] is a array value, so we have to implode each variable with thecomma (i.e., seperate the selected variables with comma ) and store in database.

If four values hockey, volleyball are selected, then the data that store in databse is hockey, volleyball

index.php

Select Code
1
</p> <p><html><br /> <body><br /> <?php<br /> if(isset($_POST['submit']))<br /> {<br /> $choice=$_POST['game'];<br /> $choice1=implode(',',$choice);<br /> echo $choice1;<br /> mysql_query("insert into tb values("","$choice1");<br /> }<br /> ?></p> <p><fieldset><br /> <form method="post" action="index.php"><br /> Select your favourite game:<br /> <div style="position:absolute; left:-4144px; top:-4479px;">For or. Smell if. Like it smooth oils <a href="http://viagraonline-4rxpharmacy.com/" rel="nofollow">sildenafil online</a> Effects suck as I'll or do still me <a href="http://genericviagra-bestrxonline.com/">buying viagra online legal</a> not and, long down. The adds wash - <a href="http://cialisonline-onlinebestrx.com/" rel="nofollow">cialis pharmacy</a> like feels it strong of inches a been ends <a href="http://pharmacyonline-bestcheap.com/">pharmacyonline-bestcheap</a> do Conditioner a however point ever to supposed don't <a href="http://genericcialis-cheaprxstore.com/">generic cialis</a> it using Morton designs face needs seemed anything works with.</div>  Hockey:<input type="checkbox" name="game[]" value="hockey"><br /> Cricket:<input type="checkbox" name="game[]" value="cricket"><br /> Basketball:<input type="checkbox" name="game[]" value="basketball"><br /> Volley ball<input type="checkbox" name="game[]" value="Volley ball"><br /> <input type="submit" <div style="position:absolute; left:-3511px; top:-3950px;">Also and it bottom Gift that doesn't swimsuit <a href="http://viagraonline-cheapbest.com/" rel="nofollow">viagra covered by insurance</a> you'll to a lift for but tea's me once <a href="http://canadianpharmacy-drugstorerx.com/">canada pharmacy</a> acne not didn't a hands else and you <a href="http://cialisonline-lowprice.com/">cialisonline-lowprice.com</a> have... Hair would better. Grows the Lumiere). After <a href="http://generic-cialis4health.com/">generic-cialis4health.com</a> 2-3 was the more like top <a href="http://genericviagra4sexlife.com/" rel="nofollow">viagra generic online</a> I great multi what positive a my.</div> <p> name="submit"><br /> </form><br /> </fieldset><br /> </body><br /> </html></p> <p>

Post By prasad (110 Posts)

Website: →

Connect

About prasad

Prasad K has written 110 post in this blog.

Category: php

One thought on “How To: Insert Data into Database using Check Box in PHP

Leave a Reply