Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <title>Untitled</title>
- <meta charset='utf-8'>
- <link rel="stylesheet" type="text/css" href="css/style.css">
- </head>
- <body>
- <form method='post'>
- <p> Table info</p>
- <input type='text' name='firstname' placeholder='Vardas' pattern='[a-zA-Z]{5,30}'><br>
- <input type='text' name='email' placeholder='Email' pattern='[a-zA-Z0-9]+@[a-zA-Z0-9]+.[a-zA-Z]{2,5}'><br>
- <input type='text' name='message' placeholder='Tekstas' pattern='[a-zA-Z0-9\s]{5,}'><br>
- <button type='submit' name='insert'>Siusti</button><br>
- <input type='text' name='deleteEdit' placeholder='ID' pattern='[0-9]{1,4}'><br>
- <button type='submit' name='edit'>Redaguoti</button>
- <button type='submit' name='delete'>Trinti</button>
- <button type='submit' name='display'>Rodyti duombaze</button>
- </form>
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "test";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- // Insert
- if (isset($_POST['insert'])) {
- $name = $_POST['firstname'];
- $email = $_POST['email'];
- $text = $_POST['message'];
- $ip = $_SERVER['REMOTE_ADDR'];
- if ((preg_match('/[a-zA-Z]{5,30}/', $name)) and (preg_match('/[a-zA-Z0-9]@[a-zA-Z0-9].[a-zA-Z]{2,5}/', $email)) and (preg_match('/[a-zA-Z0-9\s]{5,}/', $text))) {
- $sql = "INSERT INTO mantas_zukauskas(ip, vardas, epastas, zinute) VALUES('$ip', '$name', '$email', '$text')";
- if ($conn->query($sql) === TRUE) {
- echo "New record created successfully";
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- } else {
- die ("Form filled incorrectly");
- }
- }
- // Delete
- if (isset($_POST['delete'])) {
- $id = $_POST['deleteEdit'];
- $check = mysqli_query($conn, "SELECT * FROM mantas_zukauskas WHERE id = '$id'");
- if (mysqli_num_rows($check) > 0) {
- } else {
- die ("ID does not exist in table");
- }
- if (preg_match('/[0-9]{1,4}/', $id)) {
- $sql ="DELETE FROM mantas_zukauskas WHERE id = '$id'";
- if ($conn->query($sql) === TRUE) {
- echo "Record deleted successfully";
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- } else {
- die ("Error, not deleted");
- }
- }
- // Edit
- if (isset($_POST['edit'])) {
- $id = $_POST['deleteEdit'];
- $name = $_POST['firstname'];
- $email = $_POST['email'];
- $text = $_POST['message'];
- $ip = $_SERVER['REMOTE_ADDR'];
- if ((preg_match('/[a-zA-Z]{5,30}/', $name)) and (preg_match('/[a-zA-Z0-9]@[a-zA-Z0-9].[a-z]{2,5}/', $email)) and (preg_match('/[a-zA-Z0-9\s]{5,}/', $text)) and (preg_match('/[0-9]{1,4}/', $id))) {
- $check = mysqli_query($conn, "SELECT * FROM mantas_zukauskas WHERE id = '$id'");
- if (mysqli_num_rows($check) > 0) {} else {
- die ("ID does not exist in table");
- }
- $sql = "UPDATE mantas_zukauskas SET vardas ='$name', epastas = '$email', zinute = '$text', ip = '$ip' WHERE id='$id'";
- if ($conn->query($sql) === TRUE) {
- echo "Record updated successfully";
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- } else {
- die ("Form filled incorrectly");
- }
- }
- // Show data on page
- if (isset($_POST['display'])) {
- $id = $_POST['deleteEdit'];
- if ($id == TRUE) {
- $check = mysqli_query($conn, "SELECT * FROM mantas_zukauskas WHERE id = '$id'");
- if ($check->num_rows > 0) {
- } else {
- $check = mysqli_query($conn, "SELECT * FROM mantas_zukauskas");
- }
- } else {
- $check = mysqli_query($conn, "SELECT * FROM mantas_zukauskas");
- }
- if ($check->num_rows > 0) {
- while ($row = $check->fetch_assoc()) {
- echo "ID: " . $row["id"]. " Vardas: " . $row["vardas"]. " E-mail: " . $row["epastas"]. " Zinute: " . $row["zinute"]. "<br>";
- }
- }
- }
- $conn->close();
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement