<?php
$conn = mysqli_connect('localhost','root','','test');
if(isset($_POST['submit']))
{
$file = $_FILES['file']['tmp_name'];
$handle = fopen($file,"r");
$count = 0;
while(($filesop = fgetcsv($handle,1000,',')) !== false)
{
$fisrtname = $filesop[0];
$lastname = $filesop[1];
$qry = mysqli_query($conn,"insert into names set first_name = '$fisrtname', last_name = '$lastname'");
$count = $count + 1 ;
}
if($qry)
{
echo "Your database has imported successfully. You have inserted ".$count." recoreds";
}
}
?>
<form action="import.php" method="post" enctype="multipart/form-data">
<input type="file" name="file" />
<input type="submit" name="submit" value="Upload" />
</form>
$conn = mysqli_connect('localhost','root','','test');
if(isset($_POST['submit']))
{
$file = $_FILES['file']['tmp_name'];
$handle = fopen($file,"r");
$count = 0;
while(($filesop = fgetcsv($handle,1000,',')) !== false)
{
$fisrtname = $filesop[0];
$lastname = $filesop[1];
$qry = mysqli_query($conn,"insert into names set first_name = '$fisrtname', last_name = '$lastname'");
$count = $count + 1 ;
}
if($qry)
{
echo "Your database has imported successfully. You have inserted ".$count." recoreds";
}
}
?>
<form action="import.php" method="post" enctype="multipart/form-data">
<input type="file" name="file" />
<input type="submit" name="submit" value="Upload" />
</form>
No comments:
Post a Comment