在做php开发,每次需要看sql语句,忽然间觉得要是把sql格式化了看多好,于是在internet上搜了下sql formate的库,自己做改造了下,还不错,看截图,
下载个php 解析sql的库
index.php的代码:
<html>
<head>
<title>
Welcome to php sql formater!
</title>
<link rel="stylesheet" href="sqlparserlib/sqlsyntax.css" />
<style>
.blc{display:inline;} body{background-color:#E3E3E3;} form{margin-top:50px;margin-left:20px;}
</style>
</head>
<body>
<?php error_reporting(0); define( "PARSER_LIB_ROOT", dirname(__FILE__).
"/sqlparserlib/"); require_once PARSER_LIB_ROOT. "sqlparser.lib.php"; function SQLFormatPHP($sql){
return PMA_SQP_formatHtml(PMA_SQP_parse($sql)); } $sql=t rim($_REQUEST[
'sql']); ?>
<form action="<?php echo $_SERVER['PHP_SELF']?>" method="post">
<div class="blc">
<div style="float:left; border:1px solid #DBEAF9;">
<textarea name="sql" style="width:500px;height:400px;background-color:#63E940">
</textarea>
</div>
<div style="border:1px solid #DBEAF9;margin-left:520px;width:500px;overflow: scroll;height:400px;background-color:#FFFFFF;">
<?php echo $sql?SQLFormatPHP($sql): "";?>
</div>
</div>
<div style="clear:both;">
</div>
<div style="margin-top:10px;">
<input type="submit" value="EXEC FORMATE" style="background-color:#DBEAF9;height:30px; margin-left: 460px;">
</div>
</form>
</body>
</html>