[MySqli to JSON] Convert MySqli Database to JSON format by PHP (PDO)

mysqliPDOtoJSON.php

<?php
  $database_name          = "your_database_name"; //database name
  $database_username      = "your_database_username"; // database username
  $database_user_password = "your_database_user_password"; //database user password

  $table_name = "your_table_name"; // your table name

  try {
      $db = new PDO('mysql:host=localhost;dbname=' . $database_name . ';charset=utf8', $database_username, $database_user_password);
      //echo "Connected";
  }
  catch (PDOException $e) {
      //print "Error!: " . $e->getMessage() . "<br/>";
      echo "Not Connected";
      die();
  }

  $query = $db->prepare("SELECT * FROM " . $table_name . " ;");
  $query->execute();

  if ($query->rowCount() > 0) {
      $data = $query->fetchAll(PDO::FETCH_ASSOC);

      echo json_encode($data);
  } else {
      $json['success'] = 0;
      $json['message'] = 'No Data found';
      $json['myintro'] = '';

      echo json_encode($json);
  }
?>