帮看下这段代码，插入数据库部分出问题，没找到错误-php教程-PHP中文网

War game - add your score

回复讨论(解决方案)

首页

后端开发

php教程

帮看下这段代码，插入数据库部分出问题，没找到错误

Jun 23, 2016 pm 01:58 PM

<!DOCTYPE html><html>        <head>                <meta charset=utf-8/>                <title>War-game -Add Your score</title>        </head>        <body>                <h2 id="War-nbsp-game-nbsp-nbsp-add-nbsp-your-nbsp-score">War game - add your score</h2>                <?php                        if(!empty($_POST['submit']))                        {                                $first_name=$_POST['first_name'];                                $last_name=$_POST['last_name'];                                $score=$_POST['score'];                                echo $first_name;                                echo $last_name;                                echo $score;                                $dbc=mysqli_connect('localhost','root','pengyu2408','score_list')or die('error in connet');                                $query="INSERT INTO score_lis(first_name,last_name,score) VALUES('$first_name','$last_name','$score')";                                mysqli_query($dbc,$query)or die('error_2');                                echo '<p>Thanks for adding your new high score!</p>';                                echo '<p><strong>FIRST_NAME:</strong>'.$first_name.'<br/>';                                echo '<strong>LAST_NAME:</strong>'.$last_name.'</p>';                                echo '<p><strong>Score:</strong>'.$score.'<br/></p>';                                echo '<p><a href="index.php">&lt;&lt;Back to hight score</a></p>';                                //clear the score data to clear the form                                $firet_name="";                                $last_name="";                                mysqli_close($dbc);                        }                ?>                <hr />                <form method ="post" action="<?php echo $_SERVER['PHP_SELF'];?>">                        <label for="name">FIRST NAME:</label>                        <input type="text" id="first_name" name="first_name" /><br />                        <label for="name">LAST NAME:</label>                        <input type="text" id="last_name" name="last_name"/><br />                        <label for="score">Score:</label>                        <input type="text" id="score" name="score"/><br />                        <hr />                        <input type="submit" value="ADD" name="submit"/>                </form>        </body></html

登录后复制

表是这样的