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条)

报告相同问题?

悬赏问题

  • ¥20 关于#r语言#rda分析作图的问题,请各位专家解答!
  • ¥50 找回 股票行情系统的资源问题
  • ¥15 gwas 分析-plink 检查人口分层出现下面问题
  • ¥15 关于#matlab#的问题:需要 MATLAB 运行程序,对比四个多址通信方式(TDMA,FDMA,CDMA,OFDMA)的抗噪声性能
  • ¥15 有没有复现过PFENet的,如何解决?
  • ¥15 vue3使用swiper轮播图循环失败
  • ¥15 FDMA,OFDMA,TDMA 和 CDMA 系统容量对比仿真
  • ¥15 图神经网络的入侵检测
  • ¥15 工业数据采集技术+存储架构推荐
  • ¥15 GPT-SOVITS如何训练少数民族语言支持合成语音