面向对象实现数据库登陆代码,PHP代码库,德仔网

代码语言

代码分类

【PHP】面向对象实现数据库登陆

作者:dezai / 发布于2014/2/24/ 605

面向对象实现数据库登陆

<?php
   class dbclass
   {
    public $connection ;
    public $result ;
    public $fetch_num ;    

      function connect_db($host,$user,$password)
      {
        if(($this->connection = mysql_connect($host,$user,$password)) == FALSE)
        {
          die("Cannot connect to the database . error code:".mysql_error());
        }
      }

      function select_db($dbname,$connection)
      {
         if(mysql_select_db($dbname,$connection)==FALSE)
         {
          die("Cannot to select the database . Error code:".mysql_error());
         }
      }

      function db_query($sql)
      {
        $result = mysql_query($sql);
        if($result == FALSE){
         die("mysql_query execute error . Error code : ".mysql_error());
        }
        $this->result = $result ;
      }

      function fetch_num($result)
      {
        $this->fetch_num = mysql_num_rows($result);
      }
   }
?>



登录验证：login.php



<?php session_start(); ?>
<?php
  require_once("config.php");
  require_once("dbclass.php");
  if(count($_POST)>0)
    if(isset($_POST["username"])&&isset($_POST["password"])){  
     <span style="color:#000000;">  $my_db_class = new dbclass();
    $my_db_class->connect_db(HOST,USER,PASSWD);
    $my_db_class->select_db(DB,$my_db_class->connection);
    $sql = sprintf("SELECT * FROM users WHERE user_name = '%s' AND user_pwd = '%s'" , mysql_real_escape_string($_POST["username"]),mysql_real_escape_string($_POST["password"]));
    $my_db_class->db_query($sql);
    $my_db_class->fetch_num($my_db_class->result);
    if($my_db_class->fetch_num == 1)
</span>     {
      $_SESSION["YES"] = TRUE ;
      $host = $_SERVER["HTTP_HOST"] ;
      $path = dirname($_SERVER["PHP_SELF"]);
      header("Location:http://$host$path/home.php");
    }   

    }

?>

<html>
  <head>
     <title>Login web</title>
  </head>
  <body>
  <?php if(count($_POST)>0) echo "Invalid_login"; ?>
  <form method="post" action="<?php echo $_SERVER["PHP_SELF"] ?>">
    <table>
      <tr>
        <td>Username:</td>
        <td><input type="text" name="username" value="<?php echo $_POST["username"] ?>"/></td>
      </tr>
      <tr>
        <td>Password:</td>
        <td><input type="password" name="password"/></td>
      </tr>
      <tr>
        <td><input type="submit" value="Submit"/></td>
      </tr>
    </table>   
  </form>
  </body>
<html>

试试其它关键字

　数据库登陆　

同语言下

可能有用的

dezai贡献的其它代码(1065)