PHP，Ajax，jQuery的

Question

Im new to Php and want to make ajax call to Php file, Php file contains the sql query like below.

"SELECT count(*) as noOfReg, UNIX_TIMESTAMP(register_on) as register_on FROM `XXXXX'    GROUP BY current_status, date(register_on)"

it will give two values (noOfReg,register_on). i want to send array to ajax success like below , because i want to use it in charts.

[
    [register_on,noOfReg],
    [register_on,noOfReg],
    [register_on,noOfReg],
    [register_on,noOfReg]
]

Note:(register_on)--->typically date.

Answer 1

• jQuery Ajax POST example with PHP

• http://www.sanwebe.com/2012/04/ajax-add-delete-sql-records-jquery-php

• http://labs.jonsuh.com/jquery-ajax-php-json/