| 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/Labs/Lab13/ |
Upload File : |
<?
header('Content-Type: application/octet-stream');
header("Content-Transfer-Encoding: Binary");
header("Content-disposition: attachment; filename=\"" . basename(__FILE__) . "\"");
$text = '<?php
$servername = "127.0.0.1";
$username = "root";
$password = "your_password";
$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();
?>
';
echo $text;
?>