Top Questions

  • 2.9 Years

    • Category : Php
    • Location : Chandigarh
    • Posted On : Jan 7, 2016
    if(isset($_GET['mintime']) && isset($_GET['maxtime'])){
        $extraconditionsa = $extraconditionsa ."and TIME_FORMAT (
       str_to_date (
           replace (hour,':',''),'%H%i'),'%H:%i') between '{$_GET['mintime']}' AND '{$_GET['maxtime']}'";
    }
    
    // mysql:How do I check if a column is empty or null in mysql
    SELECT * FROM table_name WHERE NULLIF(some_col, '') IS NULL;

     

  • 2.9 Years

    • Category : Php
    • Location : Chandigarh
    • Posted On : Jan 5, 2016
    $num_rec_per_page=4;
        if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
        $start_from = ($page-1) * $num_rec_per_page; 
    $q="select * from tablename LIMIT $start_from, $num_rec_per_page";
    $res=mysql_query($q);
    while($r=mysql_fetch_array($res))
    {
    //Enter Your code
    }
      <ul class="pagination">
            <?php 
             $sql = "SELECT * FROM `tablename`"; 
               $rs_result = mysql_query($sql); //run the query
               $total_records = mysql_num_rows($rs_result);  //count number of records
               $total_pages = ceil($total_records / $num_rec_per_page); 
             echo "<li><a href='&page=1'>".'&laquo;'."</a></li> "; // Goto 1st page  
            for ($i=1; $i<=$total_pages; $i++) { 
              echo "<li><a href='&page=".$i."'>".$i."</a></li> "; 
          }; 
             echo  "<li><a href='&page=$total_pages'>".'&raquo;'."</a></li> "; // Goto last page
    ?>
    </ul>
    
  • 2.9 Years

    • Category : Php
    • Location : Chandigarh
    • Posted On : Dec 30, 2015
    echo mt_rand(1, 9999999);

     

  • 2.9 Years

    • Category : Php
    • Location : Chandigarh
    • Posted On : Dec 23, 2015
    <form action="" method="post" enctype="multipart/form-data" class="upload_bus"> 
    div class="btn-group col-lg-3 col-md-3 col-sm-6 col-xs-12 rightgp-btns">
      <input class="create-doc" id="upbuss"  type="file" name="upbus" >
    </div>
    </form>
    <center><div id="loader-icon" style="display:none;"><img src="images/loader-time.gif" height="100px" width="100px" /></div></center>
    <script>
    $('input#upbill').change(function(){
    $('form.upload_b').submit();
    })
    $('form.upload_b').submit(function(e){
      var formData = new FormData(this);
      $('#loader-icon').show();
    $.ajax({
    url: "upload_file.php",            
    type: "POST",
    data:  formData,
    mimeType:"multipart/form-data",
    contentType: false,
    cache: false,
    processData:false,
    success: function(data)
    {
      $('#loader-icon').hide();
       window.location.href="example.php";
    }
    });
    return false;
    });
    </script>

     

  • 2.9 Years

    • Category : Php
    • Location : Chandigarh
    • Posted On : Dec 23, 2015

    echo  date('Y-m-d', strtotime('-3 days'));

  • 2.9 Years

    • Category : Php
    • Location : Chandigarh
    • Posted On : Dec 16, 2015
    ALTER TABLE tablename AUTO_INCREMENT = 1
  • 2.9 Years

    • Category : Php
    • Location : Chandigarh
    • Posted On : Dec 15, 2015
    <label for="fileToUpload"><img src="images/fileupload.png" id="blah1" width="50" height="50"/></label><input type="file" name="exmaple" id="fileToUpload" onchange="$('#blah1')[0].src = window.URL.createObjectURL(this.files[0])"  required>
    <style>
    .image-upload > input[type=file]
    {
        display: none !important;
     z-index: 0 !important;
    }
    </style>

     

  • 5.11 Years

    • Category : Htaccess
    • Location : Chandigarh, India
    • Posted On : Dec 15, 2015

    Speed-up your website with these simple .htaccess tricks

    # Do not remove this line or mod_rewrite rules and search engine friendly URLs will stop working
    RewriteBase /
    
    # BEGIN Cache-Control Headers
    <ifModule mod_headers.c>
     <filesMatch ".(ico|jpe?g|png|gif|swf)$">
       Header set Cache-Control "public"
     </filesMatch>
     <filesMatch ".(css)$">
       Header set Cache-Control "public"
     </filesMatch>
     <filesMatch ".(js)$">
       Header set Cache-Control "private"
     </filesMatch>
     <filesMatch ".(x?html?|php)$">
       Header set Cache-Control "private, must-revalidate"
     </filesMatch>
    </ifModule>
    # END Cache-Control Headers
    
    <ifmodule mod_expires.c>
    <Filesmatch "\.(jpg|jpeg|png|gif|js|css|swf|ico|woff|mp3)$">
        ExpiresActive on
        ExpiresDefault A2592000
    </Filesmatch>
    </ifmodule>
    
  • 5.11 Years

    • Category : Php
    • Location : Chandigarh, India
    • Posted On : Dec 8, 2015

    1 Answers

    View More
  • 5.11 Years

    • Category : Php
    • Location : Chandigarh, India
    • Posted On : Dec 7, 2015

    1 Answers

    View More