Daten aus Datenbank in Schleife ausgeben

[Andre267]

Schönen guten Tag,

Ich komme gerade nicht mehr drauf wie ich mehrere Datensätze aus meiner Datenbank in einer Schleife ausgebe.
Ich habe folgendes probiert:

<?php
	include(class.php);
	$db = new Database("localhost", "root", "", "e_liste");
	
	$q = "SELECT * FROM einkaufen ORDER BY id DESC LIMIT 10";
	$r = $db->query($q);
	
	$zaehler = mysql_numrows($r);
	
	if($zaehler > 0) {
		while($a = mysql_fetch_array($r)) {
			echo "<br> Produkt: ".$a['name']." - Preis: ".$a['price'];
		}
	}
?>

Eigentlich müsste das doch gehen oder?

 

[saftmeister]

Hallo,

kannst du mal die Datei "class.php" anhängen? Außerdem solltest du

include("class.php");

schreiben.

Desweiteren wäre es auch ratsam, die Fehleranzeige zu aktivieren:

ini_set('display_errors', 1);
error_reporting(E_ALL|E_STRICT);

include("class.php");
$db...

Ich glaube, du hast mehrere Fehler drin, genaueres kann man aber erst sagen, wenn man den Inhalt von "class.php" kennt.

 

[Andre267]

Habe ich alles gemacht und ich bekomme nur 1 Datensatz aus der DB. :-/

class.php

<?php
class Database {
 
    private $host;
    private $user;
    private $pass;
    private $name;
    private $link;
    private $error;
    private $errno;
    private $query;
 
    function __construct($host, $user, $pass, $name = "", $conn = 1) {
        $this -> host = $host;
        $this -> user = $user;
        $this -> pass = $pass;
        if (!empty($name)) $this -> name = $name;      
        if ($conn == 1) $this -> connect();
    }
 
    function __destruct() {
        @mysql_close($this->link);
    }
 
    public function connect() {
        if ($this -> link = mysql_set_charset('utf8',mysql_connect($this -> host, $this -> user, $this -> pass))) {
            if (!empty($this -> name)) {
                if (!mysql_select_db($this -> name)) $this -> exception("Could not connect to the database!");
            }
        } else {
            $this -> exception("Could not create database connection!");
        }
    }
 
    public function close() {
        @mysql_close($this->link);
    }
 
    public function query($sql) {
        if ($this->query = @mysql_query($sql)) {
            return $this->query;
        } else {
            $this->exception("Could not query database!");
            return false;
        }
    }
 
    public function num_rows($qid) {
        if (empty($qid)) {         
            $this->exception("Could not get number of rows because no query id was supplied!");
            return false;
        } else {
            return mysql_numrows($qid);
        }
    }
 
    public function fetch_array($qid) {
        if (empty($qid)) {
            $this->exception("Could not fetch array because no query id was supplied!");
            return false;
        } else {
            $data = mysql_fetch_array($qid);
        }
        return $data;
    }
 
    public function fetch_array_assoc($qid) {
        if (empty($qid)) {
            $this->exception("Could not fetch array assoc because no query id was supplied!");
            return false;
        } else {
            $data = mysql_fetch_array($qid, MYSQL_ASSOC);
        }
        return $data;
    }
 
    public function fetch_all_array($sql, $assoc = true) {
        $data = array();
        if ($qid = $this->query($sql)) {
            if ($assoc) {
                while ($row = $this->fetch_array_assoc($qid)) {
                    $data[] = $row;
                }
            } else {
                while ($row = $this->fetch_array($qid)) {
                    $data[] = $row;
                }
            }
        } else {
            return false;
        }
        return $data;
    }
 
    public function last_id() {
        if ($id = mysql_insert_id()) {
            return $id;
        } else {
            return false;
        }
    }
 
    private function exception($message) {
        if ($this->link) {
            $this->error = mysql_error($this->link);
            $this->errno = mysql_errno($this->link);
        } else {
            $this->error = mysql_error();
            $this->errno = mysql_errno();
        }
        if (PHP_SAPI !== 'cli') {
        ?>
 
            <div class="alert-bad">
                <div>
                    Database Error
                </div>
                <div>
                    Message: <?php echo $message; ?>
                </div>
                <?php if (strlen($this->error) > 0): ?>
                    <div>
                        <?php echo $this->error; ?>
                    </div>
                <?php endif; ?>
                <div>
                    Script: <?php echo @$_SERVER['REQUEST_URI']; ?>
                </div>
                <?php if (strlen(@$_SERVER['HTTP_REFERER']) > 0): ?>
                    <div>
                        <?php echo @$_SERVER['HTTP_REFERER']; ?>
                    </div>
                <?php endif; ?>
            </div>
        <?php
        } else {
            echo "+-------+ +-------+\n";
            echo "| +---+ | |       |\n";
            echo "| |   | | |  +----+\n";
            echo "| |   | | |  |     \n";
            echo "| |   | | |  +----+\n";
            echo "| |   | | |       |\n";
            echo "| +---+ | |  +----+\n";
            echo "|  ___  | |  |     \n";
            echo "| (   ) | |  +----+\n";
            echo "|  ---  | |       |\n";
            echo "+-------+ +-------+\n";
            echo "MYSQL ERROR: " . ((isset($this->error) && !empty($this->error)) ? $this->error:'') . "\n";
        };
    }
 
}
?>

 

[Registrierer]

<?php
$zaehler = mysql_numrows($r);
	
if($zaehler > 0) {

?>

Ich bezweifle, dass da überhaupt was rauskommt.

 

[saftmeister]

Ok, was bekommst du zurück, wenn du den Query in phpMyAdmin ausführst?

Versuch mal so:

<?php
    include("class.php");
    $db = new Database("localhost", "root", "", "e_liste");
    
    $q = "SELECT * FROM einkaufen ORDER BY id DESC LIMIT 10";
    $r = $db->query($q);
    
    $zaehler = $db->num_rows($r);
    
    if($zaehler > 0) {
        while($a = $db->fetch_array_assoc($r)) {
            echo "<br> Produkt: ".$a['name']." - Preis: ".$a['price'];
        }
    }