Hello and Thank you for taking the time to read post. I posted this project earlier and have since found out a little more info so I wanted to update the post.
Please read the bottom of this post to understand the original problem.
ok with that said I believe someone may have hacked and forced a sql statement to erase data in a the tables listed below.
I Just need someone to go in and review and secure the code and/or database(mysql) from further attack. I also need someone to set up a automatic database backup system through php that updates twice a day so if there is any further problems the data will always be secure.
Thank you for taking the time to review this I look forward you your bids
Please respond with the word
MYSQL
so I can weed out the automatic listeners and developers who did not read this. also please bid reasonable.
Thanks
Ryan Bauer
——————–original post———————————-
Hello I am in need of help. I am a beginning php mysql web developer I recently completed a a cms system for a apartment rental site. one of the areas I made was a area to add new properties to their site. I created four different tables they are as follows:Properties, propIMG, amenities, Cities. the tables are organized as follows.
Properties
-propID
-PropAdress
-PropZipcode
-propState
-cityID
propIMG
-propID
-imageName
Amenties
-amentiesID
-propID
cities
-cityID
-cityName
Now this is my problem twice now data has disappeared from all of the above tables. The first time it happened someone was in the process of adding a new property through the CMS when they said their browser froze, they refreshed then all the data in the properties table was deleted except the property the person was trying to add also all data associated with properties that disappeared also disappeared. BUt the strange thing is not the whole table was deleted their was still data in 3 of 4 of the tables that table disappeared it was old test data that was not related to any any of the properties that were deleted..
the same thing also happened to the properties images table where all the data that was in the table associated with the deleted properties was gone but other info from previous test properties was still there. Now all the cities in the cities table was deleted.
I have done research and I can not seem to find a source or a problem.
Now the first time this happened I thought maybe their was a script error somewhere that would cause this but I could find none. I then proceeded to test the system myself so I uploaded about twenty new properties everything was working perfectly until I opened the site today and all the data I just put in was erased with the exception of the cities table all the cites were still there.
Now here is the part that is really weird Nobody has accessed the cms I built but me and The last time i logged off their was over 20 properties but now they are all gone. There are also the same four tables data erased but not all data just the ones accociated with the new properties I uploaded..
I need a MYSQL GURU or Master that can look over the existing code and try to troubleshoot the problem and come up with a fix. I Also need someone to create a php based automatic mysql backup system I would like the system to back-up the database daily and a easy system to reload the backed-up mysql dump.
Thank you for taking the time to review this I look forward you your bids
Please respond with the word
MYSQL
so I can weed out the automatic listeners and developers who did not read this. also please bid reasonable.
Thanks