calcio22

Hi, My INI file actually has long arrays turned on, and I changed the calls to just $_POST, with no success. Any other thoughts as to the problem. I imported the database using PHPMyAdmin and everything appears to be the same.

The following code successfully inserts into a MySQL DB on PHP 4.x, however, I am currently running PHP 5.1.2 and it is resorting to the ELSE statement and not inserting into the database. Does anyone have any thoughts on what could be wrong, or what I may need to change in my PHP.ini file? Thank you in advance. [/********************************************** Sets passed values to local variables to be used. **********************************************/ $POVendorName=$HTTP_POST_VARS['POVendorName']; $PONum=$HTTP_POST_VARS['PONum']; $POAmount=$HTTP_POST_VARS['POAmount']; $POVendorPhone=$HTTP_POST_VARS['POVendorPhone']; $POVendorDesc=$HTTP_POST_VARS['POVendorDesc']; $POExpDate=$HTTP_POST_VARS['POExpDate']; /********************************************* Insert new category information into the category table. Checks for errors during the insert. *********************************************/ echo"$POVendorName $PONum $ POAmount $POVendorPhone POVendorDesc POExpDate"; mysql_select_db('PO'); $query = "INSERT INTO PO (POVendorName, PONum, POAmount, POVendorPhone, POVendorDesc, POExpDate) VALUES ('$POVendorName', '$PONum', '$POAmount', '$POVendorPhone', '$POVendorDesc', '$POExpDate')"; $result = mysql_query($query); if ($result) { echo "<span class='headtitle'>Add Blanket PO Results <br /><br /></span>"; echo mysql_affected_rows(). ' category sucessfully inserted into the database.'; } else { echo "Add category did not work properly, please try again later."; } require('footer.inc'); ?>]

I am currently running PHP 5.1.2. PHP is not throwing any errors, rather it is defaulting my error checking in the PHP telling me the query was not successful. Here is an example of a page that will not submit (this is the processing page). It is the 'else' statement that is being displayed with nothing entered into the database. Note that the echo of all the values are displaying on the page. [/********************************************** Sets passed values to local variables to be used. **********************************************/ $POVendorName=$HTTP_POST_VARS['POVendorName']; $PONum=$HTTP_POST_VARS['PONum']; $POAmount=$HTTP_POST_VARS['POAmount']; $POVendorPhone=$HTTP_POST_VARS['POVendorPhone']; $POVendorDesc=$HTTP_POST_VARS['POVendorDesc']; $POExpDate=$HTTP_POST_VARS['POExpDate']; /********************************************* Insert new category information into the category table. Checks for errors during the insert. *********************************************/ echo"$POVendorName $PONum $ POAmount $POVendorPhone POVendorDesc POExpDate"; mysql_select_db('PO'); $query = "INSERT INTO PO (POVendorName, PONum, POAmount, POVendorPhone, POVendorDesc, POExpDate) VALUES ('$POVendorName', '$PONum', '$POAmount', '$POVendorPhone', '$POVendorDesc', '$POExpDate')"; $result = mysql_query($query); if ($result) { echo "<span class='headtitle'>Add Blanket PO Results <br /><br /></span>"; echo mysql_affected_rows(). ' category sucessfully inserted into the database.'; } else { echo "Add category did not work properly, please try again later."; } require('footer.inc'); ?>]

Hello, I have an application that I have written and it works fine on PHP 4.3.10 and MySQL 4.0.25 standard running on Linux, however, I have recently moved the application to a different server, with the latest stable builds of PHP MySQL, and PHPMyAdmin, using the database export in PHPMyAdmin and literally copying and pasting the php files, and the application is not working correctly. The following things are occuring: - Pages that feed directly from the DB work, but pages that pass values to a processing page do not display the information that I want queried, however, the values are being passed to the processing page. - Queries to the database for INSERT and coming back as failed on SOME pages. - All pages transfer information to a processing page via a POST I have a standard setup for PHP and MySQL. Is there an extension or change I have to make in the PHP.ini file? I do not have access to the previous servers php.ini file. Thank you.

Thanks! This worked!

Hello, I have installed Apache, PHP, and MySQL on a Windows 2003 Server in that order. Unfortunately, because I installed MySQL last, I do not know how to get PHP to realize it is there. PHP is current installed in C:\Program Files\Apache\PHP, while MySQL is installed in C:\MySQL, and the php.ini file is in C:\WinNT. While, I cannot be the first person to ask this question, how do I get PHP to recognize the installation of MySQL? I believe I am running the latest stable version of PHP and MySQL. Thank you in advance.