busca.php 13.4 KB
Edit Raw Blame History



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


<html><head></head><body><code><font color="#000000">
&lt;code&gt;&lt;span&nbsp;style="color:&nbsp;#000000"&gt;<br>&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;&amp;lt;?php&amp;nbsp;
&lt;br&nbsp;/&gt;$hostname_connTutoiMasters&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;=&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;"localhost"&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;;
&lt;br&nbsp;/&gt;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$database_connTutoiMasters&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;=&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;"tutoriais_imasters"&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;;
&lt;br&nbsp;/&gt;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$username_connTutoiMasters&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;=&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;"root"&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;;
&lt;br&nbsp;/&gt;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$password_connTutoiMasters&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;=&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;""&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;;
&lt;br&nbsp;/&gt;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$connTutoiMasters&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;=&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;mysql_pconnect&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$hostname_connTutoiMasters&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;,&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$username_connTutoiMasters&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;,&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$password_connTutoiMasters&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;)&amp;nbsp;or&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;trigger_error&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;mysql_error&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;(),&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;E_USER_ERROR&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;);&amp;nbsp;
&lt;br&nbsp;/&gt;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;?&amp;gt;
&lt;br&nbsp;/&gt;&amp;lt;?php
&lt;br&nbsp;/&gt;$colname_rsBusca&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;=&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;"-1"&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;;
&lt;br&nbsp;/&gt;if&amp;nbsp;(isset(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$_GET&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;[&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;'q'&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;]))&amp;nbsp;{
&lt;br&nbsp;/&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$colname_rsBusca&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;=&amp;nbsp;(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;get_magic_quotes_gpc&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;())&amp;nbsp;?&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$_GET&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;[&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;'q'&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;]&amp;nbsp;:&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;addslashes&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$_GET&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;[&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;'q'&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;]);
&lt;br&nbsp;/&gt;}
&lt;br&nbsp;/&gt;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;mysql_select_db&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$database_connTutoiMasters&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;,&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$connTutoiMasters&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;);
&lt;br&nbsp;/&gt;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$query_rsBusca&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;=&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;sprintf&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;"SELECT&amp;nbsp;*&amp;nbsp;FROM&amp;nbsp;busca_instantanea&amp;nbsp;WHERE&amp;nbsp;tuto_titulo&amp;nbsp;LIKE&amp;nbsp;'%%%s%%'&amp;nbsp;OR&amp;nbsp;tuto_desc&amp;nbsp;LIKE&amp;nbsp;'%%%s%%'&amp;nbsp;LIMIT&amp;nbsp;5"&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;,&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$colname_rsBusca&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;,&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$colname_rsBusca&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;);
&lt;br&nbsp;/&gt;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$rsBusca&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;=&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;mysql_query&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$query_rsBusca&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;,&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$connTutoiMasters&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;)&amp;nbsp;or&amp;nbsp;die(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;mysql_error&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;());
&lt;br&nbsp;/&gt;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$row_rsBusca&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;=&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;mysql_fetch_assoc&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$rsBusca&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;);
&lt;br&nbsp;/&gt;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$totalRows_rsBusca&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;=&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;mysql_num_rows&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$rsBusca&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;);
&lt;br&nbsp;/&gt;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;?&amp;gt;
&lt;br&nbsp;/&gt;&lt;/span&gt;&amp;lt;!DOCTYPE&amp;nbsp;html&amp;nbsp;PUBLIC&amp;nbsp;"-//W3C//DTD&amp;nbsp;XHTML&amp;nbsp;1.0&amp;nbsp;Transitional//EN"&amp;nbsp;"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&amp;gt;
&lt;br&nbsp;/&gt;&amp;lt;html&amp;nbsp;xmlns="http://www.w3.org/1999/xhtml"&amp;gt;
&lt;br&nbsp;/&gt;&amp;lt;head&amp;gt;
&lt;br&nbsp;/&gt;&amp;lt;meta&amp;nbsp;http-equiv="Content-Type"&amp;nbsp;content="text/html;&amp;nbsp;charset=iso-8859-1"&amp;nbsp;/&amp;gt;
&lt;br&nbsp;/&gt;&amp;lt;title&amp;gt;Busca&amp;lt;/title&amp;gt;
&lt;br&nbsp;/&gt;&amp;lt;/head&amp;gt;
&lt;br&nbsp;/&gt;
&lt;br&nbsp;/&gt;&amp;lt;body&amp;gt;
&lt;br&nbsp;/&gt;&amp;lt;p&amp;gt;Total&amp;nbsp;de&amp;nbsp;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;&amp;lt;?php&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;echo&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$totalRows_rsBusca&amp;nbsp;?&amp;gt;&lt;/span&gt;&amp;nbsp;resultado(s)&amp;nbsp;para&amp;nbsp;o&amp;nbsp;termo&amp;nbsp;&amp;lt;strong&amp;gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;&amp;lt;?=&amp;nbsp;$_GET&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;[&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;'q'&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;];&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;?&amp;gt;&lt;/span&gt;&amp;lt;/strong&amp;gt;&amp;lt;/p&amp;gt;
&lt;br&nbsp;/&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;&amp;lt;?php&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;do&amp;nbsp;{&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;?&amp;gt;
&lt;br&nbsp;/&gt;&lt;/span&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;h1&amp;gt;&amp;lt;a&amp;nbsp;href="&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;&amp;lt;?php&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;echo&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$row_rsBusca&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;[&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;'tuto_url'&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;];&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;?&amp;gt;&lt;/span&gt;"&amp;gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;&amp;lt;?php&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;echo&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$row_rsBusca&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;[&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;'tuto_titulo'&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;];&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;?&amp;gt;&lt;/span&gt;&amp;lt;/a&amp;gt;&amp;lt;small&amp;gt;Por:&amp;nbsp;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;&amp;lt;?php&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;echo&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$row_rsBusca&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;[&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;'tuto_colunista'&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;];&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;?&amp;gt;&lt;/span&gt;&amp;lt;/small&amp;gt;&amp;lt;/h1&amp;gt;
&lt;br&nbsp;/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;p&amp;gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;&amp;lt;?php&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;echo&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$row_rsBusca&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;[&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;'tuto_desc'&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;];&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;?&amp;gt;&lt;/span&gt;&amp;lt;/p&amp;gt;
&lt;br&nbsp;/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;p&amp;gt;&amp;lt;a&amp;nbsp;href="&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;&amp;lt;?php&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;echo&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$row_rsBusca&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;[&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;'tuto_url'&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;];&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;?&amp;gt;&lt;/span&gt;"&amp;gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;&amp;lt;?php&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;echo&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$row_rsBusca&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;[&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#DD0000"&gt;'tuto_url'&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;];&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;?&amp;gt;&lt;/span&gt;&amp;lt;/a&amp;gt;&amp;lt;/p&amp;gt;
&lt;br&nbsp;/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;hr&amp;nbsp;/&amp;gt;
&lt;br&nbsp;/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;&amp;lt;?php&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;}&amp;nbsp;while&amp;nbsp;(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$row_rsBusca&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;=&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;mysql_fetch_assoc&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$rsBusca&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;));&amp;nbsp;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;?&amp;gt;
&lt;br&nbsp;/&gt;&lt;/span&gt;&amp;lt;/body&amp;gt;
&lt;br&nbsp;/&gt;&amp;lt;/html&amp;gt;
&lt;br&nbsp;/&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;&amp;lt;?php
&lt;br&nbsp;/&gt;mysql_free_result&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;(&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;$rsBusca&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#007700"&gt;);
&lt;br&nbsp;/&gt;&lt;/span&gt;&lt;span&nbsp;style="color:&nbsp;#0000BB"&gt;?&amp;gt;&lt;/span&gt;<br>&lt;/span&gt;<br>&lt;/code&gt;</font>
</code></body></html>