代码之家  ›  专栏  ›  技术社区  ›  Sagar Parikh

php文件未连接到cpanel中的数据库

  •  -1
  • Sagar Parikh  · 技术社区  · 7 年前

    我试图从存储在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 回复  |  直到 7 年前
        1
  •  1
  •   Michal Hlávka    7 年前

    可能您设置了错误的连接属性?顺便说一下,要注意查询中的输入变量。可能有SQL注入- https://en.wikipedia.org/wiki/SQL_injection