PHP Libraries

Other libraries

PHP library for formatting SQL statements

Other libraries

Get it now

PHP library for formatting SQL statements

<?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 \&quot;testing\&quot;);\"</code></pre>";
echo "<pre><code>echo \"SELECT * FROM MyTable WHERE (id>5 AND \`name\` LIKE \&quot;testing\&quot;);\" | 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.

Disclaimer

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

Which Open-Source Java Library Best Parses SQL Statements, Allowing for Customization and SQL Standard Adherence?

18Jan2025

Identifying SQL Parsing Libraries for JavaDevelopers seeking an open-source Java library for parsing SQL statements face two primary...

How Do I Link Static Libraries That Depend on Other Static Libraries?

13Dec2024

Linking Static Libraries to Other Static Libraries: A Comprehensive ApproachStatic libraries provide a convenient mechanism to package reusable...

How to Optimize PHP Prepared Statements for SQL Injection Avoidance?

21Oct2024

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