/PHP/Return multiple rows from mysqli php and encode JSON

Return multiple rows from mysqli php and encode JSON

<?php
    $dashboard_content_token = $_REQUEST["dashboard_content_token"];
    $token = "g4";

    require(cc_scripts/connect.php);

    $sql = "SELECT * FROM `dashboard_content`";
    $check = strcmp("$token", "$dashboard_content_token");
    $statement = mysqli_query($con, $sql);
    if (check) {
        $rows = mysqli_fetch_assoc($statement);
        if (!$rows) {
            echo "No results!";
        } else {

          do {
             $news_id = $rows['news_id'];
             $image_url = $rows['image_url'];
             $news_title = $rows['news_title'];
             $news_description = $rows['news_description'];
             $news_article = $rows['news_article'];

               $result['dashboard content: '][] = array('news_id' => $news_id, 'image_url' => $image_url, 'news_title' => $news_title, 'news_description' => $news_description, 'news_article' => $news_article); 


          } while ($rows = mysqli_fetch_assoc($statement));

        mysqli_free_result($statement);
        echo json_encode($result);
    }
}
?>

Source: stackoverflow.com

Similar codes

0 vote154 views1 answer
Laravel controller create command in a folder
PHP Laravel
0 vote138 views1 answer
Laravel eloquent set timestamps values upon seed
PHP
0 vote155 views1 answer
Wordpress display post categories
PHP Wordpress
27 votes226 views3 answers
Laravel what is migrations
PHP Laravel
0 vote155 views1 answer
Onbeforeunload com mysql php
PHP
0 vote109 views0 answer
PHP
1 vote156 views1 answer
Syntax error or access violation: 1072 Key column 'user_id' doesn't exist in table (SQL: alter table `groups` add constraint `groups_user_id_foreign` foreign key (`user_id`) references `users` (`id`))
PHP
10 votes159 views3 answers
Migrate to an existing table in laravel commad
PHP Laravel
1 vote146 views1 answer
/laravel-2020-07-27.log" could not be opened
PHP Laravel
0 vote138 views2 answers
How to make a json request in php
PHP