Source of file mysql-rpc-demo.php
Size: 1,127 Bytes - Last Modified: 2021-12-24T05:19:33+00:00
/var/www/docs.ssmods.com/process/src/webconsole/src/vendor/jquery.terminal/examples/mysql-rpc-demo.php
1234567891011121314151617181920212223242526272829303132333435363738394041424344 | <?php require('json-rpc.php'); if (function_exists('xdebug_disable')) { xdebug_disable(); } $link = new mysqli('localhost', 'user', 'password', 'db_name'); class MysqlDemo { public function query($query) { global $link; if (preg_match("/create|drop/", $query)) { throw new Exception("Sorry you are not allowed to execute '" . $query . "'"); } if (!preg_match("/(select.*from *test|insert *into *test.*|delete *from *test|update *test)/", $query)) { throw new Exception("Sorry you can't execute '" . $query . "' you are only allowed to select, insert, delete " . "or update 'test' table"); } if ($res = $link->query($query)) { if ($res === true) { return true; } if ($res->num_rows > 0) { while ($row = $res->fetch_array(MYSQLI_NUM)) { $result[] = $row; } return $result; } else { return array(); } } else { throw new Exception("MySQL Error: " . mysql_error()); } } } handle_json_rpc(new MysqlDemo()); ?> |