Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    singulars
    1. This table or related slice is empty.
    1. POImplementing a 'kill' button in HTML/PHP
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USSam Dufel
    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
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI was busy essentially writing the same reply as this, however, that is not really an answer to the question. Even if you create a script to do what you want (which is non-trivial because having your apache user be able to escalate itself to root is a very dangerous thing indeed) I'm not sure that you will get the behavior you want -- which is to have the system() call return. If that works ok, then you can do what Sam suggests with Ajax (perhaps embedded into the "Calculating" image by adding an anchor tag around it that kills the process.
      singulars
      1. PO
      1. USgview
    2. COSo I tried your suggestion and created an AJAX request. However, my kill button still isn't working. The issue, it seems, is that until the program is finished the server doesn't respond to anything else from the user. Even if they try loading up a different page, it still just hangs waiting for the server. How I've gotten past this so far is by sending the kill command through the terminal myself. I was hoping the Kill button could do that instead of me, but it hasnt. Is there some way of having the program execute in such a way that the server doesn't have to wait for it to do anything else?
      singulars
      1. PO
      1. USMattS
    3. CO@MattS - You might need to separate the system into 3 scripts then - a generic UI page with a "start" button, which sends an ajax request to run the script, and a "kill" button, which sends an ajax request to the kill script.
      singulars
      1. PO
      1. USSam Dufel
 

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