aboutsummaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
Diffstat (limited to 'test')
-rw-r--r--test/index.php66
-rw-r--r--test/request.js38
2 files changed, 76 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>
diff --git a/test/request.js b/test/request.js
new file mode 100644
index 0000000..bfcf592
--- /dev/null
+++ b/test/request.js
@@ -0,0 +1,38 @@
+function subAction(action, btn) {
+ trDom = btn.parentElement.parentElement;
+ trData = trDom.children;
+
+ trId = trData[0].innerHTML;
+ trFrom = trData[1].innerHTML;
+ trTo = trData[2].innerHTML;
+ trName = trData[3].innerHTML;
+
+ console.log(trId);
+ console.log(trFrom);
+ console.log(trTo);
+ console.log(trName);
+
+ //for (var i = 0, len = trData.length - 1; i < len; i++) {
+ //console.log(i + ": " + trData[i].innerHTML);
+ //}
+
+ if (action == 'delete')
+ if (confirm("Are you sure you want to delete this reservation?"))
+ trDom.remove();
+
+ // Send XHR
+ var xhttp = new XMLHttpRequest();
+ xhttp.onreadystatechange = function () {
+ if (this.readyState == 4 && this.status == 200) {
+ document.getElementById("notice").innerHTML = this.responseText;
+ }
+ }
+ xhttp.open("POST", "edit.inc.php", true);
+ xhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
+ data_str = "action=" + action
+ data_str += "&id=" + trId
+ data_str += "&from=" + trFrom
+ data_str += "&to=" + trTo
+ data_str += "&name=" + trName
+ xhttp.send(data_str);
+}