Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement