Forum Moderators: travelin cat
I am a webmaster at a school district, primarily mac environment, and I do a lot of php/mysql web development. I develop on a mac OS X 10.2.8 ibook, and post to a mac OS X 10.2.8 G4 server. The server has MySQL 4 running and I just installed PHP 4.3.4 (from 4.1.2).
Before I upgraded the php, all but one of my pages worked correctly (posting queried data appropriately). The one page that didn't display correctly was an import code that pulled data from a comma delimited file into a mysql database. I found out on www.php.net that the function I was using fgetcsv requires auto_detect_line_endings to be set to ON in the php.ini file. However, I could not locate the php.ini file to edit, so I decided to upgrade the php version in hopes that the file would be recreated.
So, I upgraded to PHP 4.3.4, and now about half of my pages do not post mysql queries as they did before. For instance, I have a login page which checks the user input against the database. However, now it appears as though it cannot access the database data because no users can be found by the login script. The database HAS NOT changed. The only change was the php upgrade.
I have other pages experiencing the same problem. The page connects to the MySQL database. I know this because it does not return a connection failure (neitehr built-in error/warnings, nor my own failure error messages). However, whenever I use a submit button to run an sql query, nothing posts. It appears to me as though it is somehow not able to get the data which resides in the database. And it is NOT a MySQL query problem or other programming problem. I know that because before the upgrade, all pages (with the exception of that one import pg) worked perfectly and nothing else has changed.
If you have an idea as to why I am experiencing this problem, I would appreciate any help you can give me. Ideas on PHP and MySQL version conflicts?
Thx,
Josh
this is my php database connection script (suitably anonymised):
<?php
$host = '127.0.0.1:3306' ;
$user = 'user' ;
$password = 'password' ;
$dbcnx = mysql_connect($host,$user,$password) ;
if (!$dbcnx )
{
echo ('fejlede at connecte til serveren<br>'.mysql_error());
exit() ;
}
else
{
// echo('fik forbindelse til serveren<br>');
}
$base = mysql_select_db('database',$dbcnx) ;
if (!$base )
{
echo('fejlede at connecte til databasen<br>'.mysql_error());
exit() ;
}
else
{
// echo('fik forbindelse til databasen<br>');
}
?>
This script will also give you exactly where and what goes wrong when connecting to you MySQL database
I'd like to believe that dcrombie is spot-on here. Using Register Globals [php.net] went from ON to OFF in PHP 4.2.0. You didn't mention whether or not you are running Apache, but a quick per-directory override setting will let you know immediately if this is your issue. Have a look at Clarification of Global Variables OFF [webmasterworld.com] and the linked threads within for more information.
If there's an excisting php.ini does it then get overwritten / updated? I can see that the upgrade is from a version of php from before they got turned off by default.
register_globals has been turned off for a good reason: it's a security hole to have them turned on - it's possible to modify variables on the server by sending suitably crafted http headers.
/etc/httpd/httpd.conf<IfModule mod_php4.c>
php_admin_flag register_globals on
</IfModule>
(I set a bunch of other flags at the same time but that's the one for this problem)
php.ini-distfile to your bin directory from your PHP source directory:
cp php.ini-dist /usr/local/bin/php.ini
# or (if your don't have a local directory):
cp php.ini-dist /usr/bin/php.ini
The pages in which I was experiencing some problems were all forms which relied on a large number of text inputs (textboxes, select drop downs, check boxes).
With the upgrade (from PHP 4.1.2 to 4.3.4) there have been some important changes. Specific to my issue, it has become necessary to explicitly retrieve the POST variables for use upon submitting the form. This is done in the following way:
Text Input: <input type=text name=MYINPUT>
Submit: <input type=submit name=SUBMIT_FORM value=Submit Form>
---
$MYINPUT = $_POST['MYINPUT'];
$SUBMIT_FORM = $_POST['SUBMIT_FORM'];
Then because we have retrieved this post data we can use it. I then go ahead and input that data into a database.
This appears to have solved my problem. This looks like a good forum community that I will keep my eye on. Thanks for your help.
