209.15.110.90 - BlackDragon

Windows NT MYOFFICEPLG2 6.2 build 9200 (Windows Server 2012 Standard Edition) i586
Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30
192.168.0.82
Cant read /etc/named.conf

URL to Upload

File Name

Upload Method

Upload from URL

install.php

<?php
include("../config.inc.php");

$sql_create="CREATE TABLE IF NOT EXISTS school_project (
  id int(11) NOT NULL auto_increment,
  code varchar(12) NOT NULL,
  name varchar(150) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS school_project_list (
  id int(11) NOT NULL auto_increment,
  code_project varchar(12) NOT NULL,
  schoolcode varchar(12) NOT NULL,
  year varchar(12) NOT NULL,
  detail varchar(255) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_code_project
ON school_project_list (code_project)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS achievement (
  id int(11) NOT NULL auto_increment,
  class tinyint(4) NOT NULL,
  year varchar(4) NOT NULL,
  schoolcode varchar(12) NOT NULL,
  thai float NOT NULL default '0',
  math float NOT NULL default '0',
  science float NOT NULL default '0',
  social float NOT NULL default '0',
  english float NOT NULL default '0',
  health float NOT NULL default '0',
  art float NOT NULL default '0',
  vocation float NOT NULL default '0',
  score_avg float NOT NULL default '0',
  noGroup varchar(3) NOT NULL,
  noArea varchar(3) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON achievement (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS achievement_score (
  id int(11) NOT NULL auto_increment,
  class tinyint(4) NOT NULL,
  year varchar(4) NOT NULL,
  area float NOT NULL default '0',
  obec float NOT NULL default '0',
  nation float NOT NULL default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS system_teams (
  id int(11) NOT NULL auto_increment,
  code varchar(2) NOT NULL COMMENT '1.บริหาร, 2.พัฒนา / 1.ประธาน 2.รอง 3.กรรมการ 4.เลขา 5.ผู้ช่วยเลขา' ,
  name varchar(100) NOT NULL,
  position varchar(200) NOT NULL,
  photo varchar(200) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS system_group (
  id int(11) NOT NULL auto_increment,
  code varchar(2) NOT NULL,
  name varchar(150) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS system_school (
  id int(11) NOT NULL auto_increment,
  smis varchar(20) NOT NULL,
  percode varchar(20) NOT NULL,
  ministry varchar(20) NOT NULL,
  schoolname varchar(255) NOT NULL,
  schoolname_eng varchar(255) NOT NULL,
  schoolgroup varchar(2) NOT NULL,
  muti varchar(10) NOT NULL,
  road varchar(100) NOT NULL,
  muban varchar(100) NOT NULL,
  tambon varchar(100) NOT NULL,
  amper varchar(100) NOT NULL,
  province varchar(100) NOT NULL,
  postcode varchar(100) NOT NULL,
  lat varchar(80) NOT NULL,
  lng varchar(80) NOT NULL,
  tel varchar(20) NOT NULL,
  email varchar(150) NOT NULL,
  website varchar(150) NOT NULL,
  statusID varchar(1) NOT NULL COMMENT '0=เลิก, 1=ปกติ, 2=ควบรวมทุกชั้น, 3-ควบรวมบางชั้น',
  statusDetail varchar(20) NOT NULL COMMENT 'เลิกสถานศึกษา=วันที่อนุมัติ, ควบรวม=รหัสโรงเรียนหลัก',
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS age (
  id int(11) NOT NULL auto_increment,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON age (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS deformity (
  id int(11) NOT NULL auto_increment,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON deformity (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS occasion (
  id int(11) NOT NULL auto_increment,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON occasion (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS health (
  id int(11) NOT NULL auto_increment,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON health (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS journeytype (
  id int(11) NOT NULL auto_increment,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON journeytype (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS race (
  id int(11) NOT NULL auto_increment,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON race (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS religion (
  id int(11) NOT NULL auto_increment,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON religion (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS p6end (
  id int(11) NOT NULL auto_increment,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON p6end (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS m3end (
  id int(11) NOT NULL auto_increment,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON m3end (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS m6end (
  id int(11) NOT NULL auto_increment,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON m6end (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS schoolmis (
  id int(11) NOT NULL auto_increment,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a1r varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a2r varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  a3r varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  sum_ar varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p1r varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p2r varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p3r varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p4r varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p5r varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  p6r varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  sum_pr varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m1r varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m2r varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  m3r varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  sum_mr varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m4r varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m5r varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  m6r varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_hr varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  sum_r_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON schoolmis (schoolcode)";
$query = mysqli_query($connect,$sql_create);

if($query){
			echo "<center><img src='../images/ok.png' border=0 height=200>
			<meta http-equiv=refresh content=1;URL='../admin.php'></center>";
		}else{
			echo "<center><img src='../images/database-error.png' border=0 height=100>";
			echo "<br><a href='../admin.php'>ติดตั้งไม่สำเร็จ คลิกกลับ</a></center>";
		}
?>

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	dr-xr-xr-x	2025-07-04 01:29:02
..	dir	-	0/0	dr-xr-xr-x	2025-07-16 10:41:05
install.php	file	22.67 KB	0/0	-rw-rw-rw-	2021-03-18 12:36:33