暂停PHP CLI脚本以使用户可以使用CTRL-C退出

Question

How to pause the execution of a command line script to give the user the possibility to exit it with a <kbd>Ctrl</kbd>+<kbd>C</kbd>?

For example I have this script for deleting a user id from a number of tables, but would like to halt the script before really doing it:

<?php

define('DBHOST', '/tmp');
define('DBNAME', 'XXX');
define('DBUSER', 'YYY');
define('DBPASS', 'ZZZ');

$TABLES = array('pref_game',
                'pref_hand',
                'pref_luck',
                'pref_match',
                'pref_misere',
                'pref_money',
                'pref_pass',
                'pref_rep',
                'pref_status',
                'pref_users'
        );

if ($argc != 2)
        exit("Missing user id
");

if (!preg_match('/^([A-Z]{2}[0-9]+)$/', $argv[1], $matches))
        exit("Invalid user id
");

$id = $matches[1];
printf("Deleting user %s Press CTRL-C to abort

", $id);

# XXX stop here, but how? XXX

try {
        $db = new PDO('pgsql:host=' . DBHOST . '; dbname=' . DBNAME, DBUSER, DBPASS);
        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        foreach ($TABLES as $table) {
                $sql = sprintf('delete from %s where id=?', $table);
                run_sql($db, $sql, $id);
        }

} catch (Exception $e) {
       exit('Database problem: ' . $e->getMessage());
}

function run_sql($db, $sql, $arg) {
        $sth = $db->prepare($sql);
        $sth->execute(array($arg));
        printf("SQL: %s
Affected rows: %d

", $sql, $sth->rowCount());
}

?>

Using CentOS Linux 5.5 + PHP 5.1.6 + PostgreSQL 8.4.7.

Answer 1

Try with:

    printf("Deleting user %s Press CTRL-C to abort, enter to continue

", $id);
    $fp = fopen("php://stdin","r");
    fgets($fp);

    echo "OK!";