wpapi1.php

<?php

error_reporting(E_ALL);

$db = new mysqli("localhost","wpdev2019","test2019","wpblog1");

if ($db->connect_errno) {
  echo "Failed to connect to MySQL: " . $db-> connect_error;
  exit();
}
else {
$myArray = array();
if ($result = $db->query("SELECT ID, post_title, post_name, guid, post_content, post_date from wpkk_posts")) {
    $tempArray = array();
    while ($row = $result->fetch_object()) {
        $tempArray = $row;
        array_push($myArray, $tempArray);
    }
    echo json_encode($myArray);
}

$result->close();
$mysqli->close(); 
}

?>