· 7 years ago · Dec 16, 2018, 07:46 PM
1// polacz.php
2
3<?php
4 session_start();
5 $host = 'localhost';
6 $user = 'root';
7 $pass = '';
8 $db = 'samochody';
9 $conn = mysql_connect($host, $user, $pass);
10 $sql = 'CREATE DATABASE IF NOT EXISTS samochody';
11 $baza=mysql_query($sql);
12 if(!$conn){
13 die('Wystapil blad: '.mysql_error());
14 }
15 else{
16 $dba = @mysql_select_db($db, $conn);
17 if(!$dba){
18 die('Wystapil blad: '.mysql_error());
19 }
20 else{
21 $tableName = 'Sprzedane';
22 $sql_2= 'CREATE TABLE '.$tableName.' (id int(8) NOT NULL, marka varchar(32), data date,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))';
23 mysql_query($sql_2);
24 }
25 }
26
27 ?>
28
29//zad.php
30
31<style type="text/css">
32/* <![CDATA[ */
33table tr td { border: 1px solid black; border-radius: 20px; background: gray; text-align: center; padding: 3px; }
34/* ]]> */
35</style>
36
37<?php
38 REQUIRE("polacz.php");
39 $order = $_GET['order'];
40 $mod = $_GET['mod'];
41 $data = mysql_query("SELECT * FROM Sprzedane ORDER BY ".(($order) ? $order : 'id ASC'));
42
43 if(!$mod){
44 echo "<table>";
45 echo "<tr>";
46 echo "<td>ID<br><a href='?zad=2&order=id asc'>rosnaco</a> <a href='?zad=2&order=id desc'>malejaco</a></td>";
47 echo "<td>marka<br><a href='?zad=2&order=marka asc'>rosnaco</a> <a href='?zad=2&order=marka desc'>malejaco</a></td>";
48 echo "<td>data<br><a href='?zad=2&order=data asc'>rosnaco</a> <a href='?zad=2&order=data desc'>malejaco</a></td>";
49 echo "</tr>";
50 while($d = mysql_fetch_array($data)){
51 echo "<tr>";
52 echo "<td>".$d['id']."</td>";
53 echo "<td>".$d['marka']."</td>";
54 echo "<td>".$d['data']."</td>";
55 echo "</tr>";
56 }
57 echo "</table>";
58
59 echo "<br><a href='?zad=2&mod=1'>Modyfikuj</a><br>";
60 } else {
61 echo "<table>";
62 echo "<tr>";
63 echo "<td>ID<br><a href='?zad=2&order=id asc&mod=1'>rosnaco</a> <a href='?zad=2&order=id desc&mod=1'>malejaco</a></td>";
64 echo "<td>marka<br><a href='?zad=2&order=marka asc'>rosnaco</a> <a href='?zad=2&order=marka desc'>malejaco</a></td>";
65 echo "<td>data<br><a href='?zad=2&order=data asc'>rosnaco</a> <a href='?zad=2&order=data desc'>malejaco</a></td>";
66 echo "<td>Modyfikuj</td>";
67 echo "<td>Usun</td>";
68 echo "</tr>";
69 while($d = mysql_fetch_array($data)){
70 echo "<form action='?zad=2&mod=1' method='post'>";
71 echo "<tr>";
72 echo "<td><input type='text' name='id' value='".$d['id']."' readonly></td>";
73 echo "<td><input type='text' name='marka' value='".$d['marka']."'></td>";
74 echo "<td><input type='text' name='data' value='".$d['data']."'</td>";
75 echo "<td><input type='submit' value='Modyfikuj' name='mod2'></td>";
76 echo "<td><input type='submit' value='Usun' name='del'></td>";
77 echo "</tr>";
78 echo "</form>";
79 }
80 echo "</table>";
81
82 $id = htmlspecialchars(trim($_POST['id']));
83 $marka = htmlspecialchars(trim($_POST['marka']));
84 $data = htmlspecialchars(trim($_POST['data']));
85 $mod2 = htmlspecialchars(trim($_POST['mod2']));
86 $del = htmlspecialchars(trim($_POST['del']));
87
88 if($_POST){
89 if($id && $marka && $data ){
90 if($mod2){
91 echo "UPDATE Sprzedane SET marka='".$marka."', data='".$data."' WHERE id='".$id."'";
92 mysql_query("UPDATE Sprzedane SET marka='".$marka."', data='".$data."' WHERE id='".$id."'") or die(mysql_error());
93 header('Location: ?zad=2&mod=1');
94 } else {
95 mysql_query("DELETE FROM Sprzedane WHERE id='".$id."'") or die(mysql_error());
96 header('Location: ?zad=2&mod=1');
97 }
98 }
99 }
100
101 echo "<br><a href='?zad=2'>Wyswietl</a><br>";
102 }
103
104 echo "<br><br>Dodaj dane:<br>";
105
106 echo "<form action='?zad=2&mod=".$mod."' method='post'>";
107
108 echo "<table>";
109 echo "<tr>";
110 echo "<td>id</td>";
111 echo "<td>marka</td>";
112 echo "<td>data</td>";
113 echo "</tr>";
114 echo "<tr>";
115 echo "<td><input type='text' name='id'></td>";
116 echo "<td><input type='text' name='marka'></td>";
117 echo "<td><input type='text' name='data'></td>";
118 echo "<td><input type='submit' name='add' value='Dodaj'></td>";
119 echo "</tr>";
120 echo "</table>";
121
122 echo "</form>";
123 $id = htmlspecialchars(trim($_POST['id']));
124 $marka = htmlspecialchars(trim($_POST['marka']));
125 $data = htmlspecialchars(trim($_POST['data']));
126 $add = htmlspecialchars(trim($_POST['add']));
127
128 if($_POST){
129 if($id &&$marka && $data && $add){
130 mysql_query("INSERT INTO Sprzedane SET id='".$id."', marka='".$marka."', data='".$data."'");
131 header('Location: ?zad=2&mod='.$mod);
132 }
133 }
134?>