我正试图从从db创建的url数组中获取一个url,但我的数组似乎是空的。我应该如何从数据库表的url列中获取任何url。
$dbc = mysqli_connect($servername, $username, $pass, $dbname) or die('connect failed');
$r= mysqli_query ($dbc, "select url from urllist ")or die('query failed');
$url = array();
while($set = mysql_fetch_array($r)){
$url[] = $set['url'];
}
echo $url[5];
使用var_dump($url);
检查变量内容。您可能正在尝试访问一个不存在的索引!
尝试以下代码:
OO样式
$con = new mysqli($servername, $username, $pass, $dbname);
$res = $con->query('SELECT url FROM urllist');
$url = [];
while($row = $res->fetch_array())
{
$url[] = $row['url'];
}
var_dump($url);
程序风格
$con = mysqli_connect($servername, $username, $pass, $dbname);
$res = mysqli_query($con, 'SELECT url FROM urllist');
$url = mysqli_fetch_array($res, MYSQLI_ASSOC);
var_dump($url);
希望有帮助!