数据库中的回显字段未按预期工作 - echoing field from database isn't working as expected?

echoing field from database isn't working as expected?

本文关键字：工作字段数据库 | 更新日期: 2023-09-27

这是一个非常简单的事情做，但由于某种原因，我没有看到我不能从mysql数据库字段回显字段?

下面是我的代码，除了我需要它回显新更新的投票计数，任何帮助将不胜感激。

<?php
require 'core/init.php';
$_SESSION['score'] = $_POST['score'];
$_SESSION['pid'] = $_POST['pid'];
$score  = $_SESSION['score'];
$pid    = $_SESSION['pid'];
$ipaddy = $_SERVER['REMOTE_ADDR'];
$udVote = $db->query("INSERT INTO ratings (score, pid, ip) VALUES ('{$score}','{$pid}','{$ipaddy}')") && $db->query("UPDATE votes SET votecount = votecount +1 WHERE pid='$pid'");
if ($udVote){
    $voteC = $db->query("SELECT votecount FROM votes WHERE pid='$pid' LIMIT 1");
        echo $voteC;
} else {
    echo "error updating database";
}
?>

如果其他人有问题，并在这里寻找解决他们问题的方法，我会在下面发布更新和工作代码。

<?php
require 'core/init.php';
$_SESSION['score'] = $_POST['score'];
$_SESSION['pid'] = $_POST['pid'];
$score  = $_SESSION['score'];
$pid    = $_SESSION['pid'];
$ipaddy = $_SERVER['REMOTE_ADDR'];
$records =array();
if($results = $db->query("SELECT * FROM votes")){
    if($results->num_rows){
        while($row = $results->fetch_object()){
            $records[] = $row;
        }
        $results->free();
    }
}
$udVote = $db->query("INSERT INTO ratings (score, pid, ip) VALUES ('{$score}','{$pid}','{$ipaddy}')") && $db->query("UPDATE votes SET votecount = votecount +1 WHERE pid='$pid'");
if ($udVote){
    if(!count($records)){
        echo 'no records';
    }else{
        foreach ($records as $r){
            echo escape($r->votecount);
        }
        die();
    }
    }else{
        echo "error updating database";
}

?>