How do I write a codeigniter badge?

Question

How do I count all unread email for a specific user and put it on a badge: The files are here.

Location code/function:

crud_model // message number apper count per user // START
header // message number apper count per user // START

Example: The Admin have 10 message total (8 read message + 2 unread message). The badge show 2 unread message.

<?php
$current_user = $this->session->userdata('login_type') . '-' . $this->session->userdata('login_user_id');
$this->db->where('sender', $current_user);
$this->db->or_where('reciever', $current_user);
$message_threads = $this->db->get('message_thread')->result_array();
$unread_message_number = count($message_threads);
?> 
<a href="<?php echo base_url();?>index.php?teacher/message">  
<i class="entypo-mail"></i>
Message
<span class="badge badge-secondary"><?php echo $unread_message_number; ?></span>
</a>
</li>
<?php endif;?>

The existent controller:

function count($message_thread_code) {
    $unread_message_counter = 0;
    $current_user = $this->session->userdata('login_type') . '-' . $this->session->userdata('login_user_id');
    $messages = $this->db->get_where('message', array('message_thread_code' => $message_thread_code))->result_array();
    foreach ($messages as $row) {
        if ($row['sender'] != $current_user && $row['read_status'] == '0')
            $unread_message_counter++;
    }
    return $unread_message_counter;
}

I want to count the total number of unread messages from the logged user.

score 0 · Answer 1 · answered Mar 08 '17 at 14:21

0

All you need to do is count the number of $message_threads, right?

...
$message_threads = $this->db->get('message_thread')->result_array();
$unread_message_number = count($message_threads);

And then send $unread_message_number to your view. You put everything together in your example, I only imagine your model, view, and controller are separate in your actual app though.

answered Mar 08 '17 at 14:21

Pacio

523
4
11

You should probably post the relevant code then, there's no way for anyone to know how you calculate unread email – Pacio Mar 08 '17 at 14:42

Michael Krikorev · Accepted Answer · 2017-03-08T20:30:16.690

0

You should not name a method or function the same as a native PHP function like count(). Remove the method, and instead just use Codeigniters count_all_results()

Try this:

<?php
    $current_user = $this->session->userdata('login_type') . '-' . $this->session->userdata('login_user_id');
    $this->db->where('message_thread.reciever', $current_user);
    $this->db->where('message.read_status', 0);
    $this->db->from('message_thread');
    $this->db->join('message', 'message.message_thread_code = message_thread.message_thread_code');
    $unread_message_number = $this->db->count_all_results(); 
?>

Since you do not have a reciever id in your table message, we are making a join to be able to query the current user. In my example I assume that you have the column message_thread_code as the foreign key between the messages and the tread?

If this example works, you do not need the custom count() method in your controller.

Alternative 2: To make the code cleaner, you could put the logic inside a method in the controller:

function count_unread(){
    $current_user = $this->session->userdata('login_type') . '-' . $this->session->userdata('login_user_id');
    $this->db->where('message_thread.reciever', $current_user);
    $this->db->where('message.read_status', 0);
    $this->db->from('message_thread');
    $this->db->join('message', 'message.message_thread_code = message_thread.message_thread_code');
    return $this->db->count_all_results(); 
}

And then remove the PHP-code and only use this in your header:

<?php if($account_type == 'teacher'):?> 
<li>
    <a href="<?php echo base_url();?>index.php?teacher/message">  
    <i class="entypo-mail"></i>
    Message
    <span class="badge badge-secondary"><?php echo count_unread(); ?></span>
    </a>
</li>
<?php endif;?>

edited Mar 08 '17 at 20:30

answered Mar 08 '17 at 17:25

Michael Krikorev

2,126
1
18
25

1. From where i remove the method (controller or view_badge.php?)? 2. The table are message_thread with row (message_thread_id, message_thread_code, sender, reciever, last_message_timestamp) message with row (message_id, message_thread_code, message, sender, timestamp, read_status <0 unread, 1read>)3. I rename count function with count_all_results() and the result is 505 error Sorry i am new......i don't know very well php + codeigniter. 4. If you can provide me the full code.Thanks – RADU Ionut-Valentin Mar 08 '17 at 18:44
OK, do you want to count ALL unread messages for a user? (as you state in your question)? Or do you want to count all unread messages in a specific thread as you seem to do in your count function? – Michael Krikorev Mar 08 '17 at 19:22
I want to count all unread message for a user. Example Admin have 2 unread message from XX message. Student have 3 unread message from YY mesage. – RADU Ionut-Valentin Mar 08 '17 at 19:37
And it seems that you have not included the whole view in your question? I can se a php `endif` but no `if`? Are you i a middle of a loop or something in your view? – Michael Krikorev Mar 08 '17 at 19:38
"2 unread message from XX message"? Do you really mean all unread messages from all senders and message threads for this user? – Michael Krikorev Mar 08 '17 at 19:41
At this moment he shows me the total number of messages for a specific user. I want to show the total number of unread messages for a specific user. – RADU Ionut-Valentin Mar 08 '17 at 19:41
If it helps I attached files https://drive.google.com/drive/folders/0B46C63I5qC1ic3B1QXR3Vm1KZjA?usp=sharing – RADU Ionut-Valentin Mar 08 '17 at 19:50
in crud_model the function is located // message number apper count per user // START and header the code are located – RADU Ionut-Valentin Mar 08 '17 at 19:52
Ok, I have update my answer. I have not tried the code, but its close to something that should work. And you dont need the function `count()` – Michael Krikorev Mar 08 '17 at 20:09
You are briliant – RADU Ionut-Valentin Mar 08 '17 at 20:43
Thanks, great that it worked for you... You should also remove some duplicate `` tags you have in header.php where lots of nested ``-tags.. Guess they should be removed? – Michael Krikorev Mar 08 '17 at 20:48
I have another problem. If you want pleasee see http://stackoverflow.com/questions/42718625/display-monthly-attendance-report-of-an-student – RADU Ionut-Valentin Mar 10 '17 at 18:06

How do I write a codeigniter badge?

2 Answers2