我试图通过php代码连接到本地数据库,但出现以下错误:
语法错误,意外的“$result”(t\u变量),应为“,”或“)”
我不明白问题出在哪里。这是我的密码:
<?php
$hostname = "localhost";
$username = "root";
$password = "";
$databaseName = "newspage";
$dbConnected = @mysqli_connect($hostname, $username, $password);
$dbSelected = @mysqli_connect($databaseName, $dbConnected);
$query = "INSERT INTO news(titolo, testo, data)VALUES('".$_POST["titolo"]."', '".$_POST["testo"]."', NOW())";
$result = @mysqli_query($query);
if(!$result){
echo("Errore aggiunta news: " . mysqli_error(mysqli $result));
exit();
}
else {
mysqli_close(mysqli $dbConnected);
echo('News caricata!<br><a href="add.php">Clicca qui</a> per aggiungere altre news.<br><a href="edit.php">Clicca qui</a> per apportare modifiche alle news.<br><a href="../index.php">Clicca qui</a> per tornare alla pagina principale.');
}
?>
2条答案
按热度按时间4ngedf3f1#
你的问题是:
应该是:
mepcadol2#
你应该把dbname也传进去
mysqli_connect
```$dbConnected = @mysqli_connect($hostname, $username, $password, $databaseName);
$result = $dbConnected->query("select * from tablename");
$query = "INSERT INTO news(titolo, testo, data)
VALUES('".$_POST['titolo']."', '".$_POST['testo']."', NOW())";