What is the correct way to connect to a MySQL database?

Answer 1

Simple way to connect to mysql server using PHP..

$hostname = 'localhost';

$username = 'root';

$password = 'anypassword';

//Connecting to mysql server..

$connect = mysql_connect($hostname, $username, $password);

if(!$connect)

{

die('Connection Failed'. mysql_error());

}

//Selecting the database..

$select = mysql_select_db('any_database_name');

if(!$select)

{

die('Database not Selected'. mysql_error());

}

?>

Answer 2

You'll need to set Dreamweaver to "Split" or "Code" view, then add the following code somewhere near the top of your script (assuming MySQL):

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password') or die(mysql_error());

mysql_select_db('foo', $link) or die(mysql_error());

?>

You can then reference $link when running queries.

For more info visit the following pages:

• http://au2.php.net/manual/en/function.mysql-connect.php
• http://au2.php.net/manual/en/function.mysql-select-db.php
• http://au2.php.net/manual/en/function.mysql-query.php

Answer 3

to connect with server:

$connection1 = mysql_connect($server_ip, $user_name_of_database, $users_password);

to select the table

mysql_select_db($connection1,$name_of_database);

Answer 4

PHP has built in functions to access a MySQL database. A quick example would be as follows:

<?php

$c = mysql_connect("my_server", "my_username", "my_password");

$db = mysql_select_db("my_database", $c);

$q = mysql_query("SELECT * FROM bar");

while($row = mysql_fetch_assoc($q)){

print_r($row);

}

?>

In this example, you would be connecting to a server called "my_server" with the username "my_username" and the password "my_password". The database "my_database" is selected, and all records on the table "bar" are selected.

If the table "bar" has two fields in it, "id" and "foo", with three records, then the output might look like this:

Array

(

[0] => Array

(

[id] => 1

[foo] => John Jacob

)

[1] => Array

(

[id] => 2

[foo] => Jingleheimer

)

[2] => Array

(

[id] => 3

[foo] => Schmidt

)

)

Answer 5

PHP has many functions to allow users to work with MySQL database. To open a connection to a MySQL Server, one should follow three steps. First, one should connect MySQL itself by setting up variables such as username, password and server. The next step is to specify the database that one needs to open. Once it is completed, use the closing function in PHP to close the connection.

Answer 6

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

Then you can use mysqli to query the database with

$results = $mysqli->query("SELECT a FROM b");