PHP Tutorial - 24 - Connecting to MySQL Database

[TheSchola3000]

1:35 > uuuuuhhuu lmaoooooo

[juandipg]

Hey Bucky, how come we can't watch it in high def? all I'm getting is 240p. BTW your tutorials are the greatest! I keep recommending your website to everybody I know!

[manasume]

what does this mean?

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a1949037'@'localhost' (using password: YES) in /home/a1949037/public_html/con­nect.php on line 3

[russellsolid]

The semi colon : was a mistake, taking it out should help

[russellsolid]

@alexkproductions1 use x10hosting. com its free and has mySQL

[alexkproductions1]

Is there a way to not use the password? Please help me, because I don't know if I can use Hostmonster yet. So, yah! Any help, please???

[thatbennyguy]

2:00 Comic Sans... *smh*

[sacredgeometry]

btw Its pronounced phonetically mysql=my-sequel

[MrNitt]

nevermind figured it out its not localhost 000webhost does something different

[MrNitt]

I used the username, and the correct password and it still gives me access denied. I don't know what's wrong. :/

I followed everything you said, and even quadruple checked it.

[MrChrisfranko]

good work dude. =]

[youdripblood]

is it true you learn all this at uni and get back home and make the tutorials??

[MaTtYiNgRaM1997]

Ur tutorials are extremely good, u teach like a pro and ur vids r always very accurate, thnx

[Computerwizgeek920]

this does not deserve 5 stars, they should make a new button... 6 stars!

[thesickbeat]

@Computerwizgeek920 A 5 star button does not even excist so it would be a new one already.

[Computerwizgeek920]

@thesickbeat That matters how...?

[Computerwizgeek920]

@thesickbeat So? thats how good it is make 5 star buttons then add a 6 star button im glad your smart enough to figure that out

[thesickbeat]

@Computerwizgeek920 this shit aint even worth 1 star anyways

[jani1337able]

you totally changed my mind about creating websites.tnx



[MovieMad007]

@maxrosecollins and more to the point you are a younger member of his audience and less educated in the world of manners - i'm 38 - an old age pensioner compared to the likes of you - maybe i have a disposition to bad language - i get told off for using bad language by everyone - friends and even on here - so just like the rest of this crazy godforsaken world i'm getting revenge by telling everyone else off! Sick of being Mr Niceguy - its got me nowhere - i cant even get my JSA which i am entitl

[MovieMad007]

@maxrosecollins i aint going to be drawn into a tit for tat argument god knows there is enough stupid arguments in the news of late - people can't live with each other and having to resort to bombing other countries i am so sick of it all! But back to this topic - in a previous vid he said "because you are all so f*****ng stupid i am going to have to show you" - thats rude in my book!

[oldtimegamelover]

How do I create a database that allows users to create accounts for my webpage?

[vibhuti183]

u didnt told that where we have to store this folder to connect...

[vibhuti183]

u didnt told that where we have to save this folder to connect with databse.......

[alisus17]

...I use zymic but i can't register in database

can anybody wanna makes me better

[alisus17]

...I use zymic but i can't register in database

[Drizien]

There appears to be an error in his code.

the doublepoint in the die thinghy should be within the quotation marks. 

[Drizien]

There appears to be an error in his code.

the doublepoint in the die thinghy should be within the quotation marks. liek this:

die('Not connected ::' . mysql_error());

[vickymoto1]

I tried the same code, But i am getting an error shown below:

Not Connected, Can't connect to MySQL server on 'localhost' (10061)

[vickymoto1]

good one

[godonholiday]

Is it better to use prepared statements to stop injections?

[Th3LastT3mplar]

Please help me beacause it says:

Parse error: syntax error, unexpected ':' in /home/a2292773/public_html/con­­nectionfile.php on line 5

I wrote everything like BUCKY .

[LordOfCa]

YouTube somehow gives an error when i try to post the comment syntax.

[slushfilmz]

how do you add comments in html?

[TyRATnt]

Also # works the same way as // does.

[frankenstein01]

I feel like I should be paying you for this

[MovieMad007]

@frankenstein01 -- don't encourage him that'll only make him even more "bigheaded" than he is already! he may be hot on this stuff - but his previous videos he assumed everybody was an idiot! Now i have just finished uni and graduated as a software engineer - even our lecturers were not as condascending as this guy! He may be hot and know his stuff - but there is more to communication than that! This vid went up in 2008 - if he were not so condascending his views would be " > than 69,000"!

[Nifterific]

@MovieMad007 - Just because he assumes we are new doesn't mean he thinks we are stupid. In fact, tutorials SHOULD be done as if the viewers are new. I'm sick of tutorials that assume you know how to do something.

TheNewBoston's tutorials are very informative, helpful, and not the least bit "condescending." 

[MovieMad007]

@Nifterific well in a previous video he said "you are all probably so stupid......da da da that you will fuck this up!!" thats rude in my book - maybe you Americans don't think so but across the pond here thats rude! i'm a software engineer and well aware of the things he shows - he's an amateur!

[Nifterific]

@MovieMad007 - Judging from his demeanor in 99% of the tutorials, as well as how he answers posted questions and offers to help with errors, if he said that then it was more than likely meant as a joke.

You can't take one statement out of everything he has said and say that it makes him "condescending".

And please don't take this as me trying to pick a fight with you, I have no desire to start a fight I was simply pointing it out. :-)

[Drizien]

@frankenstein01 you can donate on his site =p

[izzova24]

man can you help me with this shit error?

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'database'@'localhost' (using password: YES) in C:\xampp\htdocs\folder\zz.php on line 3

Not connected: Access denied for user 'database'@'localhost' (using password: YES)

i was using the correct password(root), but this is what i get

oh yes, this is the line 3 $dbc = mysql_connect('localhost','dat­abase','root');

[lordzzcabe]

@izzova24 i m getting the same error :S:S:S any body know how do we fix this ??

[izzova24]

@lordzzcabe i solved it, try changing the password.

[GeekWithKeyboard]

@izzova24 I know it's a bit late, but, you might want to make sure that the username database was created, and that it has permission to connect (Check the permissions). Another check is to use the xampp default of 'root' and no password.

[vancar6]

I was using 3schools to learn PHP, and i got up to Email Error and SQL tutorials and some of the code does work but does not have the rest of the code.

I love your tutorials.

[samiwistler]

Learning PHP is easy, following the changes is tough

[samiwistler]

PHP gurus

[formchoi2190]

ur vids r awesome!

[autom4]

lol'd at about 4:00 = underslash.. :P

[lance182]

lol teaching us how to save as a php in tut 24.. NICE

[mmg77]

Nice stuff Ii like it good job god bless you.

[thetechall]

that if statement is completely pointless, it will confuse newcomers to the language. IGNORE THE IF STATEMENT ITS POINTLESS

[pavankat]

HELP!

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/p/a/v/pavankat/h­tml/connectionfile.php on line 5

Not connected:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[artistdigital]

The correct syntax is

die('Could not connect: ' . mysql_error());

Just check out the time in which i figured it out!! Impressed?? :)

[artistdigital]

Parse error: syntax error, unexpected ':'

[coolcam262]

Few!! I'm actually trying to create a blog from someone elses tutorial but they don't explain things clearly enough so I came to you for the bit they kind of skipped and here it is!

[ImaniHopeFaith]

hi, my database connection script brought an error message.The error message says "localhost error:the requested URL could not be found" Please give me options.

[bulixus]

Hey Bucky

Can you train me with some of this stuff over webex.  I will pay per hour based on what we agree.

Let me know.

[ilazai]

Good job!

[xbugster]

i prefer adding this into functions file and put connect into function init_db()

[mangoprojects]

Thank you. - behind vfx

[jayjaygibbs]

Is it safe to store the password in plain text on a web server? Thanks

[jcdock]

@jayjaygibbs It is strongly recommended that you store it using md5

[sridir]

Thanks for the Videos Your Awesome!

[creepingdeath668]

hmm wen i test the php on my computer i get a crap tone of mysql errors but when i put it on my site i dont get the errors... anyone know why?

[HipHop4evahh]

Hmm, maybe you should try to reinstall xamp, or whatever you are using.

[marsngquik]

what the hell.... i didn't learn anything... you are using a different version.

[ShadowCry01]

What do you use?

[simonttz]

@ Dimitre : Well no Sh1t but how do you do that?

[simonttz]

of all the videos you have, Bucky why is this one's quaility compromised? Its not very easy to distinguish between colon and semicolon....

- Take it easy Hoss

[Dimitre74]

@simonttz

You need to watch in High def.

[eogwe1995]

@simonttz add the following code to your url :

&fmt=18

[edmark4321]

I enjoy learning with your tutorial..thank you so much

[SuperPathman]

I beg you please jsp tutorial ,because other jsp tutorial not nice .the way you teach and explain how a wonderfull

[SuperPathman]

you are great and programmer maker ,

[8ToMo8]

Thanks!

[ColouredBoxMobi]

Hey man awesome tutorial but you shouldn't zoom into the cursor the bluryness is awful i can't tell a colon from a semi colon or a comma from a period..

[artistdigital]

1:35 is sexy.... lolz!!

[themewz]

some mysql database panels are different but it has all the same things to be added

[wangtian1985]

excellent!!!!!!! if you are the professor in my school, I am sure i wil take your class!

[jsmith19810808]

Just some further advice you may want to look at netbeans and setup a connect to your localhost server.

The equivalent to Elcipse, both can do multiple environments for Java9 (JSE and EE, Tomcat), Ruby on rails, where you link a table for all the outputs and generate a PHP like code, its a more object orientated version.

What you want to get into doing is avoiding SQL Injection.

[nijtram22]

download notepad++

[HCOBrittany]

notepad wouldn't give me the option to save it as php, only text document and all files. is that a problem? if so what can i do?

[coolshoos]

just name the file and type .php at the end of the file name

[MarkHuron]

You must locate where you have saved you text documents, then right click them and click "rename". then rename the file's extension (.txt, .php, .html) to what you need, in this case .php

If you cannot change extensions then go to "Tools", "Folder Options", "View", and then uncheck "Hide extensions for known file types" and you should now be able to do that.

[W00tbeer1]

Select "All Files" and then save the document with a .php extensions (for example, test.php). It will make it PHP format.

[blu3bangag]

download notepad++ and watch his first video since its the most important!

[2oPTiK09]

Notepad++

[calarasyboy]

how the hell can i add the user to the database, cuz i can't find those tables in phpmyadmin !

[xedon2]

Yeah?

Lots of people know sql, php, css and javascript.

[xedon2]

Dunno, I am only 14 (almost 15) so I dont really know ANYTHING about college :P

[iF1z]

It mostly gets easier to learn other scripting languages when you've "mastered" one.

[lambda501]

hey ladiesman!! u rock dude.. your videos helped me a lot friend..please try to upload more useful ones if u can :)

[rofsjan]

5 stars, most definitely

[chaniwie]

great thank you!

[mectoonTube]

Thanks again, once more!

This is great and is helping me a lot!

[jalle555]

thx man i have a really cool server i need 10 gm's

[nextblain]

if it could have been possible, 10000 stars

[CoNiLa2]

ty 5 stars