問題描述

$con = mysql_connect("47.107.159.50:3306","root","root");

在阿里云主機(jī)使用phpstudy配置mysql數(shù)據(jù)庫后php代碼鏈接到數(shù)據(jù)庫，數(shù)據(jù)庫地址怎么填寫

問題解答

$host = '47.107.159.50';

$port = 3306;

$user = 'root';

$password = 'root';

$db_name = '表名';

if(!$con = mysqli_connect($host,$user,$password,$db_name,$port)){

echo "can not connect to databases";

}else{

if($db_name != ''){

//選擇數(shù)據(jù)庫

if(!mysqli_select_db($con,$db_name)){

echo "can not select database" . $db_name;

return false;

}

}

}

//發(fā)送語句

mysqli_query($con,"SET NAMES 'UTF8'");