✓ MySQL连接成功
✓ 表fa_promotion_demands存在
| 字段 | 类型 | 允许NULL | 键 | 默认值 | 额外 |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | NULL | auto_increment |
| project_name | varchar(100) | NO | NULL | ||
| project_brand | varchar(255) | YES | NULL | ||
| is_brand_confidential | tinyint(1) | YES | 0 | ||
| project_desc | text | YES | NULL | ||
| demand_desc | text | YES | NULL | ||
| project_detail | text | YES | NULL | ||
| status | enum('待审核','招募中','已截止报名','项目已执行完成') | YES | 待审核 | ||
| synced_to_admin | tinyint(1) | YES | MUL | 0 | |
| sync_time | int(11) | YES | NULL | ||
| feedback | text | YES | NULL | ||
| publish_date | datetime | YES | CURRENT_TIMESTAMP | ||
| deadline_date | datetime | NO | NULL | ||
| execution_start_date | date | NO | NULL | ||
| execution_end_date | date | NO | NULL | ||
| total_budget | decimal(10,2) | YES | NULL | ||
| view_count | int(11) | NO | 0 | ||
| applicant_count | int(11) | NO | 0 | ||
| influencer_count | int(11) | NO | 0 | ||
| institution_count | int(11) | NO | 0 | ||
| detail_requirement | text | YES | NULL | ||
| creator_id | int(11) | NO | NULL | ||
| creator_type | enum('admin','user') | NO | NULL | ||
| created_at | int(11) | YES | NULL | ||
| updated_at | int(11) | YES | NULL | ||
| platform_type | text | YES | NULL | ||
| platform_list | text | YES | NULL | ||
| platform_fields | text | YES | NULL | ||
| influencer_fans_min | int(11) | YES | NULL | ||
| influencer_fans_max | int(11) | YES | NULL | ||
| influencer_required_count | int(11) | YES | NULL | ||
| cooperation_element | varchar(50) | YES | NULL | ||
| cooperation_form | varchar(255) | YES | NULL | ||
| promotion_form | varchar(50) | YES | NULL | ||
| influencer_budget | decimal(10,2) | YES | NULL | ||
| influencer_region | varchar(255) | YES | NULL | ||
| influencer_gender | varchar(20) | YES | NULL | ||
| influencer_type | text | YES | NULL | ||
| international_location | varchar(255) | YES | NULL | ||
| media_types | text | YES | NULL | ||
| has_draft | varchar(20) | YES | NULL | ||
| media_count | int(11) | YES | NULL | ||
| inclusion_requirement | int(11) | YES | NULL | ||
| activity_budget | decimal(10,2) | YES | NULL | ||
| media_platforms | text | YES | NULL | ||
| activity_location | varchar(255) | YES | NULL | ||
| activity_organizer | varchar(255) | YES | NULL | ||
| activity_time | datetime | YES | NULL | ||
| invited_media_list | text | YES | NULL | ||
| single_media_budget | decimal(10,2) | YES | NULL | ||
| media_requirements | text | YES | NULL | ||
| project_attachments | text | YES | NULL | ||
| activity_details_file | varchar(255) | YES | NULL | ||
| reference_accounts | text | YES | NULL | ||
| cooperation_remarks | text | YES | NULL | ||
| status_updates | text | YES | NULL |
表中现有 65 条记录
Array
(
[id] => 156
[project_name] => 测试项目名称-20260609124845
[project_brand] =>
[is_brand_confidential] => 0
[project_desc] =>
[demand_desc] =>
[project_detail] => 这是通过direct_insert.php插入的测试记录
[status] => 待审核
[synced_to_admin] => 0
[sync_time] =>
[feedback] =>
[publish_date] => 2026-06-09 12:48:45
[deadline_date] => 2026-07-09 12:48:45
[execution_start_date] => 2026-06-11
[execution_end_date] => 2026-07-04
[total_budget] =>
[view_count] => 0
[applicant_count] => 0
[influencer_count] => 0
[institution_count] => 0
[detail_requirement] =>
[creator_id] => 1
[creator_type] => user
[created_at] => 1780980525
[updated_at] => 1780980525
[platform_type] =>
[platform_list] =>
[platform_fields] =>
[influencer_fans_min] =>
[influencer_fans_max] =>
[influencer_required_count] =>
[cooperation_element] =>
[cooperation_form] =>
[promotion_form] =>
[influencer_budget] =>
[influencer_region] =>
[influencer_gender] =>
[influencer_type] =>
[international_location] =>
[media_types] =>
[has_draft] =>
[media_count] =>
[inclusion_requirement] =>
[activity_budget] =>
[media_platforms] =>
[activity_location] =>
[activity_organizer] =>
[activity_time] =>
[invited_media_list] =>
[single_media_budget] =>
[media_requirements] =>
[project_attachments] =>
[activity_details_file] =>
[reference_accounts] =>
[cooperation_remarks] =>
[status_updates] =>
)
✗ ThinkPHP框架连接失败: controller not exists:app\index\controller\Index