PHP implements SQL statement formatting function

This article mainly introduces the method of implementing SQL statement formatting function in PHP. The SQL statement formatting function is implemented based on the open source code on github. It is very simple and practical. Friends in need can refer to the example of this article

Describes how PHP implements the SQL statement formatting function. Share it with everyone for your reference, the details are as follows:

1. Question:

Requires the use of php to implement the formatting function for sql statements

2. Solution:

The specific code is as follows:

<?php
include(&#39;SqlFormatter.php&#39;);
$sql="SELECT DATE_FORMAT(b.t_create, &#39;%Y-%c-%d&#39;) dateID, b.title memo
  FROM (SELECT id FROM orc_scheme_detail d WHERE d.business=208
  AND d.type IN (29,30,31,321,33,34,3542,361,327,38,39,40,41,42,431,4422,415,4546,47,48,&#39;a&#39;,
  29,30,31,321,33,34,3542,361,327,38,39,40,41,42,431,4422,415,4546,47,48,&#39;a&#39;)
  AND d.title IS NOT NULL AND t_create >=
  DATE_FORMAT((DATE_SUB(NOW(),INTERVAL 1 DAY)),&#39;%Y-%c-%d&#39;) AND t_create
  < DATE_FORMAT(NOW(), &#39;%Y-%c-%d&#39;) ORDER BY d.id LIMIT 2,10) a,
  orc_scheme_detail b WHERE a.id = b.id";
echo SqlFormatter::format($sql);
?>

The running results are shown below:

Related recommendations:

How to use vue.js to achieve pricesFormatting (code attached)

Vue filterFormattingDetailed explanation of method

PythonFormattingOutput %s and %d

# #

The above is the detailed content of PHP implements SQL statement formatting function. For more information, please follow other related articles on the PHP Chinese website!