Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class Database{
- public $result;
- public function __construct(){
- $dbHost = "localhost";
- $dbUser = "root";
- $dbPass = "";
- $dbName = "portal";
- $this->conn = mysql_connect("$dbHost", "$dbUser", "$dbPass") or die(mysql_error());
- $mydb = mysql_select_db("$dbName") or die(mysql_error());
- return $this->conn;
- }
- public function execute(){
- $query = $this->sql;
- $result = mysql_query($query);
- return $this->result;
- }
- public function listall(){
- $this->execute();
- $data = array();
- while($fetch = mysql_fetch_assoc($this->result)){
- $data[] = $fetch;
- }
- return $data;
- }
- public function fetch_row(){
- $this->execute();
- $fetch = mysql_fetch_row($this->result);
- $this->data = $fetch;
- return $this->data;
- }
- }
- --------------------------------------------------------------------------------------------
- <?php require_once('database.php'); ?>
- <?php
- class User extends Database{
- public function validate_login($username, $password){
- $this->sql = "SELECT username, password FROM users WHERE username='". $username ."' AND password='". $password . "'";
- $result = $this->execute();
- if(mysql_num_rows($result) == 1) {
- return TRUE;
- }
- return FALSE;
- }
- public function insert($tablename, $username, $password, $email_address){
- $this->sql = "INSERT INTO $tablename(username, password, email_address) VALUES('$username','$password','$email_address')";
- $result = $this->execute();
- if($result){
- return TRUE;
- } else {
- return FALSE;
- }
- }
- }
- $me = new User();
- $me->insert('users', 'a', 'a','a');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement