doujiu6976 2017-06-22 07:10
浏览 56

只执行第一个SQL语句。为什么这样?

I am using the Slim PHP framework for my API. In this function, I have used two statements $sql and $sql1 to execute two different queries. $sql is getting inserted successfully whereas $sql1 is not. I am unable to debug this code.

<?php
use \Psr\Http\Message\ServerRequestInterface as Request;
use \Psr\Http\Message\ResponseInterface as Response;

$app->post('/insert/work_experience', function (Request $request, Response $response) {

$user_id        = $_POST[0];
$company_name   = $_POST[1];
$start_date = $_POST[2];
$end_date       = $_POST[3];
$designation    = $_POST[4];
$vertical       = $_POST[5];
$skillstring    = $_POST[6];

$skill = unserialize($skillstring); 

$sql = "INSERT INTO work_experience (user_id, company_name, start_date, end_date, designation, vertical)
VALUES (:user_id,:company_name,:start_date,:end_date,:designation,:vertical);";

$sql1 = "INSERT INTO skills (user_id, start_date, end_date, skill)
VALUES (:user_id,:start_date,:end_date,:skill);"; 

try{
    //make db object
    $db = new db();

    //connection
    $db = $db->connect();

    $stmt = $db->prepare($sql);

    $stmt->bindParam(':user_id',        $user_id);
    $stmt->bindParam(':company_name',   $company_name);
    $stmt->bindParam(':start_date',     $start_date);
    $stmt->bindParam(':end_date',       $end_date);
    $stmt->bindParam(':designation',    $designation);
    $stmt->bindParam(':vertical',       $vertical);

    $stmt->execute();  //This statement is being executed successfully 

    $stmt1 = $db->prepare($sql1);

    $stmt1->bindParam(':user_id',       $user_id);
    $stmt1->bindParam(':start_date',    $start_date);
    $stmt1->bindParam(':end_date',      $end_date);


    $i=0;
    while($i<count($skill)){
        $skill1 = $skill[$i];
        $stmt1->bindParam(':skill', $skill1);
        $i++;
        $stmt1->execute(); //This statement is not being executed
    }

    echo '{"notice": {"text": "Data Added"}'; 

} catch(PDOException $e){
    echo '{"error": {"text": '.$e->getMessage().'}';
} 

});

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 执行 virtuoso 命令后,界面没有,cadence 启动不起来
    • ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
    • ¥20 有关区间dp的问题求解
    • ¥15 多电路系统共用电源的串扰问题
    • ¥15 slam rangenet++配置
    • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
    • ¥15 ubuntu子系统密码忘记
    • ¥15 保护模式-系统加载-段寄存器
    • ¥15 电脑桌面设定一个区域禁止鼠标操作
    • ¥15 求NPF226060磁芯的详细资料