douruhu4282 2013-05-23 11:37
浏览 48
已采纳

Onchange更新数据库

I'm trying to make an page where you can select a value in a dropdown select box. When the selection is made it should update the database using the selected value. I use 2 pages one including the html/javascript and one using php. Currently when i select something nothing happens.

What am i doing wrong?

test.php

<html>
<head>
    <script type="text/javascript" src="js/jquery.js"></script> 
    <script>
    function updateDb() {
     $.post("buh.php", $("#form").serialize());
    }
    </script>
</head>
<body>
    <form id="form">
    <?php
        include 'Includes/database_connection.php';
        $sql = "select * FROM sims ORDER BY phonenr asc"    ;
        $result = mysql_query($sql,$con);       
        echo "<select id='select' name='select' onChange='updateDb()'>";
        while ($row = mysql_fetch_array($result)) {
            echo "<option value='" . $row['phonenr'] . "'>" . $row['phonenr'] . "</option>";
        }
        echo "</select>";
    ?>
    </form>
</body>

And buh.php

<?php
include 'Includes/database_connection.php';
$sql = "select * FROM sims ORDER WHERE phonenr='".mysql_escape_string($_POST["select"])."'"     ;
$result = mysql_query($sql,$con);
while ($row = mysql_fetch_array($result)) {
    $id = $row['id'];
    mysql_query("UPDATE pairings SET sim_id='$id' WHERE unit_id='1'")
or die(mysql_error()); 
}

?>

  • 写回答

3条回答 默认 最新

  • douwanc63652 2013-05-23 11:42
    关注

    You have something wrong with you SELECT query

    $sql = "select * FROM sims ORDER WHERE phonenr='".mysql_escape_string($_POST["select"])."'"     ;
                               ^this ORDER here makes no sense
    

    Either remove the word ORDER wich is a clause to order by a column, or assign it a column to order by with the correct syntax

    SELECT * FROM tablename WHERE yourcolumncondition ORDER BY yourcolumntoorderby
    

    Then I would like to remember you that mysql_ functions are deprecated so i would advise you to switch to mysqli or PDO

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥100 高价邀请复制 域天d8联网狗
  • ¥15 本题的答案是不是有问题
  • ¥15 关于#r语言#的问题:(svydesign)为什么在一个大的数据集中抽取了一个小数据集
  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 蓝桥杯单片机第十三届第一场,整点继电器吸合,5s后断开出现了问题
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?