Snippet Debug Test'; // Include required files require_once dirname(__FILE__) . '/includes/class-database.php'; require_once dirname(__FILE__) . '/includes/class-snippet.php'; echo '

Test Results:

'; // Test 1: Check database connection echo '

1. Database Connection

'; global $wpdb; echo '

Database Host: ' . DB_HOST . '

'; echo '

Database Name: ' . DB_NAME . '

'; echo '

Table Prefix: ' . $wpdb->prefix . '

'; // Test 2: Check if table exists echo '

2. Database Table

'; $table_name = $wpdb->prefix . 'pc_hfap_snippets'; echo '

Expected Table: ' . $table_name . '

'; $table_exists = $wpdb->get_var($wpdb->prepare('SHOW TABLES LIKE %s', $table_name)); if ($table_name === $table_exists) { echo '

✓ Table exists!

'; } else { echo '

✗ Table does not exist!

'; echo '

Attempting to create table...

'; PC_HFAP_Database::create_tables(); // Check again $table_exists = $wpdb->get_var($wpdb->prepare('SHOW TABLES LIKE %s', $table_name)); if ($table_name === $table_exists) { echo '

✓ Table created successfully!

'; } else { echo '

✗ Failed to create table!

'; echo '

Last error: ' . $wpdb->last_error . '

'; } } // Test 3: Try to insert a test snippet echo '

3. Insert Test Snippet

'; $test_data = array( 'title' => 'Debug Test Snippet - ' . date('Y-m-d H:i:s'), 'location' => 'header', 'code' => '' ); echo '

Testing snippet creation...

'; $snippet = new PC_HFAP_Snippet($test_data); $result = $snippet->save(); if ($result) { echo '

✓ Snippet created successfully! ID: ' . $result . '

'; // Test 4: Retrieve the snippet echo '

4. Retrieve Snippet

'; $retrieved = PC_HFAP_Snippet::get_by_id($result); if ($retrieved) { echo '

✓ Snippet retrieved: ' . esc_html($retrieved->get_title()) . '

'; // Test 5: Delete the snippet echo '

5. Delete Snippet

'; $delete_result = $retrieved->delete(); if ($delete_result) { echo '

✓ Snippet deleted successfully!

'; } else { echo '

✗ Failed to delete snippet!

'; } } else { echo '

✗ Failed to retrieve snippet!

'; } } else { echo '

✗ Failed to create snippet!

'; echo '

Last error: ' . $wpdb->last_error . '

'; } // Test 6: List all snippets echo '

6. List All Snippets

'; $all_snippets = PC_HFAP_Snippet::get_all(); echo '

Total snippets in database: ' . count($all_snippets) . '

'; echo '

Debug Complete

'; echo '

If you see any red ✗ marks, check your WordPress debug.log for more details.

'; echo '

To run this test:

'; echo '
    '; echo '
  1. Upload this file to your server
    2. '; echo '
  2. Access it via browser: yoursite.com/wp-content/plugins/pc-headers-and-footers-and-ad-pixels-5ake/debug-test.php
    3. '; echo '
  3. Check the results
    4. '; echo '
';