Jump to content

Sprout

Members
 View Profile  See their activity

  • Posts

    41

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by Sprout

  1. Sprout
    Exactly what I needed, thank you.
  2. Sprout
    Thanks for the quick responses, is there a way to stop the rest of the form from being submitted if those don't match? I don't want them to not match yet have the form still be submitted.
  3. Sprout
    I just want to create a simple password check like most sites have, making sure you didn't have a typo when originally registering your password. So essentially what I have is <input type="text" name="pass1"> and <input type="text" name="pass2"> and I'd like to rig something up on the form processing page that checks to make sure pass1 is equal to pass2 otherwise it returns an error. Any help?
  4. Sprout
    Someone suggested I do this but I don't understand how.
  5. Sprout
    Mmm, it is probably at least my 4th thread related to roughly the same issue, yes. However I keep changing what it is I'd like to do. Originally I wanted to know how to build an entire point system, then I tried to get help with specific code I was given elsewhere for the problem, then just how to get points displaying, I spent the last 3 days mobbing through the W3Schools PHP tutorials and have a significantly better understanding of what I'm doing. I managed to get the points displaying so I don't need to worry about that, and now all I would like to know is how I can make a form increase the points column based on the username being entered. I didn't think there'd be an issue given what I'm requesting help with is now a specific and slightly (though not much) changed problem than before, although the desired outcome is pretty much the same. Based on my observation on this forum and forums in general, if you don't create a new thread when you make changes to what it is you want help with then you're significantly less likely to get help. I imagine this is due to people generally not going through and reading entire threads to see if the person's problem has changed. Not to mention the fact phpfreaks doesn't allow you to edit your posts so I can't change my original posts in those threads to reflect my current goal. However, if me starting new threads to reflect my updated problem is causing me to look like an annoying inconsiderate asshole who doesn't understand the community here then I very sincerely apologize. I'm not trying to be rude or spam my problems, I'm just trying to get help. I'll be less hasty to start threads related to essentially the same problem in the future. I'm sorry.
  6. Sprout
    I finally got my points displaying, now I need to get them to increase. My database has a column called "points" which I would like to have increased by 100 on the submission of a form when the username is issued. But I cannot figure out how to do this. So essentially I need an input field of my form to be for a username, which when entered would select the username from my database and increase the numer of the "points" column for that user by 100. Any and all help is very much appreciated. Note: This will be used for the signup form to give points to whoever recommended the user.
  7. Sprout
    I know this is probably an extremely basic question, but I just don't understand it. None of the tutorials I've taken have explained it. So if anyone knows when/why you use exclamation points then I'd appreciate it. Example: if (!$variable)
  8. Sprout
    I want my users to be able to see how many points they have when they go to their user info page. My MySQL database is named "webvilla_users" and the table below is called "users" I want my user to be able to view their number of points when they view their account info. So if anybody can explain to me how to retrieve the logged in user's point number from the database and display it for them to see I'd appreciate it. This is what my user profile script looks like if it gives you a better idea of how users view their information I modified it from a tutorial. <? include("include/session.php"); ?> <html> <head> <script type="text/javascript"> function roll_over(img_name, img_src) { document[img_name].src = img_src; } </script> <STYLE TYPE="text/css"> table {border-spacing:0;} table {border-collapse:collapse;} img {vertical-align:top} img {display:block;} </style> <title>Docoden</title> <STYLE TYPE="text/css"> a:link {text-decoration: none; color: #0099FF;} a:visited {text-decoration: none; color: #0099FF;} a:active {text-decoration: none; color: #2FB0F4;} a:hover {text-decoration: none; color: #2FB0F4;} p { font-family: arial; } body { font-family: arial; font-size: 14px; } div.wrapper { position: relative; width: 900px; margin-left: auto; margin-right: auto; } div.top { position: relative; width: 900px; height: 20px; background-image: url(top.png); layer-background-image: url(top.png); } div.bottom { position: relative; width: 900px; height: 20px; background-image: url(bottom.png); layer-background-image: url(bottom.png); } div.left { float: left; position: relative; width: 20px; background-image: url(left.png); layer-background-image: url(left.png); } div.center { float: left; position: relative; background-color: #FFCC66; } div.right { float: right; position: relative; width: 20px; background-image: url(right.png); layer-background-image: url(right.png); } div.thin { position: relative; width: 900px; height: 45px; background-image: url(footer.png); layer-background-image: url(footer.png); </style> </head> <body bgcolor="CFECEC"> <div class="wrapper"> <table width="100%" height="100%"> <tr> <td height="10%"> <div style="width:100%" align="center"> <img src="docodenlogo.png"> </div> </td> </tr> <tr> <td> <div style="height:5;"></div> <div class="thin"><table width="100%" height="100%" border="0"> <tr> <td> <? /** * User has already logged in, so display relavent links, including * a link to the admin center if the user is an administrator. */ if($session->logged_in){ echo "<table><tr><td> <font size=\"4\"><b>$session->username</b></font></td>"; if($session->isAdmin()){ echo "<td>|</td><td><a href=\"admin/admin.php\"><img src=\"admin-center1.png\" onmouseover=\"this.src = 'admin-center2.png';\" onmouseout=\"this.src = 'admin-center1.png';\" border=\"0\" /> </A></td>"; } echo "<td width=\"5\">|</td><td> <a href=\"userinfo.php?user=$session->username\"my-account1.png\"><img src=\"my-account1.png\" onmouseover=\"this.src = 'my-account2.png';\" onmouseout=\"this.src = 'my-account1.png';\" border=\"0\" /> </A></td>" ."<td width=\"5\">|</td><td> <a href=\"useredit.php\"><img src=\"edit-account1.png\" onmouseover=\"this.src = 'edit-account2.png';\" onmouseout=\"this.src = 'edit-account1.png';\" border=\"0\" /></A></td>" ."<td width=\"5\">|</td><td><a href=\"process.php\"> <img src=\"logout1.png\" onmouseover=\"this.src = 'logout2.png';\" onmouseout=\"this.src = 'logout1.png';\" border=\"0\" /> </A></td><td width=\"5\">|</td></tr></table>"; } else{ ?> <? /** * User not logged in, display the login form. * If user has already tried to login, but errors were * found, display the total number of errors. * If errors occurred, they will be displayed. */ if($form->num_errors > 0){ echo ""; } ?> <form action="process.php" method="POST"> <table align="left" border="0" cellspacing="0" cellpadding="3" width="100%"> <tr><td width="65"> <font size="4"><b>Sign in:</b></font></td><td width="10"><input type="checkbox" title="Remember Login" name="remember" <? if($form->value("remember") != ""){ echo "checked"; } ?>></td><td width="100"><input title="Username" style="width:100px;" type="text" name="user" maxlength="30" value="<? echo $form->value("user"); ?>"></td><td><? echo $form->error("user"); ?></td><td width="100"><input title="Password" style="width:100px;" type="password" name="pass" maxlength="30" value="<? echo $form->value("pass"); ?>"></td width="0"><td><? echo $form->error("pass"); ?></td><td><a href="forgotpass.php" title="Forgot your password?"><img src="qm1.png" onmouseover="this.src = 'qm2.png';" onmouseout="this.src = 'qm1.png';" border="0" /></font></td><td align="left"> <input type="hidden" name="sublogin" value="1"> <input type="image" src="login1.png" onmouseover="this.src = 'login2.png';" onmouseout="this.src = 'login1.png';" /> </td><td width="80%"> </td> <td align="right"> <a href="register.php"> <img src="join-us1.png" onmouseover="this.src = 'join-us2.png';" onmouseout="this.src = 'join-us1.png';" border="0" /> </A></td><td></td></tr> </table> </form> <? } echo ""; ?> </td> </tr> </table> </div> <div style="height:5;"></div> <div class="top"></div><div class="middle" style="height:400;"> <div class="left" style="height:400;"></div> <div class="center" style="height:400; width:860;"> <table width="100%" height="100%" border="0"> <tr> <td valign="top"> <? /* Requested Username error checking */ $req_user = trim($_GET['user']); if(!$req_user || strlen($req_user) == 0 || !eregi("^([0-9a-z])+$", $req_user) || !$database->usernameTaken($req_user)){ die("Username not registered"); } /* Logged in user viewing own account */ if(strcmp($session->username,$req_user) == 0){ echo "<table width=\"100%\" height=\"100%\" valign=\"top\" border=\"0\"><tr><td align=\"center\" valign=\"top\"><b><font size=\"6\">$session->username's Account</font></b></td></tr></table>"; echo "<b>Email:</b> ".$req_user_info['email']."<br>"; } /* Visitor not viewing own account */ else{ echo "<table width=\"100%\" height=\"100%\" border=\"0\"><tr><td align=\"center\" valign=\"top\"><b><font size=\"6\">$session->username's Account</font></b></td></tr></table>"; echo "<b>Email:</b> ".$req_user_info['email']."<br>"; } ?> </td> </tr> </table> </div> <div class="right" style="height:400;"></div> </div> <div class="bottom"></div> <div style="height:5;"></div> <div class="thin"><table width="100%" height="100%"> <tr> <td align="center"> <b>© 2010 Docoden</b> </td> </tr> </table> </div> </td> </tr> <tr> <td height="10%"> </td> </tr> </table> </div> </body> </html>
  9. Sprout
    Thanks for all your help ejaboneta, I'm pretty sure I'm making progress but still having tons of trouble. I added "points" to the table "users" in database "users". Now I tried plopping all that script together but it doesn't seem to be working. Here's the code: <?php //after your login script... $fetch = mysql_fetch_row($query); $_SESSION[user_id] = $fetch[user_id]; $_SESSION[username] = $fetch[username]; ?> <?php $sql = "SELECT * FROM user_table"; $query = mysql_query($sql); while ($fetch = mysql_fetch_array($query)) { $users[] = "<option value=\"$fetch[user_id]\">$fetch[username]</option>\n"; } $options = implode('',$users); echo " <form method=\"get\"> User: <select name=\"user\"> $options </select><br /> Points: <input type=\"text\" name=\"points\" /><br /> <input type=\"submit\" value=\"Change Points\"> </form> "; ?> <?php if ($_GET[user_id]) { $sql = "UPDATE user_table SET points = (points + $_GET[points]) WHERE user_id = '$_GET[user_id]"; mysql_query($sql); } ?> And these are the errors I'm getting Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/webvilla/public_html/test/logger/tinker2.php on line 9 Parse error: syntax error, unexpected T_VARIABLE in /home/webvilla/public_html/test/logger/tinker2.php on line 10 In my users table the user id is set up as "userid" instead of "user_id" should I change everything that says "user_id"? the "user_id" is in the table "counter" which I created to work with the script.
  10. Sprout
    Yes, this is a point in the right direction but I'm still confused as to what my MySQL database would need to have in it for this script. This is how my database is set up. webvilla_users (5) <-- database name active_guests <-- database tables active_users banned_users counter users The "users" holds all the user names. "Counter" just has a field named "count" and one named "user_id" both of which are just int(11) with nothing else added to them. Do I need to adjust my database to fit this script?
  11. Sprout
    It just needs to be numbers, every time a user is given points I want it to increase by 100 but I don't know how to go about doing this. The $_GET[user] was my attempt to display user points for the user logged in. I don't know what I'm doing at all, I think I'm going to try to figure out a different way to do this because the version I have is just extremely sloppy. I just want three things right now. 1. Ability to store a number of points unique to the visiter (I imagine this is done in MySQL) 2. Ability to display the points of the logged in user on their user info page 3. Ability to have that number increase based on the submission of a form when their username is entered into the textbox (I'll worry about subtracting points later) But creating this system seems a lot more complicated than I would've suspected. =\
  12. Sprout
    There's nothing in the counter table except for something named "count" and "user_id" neither of which were set up to do anything except have the name so the script would have something to access. I've been trying to create a point system for my users, so that if they recommend another person or do something they can gain points. This script was given to me and slightly modified with the help of other people, but I can't get it working nor do I know how to set the MySQL database for it. If you know a better way of doing this then please feel free to let me know because based on responses when I try to get help with this I don't think this is the best way to be doing it. =P
  13. Sprout
    So I was going through my headache of a script trying to figure out why it's not working. My script is trying to grab a user_id from the counter table I created in my database, yet I don't hold any user_id's in my counter table they're held in my user table. Would it be possible to make it so this script just grabs the user's name from my user table and just get rid of the "counter" table altogether? Also, can someone tell me where this script is holding the points...? that's what I still can't for the life of me understand. I didn't set anything up to actually store points nor did I run into anyone telling me I needed to throughout all the help I've gotten creating this but I can't imagine I don't have to. Any help is greatly appreciated, I wouldn't be nearly as far along with this if it weren't for this forum. Edit: Might help if I included the script... =P <?php require_once('connect.php'); //require a database connection, to include the selection of the database. $user = trim($_GET['user']); if(isset($user)) { //if we have a user. $user = mysql_real_escape_string($user); //escape them for mysql interaction. if(isset($_GET['points']) && ($_GET['points'] == 'increase' || $_GET['points'] == 'decrease')) { //if the url has 'points' set, and the = one of two things. } if($_GET['points'] == 'increase') { //increase the count. $update = 'count + 1'; } elseif($_GET['points'] == 'decrease') { //decrease the count. $update = 'count - 1'; } $sql = "UPDATE counter SET count = $update WHERE user_id = '$user'"; //finalize query. mysql_query($sql); //execute query. } $increasePoints = '<a href="?points=increase">Increase</a>'; //increase points link set to variable. $decreasePoints = '<a href="?points=decrease">Decrease</a>'; //decrease points link set to variable. //Call the data from the db. $sql = "SELECT count FROM counter WHERE user_id = '$user'"; $re = mysql_query($sql); echo mysql_errno() . ": " . mysql_error() . "\n"; $r = mysql_fetch_row($re); $count = $r[0]; //echo the count and the variables. You can do this on the current page, or any page this code is included in. echo 'User has ' . $count . ' points! Do you want to ' . $increasePoints . ' or ' . $decreasePoints . '? '; ?>
  14. Sprout
    Alright, well I've made progress (I think) I set up a table named counter with a column named count but now the error message is saying. 1054: Unknown column 'user_id' in 'where clause' Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/webvilla/public_html/test/logger/count.php on line 23 My database is set up as so webvilla_users (5) <-- this is my database active_guests <-- these are my tables active_users banned_users counter users
  15. Sprout
    Alright, Thanks PFMaBiSmAd it ended up returning this message. 1146: Table 'webvilla_users.counter' doesn't exist Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/webvilla/public_html/test/logger/count.php on line 23 I assume I set up my "connect.php" file incorrectly as well as have no created the counter table. Should I be creating a whole new database or should I put it with the users table I have? I barely understand MySQL databases I've only two up and one was the trial run the other way following a tutorial to create my user sections for login.
  16. Sprout
    I think there's a high probability that this code isn't working because I didn't create any sort of MySQL database for it. All I did was point it in the direction of my user MySQL database I created for users but I created nothing at all to do with storing numbers or counting or anything. But then again I hardly understand wtf I'm doing. I can't figure out how to add the mysql_error messages in my code, all it does is start bitching at me about syntax errors. I appreciate all your help guys, and if anyone wants to continue to try to help me figure out how to do this then I would really greatly appreciate it, but I think maybe I just need to sit down with some more tutorials and get a better understanding of what I'm doing.
  17. Sprout
    I don't know how to use the mysql_error() and google isn't being of much help.
  18. Sprout
    I've been trying to figure out how to properly implement this into the code I have and all I've done is successfully manage to make it worse a dozen times. Do I replace the $sql = "UPDATE counter SET count = $update WHERE user_id = '$user'"; //finalize query. mysql_query($sql); //execute query with $query = mysql_query("SELECT * FROM `users` WHERE `user_id`='$user'"); $result = mysql_fetch_array($query); $count = $result['count'] + 1; //If its decreasing, replace it with minus, etc $update = mysql_query("UPDATE `users` SET `count`='$count' WHERE `user_id`='$user'"); ? I'm sorry, I just started learning PHP about two weeks ago so if I come across like I have no idea what I'm doing it's because I pretty much don't.
  19. Sprout
    Whoa, thanks for the quick responses guys. I'm about to head to the store to buy some headphones then I'll check into your suggestions and let you know how it turns out. Very much appreciated.
  20. Sprout
    Alright, well the last couple of days I've been attempting to learn how to create a user point system for my site (which is well beyond my understanding of PHP) and I've been making lots of progress. However, the page that's supposed to be displaying the points is now giving me this error. Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/public_html/test/logger/count.php on line 22 Now, I never created a mysql database for the point system, I had just been linking it to my user database under the half-baked assumption that it would just draw the username and record the points. But based on this error I'm starting to believe that's not the case. Anyway, here's my code for count.php <?php require_once('connect.php'); //require a database connection, to include the selection of the database. $user = 1; //There must be a way to determine who's profile you are looking at. This will be the user. if(isset($user)) { //if we have a user. $user = mysql_real_escape_string($user); //escape them for mysql interaction. if(isset($_GET['points']) && ($_GET['points'] == 'increase' || $_GET['points'] == 'decrease')) { //if the url has 'points' set, and the = one of two things. } if($_GET['points'] == 'increase') { //increase the count. $update = 'count + 1'; } elseif($_GET['points'] == 'decrease') { //decrease the count. $update = 'count - 1'; } $sql = "UPDATE counter SET count = $update WHERE user_id = '$user'"; //finalize query. mysql_query($sql); //execute query. } $increasePoints = '<a href="?points=increase">Increase</a>'; //increase points link set to variable. $decreasePoints = '<a href="?points=decrease">Decrease</a>'; //decrease points link set to variable. //Call the data from the db. $sql = "SELECT count FROM counter WHERE user_id = '$user'"; $re = mysql_query($sql); $r = mysql_fetch_row($re); $count = $r[0]; //echo the count and the variables. You can do this on the current page, or any page this code is included in. echo 'User has ' . $count . ' points! Do you want to ' . $increasePoints . ' or ' . $decreasePoints . '? '; ?> Can anybody explain to me what it is I have to do to get this up and running? :-\
  21. Sprout
    Alright, well I got the error messages to stop popping up by all I have is a blank page... am I supposed to set something else up I'm unaware of? The count.php code is this... <?php //a require_once('connect.php'); //require a database connection, to include the selection of the database. $user = 1; //There must be a way to determine who's profile you are looking at. This will be the user. if(isset($user)) { //if we have a user. $user = mysql_real_escape_string($user); //escape them for mysql interaction. if(isset($_GET['points']) && ($_GET['points'] == 'increase' || $_GET['points'] == 'decrease')) { //if the url has 'points' set, and the = one of two things. if($_GET['points'] == 'increase') { //increase the count. $update = 'count + 1'; } elseif($_GET['points'] == 'decrease') { //decrease the count. $update = 'count - 1'; } $sql = "UPDATE counter SET count = $update WHERE user_id = '$user'"; //finalize query. mysql_query($sql); //execute query. } $increasePoints = '<a href="?points=increase">Increase</a>'; //increase points link set to variable. $decreasePoints = '<a href="?points=decrease">Decrease</a>'; //decrease points link set to variable. //Call the data from the db. $sql = "SELECT count FROM counter WHERE user_id = '$user'"; $re = mysql_query($sql); $r = mysql_fetch_row($re); $count = $r[0]; //echo the count and the variables. You can do this on the current page, or any page this code is included in. echo 'User has ' . $count . ' points!<br />Do you want to ' . $increasePoints . ' or ' . $decreasePoints . '?<br />'; ?> Is there anything else I need to do to get the point system working?
  22. Sprout
    Well, I'm going to assume we're a lot closer but now it's telling me that there's the same problem except this time on line 15.
  23. Sprout
    I know I just can't figure out where in the script. <?php require_once('connect.php'); //require a database connection, to include the selection of the database. $user = 1; //There must be a way to determine who's profile you are looking at. This will be the user. if(isset($user)) { //if we have a user. $user = mysql_real_escape_string($user); //escape them for mysql interaction. if(isset($_GET['points']) && ($_GET['points'] == 'increase' || $_GET['points'] == 'decrease')) { //if the url has 'points' set, and the = one of two things. if($_GET['points'] == 'increase') { //increase the count. $update = 'count + 1'; } elseif($_GET['points'] == 'decrease') { //decrease the count. $update = 'count - 1'; } $sql = "UPDATE counter SET count = $update WHERE user_id = '$user'"; //finalize query. mysql_query($sql); //execute query. } $increasePoints = '<a href="?points=increase">Increase</a>'; //increase points link set to variable. $decreasePoints = '<a href="?points=decrease">Decrease</a>'; //decrease points link set to variable. //Call the data from the db. $sql = "SELECT count FROM counter WHERE user_id = '$user'"; $re = mysql_query($sql); $r = mysql_fetch_row($re); $count = $r[0]; //echo the count and the variables. You can do this on the current page, or any page this code is included in. echo 'User has ' . $count . ' points!<br />Do you want to ' . $increasePoints . ' or ' . $decreasePoints . '?<br />'; ?>
  24. Sprout
    Still can't figure it out, anybody?
  25. Sprout
    I'm still getting this error Parse error: syntax error, unexpected $end in /home/public_html/test/logger/count.php on line 66 Also, am I supposed to create something for 'points' as of now I just copied and pasted the script exactly as is. Aside from the connect.php file to connect to my user database I copied and pasted everything as is, which based on the outcome I guess I'm not supposed to be doing.
×
×
  • 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.