Online PHP editor | refs for aXWeg

<?php global $wpdb; $charset_collate = $wpdb->get_charset_collate(); $phantom_option = $wpdb->prefix . 'phantom_option'; $phantom_menu = $wpdb->prefix . 'phantom_menu'; $wc_all_defult_and_undefult_array = array_keys(wc_get_account_menu_items()); $pa_custom_tab_endpoints = $wpdb->get_results("SELECT pa_menu_endpoint FROM $phantom_menu WHERE pa_menu_from='pa_custom_tab'"); // Extract the values from $pa_custom_tab_endpoints $pa_custom_tab_endpoints_list = array_map(function($item) { return $item->pa_menu_endpoint; }, $pa_custom_tab_endpoints); // Remove the values in $pa_custom_tab_endpoints from $wc_all_defult_and_undefult_array $wc_all_defult_endpoints_array = array_diff($wc_all_defult_and_undefult_array, $pa_custom_tab_endpoints_list); foreach($wc_all_defult_endpoints_array as $wcendpoint){ $result=$wpdb->get_results("select * from $phantom_menu WHERE pa_menu_endpoint='$wcendpoint'"); foreach ($result as $row) $row->pa_menu_endpoint; if(!$result){ $wpdb->query(" INSERT INTO `$phantom_menu` (`pa_menu_endpoint`, `pa_menu_from`) VALUES ('$wcendpoint', 'wc')"); } }