php - 没有数据库选择php转mysql

Question

我正在为一些 friend 制作客户脚本。他们有 GSM/PC 服务。到目前为止我已经做到了:

            <div id="somedialog" class="dialog">
                <div class="dialog__overlay"></div>
                <div class="dialog__content">
                    <form method="post" action="mysql.php"><p align="left"><font color="white" size="5" face="Tahoma">NUME: <textarea name="nume" style="overflow:hidden" rows="1" cols="17"></textarea> PRENUME:  <textarea name="prenume" style="overflow:hidden" rows="1" cols="15"></textarea><br> TIP DEVICE: <textarea name="tipd" style="overflow:hidden" rows="0" cols="15"></textarea>BRAND: <textarea name="brand" style="overflow:hidden" rows="1" cols="15"></textarea> MODEL: <textarea name="model" style="overflow:hidden" rows="1" cols="15"></textarea><br>PROBLEMA: <textarea name="problema" style="overflow:hidden" rows="1" cols="15"></textarea> DETALII: <textarea name="detalii" style="overflow:hidden" rows="1" cols="15"></textarea></p><div><button class="action" data-dialog-close>Inchide</button><button class="action" data-dialog-close>Creaza</button></div></font><input type="submit" value="Submit"></form>
                </div>
            </div>
        </div><!-- /content -->

我的 mysql.php 页面:

<?php
$dbhandle = mysql_connect("localhost", "root", "", "client");

if (!$dbhandle) {
    die("Connection failed: " . mysql_connect_error());
}
echo "Connected successfully";

$nume=$_POST['nume'];
$prenume=$_POST['prenume'];
$tipd=$_POST['tipd'];
$brand=$_POST['brand'];
$model=$_POST['model'];
$problema=$_POST['problema'];
$detalii=$_POST['detalii'];



mysql_query("INSERT INTO client (Nume, Prenume) VALUES ('$nume', '$prenume')");

?>

当我运行脚本时，它给我没有选择数据库。

这是我的数据库的屏幕截图: screenshot

你能帮我吗？

Answer 1

使用mysql_select_db :

$dbhandle = mysql_connect("localhost", "root", "");

if (!$dbhandle) {
    die("Connection failed: " . mysql_connect_error());
}
mysql_select_db('my_database_name', $dbhandle);
....

此处最好的选择更改为 mysqli_* 函数，并为您的表创建一个特定用户，并授予一些权限:

$dbhandle = mysqli_connect("localhost", "client_db_user", "client_db_password", "client");
...