SQL statement to implement formatting function php code

小云云
Release: 2023-03-19 19:32:01
Original
1996 people have browsed it

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 who need it can refer to it. I hope it can help everyone.

1. Problem:

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

2. Solution:

Here we use the open source on github The code implements SQL formatting function.

github download address: https://github.com/till/sql-formatter

Or click here to download from this site.

Usage:

include contains the SqlFormatter.php file, and the formatting function can be achieved by using the format method for the sql statement.

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)),'%Y-%c-%d') 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);
?>
Copy after login

The running results are as shown below:

##Related recommendations:


Example sharing jQuery to implement simple date formatting function

js date formatting function

Extended JS Date object time formatting Small example of function_javascript skills

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

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!