Example #1 mysql_connect() example<?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); ?> Example #2 mysql_connect() example using hostname:port syntax<?php // we connect to example.com and port 3307 $link = mysql_connect('example.com:3307', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link);// we connect to localhost at port 3307 $link = mysql_connect('127.0.0.1:3307', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); ?> Example #3 mysql_connect() example using ":/path/to/socket" syntax<?php // we connect to localhost and socket e.g. /tmp/mysql.sock//variant 1: ommit localhost $link = mysql_connect(':/tmp/mysql', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); // variant 2: with localhost $link = mysql_connect('localhost:/tmp/mysql.sock', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); ?>
<? $link = mysql_connect('MYSQLIP地址', 'MYSQL用户名', 'MYSQL密码'); if (!$link) { die('Could not connect: ' . mysql_error()); } mysql_select_db('数据库名字'); ?>
<?php /*$conn = mysql_connect("localhost", "root", "root") or die("数据库链接错误"); mysql_select_db("book", $conn) or die("数据库名错误"); mysql_query("set names 'GBK'");*/$host= "localhost"; $user="root"; $pass="root"; $db="book";$connection=mysql_connect($host,$user,$pass) or die("数据库链接错误");mysql_select_db($db) or die ("数据库名错误");?>这是我的程序用的。比较容易判断~
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
Example #2 mysql_connect() example using hostname:port syntax<?php
// we connect to example.com and port 3307
$link = mysql_connect('example.com:3307', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);// we connect to localhost at port 3307
$link = mysql_connect('127.0.0.1:3307', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
Example #3 mysql_connect() example using ":/path/to/socket" syntax<?php
// we connect to localhost and socket e.g. /tmp/mysql.sock//variant 1: ommit localhost
$link = mysql_connect(':/tmp/mysql', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
// variant 2: with localhost
$link = mysql_connect('localhost:/tmp/mysql.sock', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
$link = mysql_connect('MYSQLIP地址', 'MYSQL用户名', 'MYSQL密码');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('数据库名字');
?>
/*$conn = mysql_connect("localhost", "root", "root") or die("数据库链接错误");
mysql_select_db("book", $conn) or die("数据库名错误");
mysql_query("set names 'GBK'");*/$host= "localhost";
$user="root";
$pass="root";
$db="book";$connection=mysql_connect($host,$user,$pass) or die("数据库链接错误");mysql_select_db($db) or die ("数据库名错误");?>这是我的程序用的。比较容易判断~