PHP handle_mysql_in_ids Examples

Example #1

File: Role.php Project: ptphp/ptphp

 /**
  * 删除
  * @param $id
  * @param $ids
  * @return array
  */
 function action_remove($id, $ids)
 {
     $table = self::table();
     if ($id) {
         $row = self::_db()->row("select * from {$table} role_id = ?", $id);
         if (!$row) {
             _throw("记录不存在");
         }
         self::_db()->delete($table, array("role_id" => $id));
     }
     if ($ids) {
         $ids = handle_mysql_in_ids($ids);
         self::_db()->run_sql("delete from {$table} where role_id in ({$ids})");
     }
     return array("msg" => "删除成功");
 }

Example #2

File: User.php Project: ptphp/ptphp

 /**
  * 删除
  * @param $id
  * @param $ids
  * @return array
  */
 function action_remove($id, $ids)
 {
     $pk = self::pk();
     $table = self::table();
     if ($id) {
         $row = self::_db()->row("select * from {$table} where {$pk} = ?", $id);
         if (!$row) {
             _throw("记录不存在");
         }
         self::_db()->delete($table, array($pk => $id));
         self::_db()->delete(self::_table("staff_user"), array($pk => $id));
     }
     if ($ids) {
         $ids = handle_mysql_in_ids($ids);
         $table_staff_user = self::_table("staff_user");
         self::_db()->run_sql("delete from {$table} where {$pk} in ({$ids})");
         self::_db()->run_sql("delete from {$table_staff_user} where {$pk} in ({$ids})");
     }
     return array("msg" => "删除成功");
 }