Home >Backend Development >PHP Tutorial >First introduction to general database operation classes - front-end easyui-datagrid, form (php), easyuidatagrid_PHP tutorial
First introduction to general database operation classes - front-end easyui-datagrid, form (php), easyuidatagrid_PHP tutorial
- WBOYOriginal
- 2016-07-13 09:45:201004browse
First introduction to general database operation classes - front-end easyui-datagrid, form (php), easyuidatagrid
First introduction to general database operation classes - front-end easyui-datagrid, form (php ), the implementation code is relatively simple. Please see below for the specific implementation steps.
Function implementation:
The datagrid on the left displays brief information, the right displays detailed information on the selected row, and database additions, deletions and modifications
(1) Click to select a row, and detailed information will be displayed on the right. The [Add], [Modify], and [Delete] buttons are available, and the [Save] button is disabled
(2) Click the [Add] button, the [Modify] and [Delete] buttons are disabled, and the [Save] button is enabled
(3) Click the [Modify] button, [Add] and [Delete] buttons to disable
Difficulty: insert method and update method in general database operation class
Final rendering:
The front-end function is not very complete, and there are still some problems with the logic between buttons. Finally, the front-end code is added
Formain.php judges the value passed to the front end and calls actSQL.class.php to obtain the result
The code is relatively simple
is as follows:
<?php
require('include/mysql_connect/actSQL.class.php');
$key=$_REQUEST['key'];
$a=new actSQL('localhost','root','1234','tpss');
//获取信息
if($key=='1')
{
$a->getAllData('t_prekeychart');
}
if($key=='2')
{
$objectstr=$_REQUEST['object'];
if($a->insertData($objectstr,'t_prekeychart'))
{
echo json_encode("true");
}else{
echo json_encode("false");
}
//test
//$test='{"keychartid":"2","keyid":"2","keychartname":"2","level":"2","showtype":"2","helptips":"2","keylevel":"2","ishmap":"2"}';
//$a->insertData($test,'t_prekeychart');
}
if($key=='3')
{
$prekey=$_REQUEST['keychartid'];
$prekeyname='keychartname';
if($a->delData($prekey,$prekeyname,'t_prekeychart'))
{
echo json_encode("true");
}else{
echo json_encode("false");
}
}
if($key=='4')
{
$objectstr=$_REQUEST['object'];
$prekeyname='keychartid';
if($a->updData($objectstr,$prekeyname,'t_prekeychart'))
{
echo json_encode("true");
}else{
echo json_encode("false");
}
}
?>
Look at the various methods of the classes that appear in Formain.php and think briefly
Which
getAllData($tablename) gets all the information of the table. This method is relatively simple. It can be done with a simple sql statement. Finally, the result can be returned in json format
delData($prekey,$prekeyname,$tablename) deletes the specified information. This is simpler, so I won’t go into details
insertData( $objectstr,$tablename ), where $objectstr is a string in json format, $tablename table name,
The difficulty is to piece together the statement insert into $tablename (......) values(.....)
Solution:
(1) Obtain all column names based on $tablename, and convert the column name array into a string to prepare for the final sql statement. In addition, there is another purpose to obtain column names. See below
(2) Convert the json format string $objectstr into an associative array and call the json_decode() method
Added json_decode() method
mixed json_decode ( string $json [, bool $assoc = false [, int $depth = 512 [, int $options = 0 ]]] )
Accepts a JSON-formatted string and converts it into a PHP variable, where assoc, when this parameter is TRUE , will return an associative array .
(3) Query the data in the order of the queried column names. When the data is empty, assign the value to NULL and store the result in the array to prevent misaligned values inserted into the database (another reason for obtaining column names)
(4) Convert the result of (3) into a string and call the implode() method
Supplement implode() method:
string implode(string glue, array pieces);
This function combines the contents of the array into a string. The parameter glue is the delimiter symbol between words
(5) Piece together the sql statement string, and then insert it into the database
The difficulty of the updData($objstr,$prekeyname,$tablename) method is also the string assembly of the sql statement. The assembly format should be as follows
update $tablename set ..... where $prekeyname=$data[$prekeyname]
The first two steps are the same as insertData()
(3) Traverse the column name character array, obtain the column name value of the non-primary key name, and store it in the array according to the string format of "column name = column name value". Here is the incomplete string after the set
(4) Convert the result of (3) into a string, and separate the array elements with ',' . This is the last string after set. The format is "xx=xx,xx=xx"
(5) Piece together the sql string and then update the database
insertData() and updData() functions are as follows
/*
* 添加信息
* @param:$objstr:json风格的数据库插入信息字符串
* $tablename:表名
*/
function insertData($objstr,$tablename)
{
$dbc=$this->conData();
if($dbc)
{
$columnname=array();
$columnname=$this->getColumns($tablename);
//echo $columnname[0];
$clos=implode(',',$columnname); //将列名数组转换为字符串
//echo $clos;
$data=json_decode($objstr,true); //将json格式的字符串转换为关联数组
//echo $value['keychartname'];
$values=array();
foreach($columnname as $value)
{
//按照查询到的列名查询数据，数据为空的，赋值为NULL，防止数据库插入数值错位
//echo $data[$value]."<br>";
if(isset($data[$value]))
{
array_push($values,$data[$value]);
}else{
$data[$value]=NULL;
array_push($value,$data[$value]);
}
}
$strvalue=implode(',',$values);
//echo $strvalue;
/*
* SQL： insert into $tablename($clos) values(...)
*/
$sql=<<<SQL
insert into $tablename($clos) values($strvalue);
SQL;
//echo $sql;
$res=mysqli_query($dbc,$sql);
if($res)
{
return true;
}else{
return false;
}
}else{
echo "连接错误!";
}
}
/*
*更新信息
*@param: $objstr:json风格的数据库更新信息字符串
* $tablename:表名
* $prekeyname:主键名
* */
function updData($objstr,$prekeyname,$tablename)
{
$dbc=$this->conData();
if($dbc)
{
$columnname=array();
$columnname=$this->getColumns($tablename);
//$clos=implode(',',$columnname); //将列名数组转换为字符串
$data=json_decode($objstr,true); //将json格式的字符串转换为关联数组
$sets=array();
foreach($columnname as $value)
{
//列名不等于主键名获取值
if($prekeyname!=$value)
{
//set $value=$data[$value];
array_push($sets,"$value=$data[$value]");//接好的set语句部分
}
}
//$sets数组转化为字符串
$stringsets=implode(',',$sets);
//echo $stringsets;
/*
* SQL:update $tablename set ..... where $prekeyname=$data[$prekeyname];
* */
$sql=<<<SQL
update $tablename set $stringsets where $prekeyname=$data[$prekeyname];
SQL;
$res=mysqli_query($dbc,$sql);
if($res)
{
return true;
}else{
return false;
}
}else{
echo "连接错误";
}
}
/*
*获取表的所有列名
*@param:$tablename:表名
*/
function getColumns($tablename)
{
$dbc=@mysqli_connect('localhost','root','1234','information_schema');
if(!$dbc)
{
echo "Connect Error".mysqli_connect_error($dbc);
}else
{
//连接成功,从表COLUMNS获取表的所有列名
$sql="select COLUMN_NAME from columns where TABLE_NAME='$tablename'";
$res=@mysqli_query($dbc,$sql);
$items=array();
if($res)
{
while($row=mysqli_fetch_array($res,MYSQLI_ASSOC))
{
$columnname=$row['COLUMN_NAME'];
array_push($items,$columnname);
}
return $items;
mysqli_close($dbc);
}
else{
echo "查询失败，请检查SQL语句!";
}
}
}
The above is the entire content of this article, I hope you all like it.