我正在編寫這個 PHP 程序,它將一條記錄插入一個名為事件的表中。PHP代碼是:<?php$servername = "example.com";$username = "dev";$password = "some password";$dbname = "mydb";$dateModified = gmdate("Y-m-d h:i:s a");// Create connection$conn = new mysqli($servername, $username, $password, $dbname);// Check connectionif ($conn->connect_error) { die($conn -> connect_errno. " : ".$conn -> connect_error);}$sql = "INSERT INTO events (ID, eventName, timeStamp, dateModified)VALUES ('1', 'Login', 'Login', '12/12/2019',".$dateModified;if ($conn->query($sql) === TRUE) { echo "New record created successfully";} else { echo "Error: " . $sql . "<br>" . $conn->error;}$conn->close();?>我收到此錯誤:2002 : Connection timed out有趣的是,如果我將它包裝在一個函數(shù)中并嘗試相同的方法,則會出現(xiàn)此錯誤:1045 : Access denied for user ''@'localhost' (using password: YES)我哪里錯了?
1 回答

精慕HU
TA貢獻1845條經(jīng)驗 獲得超8個贊
查詢中有語法錯誤。
最后缺少封閉括號
字符串登錄被給出了兩次
請參閱下面的更正版本。
$sql = "INSERT INTO events (`ID`, `eventName`, `timeStamp`, `dateModified`) VALUES ('1', 'Login', '12/12/2019', '$dateModified')";
拒絕訪問意味著,用戶dev沒有插入權(quán)限。
- 1 回答
- 0 關(guān)注
- 107 瀏覽
添加回答
舉報
0/150
提交
取消