PHP MySQL Tutorial: Connect to a MySQL Database -HD-

[PurpleEanLurver]

i did exactly like you showed, but i coudnt connect to mysql..can you help me?

[lionhart3001]

never mind i got it working, i needed to put a mysql dll file in c:\windows and then the success displayed, many thanks for the video

[walter50two]

Why do you use the @ sign? I wasn´t able to find it in the PHP documentation.

[bitmp44]

When I write this in, isnt it available for everyone to see? and like... that shouldn't happen right. If they just view source they can see all that info for mySQL database :P

[RiverCityGraphix]

@bitmp44 Nope. PHP and MySQL are hidden from the view source.

[bitmp44]

@RiverCityGraphix awesome thanks. So using javascript for any sort of form validation is a bad idea :P true? but php is safe, and thats why everyone uses it. ish. I've been reading about some exploits with the include() method .

[Josh7harington]

Can someone help ? I did this ive got the mysql file inside the folder and everything, i have checked many times, and the $db_name is correct as the actual sql db, but it still says "no database" ? and if i change the $db_host/username/pass it comes out with "Could not connect to mysql..." which means that it's working at that part ?

[TwistingFiction]

I followed all the instructions right up until the end. When I finally typed in localhost/mysql_connect I got an access forbidden page, and now even when I try to access localhost, I get an access forbidden page. It was working fine before I followed all of the instructions. Can anyone help?

[jpuma13]

once again, great!

[JurgisTamulis]

Also be sure to close connection with mysql_close();

[Shekkil1]

i get this error "Parse error: syntax error, unexpected '@' in C:\xampp\htdocs\mysql_connect.­php on line 10"  plzz help mee

[shindedeepakm]

thanks sir

[dekipet]

10 thumbs up. Great.

[pabloelpopstar]

I dont know why a create a php file with notepad and type all that stuff inside and nothing shows on the web page.

[kaysan83]

easy tutorial to follow. Thanks alot for it. 2 Thumps up.

[vanko1997]

on 4:29 when i put @mqsql_select_db it doesn't turn blue and when i test it it says "Parse error: syntax error, unexpected ')' in C:\xampp\htdocs\mysql_connect.­php on line 8" please help!

[glockenspiel9971]

thanks, this is very helpful for beginners like me.

[Vb2010TUTz]

Hey... i love you :D

[SebastiaanBol]

this one is good!! thanks.

[removeimmo]

great info !!! awesome,fast and tight.!!+++

[m0iRAWR]

thx dude

[0Alikan0]

Same, can't connect to DB, I have connected, but cant select DB

[jalautb]

i keep getting "Cannot connect to db!" pls help!

[TheLegend1245]

thanks. I think this'll help alot since I forget and my brain scrambles when the teacher says anything

[nvelickovic10]

I have a problem, the connection with username "root" and pass that I've set doesn't work, it only work if i put the pass to be empty. Also when the connection happens the database is not found. Any ideas?

[nvelickovic10]

@nvelickovic10 i solved the problem with password, but still I can't select DB...

[simpleme10100]

Good tutorial

[masoodkai]

Thanks DUDE, it helped me alot :-)

[12kittykitty1]

i have done this tutorial. but when i run this it shows "could not connect to mysql".. plz help me

[RealityFuzion]

For The Echo or *or die* does the colour become green or blue?

[RealityFuzion]

Ive done that but when i typed in Localhost it said that could not connect to mySQL help?

[RealityFuzion]

Yeh um the bit by when u say $db_host " ;

[workfornuts]

Are you in a hurry man or it's just too much caffeine?? =)

[RealityFuzion]

Yeh well ive done everything u said on Notepad and its not working and i saved it as

Mysql_connect.php

[RealityFuzion]

Could u do an tourtial on that please if u could?

[RealityFuzion]

i meant do u have to use dreamweaver?

[RiverCityGraphix]

@RealityFuzion Nope. You can use any html or php editor. You could even type it in NotePad and it would work.

[RealityFuzion]

Yeh um, my question do u have dreamweaver?

[ferguior]

I got a question! Where do you save your php script? Does it need to be located in any special folder so that Firefox can find it?

[ChristofTheDestroyer]

maybe I'm just dumb, but you create the database, then you kinda show how to connect to it, but you dont give a solid example of being able to go to a website and type in login information and have it create a file in your database that you can view from admin status.

[WorldWiredWeb]

nice one =)

[BritniPerot]

make $8+ a day in less then a month NO SKILLS /watch?v=BMPhsRN19Ms

[akocannie]

how come that when i try it takes too long to connect to mysql??

[harshalpuri]

@RiverCityGraphix

correction

$td_username = "root";

$td_pass = "";

in place of

$td_username = "root";

$td_pass = "test123";

in XAMPP

[irishfaithful1]

*connect

[irishfaithful1]

great video man. just one thing that was bothering me, isn't it easier just to string it? $dbc = mysqli_connet('localhost', 'root', 'text123', 'database') or die('Error connecting to MySQL server.');

[abhishekrai48]

great job....! bt i wd like to see more from u

[manzooroct5]

this is the best tutorial.......

thank you very much

[xnekromantikx]

thanks :)

[wms123123]

somehow i wont say successful cuz i cant connect to the database

[wms123123]

i got a error code scripts on number 8

[SingAdagioPrincess]

very good tutorial..better than my professors!

[Whisperingonthewind]

Thanks I have been looking around for how I could test this code to see if it was working, excellent.

[SmartestViking]

Awesome

[Jazukka]

You are good at teaching stuff. Thanks. Very good tutorials.

[sushant079]

thanks for the tutorial...it was very good! :)

[TheBusala7]

How do I set a password

How do I fix the relational table error

I am using a Sony Vaio SR with vista business OS. I have been having lots of trouble installing various software, xamp does not install ... using Wampserver.

Thank you for all your help greatly appreciated!!!

[TheBusala7]

1. I can’t connect to mssql. something to do with the configuration

2. No pword was set in mssql during setup, I just left it blank in cmd and pressed enter.

3. Phpmyadmin gives the following messages at the bottom of the page

a. The additional features for working with linked tables have been deactivated

b. Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account ... fix this security hole by setting a password for user 'root

[phillmadz]

I just get a blank screen in localhost/mysql_php :(

No syntax errors but Dreamweaver is asking me to setup site definition.

Do I need to do this?

XAMPP and phpmyadmin is working fine. Database is setup along with table.

Not sure what to do.

[garrymack]

fantastic tutorial. I was just doing another series on php and web programming. The time came to do databases and the person making the video said the words.. "Now go to your webhosting account where we will make our database." I just about choked on my breakfast! thanks so much. much easier/cheaper this way.

[happygameshow]

how can you do this using an input form?

[kartwag]

Hi good tutorial, But ??? Parse error: syntax error, unexpected '=' in C:\xampp\htdocs\mysql_connect.­php on line 3 <?php Sdb_host = "localhost"; Sdb_usrname ="root"; Sdb_pass = "XXXXXXXXXXXX"; Sdb_name = "test_database"; @mysql_connect("Sdb_host","Sdb­_usrname","Sdb_pass") or die ("could not connect to MySql"); @mysql_select_db("Sdb_name") or die ("No database"); echo"Succsessful Connection";

[GAiXzHeLL]

see here bsitportal.webs.com

i'm having a problem with this...

can you solve it??

[pchaff]

Excellent. Thank you from a newbie

[faressoft]

it is a good tut

[ManWithaPlan1996]

great tutorial thanks (like)

[ejl123123]

Thanks 

[salimalim]

Really helpfull..thx

[7jerryv7]

I have watched three of these and one thing that might help - number the videos so people can start with XAMP, create database, and then connect. Just an idea. Great video.

[palembassy]

very helpful i realy like your vids thnx alot 4 helping ... waiting for more ....