Connecting and Writing to MySQL with PHP

Connecting to MySQL with PHP

$server = "localhost"; $username = "username"; $password = "password"; $db = "dbname"; //connect $connect = new mysqli($server, $username, $password, $db); //Check Connection if ($connect->connect_error) { die("The connection failed: " . $connect->connect_error); }

Check if a table exists and create it if not

This checks for a table called scorecard_test and creates it if it doesn’t exist. The SQL parameters for the columns are:

An integer called ID that is the primary key and auto increments

A username that can’t be NULL

A column called counter that has a default value of 1 if there is nothing passed, and the length can’t be longer than one digit

A column that holds the current timestamp.

// SQL syntax $sql = "CREATE TABLE IF NOT EXISTS scorecard_test ( id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, username varchar(255) NOT NULL, counter int(1) NOT NULL DEFAULT 1, time TIMESTAMP )"; // Connecting, sending query, showing errors, and closing connection if ($connect->query($sql) === TRUE) { echo "Done!"; } else { echo "Error: " . $connect->error; } $connect->close();