hm ... niesom programator ale cerpam z knihy addison wesleya PHP a MYSQL ...pouziva php 4.04 tusim ... ja mam 4.3.4....
chcem vytvorit autorizaciu uzivatelou ... takze mam vytvorenu databazu v mysql TEST a tabulku user ....
dalej mam skript register.php s obsahom :
<html>
<body>

<center>REGISTRACIA</center>
<FORM method="post" action="register_add.php">
Enter a login name

<input name="login" type="TEXT">

enter pasword

<input name="password" type="PASSWORD">

re-enter the password

<input name="password2" type="PASSWORD">




<input type="SUBMIT" value="Register me!">



<input type="RESET" value="Clear me!">
</FORM>
</body>
</html>
ten sa odkazuje na register_add.php s obsahom

<html>
<body>

<?php

#register_add.php
#spojeni do mySQL
require("conn_inc_reg.php");

echo "<center>Delivery etc Registration form</center>";
$error=false;
$pass_error=false;

if (( $login =="") || ($password =="") || ($password2 =="")) {
$error=true;
}
if ( $password != $password2 ) {
$pass_error=true;
}
if ($error) {
echo "
All fields need to be filled in";
}
if ($pass_error) {
echo "
Both passwords fields need to match";
}
if (($error) || ($pass_error)) {
echo "
Back to the register<a href=\"register.php\">form<a>";
exit;

}

#ak sme tu je vsetko v poriatku ....

$sql="INSERT INTO user (login,password) VALUES ('$login','$password')";
$sql2="SELECT * FROM user WHERE login='$login' AND password='$password'";

#kontrola opakujucich sa zaznamov v tabulke user
$mysql_result=mysql_query($sql2,$connection);
#odstranenie chyb pomocou @
$num_rows=@mysql_num_rows($mysql_result);
if ($num_rows !=0 ) {
echo "
this login is alredy in use try another <a href=\"register.php\">back</a>";
exit;

}

#vkladanie uzivatelskeho mena a hesla
if (!mysql_query($sql,$connection)) {
echo "Error cannot add record... check mysql";
echo "
<a href=\"register.php\">back</a>";

exit;
} else {

#vlozenie vporiadku-informacie pre uzivatela
echo "Table updated [".mysql_affected_rows()."] record added
";
echo "Welcome ....Please make a note of your details
";
echo "Login ID:$login Password:$password";
echo "
Go to members <a href=\"register.php\"> login page</a>";
}
mysql_close($connection);
?>
</body>
</html>
ktory vyzaduje conn_inc_reg.php :
<?php
#conn_inc_reg.php
$connection=mysql_pconnect("****","****","****");
if (!$connection) {
echo "Could not connect to Mysql server!";
exit;
}

$db=mysql_select_db("test",$connection);
if (!$db) {
echo "Could not change into the database test";
exit;
}


?>
ak vyplnim login a password tak register_add.php vyhodi hlasenie ze All fields need to be filled in teda akoby si nevzal udaje z register.php....
moze to byt tym ze ten script 4.04 je nekompatibilny s php 4.3.4
aleno tam je ina chyba....