[red sun Day12 CTF] SQL injection caused by htmlentities

Exercise notes Recurrence Code: index.php <?php require 'config.php'; if(isset($_REQUEST['username'])){ if(preg_match("/(?:\w*)\W*?[a-z].*(R|ELECT|OIN|NTO|HERE|NION)/i", $_REQUEST['username'])){ die("Attack detected!!!"); } } if(isset($_REQUEST['password'])){ if(preg_match( ...

Posted on Sun, 19 Jan 2020 09:50:36 -0500 by Kingskin

Common functions in MySQL

1. String function length(a) gets the length of string a concat(a,b,c) splices multiple values into a string trim(a) remove the space at the beginning and end of string a replace(a,b,c) replace the b string in string a with C subString(str,index,len) intercepts the string str from the index char ...

Posted on Sun, 19 Jan 2020 00:42:01 -0500 by Murciano

09-06 reflection and built-in method

One reflection In Python, reflection refers to manipulating the properties of an object through a string, involving the use of four built-in functions (all objects in Python, classes and objects can use the following four methods) class Teacher: def __init__(self,full_name): self.full_name =full_name t=Teacher('Egon Lin') # hasa ...

Posted on Sat, 18 Jan 2020 09:49:04 -0500 by littlehelp

Function syntax of MySQL database

Learning objectives: master the following sql functions Digital function: format ABS mod ceil floor ground expCharacter function: upper lower char > length concat instrDate function: now date? Format date? Add DateDiff if ifnullConditional function: Numeric function First batch of digital functi ...

Posted on Fri, 17 Jan 2020 09:10:21 -0500 by DKY

Chapter 22 nine analysis takes you through helm3 sonarqube

This series: Chapter 1: Nine analysis takes you easy to finish the installation of helm3 The second chapter: Nine analysis takes you to the public warehouse of helm3 The third chapter: Nine analysis takes you through the explosion of helm3 private warehouse easily The fourth chapter: Nine analysis takes you easy The fifth chapter: Nine analy ...

Posted on Thu, 16 Jan 2020 13:34:51 -0500 by reli4nt

Hand in hand to teach you MySQL query optimization analysis

Preface MySQL is a kind of relational database, which has strong query function, high data consistency, high data security and supports secondary index. However, the performance is slightly inferior to that of non relational databases, especially for data above one million levels, which is easy to cause slow query. At this time, we need to ana ...

Posted on Thu, 16 Jan 2020 02:02:29 -0500 by nuying117

KeepAlived guarantees Mysql auto-switch

Environmental preparation Previous articles paved the way for MySQL master slave building: Article 1: Common settings for Binlog in MySQL Article 2: MySQL Master-Slave Synchronization-Principle-Practice Start the two mysql servers for Master and Slave with the following information: ➜ ~ docker ps -a CONTAINER ID IMAGE ...

Posted on Wed, 15 Jan 2020 21:08:24 -0500 by powergen

MySQL Master-Slave Synchronization-Principle-Practice

What is mysql's master-slave replication? MySQL master-slave replication refers to the replication of data from one MySQL database server master node to one or more slave nodes.MySQL replicates asynchronously by default, so that the master server is not always accessed by the slave node to update its own data, which can be updated over a remote ...

Posted on Wed, 15 Jan 2020 20:55:58 -0500 by Cinquecento

Technology sharing | some MySQL DBA practical SQL statements

Author: Du Kaisheng Contents: 1, Connection related 2, Long affairs 3, Metadata lock 4, Lock wait 5, Global read lock 6, Memory usage monitoring 7, Partition table 8, Database information overview 9, Tables not updated for a long time 10, Primary key, index 11, Storage engine 12, Real time load Reading tips: 1) This article involves a lar ...

Posted on Wed, 15 Jan 2020 04:10:52 -0500 by johnsonzhang

Dockerfile theory + practice!!!

Dockerfile overview   Dockerfile is the description file of the image file in docker. The straight white point is exactly what the image file is composed of step by step.  for example: you bought a hanger on Taobao, but the seller did not send you a complete hanger, but some components and a drawing. You assemble the hanger step by ...

Posted on Wed, 15 Jan 2020 03:25:46 -0500 by venom999