mysql / php form works on internet but not on intranet
Posted on 2011-09-18
I am continuing my attempt to port an established web site with mysql backend to an intranet site. To date I have established the database and web site, with tables and data, on a stand-alone Windows 7/Wamp setup.
The intranet web site functions correctly. I can access the database from phpmyadmin however, when I attempt to use the intranet form (php/html) to access the database I am getting an "Undefined variable" error returned.
I have made several corrections based on the "Experts" feedback. I now need some additional assistance
Internet: MySQL 5.0, PHP 5, Apache on Linux Server
Intranet: MySQL 5.0.7, PHP 5.3.5, Apache 2.2.17, on Windows 7
Error: Undefined variable: search1 in C:\wamp\www\part\edit_pprq1.php on line 11
Undefined variable: search2 in C:\wamp\www\part\edit_pprq1.php on line 11
Code: 8. $search=mysql_real_escape_string($_POST['search1']);
11. $data = 'SELECT * FROM `PPRQ` WHERE `FN` = "'.$search1.'"
AND `LN` = "'.$search2.'"';