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.

@Cerlin Boss ,Yes it worked "convert the response to array and then json_encode it" thank u Cerlin. — sharief, Feb 12 '16 at 06:45
Something like this , if any one wants $a = array((int)$row['register_on'],(int)$row['noofregistraitons']); echo json_encode($a); — sharief, Feb 12 '16 at 06:47

score 0 · Answer 1 · edited May 23 '17 at 12:31

0

edited May 23 '17 at 12:31

Community

answered Feb 12 '16 at 06:19

Hashir Hussain

1

Links can be posted as comments too, they don't need to be answers. – Satej S Feb 12 '16 at 06:22

1 Answers1