Many people on the internet aren't familiar with how to make a decent website on the internet. In an effort to remedy that, this episode kicks off the first of a five part series explaining the different aspects of building a good looking, database driven website from scratch.
In the final part 6 of this series, we will look at the connecting our website to our MySQL database.
Here's a list of the other tutorials in the series:
karthik babu
February 25, 2012 at 8:22 am
great dude!!!!! nice work……..
JWP
February 25, 2012 at 7:13 pm
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
Kingdutch
February 25, 2012 at 8:03 pm
Or just sanitize user input and there’s no need for that ; )
S Walker
February 25, 2012 at 8:56 pm
Also sanitize $_POST data with functions like mysql_real_escape_string() to help prevent SQL injection
S Walker
February 25, 2012 at 8:59 pm
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/
Mary
February 27, 2012 at 1:39 am
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.
Wildbulll
February 27, 2012 at 2:31 pm
Love, love, love this series.
sebastian
February 27, 2012 at 3:21 pm
thx it really helped me
swapnil
February 28, 2012 at 8:01 am
i hvjst error in wordpress themes installof video podcasting
plzz suggest me how to fix it?
Kevin
March 1, 2012 at 7:37 pm
Great tutorials! I would love to see another one in this series on security.
Keep up the great work!
Robbe
March 16, 2012 at 7:07 pm
In the MySQL prompt I enter the pass but then my pc beebs?
Mehrshad
March 27, 2012 at 9:02 pm
That meens you have typed the wrong password :O
Mehrshad
March 27, 2012 at 9:01 pm
Great tutorials!! 😀
orestesdd
May 4, 2012 at 4:35 pm
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.
orestesdd
May 4, 2012 at 9:32 pm
What happened? I can’t see any of the posts.
nithin
June 23, 2012 at 3:14 am
awesome
12345
November 25, 2012 at 2:22 am
I tried, did not work