« Today's Keynote | Main | More About the PHP/MySQL Annoyance »
January 8, 2004
Progress Report
Alright, I'm running out of vacation days, so that means that I should now look at what tasks I've completed, and what is still left. I've got a working beta of Taco HTML Edit 1.5.2. I still need to send that to Alex, who is determined to crash it (and probably will succeed, copying and pasting millions of text characters might do the trick). I've spent a lot of time working out the bugs of the employee login system for the Living Water website. I've dealt with all of the addslashes/stripslashes annoyances that arise from using PHP/MySQL. As I told Josh the other day, it would be nice if PHP let the programmer handle all of the slashes manually. However, PHP (and its iteraction with MySQL) instead tries to be smart and help handle the slashes. It ends up just causing problems. I also added a couple Spanish translations to the appropriate portion of the website. There is no longer a link to automated Google translations because they are just too inaccurate. No progress has been made on the mysterious new project, but I'd like to get going on that in the next couple days if I get a chance. Wait a minute, I just realized why I need my iMac. The new project has the potential to really mess up a computer, so I don't want to work on it on my primary computer. Now, I'll have to decide if I want to bring the iMac to college. I don't feel like it, but I might need to. Finally, I need to find something to do next summer, preferably something that pays. I've got some applications for internships and researchships, and I need to get going on those.
Posted by Raj Doshi at January 8, 2004 3:42 AM
Comments
Yeah... bring Taco HTMLedit on! Send it away! If you wait too long I'll have to just get it from you at school and thats no fun.
Posted by: Alex at January 8, 2004 11:37 AM
This pertains to your "annoyance".
I looked at my code today, and I see that I haven't done anything to add or strip slashes. So basically, as I've said before, PHP and mySQL works happily. So here's what I do.
When I input something into the database, PHP has already added the slashes. I have a verification page, in which I do a stripslashes on the passed variable. However, the database gets all the slashes and so forth created by PHP.
I realized today that I never dealt with this "annoyance" whatsoever, other than the fact that I don't remember at all when I even had this problem in my mind (even though I should have, like a good little programmer, such as yourself). But yeah, it's not a server thing or whatever (I was full crap), it is a PHP thing. It's not really an annoyance, but they just do it for you.
So here's my thing on the "annoyance". PHP adds the slashes, and mySQL just gladly accepts the incoming data (whatever it may be). When PHP drags that information out from the databse, PHP does it all on it's own, so that the user or the programmer doesn't have to worry about stripping or adding slashes. I swear PHP/MySQL must live as one! WOOOOOO!
Posted by: Josh at January 9, 2004 7:57 AM