I'm getting error about Undefined Index on line 2 in this case:
if ($_POST['go'] == 'create') {
I know I can fix it with isset
, but I don't know how to do it inside another if statement.
Thank you
if (isset($_GET['createDB'])) {
if ($_POST['go'] == 'create') {
$handle = fopen($databaseSchema, "r");
$createTable_events = fread($handle, filesize($databaseSchema));
$user=$_POST['user'];
$pass=$_POST['pass'];
$clientHost= (isset($_POST['host']) ? $_POST['host'] : 'localhost');
try {
$dbh = null;
$dbh = new PDO("mysql:host=$DB_HOST", $user, $pass);
// create database
$dbh->exec("CREATE DATABASE `".$DATABASE."`;");
// Create waf-fle user
$dbh->exec("CREATE USER '".$DB_USER."'@'".$clientHost."' IDENTIFIED BY '".$DB_PASS."';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES ON `".$DATABASE."`.* TO '".$DB_USER."'@'".$clientHost."';
FLUSH PRIVILEGES;");
} catch (PDOException $e) {
die("DB ERROR: ". $e->getMessage());
}