Mercurial > nebulaweb3

comparison default/node_modules/jquery-tabledit/example.php @ 0:1d038bc9b3d2 default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Up:default
author Liny <dev@neowd.com>
date Sat, 31 May 2025 09:21:51 +0800
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:1d038bc9b3d2
1 <?php
2
3 // Basic example of PHP script to handle with jQuery-Tabledit plug-in.
4 // Note that is just an example. Should take precautions such as filtering the input data.
5
6 header('Content-Type: application/json');
7
8 $input = filter_input_array(INPUT_POST);
9
10 $mysqli = new mysqli('localhost', 'user', 'password', 'database');
11
12 if (mysqli_connect_errno()) {
13 echo json_encode(array('mysqli' => 'Failed to connect to MySQL: ' . mysqli_connect_error()));
14 exit;
15 }
16
17 if ($input['action'] === 'edit') {
18 $mysqli->query("UPDATE users SET username='" . $input['username'] . "', email='" . $input['email'] . "', avatar='" . $input['avatar'] . "' WHERE id='" . $input['id'] . "'");
19 } else if ($input['action'] === 'delete') {
20 $mysqli->query("UPDATE users SET deleted=1 WHERE id='" . $input['id'] . "'");
21 } else if ($input['action'] === 'restore') {
22 $mysqli->query("UPDATE users SET deleted=0 WHERE id='" . $input['id'] . "'");
23 }
24
25 mysqli_close($mysqli);
26
27 echo json_encode($input);