· 10 years ago · Feb 15, 2016, 06:24 PM
1<!DOCTYPE html>
2<html>
3 <head>
4 <style>
5 table{
6 border: 1px solid black;
7 }
8 tr{
9 border: 1px solid black;
10 }
11 td{
12 border: 1px solid black
13 }
14 </style>
15 <title>Kontrolltöö 2</title>
16 <meta charset="UTF-8">
17 <meta name="viewport" content="width=device-width, initial-scale=1.0">
18 </head>
19 <body>
20 <div>
21 <?php
22 $servername = "localhost";
23 $username = "thepioneeer";
24 $password = "";
25 $dbName = "myDB";
26
27 // Create connection
28 $conn = new mysqli($servername, $username, $password);
29 // Check connection
30 if ($conn->connect_error) {
31 die("Connection failed: " . $conn->connect_error);
32 }
33
34 // Create database
35 $sql = "CREATE DATABASE IF NOT EXISTS myDB";
36 if ($conn->query($sql) !== TRUE) {
37 echo "Error creating database: " . $conn->error;
38 }
39
40 // Create new connection
41 $conn = new mysqli($servername, $username, $password, $dbName);
42 // Check connection
43 if ($conn->connect_error) {
44 die("Connection failed: " . $conn->connect_error);
45 }
46
47 // sql to create table
48 $sql = "CREATE TABLE IF NOT EXISTS MyTable (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
49 option1 VARCHAR(30) NOT NULL,
50 suboption VARCHAR(30) NOT NULL,
51 kogus VARCHAR(10) NOT NULL)";
52
53 if ($conn->query($sql) !== TRUE) {
54 echo "Error creating table: " . $conn->error;
55 }
56
57 //Form submitted
58 if(isset($_POST["add"])) {
59 $option = $_POST["option"];
60 $suboption = $_POST["suboption"];
61 $kogus = $_POST["kogus"];
62
63 $sql = "INSERT INTO MyTable (option1, suboption, kogus)
64 VALUES ('" .$_POST["option"]."', '".$_POST["suboption"]."', '". $_POST["kogus"]."' )";
65
66 if ($conn->query($sql) === TRUE) {
67 echo "New record created successfully";
68 } else {
69 echo "Error: " . $sql . "<br>" . $conn->error;
70 }
71 }
72 $conn->close();
73 ?>
74 <form method="POST" action="<?php $_SERVER['PHP_SELF']?>">
75 <input name="option" list="datalist1" placeholder="datalist1">
76 <datalist id="datalist1">
77 <?php
78 $con=mysqli_connect("localhost","thepioneeer","","myDB");
79 $sql = "SELECT option1 FROM MyTable";
80 $result = mysqli_query($con, $sql);
81
82 while ($value = mysqli_fetch_array($result)) {
83 echo "<option value=".$value['option1'].">";
84 }
85 mysqli_close($con);
86 ?>
87 </datalist>
88 <input name="suboption" list="datalist2" placeholder="datalist2">
89 <datalist id="datalist2">
90 <?php
91 $con=mysqli_connect("localhost","thepioneeer","","myDB");
92 $sql = "SELECT suboption FROM MyTable";
93 $result = mysqli_query($con, $sql);
94
95 while ($value = mysqli_fetch_array($result)) {
96 echo "<option value=".$value['suboption'].">";
97 }
98 mysqli_close($con);
99 ?>
100 </datalist>
101 <input name="kogus" type="text" placeholder="kogus">
102 <input type="submit" name="add">
103 <button type="button" onclick="addRow()">Create XML</button>
104 </form>
105 <hr>
106
107 <div id="table">
108 <?php
109 $con=mysqli_connect("localhost","thepioneeer","","myDB");
110
111 $sql = "SELECT option1, suboption, kogus FROM MyTable";
112 $result = mysqli_query($con,$sql);
113
114 if ($result->num_rows > 0) {
115 // output data of each row
116 echo "<table border='1'>
117 <tr>
118 <th>Option nimetus</th>
119 <th>Suboption nimetus</th>
120 <th>Kogus</th>
121 </tr>";
122
123 while($row = mysqli_fetch_array($result))
124 {
125 echo "<tr>";
126 echo "<td>" . $row['option1'] . "</td>";
127 echo "<td>" . $row['suboption'] . "</td>";
128 echo "<td>" . $row['kogus'] . "</td>";
129 echo "</tr>";
130 }
131 echo "</table>";
132 }
133 mysqli_close($con);
134 ?>
135 </div>
136 </div>
137 </body>
138</html>