Ahojte mám problem spravil som si prihlasovanie a registráciu v PHP on mi to funguje ale dneska som to chcel zabezpečit cez MD5 ale tu už nastáva problem registrácia prebehne ok meno aj heslo sa vložia do DB ale prihlasovanie nefunguje napíš že Incorrect password/username.
Vopred Ďakujem
Pridávam kod :
login.php
register.phpCode:<?php session_start(); require("db.php"); if(isset($_SESSION['SESS_LOGGEDIN']) == TRUE) { header("Location: " . $config_basedir); } if($_POST['submit']) { $heslo = MD5($_POST['passBox']); $loginsql = "SELECT * FROM logins WHERE username = '" . $_POST['userBox'] . "' AND password = '$password'"; $loginres = mysql_query($loginsql); $numrows = mysql_num_rows($loginres); if($numrows == 1) { $loginrow = mysql_fetch_assoc($loginres); session_register("SESS_LOGGEDIN"); session_register("SESS_USERNAME"); session_register("SESS_USERID"); $_SESSION['SESS_LOGGEDIN'] = 1; $_SESSION['SESS_USERNAME'] = $loginrow['username']; $_SESSION['SESS_USERID'] = $loginrow['id']; $ordersql = "SELECT id FROM orders WHERE customer_id = " . $_SESSION['SESS_USERID'] . " AND status < 2"; $orderres = mysql_query($ordersql); $orderrow = mysql_fetch_assoc($orderres); session_register("SESS_ORDERNUM"); $_SESSION['SESS_ORDERNUM'] = $orderrow['id']; header("Location: " . $config_basedir); } else { echo "Incorrect username/password"; } } else { require("header.php"); ?> <h1>Customer Login</h1> Please enter your username and password to log into the websites. If you do not have an account, you can get one for free by registering. <form action="<?php echo $SCRIPT_NAME; ?>" method="POST"> <table> <tr> <td>Username</td> <td><input type="textbox" name="userBox"> </tr> <tr> <td>Password</td> <td><input type="password" name="passBox"> </tr> <tr> <td></td> <td><input type="submit" name="submit" value="Log in"> </tr> </table> </form> <?php } require("footer.php"); ?>
Code:<?php require("db.php"); if (isset($_POST['submit']) ) { if ( empty($_POST['loginBox']) || empty($_POST['passwordBox']) || empty($_POST['forenameBox']) || empty($_POST['surnameBox']) || empty($_POST['add1Box']) || empty($_POST['add2Box']) || empty($_POST['add3Box']) || empty($_POST['postcodeBox']) || empty($_POST['emailBox'])) { ?> <script language="javascript"> alert("Enter all the information about you!!!."); </script> <meta http-equiv="refresh" content="0; url=register.php"> <?php die(); } $addsql = "INSERT INTO customers (forename, surname, add1, add2, add3, postcode, phone, email, registered) VALUES('" . strip_tags(addslashes( $_POST['forenameBox'])) . "', '" . strip_tags(addslashes( $_POST['surnameBox'])) . "', '" . strip_tags(addslashes( $_POST['add1Box'])) . "', '" . strip_tags(addslashes( $_POST['add2Box'])) . "', '" . strip_tags(addslashes( $_POST['add3Box'])) . "', '" . strip_tags(addslashes( $_POST['postcodeBox'])) . "', '" . strip_tags(addslashes( $_POST['phoneBox'])) . "', '" . strip_tags(addslashes( $_POST['emailBox'])) . "',1)"; mysql_query($addsql); $heslo = MD5($_POST['passwordBox']); $login = "INSERT INTO logins (customer_id, username, password) VALUES(" . mysql_insert_id() . ", '" . strip_tags(addslashes( $_POST['loginBox'])) . "','$heslo')"; mysql_query($login); echo "Registration completed"; ?> <meta http-equiv="refresh" content="5; url=login.php"> <?php } else { require("header.php"); echo "<form action='" . $SCRIPT_NAME . "' method='POST'>"; ?> <table> <tr> <td>Login *</td> <td><input type="text" name="loginBox"></td> </tr> <tr> <td>Password *</td> <td><input type="password" name="passwordBox"></td> </tr> <tr> <td>Forename *</td> <td><input type="text" name="forenameBox"></td> </tr> <tr> <td>Surname *</td> <td><input type="text" name="surnameBox"></td> </tr> <tr> <td>House Number, Street *</td> <td><input type="text" name="add1Box"></td> </tr> <tr> <td>Town/City *</td> <td><input type="text" name="add2Box"></td> </tr> <tr> <td>Country *</td> <td><input type="text" name="add3Box"></td> </tr> <tr> <td>Postcode *</td> <td><input type="text" name="postcodeBox"></td> </tr> <tr> <td>Phone</td> <td><input type="text" name="phoneBox"></td> </tr> <tr> <td>Email *</td> <td><input type="text" name="emailBox"></td> </tr> <tr> <td></td> <td><input type="submit" name="submit" ></td> </tr> <tr><td>* - Required information</td></tr> </table> </form> <?php } require("footer.php"); ?>


Reply With Quote
