php连接数据库新命令

<?php 
$link=mysqli_connect("localhost","user","pwd","dbname"); 
if(!$link) echo "FAILD!连接错误，用户名密码不对"; 
else echo "OK!可以连接"; 

?> 

--下面的老代码------

<?php 
$link=mysql_connect("localhost","root","123"); 
if(!$link) echo "FAILD!连接错误，用户名密码不对"; 
else echo "OK!可以连接"; 
?> 

会报错：Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in

-------建表------

--老的：mysql_query（"CREATE TEMPORARY TABLE 'TABLE'",$link）；

--建议用新的：mysqli_query（$link,"CREATE TEMPORARY TABLE 'TABLE'"）；