php查询多表数据类型,php多表关联查询

php+mysql 两个数据库中进行多表查询

select * from databasea.table1 union select * from databaseb.table2 ;

不推荐垮库使用.弊端太多

相关问答

Q1: php 的多表查询 怎么做？？

很简单啊，可以选择JION关键字。

比如　?php

session_start();

include "conn/conn.php";

$s_sqlstr="select * from xs inner jion xs_kc on xs.xh=xs_kc.xh"　order by xh　Desc";

$s_rst = $conn-execute($s_sqlstr);

?

这就实现了两个表的查询，你也可以加别名，这样更方便书写

Q2: php+mysql 一对多表查询

$sql

=

"select

gjd_callback.call_fee,

gjd_callback.call_time

from

gjd_callball,gjd_cs

where

gjd_cs.id=gjd_callback.call_id

and

gjd_cs.id=$id"

还可以：

$sql

=

"select

gjd_callback.call_fee,

gjd_callback.call_time

from

gjd_callball

left

join

gjd_cs

on

gjd_cs.id=gjd_callback.call_id

where

gjd_cs.id=$id"

这两句都可以！

Q3: php多表关联查询

在这句代码

"FROM " . $GLOBALS['ecs']-table('order_goods')." AS og, ".$GLOBALS['ecs']-table('order_info')." AS oi ".

后面加(注意点号的连接):

" LEFT JOIN ". $GLOBALS['ecs']-table('goods') . "AS g ON og.goods_id = g.goods_id ".

然后在开头的sql语句后面这里加上你要的字段:

$sql = 'SELECT og.goods_id, og.goods_sn, og.goods_name,og.goods_attr, og.goods_number AS goods_num, og.goods_price, g.gonghuojia '.

最后你去测试看一下行不行.

Q4: thinkphp 3.2 如何多表查询数组？

$info=M('A')

-field('id,title,cate_id,type_id,type_name,cate_name')

-join('F ON A.type_id = F.type_id')

-join('G ON A.cate_id = G.cate_id')

-select();

BCDE表 以此类推,数组合并