setup.php

PHP在线考试系统

<?php 

require("conn.php");
$conn=mysql_open();
$sql='CREATE TABLE `veling_drive_adminuser` (
`id` int(20) unsigned NOT NULL auto_increment,
`name`  varchar(100) default NULL,
`realname`  varchar(100) default NULL,
`password`  varchar(100) default NULL,  
 PRIMARY KEY  (`id`)
) TYPE=InnoDB;'; 
mysql_query($sql); 
echo "$sql <p/><p/>第一步："; 
echo "恭喜!数据库 已经成功建立！<hr>"; 

$ps=md5(veling);
$sql1="insert into veling_drive_adminuser(name,realname,password) values('veling','微零','$ps')";
mysql_query($sql1); 
echo "$sql1 <p/><p/>第二步："; 
echo "恭喜!默认<font color='red'>管理员：veling 密码：veling </font>顺利添加！<hr>"; 


$sql2='CREATE TABLE `veling_drive_exam` (
  `id` int(255) unsigned NOT NULL auto_increment,
  `question` varchar(255) default NULL,
  `pic` varchar(255) default NULL,
  `a` varchar(255) default NULL,
  `b` varchar(255) default NULL,
  `c` varchar(255) default NULL,
  `d` varchar(255) default NULL,
  `answer` varchar(255) default NULL,
  `easycount` int(255) unsigned NOT NULL default 0,
  `heardcount` int(255) unsigned NOT NULL default 0,
  `operater` varchar(20) default NULL,
  `addtime` datetime default NULL,
  PRIMARY KEY  (`id`)
) TYPE=InnoDB;'; 
mysql_query($sql2); 
echo "$sql2 <p/><p/>第三步："; 
echo "恭喜!选择题数据库成功建立！<hr>"; 

$sql3='CREATE TABLE `veling_drive_Judge` (
  `id` int(255) unsigned NOT NULL auto_increment,
  `question` varchar(255) default NULL,
  `pic` varchar(255) default NULL,
  `answer` int(10) default NULL,
  `easycount` int(20) unsigned NOT NULL default 0,
  `heardcount` int(20) unsigned NOT NULL default 0,
  `operater` varchar(20) default NULL,
  `addtime` datetime default NULL,
  PRIMARY KEY  (`id`)
) TYPE=InnoDB DEFAULT CHARSET=gbk' ; 

mysql_query($sql3); 
echo "$sql3 <p/><p/>第四步："; 
echo "恭喜!判断题数据库成功建立！<hr>"; 
mysql_close($conn); 
?>

<div style="text-align:center"><a href="admin/index.html">请登陆后台管理题库</a></div><br />
<br />
<br />
<div style="text-align:center"><a href="setup2.php" target="_blank">安装体验数据</a></div>