What are some common tools or methods used by beginners to manage database changes in PHP, such as phpMyAdmin?

When managing database changes in PHP, beginners often use tools like phpMyAdmin to visually interact with the database. However, for more controlled and automated database changes, beginners can utilize PHP scripts with SQL queries to make changes to the database schema or data. 

// Example of using PHP script with SQL queries to manage database changes

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

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

// Example SQL query to create a new table
$sql = "CREATE TABLE users (
    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 connection
$conn->close();

Keywords

phpMyAdmin database changes beginners tools methods

Related Questions