SQL

****** Count "yes" or "no" **************
SELECT COUNT(case when decision="yes" THEN decision end )as yes, COUNT(case when decision="no" THEN decision end )as no, COUNT(case when decision="unsure" THEN decision end ) as unsure,COUNT(decision) FROM `election` WHERE `dispute_id` = '2'
_____________________________________________

SELECT MAX(`date`) FROM stylist_payment WHERE `stylitid` ='390'

> SELECT MAX(`date`) FROM stylist_payment GROUP BY `stylitid`

> SELECT `stylist_payment`.`stylitid`, `stylitamount`, `percentage`, `si_amount`, `stylist_payment`.`date` FROM `stylist_payment` LEFT JOIN `booking` ON `booking`.`stylitid` = `stylist_payment`.`stylitid`GROUP BY `stylitid`


SELECT MAX(`stylist_payment`.`date`) FROM stylist_payment LEFT JOIN `user` ON `user`.`id` = `stylist_payment`.`stylitid` GROUP BY `stylitid`

SELECT stylitid,total_amount,user.username,user.firstname,user.lastname,user.contact,user.email,SUM(booking.total_amount) as totalamt FROM `booking` LEFT JOIN `user` ON `user`.`id` = `booking`.`stylitid` WHERE `booking`.`status` = 'complete' GROUP BY `stylitid`

SELECT stylitid,total_amount,user.username,user.firstname,user.lastname,user.contact,user.email, SUM(booking.total_amount) as totalamt FROM `booking` LEFT JOIN `user` ON `user`.`id` = `booking`.`stylitid` WHERE `booking`.`status` = 'complete' AND `booking`.`date` > '2018-09-13 07:17:00' GROUP BY `stylitid`


$result = array();
$query = $this->db->query("SELECT * FROM message WHERE stylitid = '$stylitid' AND (userid = '$userid' OR replyBy = '$userid') ORDER BY id");
foreach ($query->result() as $getmsg)
{
$data = array(
'id'    =>   $getmsg->id,
'stylitid'    =>   $getmsg->stylitid,
'userid'    =>   $getmsg->userid,
'bookingId'    =>   $getmsg->bookingId,
'message'    =>   $getmsg->message,
'replyBy'    =>   $getmsg->replyBy,
'date'    =>   $getmsg->date
);
array_push($result,$data);
}
print_r(json_encode($result));
_________________________________________________________


SELECT booking.*, `booking`.`stylitid`,`user`.`username`,`user`.`firstname`,`user`.`lastname`,`user`.`contact`,`user`.`email`,SUM(`booking`.`total_amount`) as `totalamtsum`,`stylist_payment`.`si_amount`,max(`stylist_payment`.`date`) as `paiddate` FROM `booking` LEFT JOIN `user` ON `user`.`id` = `booking`.`stylitid` LEFT JOIN `stylist_payment` ON `stylist_payment`.`stylitid` = `booking`.`stylitid` INNER JOIN ( select `stylitid`, max(`date`) as `MaxDate` from `booking` group by `stylitid` ) `tm` on `booking`.`stylitid` = tm.`stylitid` and `booking`.`date` = `tm`.`MaxDate` WHERE `booking`.`status` = 'complete' Group By `stylitid`

----
SELECT `booking`.`stylitid`,`user`.`username`,`user`.`firstname`,`user`.`lastname`,`user`.`contact`,`user`.`email`,SUM(`booking`.`total_amount`) as `totalamtsum`,`booking`.`total_amount` as `totalamount`,`stylist_payment`.`si_amount`,max(`stylist_payment`.`date`) as `paiddate` FROM `booking` LEFT JOIN `user` ON `user`.`id` = `booking`.`stylitid` LEFT JOIN `stylist_payment` ON `stylist_payment`.`stylitid` = `booking`.`stylitid` INNER JOIN ( select `stylitid`, max(`date`) as `MaxDate` from `stylist_payment` group by `stylitid` ) `tm` on `booking`.`stylitid` = tm.`stylitid` and `booking`.`date` > `tm`.`MaxDate` WHERE `booking`.`status` = 'complete' Group By `stylitid`
______________________
SELECT SUM(`total_amount`) as `amtsum` FROM `booking` LEFT JOIN `user` ON `user`.`id` = `booking`.`stylitid` INNER JOIN ( select `stylitid`, max(`date`) as `MaxDate` from `stylist_payment` group by `stylitid` ) `tm` on `booking`.`stylitid` = tm.`stylitid` and `booking`.`date` > `tm`.`MaxDate` WHERE `booking`.`status` = 'complete' Group By `booking`.`stylitid`

--
SELECT `booking`.`total_amount` as `totalamount`,`stylist_payment`.`si_amount`, MAX(`stylist_payment`.`date`) as `paiddate` FROM `booking`
LEFT JOIN `user` ON `user`.`id` = `booking`.`stylitid`
LEFT JOIN `stylist_payment` ON `stylist_payment`.`stylitid` = `booking`.`stylitid`
INNER JOIN ( select `stylitid`, MAX(`date`) as `MaxDate` from `stylist_payment` group by `stylitid` ) `tm` on `booking`.`stylitid` = tm.`stylitid` and `booking`.`date` > `tm`.`MaxDate`
WHERE `booking`.`status` = 'complete'
Group By `booking`.`stylitid`
____________________________

Change

$data[$parts[0]] = $parts[1];
to

if ( ! isset($parts[1])) {
   $parts[1] = null;
}

$data[$parts[0]] = $parts[1];
or simply:

$data[$parts[0]] = isset($parts[1]) ? $parts[1] : null;
___________________________________________

SELECT `booking`.*, `stylit`.`username` as `stylitname`, `stylit`.`firstname` as `sfirstname`, `stylit`.`lastname` as `slastname`, `user`.`username`, `user`.`firstname` as `firstname`, `user`.`lastname` as `lastname`, `stylit`.`email` as `stylitemail`
FROM `booking`
LEFT JOIN `user` ON `user`.`id` = `booking`.`userid`
LEFT JOIN `user` as `stylit` ON `stylit`.`id` = `booking`.`stylitid`
WHERE `booking`.`stylitid` = '399' AND `booking`.`status` = 'complete'
AND `booking`.`date` > '2018-09-17 07:19:15'
ORDER BY `booking`.`id` DESC


SELECT `booking`.*, `stylit`.`username` as `stylitname`, `stylit`.`firstname` as `sfirstname`, `stylit`.`lastname` as `slastname`, `user`.`username`, `user`.`firstname` as `firstname`, `user`.`lastname` as `lastname`, `stylit`.`email` as `stylitemail` FROM `booking` LEFT JOIN `user` ON `user`.`id` = `booking`.`userid` LEFT JOIN `user` as `stylit` ON `stylit`.`id` = `booking`.`stylitid` WHERE `booking`.`stylitid` = '399' AND `booking`.`status` = 'complete' AND `booking`.`date` > '2018-09-17 07:19:15' ORDER BY `booking`.`id` DESC


SELECT `booking`.`total_amount` as `totalamount`,`stylist_payment`.`si_amount`, max(`stylist_payment`.`date`) as `paiddate` FROM `booking` LEFT JOIN `user` ON `user`.`id` = `booking`.`stylitid` LEFT JOIN `stylist_payment` ON `stylist_payment`.`stylitid` = `booking`.`stylitid` INNER JOIN ( select `stylitid`, max(`date`) as `MaxDate` from `stylist_payment` group by `stylitid` ) `tm` on `booking`.`stylitid` = tm.`stylitid` and `booking`.`date` > `tm`.`MaxDate` WHERE `booking`.`status` = 'complete' Group By `stylist_payment`.`si_amount`
----
SELECT `booking`.`total_amount` as `totalamount`,`stylist_payment`.`si_amount`, max(`stylist_payment`.`date`) as `paiddate` FROM `booking` LEFT JOIN `user` ON `user`.`id` = `booking`.`stylitid` LEFT JOIN `stylist_payment` ON `stylist_payment`.`stylitid` = `booking`.`stylitid` LEFT JOIN ( select `stylitid`, max(`date`) as `MaxDate` from `stylist_payment` group by `stylitid` ) `tm` on `booking`.`stylitid` = tm.`stylitid` and `booking`.`date` > `tm`.`MaxDate` WHERE `booking`.`status` = 'complete' GROUP BY `stylist_payment`.`si_amount` AND `stylist_payment`.`stylitid` ORDER BY `booking`.`id` DESC
----
SELECT SUM(`total_amount`) as `amtsum`
FROM `booking`
LEFT JOIN `user` ON `user`.`id` = `booking`.`stylitid`
LEFT JOIN ( select `stylitid`, max(`date`) as `MaxDate` from `stylist_payment` group by `stylitid` ) `tm`
on `booking`.`stylitid` = tm.`stylitid`
and `booking`.`date` > `tm`.`MaxDate`
WHERE `booking`.`status` = 'complete'
Group By `booking`.`stylitid`
ORDER BY `booking`.`id` DESC
______________________________________________

SELECT `username`, SUM(`si_amount`), `booking`.`stylitid`, `user`.`contact`, `user`.`email`, `user`.`firstname`, `user`.`lastname`, SUM(`booking`.`total_amount`) FROM `booking` LEFT JOIN `user` ON `user`.`id` = `booking`.`stylitid` LEFT JOIN `stylist_payment` ON `stylist_payment`.`stylitid` = `booking`.`stylitid` OR `booking`.`date` > `stylist_payment`.`date` WHERE `booking`.`status` = 'complete' GROUP BY `stylitid` ORDER BY `stylist_payment`.`date` DESC

SELECT booking.stylitid,user.username,user.firstname,user.lastname,user.contact,user.email,SUM(booking.total_amount),stylist_payment.si_amount

FROM booking LEFT JOIN user ON user.id = booking.stylitid

LEFT JOIN stylist_payment ON stylist_payment.stylitid = booking.stylitid

INNER JOIN ( select stylitid, max(date) as MaxDate from booking group by stylitid ) tm on booking.stylitid = tm.stylitid and booking.date = tm.MaxDate

Group By stylitid

------------------
SELECT MAX(`date`) FROM stylist_payment WHERE `stylitid` ='390'

SELECT booking.stylitid,user.username,user.firstname,user.lastname,user.contact,user.email,SUM(`booking`.`total_amount`) as `totalamtsum`,stylist_payment.si_amount,stylist_payment.`date`as paiddate FROM booking LEFT JOIN user ON user.id = booking.stylitid LEFT JOIN stylist_payment ON stylist_payment.stylitid = booking.stylitid INNER JOIN ( select stylitid, max(date) as MaxDate from booking group by stylitid ) tm on booking.stylitid = tm.stylitid and booking.date = tm.MaxDate Group By stylitid

SELECT stylitid,total_amount,user.username,user.firstname,user.lastname,user.contact,user.email,SUM(booking.total_amount) as totalamt FROM `booking` LEFT JOIN `user` ON `user`.`id` = `booking`.`stylitid` WHERE `booking`.`status` = 'complete' GROUP BY `stylitid`