Reputation: 7 Worker
- Active Posts:
- 2,361 (0.49 per day)
- 26-March 01
- Profile Views:
- Last Active:
- Apr 16 2014 08:54 AM
- OS Preference:
- Favorite Browser:
- Internet Explorer
- Favorite Processor:
- Favorite Gaming Platform:
- Your Car:
- Dream Kudos:
Posts I've Made
Posted 20 Aug 2013Hello,
Using PDO would indeed be a lot better, but I can understand you don't want to do that yet.
However, to make it more secure, you should escape any input using
Please take this as an advance, you really don't want people injecting MySQL.
I have a function I use to sanitize all my stuff to prevent injection, I was just more worried about the basics of the script working, its all secured and cleaned up now.
Posted 19 Aug 2013That makes sense
Posted 19 Aug 2013It's nice that it's working, but can you read and explain your code to some one? Will you be able to in six months?
well now that the code itself is working i can clean it up. as for using deprecated MySQL functions I already stated that the site is going to be converted to a whole new system soon, but as for right now it is what it is.
Dont think I dont appreciate your comment because I agree 110%. I just am doing what I need to do to get the job done right now.
Posted 19 Aug 2013yup that did it, how did i miss that! thanks so much!
Posted 19 Aug 2013
Quote12 $q2 = mysql_query("INSERT INTO heards artist_id, user_id VALUES ".$id.", ".$user_id."");
Where is "$q2" being executed at?
Though.. if it were me.. I would only do soft deletes. That information on who liked something, and then how long/when they unliked something could be mined.
$q2 is executing on its own, it works the same as if i just had the mysql_query. if you look thats how I have my delete and that works fine, but as for the delete what is the plus side of a soft delete?
- Member Title:
- You wish you were my hand!
- 28 years old
- October 5, 1985
- Lindenhurst, NY
- Years Programming:
- Programming Languages:
- PHP, MySQL, HTML