<?php
ini_set('display_errors',1);
error_reporting(E_ALL);
$db_host='localhost';
$db_user='root';
$database='tpetd';
$table='etud';
if (!mysql_connect($db_host, $db_user))
die("can't connec");
if (!mysql_select_db($database))
die("can't selec database");
if (isset($_POST['submit']))
{
$fname= $_FILES['sel_file']['name'];
echo 'uplaod file name :'.$fname.' ';
$chk_exr = explode(".",$fname);
if(strtolower(end($chk_ext)) == "csv")
{
$filename = $_FILES['sel_file']['tmp_name'];
$handle = fopen($filename, "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
{
$sql = "insert into etud(prenom,nom,date) values ('$data[0]','$data[1]','$data[2]')";
mysql_query($sql) or die(mysql_error());
}
fclose($handle);
echo"Success";
}
else
{
echo"invalide";
}
}
?>
<h1>IMPORT CSV FILE</h1>
<form action="<?php echo $_SERVER["PHP_SELF"]?>" method ="post" enctype="multipart/form-data">
imprort file : <input type='file' name='sel_file' size='20'>
<input type='submit' name='submit' value='submit'>
</form>
end(explode('Polymorph\Component\Content\Model\Post'));
preferences:
61.07 ms | 402 KiB | 5 Q