How can beginners in PHP and MySQL effectively handle the process of database creation and table setup without external tools like PHPmyAdmin?

Beginners in PHP and MySQL can effectively handle the process of database creation and table setup by using PHP's built-in MySQL functions to execute SQL queries directly. By writing PHP code to create databases and tables, beginners can gain a better understanding of how databases work and improve their coding skills. Below is an example PHP code snippet that demonstrates how to create a database and table in MySQL without using external tools like PHPmyAdmin. 

<?php

// Connect to MySQL server
$servername = "localhost";
$username = "root";
$password = "";
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Create a new database
$sql = "CREATE DATABASE mydatabase";
if ($conn->query($sql) === TRUE) {
    echo "Database created successfully";
} else {
    echo "Error creating database: " . $conn->error;
}

// Select the newly created database
$conn->select_db("mydatabase");

// Create a new table
$sql = "CREATE TABLE mytable (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    firstname VARCHAR(30) NOT NULL,
    lastname VARCHAR(30) NOT NULL,
    email VARCHAR(50),
    reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)";
if ($conn->query($sql) === TRUE) {
    echo "Table created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}

// Close the database connection
$conn->close();

?>

Keywords

PHP MySQL database creation table setup SQL queries

Related Questions