本文整理匯總了PHP中app\Comment::convertJson方法的典型用法代碼示例。如果您正苦於以下問題：PHP Comment::convertJson方法的具體用法？PHP Comment::convertJson怎麽用？PHP Comment::convertJson使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類app\Comment的用法示例。
在下文中一共展示了Comment::convertJson方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: getAllCommentsByBeverage
public static function getAllCommentsByBeverage($beverage_id)
{
$conn = mysqli_connect(getenv('DB_HOST'), getenv('DB_USERNAME'), getenv('DB_PASSWORD'), getenv('DB_DATABASE'));
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "SELECT beverage_comments.comment_id, beverage_comments.beverage_id, beverages.beverage_name, users.user_fname, beverage_comments.comment_descrip, beverage_comments.rating\n FROM beverage_comments\n LEFT JOIN users\n ON beverage_comments.user_id=users.user_id\n LEFT JOIN beverages\n ON beverage_comments.beverage_id=beverages.beverage_id\n WHERE beverage_comments.beverage_id=" . $beverage_id . ";";
$result = mysqli_query($conn, $sql);
$s = "[";
$numRows = mysqli_num_rows($result);
if ($numRows > 0) {
for ($i = 0; $i < $numRows; $i++) {
$row = mysqli_fetch_assoc($result);
$comment = new Comment($row["comment_id"], $row["beverage_id"], $row["beverage_name"], $row["user_fname"], $row["comment_descrip"], $row["rating"]);
$temp = $comment->convertJson();
$s .= $temp;
if ($i < $numRows - 1) {
$s .= ", ";
}
}
}
$s .= "]";
mysqli_close($conn);
return $s;
}