-
Notifications
You must be signed in to change notification settings - Fork 1
/
Con2Mysql.php
66 lines (62 loc) · 1.57 KB
/
Con2Mysql.php
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
<?php
include "connect.php"
?>
<?php
function clearData($data, $type = 'i')
{
switch ($type) {
case 'i':
return $data * 1;
break;
case 's':
return trim(strip_tags($data));
break;
}
}
$output = "";
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$number1 = clearData($_POST['number1']);
$number2 = clearData($_POST['number2']);
if ($_POST['1']) {
$nameD = $_POST["number1"];
$telD = $_POST["number2"];
$query = "INSERT INTO `NoteBook` (`nameData`, `telData`)
VALUES('$nameD', '$telD');";
$result = mysql_query($query);
$output = 'Comlete';
} else if ($_POST['2']) {
$nameD = $_POST["number1"];
$telD = $_POST["number2"];
$query = "SELECT * FROM NoteBook where nameData='$nameD';";
$result = mysql_query($query);
output($result);
} else if ($_POST['3']) {
$query = "SELECT * FROM NoteBook";
$result = mysql_query($query);
output($result);
}
}
?>
<form action="<?= $_SERVER['PHP_SELF'] ?>" method="POST">
Name:
<input type="text" name="number1">
Tel:
<input type="text" name="number2"><br/>
<input type="submit" name="1" value="Insert">
<input type="submit" name="2" value="Find">
<input type="submit" name="3" value="Show">
</form>
<?php
if ($output) {
echo $output;
}
?>
<?php
function output($result)
{
while ($nameData = mysql_fetch_array($result)) {
echo "<h3>" . $nameData["nameData"] . "</h3>";
echo "<p>" . $nameData["telData"] . "</p>";
}
}
?>