Friday, March 15, 2013

create DB, table and insert data using php


<?php
mysql_connect("127.0.0.1","root","");
mysql_query("create database pagerank");
mysql_query("use pagerank");
mysql_query("create table abc (id int (255), data varchar (500)) if not exits ");
for($a=1;$a<2;$a++)
{
mysql_query("insert into abc (data) values ('sudhir k gupta') ");
mysql_query("insert into abc (data) values ('rajesh k gupta') ");
}
?>

here i am using for loop. so that  i can insert many data at a time
set a<100. it will insert same data 100 time.

1 comment: