Location: PHPKode > scripts > Paging Easy > paging-easy/page_test_db.php
<?php 
$con=mysql_connect('localhost','root','') or die('could not open mySql Connection!');

mysql_create_db('mydb') or die ('unable to create database');
mysql_select_db("mydb") or die('Unable to open database');

$sql="CREATE TABLE member ( username varchar(20),password varchar(20))";
mysql_query($sql) or die('unable to create database');

$sql="INSERT INTO member (username, password) VALUES('nine', 'nineni')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('ten', 'ten123')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('kkkkkakak', 'fffffff')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('dfsf', 'fffffff')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('ram', 'ram')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('wwww', 'ssssss')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('Harish', 'Chauhan')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('harish1', 'Chauhan')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('Harish2', 'Chauhan')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('harish3', 'Chauhan')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('harish4', 'Chauhan')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('raja', 'raja')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('harish5', 'Chauhan')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('rjarajaj', 'raja')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('harish6', 'Chauhan')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('kannan', 'kannan')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('amit', 'bansal')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('mamtadua', 'mitumitu')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('parag', 'parag1')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('parag1', 'parag1')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('raju', 'bhaskar')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('mamta', 'mitumitu')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('meetu', 'mitumitu')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('mitu', 'mitumitu')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('harish12', 'Chauhan')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('sara', 'mitumitu')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('mini', 'mitumitu')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('anand', 'anand12')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('guest2', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('guest1', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('dilip', 'singh1')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('meetudua', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('shikha', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('jini', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('kalai', 'kalai')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('abinaya', 'abinaya')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('mama', 'mamamama')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('chpant', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('test11', 'test11')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('cpant', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('boy', 'goodboy')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('goodboy', 'harish')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('rohit', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('goodboy1', 'harish')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('lina', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('rohit1', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('rohit2', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('local', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('tina', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('bini', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('new', 'new123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('dinky', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('mummy', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('kanaku', 'kanaku')"; 
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('annanana', 'annanana')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('manam', 'manam123')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('kanagu12', 'kanagu12')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('kanagu123', 'kanagu123')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('kapil', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('kamya', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('test5973', 'test5973')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('test59731', 'test59731')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('test597311243', 'test597311243')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('soni', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('pooja', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('aansha', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('rmamammamama', '123456')";
mysql_query($sql);
$sql="INSERT INTO member (username, password) VALUES('megha', '123456')";
mysql_query($sql);

echo "Database Created and data inserted succesfully!";
?>
Return current item: Paging Easy