Isset

Anon

Hello, i am trying to insert couple of records into my db using isset, but it does'nt work.could some body please tell me where i am going wrong.

<?php
//Check for the submit button
if (isset($submit)){
$username = "SYSDBA";
$password = "masterkey";
$connection = @ibase_connect('localhost:C:\personal\database.GDB', $username, $password);
$db = "insert into COUNTRY (COUNTRY, CURRENCY) values ($Yourcountry, $Yourcurrency)";
$result = ibase_query($connection, $db);
} else {
?>
<form action='try2.php', method="post">
Country
<br> <input type="text" country="Yourcountry">
<p> Currency
<br> <input type="text" currency="Yourcurrency">
<p>
<input type="submit" name="submit" value="submit">
</form>

<? } ?>
</body>

---------------------------------------------Many thanks
chand

jc94062

First off, I'm not to sure on ibase, but assuming its similar in all but actual words to mysql...

if ($submit) will work just as well as if (isset($submit)).

Try this

if ($submit)
{
echo "Test";
}

and see if that works.

If that fails try

if ($_POST['submit'])
{
echo "Test";
}

As if register_globals are off the top one won't work.

If you get Test outputted and it still doesn't work, what error messages, if any, do you get, cause at a glance I can't see anything wrong with the code.

Anon

HI james,

I got the ouput as Test, but, unfortunately, the records are not inserted into my db.I dont know why, could you able to figure it out??

Many thanks

crimaniak

Never use global pool of variables. Most compatible method is $HTTP_xxx_VARS[] arrays now.
Quote your string data before inserting to SQL query and validate numeric. Quoting is not just a '$var'. Quoting is addslashes($var).