function Getmicrotime () {
List ($usec, $sec) = Explode ("", Microtime ());
Return ((float) $usec + (float) $sec); }
$time _start = Getmicrotime ();
Include ("connectdb.php");
function Insert_data ($id, $summary, $description, $additional _information, $category)
{
$my _query1 = "INSERT into mantis_bug_text_table (id,description,additional_information)
VALUES (' $id ', ' $description ', ' $additional _information ') ";
$first = mysql_query ($my _query1); $my _query2 = "INSERT into mantis_bug_table (id,project_id,summary,bug_text_id) VALUES (' $id ', ' $category ', ' $s Ummary ', ' $id ');
$second = mysql_query ($my _query2);
Return }
$fp = fopen ("Test.csv", "R");
while ($data = Fgetcsv ($fp, ' 1000 ', ', ')) {
Insert_data ($data [0], $data [1], $data [2], $data [3], $data [4]);
echo "<font color = #ff0000 size = 20> data import success! </font><br><br> "; } Fclose ($FP);
$time _end = Getmicrotime ();
$time = $time _end-$time _start;
echo "Program execution Time:". $time. " Seconds "; |