how to display specific value from array fetched from database codeigniter

Question

I'm new to Codeignitor. My senior had previously used the following code to retrieve an array from a database. It retrieves all of the items in the database, but I only want the first one, Please Help:

 <?php $custom_fields = get_custom_fields('projects');
         if(count($custom_fields) > 0){ ?>
         <?php foreach($custom_fields as $field){ ?>
         <?php $value = get_custom_field_value($project->id,$field['id'],'projects');
         if($value == ''){continue;} ?>
         <tr>
            <td class="bold"><?php echo ucfirst($field['name']); ?></td>
            <td><?php echo $value; ?></td>
         </tr>
         <?php } ?>
         <?php } ?>  ```

**I attempted to retrieve the data using index key [1], but I failed miserably.**

``<?php $custom_fields = get_custom_fields('projects');
         if(count($custom_fields) > 0){ ?>
         <?php foreach($custom_fields as $field){ ?>
         <?php $value = get_custom_field_value($project->id,$field['id'],'projects');
         if($value == ''){continue;} ?>
         <tr>
            <td class="bold"><?php echo ucfirst($field[0 &&'name']); ?></td>
            <td><?php echo $value[0]; ?></td>
         </tr>
         <?php } ?>
         <?php } ?> ```

I tried using index key [0] but i got miserably failed.

Add controller function also. That will be more helpful to give you right approach — RioSant, Sep 30 '22 at 09:51

IT goldman · Answer 1 · 2022-09-30T19:27:30.070

Then break out of the foreach loop after 1 item.

<?php 
    $custom_fields = get_custom_fields('projects');
    $count = 0;
    $stop_after = 3;
    if(count($custom_fields) > 0) { 
        foreach($custom_fields as $field){ 
            $value = get_custom_field_value($project->id,$field['id'],'projects');
            if($value == ''){continue;} ?>
            <tr>
                <td class="bold"><?php echo ucfirst($field['name']); ?></td>
                <td><?php echo $value; ?></td>
            </tr>
            <?php 
            $count++;
            if ($count == $stop_after) {
                break;
            }
        } 
    } 
?>

Awesome! worked for me i got the first value, what if i want 3rd or fourth item, can you help me that — Rohan Jaiswal, Sep 30 '22 at 18:06

how to display specific value from array fetched from database codeigniter

1 Answers1