13 Aug 2015

Get value from drop down box using PHP

The drop down box allows you to select one or more values from it. The HTML tag "select" is also known as "drop down" or "pul down" box.You can get value from drop down box using PHP while form submitting.

HTML form with drop down box

The below example describes how to create HTML form with drop down box.

<html>
<body>
<form action="#" method="post">
<select name="country">
<option value="USA">USA</option>
<option value="United Kingdom">United Kingdom</option>
<option value="France">France</option>
<option value="Russia">Russia</option>
<option value="India">India</option>
</select>
<input type="submit" name="submit" value="Submit">
</form>
</body>
</html>

Retrieve input data from drop down box using PHP

You can retrieve input data from drop down box using following types in PHP.

$_POST['drop_down_name'] (if method is post)

$_GET['drop_down_name'] (if method is gett)

$_REQUEST['drop_down_name'] (if method is either post or get)

The following PHP script describes how to retrieve input data from drop down box while form submitting.

While submitting form with select country from drop down box, you can get selected country as output.

Related Post:

Store form values into MySQL table using PHP

13 Mar 2014

Insert data into mysql table using php

You can insert values to mysql table using php. The following mysql query is used for insert data into table.
INSERT INTO table_name VALUES(values datatype(length))

Store values into mysql table using php:

The following php script is used to store values into mysql table.

<?php
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('new') or die(mysql_error());
$query=mysql_query("insert into table1 values(1,'sample1', 'sample1.jpg')") or die(mysql_error());
if($query)
{
echo 'Vaules are inserted into table';
}
else
{
echo'Vaules are not inserted';
}
?>

Note:
If you declared field name as varchar, then you must insert values between single quotation marks ( 'sample1').

Now the values are inserted into table. You can see it in your mysql table at phpmyadmin. Your mysql table look like this:

You inserted values to your table using php.

Get values from user and insert into mysql table using php:

Suppose you want to get values from user. First you have to know how to get values from text boxes.

How to get values from textbox using php:

$name=$_POST['name']; if(method is post)
or
$name=$_GET['name']; if(method is get)
or
$name=S_REQUEST['name']; if(method is either post or get)

where,
S_POST[] is used to get values from textbox, If you use POST method.
S_GET[] is used to get values from textbox, If you use GET method.
S_REQUEST[] is used to get values from textbox, If you use either GET or POST method.

Then the following php code is used to insert values into table.

Where,
the values will get from users using post method like as below:
$_POST['textbox_name']

Now you run this file. Your display look like this:

Then you can get values, if user type anything in textbox. Now i added values as like this:

Get values from user and stored into mysql table using php

Now you'll get output like this:

Your mysql table have user inserted values.

Related Post:

How to avoid duplicate values storing in mysql table using php and mysql

Pages