hahahas, didnt think you would. hehehes. no worries. LOL. i am part of uni glam! hahahas. different campus thats all. yes, im using the uni glam server to upload my web pages. kekekes* ~
you don't give much to work with.. what do you mean exactly by the data is not correct in the database? do you mean it doesn't save to the database? is the data saved in the wrong table/column?
lol, cos like i said - havent really done much. okay, the user fills in the register page right? and then the data should be stored on database correct. - Yes, the data does store but their 'date of birth' is stored correctly on the database. - The user can type a number or text or anything, it will still store that info the user typed. - When the user register, i can't seem to log in as the user - when testing. _______________________________________________________________ Register.html: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>UK-Chinese Channel | Register</title> <link href="style.css" rel="stylesheet" type="text/css" /> </head> <body> <div id="banner"> <center style="position: absolute; top: 2%; left: 3%;"><img src="Banner.png" /> </div> <div id="main2"> <center style="position: absolute; top: 35%; left: 30%;"> <u>Register</u> </div> <br /> <div id="main"> <center style="position: absolute; top: 39%; left: 30%;"> <form id="login" name="login" method="post" action="register.php"> <table width="520" border="0"> <tr> <td width="500">Choose a username:</td> <td width="191"><input name="Username" type="text" id="Username" /></td> </tr> <tr> <td>Choose your password:</td> <td><input name="Password" type="Password" id="Password" size="40" maxlength="40" /></td> </tr> <td>Re-type your Password:</td> <td><input name="Password2" type="Password" id="Password2" size="40" maxlength="40" /></td> </tr> <tr> <td>Enter your date of birth:</td> <td><select name="DateOfBirth_Day"> <option> - Day - </option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option value="14">14</option> <option value="15">15</option> <option value="16">16</option> <option value="17">17</option> <option value="18">18</option> <option value="19">19</option> <option value="20">20</option> <option value="21">21</option> <option value="22">22</option> <option value="23">23</option> <option value="24">24</option> <option value="25">25</option> <option value="26">26</option> <option value="27">27</option> <option value="28">28</option> <option value="29">29</option> <option value="30">30</option> <option value="31">31</option> </select> <select name="DateOfBirth_Month"> <option> - Month - </option> <option value="1">January</option> <option value="2">Febuary</option> <option value="3">March</option> <option value="4">April</option> <option value="5">May</option> <option value="6">June</option> <option value="7">July</option> <option value="8">August</option> <option value="9">September</option> <option value="10">October</option> <option value="11">November</option> <option value="12">December</option> </select> <select name="DateOfBirth_Year"> <option> - Year - </option> <option value="2004">2004</option> <option value="2003">2003</option> <option value="2002">2002</option> <option value="2001">2001</option> <option value="2000">2000</option> <option value="1999">1999</option> <option value="1998">1998</option> <option value="1997">1997</option> <option value="1996">1996</option> <option value="1995">1995</option> <option value="1994">1994</option> <option value="1993">1993</option> <option value="1992">1992</option> <option value="1991">1991</option> <option value="1990">1990</option> <option value="1989">1989</option> <option value="1988">1988</option> <option value="1987">1987</option> <option value="1986">1986</option> <option value="1985">1985</option> <option value="1984">1984</option> <option value="1983">1983</option> <option value="1982">1982</option> <option value="1981">1981</option> <option value="1980">1980</option> <option value="1979">1979</option> <option value="1978">1978</option> <option value="1977">1977</option> <option value="1976">1976</option> <option value="1975">1975</option> <option value="1974">1974</option> <option value="1973">1973</option> <option value="1972">1972</option> <option value="1971">1971</option> <option value="1970">1970</option> <option value="1969">1969</option> <option value="1968">1968</option> <option value="1967">1967</option> <option value="1966">1966</option> <option value="1965">1965</option> <option value="1964">1964</option> <option value="1963">1963</option> <option value="1962">1962</option> <option value="1961">1961</option> <option value="1960">1960</option> <option value="1959">1959</option> <option value="1958">1958</option> <option value="1957">1957</option> <option value="1956">1956</option> <option value="1955">1955</option> <option value="1954">1954</option> <option value="1953">1953</option> <option value="1952">1952</option> <option value="1951">1951</option> <option value="1950">1950</option> <option value="1949">1949</option> <option value="1948">1948</option> <option value="1947">1947</option> <option value="1946">1946</option> <option value="1945">1945</option> <option value="1944">1944</option> <option value="1943">1943</option> <option value="1942">1942</option> <option value="1941">1941</option> <option value="1940">1940</option> <option value="1939">1939</option> <option value="1938">1938</option> <option value="1937">1937</option> <option value="1936">1936</option> <option value="1935">1935</option> <option value="1934">1934</option> <option value="1933">1933</option> <option value="1932">1932</option> <option value="1931">1931</option> <option value="1930">1930</option> <option value="1929">1929</option> <option value="1928">1928</option> <option value="1927">1927</option> <option value="1926">1926</option> <option value="1925">1925</option> <option value="1924">1924</option> <option value="1923">1923</option> <option value="1922">1922</option> <option value="1921">1921</option> <option value="1920">1920</option> <option value="1919">1919</option> <option value="1918">1918</option> <option value="1917">1917</option> <option value="1916">1916</option> <option value="1915">1915</option> <option value="1914">1914</option> <option value="1913">1913</option> <option value="1912">1912</option> <option value="1911">1911</option> <option value="1910">1910</option> <option value="1909">1909</option> <option value="1908">1908</option> <option value="1907">1907</option> <option value="1906">1906</option> <option value="1905">1905</option> <option value="1904">1904</option> <option value="1903">1903</option> <option value="1902">1902</option> <option value="1901">1901</option> <option value="1900">1900</option> </select> </td> </tr> <tr> <td>Enter your e-mail address:</td> <td><input name="Email" type="text" id="Email" size="40" maxlength="40" /></td> </tr> <tr> <td>Gender:</td> <td><INPUT TYPE=RADIO NAME="Gender" VALUE="Male"> Male<BR> <INPUT TYPE=RADIO NAME="Gender" VALUE="Female"> Female<BR> </td> </tr> <tr> <tr> <td></td> <td><p align="right"><input type="submit" name="submit" value="Click to Register" /></td> </tr> </table> </form> <body> </body> </html> register.php: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>UK-Chinese Channel | Register</title> <link href="style.css" rel="stylesheet" type="text/css" /> </head> <?php include("include.php"); $hostname = "localhost"; $name = $_POST['Username']; $password = $_POST['Password']; $password2 = $_POST['Password2']; $email = $_POST['Email']; $gender = $_POST['Gender']; $dob = $_POST['DateOfBirth_Day']; $dob2 = $_POST['DateOfBirth_Month']; $dob3 = $_POST['DateOfBirth_Year']; $Date = mktime (0,0,0,$dob2, $dob, $dob3); if ($name >= 10 && $uname <= 20) { $errorMessage = ""; } else { $errorMessage = $errorMessage . "Username must be between 10 and 20 characters". <br>; } if ($password >= 8 && $passwors <= 16) { $errorMessage = ""; } else { $errorMessage = $errorMessage . "Password must be between 8 and 16 characters". <br>; } if($password==$password2){ // connect to db $result = mysql_connect($hostname, $username, 'Password1') or die(mysql_error()); //Select the database $rs= @mysql_select_db($databaseName) or die(mysql_error()); $query="INSERT into users (username,password,date,email,gender) VALUES ('$name','$password',$Date,'$email','$gender')"; $result=mysql_query($query) or die("insert error: ".mysql_error()); mysql_close(); echo "<h2>Thank You! You have registered sucessfully!!</h2>"; header("Refresh: 4;URL=home.html"); die(); } else { echo "<h2>Passwords doesn't match!</h2>"; echo "<h1>Please try again!</h1>"; header("Refresh: 2;URL=register.html"); die(); }; ?>
well, registration is one thing, assuming you did it correctly, your database tables should contain the user and their password. however, what's going on in your login section? you've saved your data, but how are you fetching the user from the database, and giving him access?
yep, it does. lol. to be honest - i havent done that part... i'll try and look for the code on net. im just trying to do the reg page first.. where like if the user didnt type anything and press submit - it will give an error msg.... or didnt type the right format. this part dont work: if ($name >= 10 && $uname <= 20) { $errorMessage = ""; } else { $errorMessage = $errorMessage . "Username must be between 10 and 20 characters". <br>; } if ($password >= 8 && $passwors <= 16) { $errorMessage = ""; } else { $errorMessage = $errorMessage . "Password must be between 8 and 16 characters". <br>; }
well that answers your question as to why you can't log on. as to the error message, what you did there, is set a certain string as your error message. what you need to do, is pass that error message back to your registration page. basically, you're just saying errorMessage = "error message" but what do you do with errorMessage? you have to take errorMessage, and pass it back to your registration page.
on my login.php i have: <?php session_start(); include("include.php"); $hostname = "localhost"; if ((isset($_POST['Username'])) && (isset($_POST['Password']))) { $user = $_POST['Username']; $pass = $_POST['Password']; // connect to db $result = mysql_connect($hostname, $username, $password) or die(mysql_error()); //Select the database $result = mysql_select_db($databaseName) or die(mysql_error()); $query = "select Username, Password FROM login where Username = '$user'" . "AND Password = (PASSWORD('$pass'))"; $result = mysql_query($query) or die(mysql_error()); if(mysql_num_rows($result)!=1){ echo "<h2>Wrong password or username!.</h2>"; echo "<h3>You are being redirected...</h3>"; header("Refresh: 4;URL=default.html"); die(); }else{ $_SESSION['user_logged'] = $_POST['Username']; $_SESSION['user_password'] = $_POST['Password']; header('Location:home.html'); } } ?> so where do i put this: $query = "select Username, Password FROM users where Username = '$user'" . "AND Password = (PASSWORD('$pass'))"; think its right... users is the database where memebers register. to be honest dani havent got a clue what you just told me! :/ im new to this whole php thing. found these script to put on my regsiter.html page: <script type="text/javascript"> function validate_required(field,alerttxt) { with (field) { if (value==null||value=="") { alert(alerttxt);return false; } else { return true; } } } function validate_form(thisform) { with (thisform) { if (validate_required(email,"Email must be filled out!")==false) {email.focus();return false;} } } function validate_email(field,alerttxt) { with (field) { apos=value.indexOf("@"); dotpos=value.lastIndexOf("."); if (apos<1||dotpos-apos<2) {alert(alerttxt);return false;} else {return true;} } } not sure if its right or not and dont know what code to change.