function getConnection()
{
$con = getNewConnection();
mysqli_select_db($con, "bluecard");
return $con;
}
<?php
include_once 'dbconnection.php';
$con = getNewConnection();
// Create database
if ($con->query("CREATE DATABASE bluecard") === TRUE) {
echo "A new bluecard database has been created. <a href='../index.html'>Click here to start using bluecard.</a>";
} else {
echo "Error creating database:. <a href='../index.html'>Click here to start using bluecard.</a>" . mysqli_connect_error();
}
// Create tables
mysqli_select_db($con, "bluecard");
createTableCard($con);
createTableUsers($con);
createTableCardStatus($con);
createTableUserSession($con);
createTableFeatures($con);
createTableUserVotes($con);
createTableUserWatch($con);
$con->close();
function createTableCardStatus($con)
{
$query = 'CREATE TABLE cardstatus (id INT NOT NULL PRIMARY KEY ,
name VARCHAR( 255 ) NOT NULL) ENGINE = INNODB';
$con->query($query);
echo mysqli_connect_error();
$insertquery = "INSERT INTO cardstatus (ID,name)\r\n\t\t\t\t\t\t\t\t\t VALUES (10,'new')";
$con->query($insertquery);
$insertquery = "INSERT INTO cardstatus (ID,name)\r\n\t\t\t\t\t\t\t\t\t VALUES (20,'accepted')";
$con->query($insertquery);
$insertquery = "INSERT INTO cardstatus (ID,name)\r\n\t\t\t\t\t\t\t\t\t VALUES (30,'rejected')";
