<?php

function getFormIds() {

	global $wpdb;

	$sql = "
			SELECT a.id
			FROM wp_rg_lead a
			WHERE a.form_id = 10 AND a.payment_status = 'Approved'
	";

	$query = $wpdb->get_results($sql);

	if($query)
		return $query;

	return false;

}

function getFormInfo($form_id) {

	global $wpdb;
	$sql = "
			SELECT *
			FROM wp_rg_lead_detail
			WHERE lead_id = $form_id
			";

	$query = $wpdb->get_results($sql);

	if($query)
		return $query;

	return false;

}


$credit_card_form_ids = getFormIds();

if ( $credit_card_form_ids ) {

	$entries = array();

	foreach( $credit_card_form_ids as $entry) {

		$single_entry = getFormInfo($entry->id);

		if ( $single_entry ) {

			$entry_array = array();
			$full_array = array();

			foreach( $single_entry as $entry ) {
				$curr_array = array( $entry->field_number => strip_tags($entry->value));
				$entry_array[$entry->field_number] = strip_tags($entry->value);
				array_push($full_array, $entry_array);
			}
		}
	}
	#var_dump('full_array', $full_array);
}