MySql after inset trigger not exporting new inserted data into csv file

[Priyadarshni Sagar]

I am calling the procedure to export a newly inserted record into the CSV file from MySQL after insert trigger. For dynamic file generation, I wrote a PHP script. The procedure is invoking this PHP script by UDF function, sys_exec. The problem, I am facing here is my trigger is calling procedure before actually inserting data into the database so after every after insert trigger call, I am getting old records in CSV file. Is there any solution to get only new inserted data into CSV file? Here is my after insert trigger, which gives a call to the procedure for exporting CSV file:

BEGIN
call exportFile();
END

exportFile procedure:

BEGIN
DECLARE RESULT INT;
SET RESULT = sys_exec('php C:/export.php');
END

PHP script to generate a new CSV file and write a new inserted record in the file:

$query = " select id from table ";
$result = mysqli_query($conn, $query);
while($row = mysqli_fetch_row($result)) {
fputcsv($fp, $row);

}