PHP to Mysql Problem

hi guys, please help me out on this issue.

i had this code to connect to mysql using php but there is no any message displayed.

nothing is displayed on the screen, whether the connection is successful or there is an error.

any ideas?

i can connect to mysql using command prompt without a problem, but through this code below nothing is displayed on the screen.

any help is greatly appreciated.

<html>
<body>


<?php

$link = mysql_connect('localhost', 'my_username', 'my_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);

?>

</body>
</html>

5

Contributors

7

Replies

4 Days

Discussion Span

9 Months Ago

Last Updated

8

Views

Question
Answered

cguan_77

Nearly a Posting Virtuoso

1,361 posts since Apr 2007

Reputation Points: 19

Solved Threads: 117

Skill Endorsements: 0

9 Months Ago

Show Comments

1

You didn't select the database you are going to use.. Do it like this..

<?php
$link=mysql_connect("localhost","my_username", "my_password");
if(!$link)
{
    die("Could not connect:" .mysql_error());
}

mysql_select_db("name_of_your_database"); //here goes the database selection
echo "Connected successfully!";
?>

Hope this helped.. :))))

xjshiya

Light Poster

28 posts since Aug 2012

Reputation Points: 8

Solved Threads: 2

Skill Endorsements: 0

9 Months Ago

0

Selecting the database is optional, not required. Anyway, check your error log, to see if perhaps the mysql extension is not installed, or perhaps some other configuration errors. The code the OP provided is correct.

pritaeas

Posting Prodigy

Moderator

9,534 posts since Jul 2006

Reputation Points: 1,194

Solved Threads: 1,494

Skill Endorsements: 98

9 Months Ago

Show Comments

1

check sql extension care fully so it is good habit.

ankitaray