001.
<?
002.
session_start();
003.
$yname
=
$_SESSION
[
"yname"
];
004.
$member
=
$_SESSION
[
"member"
];
005.
$ID
=
$_SESSION
[
"ID"
];
006.
$name
=
$_SESSION
[
"name"
];
007.
$surname
=
$_SESSION
[
"surname"
];
008.
009.
include
(
'../connect.php'
);
010.
011.
$stsu_id
=
$_POST
[
"stsu_id"
];
012.
$round_id
=
$_POST
[
"round_id"
];
013.
$system_id
=
$_POST
[
"system_id"
];
014.
$class_id
=
$_POST
[
"class_id"
];
015.
$mem_id
=
$_POST
[
"mem_id"
];
016.
017.
$stu_id
=
$_POST
[
"stu_id"
];
018.
$prefix_id
=
$_POST
[
"prefix_id"
];
019.
$stu_name
=
$_POST
[
"stu_name"
];
020.
$stu_surname
=
$_POST
[
"stu_surname"
];
021.
$stu_nickname
=
$_POST
[
"stu_nickname"
];
022.
$stu_card
=
$_POST
[
"stu_card"
];
023.
$day
=
$_POST
[
"day"
];
024.
$month
=
$_POST
[
"month"
];
025.
$years
=
$_POST
[
"years"
];
026.
$stu_birthday
=
"$day/$month/$years"
;
027.
$stu_nationality
=
$_POST
[
"stu_nationality"
];
028.
$stu_origin
=
$_POST
[
"stu_origin"
];
029.
$stu_regligion
=
$_POST
[
"stu_religion"
];
030.
$stu_blood
=
$_POST
[
"stu_blood"
];
031.
$stu_weight
=
$_POST
[
"stu_weight"
];
032.
$stu_height
=
$_POST
[
"stu_height"
];
033.
034.
$class_school
=
$_POST
[
"class_school"
];
035.
$name_school
=
$_POST
[
"name_school"
];
036.
$grade_school
=
$_POST
[
"grade_school"
];
037.
038.
$house_number
=
$_POST
[
"house_number"
];
039.
$add_soi
=
$_POST
[
"add_soi"
];
040.
$add_moo
=
$_POST
[
"add_moo"
];
041.
$add_road
=
$_POST
[
"add_road"
];
042.
$add_location
=
$_POST
[
"add_location"
];
043.
$add_district
=
$_POST
[
"add_district"
];
044.
$add_province
=
$_POST
[
"add_province"
];
045.
$add_zip
=
$_POST
[
"add_zip"
];
046.
$add_tel
=
$_POST
[
"add_tel"
];
047.
$stu_tel
=
$_POST
[
"stu_tel"
];
048.
$stu_pic
=
$_POST
[
"stu_pic"
];
049.
$sqlC
=
"select * from student where stu_id='$stu_id'"
;
050.
$queryC
=mysql_db_query(
'student'
,
$sqlC
);
051.
$numC
=mysql_num_rows(
$queryC
);
052.
053.
if
(
$numC
!=0){
054.
echo
"<script>alert('มีรายชื่อนักเรียนคนนี้ในฐานข้อมูลแล้ว กรุณาตรวจสอบรหัสนักเรียนใหม่ด้วยค่ะ');history.back();</script>"
;
055.
}
else
{
056.
057.
058.
059.
060.
061.
062.
063.
[font=Verdana]
echo
$files
;
064.
$pic_size
=
filesize
(
$files
);
065.
echo
$pic_size
;
066.
$pic_data
=
addslashes
(
fread
(
fopen
(
$files
,
"r"
),
$pic_size
));
067.
echo
$pic_data
;[/font]
068.
$sql
=
"insert into student(stsu_id,round_id,system_id,class_id,mem_id,stu_id,prefix_id,stu_name,stu_surname,"
;
069.
$sql
.=
"stu_nickname,stu_card,stu_birthday,stu_nationality,stu_origion,stu_religion,stu_blood,stu_weight,stu_height,"
;
070.
$sql
.=
"class_school,name_school,grade_school,"
;
071.
$sql
.=
"house_number,add_soi,add_moo,add_road,add_location,add_district,add_province,add_zip,add_tel,stu_tel,"
;
072.
$sql
.=
"uname,upass,stu_pic,)"
;
073.
074.
$sql
.=
" values ('$stsu_id','$round_id','$system_id','$class_id','$mem_id','$stu_id','$prefix_id','$stu_name',"
;
075.
$sql
.=
"'$stu_surname','$stu_nickname','$stu_card','$stu_birthday','$stu_nationality','$stu_origin',"
;
076.
$sql
.=
"'$stu_religion','$stu_blood','$stu_weight','$stu_height',"
;
077.
$sql
.=
"'$class_school','$name_school','$grade_school',"
;
078.
$sql
.=
"'$house_number','$add_soi','$add_moo','$add_road','$add_location','$add_district','$add_province',"
;
079.
$sql
.=
"'$add_zip','$add_tel','$stu_tel',"
;
080.
$sql
.=
"'$stu_id','$stu_card','$pic_size')"
;
081.
082.
echo
$sql
;
083.
$query
=mysql_query(
$sql
);
084.
if
(
$query
)
085.
{
086.
087.
echo
"<script>alert('นำข้อมูลลงฐานข้อมูลเรียบร้อยแล้ว');window.location='../index_system.php';</script>"
;
088.
}
else
{
089.
echo
"<script>alert('ไม่สามาถนำข้อมูลลงฐานข้อมูลได้'history.back(););</script>"
;
090.
}
091.
}
092.
093.
?>
096.
<head>
097.
<meta http-equiv=
"Content-Type"
content=
"text/html; charset=utf-8"
/>
098.
<title>Untitled Document</title>
099.
</head>
100.
101.
<body>
102.
</body>
103.
</html>