[PHP] Nie chce mi wyswietlic danych z bazy Opcje

[Rafiks1992]

Witam! To moj pierwszy post, zaczynam uczyc sie php ogladalem troche filmikow i zaczalem tworzyc strone, wlasciwie to moze byc nawet cos podobnego do gry via www w celach nauki lecz mam pewien problem dlatego chcialem prosic tutaj o pomoc

Dokladniej chodzi mi o to ze nie chce wyswietlic mi danych z bazy, dodalem do tabeli users kolumne money i ustawilem wartosc domyslna na 3.
Teraz w pliku ktory wyswietla profil uzytkownika chce dodac opcje ktora bedzie wyswietlala aktualny stan konta uzytkownika czyli 3.

Tak wiec w pliku youraccount.php dodaje taki kod:

[PHP] pobierz, plaintext 
<?php
 
$money = 'SELECT money FROM users';
echo 'Twoja ilosc pieniedzy to:'.$money;
 
?>
[PHP] pobierz, plaintext 

Jednak gdy zaktualizuje plik i odswieze strone to pokazuje mi poprostu moje zapytanie czyli:

Twoja ilosc pieniedzy to: SELECT money FROM users

Moglby ktos mnie nakierowac jak to poprawic? Szukalem w internecie kilka sposobow i probowalem tez w innych formatach to zrobic ale nic mi nie pomoglo. Mam nadzieje ze nie zostane na dzien dobry zlinczowany za to ale kazdy kiedys zaczynal (IMG:style_emoticons/default/wink.gif) !

Ten post edytował Kshyhoo 28.06.2017, 08:59:16

Powód edycji: [Kshyhoo]: Używaj bb-code do kodu...

[Rafiks1992]

Sprobowalem tak jak podales wyskoczyl mi blad:
Fatal error: Cannot use object of type User as array in /home/.../account.php on line 172

Linia 172:
echo $userdata['money'];


A w pliku o ktorym mowiles gdzie podaje sie klase uzytkownika znalazlem dane ktore wyswietlane sa w tabeli dokladniej takie cos:

plik userclass.php

[PHP] pobierz, plaintext 
<?php
 
class User {
 
    protected static $table_name = "users";
    protected static $db_fields = array('id', 'username', 'password', 'email', 'status', 'actcode' ,'created_at' ,'money');
 
    public $id;
    public $username;
    public $password;
    public $email;
    public $status = "pending";
    public $actcode;
    public $created_at;
    public $money;
 
    public static function authenticate($username = "", $password = "") {
        global $database;
 
        $username = $database->escape_value($username);
        $password = $database->escape_value($password);
        $password = secure_string($password);
 
        $sql = "SELECT * FROM " . self::$table_name . " users WHERE username = '{$username}' AND password = '{$password}' LIMIT 1";
        $result_array = self::find_by_sql($sql);
        return !empty($result_array) ? array_shift($result_array) : false;
    }
 
	public static function activate($username, $actcode) {
		global $database;
		global $session;
 
		$username = $database->escape_value($username);
        $actcode = $database->escape_value($actcode);
 
		$sql = "SELECT status FROM users WHERE username = '{$username}' AND actcode = '{$actcode}' AND status = 'pending' LIMIT 1";
		$database->query($sql);
		if($database->affected_rows() == 1) {
			$sql = "UPDATE users SET status = 'confirmed' WHERE username = '{$username}' AND actcode = '{$actcode}'";
			$result = $database->query($sql);
 
			if($result) {
				return true;
			} else {
				return false;
			}} else {
			return false;
		}
	}
 
	public static function getUser($username) {
		global $database;
 
		$username = $database->escape_value($username);
 
		$sql = "SELECT * FROM users WHERE username = '{$username}' LIMIT 1";
		$result_array = self::find_by_sql($sql);
        return !empty($result_array) ? array_shift($result_array) : false;
 
	}
 
	public static function user_email($username, $email) {
		global $database;
 
		$username = $database->escape_value($username);
		$email = $database->escape_value($email);
 
		$sql = "SELECT username FROM users WHERE username = '{$username}' AND email = '{$email}' LIMIT 1";
		$database->query($sql);
		if($database->affected_rows() == 1) {
			return true;
		} else 
			return false;
	}
 
	public static function exists($where,$username) {
		global $database;
 
		$username = $database->escape_value($username);
		$where = $database->escape_value($where);
 
		$sql = "SELECT '{$where}' FROM users WHERE {$where} = '{$username}' LIMIT 1";
		$database->query($sql);
		if($database->affected_rows() == 1) {
			return true;
		} else 
			return false;
	}
 
 
    public static function find_all() {
        return self::find_by_sql("SELECT * FROM " . self::$table_name);
    }
 
    public static function find_by_id($id = 0) {
        $result_array = self::find_by_sql("SELECT * FROM " . self::$table_name . " WHERE id={$id} LIMIT 1");
        return !empty($result_array) ? array_shift($result_array) : false;
    }
 
    public static function find_by_sql($sql = "") {
        global $database;
        $result_set = $database->query($sql);
        $object_array = array();
        while($row = $database->fetch_array($result_set)) {
            $object_array[] = self::instantiate($row);
        }
        return $object_array;
    }
 
    public static function count_all() {
        global $database;
        $sql = "SELECT COUNT(*) FROM " . self::$table_name;
        $result_set = $database->query($sql);
        $row = $database->fetch_array($result_set);
        return array_shift($row);
    }
 
    private static function instantiate($record) {
        $object = new self;
        foreach($record as $attribute => $value) {
            if($object->has_attribute($attribute)) {
                $object->$attribute = $value;
            }
        }
        return $object;
    }
 
    private function has_attribute($attribute) {
        return array_key_exists($attribute, $this->attributes());
    }
 
    protected function attributes() {
        $attributes = array();
        foreach(self::$db_fields as $field) {
            if(property_exists($this, $field)) {
                $attributes[$field] = $this->$field;
            }
        }
        return $attributes;
    }
 
    protected function sanitized_attributes() {
        global $database;
        $clean_attributes = array();
        foreach($this->attributes() as $key => $value) {
            $clean_attributes[$key] = $database->escape_value($value);
        }
        return $clean_attributes;
    }
 
    public function create() {
        global $database;
        $attributes = $this->sanitized_attributes();
        $sql = "INSERT INTO " . self::$table_name . " (";
        $sql .= join(", ", array_keys($attributes));
        $sql .= ") VALUES ('";
        $sql .= join("', '", array_values($attributes));
        $sql .= "')";
        if($database->query($sql)) {
            $this->id = $database->insert_id();
            return true;
        } else {
            return false;
        }
    }
 
    public function update() {
        global $database;
        $attributes = $this->sanitized_attributes();
        $attribute_pairs = array();
        foreach($attributes as $key => $value) {
            $attribute_pairs[] = "{$key}='{$value}'";
        }
        $sql = "UPDATE " . self::$table_name . " SET ";
        $sql .= join(", ", $attribute_pairs);
        $sql .= " WHERE id=" . $database->escape_value($this->id);
        $database->query($sql);
        return ($database->affected_rows() == 1) ? true : false;
    }
 
    public function delete() {
        global $database;
        $sql = "DELETE FROM " . self::$table_name;
        $sql .= " WHERE id=" . $database->escape_value($this->id);
        $sql .= " LIMIT 1";
        $database->query($sql);
        return ($database->affected_rows() == 1) ? true : false;
    }
 
}
 
?>
[PHP] pobierz, plaintext 

Dodalem tam na koncu money oraz public $money ale i tak nic nie pomoglo gdzies jeszcze tego mi brakuje (IMG:style_emoticons/default/tongue.gif)