1 files changed, 38 insertions, 28 deletions
diff --git a/test/index.php b/test/index.php
index 3b1d7c0..fb6e942 100644
--- a/test/index.php
+++ b/test/index.php
@@ -1,15 +1,24 @@
 <?php
+  try {
+    $conn = new PDO("mysql:host=localhost;dbname=testdb", "testuser", "testpass");
+    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+  }
+  catch (PDOException $e) {
+    echo $e->getMessage();
+  }
 if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["name"]) && isset($_POST["date"]) && isset($_POST["time"])) {
   # values will always be set, check if they are empty...
   echo "<strong>Information submitted!</strong><br>";
   echo "<strong>Date: " . date('Y-m-d H:i:s') . "</strong><br>";
+  echo "<strong>User date: " . $_POST["date"] . "</strong><br>";
+  echo "<strong>User time: " . $_POST["time"] . "</strong><br>";
+  //$toDT='2020-10-10 12:00:00';
+  $toDT=$_POST["date"] . " " . $_POST["time"] . ":00";
+  echo "<strong>$toDT</strong><br>";
   try {
-    $conn = new PDO("mysql:host=localhost;dbname=testdb", "testuser", "testpass");
-    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
     $stmt = $conn->prepare("INSERT INTO tbl1 (`name`, `from`, `to`) VALUES (:name, :from, :to)");
     $stmt->bindParam(':name', $_POST['name']);
     $stmt->bindParam(':from', date('Y-m-d H:i:s'));
-    $toDT='2020-10-10 12:00:00';
     $stmt->bindParam(':to', $toDT);
     $stmt->execute();
   }
@@ -24,6 +33,9 @@ if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["name"]) && isset($_POS
 <meta charset="UTF-8">
 <title>Test table</title>
 <style>
+  #notice {
+    color: red;
+  }
   table {
     border-collapse: collapse;
   }
@@ -31,28 +43,25 @@ if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["name"]) && isset($_POS
     border: 1px solid black;
     padding: 0.3rem;
   }
-</style>
-<script>
-function subAction(action) {
-  var xhttp = new XMLHttpRequest();
-
-  xhttp.onreadystatechange = function() {
-    if(this.readyState == 4 && this.status == 200) {
-      console.log(this.responseText);
-    }
+  tbody tr:nth-child(even) {
+    background-color: #ccc;
   }
-  /*
-  xhttp.onload = function() {
-    console.log(this.responseText);
+  thead {
+    color: white;
+    background-color: black;
   }
-  */
-  xhttp.open("POST", "edit.inc.php", true);
-  xhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
-  xhttp.send("action=" + action);
-}
-</script>
+  .edit {
+    padding: 2px;
+    border-top: 1px solid #333;
+    border-left: 1px solid #333;
+    border-bottom: 1px solid #666;
+    border-right: 1px solid #666;
+    border-radius: 3px;
+  }
+</style>
 </head>
 <body>
+<p id="notice"></p>
 <form method="post">
 <label for="name">Name: </label>
 <input type="text" name="name" id="name">
@@ -69,15 +78,15 @@ function subAction(action) {
 try {
   echo "<table>\n";
   echo "<thead><tr><th>ID</th><th>From</th><th>To</th><th>Name</th><th>Actions</th></tr></thead><tbody>\n";
-  foreach ($conn->query("SELECT * FROM tbl1") as $row) {
+  foreach ($conn->query("SELECT * FROM tbl1 ORDER BY `id` DESC") as $row) {
     echo "<tr><td>" . $row['id'] . "</td>";
-    echo "<td>" . $row['from'] . "</td>";
-    echo "<td>" . $row['to'] . "</td>";
-    echo "<td contenteditable=\"true\">" . $row['name'] . "</td>";
+    echo "<td><div contenteditable=\"true\" class=\"edit\">" . $row['from'] . "</div></td>";
+    echo "<td><div contenteditable=\"true\" class=\"edit\">" . $row['to'] . "</div></td>";
+    echo "<td><div contenteditable=\"true\" class=\"edit\">" . $row['name'] . "</div></td>";
     echo "<td>";
-    echo "<button onclick=\"subAction('save')\">Save</button>";
-    echo "<button onclick=\"subAction('cancel')\">Cancel</button>";
-    echo "<button onclick=\"subAction('delete')\">Delete</button>";
+    echo "<button onclick=\"subAction('save', this)\">Save</button>";
+    echo "<button onclick=\"subAction('cancel', this)\">Cancel</button>";
+    echo "<button onclick=\"subAction('delete', this)\">Delete</button>";
     echo "</td></tr>\n";
   }
   echo "</tbody></table>\n";
@@ -86,5 +95,6 @@ catch (PDOException $e) {
   echo $e->getMessage();
 }
 ?>
+<script src="request.js"></script>
 </body>
 </html>