prefix . 'pc_simple_snippets';
// Create table if needed
$wpdb->query("CREATE TABLE IF NOT EXISTS $table_name (
id mediumint(9) NOT NULL AUTO_INCREMENT,
title varchar(255) NOT NULL,
code longtext NOT NULL,
created_at datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
)");
// Handle form submission
if (isset($_POST['save_snippet']) && isset($_POST['title']) && isset($_POST['code'])) {
$title = sanitize_text_field($_POST['title']);
$code = $_POST['code'];
if (!empty($title) && !empty($code)) {
$result = $wpdb->insert($table_name, array(
'title' => $title,
'code' => $code
), array('%s', '%s'));
if ($result) {
echo '✓ Snippet saved successfully! ID: ' . $wpdb->insert_id . '
✗ Failed to save. Error: ' . $wpdb->last_error . '
Please fill in all fields.
';
echo '
Simple Snippet Saver
';
echo '
';
// Show existing snippets
echo '
Existing Snippets
';
$snippets = $wpdb->get_results("SELECT * FROM $table_name ORDER BY id DESC");
if ($snippets) {
echo '
';
echo '| ID | Title | Code Preview | Created |
|---|
';
echo '';
foreach ($snippets as $snippet) {
echo '';
echo '| ' . $snippet->id . ' | ';
echo '' . esc_html($snippet->title) . ' | ';
echo '' . esc_html(substr($snippet->code, 0, 100)) . (strlen($snippet->code) > 100 ? '...' : '') . ' | ';
echo '' . $snippet->created_at . ' | ';
echo '
';
}
echo '
';
} else {
echo '
No snippets yet.
';
}
echo '