dsj2222222 2015-12-20 13:40
浏览 216

PHP无法将变量插入数据库

Problem is in the INSERT INTO statement. I'm trying to insert $today, $id, $stat_sum, $klientas. Everything is inserting except the $id. After I press the submit button, everything is inserting, but where there should be the $id, it shows NULL. I tried to echo $id , it showing normally as it should be.

    $today = date('Y-m-d G:i:s');
if( isset($_GET['pas']) )
    {
        $id = $_GET['pas'];
        $res= mysql_query("SELECT MAX(statymo_suma) FROM statymai WHERE aukciono_id = '$id'");
        $row= mysql_fetch_array($res);
        echo $id;

    }
if( isset($_POST['stat_sum']) )
    {
        echo '<input type="hidden" name="id" value="<?php echo $row[2]; ?>">';
        $stat_sum = $_POST['stat_sum'];
        $id = $_POST['id'];
        $res1= mysql_query("SELECT kliento_id FROM klientai WHERE vartotojo_vardas = '$user_check'");
        $row1 = mysql_fetch_assoc($res1);
        $klientas = $row1['kliento_id'];


        $sql = "INSERT INTO statymai (statymo_laikas,aukciono_id,statymo_suma,kliento_id) VALUES ('$today','$id','$stat_sum','$klientas')";


                     $res =mysql_query($sql)
                                            or die("Negaliu redaguoti".mysql_error());

        //echo "<meta http-equiv='refresh' content='0;url=redaguoti.php'>";


    } 

?>
<form action="pasiulymas.php" method="POST">
Statymo suma: <input type="text" name="stat_sum" value="<?php echo $row[0]; ?>"><br />
<input type="hidden" name="id" value="<?php echo $row[2]; ?>">
<input type="submit" value=" =Redaguoti "/>
</form> 

var_dump($sql) result:

string(123) "INSERT INTO statymai (statymo_laikas,aukciono_id,statymo_suma,kliento_id) VALUES ('2015-12-20 15:04:50','','123456','KL01')"
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 2024-五一综合模拟赛
    • ¥15 如何将下列的“无限压缩存储器”设计出来
    • ¥15 下图接收小电路,谁知道原理
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度
    • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
    • ¥15 ETLCloud 处理json多层级问题
    • ¥15 matlab中使用gurobi时报错
    • ¥15 这个主板怎么能扩出一两个sata口