1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| <?php
$resultats=$connexion->prepare("
SELECT
h_ev, h_id, h_dt1, h_dt2, h_lieu, h_src, h_srl,h_lat, h_long,
v_nom, v_py,
o_ad, o_tel, o_ml, o_fx, o_sit,
m_nom, m_ad, m_dcrpt, m_aut, m_per,
mu_nom, mu_ad, mu_st, mu_tel,
t_ev, t_ad, t_dcrpt, t_cr, t_pe, t_o, t_oad, t_otl, t_ofx, t_m, t_mad, t_mo, t_mf, t_s, t_p1, t_p2, t_p3,
(MATCH (h_ev) AGAINST ('$chercher') + MATCH (h_lieu) AGAINST ('$chercher')) as score
FROM historique
INNER JOIN ville on historique.h_ins = ville.v_ins
LEFT JOIN office on historique.h_ins = office.o_ins
LEFT JOIN mh on historique.h_lieu = mh.m_nom
LEFT JOIN musee on historique.h_ins = musee.mu_ins
JOIN textes
WHERE
MATCH (h_ev) AGAINST ('$chercher') OR MATCH (h_lieu) AGAINST ('$chercher')
ORDER BY score DESC
LIMIT 0,100
");
$resultats->execute();
?> |
Partager