基于 SQL 查询不起作用的结果的电子邮件通知

这是我的PHP：

#!/cron.php
<?php
$dbconnect = new mysqli('localhost','root','root','serrano');
$query = "SELECT `app`,`email`,`accept` FROM `requests` WHERE `accept`=1";
$result = mysql_query($query);
if($result && $result->num_rows>=1) {
    $subject = "Your application has been accepted for review.";
    $message='Congratulations. Your application "';
    while($row=$result->fetch_assoc()) {
        $message.="{$row['name']}'"";
        $email="{$row['email']}";
    }
    $message.="has been accepted for review at redacted.";
    if(mail($email, $subject, $message)) {
      //mail successfully sent
    } else {
        echo "fail";
    }
  }
?>

据我所知，查询工作正常。它返回数据库中的相关行。我的 PHP 是怎么回事？

代码更新 1

这是更新的PHP，纠正了mysqli错误。但它仍然返回一个错误：

PHP 致命错误：在第 5 行对非对象调用成员函数 query（）

#!/cron.php
<?php
$dbconnect = new mysqli('localhost','root','root','serrano');
$result->query('SELECT `app`,`email`,`accept` FROM `requests` WHERE `accept`=1');
if($result && $result->num_rows>=1) {
$subject = "Your application has been accepted for review.";
$message='Congratulations. Your application "';
while($row=$result->fetch_assoc()) {
    $message.="{$row['name']}'"";
    $email="{$row['email']}";
}
$message.="has been accepted for review at redacted.";
if(mail($email, $subject, $message)) {
  //mail successfully sent
} else {
    echo "fail";
}
  }
?>

工作代码

好的，这是工作代码。只需对连接和运行查询的方式进行一些调整：

#!/cron.php
<?php

$link = mysqli_connect('localhost','root','root','serrano');
$result = mysqli_query($link, 'SELECT `app`,`email`,`accept` FROM `requests` WHERE  `accept`=1');
if($result->num_rows >= 1){
$subject = "Your application has been accepted for review.";
$message='Congratulations. Your application "';
while($row=$result->fetch_assoc()) {
    $message.="{$row['app']}'"";
    $email="{$row['email']}";
}
$message.="has been accepted for review at redacted.";
if(mail($email, $subject, $message)) {
  //mail successfully sent
} else {
    echo "fail";
}
 }
?>