php - PHP的语法while($ row = mysql_fetch_row ...？

我正在尝试将SMS发送给多个收件人。我正在尝试实现的代码如下：
我面临的问题是消息仅传递到表中的第一条记录。

需要帮助吗，我要怎么办？

$db = JFactory::getDbo();
$query = $db->getQuery(true);
$result = mysql_query("SELECT name,mobile FROM members");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
while($row = mysql_fetch_row($result)) {
$mobile=$row[1];
$name=$row[0];

$request = "";
$param['mobileno'] = "91". $mobile;
$param['message']  = "Dear $name (organisation name) wishes you a very very Happy Birthday";
$param['username'] = "username";
$param['password']  = "password";
$param['sendername'] = "sender";
foreach ($param as $key => $val ){$request .= $key . "=" . urlencode($val);
$request .= "&";}$request = substr( $request, 0, strlen( $request ) - 1 );
$url = "http://smsapi" . $request;
$ch = curl_init($url);curl_setopt($ch, CURLOPT_URL, $url );
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true );
$result = curl_exec($ch);
var_dump($result);exit;
curl_close( $ch );
}

最佳答案

您需要遵守Joomla编码标准。不要使用mysql_*函数，因为它们已被弃用并构成安全威胁。

$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('*')
->from('members');
$db->setQuery($query);
$rows = $db->loadObjectList();

while($rows){
    foreach ( $rows as $row ) {
        $mobile = $row->mobile;
        $name = $row->name;
    }

    //rest of code
}

关于php - PHP的语法while($ row = mysql_fetch_row ...？，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/18344393/