I'm a beginner in PHP and Database connections

I'm accessing a MS Access database using PHP. Everything is working fine. I
get the data through an ODBC query and show it on an HTML format form so
that I can modify the data and re-post it. I tried to pass the values to a
second php file that has the updating query but no luck. My PHP didn't
accept passing variables at all. I'm using PHP 4.3.1 on IIS 5.1 server, I
even tried Apatche2 with no luck.

Is there a way to run an update query using data from a form in the same
page without the need for passing it to another page?, and what is wrong
with my server not allowing me to pass variables, is there a parameter in
the server I should set on?


Here is a test example for passing a variable that failed:


File 1: Test Passing a variable

<?PHP

echo "<html>\n";
echo "<body>\n";

echo "<form name=\"Update\" method=\"post\" ACTION=\"update.php\">\n";

echo "<p align=\"right\"><INPUT type=\"text\" NAME=\"sname\"
VALUE=\"$sname\" SIZE=30></td>\n";

echo "<P><INPUT TYPE=\"submit\" NAME=\"submit\" VALUE=\"Send\"></p>\n";

echo "</FORM>\n";

echo "</body>\n";
echo "</html>\n";

?>

****************************************************

File 2: update.php

<?php

echo "<html>\n";
echo "<body>\n";


if (isset($sname)) {

        print($sname);


        } else {

        print ("No data yet\n");

        }

echo "</body>\n";
echo "</html>\n";

?>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to