<?php
if(php_sapi_name() !== "cli") {
echo "<p>Run this php script from the command line to see CLI syntax highlighting and formatting. It support Unix pipes or command line argument style.</p>";
echo "<pre><code>php examples/cli.php \"SELECT * FROM MyTable WHERE (id>5 AND \`name\` LIKE \"testing\");\"</code></pre>";
echo "<pre><code>echo \"SELECT * FROM MyTable WHERE (id>5 AND \`name\` LIKE \"testing\");\" | php examples/cli.php</code></pre>";
}
if(isset($argv[1])) {
$sql = $argv[1];
}
else {
$sql = stream_get_contents(fopen("php://stdin", "r"));
}
require_once(__DIR__.'/../lib/SqlFormatter.php');
echo SqlFormatter::format($sql);Simply put, formatting is to initialize the disk so that we can record data on the disk step by step. For example, if we have a big house to store books, we will not move the books in and throw them on the floor. Instead, we will first set up bookshelves inside, mark them with categories, and put the books in categories.
Structured Query Language (Structured Query Language), referred to as SQL, is a database query and programming language used to access data and query, update and manage relational database systems;
sql statement is a language used to operate the database.
All resources on this site are contributed by netizens or reprinted by major download sites. Please check the integrity of the software yourself! All resources on this site are for learning reference only. Please do not use them for commercial purposes. Otherwise, you will be responsible for all consequences! If there is any infringement, please contact us to delete it. Contact information: admin@php.cn
Related Article
Explanation of id=%d for SQL query statements in PHP
22 Dec 2016
Many friends don’t know the meaning of id=%d in SQL query statement in PHP. Today, through this article, I will give you a detailed explanation of id=%d in SQL query statement in PHP. Friends who need it can refer to it.
How to write SQL statements for paging queries using PHP
03 Apr 2023
With the popularity of Web applications, many websites require paging query functions. PHP is a very popular web development language, and its built-in database access functions are also very powerful. This article will introduce how to use PHP to write SQL statements for paging queries. 1. What is paging query? Paging query refers to displaying a query result in pages, with only a fixed number of records displayed on each page. Generally speaking, paging query requires the following parameters: - The number of records displayed on each page - The page number to be displayed - The total number of records Through these parameters, we can calculate the current page that needs to be displayed
How to Optimize PHP Prepared Statements for SQL Injection Avoidance?
21 Oct 2024
This article presents best practices for optimizing PHP prepared statements to prevent SQL injections. It emphasizes the crucial steps of error checking, binding parameters correctly, avoiding manual escaping, and setting parameters after binding. Ad
29 Jul 2016
SQL language programming learning: SQL language programming learning implementation code for escaping mysql statements in PHP: It is impossible for you to manually escape every such special character, not to mention that you usually deal with the content that is automatically submitted by the form. Therefore, the mysql_real_escape_string function should be used: mysql_real_escape_string — Escapes special characters in strings used in SQL statements, taking into account the current character set of the connection. But note: this function does not escape % and _. In addition, it is best not to use this function for the entire sql statement, but only to escape the string passed into the sql statement.
Detailed explanation of the steps for php to parse xml and generate sql statements
19 May 2018
This time I will bring you a detailed explanation of the steps for php to parse xml and generate sql statements. What are the precautions for php to parse xml and generate sql statements? The following is a practical case, let's take a look.
How to import third-party libraries in ThinkPHP
03 Jun 2023
Third-party class libraries Third-party class libraries refer to other class libraries besides the ThinkPHP framework and application project class libraries. They are generally provided by third-party systems or products, such as class libraries of Smarty, Zend and other systems. For the class libraries imported earlier using automatic loading or the import method, the ThinkPHP convention is to use .class.php as the suffix. Non-such suffixes need to be controlled through the import parameters. But for the third type of library, since there is no such agreement, its suffix can only be considered to be php. In order to easily introduce class libraries from other frameworks and systems, ThinkPHP specifically provides the function of importing third-party class libraries. Third-party class libraries are uniformly placed in the ThinkPHP system directory/
Hot Tools
PHP library for dependency injection containers
PHP library for dependency injection containers
A collection of 50 excellent classic PHP algorithms
Classic PHP algorithm, learn excellent ideas and expand your thinking
Small PHP library for optimizing images
Small PHP library for optimizing images