php - Getting error Mysql. PDO -

php - Getting error Mysql. PDO -

i created profile.php page after log in user profile, want display users info. next error.

error messagefatal error: phone call fellow member function fetch() on non-object in /home/a6150953/public_html/profile.php on line 16` help me solution please.

profile.php

<?php session_start(); //session_destroy(); include_once('php/classes/class.user.php'); $user1 = new user($con); if(isset($_post['logout'])) { session_destroy(); header('location: index.php'); } include_once('php/common/head.php'); $all = $con->fetch("select * users"); ?> <div class="wrapper"> <h1> <?php if(isset($_session['uid'])){ echo "profile page ". $all[0]['fullname'] ." "; }else{ echo "welcome", "<br/><a href='index.php'>login</a>"; } ?> </h1> <pre> <div id="profile"> <?php if(isset($_get['uid']) || isset($_session['uid'])) { if($_get['uid'] == $_session['uid']) { echo " " . $all[0]['fullname'] . " "; echo "<form action='' method='post'> <input type='hidden' name='logout' value='true' /> <input type='submit' name='submit' value='logout'> </form>"; }else if($user1->check_user($uid)){ echo '<p>'.$all[0]['fullname'].'</p>'; echo '<p>'.$all[0]['uemail'].'</p>'; }else if(!$user1->check_user($uid)){ echo "invalid user"; } }else{ echo "incorrect"; } ?> </pre> </div> </div> <?php include_once('php/common/foot.php'); ?>

db_config.php

<?php class dbengine { public $con; public $errors; public function __construct("login credentials cant show") { seek { $this->con = new pdo("mysql:host=$host;dbname=$db",$user,$pass, array(pdo::attr_errmode => pdo::errmode_warning)); } grab (exception $e) { $this->errors['connect']['message'] = $e->getmessage(); $this->errors['connect']['error_code'] = $e->getcode(); } } public function fetch($_sql) { $query = $this->con->prepare($_sql); $query->execute(); $this->errors['fetch'][] = $query->errorinfo(); if($query->rowcount() > 0) { while($rows = $query->fetch(pdo::fetch_assoc)) { $array[] = $rows; } } homecoming (isset($array) && $array !== 0 && !empty($array))? $array: 0; } // simple write db method public function write($_sql) { $query = $this->con->prepare($_sql); $query->execute(); $this->errors['insert'][] = $query->errorinfo(); } } // use/initialize $con = new dbengine(); ?>

class.user.php

<?php class user { public $db; public $error; public function __construct($con){ $this->db = $con; } /*** login process ***/ public function check_login($username='', $password=''){ // validate email real 1 if(filter_var($username,filter_validate_email) !== false) { $password = md5($password); $sql = "select uid users (uemail='$username' or uname='$username') , upass = '$password'"; $result = $this->db->fetch($sql); if ($result !== 0) { // login var utilize session thing $_session['emailusername'] = $result[0]['uemail']; $_session['uid'] = $result[0]['uid']; $_session['user'] = $this->get_fullname($result[0]['uid'],0); $_session['login'] = true; } else $this->error['account'] = 'invalid username/password'; } else $this->error['email'] = 'invalid email address'; homecoming (!isset($_session['emailusername']))? false:true; } /*** showing username or fullname ***/ public function get_fullname($uid, $write = 1){ // --> can prepare, bind, , execute values here replacing have now....<-- $sql = "select * users uid = $uid"; $user_data = $this->db->fetch($sql); if($user_data !== 0) { $user['fullname'] = $user_data['fullname']; $user['uemail'] = $user_data['uemail']; $user['uid'] = $user_data['uid']; // gives alternative of returning array (setting session array) or echoing if($write == 1) echo implode("<br />",$user); else homecoming $user; } } public function check_user($uid) { $sql = "select * users uid='$uid'"; $result = $this->db->fetch($sql); $count_row = ($result !== 0)? count($result): 0; homecoming ($count_row == 1); } /*** starting session ***/ public function get_session() { homecoming $_session['login']; } public function user_logout() { $_session['login'] = false; session_destroy(); } } ?>

update :

still getting error ::::: call undefined method user::fetch() in line 16

you need include dbengine class page , utilize $con still.

include_once('php/classes/db_config.php');

you including user class page, should be:

// db class include_once('php/classes/db_config.php'); // user class include_once('php/classes/class.user.php'); // $con db class, , `fetch` in class $all = $con->fetch("select * users");

php mysql pdo