PHP Tutorial - 26 - Testing the Database Connection

[SMR513]

Thanks for the great tutorials. I am hoping you upload the next vid for PHP tutorial mysql 27.

I would like to see the form in action, adding new users and logins and such.

Thanks man!

[ITSplit]

Hi, i hope you see this. I become this: "Warning: mysql_connect() [function.mysql-connect]: Access denied for user..." but I follow you step by step and I check all few times. I'm on 000webhost. Please help!

[ramchandrasingh1]

how to data base connectivity in php 

[bluedude34]

4:42

[GrettyBoyCustoms]

Warning: mysql_connect() [function.mysql-connect]: [2002] No connection could be made because the target machine actively refused it. (trying to connect via tcp://localhost:3306) in C:\xampp\htdocs\connectionfile­.php on line 3

Warning: mysql_connect() [function.mysql-connect]: No connection could be made because the target machine actively refused it. in C:\xampp\htdocs\connectionfile­.php on line 3

Not Connected :No connection could be made because the target machine actively refused it.

?????

[TheBoomshae]

@GrettyBoyCustoms I am getting that too. Did you ever find the problem?

[jwalter007]

I'm not getting the update. No errors, but no update. I put in some bad info for the open & select commands just to test & did get errors. So I know its talking to the correct database.

I checked the $query line for typos & had non. Any idea why its not updating?

[jwalter007]

@jwalter007 I got it working. I had to name my database game1. For some reason game would not show up as a database. So when i entered the update string I was using my database nae of game1 instead of table name of game.

Im all set now :-)

[carpenter2karli]

i dont know how to set database permission on 000webhost!

can sb help me?

[jwalter007]

@carpenter2karli Im looking for an answer to that as well.

[psntanner11man]

I DIDZ IT

[goperoful]

I've never been so happy seeing a blank screen. Thanks bucky!

[lesstalkmorerock99]

so, I am a noob, I was getting a similar warning that many of you are getting. Spent three hours obsessing about it...found out that when I was creating privaleges for "bucky" i didn't designate "localhost" and instead it was using "%" when i fixed this, the error went away. Hope this helps. Thanks BTW @thenewboston you've been a lot of help!

[MCXinito95]

Why is my acces denied?

[JKTCGMV13]

My programming teacher hates you. That's a good thing.

[katzblubird]

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

Could not connect: Access denied for user ' mobiafri_mercy'@'localhost' (using password: YES)

How do i solve this error?

[Macuspantricidad]

Thank you very much dude

[eternyman]

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

Free Web Hosting

Ni povezano:( :Access denied for user 'a9844771_user'@'localhost' (using password: YES) :(( whyyy

[eternyman]

@eternyman $dbc=mysql_connect('localhost'­,'a9844771_user','correctpassw­ord');

if (!$dbc){

 die('Ni povezano:( :' . mysql_error());

}

[krishnankuta]

well i hav a few doubts pls some1 help me in it....while trying the above i got this error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'username'@'localhost' (using password: YES) in D:\xampp\htdocs\connectionfile­.php on line 10

Not Connected:Access denied for user 'username'@'localhost' (using password: YES)

wht's the prob? & my 2nd question is it necessary to try this @domain hosted...cant it be done on localhost.is this y im getting error?

[mosherry1]

thanx alot

[lt99range]

If you're lazy like me, and just go tutorial to tutorial w\o leaving a comment, at least thumbs up the video, the "like" button. it doesn't require any typing :D, just do it while watching the video

[th2]

great video

[fakeface20]

Dear Bucky, when we'll have Tutorials For Oracle Database?

Also i have to say thanks beacuse i learned many things from Ur Tutorials!:)

Peace!

[hhytyhu]

thanks for these helpful tutorials. i want to connect my website with my database created in WAMP, I try different codes but it's giving me error (connection failed).. Can you please help me out . Thanks

[zombaxcorp]

can i use .php site to make register page for my private server games??

[zombaxcorp]

can i ask you dude....erm....can i use php site to make register page for my game private server??

[harshalpuri]

@thenewboston

for testing u may use XAMPP which works on localhost

[Computerwizgeek920]

YESSS NOTHINGNESS!!!!!

[Computerwizgeek920]

240p is defiantly HD

[sudoqwan]

You're better than my teacher LOL, thanks a lot. It helps me know how it works.

[frontierdragon]

worked !!!

yahooooooooo!

[22BPWilliams22]

I have never been so glad to see a blank screen. Great tutorials!

[12345678910secret]

I got this error: "Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /home/content/89/6942489/html/­Pages/login.php on line 77

Cannot connect to the serverLost connection to MySQL server at 'reading initial communication packet', system error: 111" so what do i do?

[Th3LastT3mplar]

didn't update the email. please help me.

[SnijdersMax]

@Th3LastT3mplar

you should put a couple of echo's in there between each step in the code, that way, you can see where it went wrong!

[joaoris]

@Th3LastT3mplar Same here, it was because i forget the .php is my adress bar.

[Kd4Master]

man, i just did the same you did! and when i opened the file (on my web) it didnt appear me in blank it appeared the same i wrote in the file...

[TyRATnt]

Thanks this helps alot. I'm going to have to buy a domain name for SQL to work lol.

[ninjakid09x]

I love whoever made PHP, they must've had the best idea.. "Oh lets make a function that stops the script called DIE... mwahhaha. " Yeah, thanks.. for the die thing.. I found a problem with my code, and using DIE I could easily find the problem. Thumbs up dude.

[pnaditya1]

even though i did exactly like u but i got this after uploading file to my site

Server Error

404 - File or directory not found.

The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.

[kakarotsv50]

Haha. It did not work. You typed 'hopethisowrks' :P LOL

[JustMeAndMyThoughts]

my database information doesnt changed. :(

[edwining]

OMG IT WORKED AAAAAAAAAAAAAAAAAAAAAAAAAAAAA

[paddythetinker]

ok go this message:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /websites/123reg/LinuxPackage2­2/sw/it/ch/switchsource.co.uk/­public_html/connectfile.php on line 3

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

[Rytis95]

The error is because you pasred Not connected:' here should be ': (backwards)

[krisnarocks]

here's my error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a4474867_admin'@'localhost' (using password: YES) in /home/a4474867/public_html/fil­e786474/connectionfile.php on line 3

not connected :Access denied for user 'a4474867_admin'@'localhost' (using password: YES)

pls help!

[MrRedhydra]

All I got from this video is that at 4:40 (pause it), it's clear that you go to youporn for your porn needs ^^.

[winPGRM]

@MrRedhydra LMAO. Fuck, that's so funny.

[mrscenario1992]

i want to have a tutorial about the php!

about the mysql of xammp!!!

[mohsin5kazmi]

Parse error: syntax error, unexpected T_VARIABLE in /home/a4894606/public_html/con­nectionfile.php on line 3

[gunner4192]

@mohsin5kazmi i got the samething?

[VictorianRider]

Has anyone found unlimited FTP ? I am on JustHost and cannot find it...

[ash26ism]

first we named the table as "game"..but we got a new table named "thenewbo_game"..and as u said that for future use we need to refer the latter...so why did we use the name "game" to update our table....

please explain the difference.....

[MrArj7]

i get Parse error: syntax error, unexpected ':' on line 6

[69hwoarang]

cant find unlimited FTP ...

[gunner4192]

@69hwoarang yea same here unlimited FTP doesnt exist for me....looked everywhere

[shatteredclown]

@gunner4192

unlimited FTP is usually named file manager on other hosts

[voltecrus]

Website voltecrus.comyr.com has been successfully installed on server.

Please delete file "default.php" from public_html folder and upload your website by using FTP or web based File Manager.

Below you can see your current files in public_html folder.

File

Size

Last Modified

default.phpdefault.php 8KB Oct 09 2010 11:26:41 PM

That's what i got. Moreover, my database deleted and tabs" browse" and "insert" are gone too. I tried to find this "public_host" but it isn't on my computer.

Thank you.

[islandboy1998]

@voltecrus dude, not on your computer! I can tell you use 000webhost like me. you must do to FILE MANAGER and then delete the file from public folder... then upload all the html files to the public folder

[islandboy1998]

ermmmm, im getting a

Parse error: syntax error, unexpected '?' in /home/a4417854/public_html/sig­nup/Connecton File.php on line 3

Any help on tht>

[Shrt5x4]

I created the database through my webhost. However, on my webhost I can't seem to find "Unlimited FTP". I do see something with somewhat of the same icon called "FTP Accounts," is that what I should be using to test the PHP code?

[jgad26]

Hey Bucky. Great tutorials. However, I keep getting these errors:

Parse error: syntax error, unexpected ':' in /home2/juanalum/public_html/co­nnectionfile.php on line 6



[2AWESOMETV]

i dont get this, I think ill give up.

[NiWdLES]

hi bucky! i got this error:

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

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

im only using xampp's localhost for testing the database... thanks in advance and your tutorials are great! keep it up! :)

[NiWdLES]

hi bucky! i got the same error but im only using the localhost instead of having a host ing website. you said earlier in the tutorial that i have to type down thenewbo_game(this is the name of your database) and i have mine as "game" only. and my username is "win". thanks in advance bucky and i really love your tutorials! :D

[kagsabua]

Thank's Bucky!

You are indeed a youtube master!

No argument about that :-)

[tecnitium87]

@salboaski:

Hey thank you very much for the reply.Your suggestion alongwith few others fixed my problem.

Thanx

[tommyiscool94]

my email never changed.... >.>

[MigueDog]

oh finnally i made it but still it says cant connect wich means that couldnt connect when i change password etc it displays error and then using password yes but when i try normally it just appears the message of die(cant conect)

[MigueDog]

this tutorial made no sense

[tchen10]

i cannot get it to run, the error says:

404 Error File Not Found

The page you are looking for might have been removed,

had it's name changed, or is temporarily unavailable. * If you typed in the URL, please check the spelling * You can try to click the Back button and try another link

[salboaski]

@tecnitium87

You need to make sure you are closing the connection to the database correctly by using the db.close() command at the end of all your pages.

If you use the database on all of your web pages, you may want to add this line into your footer file if you use a php include for your footer.

[WRbugs]

Is FTP Accounts the same as Unlimited FTP?

Please help!

[mangoprojects]

Thank you. - behind vfx

[wkareeba]

hi this wallace here just a quick Question is it just games you ar into, if not get bak to me as i need help on building user a/c's on a website. Thanx

[SuperTuohy]

hey when i try to transfer the file there is no folder called "public html".

[DazzTyler]

For people who sucessfully got it to run but not get it to update email: make sure your you write your table name not database name. In this case his database name is 'game', and table name is 'game'.

[billybob300c]

@DazzTyler

thx for the help man.

[ulices2020]

hey bucky, I did all you did in the last tutorial and this error message came out!! I hope you help me. thank you..Error

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?php

//opens connection to mysql server

$dbc = mysql_connect('localhost','l' at line 1

[illusionfall]

Do you have a totorial covering sessions or cookies?

[patca22]

hi! everything worked except the email did not change in the database. i dont know where to locate where you dragged the file and placed it in public html... pls help! thanks so much!:)

[patca22]

hi, i got no error message but my email didnt change in the database... i didnt know where to drag or what to click like what you did, the dragging of the file in public_html... pls help. thanks! btw, i learned a lot from ur tutorials..thanks! :)

[upl1nk2]

I got no errors, but the databse wont change... i'm accessing root no password

$dbc = mysql_connect('localhost','roo­t',''); and i followed everything as in your video. I'm using wamp. I'm pretty much lost here... coudl you please help ?

[fedenan]

this is the best php tutorial on the web. great job well explained. i learned a ton.

i like how you took a long time to explain everything carefully. 5 stars +

[fedenan]

this is the best php tutorial on the web. great job well explained. i learned a ton.

i like how you took a long time to explain everything carefully. 5 stars +

[gunii777]

I have a problem... I need help... Cuz In my program I cant add one thing with another. Like another group with other.. I really need help!!

[IPPSable]

Thanks a lot man, fantastic tutorials well done!

[saadnaeem11]

great work u r totalyy superb guy thanks alot for giving me these steps MAY GOD BLESS YOU :)

[ffizziz]

Thanx..i learnt something from You :)

[pepparn123]

Do i HAVE TO pay, or is it an other solution?

Please tell me how to make a free domain.

I would really appriciate it...

[wolfwolf1978]

I get a syntax error message

[saveme4141]

Do i need a hosting company? i have a Domain

only

[BackRaw]

worked like a chaaaaaaaaaarm man! I never understood this MySQL-dumbshit, but now it works :D thank you!!

[Tspider4]

there is a difference between understand it and let it work....But good for you...

[BackRaw]

lol... it didn't work because I didn't understand it =)

[Tspider4]

Ok, I am updating the php file now lets "hopethisowrks"

[jsmith19810808]

Actually the die command hes explained is actually wrong, that text string doesnt actually need to be put in.

But for debugging purposes when your making a connection it helps by using 2 when connecting to the server and then to the database itself.

Using 2 different strings for this helps to work out which connection isnt working, just an additional tip.

[jsmith19810808]

For example this would work when trying to put in the mysql_connect() function.

mysql_connect("localhost", "admin", "1admin") or die(mysql_error());

mysql_select_db("test") or die(mysql_error());

The above would work, just helps to work out which connections not working if you customise the error message and look at any log files, but in preset packages like *AMP software they usually dont do log files which I find annoying why I use my own server for that purpose.

[venkyvin]

The requested URL /connection.php does not exist. this was the message I got when I did type my url/connection.php

I opened up the unlimited FTP for the first time and then I dragged and dropped the connection.php file into the public html folder, later I typed in the browser....the message came up..please help me

[rhammett01]

You are a terrific teacher. I was completely confused about PHP and MYSQL until I came across your tutorials. Please keep up the good work.

[hpeyuan]

I am follow along with your tutorial (php 24-27 connecting database, select and update), I did everything accordingly only one thing different is that I am running on my own computer with MAMP and joomla.

I am trying to update email from php file but it is not working, so frastrated. Below are the code I type.

[hpeyuan]

I upload the file into htdocs/(websitename) which is the database I am trying to change, with that folder with many other joomla folder and file. after that I open that url, nothing show, but the database doesn't changed as well. PLEASE HELP!

[InFeRnq4]

man, you rule :D

[fcprimaria]

This video was so useful... tanks a lot. Couldn't connect using 'localhost', at first, because I use a free web host which generates specific names for the data base and db server. But I got it working, now :)

[QuinnC92]

I am using 000webhost . com for free hosting but when i create a database it automatically gives me a user and doesn't let me select privileges. Also, the user i created in the table we made, I can't edit that users privileges either.

This is probably why, when we run the test, I get the error on line 3 as well.

Any help?

[danny3man]

from what i know the free hosting doesn`t come with free database ...you either need to buy a domain and host ( or whatever) or you buy the privilege to have a database

hope that helps you ....just look around the site and see what they say about databases, emails or whatever you need

[lambda501]

dude u deserve to be a youtube partner :)

[2oPTiK09]

He is a youtube partner!

[mcwonderboy]

uhm actually i paid for hosting there. i mean they have everything that hostmonster has im just not sure how to do some things.

[yesitsmonkey]

Hi, I also use hostmonster server and I followed as same as your tutorial. However I got error it says "Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'echogmco_hyun'@'localhost' (using password: YES) in /home1/echogmco/public_html/co­nnectionfile.php on line 3

not connected :Access denied for user 'echogmco_hyun'@'localhost' (using password: YES)" Help!!! Thanks your tutorial

[Ifritmaster]

thank you very much lot for this special gift

i have learned all the basics that you teach throught of this tutorial. one more thing to how can i run website without registering in these hosts?

[sinthujan]

omg ur tooo goood

[burakicel96]

Your great tutorials changed my web life very thank you

[jordotech]

dear thenewboston-

Seriously, can't thank you enough for this. This was a lot of work for you and there are a lot of people benefiting from this. Great contribution to society, my friend. Your teaching style is great, we even got to see you become a nicer teacher as well. Don't stop! Much appreciated.

jordotech

[UnknownJoker21]

hope some more come out,

[MarinosGo]

WHEN IS THE NEXT ONE COMMING OUT ?:P

[sd11208]

very nice.

[SomaVIII]

Happy New Years man 2009 great tutorials I hope to see more on php soon.

[nextblain]

hope this works, and it worked!!! thanks bro! i thanks you from my deep heart! thnx!! u saved my life!!!!!!

[thermalz0mbie]

Hi will you be making any more videos on php I think these vids are great.

Are there only 26 of these?

[thermalz0mbie]

Hi where can I view the rest of these tutorials having some trouble finding them?

Thanks

[Strongbadunit2]

"btw can you do a tutorial where users input some text from a form such as username, password and email and once they submit the form, it creates a table in mysql with those fields? please help."

+1 =)

[bboyhavoc]

btw can you do a tutorial where users input some text from a form such as username, password and email and once they submit the form, it creates a table in mysql with those fields? please help.

[bboyhavoc]

Keep up the tutorials man. Best php tutorials ever.

[ptrakk]

ha the colon error was on the other line :D

[breaker00000000]

nice tutorials dude!!

keep up the good work ^^!

[CoNiLa2]

is this the last tutorial :'(

please i rated everything 5 stars and left nice comments

please dont do this to us please say u will continue this one day :'(

[dudong19]

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

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

[georgehennessy]

I can't belive I got this on the first try. Halleluja.

[cotoronto]

please update more cool stuff. keep up the good work

[beastlt12]

Uh... we need more tuts man! Don't be an idiot and screw it up. lol

thanks

[amri5987]

I got error in this line.

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

[thenewboston]

thats means ur password, username, or database information doesnt match up somewhere, check in both your source code and the database files

[qitaal15]

hy,

I don't know what i did wrong this is what I see

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

Free Web Hosting

not connected:Access denied for user 'a6055404'@'localhost' (using password: YES)

give me your email then I will send you the code

[thenewboston]

that's what i get when i type in something wrong. make sure the username and database are spelled EXACTLY the same. also make sure the user has privileges to access the database. its either one of those two things....

[qitaal15]

I try't anything but nothing :(

[thenewboston]

hmm thats odd... maybe your web host doesnt support php?

it says access denied, so the function ran properly so its not a coding issue. so it has to be an issue that either your passwords or usernames dont match up. that's the only possibility

[YouGotTeaBagged]

Great tut once again ;)

T'was very helpful - how soon till the next one comes out?

I hope its soon :P

[thenewboston]

probably by Wednesday, im working on them now. and make sure your watching these videos in high def, they make a world of difference!

[YouGotTeaBagged]

Wednesday? thats a whole 2 days away! :o

Lol ok then. And yea I am waching in high def - can barely read the screen when its on normal!