Timeout - loader during php script

Question

I have a php script that is insert large result on my mysql dbb. I did jquery script to waiting the end of the php script. But I have a timeout error. Do you have an idea to change the timeout to let the script do his job ?

Thank you

Jquery script :

  <script type="text/javascript">
    var dataReturn='';

    function makeRequest(url){
        $('#preloader').show();
        $.get(url, function(data) {
            timeout: timeoutvalue
            $('#resultDiv').html(data);
            $('#preloader').hide();
        }).fail(function() {
            alert( 'Error occured during requesting the page' );
            $('#preloader').hide();
        });
    }

    function makePostRequest(url, params){
        $('#preloader').show();
        $.post(url,params, function(data){
            $('#resultDiv').html(data);
            $('#preloader').hide();
        }).fail(function() {
            alert( 'Error occured during requesting the page' );
            $('#preloader').hide();
        });
    }

    </script>
    <style>
        #preloader{
            display:none;
        }
    </style>

Button to start de script :

<input type="submit" onClick="makeRequest(\'inserttodbb.php?fonction=import_csv\')" value="" style="width:59px; height:17px; background:url(images/button-importstart.png) repeat-x left center;border:0;margin-left:0px; float:center;" />

Php page inserttodbb.php :

if(isset($_GET['fonction']) and $_GET['fonction']=="import_csv_valid")
{


$data=$_SESSION['listeok'];
    $count=count($data);

foreach($data as $numero)
{

    $req=("INSERT INTO contact VALUES('".$idclient."','', '".$numero."','','','','','','','0')");   
    $doins = mysql_query($req) or die(mysql_error()); 
}
echo 'Import OK for '.$count.' number !';


}

I have not the problem of time out when I load the php page. But when I try to use the ajax loader I have a problem with the message "Error occured during requesting the page". I tryed to put the timeout to 900000 but the problem continue. An idea ?

function makeRequest(url){
    $('#preloader').show();
    $.ajax({
        type: "GET",
        url: url,            
        timeout: 9000000,  //10 seconds, define this value in milliseconds
        success: function(data){
            $('#resultDiv').html(data);
            $('#preloader').hide();
        },
        error: function() {
            alert( 'Error occured during requesting the pagesssssss' );
            $('#preloader').hide();
        }
    });
    }

ojovirtual · Accepted Answer · 2014-02-11 15:28:16Z

1

If the timeout is in the ajax call (not the PHP script) you can use this:

function makeRequest(url){
        $('#preloader').show();
        $.ajax({
            type: "GET",
            url: url,            
            timeout: 10000,  //10 seconds, define this value in milliseconds
            success: function(data){
                $('#resultDiv').html(data);
                $('#preloader').hide();
            },
            error: function() {
                alert( 'Error occured during requesting the page' );
                $('#preloader').hide();
            }
        });
}

EDIT:

Another option is to define a global timeout value. Put this in your code BEFORE calling makeRequest().

$.ajaxSetup({
    timeout:10000 // 10 seconds
});

edited Feb 11, 2014 at 15:28

answered Feb 11, 2014 at 15:22

ojovirtual

3,36219 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pieter De Schepper · Accepted Answer · 2014-02-11 15:18:22Z

1

What you can do is to put set_time_limit(0);at the top of your script. This will make sure your script will not time out.

However, this might not be the best solution, you should also investigate why your script is timing out and if you can reduce the amount of work it needs to do in one go.

answered Feb 11, 2014 at 15:18

Pieter De Schepper

4761 gold badge4 silver badges10 bronze badges

1 Comment

Sylvain Over a year ago

unfortunately I have to manage data[] with around 10 000/20 000 result. So, to insert into db it need some minimum time.

Community · Accepted Answer · 2023-11-21 15:10:29Z

0

Within a PHP script

You can use set_time_limit() at the top of your PHP script to prevent timeouts.

set_time_limit(0); //no timeout

Within php.ini

If your host supports it, you can also set max_execution_time in php.ini:

max_execution_time 0

edited Nov 21, 2023 at 15:10

CommunityBot

11 silver badge

answered Feb 11, 2014 at 15:19

tdlive aw'sum

4001 silver badge7 bronze badges

Collectives™ on Stack Overflow

Timeout - loader during php script

3 Answers 3

Comments

1 Comment

Within a PHP script

Within php.ini

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Within a PHP script

Within php.ini

Comments

Your Answer

Sign up or log in

Post as a guest

Related