1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22: 
23: 
24:

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22: 
23: 
24: 
25: 
26: 
27: 
28: 
29: 
30: 
31: 
32: 
33: 
34: 
35: 
36: 
37: 
38: 
39: 
40: 
41: 
42: 
43: 
44: 
45: 
46:

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9:

also ich bekomme nur fehlermeldungen hier mal die meldungen
Warning: mysql_connect(): Access denied for user: 'web5@localhost' (Using password: NO) in /usr/local/httpd/htdocs/kunden/web5/html/treffen/login.php on line 5

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /usr/local/httpd/htdocs/kunden/web5/html/treffen/login.php on line 5

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /usr/local/httpd/htdocs/kunden/web5/html/treffen/login.php on line 7

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/httpd/htdocs/kunden/web5/html/treffen/login.php on line 8
Username or Password incorrect 

1: 
2:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/httpd/htdocs/kunden/web5/html/treffen/login.php on line 15
Username or Password incorrect 

1: 
2: 
3:

Unknown column 'Marco' in 'where clause'
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/httpd/htdocs/kunden/web5/html/treffen/login.php on line 16
Username or Password incorrect 

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19:

$connection=mysql_connect($DBHost, $DBUsername, $DBPassword); 
$db=mysql_select_db($DB, $connection);

$query="Select * from User where Username=’".$_POST["username"]."’ and Password=’".md5($_POST["password"])."’" ;
$result=mysql_query($query, $connection);
print mysql_error();
$row=mysql_fetch_array($result);
if($row["id"])
$_SESSION["authenticated"]=2;
else
echo "Username or Password incorrect";
}

if ($_SESSION["authenticated"]==0)
{
echo "Session doesn’t exist. Maybe has expired";
}

if ($_SESSION["authenticated"]==2)

1:

if($row["id"])

1:

´

1: 
2: 
3: 
4:

$query = sprintf("SELECT * FROM User WHERE Username='%s' AND Password='%s'",
				$_POST['username'],
				md5($_POST['password']));

1:

Username or Password incorrect

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22: 
23: 
24: 
25: 
26: 
27: 
28: 
29: 
30: 
31: 
32: 
33:

# phpMyAdmin SQL Dump
# version 2.5.3-rc2
# http://www.phpmyadmin.net
#
# Host: localhost
# Erstellungszeit: 24. November 2003 um 16:54
# Server Version: 3.23.37
# PHP-Version: 4.3.3
# 
# Datenbank: `usr_web5_1`
# 

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `User`
#
# Erzeugt am: 24. November 2003 um 15:19
# Aktualisiert am: 24. November 2003 um 16:52
#

DROP TABLE IF EXISTS `User`;
CREATE TABLE `User` (
  `username` varchar(10) NOT NULL default '',
  `password` varchar(32) NOT NULL default ''
) TYPE=MyISAM;

#
# Daten für Tabelle `User`
#

INSERT INTO `User` (`username`, `password`) VALUES ('marco', '101186a9a44bc0354ed997696a6aefba'),
('webmaster', '101186a9a44bc0354ed997696a6aefba');

1:

if($row['id'])

1:

if(mysql_num_rows($result))

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22: 
23: 
24: 
25: 
26: 
27: 
28: 
29: 
30: 
31: 
32: 
33: 
34: 
35:

# phpMyAdmin SQL Dump
# version 2.5.3-rc2
# http://www.phpmyadmin.net
#
# Host: localhost
# Erstellungszeit: 24. November 2003 um 17:03
# Server Version: 3.23.37
# PHP-Version: 4.3.3
# 
# Datenbank: `usr_web5_1`
# 

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `User`
#
# Erzeugt am: 24. November 2003 um 17:02
# Aktualisiert am: 24. November 2003 um 17:02
#

DROP TABLE IF EXISTS `User`;
CREATE TABLE `User` (
  `id` int(10) NOT NULL auto_increment,
  `username` varchar(10) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

#
# Daten für Tabelle `User`
#

INSERT INTO `User` (`id`, `username`, `password`) VALUES (3, 'marco', '101186a9a44bc0354ed997696a6aefba'),
(4, 'webmaster', '101186a9a44bc0354ed997696a6aefba');