PureBoard

Code: Alles auswählen

<?
$host= "localhost" ;
$user= "admin" ;
$pass= "pass" ;
$database= "usr_web456_2" ;
$dz = mysql_connect($host,$user,$pass);
mysql_select_db($database,$dz);
$sql = mysql_query("SELECT * FROM test_tabelle");

while($dz = mysql_fetch_object($sql)) {
$name = $dz -> name;
$id = $dz -> id;
echo "$id $name<br>";
  }
  mysql_close($dz);

?>

Code: Alles auswählen

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\Programme\xampp\htdocs\PHP\jan-galaxy 2\Template\Default\Mysql\Mysql.php on line 10

Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in C:\Programme\xampp\htdocs\PHP\jan-galaxy 2\Template\Default\Mysql\Mysql.php on line 15

Code: Alles auswählen

$verbindung = mysql_connect ("localhost",$SQL_User, $SQL_PWD)
or die ("keine Verbindung möglich. Benutzername oder Passwort sind falsch");

mysql_select_db($SQL_DB)
or die ("Die Datenbank existiert nicht.");

$abfrage = "SELECT * FROM team ORDER BY id";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
	 {
	$ID=$row->ID;
	echo $ID;
	}

Code: Alles auswählen

<?
$host= "localhost" ;
$user= "user" ;
$pass= "pass" ;
$database= "usr_web456_2" ;
$dz = mysql_connect($host,$user,$pass);
mysql_select_db($database,$dz);
$sql = mysql_query("SELECT * FROM test_tabelle");

while($ds = mysql_fetch_object($sql)) {
$name = $ds -> name;
$id = $ds -> id;
echo "$id $name<br>";
  }
  mysql_close($dz);

?>