PHP, Dropdowns, and Radio buttons

**pbmods** · May 8 '07, 12:52 PM

Originally posted by pringle

i want the php code to handle this dropdown list and radio button.

Don't we all.

How far have you gotten? Are you getting errors? Is your script not working the way it's supposed to?

**devsusen** · May 8 '07, 01:02 PM

Originally posted by pbmods

Don't we all.

well said pbmods. I am agreed with u. :)

susen

**pringle** · May 9 '07, 07:07 AM

i need a simple php code storing dropdown list and radiobutton data into my mysql database.

**pbmods** · May 9 '07, 01:30 PM

Originally posted by pringle

i need a simple php code storing dropdown list and radiobutton data into my mysql database.

So you haven't written it yet is what you're saying. Ok then.

Well, the basics are pretty simple. Each item in your form should have a name:

[HTML]
<input name="flavor" ...
[/HTML]

When the User submits the form, PHP puts the value of that input into $_REQUEST (also $_GET, $_POST or one of a couple others, depending on the action of your form). So to access that value, you would type something like this:

[PHP]
echo $_REQUEST['flavor'];
[/PHP]

To save it to the database, you'd need to build a query and send it:
[PHP]
$query = "INSERT INTO `tableName` (`col1`, `col2`) VALUES('" . addslashes($_RE QUEST['flavor']) . "', '" . addslashes($_RE QUEST['caliber']) . "')";
[/PHP]

And so forth. Note that it is good practice to (at the very least) use addslashes to prevent SQL injection attacks.

**pringle** · May 10 '07, 09:43 AM

actually i'm new to php, so i don't understand the code. this is my html code, so i hope that anyone can help me...

<input type="radio" name="formradio 1" style="position :absolute;left: 299px;top:725px ;z-index:10">
<input type="radio" name="formradio 1" style="position :absolute;left: 300px;top:799px ;z-index:11">
<input type="radio" name="formradio 1" style="position :absolute;left: 300px;top:616px ;z-index:12">
<input type="radio" name="formradio 1" style="position :absolute;left: 300px;top:653px ;z-index:13">
<input type="radio" name="formradio 1" style="position :absolute;left: 300px;top:761px ;z-index:14">
<input type="radio" name="formradio 1" style="position :absolute;left: 300px;top:688px ;z-index:15">
<input name="formtext1 " type="text" style="position :absolute;width :335px;left:326 px;top:818px;z-index:16">
<select name="Ruangan" style="position :absolute;left: 325px;top:440px ;width:336px;z-index:17">
<option value="">Bilik Komputer Sains Fizik</option>
</select>

<select name="Hingga" style="position :absolute;left: 325px;top:584px ;width:118px;z-index:18">
<option value="">9.00</option>
<option value="">10.00</option>
<option value="">11.00</option>
<option value="">12.00</option>
<option value="">1.00</option>
<option value="">2.00</option>
<option value="">3.00</option>
<option value="">4.00</option>
<option value="">5.00</option>
<option value="">6.00</option>
<option value="">7.00</option>
<option value="">8.00</option>
<option value="">9.00</option>
<option value="">10.00</option>
</select>

<select name="formselec t3" style="position :absolute;left: 325px;top:476px ;width:168px;z-index:19">
<option value="">Isnin</option>
<option value="">Selasa </option>
<option value="">Rabu</option>
<option value="">Khamis </option>
<option value="">Jumaat </option>
<option value="">Sabtu</option>
<option value="">Ahad</option>
</select>

<select name="Dari" style="position :absolute;left: 325px;top:549px ;width:118px;z-index:20">
<option value="">8.00</option>
<option value="">9.00</option>
<option value="">10.00</option>
<option value="">11.00</option>
<option value="">12.00</option>
<option value="">1.00</option>
<option value="">2.00</option>
<option value="">3.00</option>
<option value="">4.00</option>
<option value="">5.00</option>
<option value="">6.00</option>
<option value="">7.00</option>
<option value="">8.00</option>
</select>

<div id="text4" style="position :absolute; overflow:hidden ; left:108px; top:98px; width:522px; height:28px; z-index:21"><div class="wpmd">
<div align=justify>< font color="#253B6D" >Sila pilih kategori </font><font color="#253B6D" ><B>TEMPAHAN RUANG</B></font><font color="#253B6D" >.</font></div>
<div align=justify>< font color="#253B6D" > </font></div>
</div></div>

<div id="nav2" style="position :absolute; left:132px; top:131px; z-index:22"><a onMouseOut="MM_ swapImgRestore( )" onMouseOver="MM _swapImage('nav 20','','images/nav55583920a.gi f',1)" href="TempahMak mal.html"><img name="nav20" onLoad="MM_prel oadImages('imag es/nav55583920a.gi f')" alt="" border=0 src="images/nav55583920i.gi f"></a></div>
<div id="nav2" style="position :absolute; left:132px; top:171px; z-index:22"><a onMouseOut="MM_ swapImgRestore( )" onMouseOver="MM _swapImage('nav 21','','images/nav55583921a.gi f',1)" href="TempahSem inar.html"><img name="nav21" onLoad="MM_prel oadImages('imag es/nav55583921a.gi f')" alt="" border=0 src="images/nav55583921i.gi f"></a></div>
<div id="nav2" style="position :absolute; left:132px; top:211px; z-index:22"><a onMouseOut="MM_ swapImgRestore( )" onMouseOver="MM _swapImage('nav 22','','images/nav55583922a.gi f',1)" href="TempahMes yuarat.html"><i mg name="nav22" onLoad="MM_prel oadImages('imag es/nav55583922a.gi f')" alt="" border=0 src="images/nav55583922i.gi f"></a></div>
<div id="nav2" style="position :absolute; left:132px; top:251px; z-index:22"><a onMouseOut="MM_ swapImgRestore( )" onMouseOver="MM _swapImage('nav 23','','images/nav55583923a.gi f',1)" href="TempahPep eriksaan.html"> <img name="nav23" onLoad="MM_prel oadImages('imag es/nav55583923a.gi f')" alt="" border=0 src="images/nav55583923i.gi f"></a></div>

<select name="hari" style="position :absolute;left: 358px;top:512px ;width:49px;z-index:23">
<option value="">1</option>
<option value="">2</option>
<option value="">3</option>
<option value="">4</option>
<option value="">5</option>
<option value="">6</option>
<option value="">7</option>
<option value="">8</option>
<option value="">9</option>
<option value="">10</option>
<option value="">11</option>
<option value="">12</option>
<option value="">13</option>
<option value="">14</option>
<option value="">15</option>
<option value="">16</option>
<option value="">17</option>
<option value="">18</option>
<option value="">19</option>
<option value="">20</option>
<option value="">21</option>
<option value="">22</option>
<option value="">23</option>
<option value="">24</option>
<option value="">25</option>
<option value="">26</option>
<option value="">27</option>
<option value="">28</option>
<option value="">29</option>
<option value="">30</option>
<option value="">31</option>
</select>

<select name="Bulan" style="position :absolute;left: 462px;top:512px ;width:79px;z-index:24">
<option value="">Jan</option>
<option value="">Feb</option>
<option value="">Mac</option>
<option value="">April</option>
<option value="">Mei</option>
<option value="">Jun</option>
<option value="">Julai</option>
<option value="">Ogos</option>
<option value="">Septem ber</option>
<option value="">Oktobe r</option>
<option value="">Novemb er</option>
<option value="">Disemb er</option>
</select>

<select name="Tahun" style="position :absolute;left: 603px;top:512px ;width:59px;z-index:25">
<option value="">2007</option>
<option value="">2008</option>
<option value="">2009</option>
<option value="">2010</option>
<option value="">2011</option>
<option value="">2012</option>
<option value="">2013</option>
<option value="">2014</option>
<option value="">2015</option>
<option value="">2016</option>
<option value="">2017</option>
<option value="">2018</option>
<option value="">2019</option>
<option value="">2020</option>
</select>

<select name="AMPM" style="position :absolute;left: 452px;top:583px ;width:56px;z-index:26">
<option value="">AM</option>
<option value="">PM</option>
</select>

<select name="AMPM" style="position :absolute;left: 450px;top:548px ;width:56px;z-index:27">
<option value="">AM</option>
<option value="">PM</option>
</select>

<input name="formtext2 " type="text" style="position :absolute;width :336px;left:325 px;top:402px;z-index:28">
<input name="formbutto n1" type="submit" value="HANTAR" style="position :absolute;left: 587px;top:881px ;z-index:29">

</div></body>
</html>

**adamalton** · May 10 '07, 06:04 PM

I don't mean to sound patronising, but I think what you really need to do is get a book on PHP and read up on the basics before getting gong. I recommend Larry Ullman's php books. That's how I got started.

Before you do any php stuff your html form needs sorting out:
Each radio button needs a value, e.g.
Please choose your favorite food:<br>
[HTML]<input type="radio" name="choose_fo od" value="cheese"> Cheese<br>
<input type="radio" name="choose_fo od" value="carrots" >Carrots<br>
Please choose your gender:<br>
<input type="radio" name="gender" value="m">Male< br>
<input type="radio" name="gender" value="f">Femal e<br>[/HTML]
If you have a list of radio buttons with the same name then the user can only choose one from that list. So here they can choose one option from the 'choose_food" options and one option from the "gender" option.

When the user submits the form all of the stuff that they entered will be stored by PHP in $_POST (if your form tag is <form method="POST">)
So the gender they chose will be stored in $_POST['gender'] and the food they chose will be stored in $_POST['choose_food'].

PHP, Dropdowns, and Radio buttons

PHP, Dropdowns, and Radio buttons

Comment

Comment

Comment

Comment

Comment

Comment