I have been created the database CSCW and I am unsure of why I keep getting the error, 'No database selected' I am a beginner so any help is a bonus! Thank You!
<html>
<head>
<title>CS coursework</title>
<link rel="stylesheet" type="text/css" href="mystyle.css">
</head>
<body>
<h1>Online Stock Help.</h1>
<?php
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "CSCW";
// Create connection
$conn = mysqli_connect($servername, $username, $password);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
//create db tables
$sql = "CREATE TABLE users (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
businessName VARCHAR(30) NOT NULL,
name VARCHAR(30) NOT NULL,
email VARCHAR(50),
regDate TIMESTAMP
)
";
if (mysqli_query($conn, $sql)) {
echo "Table Created Successfully";
} else {
echo "Unsuccessful: " . mysqli_error($conn);
}
?>
</body>
</html>
The correct code is:
<html>
<head>
<title>CS coursework</title>
<link rel="stylesheet" type="text/css" href="mystyle.css">
</head>
<body>
<h1>Online Stock Help.</h1>
<?php
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "CSCW";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
//create db tables
$sql = "CREATE TABLE users (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
businessName VARCHAR(30) NOT NULL,
name VARCHAR(30) NOT NULL,
email VARCHAR(50),
regDate TIMESTAMP
)
";
if (mysqli_query($conn, $sql)) {
echo "Table Created Successfully";
} else {
echo "Unsuccessful: " . mysqli_error($conn);
}
?>
</body>
</html>
Your connection is missing the database name change the connection line to $conn = new mysqli($servername, $username, $password, $dbname);