Quote:
Originally Posted by Adolf80
|
The IP of the MySQL server is wrong. You must change the first line of the script.
<?php
$m=mysql_connect("192.168.56.101","root",""); <- There you change the IP
mysql_select_db("newproject_db",$m);
if ((isset($_POST['anmelden']))&&(strlen($_POST['name'])>0)&&(strlen($_POST['pw'])>0)&&(strlen($_POST['pww'])>0)) {
if ($_POST['pw']==$_POST['pww']) {
if ($m) {
$e=mysql_query("SELECT MAX(a_index) FROM t_users");
$u=mysql_fetch_row($e);
$u=$u[0]+1;
$e=mysql_query("SELECT MAX(user_code) FROM bg_user");
$b=mysql_fetch_row($e);
$b=$b[0]+1;
$reg_date=date("Y-m-d H:i:s");
$name=$_POST['name'];
$pw=$_POST['pw'];
$x=mysql_query("INSERT INTO t_users VALUES ('$u','$name','$pw','$b','$reg_date','NULL','1','1 ','1','-1','0','0','10','0','','0')");
$y=mysql_query("INSERT INTO bg_user VALUES ('$b','$name','$pw','1')");
mysql_close($m);
if (($x==1)&&($y==1)) {
die("Du wurdest erfolgreich angemeldet.");
}
else {
die("Username ist bereits vorhanden.");
}
}
}
else {
die("Die eingegebenen Passwörter stimmen nicht überein.");
}
}
?>
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
Username:<br />
<input type="text" name="name" maxlength="30" size="30" />
<br />
Passwort:<br />
<input type="password" name="pw" maxlength="15" size="30" />
<br />
Passwort wiederholen:<br />
<input type="password" name="pww" maxlength="15" size="30" />
<br />
<input type="submit" name="anmelden" value="Anmelden" />
</form>