Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

[PHP-DB] Data integrity checking w/ PHP & MySQL? From: Chad Day (cday <email protected>)
Date: 12/07/00

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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>