php - cant insert the difference of this into table -

-

this insert section $total_minutes , $total_hour cant inserted in table

$year = $_post['year'];   $month = $_post['month'];   $day = $_post['day'];   $hour = $_post['hour'];   $min = $_post['min'];   $sec = $_post['sec'];   $year1 = $_post['year1'];   $month1 = $_post['month1'];   $day1 = $_post['day1'];   $hour1 = $_post['hour1'];   $min1 = $_post['min1'];   $sec1 = $_post['sec1'];   $time_in = $year.'-'.$month.'-'.$day.' '.$hour.'-'.$min.'-'.$sec;   $time_out = $year1.'-'.$month1.'-'.$day1.' '.$hour1.'-'.$min1.'-'.$sec1; $total_minutes = $total_min; $total_hour = $total_hr;  $sql = "insert time (year, month, day, hour, min, sec, year1, month1, day1, hour1, min1, sec1, time_in, time_out, total_minutes, total_hour)     values     ('$year','$month','$day','$hour','$min','$sec','$year1','$month1','$day1','$hour1','$min1','$sec1','$time_in','$time_out', '$total_minutes', '$total_hour')";

how can add in table?

minutes

    $datetime1 = strtotime($row['time_in']); //year-month-day hr:min:sec timein   $datetime2 = strtotime($row['time_out']); //year-month-day hr:min:sec timeout   $interval = abs($datetime2 - $datetime1);   $total_min = round($interval / 60);   $total_minutes = $total_min;

hour

function converttohoursmins($total_minutes, $format = '%02d:%02d') {     if ($total_minutes < 1) {         return;     }     $hours = floor($total_minutes / 60);     $wmin = ($total_minutes % 60);     return sprintf($format, $hours, $wmin); } $total_hr = converttohoursmins($total_minutes, '%02d hours %02d minutes'); $total_hour = $total_hr;

im new , wanted simple answer

you have convert datetime1 , datetime2 in format first : 

datetime1 =   2012-01-01   12:00:00; datetime2 =   2012-01-02   13:00:00;

then in sql insert query directly insert value following functions :

timestampdiff(hour, datetime2, datetime1) // hours calculation timestampdiff(minute,datetime2, datetime1) // minutes calculation

hope may :)


Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

reactjs - React router and this.props.children - how to pass state to this.props.children -

-
i'm using react-router first time , don't know how think in yet. here's how i'm loading components in nested routes. entry point .js reactdom.render( <router history={hashhistory} > <route path="/" component={app}> <route path="models" component={content}> </route> </router>, document.getelementbyid('app') ); app.js render: function() { return ( <div> <header /> {this.props.children} </div> ); } so child of app content component sent in. i'm using flux , app.js has state , listens changes, don't know how pass state down this.props.children. before using react-router app.js defines children explicitly, passing state natural don't see how now. using couple of react helper methods can add state, props , whatever else this.props.children render: function() { var children = react.ch...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more