我在8080端口上使用wamp localhost,它运行php页面很好,但现在我想连接mysql
<table width="200" border="1" dir="rtl">
<tr>
<td>Age</td>
<td>City</td>
<td>Lname</td>
<td>Fname</td>
<td>ID</td>
</tr>
<?php
mysql_connect("localhost","root","");
mysql_select_db("learnfiles");
$query="select * from users";
$a=mysql_query($query);
while($b=mysql_fetch_assoc($a))
{
echo "<tr>";
echo "<td>".$b["age"]."</td>";
echo "<td>".$b["city"]."</td>";
echo "<td>".$b["lname"]."</td>";
echo "<td>".$b["fname"]."</td>";
echo "<td>".$b["id"]."</td>";
echo "</tr>";
}
?>
但它有错误Deprecated:mysql_connect():mysql扩展已被弃用,将来将被删除:在第16行的C:''wamp''ww''pro''index.php中使用mysqli或PDO我将myadmin的端口地址更改为[http://localhost:8080/phpmyadmin]我该怎么解决?
使用mysqli
,因为mysql_connect已弃用
$db = new mysqli('localhost', 'user', 'pass', 'DB');
if($db->connect_errno > 0){
die('Unable to connect to database [' . $db->connect_error . ']');
}