Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You could achieve that by using curl and loading the script as a web resource so it can be executed. If that script needs to be protected from public, you can check if the request came from the same server:</p> <pre><code>if( $_SERVER['SERVER_NAME'] != 'localhost' || $_SERVER['REMOTE_ADDR'] != '127.0.0.1' || stripos( $_SERVER['HTTP_USER_AGENT'], 'wget' )===false ) { // Access Denied!! die(); } </code></pre> <p>Be sure to make an asynchronous request with curl, so if the script takes a lot of time to execute, doesn't hang the original user request (use <code>curl_setopt( $handle, CURLOPT_HEADER, false );</code></p> <p>So the plan is from the page where you know you need to execute the script, launch an Http request to the script (this is a very basic example of using curl library):</p> <pre><code>$handle = curl_init(); curl_setopt( $handle, CURLOPT_URL, 'http://localhost/your_script.php'); curl_setopt( $handle, CURLOPT_HEADER, false ); curl_exec( $handle ); curl_close( $handle ); </code></pre> <p>Then in your script, use the above script to protect requests not comming from current server, and do the job.</p> <p><strong>Updated</strong><br> As stated in this question: <a href="https://stackoverflow.com/questions/1555517/sending-a-non-blocking-http-post-request">sending a non-blocking HTTP POST request</a> In your script job you could send this header to close the connection as script is running:</p> <pre><code>// Send the response to the client header('Connection: Close'); // Do the background job: just don't output anything! </code></pre> <p><strong>Updated II</strong><br> Reviewing my own answer, I've checked that <code>curl_setopt( $handle, CURLOPT_HEADER, false );</code> does not create an asynchronous request. I still have not found how to do it.</p>
    singulars
    1. This table or related slice is empty.
    1. POLaunch php file from php as background process without exec()
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USRaúl Ferràs
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POLaunch php file from php as background process without exec()
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThank you for your nice answer! Only, it still keeps waiting for the background process to finish. Is there any way I could set something like a timeout of 0 seconds in cURL?
      singulars
      1. PO
      1. USONOZ
    2. COAh, got it! `curl_setopt( $handle, CURLOPT_TIMEOUT, 1);` It does generate a race condition however; If it takes longer than 1 second to connect this won't work. Also. it keeps the user waiting for one extra second, but I guess I'll just have to accept that.
      singulars
      1. PO
      1. USONOZ
    3. COYou'll need to develop a way that will block second visitor for running the background request if the job is still working.
      singulars
      1. PO
      1. USRaúl Ferràs
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload