Hi,
I'm new on mySQL. I want to validate user input from html form with mySQL row.
html>
<head></head>
<body>
<form name="login" method="post" action="if.php">
Lucky Number <input type="text" name="guess" />
<input type="submit" value="Submit" />
</form>
</body>
</html>
and if.php is here
<?php
$dbhost = "localhost";
$dbname = "gm";
$dbuser = "root";
$dbpass = "";
//Connect to database
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());
//table rows
$guess = $_POST['guess'];
$result = mysql_query("SELECT guessnum FROM secnum");
$row = mysql_fetch_array( $result);
if($_POST['guess']==$row) {
echo "<p>Good Job!</p>";
} else {
echo "<p>Sorry!</p>";
}
?>
and my mysql database is like this
Datebase name = gm
table=secnum
column=guessnum
row(or column value)=1
comingsoon
New php-forum User
New php-forum User
Posts: 4
Joined: Thu May 19, 2011 8:23 pm
