[ create a new paste ] login | about

Link: http://codepad.org/nWiPTuME    [ raw code | output | fork ]

PHP, pasted on Oct 12:
<?php
$get_elements = array (
    'student_elements'     => 'firstname,lastname,mobileno,age,gender',
    'address_elements'     => 'building,sector,city',
    'marketing_elements'     => NULL,
    'office_use_elements'     => 'counsellername,mobile,email'
);

// Combine all strings
$get_elements = implode(',',$get_elements);

// DEBUGGING ONLY
echo $get_elements;

// Split the elements
$get_elements = explode(',', $get_elements);

// DEBUGGING ONLY
echo '<pre>'.var_export($get_elements, TRUE).'</pre>';

// YOUR CODE
foreach ($get_elements as $value) {
    // Ensure it's not empty
    if($value != ''){
        echo $sql_elements_get="SELECT fields_name, fields_type FROM `tbl_form_builder_fields` WHERE fields_name='".$value."'";
    }
}

?>


Output:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
firstname,lastname,mobileno,age,gender,building,sector,city,,counsellername,mobile,email<pre>array (
  0 => 'firstname',
  1 => 'lastname',
  2 => 'mobileno',
  3 => 'age',
  4 => 'gender',
  5 => 'building',
  6 => 'sector',
  7 => 'city',
  8 => '',
  9 => 'counsellername',
  10 => 'mobile',
  11 => 'email',
)</pre>SELECT fields_name, fields_type FROM `tbl_form_builder_fields` WHERE fields_name='firstname'SELECT fields_name, fields_type FROM `tbl_form_builder_fields` WHERE fields_name='lastname'SELECT fields_name, fields_type FROM `tbl_form_builder_fields` WHERE fields_name='mobileno'SELECT fields_name, fields_type FROM `tbl_form_builder_fields` WHERE fields_name='age'SELECT fields_name, fields_type FROM `tbl_form_builder_fields` WHERE fields_name='gender'SELECT fields_name, fields_type FROM `tbl_form_builder_fields` WHERE fields_name='building'SELECT fields_name, fields_type FROM `tbl_form_builder_fields` WHERE fields_name='sector'SELECT fields_name, fields_type FROM `tbl_form_builder_fields` WHERE fields_name='city'SELECT fields_name, fields_type FROM `tbl_form_builder_fields` WHERE fields_name='counsellername'SELECT fields_name, fields_type FROM `tbl_form_builder_fields` WHERE fields_name='mobile'SELECT fields_name, fields_type FROM `tbl_form_builder_fields` WHERE fields_name='email'


Create a new paste based on this one


Comments: