Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
- <html>
- <head>
- <meta http-equiv="content-type" content="text/html; charset=utf-8">
- <meta name="generator" content="PSPad editor, www.pspad.com">
- <title></title>
- </head>
- <body>
- <?
- //Přihlášení do DB
- $DBSERVER = 'sql2.webzdarma.cz';
- $DBUSER = 'sovetickachy0307';
- $DBPASS = 'Immergas1';
- $DB = 'sovetickachy0307';
- $link = mysql_connect($DBSERVER,$DBUSER,$DBPASS) or die ('Nelze se připojit k DB');
- mysql_select_db($DB,$link) or die ('Nelze vybrat databázi');
- mysql_query("SET NAMES utf8");
- //Vstup do DB
- if(isset($_POST['insert_persons'])){
- $jmeno = $_POST['jmeno'];
- $prijmeni = $_POST['prijmeni'];
- $adresa = $_POST['adresa'];
- $email = $_POST['email'];
- mysql_query("INSERT INTO users (jmeno,prijmeni,adresa,email)
- VALUES('".$jmeno."','".$prijmeni."','".$adresa."','".$email."')");
- echo "Uživatel $jmeno byl přidán do databáze.<br>";
- }
- ?>
- <!-- Formulář pro vstup -->
- <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post">
- Jméno: <input name="jmeno" value="" type="text"></br>
- Příjmení: <input name="prijmeni" value="" type="text"></br>
- Adresa: <input name="adresa" value="" type="text"></br>
- Email: <input name="email" value="" type="text"></br>
- <input type='submit' name='insert_persons' value="Vložit"><br><br>
- </form>
- <br><br />
- <?
- //Editace DB
- if(isset($_POST['user_edit'])){
- $id = $_POST['id'];
- $jmeno = $_POST['nick'];
- $prijmeni = $_POST['prijmeni'];
- $adresa = $_POST['adresa'];
- $email = $_POST['email'];
- mysql_query("UPDATE users SET jmeno='".$jmeno."' , prijmeni='".$prijmeni."' , adresa='".$adresa."' , email='".$email."' WHERE id='".$id."' ");
- echo "$id/$jmeno/$prijmeni/$adresa/$email - Aktualizováno...<br>";
- }
- //Formulář pro editaci DB- Vypisuje řádky podle počtu vstupů v ID. Každý řádek = separátní formulář.
- echo "<table>";
- $data=mysql_query("select * from users");
- while($zaznam=mysql_fetch_array($data)){
- echo "<tr>";
- echo "<form action='".$_SERVER['PHP_SELF']."' method='POST'>";
- echo "<input type='hidden' name='id' value='".$zaznam["id"]."'>";
- echo "<td style='width:100px;'><input type='text' name='nick' value='".$zaznam["jmeno"]."'</td>";
- echo "<td style='width:100px;'><input type='text' name='prijmeni' value='".$zaznam["prijmeni"]."'</td>";
- echo "<td style='width:100px;'><input type='text' name='adresa' value='".$zaznam["adresa"]."'</td>";
- echo "<td style='width:100px;'><input type='text' name='email' value='".$zaznam["email"]."'</td>";
- echo "<td style='width:100px;'><input type='submit' name='user_edit' value='editovat'</td>";
- echo "</tr>";
- }
- echo "</table>"
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement