Fading Coder

One Final Commit for the Last Sprint

2019 lovesql Challenge Analysis

Upon inspection of the URL, it shows: check.php?username=admin&password=password. To proceed, a SQL injection test is performed using the universal bypass technique: Username: 1' or 1=1# Password: 123 (any input) This reveals the actual username is admin and the password hash is 8cd498400535134...

Exploiting SQL Injection by Bypassing Client-Side Encryption

During a security assessment of a web application at http://aa.test.com:8088/Admin/Login, a SQL injection vulnerability was identified. The login request revealed that the username and password parameters were encrypted on the client side before transmission. Analysis of the page's JavaScript source...

Exploiting Order By Clauses for Blind SQL Injection

In SQL injection scenarios where the ORDER BY clause processes user input, data extraction can be performed through blind techniques. The method relies on observing differences in sorting behavior when conditions evaluate to true or false. Exploitation Technique The RAND() function comibned with con...

Preventing SQL Injection with JDBC PreparedStatement

Parameter Binding for Security package com.database.security; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.Scanner; public class AuthenticationHandler { private static final String DB_URL = "jdbc:mysql://lo...

MySQL Table Operations, pymysql, and SQL Injection

1. Basic SQL Statements Query (SELECT) Retrieve data using SELECT, with support for wildcrads (*), column names, arithmetic operations, or aggregate functions. Use AS for aliases (optional): SELECT name, (math + english)/2 AS avg_score FROM students; Insert (INSERT) Add new records (single/multiple...

Common SQL Injection WAF Bypass Techniques

WAF Detection Mechanism WAFs intercept traffic by matching patterns against a rule database. When sensitive characters are detected, the request gets blocked. Case Manipulation Bypass Some WAFs only match exact case patterns—either all uppercase or all lowercase. Mixed-case inputs may slip through s...

SQL Injection CTF Challenge: Extracting Flag from Vulnerable Parameter

Challenge Overview Source: BUUCTF Platform Objective: Retrieve the flag value. Approach The challenge presents a web page with minimal visible content. The URL contains a query parameter ?id=1, indicating this is a standard SQL injection vulnerability. Determining Injection Type First, test whether...

Web Authentication Implementation and Common Vulnerability Exploitation

HTML Frontend Construction Deploy Apache web server and verify functionality via loopback address. Create authentication interfaces within the web root directory. <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Secure Portal<...

Comprehensive Classification and Detailed Analysis of SQL Injection Techniques

SQL injection occurs when user input is directly concatenated into backend SQL queries without proper validation or sanitization. This vulnerability allows attackers to manipulate SQL statements, potentially enabling unauthorized database operations such as data retrieval, modification, or deletion....

Parameter Binding Strategies in MyBatis: Security and Performance Implications

MyBatis provides two distinct syntaxes for injecting dynamic values into SQL statements. Consider retrieving records from an employee table based on an email address: SELECT * FROM employee WHERE email = 'alice@example.com'; To make this query dynamic, MyBatis offers two approaches: SELECT * FROM em...