In this article we will learn how to do Sorting in PHP using AJAX. The connection between PHP and the MySQL database is done in the config.php file.
Table creation
-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
-- Host: localhost
-- Generation Time: Nov 22,
2008 at 03:06 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- Database: `home_work`
-- Table structure for table
`user_info`
CREATE TABLE `user_info`
(
`id_user_info` int(11) NOT
NULL auto_increment,
`fullname` varchar(255) NOT
NULL default '',
`email` varchar(255) NOT
NULL default '',
`contact_no` varchar(255)
NOT NULL default '',
PRIMARY KEY (`id_user_info`)
TYPE=MyISAM AUTO_INCREMENT=24 ;
-- Dumping data for table `user_info`
INSERT INTO `user_info`
VALUES (1, 'John Smith', '[email protected]', '98675410181');
INSERT INTO `user_info`
VALUES (2, 'Micheal Doughlas', '[email protected]', '98675410131');
INSERT INTO `user_info`
VALUES (3, 'Mary Anderson', '[email protected]', '91675433181');
INSERT INTO `user_info`
VALUES (4, 'James McCarthy', '[email protected]', '98675550131');
INSERT INTO `user_info`
VALUES (5, 'Rosalind Holmes', '[email protected]', '94675433181');
INSERT INTO `user_info`
VALUES (6, 'Pete McCuin', '[email protected]', '98475550131');
INSERT INTO `user_info`
VALUES (7, 'Nicolas Finh', '[email protected]', '98675410181');
INSERT INTO `user_info`
VALUES (8, 'Tommy Lee', '[email protected]', '98675710131');
INSERT INTO `user_info`
VALUES (9, 'Sujoku Jim', '[email protected]', '91675433181');
INSERT INTO `user_info`
VALUES (10, 'James Hull', '[email protected]', '98655550131');
INSERT INTO `user_info`
VALUES (11, 'Sherly Peters', '[email protected]', '94675433181');
INSERT INTO `user_info`
VALUES (12, 'Abraham Holder', '[email protected]', '98400550131');
INSERT INTO `user_info`
VALUES (13, 'Pete Sampras', '[email protected]', '98600010132');
INSERT INTO `user_info`
VALUES (14, 'Kirk Doughlas', '[email protected]', '98675410144');
INSERT INTO `user_info`
VALUES (15, 'Dorothy James', '[email protected]', '91675433165');
INSERT INTO `user_info`
VALUES (16, 'Sebastian Urchin', '[email protected]', '98675550197');
INSERT INTO `user_info`
VALUES (17, 'Tabitha Gregory Golmes', '[email protected]', '94675433133');
INSERT INTO `user_info`
VALUES (18, 'Albert Einstien', '[email protected]', '98475550144');
INSERT INTO `user_info`
VALUES (19, 'Yasser Arafat', '[email protected]', '98675410155');
INSERT INTO `user_info`
VALUES (20, 'Bruce Lee', '[email protected]', '98675710166');
INSERT INTO `user_info`
VALUES (21, 'Johny Depp', '[email protected]', '91675433171');
INSERT INTO `user_info`
VALUES (22, 'Celina Jaitly', '[email protected]', '98655550199');
INSERT INTO `user_info`
VALUES (23, 'Leander Peas', '[email protected]', '94675433100');
config.php
<?php
$DBHOST = "localhost";
$DBNAME = "home_work";
$DBUSER = "root";
$sLink = mysql_connect($DBHOST,$DBUSER,'') or die('Connection with MySql Server failed');
mysql_select_db($DBNAME, $sLink) or die('MySql DB was not found');
?>
Sorting.php
<?php
include('./config.php');
?>
<html>
<head>
<title>User
Information</title>
<script
type="text/javascript"
src="./ajax_sort.js"></script>
<style
type="text/css">
.blackText{
font-weight:normal;
font-size:11.5px;
font-family:
verdana, arial, helvetica, sans-serif;
color:#000000;
font-style:normal;
}
.grayText{
font-weight:normal;
font-size:11px;
font-style:normal;
font-family:
verdana, arial, helvetica, sans-serif;
color:#333333;
}
.errText{
font-weight:italic;
font-size:10.5px;
font-family:
verdana, arial, helvetica, sans-serif;
color:red;
}
</style>
</head>
<body>
<?php
include('./records.php');?>
</body>
</html>
Join the conversation! Your thoughts help the community grow.