roper22
-
Posts
19 -
Joined
-
Last visited
Never
Everything posted by roper22
-
Thank you so much mmvomit for all the help :]
-
How would I set the value attribute without actually making the value of the text box the PHP code?
-
Another question, figured i'd just put it into this topic. How do I make it so that when someone goes to edit their profile, the boxes keep their Location and such, rather then them all being blank every time they go to edit their profile. Like, if they set their location to "USA", next time they go to edit their profile, everything is blank. I want the location input field to say "USA". Is this html?
-
Yeah, I realized I said that in my first post, I fixed it in my next post though, so I was abut confused as to which code you were looking at. By the way, the code you just provided worked like a charm, thank you very much.
-
Which would make sense. mysql_fetch_assoc() returns an array. You want to store the result of mysql_fetch_assoc() to a different variable, then grab the ID number from the 'id' element of the array. How can I do this? The second part, I mean. EDIT: I see where you got that ID = $username from, but I updated my code since in one of the posts prior, sorry.
-
Where did you get WHERE id = $username? Everywhere I see it, it says $id.
-
Lol, about your first code, I just realized that, I was using find and replace with some variables, but that wasn't causing the problem. I noticed now that the variable "$id" is actually empty. The cookie is not being set when the user is logged in, because i'm not sure how to return a numerical value for it. I'll show you what I mean... Do_login.php <?php include 'connect.php'; $password = $_POST['password']; $username = $_POST['username']; $encrypted_pass = md5($password); $sql = "SELECT id FROM users WHERE username = '".$username."' AND password = '".md5($password)."'"; $result = mysql_query($sql); $num = mysql_num_rows($result); if ($num > 0) { $id = mysql_fetch_assoc($result); setcookie("username", $username, time()+31622400); setcookie("password", $encrypted_pass, time()+31622400); setcookie("logged", "yes", time()+31622400); setcookie("id", $id, time()+31622400); echo "$id"; } ?> When it echos back, I get...
-
I italicized at this point because my site isn't even public yet. I will make sure to protect my code before releasing it. But as for now, please try to help me with the problem i'm having, not the whole protection issue.
-
Thanks a lot, i'll look into that. But I really want this thread to stay on track, the protection isn't really a worry of mine at this point.
-
Could this possibly be a header problem?
-
I'm sure its barely any protection, my friend sent it to me and told me to put it my scripts, so I figured it can't hurt. But i'll just give you the script anyway... function protect($value){ $value = mysql_real_escape_string($value); $value = stripslashes($value); $value = strip_tags($value); } Very primitive and simple, you'd probably be better off finding one on the internet. Like I said, i'm extremely new to PHP. EDIT: I realize I said the script was made by me, which I guess is a lie, it was (I think) made by my friend Luke, but I just said it was mine because I figured it would be as much clarification as he needed to know that it wasn't one I got off of some "MyProtect" or whatever it was sorry
-
No, the protect function is one I made myself. EDIT: As for the script you posted pocobueno... I get no errors when I do it that way, meaning I get "You have edited your profile successfully!", but the profile is not updated. When I was playing around trying to figure things out, I put in xyz for the value of all 7 of these. When I clicked the "Submit" button to run the edit profile script, the first thing I did was check my table via phpMyAdmin, but all the fields were still xyz. I'll post the entirety of the code, perhaps I did something else wrong. I apologize if my code is primitive or not neat, I am new to PHP. I appreciate the help. <!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>Trportfolio.net - Register</title> <style type="text/css"> <!-- body,td,th { font-family: Arial, Helvetica, sans-serif; font-size: 10px; color: #FFFFFF; } body { background-color: #2F553F; } .style1 {font-size: 36px} .style2 {color: #999999} .style2 {} a:link { color: #FFFFFF; } a:visited { color: #666666; } a:hover { color: #FFFFFF; } a:active { color: #FFFFFF; } .style3 { color: #FFFFFF; font-size: 14px; font-weight: bold; } --> </style></head> <body> <?php include 'connect.php'; include 'login_check.php'; $action = $_GET['act']; protect($act); $id = $_COOKIE['id']; if (!$action) { ?> <form id="register" name="register" method="post" action="edit_profile.php?act=edit"> <table width="270" height="484" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#37685E"> <tr> <td height="58" colspan="2"><div align="center" class="style1">TR.profile</div> <div align="center"></div></td> </tr> <tr> <td width="80" height="46"><div align="center">Location: </div></td> <td width="184"><div align="center"> <input name="location" type="text" id="location" maxlength="64" /> </div></td> </tr> <tr> <td height="43"><div align="center"> <p>AIM: <span class="style2"></span></p> </div></td> <td><div align="center"> <input name="aim" type="text" id="aim" maxlength="64" /> </div></td> </tr> <tr> <td height="38"><div align="center">MSN: </div></td> <td><div align="center"> <input name="msn" type="text" id="msn" maxlength="100" /> </div></td> </tr> <tr> <td height="44"><div align="center">Website:<span class="style2"></span></div></td> <td><div align="center"> <input name="website" type="text" id="website" maxlength="70" /> </div></td> </tr> <tr> <td height="50"><div align="center">Hobbies:</div></td> <td><div align="center"> <label></label> <textarea name="hobbies" id="hobbies"></textarea> </div></td> </tr> <tr> <td height="50"><div align="center">Favorite Movies: </div></td> <td><div align="center"> <label></label> <textarea name="movies" id="movies"></textarea> </div></td> </tr> <tr> <td height="56"><div align="center">Favorite Books: </div></td> <td><div align="center"> <label> <textarea name="books" id="books"></textarea> </label> </div></td> </tr> <tr> <td colspan="2"><div align="center"> <label> <input name="image" type="image" value="Submit" src="images/submit.png" alt="Submit" /> </label> </div> <div align="center"></div></td> </tr> </table> </form> <?php } if ($logged_in == "yes") { if($action == "edit"){ $location = $_POST['location']; $aim = $_POST['aim']; $msn = $_POST['aim']; $website = $_POST['msn']; $hobbies = $_POST['website']; $movies = $_POST['hobbies']; $books = $_POST['movies']; protect($location); protect($aim); protect($msn); protect($website); protect($hobbies); protect($movies); protect($books); $sql = "UPDATE `users` SET location='$location', aim='$aim', msn='$msn', website='$website', hobbies='$hobbies', movies='$movies', books='$books' WHERE id = '".$id."'"; $res = mysql_query($sql) or die(mysql_error()); echo "Your profile has been successfully edited!"; } } else { echo "Sorry, an error occurred and you have been logged out. Please re-login and try again."; } ?> </body> </html> I realized that for whatever reason, my code said WHERE id=username, rather than id, so I fixed that. Thank you again.
-
I want to make a small "Edit Profile" section for my website. The profile consists of 7 input boxes, which are as follows. location, AIM, MSN, website, hobbies, favorite movies, favorite books. the code I have is $location = $_POST['location']; $aim = $_POST['aim']; $msn = $_POST['aim']; $website = $_POST['msn']; $hobbies = $_POST['website']; $movies = $_POST['hobbies']; $books = $_POST['movies']; protect($location); protect($aim); protect($msn); protect($website); protect($hobbies); protect($movies); protect($books); $sql = "UPDATE `users` SET location=$location, aim=$aim, msn=$msn, website=$website, hobbies=$hobbies, movies=$movies, books=$books WHERE id = '".$username."'"; $res = mysql_query($sql) or die(mysql_error()); The error I get is this... If you were to put in "asdf" in the first field of the edit profile form, then the error would be I'm not really sure how to put variables in an UPDATE... SET... sequence, so maybe someone can help me? (this was not my first resort, I have been googling for an hour.) THANKS!
-
Alright, so I saw the "Hi." I don't get how that is helping me with the cookies
-
Alright, I now have a better understanding, but the cookie is still not being sent, and unless variables are output, I don't think that anything is being sent to the browser until the cookie line...? By the way, much thanks for clearing that up.
-
Like I said, i'm new to PHP, and to be honest, I have no idea what that means. I took out any "echo" scripts that I had, yet the cookies still don't work. Maybe I misunderstood you when you said "Set your cookie before you echo anything." My code now looks like this... <?php include 'connect.php'; $time = time(); $password = $_POST['password']; $username = $_POST['username']; $sql = "SELECT * FROM users WHERE username = '".$username."' AND password = '".md5($password)."'"; $result = mysql_query($sql); $num = mysql_num_rows($result); if ($num > 0) { //USER AND PASS ARE CORRECT $id = mysql_fetch_array($result); setcookie("cookie", "Hello.", time()+3200); header("Location: login_successful.php"); } else { header("Location: login_fail.php"); } ?> Since we were on the topic of headers, I figured i'd tackle another problem and ask for a bit of help about why this isn't working. Please realize that I am not fully aware of all these 'exceptions' yet. I am actually learning a lot of my codes from tutorials, but I am tweaking it to how i'd like it, as I attempt to learn in the process. I apologize for the newbie questions, and your help is much appreciated (Sorry for being a nub roopurt, lol.)
-
Hi everyone. I'm kinda new to PHP, but I feel as though I am learning quite quickly. I was attempting to make a login, but I hit a roadblock in this... -------------------------------------------------------------- <?php setcookie("cookie", "Hello.", time()+3200); ?> -------------------------------------------------------------- That code works. --------------------------------------------------------- <?php include 'connect.php'; $password = $_POST['password']; $username = $_POST['username']; $sql = "SELECT * FROM users WHERE username = '".$username."' AND password = '".md5($password)."'"; $result = mysql_query($sql); $num = mysql_num_rows($result); if ($num > 0) { //USER AND PASS ARE CORRECT $id = mysql_fetch_array($result); echo "s"; setcookie("cookie", "Hello.", time()+3200); } else { echo "f"; } ?> --------------------------------------------------------- But after taking that EXACT line, and putting it in my login script, it doesn't work. Help appreciated! Thanks tons guys. The first code can be seen active on www.trportfolio.net/cookie_test.php The second can be seen if you register at www.trportfolio.net/register.php and then login at www.trportfolio.net/login.php
-
Just realized this is in the wrong section Sorry, i'll post it in the correct one and leave this here for deletion.
-
Hi everyone. I'm kinda new to PHP, but I feel as though I am learning quite quickly. I was attempting to make a login, but I hit a roadblock in this... -------------------------------------------------------------- <?php setcookie("cookie", "Hello.", time()+3200); ?> -------------------------------------------------------------- That code works. --------------------------------------------------------- <?php include 'connect.php'; $password = $_POST['password']; $username = $_POST['username']; $sql = "SELECT * FROM users WHERE username = '".$username."' AND password = '".md5($password)."'"; $result = mysql_query($sql); $num = mysql_num_rows($result); if ($num > 0) { //USER AND PASS ARE CORRECT $id = mysql_fetch_array($result); echo "s"; setcookie("cookie", "Hello.", time()+3200); } else { echo "f"; } ?> --------------------------------------------------------- But after taking that EXACT line, and putting it in my login script, it doesn't work. Help appreciated! Thanks tons guys. The first code can be seen active on www.trportfolio.net/cookie_test.php The second can be seen if you register at www.trportfolio.net/register.php and then login at www.trportfolio.net/login.php