prefix . 'accordions_or_faqs_items'; $table_name = $wpdb->prefix . 'accordions_or_faqs_style'; $title = ''; $files = ''; if (!empty($_REQUEST['_wpnonce'])) { $nonce = $_REQUEST['_wpnonce']; } $Icon = 'fa-coffee'; $titlecolor = '#fff'; $backgroundcolor = '#ccc'; $Iconbackgroundcolor = '#d55252'; $itemid = ''; 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 = 'font-awesome-icon|' . sanitize_text_field($_POST['afoxi-icon']) . '| font-color|' . sanitize_hex_color($_POST['afoxi-tite-color']) . '| afoxi-background-color|' . sanitize_hex_color($_POST['afoxi-background-color']) . '| afoxi-icon-background-color|' . sanitize_hex_color($_POST['afoxi-icon-background-color']) . '|'; $css = sanitize_text_field($css); 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']); $css = explode('|', $data['css']); $Icon = $css[1]; $titlecolor = $css[3]; $backgroundcolor = $css[5]; $Iconbackgroundcolor = $css[7]; $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-familly |' . sanitize_text_field($_POST['heading-font-familly']) . '| heading-font-weight |' . sanitize_text_field($_POST['heading-font-weight']) . '|' . ' heading-padding-top |' . sanitize_text_field($_POST['heading-padding-top']) . '| heading-padding-left |' . sanitize_text_field($_POST['heading-padding-left']) . '| heading-margin |' . sanitize_text_field($_POST['heading-margin']) . '| heading-icon-size |' . sanitize_text_field($_POST['heading-icon-size']) . '| heading-icon-active-size |' . sanitize_text_field($_POST['heading-icon-active-size']) . '| heading-icon-width |' . sanitize_text_field($_POST['heading-icon-width']) . '| heading-icon-active-width |' . sanitize_text_field($_POST['heading-icon-active-width']) . '| heading-box-shadow |' . sanitize_text_field($_POST['heading-box-shadow']) . '| heading-box-shadow-color |' . sanitize_text_field($_POST['heading-box-shadow-color']) . '|' . ' content-font-size |' . sanitize_text_field($_POST['content-font-size']) . '| 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']) . '||'; $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) { $cssdata = explode('|', $value['css']); echo '

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

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

'; } ?>

Edit Title

Edit Content