Stuff
public text v1 · immutableArray
(
[0] => Array
(
[Course] => Array
(
[id] => 38
)
[Type] => Array
(
)
[User] => Array
(
)
[Schedule] => Array
(
)
[Cat] => Array
(
)
[Provider] => Array
(
)
[Module] => Array
(
[id] => 1
[course_id] => 38
[title] => Descrição
[body] => Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Morbi nisi. Etiam arcu tortor, ornare feugiat, laoreet scelerisque, gravida at, eros. Nulla fringilla accumsan sapien. Vestibulum mollis, sem in imperdiet rhoncus, leo purus facilisis urna, a mattis urna dui sit amet nisl. Integer eros nulla, facilisis ac, dictum et, malesuada cursus, magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos. In dolor. Vestibulum vestibulum feugiat metus. Morbi in nulla ac massa tempor dictum. Proin lacus tellus, pretium blandit, tincidunt sed, tristique et, nisi. Sed nulla. Nunc lorem nisl, ornare sit amet, blandit in, interdum eu, libero. Vestibulum nec arcu in sapien venenatis consectetuer.
[source] =>
[created] => 2007-10-16 10:58:49
[modified] => 2007-10-16 10:58:49
[Course] => Array
(
[id] => 38
[user_id] => 35
[type_id] => 14
[schedule_id] => 6
[cat_id] =>
[provider_id] => 15
[title] => Canto Popular
[points] => 150
[created] => 2007-10-15 10:00:25
[modified] => 2007-10-19 16:37:13
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
[0] => Array
(
[id] => 1
[course_id] => 38
[title] => Descrição
[body] => Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Morbi nisi. Etiam arcu tortor, ornare feugiat, laoreet scelerisque, gravida at, eros. Nulla fringilla accumsan sapien. Vestibulum mollis, sem in imperdiet rhoncus, leo purus facilisis urna, a mattis urna dui sit amet nisl. Integer eros nulla, facilisis ac, dictum et, malesuada cursus, magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos. In dolor. Vestibulum vestibulum feugiat metus. Morbi in nulla ac massa tempor dictum. Proin lacus tellus, pretium blandit, tincidunt sed, tristique et, nisi. Sed nulla. Nunc lorem nisl, ornare sit amet, blandit in, interdum eu, libero. Vestibulum nec arcu in sapien venenatis consectetuer.
[source] =>
[created] => 2007-10-16 10:58:49
[modified] => 2007-10-16 10:58:49
[Course] => Array
(
[id] => 38
[user_id] => 35
[type_id] => 14
[schedule_id] => 6
[cat_id] =>
[provider_id] => 15
[title] => Canto Popular
[points] => 150
[created] => 2007-10-15 10:00:25
[modified] => 2007-10-19 16:37:13
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
)
[1] => Array
(
[id] => 3
[course_id] => 38
[title] => Algo mais
[body] => amizade
[source] =>
[created] => 2007-10-19 16:37:13
[modified] => 2007-10-19 16:37:13
[Course] => Array
(
[id] => 38
[user_id] => 35
[type_id] => 14
[schedule_id] => 6
[cat_id] =>
[provider_id] => 15
[title] => Canto Popular
[points] => 150
[created] => 2007-10-15 10:00:25
[modified] => 2007-10-19 16:37:13
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
)
)
[Comment] => Array
(
)
[Place] => Array
(
[0] => Array
(
[id] => 5
[provider_id] => 15
[street] => Dois de Dezembro
[number] => 78
[neighbourhood] => Catete
[complement] => Sala 214
[city] => Rio de Janeiro
[cep] =>
[email] =>
[ddd] => 21
[tel] => 22253746
[otherinfo] =>
[Provider] => Array
(
[id] => 15
[state_id] => 18
[user_id] => 35
[owner_id] => 0
[ddd] => 21
[tel] => 22052249
[email] => contato@musimundi.com
[url] => www.musimundi.com
[name] => Musimundi
[points] => 200
[created] => 2007-10-15 10:00:44
[modified] => 2007-10-15 14:31:11
)
[Course] => Array
(
[0] => Array
(
[id] => 38
[user_id] => 35
[type_id] => 14
[schedule_id] => 6
[cat_id] =>
[provider_id] => 15
[title] => Canto Popular
[points] => 150
[created] => 2007-10-15 10:00:25
[modified] => 2007-10-19 16:37:13
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
[1] => Array
(
[id] => 39
[user_id] => 35
[type_id] => 14
[schedule_id] => 1
[cat_id] =>
[provider_id] => 15
[title] => Canto Lírico
[points] => 100
[created] => 2007-10-15 10:01:28
[modified] => 2007-10-15 10:01:28
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
[2] => Array
(
[id] => 40
[user_id] => 35
[type_id] => 14
[schedule_id] => 1
[cat_id] =>
[provider_id] => 15
[title] => Coral
[points] => 100
[created] => 2007-10-15 10:02:04
[modified] => 2007-10-15 10:02:04
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
[3] => Array
(
[id] => 42
[user_id] => 35
[type_id] => 14
[schedule_id] => 1
[cat_id] =>
[provider_id] => 15
[title] => Piano
[points] => 150
[created] => 2007-10-15 10:03:43
[modified] => 2007-10-22 14:47:32
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
[4] => Array
(
[id] => 43
[user_id] => 35
[type_id] => 14
[schedule_id] => 1
[cat_id] =>
[provider_id] => 15
[title] => Teclado
[points] => 105
[created] => 2007-10-15 10:04:58
[modified] => 2007-10-15 10:04:58
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
[5] => Array
(
[id] => 44
[user_id] => 35
[type_id] => 14
[schedule_id] => 1
[cat_id] =>
[provider_id] => 15
[title] => Guitarra
[points] => 115
[created] => 2007-10-15 10:05:32
[modified] => 2007-10-15 10:05:32
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
[6] => Array
(
[id] => 45
[user_id] => 35
[type_id] => 14
[schedule_id] => 1
[cat_id] =>
[provider_id] => 15
[title] => Violão
[points] => 125
[created] => 2007-10-15 10:05:57
[modified] => 2007-10-15 10:05:57
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
[7] => Array
(
[id] => 46
[user_id] => 35
[type_id] => 14
[schedule_id] => 1
[cat_id] =>
[provider_id] => 15
[title] => Baixo
[points] => 135
[created] => 2007-10-15 10:06:21
[modified] => 2007-10-15 10:06:21
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
)
)
)
)
[1] => Array
(
[Course] => Array
(
[id] => 41
)
[Type] => Array
(
)
[User] => Array
(
)
[Schedule] => Array
(
)
[Cat] => Array
(
)
[Provider] => Array
(
)
[Module] => Array
(
[id] => 2
[course_id] => 41
[title] => Descrição
[body] => Lorem Ipsum
[source] =>
[created] => 2007-10-19 14:23:06
[modified] => 2007-10-19 15:02:24
[Course] => Array
(
[id] => 41
[user_id] => 35
[type_id] => 14
[schedule_id] => 1
[cat_id] =>
[provider_id] => 15
[title] => Cantoterapia
[points] => 150
[created] => 2007-10-15 10:02:30
[modified] => 2007-10-19 15:02:24
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
[0] => Array
(
[id] => 2
[course_id] => 41
[title] => Descrição
[body] => Lorem Ipsum
[source] =>
[created] => 2007-10-19 14:23:06
[modified] => 2007-10-19 15:02:24
[Course] => Array
(
[id] => 41
[user_id] => 35
[type_id] => 14
[schedule_id] => 1
[cat_id] =>
[provider_id] => 15
[title] => Cantoterapia
[points] => 150
[created] => 2007-10-15 10:02:30
[modified] => 2007-10-19 15:02:24
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
)
)
[Comment] => Array
(
[0] => Array
(
[id] => 1
[user_id] => 35
[course_id] => 41
[created] => 2007-10-17 10:28:41
[body] => comentário 123...
[User] => Array
(
[id] => 35
[name] => Eber Freitas Dias
[email] => eber.freitas@gmail.com
[pass] => $1$125..W1.$0EoJwhOnIws5ZZuJxpNXI/
[state_id] => 18
[verifystring] => GUFNIVZJOVROKUES
[created] => 2007-10-11 00:00:00
[points] => 150
[verified] => 1
)
[Course] => Array
(
[id] => 41
[user_id] => 35
[type_id] => 14
[schedule_id] => 1
[cat_id] =>
[provider_id] => 15
[title] => Cantoterapia
[points] => 150
[created] => 2007-10-15 10:02:30
[modified] => 2007-10-19 15:02:24
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
)
)
[Place] => Array
(
[0] => Array
(
[id] => 6
[provider_id] => 15
[street] =>
[number] =>
[neighbourhood] => Bangu
[complement] =>
[city] => Rio de Janeiro
[cep] =>
[email] =>
[ddd] =>
[tel] =>
[otherinfo] =>
[Provider] => Array
(
[id] => 15
[state_id] => 18
[user_id] => 35
[owner_id] => 0
[ddd] => 21
[tel] => 22052249
[email] => contato@musimundi.com
[url] => www.musimundi.com
[name] => Musimundi
[points] => 200
[created] => 2007-10-15 10:00:44
[modified] => 2007-10-15 14:31:11
)
[Course] => Array
(
[0] => Array
(
[id] => 41
[user_id] => 35
[type_id] => 14
[schedule_id] => 1
[cat_id] =>
[provider_id] => 15
[title] => Cantoterapia
[points] => 150
[created] => 2007-10-15 10:02:30
[modified] => 2007-10-19 15:02:24
[ips] => ips|127.0.0.1
[rank] => 2
[moderated] => 0
[active] => 1
)
)
)
)
)
)
//QUERY
SELECT `Module`.`id`, `Module`.`course_id`, `Module`.`title`, `Module`.`body`, `Module`.`source`, `Module`.`created`, `Module`.`modified`, `Course`.`id`, `Course`.`user_id`, `Course`.`type_id`, `Course`.`schedule_id`, `Course`.`cat_id`, `Course`.`provider_id`, `Course`.`title`, `Course`.`points`, `Course`.`created`, `Course`.`modified`, `Course`.`ips`, `Course`.`rank`, `Course`.`moderated`, `Course`.`active` FROM `modules` AS `Module` LEFT JOIN `courses` AS `Course` ON (`Module`.`course_id` = `Course`.`id`) WHERE ((`Module`.`body` LIKE '%ipsum amizade%') OR (`Module`.`body` LIKE '%ipsum%') OR (`Module`.`body` LIKE '%amizade%'))