where is the error?

[Anon]

Hello everybody

Could somebody please tell me where i am going wrong.

I have a file called ex1.ini which has the following code.

<p> Address <input type="text" name="address" ></p>

City<input type="text" name="city" >

and i have data.php which has the following statement:

include "ex1.ini";

Now, when i run my data.php, the two text boxes should be filled with a record from my table.

This is the code which i am using, but, where exactly i have to paste it.

$username = "SYSDBA";
$password = "masterkey";
$connection = @ibase_connect('C:\work\country.GDB', $username, $password);
if (!$connection)
{
exit ("Unable to connect to database: $connection");
}
$db = 'Select * from customers';
$bsc = ibase_query($connection, $db);
while ($row = ibase_fetch_row($bsc)) {
echo '<value="' . $row[1] . '">';

}

ibase_free_result($bsc);
ibase_close($connection);

IS THE ECHO STATEMENT CORRECT??
Please help me

Thank you

[nnichols]

$db = 'Select * from customers';
$bsc = ibase_query($connection, $db);
while ($row = ibase_fetch_row($bsc)) {
echo '<value="' . $row[1] . '">';

1. you must escape the " in the echo statement
2. the value section must go inside the input tag

It would probably be easier to do -

$db = 'Select * from customers';
$bsc = ibase_query($connection, $db);
while ($row = ibase_fetch_row($bsc))
{
echo "<input type=\"text\" name=\"address\" value=\"$row[1]\">";
echo "<input type=\"text\" name=\"city\" value=\"$row[2]\">";
}

than to use your ex1.ini file.

Hope this helps.
Nick

[trooper]

Or another way but similar would be to do this

<p> Address <input type="text" name="address" value="<?php echo "$_POST['address']";?>"></p>

City<input type="text" name="city" value="<?php echo "$_POST['city']"; ?>">

Mind you if you do that then you'll need to rename you ini file to a .php file