sql job

[alexandre]

Hi, I wonder how to create a job that make request at a Mysql database for exemple in PHP I have

$con = mysqli_connect('localhost','test-user','test123456','test');
if (!$con) {
    die('Could not connect: ' . mysqli_error($con));
}

mysqli_select_db($con,"demo");
$sql="SELECT * FROM tabledetest ";
$result = mysqli_query($con,$sql);

but for the job (in js) what is the best way to do this ?

[Chris Barlow]

I'd recommend following the guide on Using node with SQL.

Return the data to the widget using jobCallback(null, rows) when the query has complete.