PHP Tutorial - 25 - Selecting a MySQL Database

[Danish13616]

He hasnt created the database in this video.

To create the database you do this

mysql_query("CREATE DATABASE nameofthedatabse " , variable in which u have stored connect info)

[PktMma]

I've been looking for decent tutorials for the last 2 weeks and now I'm finally learning something!

[MCXinito95]

Why is my access denied??

[gavin3191]

These tuts are the dogs bollocks

[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?

[PCGamesification]

I love this dude.

[aalamnaryab]

i have books table

and i displayed few fields of book in html table

i want to further link each row with a dynamic page fetching that book's details

like yahoo inbox page navigates to email body page when we click a specific subject in inbox page

[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());

[Drizien]

There appears to be an error in his code.

the doublepoint in the die thinghy of the connector should be within the quotation marks. like this:

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

[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 .

[MisutaGameBoi]

is there a more secure way of doing this? surely any noob can click "view source" and find u/p details.

let us know. thanks.

[monofono2006]

@MisutaGameBoi I was also thinking that way, but you cant look at the source code unless you hack into the database. If you check a source of a php fir it will look like an html file.

[trappingnoobs]

@MisutaGameBoi PHP is executed server-side so by the time they see it, it's already ran.

[derekmcgoldrick]

There is an error on line 5. The " :" needs to be removed or changed.

[Uwak2]

Can you also teach us how can we use the mysql at xammp, thanks Bucky, I will be waiting for your reply. I have been trying to connect it, but I dont know how to setup the username, password at phpmyadmin at xammp to set up for the code. When I try I got the error coded, not connected access denied for user ODBC at localhost using password no.

[sssubbu96]

these are really gr8 tutorials...

[mangoprojects]

I got the "Can't Connect to MySQL server on 'localhost' (10061). Can someone suggest a solution? Thank you. - behind vfx

[NWInvestor]

These tutorials of yours are great stuff for newbs like me, I really appreciate you taking the time to post them.

[81brett83]

Bucky your a legend mate !! I dont have a web hosting account I did it using the xampp Apache server, but I wrote to hopethisworks to the table. Your tutorials beet reading this stuuf by a mile, cheers mate !!

[everybody2008]

I did all the steps then I got this error message " Not Connected:Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)" .I have tried every thing

and made sure that my username ,password and database name is correct.

Can you help me?

[dmorigeau]

I have a question...what's the difference between "double quotes" and 'single quotes" I read an article that says PHP doesn't look for information inside of 'single quotes' only "double quotes". Just trying to clarify because I see that mysql_connect is in single and mysql_select_db is in double. Should they both be in double? Just trying to learn a few things. Thanks.

[akhumetsu]

thanks fore the tutorials helps a lot..........great tutorial ..

[mounayassir]

thank you for sharing php

[GTAmyths94]

The best tutorial i ever saw here, but the tutorial with the badest quality too

[blazin20s]

Just want to thank you sooo much for your help!

[d2cky]

I don't know if you went through this but it might be able to help others later on.

Instead of going out and purchasing webspace, it is possible to do this locally. If you open your mysql commandline client, you can manually input the database yourself.

Once that is completed when you get to the $dbc, the username is then "root", with the master password you inputted during installation.

Example:

$dbc = mysql_connect('localhost', 'root', 'password');

[Aoudhubillahi]

Impressive series of works. Bravo.

[skyheero]

you need to fix your code :: it case me some headache but here the right code for everyone trying to learn

if (!$dbc){

die("not connect".mysql_error());

}

//select databse

$db_selected = mysql_select_db("game",$dbc);

if(!db_selected)

{

die("cant connect:".mysql_error());

}

[tyler4you1990]

you need to put the first part of your website on the mysql_select_db like in his other tutorial you need to include the first part of your website underscore then the database name and it will work

[mangoprojects]

@skyheero This one works.

[Oamaok]

Okay, this is what I get:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user '********_********'@'localhost­' (using password: YES)

Could someone help?

[Oamaok]

usernames, passwords etc. are right.

[coolshoos]

same with me!

[rlharris9337]

I think you need "localhost" first, then username and password. Try that.

[ThaEmielNL]

change

$dbc = mysql_connect('localhost','use­rname','password');

with

$dbc = mysql_connect('localhost:3306'­,'username','password');

[Oamaok]

earlier code works now, but thanks. this may help others.

[hugovasto]

Man youre the best teacher ever

i barely speak english but with your method

it was very easy to learn some php thankyou very very much

[voteforgod]

youre a really good teacher. thank you.

[asimkhanalizai]

excellent work, thanks alot ,you saved my lots of time to read book to review,god bless

[lambda501]

look forward to more.please carry on the good work.

[Poskusin]

Love your vids, but be careful when you tell people to type exactly what you have. If they don't know any better, they are going to enter your typos (there's a few) and be really confused when it doesn't work.

[EnvyMyPower]

@Poskusin line 5... the : needs to be removed

[mectoonTube]

Excellent!

Thanks a lot.

[joesenter]

Loved all the tutorials. Have been watching and learning all day. Felt gipped, however, when starting from lessons 24 images became blurry from the hi-def requirement :( Furthermore, GoDaddy ( I know, I know) had different set up procedures ( you had to get their PHP script in order to connect). Never the less, you should set up a Pay Pal option own your site, I bet you could live off the many thankful views. Thanks again for the outstanding presentations. Look forward to more!

[nextblain]

i think add "&fmt=18" to the video url and it will become hi-def! XD

[SomaVIII]

&fmt=18 is high quality &fmt=22 is high def which not all videos can go high def

[nextblain]

oh! i dint know that! thnxz for telling XD

[amri5987]

thanks dude.. nice tutorials..

[amgharo]

hahahha

[turxxx]

Thanks for the PHP tutorials, dude. I appreciate it.

[YouGotTeaBagged]

Thanks man, yet another great tut :)

[thenewboston]

thanks im working on the next tutorials right now so check back in a few!

[YouGotTeaBagged]

Great! ;)

[nextblain]

dude, u deserve to be a youtube partner! you are not like other partners, you r good