sql 字符串转数组_有这么一个字符串（SQL），要求用最快速的办法转换成数组；...

有这么一个字符串(SQL)，要求用最快速的办法转换成数组；1.SELECTm.*,i.*,c.idascid,c.name,u.*,count(*)FROMmessagem,categoryascJOINimagesioni.id=m.iidleftJOINuseruonu.id=m.u...

有这么一个字符串(SQL)，要求用最快速的办法转换成数组；

1. SELECT m.*, i.*, c.id as cid, c.name, u.*, count(*) FROM message m, category as c JOIN images i on i.id = m.iid left JOIN user u on u.id = m.uid right join person on person.id=u.id where m.id>1000 and u.id=100 GROUP by m.cid order by m.id desc LIMIT 100, 10

2. select * from user where id=10;

3. select * from user order by id desc;

数组的格式为

Array

([field] => m.*, i.*, c.id as cid, c.name, u.*, count(*)

[table] => Array

(

[m] => message

[c] => category

)

[join] => Array

(

[images] => Array

(

[type] =>

[alias] => i

[on] => i.id = m.iid

)

[user] => Array

(

[type] => left

[alias] => u

[on] => u.id = m.uid

)

[person] => Array

(

[type] => right

[alias] =>

[on] => person.id=u.id

)

)

[where] => m.id>1000 and u.id=100

[group] => m.cid

[order] => m.id desc

[limit] => 100, 10

)

要做成一个方法 适合各种这类字符串 例1.2.3

php 程序

展开