Jump to content

Dark57

Members
 View Profile  See their activity

  • Posts

    63

  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Dark57's Achievements

Member

Member (2/5)

0

Reputation

  1. Dark57
    It does work, thank you for helping me. I actually had the jest of what I had to do, but I was putting it in the wrong spot. It does help to have an active community to help you figure out what you're doing wrong.
  2. Dark57
    An integer, for User ID #1 it has 1000 in it, for user #2 it has 0 in it. The integer stands for how many days the user has left in Shinobi status. And yes, login and authentication is done elsewhere. That works fine, the session transfers over properly but I don't know how to select information specifically from just one column from a specific row.
  3. Dark57
    If the user has Shinobi status their name will appear bolded, if they do not have Shinobi status their name will be normal. That's all that section of the script is trying to do, since I couldn't even get it to do that I didn't even attempt to make it do all the rest of the things that differ from Shinobi and Non-Shinobi.
  4. Dark57
    I'm not sure how I was describe my problem other than a lack of knowledge on my own part. I have tried a few ways but this is the only way I can get it to work. Now the problem with the code I have is that I believe it is checking the entire database to see if one person has "Shinobi" status, and if one person has it then it gives it to everyone. if ($row['shinobi'] > 0) { echo "<strong>" . "[" . $_SESSION['id']. "] " . $_SESSION['username'] . "</strong>"; } My problem is that I guess I don't understand how I'm supposed to get it to just select the person whose logged in Shinobi status using their ID number. In the code above you can see my problem. How would I go about doing this? <?php session_start(); if(!isset($_SESSION['username'])) { header("location:main_login.php"); } ?> <table width="800" border="0" align="center"> <tr> <td colspan="2" bgcolor="#402E16"> </td> </tr> <tr> <td width="200" bgcolor="#402E16"><img src="images/Header-redo3.jpg" width="200" height="100" alt="Header" /></td> <td width="590" bgcolor="#402E16"><?php $con = mysql_connect("127.0.0.1","xxxx","xxxxxxx"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("SNO1", $con); $result = mysql_query("SELECT * FROM Basic"); $row = mysql_fetch_array($result); if ($row['shinobi'] > 0) { echo "<strong>" . "[" . $_SESSION['id']. "] " . $_SESSION['username'] . "</strong>"; } else { echo "[".$_SESSION['id']."] ".$_SESSION['username']; } ?></td> </tr> </table>
  5. Dark57
    Ok I do see the logic behind creating multiple tables inside a database. I am reading up on normalizing it and it makes sense, now I will just have to take it to the drawing board so I can break it down into tables that make sense.
  6. Dark57
    Yeah well I said its a question/discussion because I'd like to hear from peoples personal experience. Thanks for the link though, I will read it.
  7. Dark57
    So I'm looking to use a database to store many different fields of information. I'm looking at roughly 20 or more columns of information per user just at the start, before I start getting into other systems I may implement in the future. My question is, would it be easier to manage all of this information in multiple tables or in one huge table. Whats the downside to using one huge table and the downside of multiple tables. Will either of these slow down the website or use more bandwidth? EDIT: Actually, now that I think about it this should probably be in the MYSQL section.
  8. Dark57
    Ok, that did work and I think I figured out why my code wasn't working. Though you did have a few errors in your code. if (!$userpassword); if (!$email); Those two lines of code were still causing errors because of the ; at the end.
  9. Dark57
    <html> <body> <?php $username = $_POST['myusername']; $userpassword = $_POST['mypassword']; $email = $_POST['myemail']; $errors[1] = 0; $errors[2] = 0; $errors[3] = 0; $host="localhost"; // Host name $login="xxxx"; // Mysql username $password="xxxxxxx"; // Mysql password $db_name="test"; // Database name $tbl_name="members"; // Table name session_start(); $_SESSION['noname']=0; $_SESSION['nopass']=0; $_SESSION['noemail']=0; $_SESSION['usernamefail']=0; $_SESSION['emailfail']=0; // Connect to server and select databse. $con = mysql_connect("$host", "$login", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); //Check for empty fields if (!isset($username)) { $_SESSION['noname']=1; echo "Username = " . $_SESSION['noname'] . "<br />"; } if (!isset($userpassword)); { $_SESSION['nopass']=1; echo "Password = " . $_SESSION['nopass'] . "<br />"; } if (!isset($email)); { $_SESSION['noemail']=1; echo "email = " . $_SESSION['noemail'] . "<br />"; } //If not empty, compare emails to database $sql = "SELECT COUNT(*) FROM members WHERE email = '$email'"; $result = mysql_query($sql); $number=mysql_num_rows($result); if($number>0) { $_SESSION['emailfail']=1; echo "Duplicate Email = 1<br />"; } $username = stripslashes($username); $username = mysql_real_escape_string($username); $sql = "SELECT COUNT(*) FROM members WHERE username = '$username'"; $result = mysql_query($sql); if(!$result) die(mysql_error().'<br />'.$sql); $number=mysql_num_rows($result); if($number>0) { echo "Duplicate Username <br />"; $_SESSION['usernamefail']=1; } if ($_SESSION['noname'] == 0 && $_SESSION['nopass'] == 0 && $_SESSION['noemail'] == 0 && $_SESSION['usernamefail'] == 0 && $_SESSION['emailfail'] == 0) { //If emails arent duplicates, write to file. // To protect MySQL injection $userpassword = stripslashes($userpassword); $email = stripslashes($email); $userpassword = mysql_real_escape_string($userpassword); $email = mysql_real_escape_string($email); $userpassword = md5($userpassword); $register="INSERT INTO $tbl_name (username, password, email) VALUES ('$username','$userpassword','$email')"; if (!mysql_query($register,$con)) { die('Error: ' . mysql_error()); } echo "No Errors"; } session_unset(); session_destroy(); ?> </body> </html> And the form <html> <body> <form name="registerform" method="post" action="check_register.php"> <table width="300" border="0" cellpadding="3" cellspacing="1" bgcolor="#ffffff"> <tr> <td colspan="4" bgcolor="#ffffff"><strong>Member Login </strong></td> </tr> <tr> <td width="67">Username</td> <td width="4">:</td> <td colspan="2"><input name="myusername" type="text" id="myusername"></td> </tr> <tr> <td>Password</td> <td>:</td> <td colspan="2"><input name="mypassword" type="password" id="mypassword"></td> </tr> <tr> <td>Email</td> <td>:</td> <td colspan="2"><input name="myemail" type="text" id="myemail"></td> </tr> <tr> <td width="54" align="left"><input type="submit" name="Submit" value="register"></td> </tr> </table> </form> </body> </html> I'm actually going to sign off for the night, but I will be checking back tomorrow. Thanks for helping, I'm just too tired to continue right now.
  10. Dark57
    Hrm, I see that oops now. I thought I fixed that, maybe I started over with an older copy. Bah. This is what is displayed. I typed in a brand spanking new username, password and email. Password = 1 means that it detects there is no password being submitted. Email = 1 means there is no email being submitted. Duplicate Email = 1 means it found the same email in the database already. Duplicate USername means it found the same username in the database. Password = 1 email = 1 Duplicate Email = 1 Duplicate Username
  11. Dark57
    Ah, I see. The session variables are supposed to be transferred over to the next page where it tells you where you are wrong etc and cleared there. I just removed that part temporarily so I could try to debug it. Maybe coding this tired is not the best of ideas.
  12. Dark57
    Ok I thought I had as brilliant break through a little earlier and that I got it to detect if anything was already in a datebase when someone was trying to register. Username or email for example. Now for some reason it was always allowing the submitted info to write to the database, now its not letting it write at all. Infact its giving me all the errors about my information now, even when its not in the database. <html> <body> <?php $username = $_POST['myusername']; $password = $_POST['mypassword']; $email = $_POST['myemail']; $errors[1] = 0; $errors[2] = 0; $errors[3] = 0; $host="localhost"; // Host name $login="xxxx"; // Mysql username $password="xxxxxxx"; // Mysql password $db_name="test"; // Database name $tbl_name="members"; // Table name session_start(); $_SESSION['noname']=0; $_SESSION['nopass']=0; $_SESSION['noemail']=0; $_SESSION['usernamefail']=0; $_SESSION['emailfail']=0; // Connect to server and select databse. $con = mysql_connect("$host", "$login", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); //Check for empty fields if (!isset($username)) { $_SESSION['noname']=1; echo "Username = " . $_SESSION['noname'] . "<br />"; } if (!isset($password)); { $_SESSION['nopass']=1; echo "Password = " . $_SESSION['nopass'] . "<br />"; } if (!isset($email)); { $_SESSION['noemail']=1; echo "email = " . $_SESSION['noemail'] . "<br />"; } //If not empty, compare emails to database $sql = "SELECT COUNT(*) FROM members WHERE email = '$email'"; $result = mysql_query($sql); $number=mysql_num_rows($result); if($number>0) { $_SESSION['emailfail']=1; echo "Duplicate Email = 1<br />"; } $username = stripslashes($username); $username = mysql_real_escape_string($username); $sql = "SELECT COUNT(*) FROM members WHERE username = '$username'"; $result = mysql_query($sql); if(!$result) die(mysql_error().'<br />'.$sql); $number=mysql_num_rows($result); if($number>0) { echo "Duplicate Username <br />"; $_SESSION['usernamefail']=1; } if ($_SESSION['noname'] == 0 && $_SESSION['nopass'] == 0 && $_SESSION['noemail'] == 0 && $_SESSION['usernamefail'] == 0 && $_SESSION['emailfail'] == 0) { //If emails arent duplicates, write to file. // To protect MySQL injection $password = stripslashes($password); $email = stripslashes($email); $password = mysql_real_escape_string($password); $email = mysql_real_escape_string($email); $password = md5($password); $register="INSERT INTO $tbl_name (username, password, email) VALUES ('$username','$password','$email')"; if (!mysql_query($register,$con)) { die('Error: ' . mysql_error()); } echo "No Errors"; } ?> </body> </html> Does anyone see what I'm doing wrong?
  13. Dark57
    Yeah, especially when you're tired. Well I seem to have gotten it working now Thanks guys for the help, you guys always help me overcome my coding struggles.
  14. Dark57
    Ah, I feel retarded now. I guess its a good thing I posted the code here so you could point out that to me too. I've been developing this on two different computers and this is a new database I'm working with. I forgot to run my create_db.php file before trying to use this file /facepalm
  15. Dark57
    Ok so I'm using $sql = "SELECT COUNT(*) FROM mytable WHERE username = '$username'"; $result = mysql_query($sql); $username = stripslashes($username); $username = mysql_real_escape_string($username); $number=mysql_num_rows($result); if($number>0) { echo "Duplicate Username <br />"; $_SESSION['usernamefail']=1; } But I keep getting this error: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\Silent Night Online\check_register.php on line 51 Line 51 refers to $number=mysql_num_rows($result); in this case. I'm not sure why it is returning a true/false statement if its supposed to be counting the matching rows of a username?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.