How to use PHP to implement the advertising management function of CMS system

How to use PHP to implement the advertising management function of CMS system

With the rapid development of the Internet, websites have become one of the important channels for promotion in various industries. In websites, advertising is a common way to make money. Therefore, it is very important for a CMS system to implement a complete advertising management function. This article will introduce how to use PHP to implement the advertising management function of the CMS system and provide relevant code examples.

1. Create an advertising table

First, we need to create an advertising table in the database to store advertising-related information. An advertisement table containing the necessary fields can be created using the following SQL statement:

CREATE TABLE `advertisements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `img_url` varchar(255) NOT NULL,
  `link_url` varchar(255) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

In the advertisement table, we have included the following fields:

• id: the unique identifier of the advertisement, use Self-increasing integer
• title: The title of the advertisement
• img_url: The URL address of the advertisement image
• link_url: The URL address that jumps after clicking on the advertisement
• start_time: The start time of the advertisement
• end_time: The end time of the advertisement
• status: The status of the advertisement, 0 means disabled, 1 means enabled

2. Add Advertising

Next, we need to add a page to the CMS system to add advertising information. You can use the following code example to create an add advertising page:

  标题：
  

  图片链接：
  

  跳转链接：
  

  开始时间：
  

  结束时间：
  

  状态：
  

  

In the code example, we obtain the advertising information submitted by the user through the POST method, and then insert it into the advertising table in the database.

3. Manage Advertisements

In addition to adding advertising functions, we also need to implement advertising management functions, including editing, deleting, enabling/disabling, etc. You can use the following code sample to create an advertising management page:

';
    echo '
'.$row['title'].'
';
    echo '';
    echo '点击跳转';
    echo '
开始时间：'.$row['start_time'].'
';
    echo '
结束时间：'.$row['end_time'].'
';
    echo '
状态：'.$row['status'].'
';
    echo '编辑 ';
    echo '删除';
    echo '