目前,我正在尝试生成一些代码来将值插入到表中:
<?php
error_reporting(E_ALL);
ini_set('display_errors', 'on');
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "database";
$sock = "/tmp/mysql.sock";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname, $sock);
// Check connection
if ($conn->connect_error) {
echo ("Connection failed: ");
}
$sql = "INSERT INTO table (firstname, surname)
VALUES ('John', 'Doe')";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>";
}
?>
(某些名称已更改)但当我运行它时(错误显示打开!),上面写着:
警告:mysqli::mysqli()期望参数5很长,第180行/www/sites/545/473/www.example.co.uk/web/page.php中给出的字符串
还有:
警告:mysqli::query():无法在第189行的/www/sites/545/473/www.example.co.uk/web/page.php中获取mysqli
错误:插入表(名字,姓氏)值('john','doe')
在打开php的实时页面上。我不知道为什么会这样?
