top of page

Get Row and Get Result from Global $wpdb

  • Writer: سُلَيْمَان بْن دَاوُوْد
    سُلَيْمَان بْن دَاوُوْد
  • Jul 29, 2020
  • 1 min read


	public static function get_juridiction_city_from_user_zip($zipcode){

		global $wpdb; 
		$sql = "SELECT * FROM ".$wpdb->prefix."dk_speakout_parish_zip WHERE zipcode =".$zipcode ;

    	$result = $wpdb->get_row( $sql );

		if ( $result  ) {
			$city = $result->city;
		}

		if($city){
			$citysql  = "SELECT * FROM ".$wpdb->prefix."dk_speakout_parish WHERE city = '".$city."' ";
			$parishes =  $wpdb->get_results($citysql);

			return    $parishes; 
		}


	}


Recent Posts

See All
Hide Upcoming Events

Hiding Upcoming Events can be relatively useful when you are using ACF fields to show Dates for an an Event The Following Snippet is an...

 
 
 

Comments


© 2020 by syednazrulhassan

bottom of page