· 8 years ago · Jan 11, 2018, 09:30 PM
1<!DOCTYPE html>
2<!--
3To change this license header, choose License Headers in Project Properties.
4To change this template file, choose Tools | Templates
5and open the template in the editor.
6-->
7<html>
8<head>
9 <meta charset="UTF-8">
10 <title></title>
11 <script type='text/javascript'>
12
13 function HideAll()
14 {
15 document.getElementById("FormInsert").hidden = true;
16 document.getElementById("FormDel").hidden = true;
17 }
18
19 function CheckTrack()
20 {
21 if(document.getElementsByName("NewDel")[0].checked == true)
22 {
23 document.getElementById("FormInsert").hidden = false;
24 document.getElementById("FormDel").hidden = true;
25 }
26 else
27 {
28 document.getElementById("FormInsert").hidden = true;
29 document.getElementById("FormDel").hidden = false;
30 }
31 }
32
33 </script>
34</head>
35<body onload="HideAll()">
36
37 <table style="border: 1px solid #000; margin-top: 50px; margin-left: 50px; width: 300px;">
38
39 <tr>
40 <td>Nuovo utente</td>
41 <td><input type="radio" name="NewDel" onchange="CheckTrack()"/></td>
42 </tr>
43 <tr>
44 <td>Elimina</td>
45 <td><input type="radio" name="NewDel" onchange="CheckTrack()"/></td>
46 </tr>
47
48 </table>
49
50 <form method="post" id="FormInsert">
51 <table style="border: 1px solid #000; margin-top: 50px; margin-left: 50px; width: 300px;">
52 <tr><td>Nome</td> <td><input type="text" name="Nome"/></td></tr>
53 <tr><td>Email</td> <td><input type="Email" name="Email"/></td></tr>
54 <tr><td>Password</td> <td><input type="Password" name="Password"/></td></tr>
55 <tr><td colspan="2" align="center"> <input type="submit" value="Inserisci" style="width: 100%;" /> </td> </tr>
56 </table>
57 </form>
58
59 <form method="post" id="FormDel">
60 <table style="border: 1px solid #000; margin-top: 50px; margin-left: 50px; width: 300px;">
61 <tr><td>Id utente da eliminare</td> <td><input type="number" name="Id"/></td></tr>
62 <tr><td colspan="2" align="center"> <input type="submit" value="Elimina" style="width: 100%;" /> </td> </tr>
63 </table>
64 </form>
65
66 <?php
67 $mysqli = @mysqli_connect("localhost", "root", "");
68
69 if(!$mysqli)
70 Error($mysqli, "Errore con la tabella");
71
72 if (!@mysqli_select_db($mysqli, "my_herz"))
73 Error($mysqli, "Errore con la tabella");
74
75 $insert = true;
76 $delete = true;
77 echo "<pre> \n";
78 if(isset($_POST["Nome"]) && isset($_POST["Email"]) && isset($_POST["Password"]) && $insert){
79 if($_POST["Nome"] == "" || $_POST["Email"] == "" || $_POST["Password"] == "")
80 Error($mysqli, "Devi inserire dei valori");
81 $delete = false;
82 $insert = false;
83 $result = @mysqli_query($mysqli, "INSERT INTO user (Nome, Email, Password)VALUES ('$_POST[Nome]','$_POST[Email]','$_POST[Password]')");
84 if (!$result)
85 Error($mysqli, "Errore con la query");
86 ShowTable($mysqli);
87 }
88 else if (isset($_POST["Id"]) && $delete){
89 if($_POST["Id"] <= 0)
90 Error($mysqli, "Errore, L'ID non può essere minore di 0");
91 $delete = false;
92 $insert = false;
93 $result = @mysqli_query($mysqli, "DELETE FROM user WHERE Id = '$_POST[Id]'");
94 if (!$result)
95 Error($mysqli, "Errore con la query");
96 ShowTable($mysqli);
97 }
98 else
99 Error($mysqli, "Nessun valore valido passato");
100
101
102 function ShowTable($mysqli) {
103
104 $result = @mysqli_query($mysqli, "SELECT * FROM user");
105 if (!$result)
106 Error($mysqli, "Errore con la query");
107 echo "<table style='border: 1px solid #000; margin-top: 50px; margin-left: 50px; width: 300px;'>";
108
109 while($row = $result->fetch_array(MYSQLI_ASSOC)) {
110 echo "<tr> <td> ".$row['Id']." </td> ";
111 echo " <td> ".$row['Nome']." </td> ";
112 echo " <td> ".$row['Email']." </td>";
113 echo " <td> ".$row['Password']." </td> </tr>";
114 }
115 echo '<table>';
116 echo "</pre> \n";
117
118 }
119
120 function Error($mysqli, $err) {
121 $nl="<br />";
122 echo mysqli_sqlstate( $mysqli ) . $nl;
123 echo mysqli_errno( $mysqli ) . $nl;
124 echo mysqli_error( $mysqli ) . $nl;
125 echo $err;
126 die();
127 }
128
129 ?>
130
131</body>
132</html>
133
134
135<!--
136
137SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
138SET time_zone = "+00:00";
139
140CREATE DATABASE IF NOT EXISTS `corsophp` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
141USE `corsophp`;
142
143DROP TABLE IF EXISTS `user`;
144CREATE TABLE `user` (
145 `Id` int(11) NOT NULL,
146 `Nome` varchar(50) NOT NULL,
147 `Email` varchar(50) NOT NULL,
148 `Password` varchar(128) NOT NULL
149) --ENGINE=InnoDB DEFAULT CHARSET=latin1;
150
151
152INSERT INTO `user` (`Id`, `Nome`, `Email`, `Password`) VALUES
153(1, 'Alessandro', 'alekevin@gmail.com', 'alekevin12'),
154(3, 'Giovanni', 'giovanni@gmail.com', 'giovanni98'),
155(4, 'Marco', 'marco@gmail.com', 'marco98'),
156(5, 'Giovanni', 'giova@gmail.com', 'giova87'),
157(6, 'Riccardo', 'riccardo@gmail.com', 'natale99'),
158(9, 'Nino', 'nino@gmail.com', 'nino554');
159
160
161ALTER TABLE `user`
162 ADD PRIMARY KEY (`Id`);
163
164ALTER TABLE `user`
165 MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
166
167 -->