| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/CST1146/Resources/Examples/Week/14/ |
Upload File : |
<?php
$servername = "127.0.0.1";
$username = "root";
$password = "bogus";
$dbname = "mydb";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// sql to drop table
$sql = "
DROP TABLE IF EXISTS `MyGuests`
";
if ($conn->query($sql) === TRUE) {
echo "Table MyGuests dropped<br>";
} else {
echo "Error dropping table: " . $conn->error;
}
// sql to create table
$sql = "
CREATE TABLE `myguests` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(16) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`firstname` varchar(30) NOT NULL,
`lastname` varchar(30) NOT NULL,
`email` varchar(50) DEFAULT NULL,
`addedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `username_UNIQUE` (`username`)
)
";
if ($conn->query($sql) === TRUE) {
echo "Table MyGuests created successfully<br>";
} else {
echo "Error creating table: " . $conn->error;
}
$sql = "
INSERT INTO `myguests`
(username, firstname, lastname, email)
VALUES ('AvramHinton', 'Avram', 'Hinton', 'Avram.Hinton@go.ridgewater.edu'),
('HayesGibson', 'Hayes', 'Gibson', 'Hayes.Gibson@go.ridgewater.edu'),
('KristenAcosta', 'Kristen', 'Acosta', 'Kristen.Acosta@go.ridgewater.edu'),
('ColetteGibson', 'Colette', 'Gibson', 'Colette.Gibson@go.ridgewater.edu'),
('KyleePugh', 'Kylee', 'Pugh', 'Kylee.Pugh@go.ridgewater.edu'),
('NissimMoreno', 'Nissim', 'Moreno', 'Nissim.Moreno@go.ridgewater.edu'),
('LaelAbbott', 'Lael', 'Abbott', 'Lael.Abbott@go.ridgewater.edu'),
('EthanGomez', 'Ethan', 'Gomez', 'Ethan.Gomez@go.ridgewater.edu'),
('JenaSosa', 'Jena', 'Sosa', 'Jena.Sosa@go.ridgewater.edu'),
('JohnSmith', 'John', 'Smith', 'John.Smith@go.ridgewater.edu')
";
if (mysqli_query($conn, $sql)) {
echo "Ten new records created successfully<br>";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
$conn->close();
?>