dongmao3131 2015-06-29 22:41
浏览 21

PHP - mySQL - 表单不会工作

I have now reinstalled XAMPP and i got rid of most errors.

But i still have one error. This one :

Warning: mysql_connect(): Access denied for user 'admin'@'localhost' (using password: YES) in D:\xampp\htdocs\login_form\login.php on line 7
Could not connect to database.

SQL DATABASE :

login > users > 
Id = 1
Username = admin
Password = admin

Id = 2
Username = login_system
Password = login_system

index.php :

<!DOCTYPE html>
<html>
  <body>
    <form action="login.php" method="POST">
      <p>Username : </p><input type="text" name="user">
      <p>Password : </p><input type="password" name="pass">
      <br>
      <input type="submit" value="Login">
    </form>
  </body>
</html>

login.php

<?php
  //$ = variables?
  $username = "admin";
  $password = "admin";
  $hostname ="localhost";

  $database_handle = mysql_connect($hostname, $username, $password) or die ("Could not connect to database.");

  $selected = mysql_select_db("login", $database_handle);

  $myusername = $_POST['user'];
  $mypassword = $_POST['pass'];

  $myusername = stripslashes($myusername);
  $mypassword = stripslashes($mypassword);

  //Checks if the mySQL database matches the user inputs.
  $query = "SELECT * FROM users WHERE Username='".$myusername."' and Password='".$mypassword."'";

  $result = mysql_query($query,$database_handle);
  $count = mysql_num_rows($result);

  if ($count==1){
    echo 'Databse connection and code was successful!';
  }
 ?>

It said i needed to add more info which i couldn't.

Random text here..

  • 写回答

1条回答 默认 最新

  • douxian1939 2015-06-29 23:29
    关注

    Please try this and let me know if this works

    <?php
      //$ = variables?
      $username = "root";
      $password = "test123";
      $hostname ="localhost:8080";
    
      $database_handle = mysql_connect($hostname, $username, $password) or die ("Could not connect to databse. Check your internet connection.");
    
      $selected = mysql_select_db("login", $database_handle);
    
      $myusername = $_POST['user'];
      $mypassword = $_POST['pass'];
    
      $myusername = stripslashes($myusername);
      $mypassword = stripslashes($mypassword);
    
      //Checks if the mySQL database matches the user inputs.
      $query = "SELECT * FROM users WHERE Username='".$myusername."' and Password='".$mypassword."'";
    
      $result = mysql_query($query,$database_handle);
      $count = mysql_num_rows($result);
    
      if ($count==1){
        echo 'Databse connection and code was successful!';
      }
     ?>
    
    评论

报告相同问题?

悬赏问题

  • ¥100 为什么这个恒流源电路不能恒流?
  • ¥15 有偿求跨组件数据流路径图
  • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
  • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
  • ¥15 CSAPPattacklab
  • ¥15 一直显示正在等待HID—ISP
  • ¥15 Python turtle 画图
  • ¥15 stm32开发clion时遇到的编译问题
  • ¥15 lna设计 源简并电感型共源放大器
  • ¥15 如何用Labview在myRIO上做LCD显示?(语言-开发语言)