About calculations in $row
Employee number, name, no, object name, travel distance, arrival time, departure time can be obtained directly from the database $row ["]
Drive time, travel speed, operating time need to be calculated to get
Job time I get it this way
Acquisition of travel speed
Question 1: This travel time is described in Excel, such as Zhangsan's no=2 behavior i3-j2 and so on I4-j3,i5-j4,. Can this be handled, is there any way to $row+1 the wrong line calculation?
Question 2: Requirements are grouped by name is it better to use GROUP by? Can I use ORDER by?
Question 3: After each person, there is also a total, such as the need to calculate travel distance and, travel time, and the time of the work, and how to deal with this part?
Question 4: Does the whole work content be easier to handle with Phpexcel?
Thank you
PHP's current code situation is as follows:
PHP code
!--code highlighting produced by Actipro Codehighlig Hter (freeware) http://www. codehighlighter.com/-->!--? phpinclude (' conn.php '); $officename =$_post[' officename ']; $date =$_post[' Riqi ']; $sql 1 = "SELECT * from the record where officename= ' $officename ' and searchtime like '% $riqi% ' order by name"; $result 1=mysql_query ($s QL1); if (Mysql_num_rows ($result 1)!=0) {$row =mysql_fetch_assoc ($result 1); $officecode = $row [' Officecode ']; }else{echo "No such record is being returned to the confirmation page"; echo "
";}? > Date:!--? php echo $date;?-->―― standby point no:!--? php echo $officecode;?-->―― Standby point name:!--? php echo $officename;?--