| Server IP : 182.53.201.61 / Your IP : 216.73.217.175 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/reportservice/3/ |
Upload File : |
<html>
<head>
<title>ติดตั้งฐานข้อมูลโปรแกรมจัดรถ </title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
</head>
<body><center>Install Car</center><br>
<p>
<?php
include("dbconfig.php");
$sql="drop database if exists $__db__;";
$result = mysql_query($sql) ;
echo "<br>";
echo "waiting will creat database $__db__" ;
$sql = "CREATE DATABASE $__db__ ; ";
$result = mysql_query($sql) or die(mysql_error()) ;
$sql = "USE $__db__ ;";
$result = mysql_query($sql);
echo "<br>waiting will creat table car" ;
$sql = "CREATE TABLE car(
regist varchar(7) NOT NULL ,
type varchar(20) default NULL,
status varchar(1) default NULL,
PRIMARY KEY (regist));";
$result = mysql_query($sql) or die(mysql_error());
echo "<br> creat table car suscess" ;
$sql ="INSERT INTO car (regist,type,status) VALUES ('นค123','1','1')";
$result = mysql_query($sql) or die(mysql_error());
echo "<br>waiting will creat table audit" ;
$sql = "CREATE TABLE audit(
audit_id varchar(5) NOT NULL ,
t1 varchar(1) default NULL,
t2 varchar(1) default NULL,
t3 varchar(1) default NULL,
t4 varchar(1) default NULL,
t5 varchar(1) default NULL,
t6 varchar(1) default NULL,
date date default NULL,
audit_name varchar(30) default NULL,
PRIMARY KEY (audit_id));";
$result = mysql_query($sql) or die(mysql_error());
echo "<br> creat table audit suscess" ;
echo "<br> waiting will creat table tran" ;
$sql = "CREATE TABLE tran (
no int(5) NOT NULL auto_increment,
car_id varchar(6) default '0',
driver varchar(5) default NULL,
comment varchar(100) default NULL,
audit_id varchar(5) default NULL,
target varchar(100) default NULL,
user_id varchar(5) default NULL,
person int(11) default NULL,
u1 varchar(30) default NULL,
u2 varchar(30) default NULL,
u3 varchar(30) default NULL,
u4 varchar(30) default NULL,
u5 varchar(30) default NULL,
approv varchar(30) default '0',
reason varchar(100) default NULL,
date date default NULL,
date1 date default NULL,
time1 varchar(5) default NULL,
date2 date default NULL,
time2 varchar(5) default NULL,
car_start int(11) default '0',
car_end int(11) default '0',
boss varchar(5) default NULL,
chk char(2) default 'ok',
PRIMARY KEY (no)
);";
//TYPE=MyISAM;
$result = mysql_query($sql) or die(mysql_error());
echo "<br> waiting will creat table pm" ;
$sql = "CREATE TABLE pm (
car_id varchar(6) default not NULL,
pm_id varchar(4) default NULL,
date date(10) default NULL,
mile_pm int(11) default NULL,
user_id varchar(5) default NULL,
price float(7.2) default NULL
);";
$result = mysql_query($sql) or die(mysql_error());
echo "<br> creat table pm success" ;
echo "<br> waiting will creat table pmlist" ;
$sql = "CREATE TABLE pmlist (
item_id varchar(4) default not NULL,
item_name varchar(50) default NULL,
PRIMARY KEY (item_id)
);";
$result = mysql_query($sql) or die(mysql_error());
echo "<br> creat table pmlist success" ;
echo "<br> insert into pmlist " ;
$sql ="INSERT INTO pmlist (item_id,item_name) VALUES ('0001','เปลี่ยนน้ำมันเครื่อง')";
$result = mysql_query($sql) or die(mysql_error());
$sql="drop database if exists $__dbwp__ ;";
$result = mysql_query($sql) ;
echo "<br>waiting will creat database $__dbwp__" ;
$sql = "CREATE DATABASE $__dbwp__ ; ";
$result = mysql_query($sql) ;
$sql = "USE $__dbwp__ ;";
$result = mysql_query($sql);
echo "<br> creat database $__dbwp__ sucess" ;
echo "<br>waiting will creat table position" ;
$sql = "CREATE TABLE position(
position varchar(30) NOT NULL ,
);";
$result = mysql_query($sql) or die(mysql_error());
echo "<br> creat table position suscess" ;
$sql ="INSERT INTO position VALUES ('นายแพทย์')";
$result = mysql_query($sql) or die(mysql_error());
$sql ="INSERT INTO position VALUES ('เภสัชกร')";
$result = mysql_query($sql) or die(mysql_error());
$sql ="INSERT INTO position VALUES ('ทันตแพทย์')";
$result = mysql_query($sql) or die(mysql_error());
$sql ="INSERT INTO position VALUES ('หัวหน้าฝ่ายบริหารงานทั่วไป')";
$result = mysql_query($sql) or die(mysql_error());
$sql ="INSERT INTO position VALUES ('พนักงานขับรถยนต์')";
$result = mysql_query($sql) or die(mysql_error());
echo "<br>waiting will creat table place" ;
$sql = "CREATE TABLE car(
id int(4) NOT NULL auto_increment,
place_name varchar(50) default NULL,
PRIMARY KEY (id));";
$result = mysql_query($sql) or die(mysql_error());
echo "<br> creat table place suscess" ;
echo "<br> insert data into table place " ;
$sql ="INSERT INTO place_name VALUES ('กลุ่มงานสนับสนุนงาน')";
$result = mysql_query($sql) or die(mysql_error());
$sql ="INSERT INTO place_name VALUES ('กลุ่มงานคุ้มครองผู้บริโภค')";
$result = mysql_query($sql) or die(mysql_error());
echo "<br>waiting will creat table user" ;
$sql = "CREATE TABLE user (
id varchar(5) NOT NULL default '',
name varchar(50) default NULL,
pwd varchar(33) default NULL,
class char(2) default NULL,
inspector varchar(5) default NULL,
station varchar(5) default NULL,
name_station varchar(50) default NULL,
position varchar(30) default NULL,
money int(8) default NULL,
bod varchar(15) default NULL,
picture varchar(20) default NULL,
auth varchar(8) default NULL,
status char(1) default '1',
PRIMARY KEY (id)
) TYPE=MyISAM;";
$result = mysql_query($sql) or die(mysql_error());
echo "<br>creat user sucess" ;
echo "<br>Ex.user pwd 00001" ;
$sql ="INSERT INTO `user` VALUES ('00001','นพ.ราเมศร์ อำไพพิศ','00001','3','00001','','แพทย์','ผู้อำนวยการ',0,'','\r','a','1')";
$result = mysql_query($sql) or die(mysql_error());
$sql ="INSERT INTO `user` VALUES ('00002','สุมิตร ธรรมาภิมุข','00002','3','00002','','ศูนย์ข้อมูลข่าวสาร','ทันตแพทย์',0,'','\r','ba','1')";
$result = mysql_query($sql) or die(mysql_error());
$sql ="INSERT INTO `user` VALUES ('00058','กัญญาลักษณ์ เผ่าเพ็ง','','2','00008','08','งานชันสูตรสาธารณสุข','เจ้าหน้าที่รังสีการแพทย์',0,NULL,NULL,NULL,'1')";
$result = mysql_query($sql) or die(mysql_error());
$sql ="INSERT INTO `user` VALUES ('00066','สมร อุตะมะ','00066','2','00007','','ฝ่ายบริหารงานทั่วไป','พยาบาลเทคนิค',0,NULL,NULL,'bc','1')";
$result = mysql_query($sql) or die(mysql_error());
$sql ="INSERT INTO `user` VALUES ('00067','วิหค ธรรมดี','00067','1','00007','','ฝ่ายบริหารงานทั่วไป','พนักงานขับรถยนต์',0,NULL,NULL,'c','1')";
$result = mysql_query($sql) or die(mysql_error());
$sql ="INSERT INTO `user` VALUES ('00068','วาสนา เสถียร','00068','2','00025','','ฝ่ายบริหารงานทั่วไป','จพง.การเงินและบัญชี',0,NULL,NULL,'s','1')";
$result = mysql_query($sql) or die(mysql_error());
$sql ="INSERT INTO user VALUES ('00123','สุรัติ เกิดในมงคล','00123','2','00002','','ศูนย์ข้อมูลข่าวสาร','จพง.สาธารณสุขชุมชน',0,NULL,NULL,'a','1')";
$result = mysql_query($sql) or die(mysql_error());
if ($result) {
echo "<br><br><center><font size='7' face='Microsoft Sans Serif, MS Sans Serif, sans-serif'>Create table succes</font></center>";
}
else
{
echo "<br><br><center>table can't Create !! Mission fail</center>";
}
?>
</body>
</html>