Help! How to display selected data from json file using search option

The aim of what I would like to do is allow the user to select a classification and a list of jobs for that selected classification is displayed. Currently, I have the search bar displaying the classifications and all of the jobs are displayed. What is do I have to change in my code to allow the search option to function? I’m using two files which are a json file and a php file. The json file contains classifications such as Tradesperson and related workers. In each classification are a list of two jobs.

jobsfinal_v3.json file looks like this:

“id”: 1,
“cname”: “Generalist managers”,
“jobs”: [“Directors”, “Building and Construction manager”]
“id”: 2,
“cname”: “Specialist managers”,
“jobs”: [“School Principal”, “Finance managers”]
“id”: 3,
“cname”: “Science, Building and Engineering professionals”,
“jobs”: [“Mining Engineer”, “Architects”]
“id”: 4,
“cname”: “Business and Information professionals”,
“jobs”: [“Accountants”, “Marketing and advertising”]
“id”: 5,
“cname”: “Tradespersons and related workers”,
“jobs”: [“Electrician”, “Mechanics”]
“id”: 6,
“cname”: “Production and Transport Workers”,
“jobs”: [“Road and Rail Transport drivers”, “Miners”]

jobsfinal_v5.php file looks like this:


//new code

// an array of ids for each classification
$jobtitles = array(
    'Select a classification' => '0', 
    'General managers' => '1',
    'Specialist managers' => '2',
    'Science, Building and Engineering professionals' => '3',
    'Business and Information professionals' => '4',
    'Tradesperson and related workers' => '5'

// check if a classifications has already been selected, otherwise set it to the first key
if (isset($_GET["jobtitle"])) {
    $jobtitle = $_GET["jobtitle"];
} else {
    $jobtitle = key($jobtitles);

// retrieve the classifications from the array for the selected classification and build the url
$url = 'jobsfinal_v3.'.$jobtitles[$jobtitle].'.json';

// set up a form that loads the current page (with get method)
echo '<form name="classification" method="get" action="'.htmlentities($_SERVER['PHP_SELF']).'">';

// a drop down select box that will submit the form when changed
echo 'Classifications for <select name="jobtitle" onchange="this.form.submit()">';

// iterate through the classifications in the array to build the drop down box options
foreach ($jobtitles as $l => $u) {
    if ($jobtitle == $l) {
        $selected = ' selected';
    } else {
        $selected = '';
    echo '<option'.$selected.' value="'.$l.'">'.$l.'</option>';
// close the select and form
echo '</select>';
echo '</form>';

//To display all of the contents of the json file
// Define recursive function to extract nested values
function printValues($arr) {
    global $count;
    global $values;
    // Check input is an array
        die("ERROR: Input is not an array");
    Loop through array, if value is itself an array recursively call the
    function else add the value found to the output items array,
    and increment counter by 1 for each value found
    foreach($arr as $key=>$value){
        } else{
            $values[] = $value;
// Return total count and values found in array
    return array('total' => $count, 'values' => $values);

$json = file_get_contents('jobsfinal_v3.json');
// Decode JSON data into PHP associative array format
$arr = json_decode($json, true);
// Call the function and print all the values
$result = printValues($arr);
echo "<h3>" . $result["total"] . " value(s) found: </h3>";
echo implode("<br>", $result["values"]);

Output from these two files:

Hey there,
When you enter a code block into a forum post, please precede it with a separate line of three backticks and follow it with a separate line of three backticks to make it easier to read.

You can also use the “preformatted text” tool in the editor (</>) to add backticks around text.

See this post to find the backtick on your keyboard.
Note: Backticks (`) are not single quotes (').

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.