uT8xagDN

1CREATE TABLE IF NOT EXISTS `registered_users` (
2`id` int(8) NOT NULL AUTO_INCREMENT,
3`first_name` varchar(255) NOT NULL,
4`last_name` varchar(255) NOT NULL,
5`gender` varchar(20) NOT NULL,
6`date_birth` varchar(255) NOT NULL,
7`address` varchar(255) NOT NULL,
8`postal_code` varchar(255) NOT NULL,
9`place` varchar(255) NOT NULL,
10`school_name` varchar(255) NOT NULL, 
11`email` varchar(55) NOT NULL,
12`tel` varchar(55) NOT NULL,
13
14PRIMARY KEY (`id`)
15) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
16	
17$query = "INSERT INTO registered_users (first_name, last_name, gender, date_birth, address, postal_code, place, school_name, email, tel) VALUES
18    ('" . $_POST["firstName"] . "',
19     '" . $_POST["lastName"] . "',
20     '" . $_POST["gender"] . "',
21     '" . $_POST["dateBirth"] . "',
22     '" . $_POST["address"] . "',
23     '" . $_POST["postalCode"] . "',
24     '" . $_POST["place"] . "',
25     '" . $_POST["schoolName"] . "',
26     '" . $_POST["userEmail"] . "',
27     '" . $_POST["userPhone"] . "')";
28    $result = $db_handle->insertQuery($query);
29	
30CREATE TABLE IF NOT EXISTS `registered_users` (
31`id` int(8) NOT NULL AUTO_INCREMENT,
32`first_name` varchar(255) NOT NULL,
33`last_name` varchar(255) NOT NULL,
34`gender` varchar(20) NOT NULL,
35`date_birth` varchar(255) NOT NULL,
36`address` varchar(255) NOT NULL,
37`postal_code` varchar(255) NOT NULL,
38`place` varchar(255) NOT NULL,
39`school_name` varchar(255) NOT NULL, 
40`email` varchar(55) NOT NULL,
41`tel` varchar(55) NOT NULL,
42`active` BOOLEAN NOT NULL DEFAULT false,
43
44PRIMARY KEY (`id`)
45) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
46	
47CREATE TABLE IF NOT EXISTS `registered_users` (
48`id` int(8) NOT NULL AUTO_INCREMENT,
49`first_name` varchar(255) NOT NULL,
50`last_name` varchar(255) NOT NULL,
51`gender` varchar(20) NOT NULL,
52`date_birth` varchar(255) NOT NULL,
53`address` varchar(255) NOT NULL,
54`postal_code` varchar(255) NOT NULL,
55`place` varchar(255) NOT NULL,
56`school_name` varchar(255) NOT NULL, 
57`email` varchar(55) NOT NULL,
58`tel` varchar(55) NOT NULL,
59`changed` varchar(10) NOT NULL,
60
61PRIMARY KEY (`id`)
62) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
63	
64$query = "INSERT INTO registered_users (first_name, last_name, gender, date_birth, address, postal_code, place, school_name, email, tel, changed) VALUES
65    ('" . $_POST["firstName"] . "',
66     '" . $_POST["lastName"] . "',
67     '" . $_POST["gender"] . "',
68     '" . $_POST["dateBirth"] . "',
69     '" . $_POST["address"] . "',
70     '" . $_POST["postalCode"] . "',
71     '" . $_POST["place"] . "',
72     '" . $_POST["schoolName"] . "',
73     '" . $_POST["userEmail"] . "',
74     '" . $_POST["userPhone"] . "',
75     '"ok"')";
76    $result = $db_handle->insertQuery($query);