php mysql 语句生成工具,php 之批量生成 mysql 语句注释

悠悠 2023-01-17 03:20 156阅读 0赞

parent::\_\_construct();/\*加载项\*/

$this->load->model('Convers', 'conv');

\}/\*\*

/\*\*

\* 获取所有数据\*/

public functionceshi()\{//获取所有的账户信息

$result=$this->conv->getAdmininfo();//获取所有的专家信息

$result11=$this->conv->getPart11();//循环账户信息

//获取账户的uid和名称

//将名称和专家的单位想比较 然后进行替换uid

foreach($result as $val)\{foreach($result11 as $val1)\{//这里更新的是 某些数据没有单位 是以id显示的 所以统一更新为单位

// if($val1\['danweimingcheng\_12'\]!==$val1\['xuhao\_12'\])\{

// $a=$this->conv->SaveName($val1\['id'\],$val1\['danweimingcheng\_12'\]);

// if($a>0)\{

// echo "更新成功单位为".$val1\['danweimingcheng\_12'\]."";

// \}

// \}else\{

// continue;

// \}

if($val\['admin\_name'\]==$val1\['xuhao\_12'\])\{$a=$this->conv->SaveUid($val1\['id'\],$val\['admin\_id'\]);if($a>0)\{echo "更新成功ID为".$val1\['id'\]."";

\}else\{continue;

\}public functionuptijiao()\{//省厅提交 学校提交

$result11=$this->conv->getPart11();$result=$this->conv->getAdmininfo();//学校提交为1; xx\_tijiao

//省厅提交为1 st\_tijiao

foreach($result as $val)\{foreach($result11 as $val1)\{if($val1\['uid'\]==$val\['admin\_id'\])\{$data\['xx\_tijiao'\]=1;$data\['st\_tijiao'\]=1;$a=$this->conv->SaveST($val1\['id'\],$data);if($a>0)\{echo "更新成功ID为".$val1\['id'\]."";

\}else\{continue;

\}//获取表的注释:

public functiongetdescs()\{//获取表结构

$talbe=$this->conv->getTable();foreach($talbe as $v)\{echo "--当前表:".$v."----";//var\_dump($this->conv->getDesc($v));

$ceshi=$this->conv->getDesc($v);//循环查询表的字段信息

foreach($ceshi as $val)\{//$this->AlterContent($v,$val);

if($val\['Collation'\]=="utf8\_general\_ci")\{$where="CHARACTER SET utf8 COLLATE \{$val\['Collation'\]\}";

\}else\{$where="";

\}if($val\['Null'\]=="YES")\{$nus="NULL";

\}else\{$nus="NOT NULL";

\}if($val\['Default'\]=="NULL")\{$defaul=" ";

\}else\{$defaul="DEFAULT '\{$val\['Default'\]\}' ";

\}echo "ALTER TABLE \`\{$v\}\` CHANGE \`\{$val\['Field'\]\}\` \`\{$val\['Field'\]\}\` \{$val\['Type'\]\} \{$where\} \{$nus\} \{$defaul\} COMMENT '\{$val\['Comment'\]\}';"."";

\}//情况分析第一种

function AlterContent($v,$val)\{//编码不为null 但是 允许空值

if($val\['Collation'\]=="utf8\_general\_ci" && $val\['Null'\]=="YES")\{echo "ALTER TABLE \{$v\} CHANGE \{$val\['Field'\]\} \{$val\['Field'\]\} \{$val\['Type'\]\} CHARACTER SET utf8 COLLATE \{$val\['Collation'\]\} NULL DEFAULT \{$val\['Default'\]\} COMMENT '\{$val\['Comment'\]\}';"."";

\}//编码不为null 但是不 允许空值

if($val\['Collation'\]=="utf8\_general\_ci" || $val\['Null'\]=="No")\{echo "ALTER TABLE \{$v\} CHANGE \{$val\['Field'\]\} \{$val\['Field'\]\} \{$val\['Type'\]\} CHARACTER SET utf8 COLLATE \{$val\['Collation'\]\} NOT NULL DEFAULT '\{$val\['Default'\]\}' COMMENT '\{$val\['Comment'\]\}';"."";

\}if($val\['Collation'\]!="utf8\_general\_ci" || $val\['Null'\]=="YES")\{echo "ALTER TABLE \{$v\} CHANGE \{$val\['Field'\]\} \{$val\['Field'\]\} \{$val\['Type'\]\} CHARACTER SET utf8 COLLATE \{$val\['Collation'\]\} NOT NULL DEFAULT '\{$val\['Default'\]\}' COMMENT '\{$val\['Comment'\]\}';"."";

\}if($val\['Collation'\]!="utf8\_general\_ci" || $val\['Null'\]=="No")\{echo "ALTER TABLE \{$v\} CHANGE \{$val\['Field'\]\} \{$val\['Field'\]\} \{$val\['Type'\]\} CHARACTER SET utf8 COLLATE \{$val\['Collation'\]\} NOT NULL DEFAULT '\{$val\['Default'\]\}' COMMENT '\{$val\['Comment'\]\}';"."";