dqssst0144 2017-06-03 14:03
浏览 120

同时进行PDO SQL查询

i'm having problems with translating simple sql queries to pdo sql queries but my code doesn't seems to run...

I had something like this in simple sql:

Sql(query) 
If(row == variable){
Sql(query)
If(row>variable){
Sql(query)
}
}

This worked in simple sql queries but trying to use pdo doesn't work... I don't know why... Y have to make several pdo for every query? I'm using only one dbh pdo...

require 'dbdata.php';
$fb = $_POST["FB"]; 
$gg = $_POST["GG"];
$points = $_POST["Points"];
$lb = $_POST["leaderboard"];
$ID;
try {
    $DBH = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
    if(!empty($fb)){
        $FBQ = $DBH->prepare("SELECT ID FROM Usuarios WHERE FbID='$fb'");
        $count = $FBQ->rowCount();
        $FBQ->setFetchMode(PDO::FETCH_ASSOC);
        while($row = $FBQ->fetch()) {
        $ID = $row['ID'];}
        if($count > 0){
            $LBQ = $DBH->prepare("SELECT * FROM $leaderboard WHERE UserID = $ID");
            $countlb = $LBQ->rowCount();
            $LBQ->setFetchMode(PDO::FETCH_ASSOC);
            if($countlb >0){
                while($row = $LBQ->fetch()) {

                    if($row['Puntuacion'] < $points){
                        $LBQS = $DBH->prepare("UPDATE $leaderboard SET Puntuacion = $points WHERE UserID = $ID");
                        $LBQS -> execute();
                        echo "Actualizado Record";
                    }
                }
            }
        }
    }
}

Any help is apreciated, thanks in advance!

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 如何实验stm32主通道和互补通道独立输出
    • ¥30 这是哪个作者做的宝宝起名网站
    • ¥60 版本过低apk如何修改可以兼容新的安卓系统
    • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
    • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
    • ¥50 有数据,怎么用matlab求全要素生产率
    • ¥15 TI的insta-spin例程
    • ¥15 完成下列问题完成下列问题
    • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
    • ¥15 YoloV5 第三方库的版本对照问题