install.php

<?php

// Create Database

$con1=mysqli_connect("localhost","root","");
// Check connection
if (!$con1) {
    die("Keine Verbindung zu MySQL: " . mysqli_connect_error());
}


// Perform query
mysqli_query($con1,"Create Database Autovermietung");

mysqli_close($con1);


// Create Tables


$con2=mysqli_connect("localhost","root","", "Autovermietung");

if (!$con2) {
    die("Datenbank wurde nicht gefunden: " . mysqli_connect_error());
}

// create queries


$tableq[] = "CREATE TABLE Autos (
        auto_id INT(6) AUTO_INCREMENT PRIMARY KEY,
        km_stand INT(20),
        marke VARCHAR(30) NOT NULL,
        modell VARCHAR(30) NOT NULL
        )";

            $tableq[] = "CREATE TABLE Kunde (
            kunden_id INT(6) AUTO_INCREMENT PRIMARY KEY,
            vorname VARCHAR(30) NOT NULL,
            nachname VARCHAR(30) NOT NULL,
            date TIMESTAMP
            )";

                $tableq[] = "CREATE TABLE ausleihen (
                auto_id VARCHAR(30) NOT NULL,
                kunden_id VARCHAR(30) NOT NULL,
                datum TIMESTAMP
                )";

                // id INT(6) AUTO_INCREMENT PRIMARY KEY,
                // print_r ($tableq);
// perform queries

foreach ($tableq as $sql) {
    if (mysqli_query($con2, $sql)) {
        echo "<p>Tabelle wurde erstellt</p>";
    } else {
        echo "<p>Fehler beim Erstellen der Tabelle:</p>" . mysqli_error($con2);
    }
}

mysqli_close($con2);
?>