In the last of our 6 Part series, we cover how to create a MySQL database and how to use PHP scripting to integrate the database content into the site, as well as adding information from forms to the database. Before watching this video, it is a necessity to watch the previous videos in the series. Otherwise, you will be completely lost. For the full code and extra coding tips, please visit the wiki project page at this link:
http://www.tinkernut.com/wiki/page/Episode_309
Part 1: HTML – http://www.youtube.com/watch?v=6Ct6emxVR9w
Part 2: CSS – http://www.youtube.com/watch?v=L8R2x7bEJUo
Part 3: Javascript – http://www.youtube.com/watch?v=TLjJM-CsOIs
Part 4: Server – http://www.youtube.com/watch?v=cUMYcuOjfns
Part 5: PHP – http://www.youtube.com/watch?v=j-2Rz3nL2HU
great dude!!!!! nice work……..
Might be beneficial to add:
”
deny SELECT ON sys.sysobjects TO webdatabaselogon;
deny SELECT ON sys.objects TO webdatabaselogon;
deny SELECT ON sys.TABLES TO webdatabaselogon;
deny SELECT ON sys.views TO webdatabaselogon;
”
or something to that effect to protect the website from SQL injections
Or just sanitize user input and there’s no need for that ; )
Also sanitize $_POST data with functions like mysql_real_escape_string() to help prevent SQL injection
Here’s one of many helpful tutorials on SQL injection protection: http://www.wonderhowto.com/how-to-protect-your-php-website-from-sql-injection-hacks-0133507/
I’m having some trouble and I’m not sure why. I can type exactly the same thing as the video has and I end up with “ERROR 1064 <42000>: you have an error in your SQL syntax”‘ at line one” or whatever line it seemed to think the problem is on.
and then it advises me to check the manual. It says the problem is “near ‘
it always seems to be near a ; though I can’t understand why that would be wrong when it’s working for you.
So far the only thing that has worked is creating the database my_data though it doesn’t like the idea of tables and columns, can’t make a password or look at the existing databases.
I am a bit dyslexic, but I’ve checked and recheck my spelling and order of things at least 12 times to compensate as I inevitable have to do with all things I write, but I can’t find the problem. I really do hope I’m overlooking something.
Love, love, love this series.
thx it really helped me
i hvjst error in wordpress themes installof video podcasting
plzz suggest me how to fix it?
Great tutorials! I would love to see another one in this series on security.
Keep up the great work!
In the MySQL prompt I enter the pass but then my pc beebs?
That meens you have typed the wrong password :O
Great tutorials!!
I followed all 6 video tutorials. Now my question is: where do I go from here to learn more? Specially I’d like to learn more about CCS, PHP, and mySql. Thanks for posting all these videos. One more question, what tools do you use to make these videos? What mic? What video editor? What software? Again thanks.
What happened? I can’t see any of the posts.
awesome
I tried, did not work