我试图从我的站点表单获取数据&存储在sql中,但它显示数据库连接错误。
这是我的密码:
<!DOCTYPE html>
<head>
</head>
<body>
<?php
$name = $_POST['name'];
$email = $_POST['email'];
$contact = $_POST['contact'];
$comment = $_POST['comment'];
$link = mysqli_connect("localhost", "epiz_22277887", "A6R6qtbEVDIe", "epiz_22277887_data") or die("ERROR: Could not connect database. ");
if(isset($_POST['name']) && isset($_POST['email'])){
$sql = "INSERT INTO user (name, email, contact, comment) VALUES ('$name', '$email', '$contact', '$comment')";
$result = mysqli_query($link, $sql) or die("ERROR: Could not connect. ");
mysqli_close($link);
?>
<h1>Thank You for Contacting Us <?php echo "<span style='color:purple;'>$name</span>" ?></h1>
<h3>We will be contacting you soon</h3> <a href="index.html">Click here for redirecting site..</a
<?php
}else{
?> <p>Your account have been not registered yet.</p>
<a href="index.html">Click here for redirecting site..</a>
<?php }?>
</body>
</html>
错误为:错误:无法连接数据库。
有人告诉我哪里做错了吗?
1条答案
按热度按时间i7uq4tfw1#
可能您正在设置错误的连接属性?顺便说一下,要小心查询中的输入变量。可能存在sql注入-https://en.wikipedia.org/wiki/sql_injection