DaniWeb Forum Index > Web Development > PHP

Connecting to database

Please support our PHP advertiser: $6.99 Domain Names at 1&1. Includes Free Privacy. Save Now!

Thread Solved

•

Join Date: May 2008

Posts: 60

Reputation: gangsta gama is an unknown quantity at this point

Solved Threads: 0

gangsta gama gangsta gama is offline

Offline

Junior Poster in Training

Connecting to database

Feb 18th, 2009

Hey whats up guys? I was using thenewboston tutorials on youtube and I am stuck. I was trying to connect to my database that i made.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
//opens connection to mysql server
$dbc=mysql_connect('localhost','kybo13','****');
if(!$dbc)
{
die('Not connected: ' . mysql_error()); 
}
 
//select database
$db_selected=mysql_select_db("kybo13_game",$dbc);
if(!$db_selsected)
{
die("Cant connect: " . mysql_error());
}
 
//test
$query="UPDATE game SET email='hopethisworks' WHERE username='kybo13'";
$result=mysql_query($query);
?>
<?php
//opens connection to mysql server
$dbc=mysql_connect('localhost','kybo13','****');
if(!$dbc)
{
die('Not connected: ' . mysql_error()); 
}

//select database
$db_selected=mysql_select_db("kybo13_game",$dbc);
if(!$db_selsected)
{
die("Cant connect: " . mysql_error());
}

//test
$query="UPDATE game SET email='hopethisworks' WHERE username='kybo13'";
$result=mysql_query($query);
?>

Thanks for your help guys.

•

Join Date: Sep 2008

Posts: 288

Reputation: chrishea is on a distinguished road

Solved Threads: 36

chrishea

Offline

Posting Whiz in Training

Re: Connecting to database

Feb 18th, 2009

Start by changing the line
if(!$db_selsected) -to-
if(!$db_selected)

Last edited by peter_budo; Feb 21st, 2009 at 3:57 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: May 2008

Posts: 60

Reputation: gangsta gama is an unknown quantity at this point

Solved Threads: 0

gangsta gama gangsta gama is offline

Offline

Junior Poster in Training

Re: Connecting to database

Feb 19th, 2009

Ok thank you for that mistake I missed. It still doesnt work though.

•

Join Date: Sep 2008

Posts: 288

Reputation: chrishea is on a distinguished road

Solved Threads: 36

chrishea

Offline

Posting Whiz in Training

Re: Connecting to database

Feb 19th, 2009

You have to be more explicit. "It still doesn't work" doesn't help much. I ran a modified version of your code as follows and it worked correctly:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
//opens connection to mysql server
$dbc=mysql_connect('localhost','root','');
if(!$dbc)
	{
	die('Not connected: ' . mysql_error());
	}
 
//select database
$db_selected = mysql_select_db("test",$dbc);
if(!$db_selected)
	{
		die("Cant connect: " . mysql_error());
	}
 
//test
$query="UPDATE test_table SET field1='hopethisworks' WHERE id='00001'";
$result=mysql_query($query);
?>
<?php
//opens connection to mysql server
$dbc=mysql_connect('localhost','root','');
if(!$dbc)
	{
	die('Not connected: ' . mysql_error());
	}

//select database
$db_selected = mysql_select_db("test",$dbc);
if(!$db_selected)
	{
		die("Cant connect: " . mysql_error());
	}

//test
$query="UPDATE test_table SET field1='hopethisworks' WHERE id='00001'";
$result=mysql_query($query);
?>