Hi, I am having issue. I have written code of uploading the csv file data in mysql. But when I execute php script either locally or on server. It uses all the disk space and CPU usage to 100%. Code is written below :
include 'db.php';
$handle= fopen('file.csv',"r");
$c=1;
while(($csvdata=fgetcsv($handle,1000,",")) !== FALSE)
{
$domain = $csvdata[0];
$primary_cid = $csvdata[1];
$call_id = $csvdata[2];
$from = $csvdata[3];
$to = $csvdata[4];
$dir = $csvdata[5];
$type = $csvdata[6];
$start = $csvdata[7];
$connect = $csvdata[8];
$end = $csvdata[9];
$trunk = $csvdata[10];
$local = $csvdata[11];
$remote = $csvdata[12];
$recloc = $csvdata[13];
$ipadr = $csvdata[15];
$ivr_ext = $csvdata[17];
$ivr_user = $csvdata[18];
$sql= "INSERT INTO cdr (domain, primary_cid, call_id, source, destination, dir, type, start, connect, endlast, trunk, local, remote, recloc, ipadr, ivr_ext, ivr_user) VALUES ('$domain','$primary_cid','$call_id','$from','$to' ,'$dir','$type','$start','$connect','$end','$trunk','$local','$remote','$recloc','$ipadr','$ivr_ext','$ivr_user')";
$query=mysqli_query($con,$sql);
$c++;
}
fclose($handle);
$close = mysqli_close($con);
if($query && $close)
{
echo "success";
}
else
{
echo "error";
}