组消息从mysql获取关联数组 - Group Messaging Fetch Associative Array from mysql

Group Messaging Fetch Associative Array from mysql

本文关键字：关联数组获取 mysql 消息 | 更新日期: 2023-09-27

My Group消息系统使用数组来控制数字和名称

$people = array(
    "+14031234567" => "Test Black Berry",
    "+14038999999" => "Test Android",
    "+14036519999" => "Test iPhone",
);

我尝试使用php从mysql-db-中获取这些信息

<?php
include("config.php");
$connect = new mysqli("$dbhost","$dbuser","$dbpass","$dbname")
or die (mysqli_error());
$people=$connect->query("SELECT phone, name FROM contacts");
        while($row=$people->fetch_array(MYSQLI_ASSOC)){
        echo 
        $row ['phone']." => ".$row['name'].","; 
        }
?>

这给了我的结果

   +14037777777 => Test Black Berry,
   +14038888888 => Test Android,
   +14039999999 => Test iPhone,

很近，但不是一直。我错过了什么。提前感谢的帮助

This the final code that works in my Message App 
<?php
include("../../lib/config.php");
$conn=mysqli_connect("$dbhost","$dbuser","$dbpass","$dbname")
or die (mysqli_error());
$query = "SELECT phone, name FROM grouplist";
$result = mysqli_query($conn, $query);
$people = array();
while ($row = mysqli_fetch_assoc($result)) {
    $people[$row['phone']] = $row['name'];
}   
?>