You can use the database $ row [''] to obtain the employee ID, name, no, object name, driving distance, arrival time, and departure time in $ row. & nbsp; the travel time, speed, and operation time need to be calculated and obtained. & nbsp; how can I obtain the operation time? & lt ;? Phpecho $ dotime = (strtotime about computing in $ row
Employee ID, name, no, object name, driving distance, arrival time, and departure time can be directly obtained through Database $ row ['']
The travel time, speed, and operation time must be calculated and obtained.
I obtained the job time in this way.
Driving speed acquisition
Problem 1: This travel time in excel to describe words such as zhangsan no = 2 for the I3-J2 and so on I4-J3, I5-J4 ,.. Can this be processed? is there any method for calculating the $ row + 1 error row?
Question 2: it is required to group by name. Is it better to use group by here? Can I use order?
Question 3: How can we deal with the sum of distance, time, and time?
Question 4: Is PHPEXCEL easier to process the entire work content?
Thank you.
The current php code is as follows:
PHP code
";}?> Date:
-- NO at the standby point:
-- Standby point name: