Tp5自动验证

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

<?php

class DB

{
private $address = 'mysql.21future.com';

private $username = 'manbang';

private $password = 'M8356b8356';

private $db = 'manbang';

private $table = 'fa_contacts';

private $con;

public function __construct()

{

$con = mysqli_connect($this->address,$this->username,$this->password,$this->db,'3306');

if (mysqli_connect_errno())

{

die('Could not connect: ' . mysql_error());

}else{

$con->set_charset('utf8');

$this->con=$con;

}

public function index(){

//2 创建sql

$_sql = "show full columns from ".$this->table;

$_result = $this->con->query($_sql);

while ($access= $_result->fetch_assoc()){

// echo "<pre>";

// dump($access);

$data[]=self::HandleArr($access);

}

$data=array_filter($data);

// return view('index',['data'=>$data]);

return $data;

}

public function data(){

$html="<?php\nnamespace app\对应的控制器\\validate;\n\nuse think\Validate;\n\nclass 模型 extends Validate\n{\n\tprotected \$rule = [%s];\n\tprotected \$message = [%s];\n\tprotected function checkphone(\$val,\$role,\$data){\n\t\tif(preg_match('/^1[34578]\d{9}$/', \$val)){\n\t\treturn true;\n\t}\n\t\treturn \$role;\n\t}\t\n}";
$arr=$_POST;
$res = array_map(function($val) {

return array_filter($val);

}, $arr);
$res=array_filter($res);
$rule="\n\t\t";

$message="\n\t\t";

foreach ($res as $key => $value) {

$rule .="'${key}' => '";

foreach ($value as $k => $v) {

//添加条件理由

if(strpos($k, '_'.md5(1))){

if(strpos($v,'@@')){

$valmsg=explode('@@', $v);

$v=$valmsg[0];

$msg=$valmsg[1];

}else{

$msg=$k.'的提示信息';

}

$rule .=str_replace('_'.md5(1),'', $k).":${v}|";

$message .="'${key}.".str_replace('_'.md5(1),'', $k)."' => '${msg}',\n\t\t";

}elseif(strpos($k, '_'.md5(2))){

$rule .=str_replace('_'.md5(2),'', $k).":${v}|";

}else{

$rule .="${k}|";

$message .="'${key}.${k}' => '$v',\n\t\t";

}

$rule=trim($rule,'|')."',\n\t\t";

}

$txt = sprintf($html,$rule,$message);

// print($rule);
// print($message);
if(file_put_contents('cheng.php', $txt,FILE_APPEND)){
echo 'success';
}else{
echo 'error';
}

die;

}

static public function HandleArr($arr)

{

if($arr['Field']=='id')

return [];

$preg='/^([a-z]+)$(\d+)(,?\d+)?$/';

preg_match($preg,$arr['Type'],$e);

@$len=['type'=>$e[1],'leng'=>$e[2]];

if($arr['Key']=='PRI'){

$arr['Null']='YES';

}

$must=$arr['Null']=='YES'?0:1;

return ['field'=>$arr['Field'],'leng'=>$len,'must'=>$must,'comment'=>$arr['Comment']];

}

if(isset($_GET['type'])){

$obj = new DB();

$data=$obj->data();

}else{

$obj = new DB();

$data=$obj->index();

}

<!DOCTYPE html>

<head>

<title>Document</title>

<style>

@charset "UTF-8";

/*css 初始化 */

html, body, ul, li, ol, dl, dd, dt, p, h1, h2, h3, h4, h5, h6, form, fieldset, legend, img { margin:0; padding:0; }

fieldset, img,input,button { border:none; padding:0;margin:0;outline-style:none; } /*去掉input等聚焦时的蓝色边框*/

ul, ol { list-style:none; }

input { padding-top:0; padding-bottom:0; font-family: "SimSun","宋体";}

select, input { vertical-align:middle;}

select, input, textarea { font-size:12px; margin:0; }

textarea { resize:none; } /*防止拖动*/

img {border:0; vertical-align:middle; } /* 去掉图片低测默认的3像素空白缝隙，或者用display：block也可以*/

table { border-collapse:collapse; }

body {

font:12px/150% Arial,Verdana,"\5b8b\4f53";

color:#666;

background:#fff

}

.clearfix:before,.clearfix:after { /*清楚浮动*/

content:"";

display:table;

}

.clearfix:after{clear:both;}

.clearfix{

*zoom:1;/*IE/7/6*/

}

a {color:#666; text-decoration:none; }

a:hover{color:#C81623;}

h1,h2,h3,h4,h5,h6 {text-decoration:none;font-weight:normal;font-size:100%;} /*设置h标签的大小，设置跟父亲一样大的字体font-size:100%;*/

s,i,em{font-style:normal;text-decoration:none;}

.col-red{color: #C81623!important;}

/*公共类*/

.w { /*版心提取 */

width: 1210px;margin:0 auto;

}

.fl {

float:left

}

.fr {

float:right

}

.al {

text-align:left

}

.ac {

text-align:center

}

.ar {

text-align:right

}

.hide {

display:none

}

.addv{

height: 30px;

border-radius:15px;

outline:none;

}

.font12{ font-size: 12px;}

.font14{ font-size: 14px;}

.font16{ font-size: 16px;}

body{

background:#D9D7D7FF;

}

div{

margin-top:10px;

}

.header{

text-align: center;

font-size: 40px;

height: 44px;

width: 80%;

margin: 0 auto;

line-height: 44px;

}

.content{

padding-left: 32%;

width: 80%;

font-size: 20px;

}

#title{

font-size: 25px;

padding-left: 30%;

}

.g{

color:#f40;

}

.c{

color:#4FF458FF;

}

.block{

line-height: 25px;

font-size: 22px;

}

</style>

/*! jQuery v3.3.1 | (c) JS Foundation and other contributors | jquery.org/license */

</script>

</head>

<body>

TP5自动验证

</div>

<?php

foreach ($data as $key => $vo) {

# code...

<span class="c">必选：</span><input type="radio" name="<?php echo $vo['field']; ?>[require]" <?php if($vo['must']==1)echo 'checked';?> value="<?php echo $vo['comment']; ?>不可为空">

<span class="g">可选：</span><input type="radio" name="<?php echo $vo['field']; ?>[require]" <?php if($vo['must']==0)echo 'checked';?> value="">

<option value="phonenumber" msg="2">验证手机号</option>

<option value="alphaNum">字母和数字</option>

<option value="alphaDash">字母和数字_</option>

<option value="chsAlpha">汉字和字母</option>

<option value="chsDash">汉字字母数字和下划线_-</option>

<option value="url">URL地址</option>

<option value="dateFormat:y-m-d">dateFormat:y-m-d</option>

<option value="in" msg="1">在指定几个值内</option>

<option value="notIn" msg="1">不在在指定几个值内</option>

<option value="notBetween" msg="1">在某个范围</option>

<option value="length" msg="1">字符长度或指定长度</option>

<option value="begin_time" msg="1">证某个字段的值是否在某个日期之前before:2016-10-01</option>

<option value="expire_time" msg="1">expire:2016-2-1,2016-10-01</option>

<option value="allowIp" msg="1">允许allowIp:114.45.4.55</option>

<option value="denyIp" msg="1">禁用denyIp:114.45.4.55</option>

<option value="confirm" msg="1">验证某个字段是否和另外一个字段的值一致</option>

<option value="different" msg="1">验证某个字段是否和另外一个字段的值不一致</option>

<option value="egt" msg="1">大于等于某值</option>

<option value="elt" msg="1">小于等于某值</option>

<option value="activeUrl">域名或IP</option>

</select>

</div>

<?php

}

</form>

</body>

$('.addv').change(function(){

var name=$(this).parents('.content').attr('data')

var val=$(this).val();

if(val==''){

return

}

var text=$(this).find("option:selected").text()

switch ($(this).find("option:selected").attr('msg')) {

case '1':

var html='<div><input type="text" name="'+name+'['+val+'_<?php echo md5(1); ?>]" value="" placeholder="添加所需内容@@错误提示"><span class="del">X</span></div>';

break;

case '2':

var html='<div><input type="text" name="'+name+'['+val+'_<?php echo md5(2); ?>]" value="请填写正确填写'+text+'"><span class="del">X</span></div>';

break;

default:

var html='<div><input type="text" name="'+name+'['+val+']" value="请填写正确填写'+text+'" placeholder=""><span class="del">X</span></div>'

break;

}

$(this).parents('.content').append(html)

})

$("body").delegate(".del","click",function(){

$(this).parent().remove()