| Mike S. 2004-12-24, 3:55 pm |
| > hallo ,
>
> i have wriiten simple php script , below.
> created databse "dollar1_allinfo" with table 'totalinfo'
>
> but on clicking submit button ,
>
> information entered is not entering in database.
>
> also, echo statements are also not displaying after submit
>
> <?php
> if ($submit)
> {
> $db = mysql_connect("localhost","root");
> mysql_select_db("dollar1_allinfo",$db);
> mysql_query("INSERT INTO totalinfo (username,password,) VALUES
> ('$loginusername','$loginpassword')");
> echo 'thank you';
> echo 'So Hurry Up';
> }
> ?>
>
> thank you.
Because your query and echoes are within an "if" block, I'd say that
$submit is evaluating to FALSE, and thus not executing the query and
echoes.
Add (before the if statement):
echo "Submit = $submit";
Make sure that $submit is evaluating to TRUE.
To All Beginning Programmers ("Newbies"), or just people who want to
easily debug their code:
Try adding debugging statements to help you find problems. A few echoes
or prints in selected locations will help identify the issue. Make sure
your variables are evaluating to values that you think they should be.
If you want to keep the debugging statements in your code and just
activate them when you need to see them, do something like:
// near the top of your code
$debug=TRUE;
// and anywehere in your code
if ($debug) {
echo "DEBUG: Submit = $submit<BR>\n";
}
// or whatever echo might help you nail down the problem. Put as many of
these in your code and you can turm them ON and OFF very easily, by
changing one line of code.
OR for even quicker debugging, replace $debug=TRUE; with
$debug=$_GET['debug'];
and then you can turn it on in by adding ?debug=TRUE at the end of the
URL. Example: http://www.php.net/path/my.html?debug=TRUE
or: http://www.php.net/path/my.html?debug=1
**DISCLAIMER** Using the URL method is NOT a secure way to do this!!!
And I'm sure there's plenty of folks groaning out there because it is a
BIG security hole. You really would want to do this on a development
machine and network, and remove the debug code for production. That
really should go without saying.
Good luck.
:Mike S.
:Austin TX USA
|