<?php

//$username=$_SESSION['username'];
//$receiver=$_SESSION['receiver'];

$palidsender=$_POST['palidsender'];
$palidreceiver=$_POST['palidreceiver'];


//$username= '445';
//$receiver='447';
//$username ="nosa";
//$receiver="praise";

                                  $db = new PDO('mysql:host=127.0.0.1;dbname=smartsmsrouter','smsEngine','guEnaR28T');
                                //  $query ="SELECT * FROM Penpalchatmessages where (Palidsender='$palidsender' and Palidreceiver='$palidreceiver') or (Palidsender='$palidreceiver' and Palidreceiver='$palidsender') order by sn limit 100";
                                  //echo $query;
                                  //die();

                                  $query = $db->prepare("SELECT palidsender,palsender,palidreceiver,palreceiver,message,DATE_FORMAT(datesent, '%h:%i %p') as datesent, datediff(datesent,now()) as datecompare, DATE_FORMAT(datesent, '%d/%m/%Y') as workdate, messageread FROM Penpalchatmessages where (Palidsender='$palidsender' and Palidreceiver='$palidreceiver') or (Palidsender='$palidreceiver' and Palidreceiver='$palidsender') order by sn limit 100") ;
                                  $query->execute();

                                  //Fetch

                                  $dateprevious= "";

                                  while ($fetch = $query->fetch(PDO::FETCH_ASSOC)){
                                    //echo $palidsender;
                                  //  die();

                                    $cpalidsender =$fetch['palidsender'];
                                    $cpalidreceiver =$fetch['palidreceiver'];
                                    $cnickname =$fetch['palsender'];
                                    $message =$fetch['message'];
                                    $cnicknameother =$fetch['palreceiver'];
                                    $datesent =$fetch['datesent'];
                                    $messageread =$fetch['messageread'];
                                    $workdate =$fetch['workdate'];
                                    $datecompare=$fetch['datecompare'];

                                    if($workdate != $dateprevious){
                                    $datedisplay= "";
                                    if( $datecompare == "0")
                                      $datedisplay= "Today";
                                    if( $datecompare == "-1")
                                      $datedisplay= "Yesterday";
                                    if($datedisplay =="")
                                        $datedisplay = $workdate;

                                    echo "<ul class='chat'>
                                    <li class='clearfix'>

                                        <div class='chat-body clearfix'>
                                            <div style='text-align: center;'  >


                                                <p>
                                                   <span class='label label-success'>  $datedisplay </span><br>
                                                </p>



                                            </div>




                                        </div>
                                    </li>

                                </ul>";

                              }//
                              $dateprevious = $workdate;


                                    if(($palidsender==$cpalidsender) && ($palidreceiver==$cpalidreceiver)){
                                        //Palidsender='445' and Palidreceiver='447'
                                  echo "<ul class='chat'>
                                  <li class='right clearfix'>
                                      <span class='chat-img pull-right'>
                                        <img src='assets/img/subscribers/".$palidsender."/profile/".$palidsender.".jpg'  alt='User Avatar' class='img-circle' />
                                      </span>
                                      <div class='chat-body clearfix'>
                                          <div class='header'  >

                                              <strong class='pull-right primary-font'>".   ucwords($cnickname) ."</strong>
                                              <br/>
                                              <p>
                                                 <span class='pull-right'>  $message </span><br>
                                              </p>

                                              <small class='text-muted pull-right'>";
                                              if($messageread=="1")
                                                  echo " $datesent <img src='assets/img/icon/icon-read2.png' alt =''/>   </small>";
                                              else {
                                                echo " $datesent <img src='assets/img/icon/icon-delivered2.png' alt =''/>  </small>";
                                              }

                                          echo "</div>




                                      </div>
                                  </li>

                              </ul>";
                            }//end of username

                            if(($palidsender==$cpalidreceiver) && ($palidreceiver==$cpalidsender)){
                              //(palidsender='447' and Palidreceiver='445')

                              echo "<ul class='chat'>
                                  <li class='left clearfix'>
                                      <span class='chat-img pull-left'>
                                          <img src='assets/img/subscribers/".$palidreceiver."/profile/".$palidreceiver.".jpg' alt='User Avatar' class='img-circle' />
                                      </span>
                                      <div class='chat-body clearfix'>
                                          <div class='header'>
                                              <strong class='primary-font '> ". ucwords($cnickname)." </strong>
                                              <br />
                                             <p>
                                                 $message
                                             </p>

                                              <small class='pull-left text-muted '>
                                                  <i class='icon-time'></i> $datesent </small>
                                          </div>

                                      </div>
                                  </li>
                                </u>";
                            }// end of receiver

                          }// end of while loop



?>