I have a file "exmple.dat" with the following data.
1 2018-09-06 16:29:18 1
2 2018-09-06 16:36:03 1
3 2018-09-06 16:36:11 1
4 2018-09-06 16:36:58 1
5 2018-09-06 16:37:56 1
6 2018-09-06 16:38:14 1
7 2018-09-06 16:43:53 1
I want to store this data into mysql table "scheduler". I read the contents using file_get_contents() but how do I insert this contents into the scheduler table with columns sid,date,time and stat?
if(!empty($_FILES)) {
$file = file_get_contents($_FILES["upload_cont_dat"]["tmp_name"], true);
// store content in table
}