Ajax Tutorial: Dynamic Loading of ComboBox using jQuery and Ajax in PHP

Here is a script for beginners to create a dynamic loading of dropdown. Simple solution which is created by jQuery.

Table Structure

CREATE TABLE IF NOT EXISTS `ajax_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(50) NOT NULL,
  `pid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)

CREATE TABLE IF NOT EXISTS `ajax_categories` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`category` varchar(50) NOT NULL,

`pid` int(11) NOT NULL,

PRIMARY KEY (`id`)

)

get_child_categoires.php

<!--?php
if($_REQUEST)
{
	$id 	= $_REQUEST['parent_id'];
	$query = "select * from ajax_categories where pid = ".$id;
	$results = mysql_query( $query);?--><select id="sub_category_id" name="sub_category">

<option selected="selected" value=""></option>


	<!--?php
	while ($rows = mysql_fetch_assoc(@$results))
	{?-->

<option value="&lt;?php echo $rows['category'];?&gt;  ID=&lt;?php echo $rows['id'];?&gt;"><!--?php echo $rows['category'];?--></option>


	<!--?php
	}?-->


</select>	
	
<!--?php	
}?-->

<!--?php

if($_REQUEST)

{

$id = $_REQUEST['parent_id'];

$query = "select * from ajax_categories where pid = ".$id;

$results = mysql_query( $query);?--><select id="sub_category_id" name="sub_category">

<!--?php

while ($rows = mysql_fetch_assoc(@$results))

{?-->

<!--?php

}?-->

</select>

<!--?php

}?-->

HTML

Select Category

Select Sub Category

5 thoughts on “Ajax Tutorial: Dynamic Loading of ComboBox using jQuery and Ajax in PHP”

Comments are closed.

Table Structure

get_child_categoires.php

HTML

Select Category

Select Sub Category

Few More Brilliant Posts !

5 thoughts on “Ajax Tutorial: Dynamic Loading of ComboBox using jQuery and Ajax in PHP”