HELP - Script needed on my test php

miyaka

HELP Please.... Sorry if im posting here.. But i dont really know how this will work... Im trying to learn PHP now..

Im a newbie in web design (HTML knowledge only)and almost Zero on php scripting. Can any one help me or give me a simple script for my sample database?

My database has 5 fields : "ID" - key and VAR1, VAR2, VAR3, VAR4

What i want to do is :

Have a 1 form field that would ask me to encode content of "VAR1" <<<<
after i press submit then

New page or same page will ECHO me contents of VAR1 and VAR2
and also ask me to encode/input for VAR3...

If my input in VAR3 is correct (there is a match between VAR1, VAR2 and VAR3 of one databse single entry) The database should show me the content of VAR4...

Please if anyone can give help/PHP script of this...

Please let me know if you have questions......

Thanks
-Shiela

:queasy: 😕

dalecosp

miyaka wrote:
Please let me know if you have questions......

Thanks
-Shiela

:queasy: 😕

I've got one: have you started yet? 😃

<?php

if (!$_POST['submit']) {
   echo "
<form action=\".$_SERVER['PHP_SELF']."\" method=\"post\">Please encode the first variable: <input type=\"text\" name=\"var1\">
<br />
<br />
<input type=\"submit\">

";
}

//etc...

?>

miyaka

thanks dalecosp

What im trying to do now is to create a password reminder page.

I updated the variables...

Here is my present MYSQL

Table structure for table test1

CREATE TABLE test1 (
USER_KEY int(2) NOT NULL auto_increment,
USERNAME varchar(20) NOT NULL default '',
Reminder varchar(50) NOT NULL default '',
ReminderAns varchar(20) NOT NULL default '',
PASSWORD varchar(20) NOT NULL default '',
PRIMARY KEY (USER_KEY),
UNIQUE KEY USERNAME (USERNAME)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Test DB';

Can you create a full script for this?
Is it possible to run the script without logging in?

miyaka

Hi i have this code ... Dunno where can i put or what script to use to give the USERNAME....

Please Anyone who can give me script for this to work?

File: forgotpwd.php


<html>

<head>

<?php
	$connect = @mysql_connect('localhost','root','');
	$selectdb = @mysql_select_db('testing',$connect);

    $query = "SELECT * FROM test1 WHERE USERNAME = '$username'";

$rs = mysql_query($query) or die('Error!');
    $row = mysql_fetch_array($rs);
    $username = $row['USERNAME'];

echo "FORGOT PASSWORD";
     while ($row = mysql_fetch_array($rs)) {
			                  $username = $row['USERNAME'];
			                  $reminder = $row['Reminder'];
					  $Ans = $row['ReminderAns'];
					  $pass= $row['PASSWORD'];

			                  echo " $username, <br><p> $Ans";
			                }		
     	     @mysql_close($connect); 
		?>

<TABLE>
	<p align="center">&nbsp;
		<form method="post" action="getpass.php">
			<table border="1" width="350" cellspacing="0" cellpadding="0" style="border-collapse: collapse">
				<tr>
					<td width="150">ANSWER: </td>
					<td width="200"><input type="text" name="password" size="20"></td>
				</tr>
				<tr>
					<td colspan="2">
					  <?php 
					    echo "<input type=\"hidden\" name=\"username\" value=\"$username\">";
					  ?>  

				  <?php 
				    echo "<input type=\"hidden\" name=\"reminder\" value=\"$reminder\">";
				  ?>  
				  <input type="submit" name="Submit" value="Submit">
				  <input type="reset" value="reset" name="reset">
				</td>
			</tr>
		</table>
		</form>
	<form>


</table>

</body>

</html>

and the second file :getpass.php


<?php

$username = isset($_GET['username']) ? $_GET['username'] : $_POST['username'];
$reminder = isset($_GET['reminder']) ? $_GET['reminder'] : $_POST['reminder'];
$Ans = isset($_GET['Ans']) ? $_GET['Ans'] : $_POST['Ans'];
$pass = isset($_GET['pass']) ? $_GET['pass'] : $_POST['pass'];

echo "username = $userid<br>
      reminder = $reminder<br>
      Ans = $Ans<br>";

 $connect = @mysql_connect('localhost','root','');
 $selectdb = @mysql_select_db('training',$connect);
	$query = "SELECT * FROM test1
		WHERE USERNAME='$username' AND $reminder='$reminder' AND $Ans='$Ans'"; 
	    echo "Your Password is $pass <br>";                                      

?>