It is necessary to understand PHP code security

The attacker sends malicious SQL commands to the database through construction. If the program does not perform judgment filtering on the SQL commands entered by the user, the generated SQL statements may bypass the security check, insert other statements used to modify the back-end database, and may execute system commands, thus causing harm t ...

Posted on Thu, 14 Nov 2019 05:46:29 -0800 by bhagwat

Open Source Project: Zhang Shuai's Personal Blog

[Actual Warfare] How to quickly create dynamic web pages through html+css+mysql+php (listed as making a blog site) To complete the school's final course design, it took nearly two months of leisure to create a simple blog site.Next, I will describe the process of these days. At the end of the text, some code will be pasted and a download link w ...

Posted on Tue, 12 Nov 2019 17:56:30 -0800 by jorje

Technology sharing | MySQL: timestamp time zone conversion leads to high CPU% sys

Author: Gao PengAt the end of the article, there is his book "in-depth understanding of MySQL master-slave principle 32", in-depth understanding of MySQL master-slave, GTID related technical knowledge. This is a learning record. Please understand if there is any mistake. This problem is a friend's @ situation, and this friend has rea ...

Posted on Tue, 12 Nov 2019 02:13:42 -0800 by imnsi

Technology sharing | MySQL: timestamp time zone conversion leads to high CPU% sy

Author: Gao Peng At the end of the article, there is his book "in-depth understanding of MySQL master-slave principle 32", in-depth understanding of MySQL master-slave, GTID related technical knowledge. This is a learning record. Please understand if there is any mistake. This problem was encountered by a friend @ Fengyun , and thi ...

Posted on Tue, 12 Nov 2019 02:01:45 -0800 by mars16

java connect database

This time, I want to record the connection between java and database and display the data. The effect start interface is as follows   This application uses MySQL to access the database, which contains a students class. The code is as follows CREATE TABLE students( id serial NOT NULL, name character VARCHAR(10), age int, ...

Posted on Mon, 11 Nov 2019 13:18:07 -0800 by pestilence669

Massive data display (2) - Performance Optimization

background The massive data display done before                               . Get ready      software environment: PostGIS(3.0.0rc2 r17909) and PostgreSQL (12.0, compile ...

Posted on Sun, 10 Nov 2019 09:24:33 -0800 by sws

Using Spring AbstractRoutingDataSource to manage multiple data sources

1. Principle of multi data switching: the core of multi data source dynamic switching is that the bottom layer of spring provides AbstractRoutingDataSource class for data source routing. We mainly inherit this class and implement the methods in it. The main implementation method is: determineCurrentLookupKey(), which only needs to return the ...

Posted on Sun, 10 Nov 2019 09:02:12 -0800 by gauravupadhyaya

There is no scott account in PLsql/Oracle database, how to create and unlock it

Of course, first of all, install Oracle 11g Then there should be sqlplus, which should be matched with Oracle11g Enter the main topic, if oracle/plsql does not have a scott account, how to create First find soctt.sql in the Oracle installation directory What I am doing is: E:\app\91959\product\11.2.0\dbhome_1\admin If soctt.sql is not ava ...

Posted on Sat, 09 Nov 2019 13:26:45 -0800 by inerte

Mybaits Source Parsing - - The most detailed network, none of them: Level 1 Cache and Level 2 Cache Source Analysis

ORM frameworks like Mybatis and Hibernate encapsulate most of the operations of JDBC, greatly simplifying our operations on the database. In a real project, we found that when we query the same statement twice in a transaction, we did not query the database the second time and returned the result directly. In this case, we can call it caching. ...

Posted on Fri, 08 Nov 2019 20:45:49 -0800 by oscar2

MySQL containerization detailed tutorial

Preface: The previous article introduced the installation of Docker tool and the use of common commands. In this article, we will introduce how to run MySQL instance in Docker. Some small partners may ask: why run MySQL in Docker? Because it is easy to deploy MySQL instance in Docker, it does not need to consider the dependency differences such ...

Posted on Thu, 07 Nov 2019 22:15:09 -0800 by syacoub