How to prevent repeatable output in PHP MySQL? -

-

i have create 3 rows of data in mysql database have 4 column dtfrom,dtto,timeout,timein

and have 3 sets of row 

dtfrom      dtto        timeout     timein 2016-11-11  2016-11-11  0830     1030 2016-11-12  2016-11-12  0830     1030 2016-11-13  2016-11-13  0830     1030

however, output of "time not passed !" display 3 times below

time not passed ! time not passed ! time not passed !

what want error "time not passed!" display once query. because there's problem if have hundred of data rows. errors appear in hundred of time isn't ?

and second issues cannot run error if input 0845 - 1730 or 0845 - 0945 . it run error if input in database 0830 - 1030

can ? code below 

<?php     $connect      = mysqli_connect("localhost", "root", "", "database");     global $connect;         if(isset($_post['submit']))     {         $user_id        = $_post['user_id'];          $dtfrom         = $_post['dtfrom'];         $dtfrom_user    = strtotime($dtfrom);         $dtto           = $_post['dtto'];         $dtto_user      = strtotime($dtto);          $timeout        = $_post['timeout'];         $timein         = $_post['timein'];          $sql            = "select * table user_id='{$user_id}'  , dtfrom >= '{$dtfrom}' , dtto <= '{$dtto}'";         $run            = mysqli_query($connect, $sql);         if($run && mysqli_num_rows($run) > 0 )         {                            while($result = mysqli_fetch_assoc($run))             {                 $sql1   = "select * table user_id='{$user_id}'  , timeout >= '{$timeout}' , timein <= '{$timein}'";                 $run1   = mysqli_query($connect,$sql1);                 if($run1 && mysqli_num_rows($run1) > 0)                 {                     while($result1 = mysqli_fetch_array($run1))                     {                         echo "time not passed !<br/>";                     }                 mysqli_free_result($run1);                 }                 else                 {                     echo "date & time passed !";                     echo mysqli_error($connect);                 }             }         mysqli_free_result($run);         }         else         {             echo "date passed !";             echo mysqli_error($connect);         }     } ?> <form action="tt.php" method="post">       <table>          <tr>             <td><i class="fa fa-unlock-alt"></i> </td>             <td>user id : </td>             <td><input type ="text" name="user_id" size="30"></td>         </tr>         <tr>             <td><i class="fa fa-unlock-alt"></i> </td>             <td>date : </td>             <td><input type ="text" name="dtfrom" size="30"></td>         </tr>         <tr>             <td><i class="fa fa-unlock-alt"></i> </td>             <td>date : </td>             <td><input type ="text" name="dtto" size="30"></td>         </tr>         <tr>             <td><i class="fa fa-unlock-alt"></i> </td>             <td>timeout : </td>             <td><input type ="text" name="timeout" size="30"></td>         </tr>                 <tr>             <td><i class="fa fa-unlock-alt"></i> </td>             <td>timein : </td>             <td><input type ="text" name="timein" size="30"></td>         </tr>     </table>          <p><input class="btnsuccess" type ="submit" name="submit" value="submit"> </p>               </form>

thanks in advance.


Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more