Cyperfriend
Der ohne Avatar
- Registriert
- 14 Juli 2013
- Beiträge
- 1.123
Kann mir bitte jemand erklären, warum Code 1 funktioniert und Code 2 nicht? Ich blicks nicht. Die Datenbankverbindung kommt bei beiden Codes zustande, aber das Auslesen der Daten klappt nur bei Code 1. Bei Code 2 bekomme ich folgende Fehlermeldung:
[src=php]
$db_host = "**********";
$db_user = "**********";
$db_pass = "**********";
$db_name = "**********";
$mysqli = new mysqli($db_host, $db_user, $db_pass, $db_name);
if($mysqli->connect_error) {
echo "Datenbankverbindung fehlgeschlagen. Fehler: ".mysqli_connect_error();
exit();
}
echo "Datenbankverbindung hergestellt";
$result = $mysqli->query("SELECT kunden_id FROM db_kunden");
while($row = $result->fetch_array()){
echo "Test: ".$row['kunden_id'];
}
[/src]
Code 2.1 (function.inc.php):
[src=php]
function db_connect() {
$db_host = "**********";
$db_user = "**********";
$db_pass = "**********";
$db_name = "**********";
$mysqli = new mysqli($db_host, $db_user, $db_pass, $db_name);
if($mysqli->connect_error) {
echo "Datenbankverbindung fehlgeschlagen. Fehler: ".mysqli_connect_error();
exit();
}
echo "Datenbankverbindung hergestellt";
return $db_connect;
}
[/src]
Code 2.2 (index.php):
[src=php]
$db_connect = db_connect();
$result = $mysqli->query("SELECT kunden_id FROM db_kunden");
while($row = $result->fetch_array()){
echo "Test: ".$row['kunden_id'];
}
[/src]
Code 1:Fatal error: Call to a member function query() on a non-object in ...
[src=php]
$db_host = "**********";
$db_user = "**********";
$db_pass = "**********";
$db_name = "**********";
$mysqli = new mysqli($db_host, $db_user, $db_pass, $db_name);
if($mysqli->connect_error) {
echo "Datenbankverbindung fehlgeschlagen. Fehler: ".mysqli_connect_error();
exit();
}
echo "Datenbankverbindung hergestellt";
$result = $mysqli->query("SELECT kunden_id FROM db_kunden");
while($row = $result->fetch_array()){
echo "Test: ".$row['kunden_id'];
}
[/src]
Code 2.1 (function.inc.php):
[src=php]
function db_connect() {
$db_host = "**********";
$db_user = "**********";
$db_pass = "**********";
$db_name = "**********";
$mysqli = new mysqli($db_host, $db_user, $db_pass, $db_name);
if($mysqli->connect_error) {
echo "Datenbankverbindung fehlgeschlagen. Fehler: ".mysqli_connect_error();
exit();
}
echo "Datenbankverbindung hergestellt";
return $db_connect;
}
[/src]
Code 2.2 (index.php):
[src=php]
$db_connect = db_connect();
$result = $mysqli->query("SELECT kunden_id FROM db_kunden");
while($row = $result->fetch_array()){
echo "Test: ".$row['kunden_id'];
}
[/src]