JizhiCMS

https://help.jizhicms.cn

This documentation provides guidance and information for JizhiCMS, covering topics such as system...

Tokens:116,121

Snippets:1,059

Trust Score:9.5

Update:3 months ago

Show doc for...

Tokens:

Tokens:

### Alipay Instant Payment Example

Source: https://help.jizhicms.cn/topay.html

Example of how to construct a URL for an instant Alipay payment. Ensure all required parameters are correctly set for the transaction.

```URL
http://您的网站域名/mypay/topay?tid=1&id=1&num=1&username=测试&email=123456@qq.com&address=北京朝阳区xxx号&tel=13900xxxx&ptype=1
```

--------------------------------

### Plugin Installation (PluginsController.php)

Source: https://help.jizhicms.cn/plugins-hook.html

Handles the installation process for a Jizhi CMS plugin, including registering a controller hook. This function is called when a plugin is installed via the backend.

```php
//执行SQL语句在此处处理,或者移动文件也可以在此处理
	public  function install(){
		//下面是新增test表的SQL操作
        /*
		$table = 'test';
		$sql = "CREATE TABLE IF NOT EXISTS `".DB_PREFIX.$table."` (
				`id` int(11) unsigned NOT NULL auto_increment,
				`tid` int(11) DEFAULT 0,
				`orders` int(11) DEFAULT 0,
				`comment_num` int(11) DEFAULT 0,
				`htmlurl` varchar(100) DEFAULT NULL,
				PRIMARY 
				KEY  (`id`)
				) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
				
		$x = M()->runSql($sql);
		*/
		//转移一个文件到另一个文件下面
        /**
         * 方法1：将当前目录下的tpl/test.html 转移到 根目录static/test.html （需要确定转移的文件目录已存在）
         * copy(APP_PATH.APP_HOME.'/exts/test/tpl/test.html',APP_PATH.'static/test.html')
         * 方法2：将当前目录下的file文件夹下面所有文件（只是文件，不包含文件夹） 转移到 根目录static下面 （需要确定转移的文件目录已存在）
         * $this->removeFile(APP_PATH.APP_HOME.'/exts/test/file',APP_PATH.'static');
         * 方法3：将当前目录下的file文件夹下面所有文件（包含文件夹） 转移到 根目录static下面
         * $this->recurse_copy(APP_PATH.APP_HOME.'/exts/test/file',APP_PATH.'static');
         */

        //备份当前数据库
        /**
         * $this->JZ_backup();
         */
         
        /**
        这里进行注册 hook 
        **/
        
		$ww = [];
		$ww['module'] = 'home';
		$ww['controller'] = 'Home';//HomeController前台主要入口控制器
		$ww['action'] = 'jizhi';//主入口函数
		$ww['hook_controller'] = 'NewTest';//我们需要创建的控制器 NewTestController
		$ww['hook_action'] = 'index';//需要写的函数
		$ww['all_action'] = 1;//这个标识，HomeController下面的所有方法，是否都执行我的这个函数，1是0否
		$ww['isopen'] = 1;//开放这个钩子，必须写1
		$ww['plugins_name'] = 'newtest';//我们这个插件文件夹名字
		$ww['addtime'] = time();//当前时间，默认必须写
		M('hook')->add($ww);
        
        setCache('hook',null);//重置钩子，只要注册了钩子就必须重置才会执行

		return true;
		
	}
	
```

--------------------------------

### PHP Plugin Controller Example

Source: https://help.jizhicms.cn/plugins-hook.html

This is an example of a Jizhi CMS plugin controller. It demonstrates how to check if a plugin is enabled, retrieve its configuration, and display a message.

```php
namespace app\home\plugins;

use app\home\c\CommonController;

class NewTestController extends CommonController
{
	function index()
	{
		echo '这是一个插件页面！';
		//查询插件是否已经开启
		$plugins = M('plugins')->find(['filepath'=>'newtest','isopen'=>1]);
		if($plugins){
		    $config = json_decode($plugins['config']);//后台存储的json，所以要专为数组形式
		    
		    $this->newtest = $config;//将插件赋值到模板中
		    
		    
		    
		}
		else{
		    Error('插件未开启！');
		}
		
		
		
	}
	
	
}



```

--------------------------------

### Example Response for Get User Info API

Source: https://help.jizhicms.cn/app/getuserinfo.html

This is a sample JSON response when successfully retrieving user information. It includes user details like ID, username, contact information, and group settings.

```json
{
	"code": 0,
	"msg": "success",
	"data": {
		"id": "99",//用户ID
		"molds": "member_group",//用户组模型
		"username": "ylrrja",//随机生成的用户名
		"openid": null,//公众号openid
		"pass": "8718a19eabec0174b7bc256254c336a5",//密码加密字符串
		"token": null,//安全token
		"sex": "0",//性别：0未知1男2女
		"gid": "1",//用户组ID
		"litpic": null,//头像
		"tel": "13800138008",//手机号
		"jifen": 1,//积分
		"likes": null,//已作废
		"collection": null,//已作废
		"money": "0.00",//钱包
		"email": "12312312@qq.com",//邮箱
		"address": null,//地址
		"province": null,//省份
		"city": null,//城市
		"regtime": "1724393605",//注册时间戳
		"logintime": "0",//登录时间
		"isshow": "1",//是否显示
		"signature": null,//签名
		"birthday": null,//生日
		"follow": null,//已作废
		"fans": "0",//粉丝数
		"ismsg": "1",//是否接收信息提醒
		"iscomment": "1",//是否允许评论提醒
		"iscollect": "1",//是否允许收藏提醒
		"islikes": "1",//是否允许点赞提醒
		"isat": "1",//是否允许@提醒
		"isrechange": "1",//是否允许交易提醒
		"pid": "0",//父类ID，推荐人
		"uploadsize": "50",//允许上传的总容量50MB，单位MB
		"name": "注册会员",//分组名称
		"description": "前台会员分组，最低等级分组",//分组描述
		"paction": ",Message,Comment,User,Order,Home,Common,Uploads,",//前台权限
		"isagree": "1",//是否允许登录
		"ischeckmsg": "1",
		"addtime": "0",//分组添加时间
		"orders": "0",//排序
		"discount": "0.00",//折扣
		"discount_type": "0"//折扣类型
	}
}

```

--------------------------------

### Loop Limit with Offset

Source: https://help.jizhicms.cn/loop-limit.html

Specify a starting point and count for the loop output using 'limit="start,count"'. The database counts from 0, so 'limit="0,10"' starts from the first item and displays 10. 'limit="1,10"' starts from the second item and displays 10.

```Jizhicms Template
{loop table="表名" tid="栏目ID" isshow="1" limit="1,10"  as="v"}

{/loop}
```

--------------------------------

### Example Response for Get Single Content

Source: https://help.jizhicms.cn/app/getcontents.html

This is an example of a successful response from the Get Single Content API, indicating the structure of the returned data.

```json
{
	"code": 0,
	"msg":"success",
	"data":{}
}
```

--------------------------------

### User Registration API Request Example

Source: https://help.jizhicms.cn/app/register.html

Example of how to make a POST request to the user registration API using curl. It includes all required parameters like phone number, password, and verification code.

```bash
curl -X POST -d "ajax=1&tel=13800138000&email=123456@qq.com&password=123456&repassword=123456&vercode=abcd" https://demo.jizhicms.cn/login/register
```

--------------------------------

### SQL Cache Query Examples

Source: https://help.jizhicms.cn/sqlcache.html

Examples of SQL queries to be used with the Jizhicms cache for different search criteria. Ensure strings use English single quotes.

```sql
id in(1,2,3) or tid in(2,3,4)
```

```sql
title like '%网站建设%'
```

```sql
(title like '%网站建设%' or body like '%网站建设%')
```

```sql
title='网站建设'
```

--------------------------------

### Example cURL Request for User Login

Source: https://help.jizhicms.cn/app/login.html

Demonstrates how to make a POST request to the user login endpoint using cURL, including all required parameters.

```bash
curl -X POST -d "ajax=1&tel=13800138000&email=123456@qq.com&password=123456&vercode=abcd" https://demo.jizhicms.cn/login/index
```

--------------------------------

### Jizhicms AJAX List Template Example

Source: https://help.jizhicms.cn/ajax.html

This is an example of an AJAX list template (`ajax_list_*.html`) for Jizhicms. It iterates through a list of articles, displaying their image, title, date, author, description, and a 'Learn More' button. This is a template structure and not executable JavaScript.

```html
{if($lists)}
{foreach $lists as $v}
    <div class="clean-blog-post">
        <div class="row">
            <div class="col-lg-5"><img class="rounded img-fluid" src="{if($v['litpic']=='')}{$tpl}assets/img/tech/image4.jpg{else}{$v['litpic']}{/if}"></div>
            <div class="col-lg-7">
                <h3>【{$v['id']}】{$v['title']}</h3>
                <div class="info"><span class="text-muted">{fun date('Y-m-d',$v['addtime'])}&nbsp;<a >{fun get_info_table('level',['id'=>$v['userid']],'name')}</a></span></div>
                <p>{fun newstr($v['description'],150)}</p><a href="{$v['url']}"><button class="btn btn-outline-primary btn-sm" type="button">了解更多</button></a></div>
        </div>
    </div>
{/foreach}
{/if}
```

--------------------------------

### Get Website System Configuration

Source: https://help.jizhicms.cn/wechat-miniprogram/wxdev.html

Uses the `util.AJAX` method to fetch website system configuration. It then updates the navigation bar title and sets local data with the retrieved configuration. Ensure `util.config.accesskey` is correctly set.

```javascript
// 获取网站配置信息
        util.AJAX("/GetData/index", function (res) {
            //正确获取数据
            if(res.data.code==0){
                var webconfig = [];
                var len = res.data.data.length;
         //对返回的数据进行封装成键值对的形式，方便调用
                for(var i=0;i<len;i++){
                    webconfig[res.data.data[i].field] = res.data.data[i].data;
                }

                 // 重新写入数据
                wx.setNavigationBarTitle({
                  title:webconfig.web_name
                }) ;

                that.setData({
                    webconfig: webconfig,
                    intro: webconfig.web_desc,
                    company: webconfig.web_name,
                    mobile:  webconfig.web_tel,
                    email: webconfig.web_email,
                    address: webconfig.web_address,
                });

            }

        }, { "key": util.config.accesskey, "model":'sysconfig'});

```

--------------------------------

### classtypedata Structure Example

Source: https://help.jizhicms.cn/exts-classtypedata.html

This example illustrates the structure of the classtypedata array, showing how column information is organized with the column ID as the key. It details various properties of a column, including its ID, name, mold, HTML configuration, and hierarchical relationships like 'haschild', 'level', and 'children'.

```php
Array
(
    //以栏目ID为key的栏目数组
    [1] => Array
        (
            [id] => 1
            [classname] => 公司产品
            [seo_classname] => 公司产品
            [molds] => product
            [litpic] => 
            [description] => 
            [keywords] => 
            [body] => 
            [orders] => 0
            [orderstype] => 1
            [isshow] => 1
            [iscover] => 0
            [pid] => 0
            [gid] => 0
            [htmlurl] => product
            [lists_html] => list.html
            [details_html] => details.html
            [lists_num] => 9
            [comment_num] => 0
            [gourl] => 
            [ishome] => 1
            [isclose] => 0
            [gids] => 
            [lang] => cn
            [haschild] => 1 //是否有下级
            [level] => 0 //当前栏目的层级，0表示顶级
            [url] => http://demo.jizhicms.cn/product.html
            [children] => Array
                (
                    //当前栏目的直系下级ID数组
                    [id] => Array
                        (
                            [0] => 6
                            [1] => 7
                        )
                    //当前栏目的直系下级栏目数组
                    [list] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 6
                                    [classname] => 免费模板
                                    [seo_classname] => 免费模板
                                    [molds] => product
                                    [litpic] => 
                                    [description] => 
                                    [keywords] => 
                                    [body] => 
                                    [orders] => 0
                                    [orderstype] => 1
                                    [isshow] => 1
                                    [iscover] => 0
                                    [pid] => 1
                                    [gid] => 0
                                    [htmlurl] => free
                                    [lists_html] => list
                                    [details_html] => details
                                    [lists_num] => 9
                                    [comment_num] => 0
                                    [gourl] => 
                                    [ishome] => 1
                                    [isclose] => 0
                                    [gids] => 
                                    [lang] => cn
                                    [haschild] => 
                                    [level] => 1
                                    [url] => http://demo.jizhicms.cn/free.html
                                    [children] => Array
                                        (
                                            //当前栏目的直系下级ID数组
                                            [id] => Array
                                                (
                                                )
                                            //当前栏目的直系下级栏目数组
                                            [list] => Array
                                                (
                                                )
                                            //包含当前栏目和所有下级的栏目ID数组
                                            [ids] => Array
                                                (
                                                    [0] => 6
                                                )
                                            //所有下级的栏目数组
                                            [lists] => Array
                                                (
                                                )

                                        )

                                )

                            [1] => Array
                                (
                                 
                                 ...(栏目内容)

                                )

                        )

                )

        )

)
```

--------------------------------

### Nested Loop Example

Source: https://help.jizhicms.cn/loop.html

Demonstrates how to use nested 'loop' tags to display hierarchical data, such as articles within categories. Ensure distinct 'as' variables are used for each loop to prevent conflicts.

```html
{loop table="classtype" isshow="1" pid="0" as="v"}
	{loop table="article" tid="$v['id']" isall="1" limit="10" as="vv"}
		文章标题：{$vv['title']}
		文章简介：{$vv['description']}
		文章内容：{$vv['body']}
		文章缩略图：{$vv['litpic']}
	{/loop}
{/loop}
```

--------------------------------

### Retrieving Configuration with webConf Function

Source: https://help.jizhicms.cn/label.html

The `webConf` function retrieves configuration settings. Pass the desired field name as an argument to get its value.

```JizhiCMS Template
{fun webConf('web_name')}
```

--------------------------------

### AJAX Member Registration Example

Source: https://help.jizhicms.cn/member-register.html

This JavaScript function demonstrates how to perform member registration using AJAX. It sends registration data to the server and handles the response, including success messages, errors, and redirects.

```javascript
function register(){
	var tel = $("#r-tel").val();
	var pass = $("#r-pass").val();
	var repass = $("#r-repass").val();
	
	if(tel==''){
		layer.alert('手机号不能为空！');return false;
	}
	if(pass==''){
		layer.alert('登录密码不能为空！');return false;
	}
	if(repass==''){
		layer.alert('重复密码不能为空！');return false;
	}
	if(pass!=repass){
		layer.alert('两次密码不同！');return false;
	}
	{if(!$webconf['closehomevercode'])}
	var yzm = $("#r-yzm").val();
	if(yzm==''){
		layer.alert('验证码不能为空！');return false;
	}
	{else}
	var yzm = '';
	{/if}
	
	$.post('/login/register',{tel:tel,repassword:repass,password:pass,vercode:yzm,ajax:1,autologin:1},function(res){
		if(res.code==0){
			layer.msg(res.msg,{icon: 6,time: 2000},function(){
				//登录成功后的操作
				window.location.href=res.url;
			})
		}else{
			layer.msg(res.msg,{icon:5,time:2000});
			var img = '/common/vercode?name=reg_vercode&'+Math.random();
			$("#register-yzm").attr('src',img);
		}
	},'json')
	
	return false;
	
}
```

--------------------------------

### Article Likes/Unlikes API Response Examples

Source: https://help.jizhicms.cn/app/dolikes.html

Shows successful responses for liking and unliking an article. Use the /user/likesAction endpoint with POST/GET method.

```json
{
	"code": 0,
	"msg": "点赞成功",
	"data":[]
}
```

```json
{
	"code": 0,
	"msg": "已取消点赞",
	"data":[]
}
```

--------------------------------

### Initialize Database Backup Configuration

Source: https://help.jizhicms.cn/plugins-hook.html

Sets up the database connection configuration for backup operations, merging with existing configurations.

```PHP
$pconfig = array(
            'host' =>DB_HOST,
            'port' =>DB_PORT,
            'user' =>DB_USER,
            'password' =>DB_PASS,
            'database' =>DB_NAME
        );
        $this->config = array_merge($this->config, $pconfig);
        $this->handler = new 
aquoPDO("mysql:host=".$this->config['host'].";port={\$	his->config['port']};dbname={\$	his->config['database']}", $this->config['user'], $this->config['password']);
        $this->handler->query("set names utf8");

        $this->backup();
```

--------------------------------

### Example cURL Request to Get User Info

Source: https://help.jizhicms.cn/app/getuserinfo.html

This snippet shows how to make a POST request using cURL to the Get User Info endpoint. Ensure you replace '12321312' with a valid token.

```bash
curl -X POST -d "ajax=1&token=12321312" https://demo.jizhicms.cn/user/userinfo

```

--------------------------------

### Get Single Content

Source: https://help.jizhicms.cn/app/getcontents.html

Retrieves a single content item based on its ID and model. Supports both POST and GET requests.

```APIDOC
## GET /user/getcontent

### Description
Retrieves a single content item using its ID and model identifier.

### Method
POST/GET

### Endpoint
/user/getcontent

### Parameters
#### Query Parameters
- **ajax** (number) - Required - Ajax return identifier, defaults to 1.
- **token** (string) - Required - User authorization key.
- **molds** (string) - Required - Model identifier.
- **id** (number) - Required - Content ID.

### Response
#### Success Response (0)
- **code** (integer) - Response code, 0 indicates success.
- **msg** (string) - Response message, e.g., "success".
- **data** (object) - Response object containing the content data upon success, or an empty array upon failure.

#### Response Example
```json
{
	"code": 0,
	"msg":"success",
	"data":{}
}
```

### Error Codes
- **0**: Request successful.
- **1**: Request parameter error, e.g., incorrect format or missing parameters.
```

--------------------------------

### Example API Response for Upload Avatar

Source: https://help.jizhicms.cn/app/headimg.html

This is an example of a successful response from the upload avatar API, showing the returned URL and status code.

```json
{
	"url": "/static/upload/2024/08/23/202408238633.png",
	"code": 0
}
```

--------------------------------

### Displaying Thumbnails in Frontend Templates

Source: https://help.jizhicms.cn/plugins-imagethumbnail.html

These examples demonstrate how to output different sized images in your frontend templates using the `showpic` function. The default output is the original or medium-sized image, while 's' and 'l' specify small and large thumbnails, respectively.

```html
假设图片为：$v['litpic'] 
中图(默认图片)：{$v['litpic']}或{fun showpic($v['litpic'])}或{fun showpic($v['litpic'],'d')}
小图：{fun showpic($v['litpic'],'s')}
大图：{fun showpic($v['litpic'],'l')}
```

--------------------------------

### Basic GET Request with jQuery

Source: https://help.jizhicms.cn/ajax.html

Use this snippet for simple GET requests to fetch data. Ensure jQuery is included before this code. The response is expected in JSON format.

```javascript
$.get('请求地址',{
    请求参数
},function(res){
    //只需成功后返回内容
    console.log(res)
    
},'json')
```

--------------------------------

### Initiate Payment

Source: https://help.jizhicms.cn/topay.html

This endpoint allows users to directly initiate a payment for a product. It supports various payment types and collects necessary buyer information.

```APIDOC
## POST/GET mypay/topay

### Description
Initiates an immediate payment for a product, bypassing the shopping cart. It accepts product details and buyer information to process the payment.

### Method
POST/GET

### Endpoint
/mypay/topay

### Parameters
#### Path Parameters
None

#### Query Parameters
- **tid** (integer) - Required - Product category ID.
- **id** (integer) - Required - Product ID.
- **num** (integer) - Optional - Purchase quantity (default: 1).
- **username** (string) - Optional - Buyer's username (default: anonymous).
- **email** (string) - Optional - Buyer's email address (default: empty).
- **address** (string) - Optional - Buyer's shipping address (default: empty).
- **tel** (string) - Optional - Buyer's phone number (default: empty).
- **ptype** (integer) - Optional - Payment type (default: 1).
  - 1: Alipay payment (dual-end)
  - 2: WeChat payment (in-app, H5, PC scan code)
  - 3: Wallet payment
  - 4: Points payment
  - 5: Alipay face-to-face payment

### Request Example
```json
{
  "example": "http://yourdomain.com/mypay/topay?tid=1&id=1&num=1&username=test&email=123456@qq.com&address=Beijing Chaoyang District xxx&tel=13900xxxx&ptype=1"
}
```

### Response
#### Success Response (200)
- **Details**: Order details are processed and confirmation is sent via email if configured and provided.

#### Response Example
None explicitly provided in source.
```

--------------------------------

### Example Response for Modifying User Information

Source: https://help.jizhicms.cn/app/edituserinfo.html

This is an example of a successful response from the modify user information API. It indicates the operation was successful with a code of 0 and a success message.

```json
{
	"code": 0,
	"msg": "修改成功！",
	"data":[]
	
}
```

--------------------------------

### WeChat Official Request for System Configuration

Source: https://help.jizhicms.cn/wechat-miniprogram/wxdev.html

Demonstrates how to make a POST request to the `/GetData/index` endpoint using `wx.request` to fetch system configuration. This method is suitable for direct WeChat API interactions. Ensure `util.config.appApiUrl` and `util.config.accesskey` are correctly configured.

```javascript
//微信自带请求
        wx.request({
            url:util.config.appApiUrl+'/GetData/index',
            data:{ key: util.config.accesskey, model:"sysconfig"},
            method:'POST',
            header: {  
                'content-type': 'application/x-www-form-urlencoded' 
              },
            dataType:'json',
            success:function(res){
                console.log(res);

            }



        });

```

--------------------------------

### Get User Info

Source: https://help.jizhicms.cn/app/getuserinfo.html

Retrieves user information using a GET request. Requires an 'ajax' parameter and a 'token' for authentication. Returns a comprehensive user object upon success.

```APIDOC
## GET /user/userinfo

### Description
Retrieves user information based on the provided token. This endpoint is used to fetch detailed user profile data.

### Method
GET

### Endpoint
/user/userinfo

### Parameters
#### Query Parameters
- **ajax** (number) - Required - Identifier for AJAX requests, defaults to 1.
- **token** (string) - Required - User authorization key obtained after login.

### Request Example
```
curl -X POST -d "ajax=1&token=12321312" https://demo.jizhicms.cn/user/userinfo
```

### Response
#### Success Response (200)
- **code** (integer) - Response code, 0 indicates success.
- **msg** (string) - Response message, e.g., "success".
- **data** (object) - User data object containing fields like id, username, email, etc. Returns an empty array on failure.

#### Response Example
```json
{
	"code": 0,
	"msg": "success",
	"data": {
		"id": "99",
		"molds": "member_group",
		"username": "ylrrja",
		"openid": null,
		"pass": "8718a19eabec0174b7bc256254c336a5",
		"token": null,
		"sex": "0",
		"gid": "1",
		"litpic": null,
		"tel": "13800138008",
		"jifen": 1,
		"likes": null,
		"collection": null,
		"money": "0.00",
		"email": "12312312@qq.com",
		"address": null,
		"province": null,
		"city": null,
		"regtime": "1724393605",
		"logintime": "0",
		"isshow": "1",
		"signature": null,
		"birthday": null,
		"follow": null,
		"fans": "0",
		"ismsg": "1",
		"iscomment": "1",
		"iscollect": "1",
		"islikes": "1",
		"isat": "1",
		"isrechange": "1",
		"pid": "0",
		"uploadsize": "50",
		"name": "注册会员",
		"description": "前台会员分组，最低等级分组",
		"paction": ",Message,Comment,User,Order,Home,Common,Uploads,",
		"isagree": "1",
		"ischeckmsg": "1",
		"addtime": "0",
		"orders": "0",
		"discount": "0.00",
		"discount_type": "0"
	}
}
```

### Error Handling
- **0**: Request successful.
- **1**: Request parameter error, e.g., incorrect or missing 'tel' format.
```

--------------------------------

### Display System Configuration Parameters

Source: https://help.jizhicms.cn/work/workready.html

Outputs various system configuration parameters defined in the backend. Ensure these are correctly set in the JizhiCMS admin panel.

```HTML
网站域名:{$webconf['domain']} //需要后台配置好
网站名:{$webconf['web_name']}
网站描述:{$webconf['web_desc']}
底部版权:{$webconf['web_copyright']}
网站备案:{$webconf['web_beian']}
网站手机:{$webconf['web_tel']}
400电话:{$webconf['web_tel_400']}
QQ:{$webconf['web_qq']}
邮箱:{$webconf['web_email']}
公司地址:{$webconf['web_address']}

自定义配置:{$webconf['自定义参数']} //后台显示的如：[ abc ] {$webconf['abc']}

模板资源路径：{$tpl}    解析路径:/staic/default(当前模板)/
```

--------------------------------

### Single Entry Point Configuration

Source: https://help.jizhicms.cn/update-log.html

Configure a single entry point for both frontend and backend access through `index.php`. The default backend address is `/index.php/admins`. The `admins` identifier can be modified within `index.php`.

```php
> 单入口：进入前后台都通过`index.php`，也可以通过自定义入口文件进行指定，默认后台地址：`/index.php/admins` 在 `index.php` 里面可以修改 `admins` 后台模块标识

```

--------------------------------

### 批量查询数据

Source: https://help.jizhicms.cn/model.html

使用findAll()函数查询多条数据。可指定查询条件、排序、字段和数量限制。返回查询结果数组。常用于获取列表数据。

```php
{php
$lists = M('article')->findAll(['isshow'=>1],'hits desc',null,10);

/}
{foreach $lists as $v}
ID:{$v['id']}
标题：{$v['title']}
链接：{fun gourl($v)}//链接需要使用链接创建方法获取url，可以从内置函数这个章节找到方法
{/foreach}
```

--------------------------------

### Successful Article Deletion Response

Source: https://help.jizhicms.cn/app/delarticle.html

Example of a successful response when an article is deleted.

```json
{
	"code": 0,
	"msg": "删除成功",
	"data":[]
}
```

--------------------------------

### Get All Table Names (MySQL)

Source: https://help.jizhicms.cn/plugins-hook.html

Retrieves a list of all table names from a MySQL database.

```PHP
else{
            $sql = "SHOW TABLES";
        }


        $tables = M()->findSql($sql);
        $ttable = array();
        foreach($tables as $value){
            foreach($value as $vv){
                $ttable[] = $vv;
            }

        }
        return $ttable;
```

--------------------------------

### Output Product List

Source: https://help.jizhicms.cn/loop.html

Fetches and displays a list of products from a specific category (ID 2). Similar to articles, `isall` includes products from sub-categories. Use `isshow` to filter by display status.

```html
{loop table="product" tid="2" isall="1" limit="10" isshow="1" as="v"}
商品标题：{$v['title']}
商品简介：{$v['description']}
商品内容：{$v['body']}
商品缩略图：{$v['litpic']}
商品价格：{$v['price']}
...
{/loop}
```

--------------------------------

### Get All Table Names (SQLite)

Source: https://help.jizhicms.cn/plugins-hook.html

Retrieves a list of all table names from a SQLite database.

```PHP
if(defined('DB_TYPE') && DB_TYPE=='sqlite'){
            $sql = "select name from sqlite_master where type='table' order by name";
        }
```

--------------------------------

### Delete Article

Source: https://help.jizhicms.cn/app/delarticle.html

Allows users to delete articles. Supports both POST and GET requests.

```APIDOC
## Delete Article

### Description
Users can delete articles using this endpoint. It supports both POST and GET request methods.

### Method
POST/GET

### Endpoint
/user/del

### Parameters
#### Query Parameters
- **ajax** (number) - Required - ajax return identifier, defaults to 1.
- **token** (string) - Required - User authorization key.
- **id** (number) - Required - The ID of the article to delete.
- **molds** (string) - Optional - Model identifier, defaults to 'article'.

### Request Example
```json
{
  "ajax": 1,
  "token": "your_auth_token",
  "id": 123,
  "molds": "article"
}
```

### Response
#### Success Response (200)
- **code** (integer) - Response code, 0 indicates success.
- **msg** (string) - Response message.
- **data** (object) - Response object, returns an empty array on success.

#### Error Response (e.g., 400)
- **code** (integer) - Response code, 1 indicates failure.
- **msg** (string) - Response message.
- **data** (object) - Response object, returns an empty array on failure.

### Response Example
```json
{
  "code": 0,
  "msg": "Deletion successful",
  "data": []
}
```

```json
{
  "code": 1,
  "msg": "Deletion failed",
  "data": []
}
```

### Error Codes
- **0**: Request successful, correct response.
- **1**: Request parameter error, such as incorrect or missing tel format.
```

--------------------------------

### Making a Request with wx.request

Source: https://help.jizhicms.cn/wechat-miniprogram/wxapi.html

This snippet demonstrates how to make a POST request to a backend API using the wx.request method. It includes setting the URL, data payload, method, content type header, and handling the success response.

```javascript
wx.request({
    url:util.config.appApiUrl+'/GetData/index',
    data:{ key: util.config.accesskey, model:"sysconfig"},
    method:'POST',
    header: {
        'content-type': 'application/x-www-form-urlencoded'
      },
    dataType:'json',
    success:function(res){
        console.log(res);

    }

});
```

--------------------------------

### Apache伪静态配置

Source: https://help.jizhicms.cn/rewrite.html

将此内容添加到Apache服务器根目录下的.htaccess文件中，以启用伪静态。

```apache
<IfModule mod_rewrite.c>
 RewriteEngine on
 RewriteBase /
 #RewriteCond %{REQUEST_URI} !((.*).jpg|.jpeg|.bmp|.gif|.png|.js|.css|.tts|.woff )$
 RewriteCond %{REQUEST_FILENAME} !-d
 RewriteCond %{REQUEST_FILENAME} !-f
 RewriteCond %{DOCUMENT_ROOT}%{REQUEST_URI} !-d
 RewriteCond %{DOCUMENT_ROOT}%{REQUEST_URI} !-f
 #RewriteRule ^(.*)$ index.php?/$1 [QSA,PT,L]
 RewriteRule ^(.*)$ index.php [E=PATH_INFO:$1,QSA,PT,L]
</IfModule>


```

--------------------------------

### Failed Article Deletion Response

Source: https://help.jizhicms.cn/app/delarticle.html

Example of a failed response when an article deletion fails.

```json
{
	"code": 1,
	"msg": "删除失败",
	"data":[]
}
```

--------------------------------

### Product Module Content Parameters

Source: https://help.jizhicms.cn/plugins-webapi.html

Parameters for publishing content to the Product module. Includes standard fields plus 'pictures_urls[]' for image galleries. Multiple image URLs can be submitted.

```plaintext
tid:[标签:栏目ID]
title:[标签:文章标题]
addtime:[标签:时间]
body:[标签:内容]
以下可以不传入
litpic:[标签:缩略图]（默认自动提取内容缩略图）
seo_title:[标签:文章SEO标题]
keywords:[标签:关键词]
description:[标签:简介]
pictures_urls[]:[标签:图集1]
pictures_urls[]:[标签:图集2](一次提交多个，按需写入)
```

--------------------------------

### Get Table Creation DDL

Source: https://help.jizhicms.cn/plugins-hook.html

Fetches the SQL statement used to create a specific table.

```PHP
private function getDDL($table = '')
    {
        $sql = "SHOW CREATE TABLE `{$table}`";
        $ddl = $this->query($sql)[0][1] . ';';
        return $ddl;
```

--------------------------------

### Get Table Fields (MySQL)

Source: https://help.jizhicms.cn/plugins-hook.html

Retrieves column names for a given table in a MySQL database.

```PHP
else{
            $sql = 'SHOW COLUMNS FROM '.DB_PREFIX.$table;
            $list = M()->findSql($sql);
            $isgo = true;
            $fields = [];
            foreach($list as $v){
                $fields[]=$v['Field'];

            }
        }



        return $fields;
```

--------------------------------

### Get Table Fields (SQLite)

Source: https://help.jizhicms.cn/plugins-hook.html

Retrieves column names for a given table in a SQLite database.

```PHP
if(defined('DB_TYPE') && DB_TYPE=='sqlite'){
            $sql = "pragma table_info(".DB_PREFIX."$table)";

            $list = M()->findSql($sql);
            $fields = [];
            foreach($list as $v){
                $fields[]=$v['name'];

            }
        }
```

--------------------------------

### wx.request for GetData/index

Source: https://help.jizhicms.cn/wechat-miniprogram/wxapi.html

This snippet demonstrates how to make a POST request to the /GetData/index API endpoint using wx.request to fetch data. It includes common parameters like API key, model, and optional parameters for filtering and sorting.

```APIDOC
## POST /GetData/index

### Description
This endpoint is used to retrieve data from the system. It supports various parameters for filtering, sorting, and selecting specific fields.

### Method
POST

### Endpoint
/GetData/index

### Parameters
#### Query Parameters
- **key** (string) - Required - API access key.
- **model** (string) - Required - Identifier for the module to query.
- **limit** (integer) - Optional - Number of records to retrieve.
- **orders** (string) - Optional - Sorting criteria (e.g., 'id desc,addtime desc'). Defaults to 'id asc'.
- **fields** (string) - Optional - Comma-separated list of fields to retrieve (e.g., 'id,title,body'). Defaults to all fields.
- **isshow** (boolean) - Optional - Whether to query for displayed items.
- **tid** (integer) - Optional - Identifier for the category to query.

### Request Example
```json
{
  "url": "/GetData/index",
  "data": {
    "key": "YOUR_API_KEY",
    "model": "sysconfig"
  },
  "method": "POST",
  "header": {
    "content-type": "application/x-www-form-urlencoded"
  }
}
```

### Response
#### Success Response (200)
- **code** (integer) - 0 for successful return, 1 for request error.
- **data** (array) - An array containing the retrieved data.

#### Response Example
```json
{
  "code": 0,
  "data": [
    // ... retrieved data objects ...
  ]
}
```
```

--------------------------------

### Get Table Data

Source: https://help.jizhicms.cn/plugins-hook.html

Retrieves all rows and columns from a specified table and formats them into SQL INSERT statements.

```PHP
private function getData($table = '')
    {
        $sql = "SHOW COLUMNS FROM `{$table}`";
        $list = $this->query($sql);
        //字段
        $columns = '';
        //需要返回的SQL
        $query = [];
        foreach ($list as $value)
        {
            $columns .= "`{$value[0]}`,";
        }
        $columns = substr($columns, 0, -1);
        $data = $this->query("SELECT * FROM `{$table}`");
        foreach ($data as $value)
        {
            $dataSql = '';
            foreach ($value as $v)
            {
                if($v==='' || $v===null){
                    $dataSql .= " NULL,";
                }else{
                    $dataSql .= "'{$v}',";
                }


```

--------------------------------

### 在loop中判断不同属性标签

Source: https://help.jizhicms.cn/loop-jzattr.html

在循环输出文章时，使用`strpos`函数判断`jzattr`字符串是否包含特定的属性值（1:置顶, 2:最热, 3:推荐），并输出相应的标签。

```html
{loop table="article" isshow="1" limit="10" as="v"}
    {if($v['jzattr'])}
    {if(strpos($v['jzattr'],',1,')!==false)}置顶{/if}
    {if(strpos($v['jzattr'],',2,')!==false)}最热{/if}
    {if(strpos($v['jzattr'],',3,')!==false)}推荐{/if}
    {/if}
{/loop}
```

--------------------------------

### IIS伪静态配置

Source: https://help.jizhicms.cn/rewrite.html

将此XML内容保存到IIS服务器根目录下的web.config文件中，以启用伪静态。

```xml
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <system.webServer>
        <rewrite>
            <rules>
                <rule name="allow_rules" enabled="true" stopProcessing="true">
                    <match url="^(.*)$" ignoreCase="false" />
                    <conditions logicalGrouping="MatchAll" trackAllCaptures="false">
                        <add input="{REQUEST_FILENAME}" matchType="IsDirectory" ignoreCase="false" negate="true" />
                        <add input="{REQUEST_FILENAME}" matchType="IsFile" ignoreCase="false" negate="true" />
                    </conditions>
                    <action type="Rewrite" url="index.php/{R:1}" appendQueryString="true" />
                </rule>
            </rules>
        </rewrite>
    </system.webServer>
</configuration>


```

--------------------------------

### Get All Table Names

Source: https://help.jizhicms.cn/plugins-hook.html

Retrieves a list of all table names from the database using a 'SHOW TABLES' SQL query.

```PHP
private function getTables()
    {
        $sql = 'SHOW TABLES';
        $list = $this->query($sql);
        $tables = array();
        foreach ($list as $value)
        {
            $tables[] = $value[0];
        }
        return $tables;
```

--------------------------------

### Getting Current URL with current_url Function

Source: https://help.jizhicms.cn/label.html

The `current_url` function returns the complete URL of the current page.

```JizhiCMS Template
{fun current_url()}
```

--------------------------------

### 输出非推荐内容

Source: https://help.jizhicms.cn/loop-jzattr.html

使用`sql`参数配合`jzattr not like '%,3,%' or jzattr is null`来筛选出不包含推荐属性（3）的文章。

```html
{php}
$sql = " (jzattr not like '%,3,%' or jzattr is null) ";
{/}
{loop table="article" sql="$sql" isshow="1" limit="10" as="v"}

{/loop}
```

--------------------------------

### 执行SQL查询数据

Source: https://help.jizhicms.cn/model.html

使用findSql()函数执行原生SQL查询语句。返回查询结果数组或false。需要包含完整的表名。适用于复杂查询或需要直接操作数据库的场景。

```php
{php

$lists = M()->findSql("select * from jz_article where id=1 and isshow=1");

/}
```

--------------------------------

### Getting Visitor IP with GetIP Function

Source: https://help.jizhicms.cn/label.html

The `GetIP` function retrieves the current visitor's IP address.

```JizhiCMS Template
{fun GetIP()}
```

--------------------------------

### Getting Current Template Name with get_template Function

Source: https://help.jizhicms.cn/label.html

The `get_template` function returns the name of the currently active template file.

```JizhiCMS Template
{fun get_template()}
```

--------------------------------

### Switching Languages via URL Parameter

Source: https://help.jizhicms.cn/mutilang.html

Explains how to switch between different language versions of the website by appending a language parameter to the URL.

```http
http://域名/?l=zh_cn
```

--------------------------------

### Get Comment Count for a Specific User

Source: https://help.jizhicms.cn/comment.html

Retrieves the number of comments made by a specific user. Requires 'isshow' and 'userid' parameters.

```php
{fun M('comment')->getCount(['isshow'=>1,'userid'=>1])}
```

--------------------------------

### 实例化模型并查询条数

Source: https://help.jizhicms.cn/model.html

使用M()函数实例化模型，并通过getCount()方法查询满足条件的数据条数。支持SQL字符串或数组作为条件。

```php
{php echo M('member')->getCount(['gid'=>1]);/}
```

```php
{php echo M('member')->getCount('gid=1');/}
```

```php
{php echo M('article')->getCount(['member_id'=>1]);/}
```

```php
{php echo M('article')->getCount('member_id=1');/}
```

```php
{php echo M('article')->getCount("title like '%极致%' ");/}
```

--------------------------------

### Check Collect API Success Response

Source: https://help.jizhicms.cn/app/checkCollect.html

Example of a successful response from the /user/checkCollect API, indicating the content has been collected (data: true).

```json
{
	"code": 0,
	"msg": "success",
	"data": true
}

```