简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > php教程 > php手册 > body text

phpmyadmin把sql语句改为base64传输

WBOY
Release： 2016-06-13 09:50:52
Original
1034 people have browsed it

因为服务器上安装了安全狗这个功能，我们直接的sql是不能使用的，下面我来给各位同学介绍介绍一下phpmyadmin把sql语句改为base64传输来解决这个问题。

1.首先 修改 libraries/header.inc.php

将 js base64 的函数 粘贴到 第 61 行

2.然后 修改 js/sql.js

找到 $("#sqlqueryform.ajax").live("submit",function(a){ 这一段

改为下面这样,

 代码如下 复制代码

$("#sqlqueryform.ajax").live("submit",function(a){
  a.preventDefault();
  var b=$(this);
  if(!checkSqlQuery(b[0]))return false;
  $(".error").remove();
  var c=PMA_ajaxShowMessage(),e=$("#sqlqueryresults");
  PMA_prepareForAjaxRequest(b);
  $('#sqlquery').val( Base64.encode( $('#sqlquery').val() )  );
  $.post(b.attr("action"),b.serialize(),function(d){

 
3.最后修改 import.php


import.php 文件第24行 插入

 代码如下 复制代码


$sql_query=base64_decode($sql_query);


ok 现在 如果是通过点击 sql 输入的查询 全部会通过base64编码后 再进行传输了 ，可以躲过安全狗之类的安全防御软件的拦截

Related labels：
base64 phpmyadmin sql superior transmission Function install Safety us Bundle server dog statement this
source：php.cn
Previous article：php json与数组互转支持中文 Next article：微信公众平台之CURL应用
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Unable to establish external connection to MySQL/MariaDB database I'm trying to connect a MariaDB client (DBeaver) to my database from my home computer. The...
From 2024-03-31 23:39:43
0
1
302
Docker Image: Integration of PHP 8.0, Apache and phpMyAdmin I'm creating an image for a php8 project running on apache and using phpMyAdmin, my Docker...
From 2024-03-31 18:19:17
0
1
306
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！