Data integrity checking w/ PHP & MySQL?

From: Date: Thu, 07 Dec 2000 14:30:44 +0000
Subject: Data integrity checking w/ PHP & MySQL?
Groups: php.db php.general 
Request: Send a blank email to php-db+get-5077@lists.php.net to get a copy of this message
I've run into some problems on my high traffic site, bangable.com, with what appears to be data integrity in MySQL, and was wondering if there are any checks I can do in PHP to validate that the right information was updated. I have a ton of inserts/selects going on.. in little over a day the number of queries has reached 1 million. This is an amihotornot type site, what happens is the user votes on a picture, that rating/# of votes is updated in the DB, the persons IP thrown into a database, then moves onto the next picture.. I've gotten a few reports of people who have had like 600 votes then all of a sudden they drop to like 27 (or some other random #) or their score changes, or some combination of the 2. I've only had about half a dozen reported cases of this, and half a dozen in several million queries is pretty good, but it reflects badly on the integrity of the system and I need to correct that. Is there any way I can code in a check in PHP to see if it got updated correctly without inducing too much overhead? While searching around the net this morning for data integrity in MySQL, what I basically saw was the check needs to be coded in the programming language. If anyone has recommendations on how to do this, I would appreciate it. I don't want to switch over to another DB unless there's no solution, as I didn't use a db wrapper and changing all those database calls would really suck. Thanks, Chad Day When I speak german... I think german in my head... but like...Do skript kiddies see a w40l3 8uncha 1's and 0's and 3's and 4's and 7's in their h34d'5 w43n t43y R +a1k1n6 ? -- SirStanley

« previous php.db (#5077) next »