mysql pdo 关闭_mysql – 通过pdo停止查询

这里的主要问题是在生成报告的异步请求和应该停止它的脚本之间共享PID.

您可以使用以下方式获取PID：

$stmt = $dbh->prepare("SELECT CONNECTION_ID()");

$stmt->execute();

$pid = $stmt->fetchColumn();

您可以使用类似php-shared-memory的内容在脚本之间创建共享变量.如果您没有将Composer用于项目依赖项,则此库具有独立版本(1.5.0,here).

实施样本：

if (!include __DIR__ . '/vendor/autoload.php')

{

die('You must set up the project dependencies.');

}

use Fuz\Component\SharedMemory\SharedMemory;

use Fuz\Component\SharedMemory\Storage\StorageFile;

// your intializations here

$storage = new StorageFile("/tmp/shared.{$user_id}.sync");

$shared = new SharedMemory($storage);

if (!isset($_POST['cancel_request']))

{

$stmt = $dbh->prepare("SELECT CONNECTION_ID()");

$stmt->execute();

$pid = $stmt->fetchColumn();

$shared->pid = $pid;

// your long query here

$shared->destroyStorage();

}

else

{

// kills pid

$pid = $shared->pid;

if (!is_null($pid))

{

$dbh->exec("KILL {$pid}");

}

}