Hi all i have a doubt from the following code i am able to insert single record at a time from notepad to mysql database how can i insert multiple records into mysql database using php
<?php
$conn=mysql_connect("localhost","root","root") or die("cannot connect".mysql_error());
$db=mysql_select_db("kb");
$target_path = "details.txt";
$fcontents = file ($target_path);
for($i=0; $i<sizeof($fcontents); $i++)
{
$line = trim($fcontents[$i]);
$arr = explode(":",$fcontents[$i]); }
$a=trim($arr[1]);
$firstname=explode(":",$fcontents[0]);
$firstname1= $firstname[1];
$a=explode(":",$fcontents[1]);
$lastname =$a[1];
$b=explode(":",$fcontents[2]);
$address= $b[1];
$c=explode(":",$fcontents[3]);
$city= $c[1];
$d=explode(":",$fcontents[4]);
$state= $d[1];
$e=explode(":",$fcontents[5]);
$zip= $e[1];
$f=explode(":",$fcontents[6]);
$email= $f[1];
$g=explode(":",$fcontents[7]);
$telephone= $g[1];
$h=explode(":",$fcontents[8]);
$contacttype= $h[1];
$uplsubscriber = "insert into habitat_coupon_subscribers4(FirstName,LastName,Address,City,State,Zip, Email,ContactType,WorkPhone) values
('".$firstname1."','".$lastname."','".$address."','".$city."','".$state."','".$zip."','".$email."','".$telephone."','".$contacttype."')";
$result = mysql_query($uplsubscriber);
if($result===false)
$_SESSION['errMessage'] = "upload failed";
/*
details.txt
FirstName: Jeanette
LastName: Burleson
Address: 417 PARK RIDGE RD
City: ALBEMARLE
State: NC
Zip: 28001
EMail: bburleson@carolina.rr.com
TelePhone: 704-982-7733
ContactType: Realtor
*/
/*table1
CREATE TABLE `habitat_coupon_subscribers4` (
`subscriber_id` int(10) unsigned NOT NULL auto_increment,
`user_id` int(5) unsigned NOT NULL default '0',
`FirstName` varchar(45) default NULL,
`LastName` varchar(45) default NULL,
`Address` varchar(45) default NULL,
`City` varchar(45) NOT NULL default '',
`State` varchar(20) default NULL,
`Zip` varchar(11) default NULL,
`Email` varchar(60) default NULL,
`ContactType` varchar(7) default NULL,
`WorkPhone` varchar(45) default NULL,
`issubscribe` smallint(5) unsigned default '0',
`isdeleted` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`subscriber_id`),
KEY `FK_ecoup_coupon_subscribers_1` (`user_id`)
);
CREATE TABLE `ecoup_coupon_subscribers1` (
`subscriber_id` int(10) unsigned NOT NULL auto_increment,
`user_id` int(5) unsigned NOT NULL default '0',
`subscriber_name` varchar(45) default NULL,
`subscriber_address` varchar(45) default NULL,
`email` varchar(45) NOT NULL default '',
`issubscribe` smallint(5) unsigned default '0',
`isdeleted` tinyint(3) unsigned NOT NULL default '0',
`city` varchar(45) default NULL,
`state` varchar(45) default NULL,
`zip` varchar(45) default NULL,
PRIMARY KEY (`subscriber_id`),
KEY `FK_ecoup_coupon_subscribers_1` (`user_id`)
);
*/
?>