无法使用php将数据输入数据库 - Unable to enter data into database using php

Unable to enter data into database using php

本文关键字：数据输入数据库 php | 更新日期: 2023-09-27

我无法在数据库中输入数据。请帮忙，让我知道我的代码出了什么问题。

    <?php
    require("dbconn.php");
    if(isset($_POST['submit']))
    {
        $fname = $_POST['fname'];
        $lname = $_POST['lname'];
        $username = $_POST['username'];
        $password = $_POST['pass1'];
        $hash = crypt($password);
        $admin = 0;
        $sqlq = "INSERT INTO user (fname, lname, username, password, admin) VALUES('".$fname."', '".$lname."', '".$username."', '".$hash."', '".$admin."');";
        $result = mysql_query($sqlq);
        if(!$result)
        {
            die("Fatal Error: Unable to insert into database");
        }
    }
?>

dbconn.php如下所示

    <?php
$servername = "localhost";
$susername = "root";
$spassword = "123456";
$dbname = "alphara";
$conn = mysql_connect($servername, $susername, $spassword, $dbname);
if ($conn->connect_error) {
    die("Connection failed with database! " . $conn->connect_error);
} 
?>

请帮我解决问题。返回的查询在phpmyadmin中成功运行。

mysql_connect将不接受数据库名称。因此，请尝试以下连接命令。

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
mysql_connect_db($dbname, $link);
echo 'Connected successfully';
mysql_close($link);
?>

你能在你的dbconn.php 中试试这个吗

<?php
$connection = mysql_connect('localhost', 'mysql_user', '123456');
mysql_select_db('alphara', $connection );
?>