Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>First I suggest you to reorder your tasks:</p> <ol> <li>User uploads an image</li> <li><p>Upload confirmation is sent to user.</p></li> <li><p>Image is processed</p></li> <li>Other time intensive functions are called</li> </ol> <p>Then you have following options, how to deffer parts 3&amp;4:</p> <p>Option 1: Send confirmation to user on step 2, use <code>ignore_user_abort()</code> and continue with handling image (non optimal, as user will still see "page loading" message.</p> <p>Option 2: IBP-style. Do steps 1-2, then add processing job to some sort of database. At random time show image to the users.. Image is actually link to the php script that do <code>ignore_user_abort()</code> and process your queue of items.</p> <p>Option 3: Same as option 2, but don't show image. Instead, you will have to do request to own server with cURL, or similar. Idea is that you start request, and don't wait for it to end, just stop main script execution.</p> <p>Option 4: start a cron script that starts every 5-15 minutes and do needed tasks. It can also live on background 24h, and sleep for 20 seconds between checking for tasks. This option might be best in case you have relatively busy website. </p> <p>Option 5: try to do something like exec() or shell_exec() to ruin processing script on background, after you added task to the queue. </p> <p>Examples of how to do options 2 &amp; 3: <a href="https://stackoverflow.com/questions/124462/asynchronous-php-calls">Asynchronous PHP calls?</a> <a href="https://stackoverflow.com/questions/962915/how-do-i-make-an-asynchronous-get-request-in-php">How do I make an asynchronous GET request in PHP?</a></p>
    singulars
    1. This table or related slice is empty.
    1. POHow can I call part of my PHP program to be called at a later time
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USOleg Liski
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    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. VTUpMod
    1. COWhat if 3 and 4 fails ? Confirmation is already sent.
      singulars
      1. PO
      1. USAbhishek Saha
    2. COstep 2 says that image is uploaded, not processed, so I don't see a problem with steps 3&4 failed :) In addition to that.. If there is queue implemented, you can easilly reprocess image that is failed in next script instance. (you can do this with options 2-5, not with option 1)
      singulars
      1. PO
      1. USOleg Liski
    3. COOptoin 4 is the most reliable in my experience. +1. Thanks.
      singulars
      1. PO
      1. USdotancohen
 

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