joinCADA/new.php at master · Z4Tech/joinCADA · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<?php

$id = $_POST['id'];
$name = $_POST['name'];
$grade = $_POST['grade'];
$school = $_POST['school'];
$text_gender = $_POST['gender'];
$phone = $_POST['phone'];
$mail = $_POST['mail'];
$arr_favor = $_POST['favor'];
$text_work = $_POST['work'];

if($text_gender == "男"){
	$gender = 0;
}
else $gender = 1;

if($text_work == "否"){
	$work = 0;
}
else $work = 1;

$favor = implode(' ',$arr_favor);

// echo $gender;
// echo $work;
// echo $favor;
$dbname='members.db';
$mytable ="member";

if(!class_exists('SQLite3'))
   die("SQLite 3 NOT supported.");

$base=new SQLite3($dbname, 0666);

$query = "INSERT INTO $mytable(ID, NAME, GRADE, SCHOOL, GENDER, PHONE, MAIL, FAVOR, WORK)
                VALUES ('$id', '$name', '$grade', '$school', '$gender', '$phone', '$mail', '$favor', '$work')";
$results = $base->exec($query);

// echo $id;
// echo $name;
// echo $grade;
// echo $school;
// echo $gender;
// echo $phone;
// echo $mail;
// echo $favor;
// echo $work;

// $value = $_POST['favor'];
// echo "<br>";
// echo implode(',',$value);
// echo $gender == '男';

?>

<!DOCTYPE html>
<html lang="zh_cn">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="CADA Registering">
    <meta name="author" content="Z4Tech">

    <title>CADA报名</title>

    <!-- Bootstrap core CSS -->
    <link href="./css/bootstrap.min.css" rel="stylesheet">
    <link href="./css/cover.css" rel="stylesheet">
  </head>

  <body>

    <div class="site-wrapper">

      <div class="site-wrapper-inner">

        <div class="cover-container">

          <div class="masthead clearfix">
          </div>

          <div class="inner cover">
            <h1 class="cover-heading">入坑成功</h1>
            <p class="lead">完成成就——加入CADA</p>
          </div>

          <div class="mastfoot">
            <div class="inner">
              <p>Created by Z4Tech, 2014</p>
            </div>
          </div>

        </div>

      </div>

    </div>

    <!-- Bootstrap core JavaScript
    ================================================== -->
    <!-- Placed at the end of the document so the pages load faster -->
    <script src="./js/jquery.min.js"></script>
    <script src="./js/bootstrap.min.js"></script>
    <script src="./js/docs.min.js"></script>
  </body>
</html>

<?php
	 header("refresh:3;url=./index.php");
?>