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:

<&#63;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");
   }
  }
&#63;>

Copy after login

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语句!";
     }
   }
  }

Copy after login

The above is the entire content of this article, I hope you all like it.