fclose($fp); mysql_connect($db_host, $db_user, $db_pass); if (mysql_query("create database {$db_name}")) { if (mysql_select_db($db_name)) { $q = "CREATE TABLE IF NOT EXISTS `accounts` (\n\t\t\t\t\t\t\t\t\t\t `fname` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `uname` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `passwd` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `gen` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `dob` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `edu` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `add` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `email` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `pno` varchar(12) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `sq` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `ans` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`uname`)\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1"; $q1 = mysql_query($q) or die(goToDie()); $q = "CREATE TABLE IF NOT EXISTS `exams` (\n\t\t\t\t\t\t\t\t\t\t `id` varchar(30) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `name` text NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `type` varchar(20) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `date` date NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `no_questions` int(11) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `duration` varchar(10) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `pass` text NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `inv_pass` text NOT NULL,\n\t\t\t\t\t\t\t\t\t\t `paper_status` varchar(50) NOT NULL DEFAULT 'NOT PREPARED',\n\t\t\t\t\t\t\t\t\t\t `results` varchar(30) NOT NULL DEFAULT 'NOT GENARATED',\n\t\t\t\t\t\t\t\t\t\t `key_status` varchar(30) NOT NULL DEFAULT 'NOT UPLOADED',\n\t\t\t\t\t\t\t\t\t\t `exam_active` varchar(30) NOT NULL DEFAULT 'NO',\n\t\t\t\t\t\t\t\t\t\t `reg` varchar(30) NOT NULL DEFAULT 'NOT OPEND',\n\t\t\t\t\t\t\t\t\t\t `ngm` varchar(10) NOT NULL,\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1"; $q1 = mysql_query($q) or die(goToDie()); $q = "insert into accounts values('{$c_name}', '*****@*****.**', '{$c_pass}', '', '', '', '', '*****@*****.**', '', '', '')"; mysql_query($q); if (mysql_affected_rows() > 0) { ?> <script type="text/javascript"> window.location="del.php"; </script> <?php } else { die(goToDie()); } } else { die(mysql_error()); } } else { die(mysql_error()); } } function goToDie() { echo mysql_error(); $q = mysql_query("drop DATABASE {$db_name}") or die(mysql_error()); }
$q1 = mysql_query($q) or die(mysql_error() . "<br> Try to choose different Exam ID"); if ($q1) { if (mysql_select_db("{$e_id}")) { $q = "CREATE TABLE IF NOT EXISTS `questions` (\n\t\t\t\t\t `qid` int(11) NOT NULL,\n\t\t\t\t\t `sid` int(11) DEFAULT NULL,\n\t\t\t\t\t `q` text,\n\t\t\t\t\t `nop` int(11) DEFAULT NULL,\n\t\t\t\t\t `ans` text,\n\t\t\t\t\t `a` text,\n\t\t\t\t\t `b` text,\n\t\t\t\t\t `c` text,\n\t\t\t\t\t `d` text,\n\t\t\t\t\t `e` text,\n\t\t\t\t\t `f` text,\n\t\t\t\t\t `g` text,\n\t\t\t\t\t `h` text,\n\t\t\t\t\t PRIMARY KEY (`qid`)\n\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8"; $q1 = mysql_query($q) or die(goToDie()); $q1 = "CREATE TABLE IF NOT EXISTS `time` (\n\t\t\t\t\t `min` int(11) NOT NULL,\n\t\t\t\t\t `sec` int(11) NOT NULL,\n\t\t\t\t\t `id` varchar(50) NOT NULL,\n\t\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1"; mysql_query($q1) or die(goToDie()); if ($e_type == "SR") { $q1 = "CREATE TABLE IF NOT EXISTS `exam` (\n\t\t\t\t\t\t `id` varchar(50) NOT NULL,\n\t\t\t\t\t\t `sec` int(11) NOT NULL,\n\t\t\t\t\t\t `q` int(11) NOT NULL,\n\t\t\t\t\t\t `ans` text NOT NULL,\n\t\t\t\t\t\t `mark` varchar(11) NOT NULL\n\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1"; mysql_query($q1) or die(goToDie()); } else { $q1 = "CREATE TABLE IF NOT EXISTS `exam` (\n\t\t\t\t\t\t `id` varchar(50) NOT NULL,\n\t\t\t\t\t\t `sec` int(11) NOT NULL,\n\t\t\t\t\t\t `q` int(11) NOT NULL,\n\t\t\t\t\t\t `ans` text NOT NULL\n\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1"; mysql_query($q1) or die(goToDie()); } $q = "CREATE TABLE IF NOT EXISTS `results` (\n\t\t\t\t\t `id` varchar(50) NOT NULL,\n\t\t\t\t\t `marks` text NOT NULL,\n\t\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1"; $q1 = mysql_query($q) or die(goToDie()); if (is_dir("../../Exams/") && mkdir("../../Exams/" . $e_id, 0777, TRUE)) { mysql_select_db("aoes"); $q = "insert into exams values('{$e_id}', '{$e_name}', '{$e_type}', NOW(), {$no_q}, '{$e_duration}','{$e_pass}', '{$e_inv}', default, default, default, default, default, '{$e_ngm}')"; if ($e_type == "SR") { $q = "insert into exams values('{$e_id}', '{$e_name}', '{$e_type}', NOW(), {$no_q}, '{$e_duration}','{$e_pass}', '{$e_inv}', default, 'SPOT RESULTS', default, default, default, '{$e_ngm}')"; } $q1 = mysql_query($q); if ($q1) { echo "success"; } else { echo mysql_error(); $q = mysql_query("drop DATABASE {$e_id}"); } } else { echo "Error: Unable to create {$e_id} folder make sure 'es-1' directory writable!";