|
В PHP не работает запрос, работающий в phpMyAdmin
#38463210
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
|
|
|
|
miksoftOfigenski,
В кавычках ничего не напутали? А то, может, вы часть PHP-кода в запрос отправили?
Ofigenskiсли вывести его через die()Выводите что именно?
Нужно сначала собрать запрос в отдельную переменную, а затем отправлять его и на вывод, и в MySQL. Но не пытаться выводить такое же выражение, которое собирает запрос.
Вот!! : Получите распишитесь дорогие друзья )))
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
$query = <<<SQL
SELECT
cw.`s_number0`, cw.`s_number`,
cw.`s_regDate0`, cw.`s_regDate`,
cw.`s_termDate0`, cw.`s_termDate`,
st1.typeName AS type0, st2.typeName AS `type`,
ob1.objectName AS source0, ob2.objectName AS `source`,
ob3.objectName AS term0, ob4.objectName AS `term`,
wo1.workerName AS cont0, wo2.workerName AS `cont`,
cw.`s_comment0`, cw.`s_comment`,
lo1.locName AS loc0, lo2.locName AS `loc`,
cw.`s_isDeleted0`, cw.`s_isDeleted`,
ob5.objectName AS project0, ob6.objectName AS `project`,
ob7.objectName AS carrier0, ob8.objectName AS `carrier`,
wo3.workerName AS operator0, wo4.workerName AS `operator`,
fa1.fName AS fault0, fa2.fName AS `fault`,
cw.`o_carcom0`, cw.`o_carcom`,
cw.`c_goodsId0`, cw.`c_goodsId`,
cw.`c_amount0`, cw.`c_amount`,
cw.`c_curr0`, cw.`c_curr`,
cw.`c_summ0`, cw.`c_summ`,
cw.`dTime`,
cw.`setId`,
cw.`c_sign`,
us1.usName
FROM
`change_writing` AS cw
LEFT OUTER JOIN
setTypes AS st1 ON cw.`s_typeId0` = st1.typeId
LEFT OUTER JOIN
setTypes AS st2 ON cw.`s_typeId` = st2.typeId
LEFT OUTER JOIN
objects AS ob1 ON cw.`s_source0` = ob1.objectId
LEFT OUTER JOIN
objects AS ob2 ON cw.`s_source` = ob2.objectId
LEFT OUTER JOIN
objects AS ob3 ON cw.`s_term0` = ob3.objectId
LEFT OUTER JOIN
objects AS ob4 ON cw.`s_term` = ob4.objectId
LEFT OUTER JOIN
workers AS wo1 ON cw.`s_contId0` = wo1.workerId
LEFT OUTER JOIN
workers AS wo2 ON cw.`s_contId` = wo2.workerId
LEFT OUTER JOIN
locations AS lo1 ON cw.`s_locId0` = lo1.locId
LEFT OUTER JOIN
locations AS lo2 ON cw.`s_locId` = lo2.locId
LEFT OUTER JOIN
objects AS ob5 ON cw.`o_projectId0` = ob5.objectId
LEFT OUTER JOIN
objects AS ob6 ON cw.`o_projectId` = ob6.objectId
LEFT OUTER JOIN
objects AS ob7 ON cw.`o_carrier0` = ob7.objectId
LEFT OUTER JOIN
objects AS ob8 ON cw.`o_carrier` = ob8.objectId
LEFT OUTER JOIN
workers AS wo3 ON cw.`o_operator0` = wo3.workerId
LEFT OUTER JOIN
workers AS wo4 ON cw.`o_operator` = wo4.workerId
LEFT OUTER JOIN
faults AS fa1 ON cw.`o_fault0` = fa1.fId
LEFT OUTER JOIN
faults AS fa2 ON cw.`o_fault` = fa2.fId
LEFT OUTER JOIN
users AS us1 ON cw.`user` = us1.usId
WHERE
cw.`setId` = 777
SQL;
//die($query);
$stmt = $this->db->prepare( $query );
$dbres = $stmt->execute();
Сорри, табуляция чуть поехала после копипоста!
Какие мысли?? |
|
|
