prefix . 'accordions_or_faqs_items'; $table_name = $wpdb->prefix . 'accordions_or_faqs_style'; $title = ''; $files = ''; $icon = ''; $itemid = ''; if (!empty($_REQUEST['_wpnonce'])) { $nonce = $_REQUEST['_wpnonce']; } if (!empty($_POST['submit']) && $_POST['submit'] == 'submit') { if (!wp_verify_nonce($nonce, 'accordionsnewdata')) { die('You do not have sufficient permissions to access this page.'); } else { $title = sanitize_text_field($_POST['afoxi-title']); $details = sanitize_text_field($_POST['afoxi-details']); $css = sanitize_text_field($_POST['afoxi-icon']); if ($_POST['item-id'] == '') { $wpdb->query($wpdb->prepare("INSERT INTO {$table_list} (title, files, css, styleid) VALUES ( %s, %s, %s, %d)", array($title, $details, $css, $styleid))); } if ($_POST['item-id'] != '' && is_numeric($_POST['item-id'])) { $item_id = (int) $_POST['item-id']; $data = $wpdb->update("$table_list", array("title" => $title, "files" => $details, "css" => $css), array('id' => $item_id), array('%s', '%s', '%s'), array('%d')); } } } if (!empty($_POST['edit']) && is_numeric($_POST['item-id'])) { if (!wp_verify_nonce($nonce, 'accordionseditdata')) { die('You do not have sufficient permissions to access this page.'); } else { $item_id = (int) $_POST['item-id']; $data = $wpdb->get_row($wpdb->prepare("SELECT * FROM $table_list WHERE id = %d ", $item_id), ARRAY_A); $title = accordions_or_faqs_oxilab_special_charecter($data['title']); $files = accordions_or_faqs_oxilab_special_charecter($data['files']); $icon = accordions_or_faqs_oxilab_special_charecter($data['css']); $itemid = $data['id']; echo ''; } } if (!empty($_POST['delete']) && is_numeric($_POST['item-id'])) { if (!wp_verify_nonce($nonce, 'accordionsdeletedata')) { die('You do not have sufficient permissions to access this page.'); } else { $item_id = (int) $_POST['item-id']; $wpdb->query($wpdb->prepare("DELETE FROM {$table_list} WHERE id = %d ", $item_id)); } } if (!empty($_POST['data-submit']) && $_POST['data-submit'] == 'Save') { if (!wp_verify_nonce($nonce, 'accordionsstyledata')) { die('You do not have sufficient permissions to access this page.'); } else { $data = 'heading-font-size |' . sanitize_text_field($_POST['heading-font-size']) . '| heading-font-color |' . sanitize_hex_color($_POST['heading-font-color']) . '|heading-font-active-color |' . sanitize_hex_color($_POST['heading-font-active-color']) . '| heading-background-color |' . sanitize_hex_color($_POST['heading-background-color']) . '|heading-background-active-color |' . sanitize_hex_color($_POST['heading-background-active-color']) . '|heading-border-color |' . sanitize_hex_color($_POST['heading-border-color']) . '|heading-border-active-color |' . sanitize_hex_color($_POST['heading-border-active-color']) . '| heading-font-familly |' . sanitize_text_field($_POST['heading-font-familly']) . '| heading-font-weight |' . sanitize_text_field($_POST['heading-font-weight']) . '|' . ' heading-padding |' . sanitize_text_field($_POST['heading-padding']) . '| heading-margin-bottom |' . sanitize_text_field($_POST['heading-margin-bottom']) . '| heading-icon-size |' . sanitize_text_field($_POST['heading-icon-size']) . '| heading-icon-width |' . sanitize_text_field($_POST['heading-icon-width']) . '|' . ' heading-box-shadow |' . sanitize_text_field($_POST['heading-box-shadow']) . '| heading-box-shadow-color |' . sanitize_hex_color($_POST['heading-box-shadow-color']) . '|' . ' content-font-size |' . sanitize_text_field($_POST['content-font-size']) . '| content-font-color |' . sanitize_hex_color($_POST['content-font-color']) . '| content-background-color |' . sanitize_hex_color($_POST['content-background-color']) . '| content-padding-top |' . sanitize_text_field($_POST['content-padding-top']) . '| content-padding-right |' . sanitize_text_field($_POST['content-padding-right']) . '| content-padding-bottom |' . sanitize_text_field($_POST['content-padding-bottom']) . '| content-padding-left |' . sanitize_text_field($_POST['content-padding-left']) . '|' . ' content-line-height |' . sanitize_text_field($_POST['content-line-height']) . '| content-font-familly |' . sanitize_text_field($_POST['content-font-familly']) . '| content-font-weight |' . sanitize_text_field($_POST['content-font-weight']) . '|' . ' content-text-align |' . sanitize_text_field($_POST['content-text-align']) . '| content-box-shadow |' . sanitize_text_field($_POST['content-box-shadow']) . '| content-box-shadow-color |' . sanitize_hex_color($_POST['content-box-shadow-color']) . '||'; $data = sanitize_text_field($data); $wpdb->query($wpdb->prepare("UPDATE $table_name SET css = %s WHERE id = %d", $data, $styleid)); } } $listdata = $wpdb->get_results($wpdb->prepare("SELECT * FROM $table_list WHERE styleid = %d ORDER by id ASC ", $styleid), ARRAY_A); $styledata = $wpdb->get_row($wpdb->prepare("SELECT * FROM $table_name WHERE id = %d ", $styleid), ARRAY_A); $styledata = $styledata['css']; $styledata = explode('|', $styledata); ?>

'; foreach ($listdata as $value) { echo '

' . accordions_or_faqs_oxilab_special_charecter($value['title']) . '

' . accordions_or_faqs_oxilab_special_charecter($value['files']) . '

'; } echo '

'; ?>

Edit Title

Edit Content