donglisi8644 2015-09-07 01:23
浏览 58
已采纳

将表单数据插入MySQL数据库表

I want to insert data from a form into a table but everytime i hit submit nothing happens, i checked and re-checked everything but i can't find the reason.

indextest1.php

<!DOCTYPE html>

<html>    
    <head>  
        <title></title>    
        <meta charset="UTF-8">    
        <meta name="author" content="">    
        <meta name="description" content="">    
        <meta name="keywords" content="">   
    </head>    
    <body>
        <form action="test1.php" method="post">
        <input type="text" name="name"><br>
        <input type="text" name="lastname"><br>
        <input type="radio" name="radio" value="one" checked> one<br>   
        <input type="radio" name="radio" value="two" > two<br>
        <select name="drop">   
            <option value="0" selected>0</option>    
            <option value="1">1</option>    
            <option value="2">2</option>    
            <option value="3">3</option>    
            <option value="4">4</option>    
            <option value="5">5</option>   
            <option value="6">6</option>    
            <option value="7">7</option>    
            <option value="8">8</option>    
        </select>
        <input type="checkbox" name="check" value="1"><br>    
        <input type="submit" value="Submit">   
        </form>    
    </body>   
</html>

test1.php

<?php

$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "db-test";

$connect = ("$servername, $username, $password, $dbname") or die ("ERROR DURING CONNECTION");

$name = $_POST["name"];
$lastname = $_POST["lastname"];
$radio = $_POST["radio"];
$drop = $_POST["drop"];
$check = $_POST["check"];

$sql_insert = mysql_query("INSERT INTO test-table (id, name, lastname, radio, drop, check) VALUES ('', '$name', '$lastname', '$radio', '$drop', '$check')");
        header("location: indextest1.php");

?>

Table values

enter image description here

Thanks in advance, i hope i provided all the info needed.

  • 写回答

3条回答 默认 最新

  • dqzlqfqeh845799833 2015-09-07 02:10
    关注

    Besides the other answer,

    Firstly, this part of your query:

    INSERT INTO test-table (id, name, lastname, radio, drop, check)
    

    should read as

    INSERT INTO `test-table` (id, name, lastname, radio, `drop`, `check`)
    

    MySQL is interpreting your table as "test minus table". Use ticks, or rename it using an underscore test_table which is a safe seperator.

    Then you're using two MySQL reserved words, "drop" and "check". Use ticks for those also.

    Reference:

    See how MySQL is telling you where the syntax error begins?

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'drop, check)

    and it would have shown you another one after that being

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'check)

    Just to clarify, you are mixing MySQL APIs with

    mysql_query("INSERT ...
    

    which those mysql_ functions do not intermix with your present method. Use the same from connection to query

    mysqli_query($connect, "INSERT ...
    

    and of course the fact that you're open to SQL injection. Use a prepared statement:

    You should also check for empty fields against your POST arrays such as !empty().

    Sidenote: If an apostrophe or any other character is to be inserted that MySQL will complain about, then you must escape them. Either way, you should.

    Plus, remember to add exit; after header. Otherwise and if you have more code below that, it may want to continue and execute.

    header("location: indextest1.php");
    exit;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 recipe通过gem协议传的是什么
  • ¥15 TS2307: Cannot find module 'cc'.
  • ¥15 100小时学会sap 书上pp章节5.22,标准成本计算逻辑?
  • ¥50 达梦数据库误删日志文件重做DAMENG01.log启动仍然-712错误
  • ¥15 cellranger化学处理类型报错
  • ¥15 用texstudio插入图片出现下面情况,怎么办
  • ¥15 ubantu 用samba挂载windows的共享文件夹,无法挂载二级目录和修改文件
  • ¥15 有没有会五轴RTCP算法,双转台AC结构。
  • ¥25 对于LSTM实践问题的疑问
  • ¥15 PHP中关于排名和显示的问题