Solved

Connect to mysql server

Posted on 2004-08-26
3
199 Views
Last Modified: 2008-03-06
Hi-

I am very, very new to php, and had a couple questions.

I want to connect to a mysql server, so I do this using mysql_connect and this handy function I found online

<?php
$user = "user";
$pass = "pass";
$db = "db";
$link = mysql_connect( "localhost", $user, $pass );
if ( ! $link )
die( "Couldn't connect to MySQL" );
print "Successfully connected to server<P>";
mysql_select_db( $db )
or die ( "Couldn't open $db: ".mysql_error() );
print "Successfully selected database \"$db\"<P>";
mysql_close( $link );
?>

Now it doesn't work right away, I would like to know how to point to the server, I don't believe it is localhost, do I just ask my server admin, or is there some secret?
0
Comment
Question by:Eduski
  • 2
3 Comments
 
LVL 32

Accepted Solution

by:
ldbkutty earned 75 total points
ID: 11907905
mysql_connect() establishes a connection to a MySQL server.
if your MySQL server is not in your localhost, just replace 'localhost' in your code with the corresponding server address.

If you got any errors, let us know.
0
 
LVL 2

Assisted Solution

by:Rajkumar_G
Rajkumar_G earned 50 total points
ID: 11911645
<?php
/*************************************************************/
// FileName : DBLib.php
/*************************************************************/

/* Configuration parameters for DB connectivity*/
$db_name = '';  //give your database name which you want to connect
$db_user = 'root';
$db_pass = '';  
$db_host = 'localhost';  //host is localhost only .If  you have apache in your system.
/*************************************************************/

global $db_handle;

/* This is where i open the floodgates to the DB */

if(!initialize($db_host,$db_user,$db_pass,$db_name))
{
        die('The database cannot be opened - Please check the configurations');
}
else
 {
   echo "database initialised";
 }

//purpose : to open the connection to database

function initialize($db_host,$db_user,$db_pass,$db_name)
{
        global $db_handle;
        if(!($db_handle = mysql_pconnect($db_host,$db_user,$db_pass)))
        {
                return false;
        }
        else
        {
                if(!mysql_select_db($db_name,$db_handle))
                {
                        return false;
                }
        }
        return true;
}

?>

 This function is used to connect to  Mysql databse and open database.
You can create a this file with the given filename and caninclude in any of your files where u need to connect this particular database in mysql.

0
 
LVL 2

Expert Comment

by:Rajkumar_G
ID: 11911652
Mysql database should reside in your system if you want to use host as localhost.
Or else give the corresponding server address in host name.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now