<?php

  $servername = "localhost";
  $username = "root";
  $password = "";
  $dbname = "php_api_database";
  $conn = mysqli_connect($servername,$username,$password,$dbname);

  if($conn) {
    echo 'Succesfully connected to the database' . '<br>';
  }
  else {
    die('Error.');
  }

  $user_url = 'http://jsonplaceholder.typicode.com/users';
  $user_json = file_get_contents($user_url);
  $user_array = json_decode($user_json, true);

  // $sqlTable = "CREATE TABLE users (
  // id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  // name VARCHAR(30) NOT NULL,
  // username VARCHAR(30) NOT NULL,
  // email VARCHAR(50) NOT NULL,
  // address VARCHAR(50) NOT NULL,
  // phone VARCHAR(50) NOT NULL
  // )";

  echo '<table id="table"> <tr> <th>Id</th> <th>Name</th> <th>Username</th> <th>Email</th> <th>Address</th> <th>Phone</th> </tr>';
  if(!empty($user_array)){
  foreach($user_array as $user){
    echo '<tr><td>' . $user['id'] . '</td>';
    echo '<td>' . $user['name'] . '</td>';
    echo '<td>' . $user['username'] . '</td>';
    echo '<td>' . $user['email'] . '</td>';
    echo '<td>' . $user['address']['street'] . ', ' . $user['address']['suite'] . ', ' . $user['address']['city'] . ', ' . $user['address']['zipcode'] . '</td>';
    echo '<td>' . $user['phone'] . '</td></tr>';

    $sql = "INSERT INTO users(name,username,email) VALUES ($user['name'];$user['username'];$user['email']);";

    // $sql = "INSERT INTO users ('name', 'username', 'email', 'address', 'phone')
    // VALUES (
    //   '".mysqli_real_escape_string($user['name']."',
    //   '".mysqli_real_escape_string($user['username']."',
    //   '".mysqli_real_escape_string($user['email']."',
    //   '".mysqli_real_escape_string($user['address']['street']."',
    //         '".mysqli_real_escape_string($user['address']['suite']."',
    //               '".mysqli_real_escape_string($user['address']['city']."',
    //                     '".mysqli_real_escape_string($user['address']['zipcode']."',
    //   '".mysqli_real_escape_string($user['phone']."'
    // )";

    // if (mysqli_query($conn, $sql)) {
    //     echo "New record created successfully";
    // } else {
    //     echo "Error: " . $sql . "<br>" . mysqli_error($conn);
    // }

    var_dump($sql);

  }}
  echo '</table>';

  if (mysqli_query($conn, $sqlTable)) {
      echo "Table users created successfully";
  } else {
      echo "Error creating table: " . mysqli_error($conn) . '<br>';
  }
  ?>