PHPRad Classic Initial 2.7.3 Forum Track issues, Ask questions, Make suggestions,Report a bug

You can achieve that by using custom code and adding field color to your table.
For example you table named status with the ff fields:
id
status
color

then you'll have to make a new file on the controllers folder.
let's name it ChartController with the ff code:

Code: [Select]

<?php


class ChartController  extends BaseController{

	function StatusChart(){
		$db = $this->GetModel();
		$arr = array();
		$sqltext = "select count(id) as value, status as label, color from status";
		$queryparams = null;
		$dataset1 = $db->rawQuery($sqltext, $queryparams);
		$arr['labels']=array_map(function($var){ return $var['label']; }, $dataset1);
		$arr['colors']=array_map(function($var){ return $var['color']; }, $dataset1);
                $arr['datasets'][] = array_map(function($var){ return $var['value']; }, $dataset1);
		return $arr;
	}

}

Then you'll have to supply the code above by

Code: [Select]

                           //Custom controller created
                           $cModel= new ChartController();
                           //Get the value of function status chart
                           $chartdata = $cModel->StatusChart();
                           //Supply the return value to the backgroundColor property.
                           backgroundColor:[
                           <?php echo json_encode($chartdata['colors']); ?>,
                            ]

P.S. sorry for my english

This worked for @arun‍

Code: [Select]

$mailer = new Mailer;
$mailer->send_mail("willvin@example.org", "An Example Subject", "The message to be sent.");

@cnmycrl‍ please use the Action Before Add in Page Event to query the record using the id from that select field, and then, use the result to assign to the name and city field, and it will be inserted to your database table.

@sweetman‍ The best solution to avoid any error is to set the database column to varchar. but from the SQL error you posted, it seems the database field is set to DateTime.