Q

PHP page works sometimes, not others

Weird problem. I have a form on a PHP page that collects three fields. When submit is selected, the data is sent to a second page where MySQL writes the data. But sometimes it works, and sometimes it doesn't. For new users who have not been entered into the database, sometimes it writes data successfully and other times it just gives me a 0 and no data is written. Any ideas what I should be looking at? I have six other databases running in the same environment that have never had this type of problem.

Well the first thing to do would be to look at the output of the mysql_error() function in PHP. This function will

provide the textual error message from the MySQL server, which may shed some light on the problem. Another recommendation is to send this error message, along with any relevant information, to yourself with the mail() PHP function when an error is encountered. This may help identify trends.

One area to watch for is users violating primary keys or UNIQUE indexes. Before inserting the row, check and make sure the row is truly unique, or catch the error and ask the user for new information.

This was first published in November 2004

Dig deeper on Open source Web and application servers

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close