September 6, 2022 in Tips and Tricks

insert command increment one even not inserted due to duplicate values

Prevent auto increment on MySQL duplicate insert

August 27, 2022 in Tips and Tricks

add class when scroll down jQuery

$(window).scroll(function() {    
    var scroll = $(window).scrollTop();

    if (scroll >= 100) {
        $("#audioplayer").addClass("player");
    } else {
        $("#audioplayer").removeClass("player");
    }
});

August 23, 2022 in Tips and Tricks

seconds to days in php

Example 1

function secondsToTime($seconds) {
    $dtF = new \DateTime('@0');
    $dtT = new \DateTime("@$seconds");
    return $dtF->diff($dtT)->format('%a days, %h hours, %i minutes and %s seconds');
}

echo secondsToTime(1640467);
# 18 days, 23 hours, 41 minutes and 7 seconds

Example 2

public function toDateInterval($seconds) {
    return date_create('@' . (($now = time()) + $seconds))->diff(date_create('@' . $now));
}

echo $this->toDateInterval(1640467)->format('%a days %h hours %i minutes'));

18 days 23 hours 41 minutes

August 14, 2022 in Tips and Tricks

str_word_count

str_word_count(string,return,char)

<?php

print_r(str_word_count("Hello world!"));

print_r(str_word_count("Hello world!",1));


print_r(str_word_count("Hello world!",2));

print_r(str_word_count("Hello world & good morning!",1));

print_r(str_word_count("Hello world & good morning!",1,"&"));

?>

August 14, 2022 in Tips and Tricks

run code after ajax success

<script>
    var done = 0;
    var ind=1;
    var timer=3000;
    var forreplace='soatechnology.net';
      $('form#seoform').submit(function(e) {
        $('#btn').html('Please Wait');
        var form = new FormData($('#seoform')[0]);
$.ajax({
    type: "POST",
    url: "Action/AddWebsite.php",
    data: form,
    cache: false,
    contentType: false,
    processData: false,
    success:  function(data){
        //alert("---"+data);
        $("html, body").animate({ scrollTop: 100 }, "slow");
        if(data <= 0)
        {
          $("#info").html('Already submitted');
          done = 0;
        }else{
          $("#info").html('Submit successfully');
          done = 1;
        }
      $('#seoBtn').html('<a href="/free-website-submission" class="btn btn-success">NeW Submit</a>');  
    },
    complete: function (data) {
      staticWebsite = $("#staticWebsite").val();
            $("#curlresult").html('');
           if (staticWebsite.trim() == '') {
                return false;
            }
      if(done)   {
      
      myfun();
      
    }
     }
});
           
            e.preventDefault();          
       
      
               });
              
        function myfun(){
            
       var myVar = setInterval(ajaxfun, timer);
         
           function ajaxfun()
           {
               url=pausecontent.pop();
             url=url.replace(forreplace,staticWebsite);
              
               $.ajax({
                //api call
                url:  'Action/Curl.php',
                //api call end
                data: {
                    url: url,
                                  },
                type: 'POST',
                dataType: 'json',
                beforeSend: function() {
                 
                },
                complete: function(data) {
                     $("#curlresult").append('<li class="list-group-item list-group-item-action bg-light">'+ind+" "+url+'</li>  ');
                  //
                     ind ++;
               if(!pausecontent.length)
            {     clearInterval(myVar);
            
               }
               
                    },
                success: function(data) {
               //  console.log(ind);   
               
                },
                error: function(xhr, ajaxOptions, thrownError) {
                  //  alert(thrownError + "\r\n" + xhr.statusText + "\r\n" + xhr.responseText);
                  $("#curlresult").append('<li class="list-group-item list-group-item-action bg-light">'+ind+" "+url+' Error</li>  ');
                }
            });
           }
            
              
                  
              
        }
        </script>