I've tried repediately to have a PHP script validate a form when the form is
submitted. I'm quite new to PHP, and I'd really appreciate the help anybody
could give me. I've been stuck on this problem far to long.
I have a form (here's the code):
<form method="post" action="<?php $PHP_SELF; ?>">
Username:
<input type="text" name="username" maxlength="255" value="<?
$HTTP_POST_VARS['username']; ?>">
<br>
Password:
<input type="text" name="password" maxlength="8" value="<?
$HTTP_POST_VARS['password']; ?>">
<br>
<input type="submit" name="login" value="Log In"
onclick="document.refresh()">
<br>
<br>
</form>
And right underneath the form code, I have my PHP script:
<?php
if (isset($login)) {
insert();
}
function insert() {
$db = odbc_connect('mydatabase', 'myusername', 'mypassword');
if(!$db) {
echo "An error has occured. Please <a
href=\"mailto:[EMAIL PROTECTED]\";>e-mail</a> the text below to
me.<br><br>~~~~~~~<br>$PHP_ERROR<br>$db<br>~~~~~~~";
}
$SQLQuery = "SELECT fldID FROM tblUsers WHERE fldUsername = '$username'
AND fldPassword = '$password'";
$cursor = odbc_exec($db, $SQLQuery);
if (!$cursor) {
echo "An error has occured. Please <a
href=\"mailto:[EMAIL PROTECTED]\";>e-mail</a> the text below to
me.<br><br>~~~~~~~~<br>" . odbc_errormsg($db) . "<br>~~~~~~~";
}
}
?>
What I'm trying to achieve here is that when the user fills out the form,
presses the "Log In" button, the script underneath validates and inserts the
data into a database. Now, I click on the "Log In" button, nothing happens.
Could anybody please help me with this? I would really, really appreciat any
help.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
