超直接的数据库插入测试

将执行以下SQL:

INSERT INTO `fa_promotion_demands` (`project_name`, `project_detail`, `publish_date`, `deadline_date`, `execution_start_date`, `execution_end_date`, `status`, `creator_id`, `creator_type`, `created_at`, `updated_at`) VALUES ('测试项目-20260613204139', '这是一个由debug_insert.php直接插入的测试', '2026-06-13 20:41:39', '2026-07-13 20:41:39', '2026-06-15', '2026-07-08', '待审核', '1', 'user', '1781354499', '1781354499')

✓ 数据库连接成功

✓ 数据插入成功,ID: 159

刚刚插入的数据:

Array
(
    [id] => 159
    [project_name] => 测试项目-20260613204139
    [project_brand] => 
    [is_brand_confidential] => 0
    [project_desc] => 
    [demand_desc] => 
    [project_detail] => 这是一个由debug_insert.php直接插入的测试
    [status] => 待审核
    [synced_to_admin] => 0
    [sync_time] => 
    [feedback] => 
    [publish_date] => 2026-06-13 20:41:39
    [deadline_date] => 2026-07-13 20:41:39
    [execution_start_date] => 2026-06-15
    [execution_end_date] => 2026-07-08
    [total_budget] => 
    [view_count] => 0
    [applicant_count] => 0
    [influencer_count] => 0
    [institution_count] => 0
    [detail_requirement] => 
    [creator_id] => 1
    [creator_type] => user
    [created_at] => 1781354499
    [updated_at] => 1781354499
    [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] => 
)

查询所有记录:

ID项目名称状态发布日期
159测试项目-20260613204139待审核2026-06-13 20:41:39
158测试项目-20260610154945待审核2026-06-10 15:49:45
157测试项目名称-20260610113012待审核2026-06-10 11:30:12
156测试项目名称-20260609124845待审核2026-06-09 12:48:45
155测试项目名称-20260219052806待审核2026-02-19 05:28:06
154测试项目-20251125122915待审核2025-11-25 12:29:15
153测试项目名称-20251125122912待审核2025-11-25 12:29:12
152测试项目名称-20250601093704待审核2025-06-01 09:37:04
151测试项目发布-平台招募中2025-05-12 09:31:35
150百度推广测试需求1待审核2025-05-11 16:43:16

打开phpMyAdmin查看数据 | 使用纯PHP表单测试 | 数据库诊断工具