pdo 调用mysql 存储过程

pdo 调用mysql 存储过程

$stmt = $dbh->prepare(“CALL test(:bb)”);
    $aa = ”;
    $stmt->bindParam(‘:bb’, $aa,
PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 4000);
var_dump($stmt->execute());
var_dump($aa);
var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));

$stmt = $dbh-prepare(CALL test(:bb)); $aa = ”; $stmt-bindParam(‘:bb’,
$aa, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 4000);
var_dump($stmt-execute());var_dump($aa);var_dump($stmt-fetchAll(PDO::FETCH_ASSOC));

$stmt = $dbh->prepare(“select * from userinfo where u_id=:id”);
    $aa = 1;
    $stmt->bindParam(‘:id’, $aa,
PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 4000);
var_dump($stmt->execute());
var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));

$stmt = $dbh-prepare(select * from userinfo where u_id=:id); $aa = 1;
$stmt-bindParam(‘:id’, $aa, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT,
4000);
var_dump($stmt-execute());var_dump($stmt-fetchAll(PDO::FETCH_ASSOC));

 

发表评论

电子邮件地址不会被公开。 必填项已用*标注