function liq_spp_insertdb() { global $wpdb; if (isset($_POST['liq_spp_term'])) { $aterm = array(); if (isset($_POST['spp_linebreak'])) { $aterm = explode("\n", $_POST['liq_spp_term']); } else { $aterm = explode(',', $_POST['liq_spp_term']); } if (sizeof($aterm) > 0) { $tot = 0; foreach ($aterm as $term) { if (!empty($term) && spp_filter_before_save($term)) { if ($wpdb->query($wpdb->prepare("INSERT IGNORE INTO " . $wpdb->prefix . "spp (`term` ) VALUES ( %s )", trim($term)))) { $tot++; } } } } echo '<div id="message" class="updated"> <p style="text-align:center;"><strong>' . $tot . '</strong> of <strong>' . sizeof($aterm) . '</strong> total terms inserted.</p> </div>'; } }
function spp_save_term($term) { global $wpdb; if (spp_filter_before_save($term) == false) { return false; } // buat jadi lower case sebelum insert $term = strtolower(trim($term)); if (empty($term)) { return false; } $success = $wpdb->query($wpdb->prepare("INSERT IGNORE INTO " . $wpdb->prefix . "spp (`term` ) VALUES ( %s )", $term)); return $success; }
function liq_spp_save_term($term){ global $wpdb; if( !empty($term) && spp_filter_before_save($term) ){ if($wpdb->query( $wpdb->prepare( "INSERT IGNORE INTO ".$wpdb->prefix."spp (`term` ) VALUES ( %s )", trim($term) )) ) return true; else return false; } }