Hallo ich habe schon am Anfang Stress!
ich lerne gerade php und Mysql über ILS Fehrnstudien. Stand: 75 %
Trotz allem finde ich den Fehler nicht!
Vielleicht kann mir hier geholfen werden
Danke Jacqueline
Fehlermeldungen:
Warning: mysql_connect() [
function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in
C:\xampp\htdocs\cms\system\dbconnect.php on line
3
Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in
C:\xampp\htdocs\cms\system\dbconnect.php on line
4
Warning: mysql_query() [
function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in
C:\xampp\htdocs\cms\system\settings.php on line
4
Warning: mysql_query() [
function.mysql-query]: A link to the server could not be established in
C:\xampp\htdocs\cms\system\settings.php on line
4
225190
Quellcode, ich habe 4 Dateien im Ordner System:
/* dbsettings.php */
<?php
$dbpraefix = "cms_";
$dbhost = "localhost";
$dbpasswort = "A2xK5Mm8";
$dbuser = "root";
$db = "cms";
?>
/* dbconnect.php */
<?PHP
include('dbsettings.php');
$connection = mysql_connect($dbhost,$dbuser,$dbpassword);
mysql_select_db($db,$connection);
?>
/* settings.php */
<?PHP
function getSetting($property){
global $dbpraefix;
$res = mysql_query("SELECT value FROM ".$dbpraefix." settings WHERE property = '".$property."'");
echo mysql_error();
echo $res;
$row = mysql_fetch_row($res);
return $row[0];
}
?>
/* settings.test.php */
<?PHP
include('dbconnect.php');
include('settings.php');
echo getSetting("title");
?>
/* Datenbank= cms, Tabelle= cms_settings, 2 Felder (inhalt in klammern) : property(test), value(test_seite) alles ok */