[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

A trial of customizing mybaits framework

Article directory Preface Realization `pom` dependence `xml ` parsing class ` XMLConfigBuilder` The 'SqlSession' series of database transactions Abstract factory ` SqlSessionFactory` Default implementation factory ` DefaultSqlSessionFactory` Default implementation ` DefaultSqlSession` Builder mode ...

Posted on Sat, 18 Jan 2020 07:20:39 -0500 by konrados

Analysis of the implementation process and principle of the ORM of Mybatis

Article directory Preface First case Stepwise analysis Preface Go back to basics. Today, let's see the execution process of mybatis. First case 1, The first is the configuration file. You need an xml configuration file <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration ...

Posted on Sat, 18 Jan 2020 07:05:31 -0500 by gromer

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

The principle of color image acquisition of OV7725 camera and LCD display "one"

The principle of color image acquisition of OV7725 camera and LCD display "one" Original ...

Posted on Thu, 16 Jan 2020 22:58:49 -0500 by hustler

Django Web framework teaching notes

Catalog Article directory Catalog Query data Field lookup query predicate Modify data record Delete record Aggregate query F object Q object - Q() Native database operation method Query data The query of database needs to use manager object Call the query interface through the MyModel.ob ...

Posted on Thu, 16 Jan 2020 10:21:54 -0500 by scotchegg78

MyBatis plug in development

1. Principle of mybatis plug-in MyBatis has plug-ins involved in the creation of four objects. The plug-in can use the dynamic proxy mechanism to wrap the target object layer by layer, and achieve the effect of intercepting before the target object executes the target method. When creating four object ...

Posted on Thu, 16 Jan 2020 10:20:49 -0500 by thirdeye

Spark.ml -- Naive Bayes

Preface Naive Bayes classifier is a classifier with low variance and high deviation. It assumes that there is conditional independence between each feature: for a given category, all features are independent of each other. Obviously, this assumption makes the problem too simple, but naive Bayes does ...

Posted on Thu, 16 Jan 2020 10:05:20 -0500 by sp2hari

SqlServer common commands

Article directory 1, SQL Basics Two, enhance Three, function Four, actual combat 1.SELECT 2.Update 3. table / field 4. Index (add, delete, modify and check) Like 👍 pay attention ❤ don't get lost 1, SQL Basics 1.query SELECT Column name FROM Table name 2.Duplicate removal SELECT DISTINCT Colum ...

Posted on Thu, 16 Jan 2020 07:32:51 -0500 by kaumilpatel

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