How do I save a string from database query using codeigniter

Question

I am trying to save data into a string that can later be used.

this is the code that I have thus far:

$phone_numbers = $this->phone_model->get_all()->result();

$string = '';
foreach($phone_numbers as $cel){
    $string .= 'Phone #: ';
    $string .= $cel->cel_num;
    $string .= '<br/>';
}
$data['string'] = $string;

my database has:

id    cel_num
1     1324567890
2     1515744243
3     6516515225

There can be more or less

Then in my view I just have it as echo $string to echo the data

$html .='
<br/>
<br/>
<br/>
<br/>
<br/>
<table width="90%" align="center" style="border-bottom: 1px solid #000;">
    <tr>
        <th style="font-size:14px;" align="center">'.$contact->name.'<br />
            <div style="font-size:10px">
            '.$contact->addr.'<br />
            ////////// HERE IS WHERE I WANT TO ECHO THE NUMBERS/////////
            '.$string.'
            </div>
        </th>
    </tr>
    <tr>
    <th style="font-size:12px; font-weight:bold;" align="left">
    PHONE BOOK</th></tr>
</table>';

Is any of this being echoed, or just $string isn't working? — Michael Hommé
– Michael Hommé, Commented Aug 10, 2016 at 22:19

Lorenzo · Accepted Answer · 2016-08-11 01:47:57Z

You have an array and that is why you need a foreach loop. Here is the code that you need. I'll change it into something more simpler.

CONTROLLER FUNCTION

function display_numbers()
{
    $data['phone_numbers'] = $this->phone_model->get_all();
    //I made this into an array and removed the result, 
    //we will be getting that from the database.

    //I removed the String part for it is maybe not necessary, I'll echo it in the view

    $this->load->view('my_view', $data);
}

MODEL FUNCTION

function get_all()
{
    $this->db->select('*');
    $this->db->from('your_table');
    $query = $this->db->get();
    return $query->result();
    //This way we return this result automatically to the call
}

View

Important note, Don't mix php with html, or if you can don't over do it.

    <table width="90%" align="center" style="border-bottom: 1px solid #000;">
        <tr>
            <th style="font-size:14px;" align="center">'.$contact->name.'<br />
                <div style="font-size:10px">


                 <ul>
                 <?php foreach($phone_numbers as $cel) ?>
                   <li> <?php echo $cel->cel_num  </li>
                 <?php endforeach ?>
                 </ul>


                </div>
            </th>
        </tr>
        <tr>
        <th style="font-size:12px; font-weight:bold;" align="left">
        PHONE BOOK</th></tr>
    </table>';

Good luck!!

Kelvin · Accepted Answer · 2016-08-12 06:21:25Z

0

change your :

$data["string"] = $string

to this

$data["string"][] = $string

edited Aug 12, 2016 at 6:21

answered Aug 11, 2016 at 4:44

Kelvin

1,1041 gold badge10 silver badges32 bronze badges

1 Comment

Blue Over a year ago

While this code snippet may solve the question, including an explanation really helps to improve the quality of your post. Remember that you are answering the question for readers in the future, and those people might not know the reasons for your code suggestion. Please also try not to crowd your code with explanatory comments, as this reduces the readability of both the code and the explanations!

Collectives™ on Stack Overflow

How do I save a string from database query using codeigniter

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related