· 7 years ago · Dec 09, 2018, 08:22 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//wyswietl.php
30
31<style type="text/css">
32table tr td { border: 1px solid black; text-align: center; padding: 2px; }
33</style>
34
35<?php
36 REQUIRE("polacz.php");
37
38 $order = $_GET['order'];
39 $mod = $_GET['mod'];
40 $data = mysql_query("SELECT * FROM Sprzedane ORDER BY ".(($order) ? $order : 'id ASC'));
41 //if(!$mod){
42echo "Zawartosc tabel: <BR><table>";
43 echo "<tr>";
44 echo "<td>ID<br><a href='?zad=2&order=id asc'>rosnaco</a> <a href='?zad=2&order=id desc'>malejaco</a></td>";
45 echo "<td>MARKA<br><a href='?zad=2&order=marka asc'>rosnaco</a> <a href='?zad=2&order=marka desc'>malejaco</a></td>";
46 echo "<td>DATA<br><a href='?zad=2&order=data asc'>rosnaco</a> <a href='?zad=2&order=data desc'>malejaco</a></td>";
47 echo "</tr>";
48 while($d = mysql_fetch_array($data)){
49 echo "<tr>";
50 echo "<td>".$d['id']."</td>";
51 echo "<td>".$d['marka']."</td>";
52 echo "<td>".$d['data']."</td>";
53 echo "</tr>";
54 }
55 echo "</table>";
56/////////////////////////////////////////////////////////////
57
58
59echo '<br><a href="dodaj.php">Dodawanie</a>
60<a href="edyt_usun.php">Edycja lub usuwanie</a><br>'
61?>
62
63//dodaj.php
64
65
66<style type="text/css">
67table tr td { border: 1px solid black; text-align: center; padding: 2px; }
68</style>
69
70<?php
71 REQUIRE("polacz.php");
72
73
74echo "<br>Wstawianie:<br>";
75echo "<form action='dodaj.php' method='post'>";
76
77 echo "<table>";
78 echo "<tr><td>ID</td><td>MARKA</td><td>DATA</td></tr><tr>";
79 echo "<td><input type='text' name='id'></td>";
80 echo "<td><input type='text' name='marka'></td>";
81 echo "<td><input type='text' name='data'></td>";
82 echo "</tr></table>";
83 echo "<input type='submit' name='dodaj' value='Dodaj'>";
84 echo "</form>";
85 $id = htmlspecialchars(trim($_POST['id']));
86 $p1 = htmlspecialchars(trim($_POST['marka']));
87 $p2 = htmlspecialchars(trim($_POST['data']));
88 $dodaj = htmlspecialchars(trim($_POST['dodaj']));
89
90 if($_POST){
91 if($id && $p1 && $p2 && $dodaj){
92 mysql_query("INSERT INTO Sprzedane SET id= '".$id."',marka='".$p1."', data='".$p2."' ");
93 header('Location: dodaj.php');
94 }
95 }
96
97echo '<br><a href="wyswietl.php">Wyswietlanie</a>
98<a href="edyt_usun.php">Edycja lub usuwanie</a>'
99?>
100
101
102//edyt_usun.php
103
104<style type="text/css">
105table tr td { border: 1px solid black; text-align: center; padding: 2px; }
106</style>
107
108<?php
109 REQUIRE("polacz.php");
110
111 $data = mysql_query("SELECT * FROM Sprzedane");
112
113echo '<br><br>Edycja lub usuwanie danych:<br>';
114 //echo "<br><a href='?zad=2&mod=1'>Modyfikuj</a><br>";
115 //} else {
116 echo "<table>";
117 echo "<tr>";
118 echo "<td>Edytuj</td>";
119 echo "<td>Usun</td>";
120 echo "<td>ID<br></td>";
121 echo "<td>Marka<br></td>";
122 echo "<td>Data<br></td>";
123 echo "</tr>";
124 while($r = mysql_fetch_array($data)){
125 echo "<form action='edyt_usun.php' method='post'>";
126 echo "<td><input type='submit' value='Edytuj' name='edytuj'></td>";
127 echo "<td><input type='submit' value='Usun' name='usun'></td>";
128 echo "<td><input type='text' name='id' value='".$r['id']."'></td>";
129 echo "<td><input type='text' name='p1' value='".$r['marka']."'></td>";
130 echo "<td><input type='text' name='p2' value='".$r['data']."'</td>";
131 echo "</tr>";
132 echo "</form>";
133 }
134 echo "</table>";
135
136 $id = htmlspecialchars(trim($_POST['id']));
137 $p1 = htmlspecialchars(trim($_POST['p1']));
138 $p2 = htmlspecialchars(trim($_POST['p2']));
139 $edytuj = htmlspecialchars(trim($_POST['edytuj']));
140 $usun = htmlspecialchars(trim($_POST['usun']));
141
142 if($_POST){
143 if($id && $p1 && $p2){
144 if($edytuj){
145 echo "UPDATE Sprzedane SET marka='".$p1."', data='".$p2."' WHERE id='".$id."'";
146 mysql_query("UPDATE Sprzedane SET marka='".$p1."', data='".$p2."' WHERE id='".$id."'") or die(mysql_error());
147 header('Location: edyt_usun.php');
148 } else {
149 mysql_query("DELETE FROM Sprzedane WHERE id='".$id."'") or die(mysql_error());
150 header('Location: edyt_usun.php');
151 }
152 }
153 }
154
155
156echo '
157<a href="wyswietl.php">Wyswietlanie</a>
158<a href="dodaj.php">Dodawanie</a>
159 ';
160?>