I need to make a php page to change password. Can someone make a simple form and mysql thing to do it? Here is the existing file Checklogin.php <?php $host="localhost"; // Host name $username="bucketho_****"; // Mysql username $password="*****"; // Mysql password $db_name="bucketho_****"; // Database name $tbl_name="members"; // Table name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // username and password sent from form $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql); // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table row must be 1 row if($count==1){ // Register $myusername, $mypassword and redirect to file "index.php" session_register("myusername"); session_register("mypassword"); header("location:index.php"); } else { header("location:login_failed.php"); } ?> Here is the mql info thing CREATE TABLE `members` ( `id` int(4) NOT NULL auto_increment, `username` varchar(65) NOT NULL default '', `password` varchar(65) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Dumping data for table `members` -- INSERT INTO `members` VALUES (1, '****', '****'); I made the private info * to protect it. Thanks. I need a script that can connect to the database and change the password. Thanks, Hopefully it can be done for free which would be a great help!

[SOLVED] Change Password

By sith717
September 22, 2008 in PHP Coding Help

Followers 0

Start new topic

Prev
2
3
4
5
6
7
Next
Page 7 of 7

Recommended Posts

.josh

Posted September 22, 2008

- Share

Posted September 22, 2008

After forcing myself to go through all 10 pages of this thread, it's painfully obvious that you aren't trying to work it out for yourself, but just to have people spoonfeed it to you one line at a time. That is not what we're here for. Post in the freelance forum.

Thread closed.