<?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "wporgapi";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
foreach ($call_api->plugins as $keys) {
    $sql = "INSERT INTO plugins (name, slug, author, author_profile, rating, downloads)
    VALUES ($keys->name, $keys->slug, $keys->author, $keys->author_profile, $keys->rating, $keys->downloaded)";
    mysqli_query($conn, $sql);
}
/** $sql = "INSERT INTO plugins (name, slug, author, author_profile, rating, downloads)
VALUES ('John', 'Doe', 'john@example.com', 'test', 'test', 'test')";

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

mysqli_close($conn);
?>