我遇到了一个问题。我有一个代码:
<?php
$mysqli = new mysqli('localhost', 'test', 'test123', 'testdb');
$sql = "
SELECT g.id as groupId, g.name as groupName, d.device_id
FROM librenms.devices as d
INNER JOIN librenms.device_groups as g
ON d.hostname LIKE CONCAT('%', mysql.SPLIT_STR(g.pattern, ''"', 2), '%')
WHERE g.pattern LIKE '_devices.hostname%'
ORDER BY g.id
";
$qid = $mysqli->query($qry);
if($qid->num_rows == 0){
die("no results from MySQL'n");
}else{
while($row = $qid->fetch_object()){ // each row
var_dump($row);
}
}
主要的是,这段代码在数据库中查找设备,这些设备与设备组具有相同的"字符串"。没关系。但是我如何用属于该组的设备分别打印所有组?或者,我如何使用"之间具有相同字符串的设备打印一个组。?有人能提出一些建议吗?
$qid = $mysqli->query($qry);
应为$qid = $mysqli->query($sql);