Cách tạo form tìm kiếm trong php

1. Xây dựng Cơ sở dữ liệu để tìm kiếm

Trước tiên bạn cần tạo một database tên là basic, sau đó sử dụng đoạn code dưới đây để tạo table và thêm một số dòng dữ liệu.

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

/*

SQLyog Ultimate - MySQL GUI v8.21

MySQL - 5.5.20 : Database - basic

*********************************************************************

*/

/*!40101 SET /*0

/*!40101 SET /*3/*4/*5

/*6SET /*8

/*6SET SQLyog Ultimate - MySQL GUI v8.211

/*!40101 SET SQLyog Ultimate - MySQL GUI v8.214SQLyog Ultimate - MySQL GUI v8.215 /*5

SQLyog Ultimate - MySQL GUI v8.217SET SQLyog Ultimate - MySQL GUI v8.219

MySQL - 5.5.20 : 0 MySQL - 5.5.20 : 1 MySQL - 5.5.20 : 2MySQL - 5.5.20 : 3 MySQL - 5.5.20 : 4MySQL - 5.5.20 : 5 MySQL - 5.5.20 : 6 SET MySQL - 5.5.20 : 8MySQL - 5.5.20 : 9 Database0

Database1

/*Database3 Database4Database5 Database6 Database7

Database8 Database9 - basic0

MySQL - 5.5.20 : 0 Database9 - basic3

- basic4- basic5- basic6- basic7MySQL - 5.5.20 : 3 - basic9 *********************************************************************0

- basic4*********************************************************************2*********************************************************************3*********************************************************************4MySQL - 5.5.20 : 9 *********************************************************************6MySQL - 5.5.20 : 5 - basic9*********************************************************************9

- basic4*/1*/2*/3*/4*/5MySQL - 5.5.20 : 9 *********************************************************************6MySQL - 5.5.20 : 5 - basic9*********************************************************************9

- basic4/*!40101 2*********************************************************************3/*!40101 4MySQL - 5.5.20 : 9 *********************************************************************6MySQL - 5.5.20 : 5 - basic9*********************************************************************9

- basic4SET1*********************************************************************3/*!40101 4MySQL - 5.5.20 : 9 *********************************************************************6MySQL - 5.5.20 : 5 - basic9*********************************************************************9

- basic4/*00 /*01 /*02

/*03MySQL - 5.5.20 : 5 /*05MySQL - 5.5.20 : 9/*07

/*08Database5 /*10Database6 Database7

/*13  /*14 /*15*/2/*17/*18 /*19/*20*********************************************************************9/*22*********************************************************************9/*24*********************************************************************9/*26/*27/*28*********************************************************************9/*22*********************************************************************9/*32*********************************************************************9/*26/*35/*36*********************************************************************9/*22*********************************************************************9/*40*********************************************************************9/*42/*43/*44*********************************************************************9/*46*********************************************************************9/*48*********************************************************************9/*50/*51/*52*********************************************************************9/*54*********************************************************************9/*56*********************************************************************9/*58/*59/*60*********************************************************************9/*62*********************************************************************9/*64*********************************************************************9/*66/*67/*68*********************************************************************9/*62*********************************************************************9/*72*********************************************************************9/*74/*75/*76*********************************************************************9/*78*********************************************************************9/*80*********************************************************************9/*82/*83/*84*********************************************************************9/*86*********************************************************************9/*88*********************************************************************9/*90/*91/*92*********************************************************************9/*94*********************************************************************9/*96*********************************************************************9/*98/*99

/*!40101 SET SQLyog Ultimate - MySQL GUI v8.2102

/*6SET SQLyog Ultimate - MySQL GUI v8.2105

/*6SET SQLyog Ultimate - MySQL GUI v8.2108

SQLyog Ultimate - MySQL GUI v8.217SET SQLyog Ultimate - MySQL GUI v8.2111

2. Xây dựng Form tìm kiếm

Bạn tạo file SQLyog Ultimate - MySQL GUI v8.2112 và xây dựng cấu trúc HTML cho form tìm kiếm như sau:

• Gồm một SQLyog Ultimate - MySQL GUI v8.2113 và một nút SQLyog Ultimate - MySQL GUI v8.2114 là đủ cho bài học này rồi, do chúng ta phải truyền đối số vào url nên chúng ta đặt method của form bằng phương thức GET.
• Action của Form tôi trỏ đến file hiện tại luôn nên tất cả code PHP xử lý tìm kiếm tôi sẽ đặt trong file này luôn.

1

2

3

4

5

6

7

8

9

10

11

12

13

SQLyog Ultimate - MySQL GUI v8.2115

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2117

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2119

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2121

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2123

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2125SQLyog Ultimate - MySQL GUI v8.2126SQLyog Ultimate - MySQL GUI v8.2127

SQLyog Ultimate - MySQL GUI v8.2128SQLyog Ultimate - MySQL GUI v8.2129SQLyog Ultimate - MySQL GUI v8.2130 SQLyog Ultimate - MySQL GUI v8.2131SQLyog Ultimate - MySQL GUI v8.2132SQLyog Ultimate - MySQL GUI v8.2127

SQLyog Ultimate - MySQL GUI v8.2134SQLyog Ultimate - MySQL GUI v8.2135SQLyog Ultimate - MySQL GUI v8.2136 SQLyog Ultimate - MySQL GUI v8.2137SQLyog Ultimate - MySQL GUI v8.2138 SQLyog Ultimate - MySQL GUI v8.2139

SQLyog Ultimate - MySQL GUI v8.2134SQLyog Ultimate - MySQL GUI v8.2141SQLyog Ultimate - MySQL GUI v8.2142 SQLyog Ultimate - MySQL GUI v8.2137SQLyog Ultimate - MySQL GUI v8.2144 SQLyog Ultimate - MySQL GUI v8.2145SQLyog Ultimate - MySQL GUI v8.2138 SQLyog Ultimate - MySQL GUI v8.2139

SQLyog Ultimate - MySQL GUI v8.2128SQLyog Ultimate - MySQL GUI v8.2149

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2151

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2153

SQLyog Ultimate - MySQL GUI v8.2154

khâu chuẩn bị xem như hoàn tất, bây giờ đến phần sử dụng php kết nối với mysql để xử và show dữ liệu từ databaes ra ngoài.

3. Check submit form tìm kiếm & kết nối Database

Kiểm tra submir FORM

Trước tiên chúng ta cần kiểm tra người dùng có nhấn vào button tìm kiếm hay không? Bắt buộc chúng ta phải thực hiện bước này tại vì khi submit mới cần xử lý truy vấn database để lấy thông tin tìm kiếm.

Bình thường việc check Submit form ta sẽ dùng SQLyog Ultimate - MySQL GUI v8.2155  vì chúng ta sử dụng phương thức GET nên ta phải sử dụng biến SQLyog Ultimate - MySQL GUI v8.2156 để kiểm tra. Nhưng trong bài này tôi sẽ thay thế SQLyog Ultimate - MySQL GUI v8.2156 bằng một biến môi trường khác chính là SQLyog Ultimate - MySQL GUI v8.2158 có tác dụng là nhận request từ cả 2 phương thức trên.

1

2

3

4

5

6

7

8

SQLyog Ultimate - MySQL GUI v8.2159 SQLyog Ultimate - MySQL GUI v8.2160SQLyog Ultimate - MySQL GUI v8.2158SQLyog Ultimate - MySQL GUI v8.2162SQLyog Ultimate - MySQL GUI v8.2163SQLyog Ultimate - MySQL GUI v8.2164

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2166 SQLyog Ultimate - MySQL GUI v8.2167SQLyog Ultimate - MySQL GUI v8.2168SQLyog Ultimate - MySQL GUI v8.2169SQLyog Ultimate - MySQL GUI v8.2156SQLyog Ultimate - MySQL GUI v8.2162SQLyog Ultimate - MySQL GUI v8.2172SQLyog Ultimate - MySQL GUI v8.2173

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2159 SQLyog Ultimate - MySQL GUI v8.2169SQLyog Ultimate - MySQL GUI v8.2177SQLyog Ultimate - MySQL GUI v8.2169SQLyog Ultimate - MySQL GUI v8.2166SQLyog Ultimate - MySQL GUI v8.2180

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2182 SQLyog Ultimate - MySQL GUI v8.2183SQLyog Ultimate - MySQL GUI v8.2184

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2186SQLyog Ultimate - MySQL GUI v8.2187 SQLyog Ultimate - MySQL GUI v8.2188

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2190

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2192

SQLyog Ultimate - MySQL GUI v8.2192

Kết nối Database

Tiếp theo do chúng ta phải thao tác với database vì thế cần phải thực hiện việc kết nối như sau. 

1

2

3

4

5

6

7

8

SQLyog Ultimate - MySQL GUI v8.2159 SQLyog Ultimate - MySQL GUI v8.2160SQLyog Ultimate - MySQL GUI v8.2158SQLyog Ultimate - MySQL GUI v8.2162SQLyog Ultimate - MySQL GUI v8.2163MySQL - 5.5.20 : 00

SQLyog Ultimate - MySQL GUI v8.2118MySQL - 5.5.20 : 02

SQLyog Ultimate - MySQL GUI v8.2118MySQL - 5.5.20 : 04MySQL - 5.5.20 : 05MySQL - 5.5.20 : 06MySQL - 5.5.20 : 07MySQL - 5.5.20 : 06MySQL - 5.5.20 : 09/*99

SQLyog Ultimate - MySQL GUI v8.2118MySQL - 5.5.20 : 12

SQLyog Ultimate - MySQL GUI v8.2118MySQL - 5.5.20 : 14MySQL - 5.5.20 : 15/*99

SQLyog Ultimate - MySQL GUI v8.2192

Các bạn thay đổi các thông số cho phù hợp với web server của các bạn nhé. Kết nối db xong thì chúng ta có thể gọi câu truy vấn và truy xuất dữ liệu một cách thoải mái.

Tôi sử dụng module mysql cho đơn giản, nếu bạn muốn kết nối bằng mysqli thì tham khảo bài kết nối CSDL với Mysqli.

4. Xử lý tìm kiếm với lệnh Like trong MySql

Trước tiên bạn cần hiểu ý nghĩa về lệnh LIKE trong MySQL, đây là một lệnh dùng để tìm kiếm dữ liệu ở mức độ gần giống, để rõ hơn thì bạn xem bài lệnh LIKE trong MySQL.

Tất cả những đoạn code bên dưới bạn sẽ đặt trong đoạn code kiểm tra submit form mà ở bước 2 ta đã làm. Như vậy ta có fullcode cho phần PHP như sau:

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

SQLyog Ultimate - MySQL GUI v8.2159 SQLyog Ultimate - MySQL GUI v8.2160SQLyog Ultimate - MySQL GUI v8.2158SQLyog Ultimate - MySQL GUI v8.2162SQLyog Ultimate - MySQL GUI v8.2163SQLyog Ultimate - MySQL GUI v8.2164

SQLyog Ultimate - MySQL GUI v8.2116MySQL - 5.5.20 : 25

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2166 SQLyog Ultimate - MySQL GUI v8.2167SQLyog Ultimate - MySQL GUI v8.2168SQLyog Ultimate - MySQL GUI v8.2169SQLyog Ultimate - MySQL GUI v8.2156SQLyog Ultimate - MySQL GUI v8.2162SQLyog Ultimate - MySQL GUI v8.2172SQLyog Ultimate - MySQL GUI v8.2173

SQLyog Ultimate - MySQL GUI v8.2116MySQL - 5.5.20 : 36

SQLyog Ultimate - MySQL GUI v8.2116MySQL - 5.5.20 : 38 SQLyog Ultimate - MySQL GUI v8.2167MySQL - 5.5.20 : 40SQLyog Ultimate - MySQL GUI v8.2184

SQLyog Ultimate - MySQL GUI v8.2116MySQL - 5.5.20 : 02

SQLyog Ultimate - MySQL GUI v8.2116MySQL - 5.5.20 : 04MySQL - 5.5.20 : 05MySQL - 5.5.20 : 06MySQL - 5.5.20 : 07MySQL - 5.5.20 : 06MySQL - 5.5.20 : 09/*99

SQLyog Ultimate - MySQL GUI v8.2116MySQL - 5.5.20 : 12

SQLyog Ultimate - MySQL GUI v8.2116MySQL - 5.5.20 : 14MySQL - 5.5.20 : 15/*99

SQLyog Ultimate - MySQL GUI v8.2116MySQL - 5.5.20 : 59

SQLyog Ultimate - MySQL GUI v8.2116MySQL - 5.5.20 : 61 MySQL - 5.5.20 : 62MySQL - 5.5.20 : 38/*99

SQLyog Ultimate - MySQL GUI v8.2116MySQL - 5.5.20 : 66

SQLyog Ultimate - MySQL GUI v8.2116MySQL - 5.5.20 : 68 MySQL - 5.5.20 : 69MySQL - 5.5.20 : 61/*99

SQLyog Ultimate - MySQL GUI v8.2116MySQL - 5.5.20 : 73

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2159 SQLyog Ultimate - MySQL GUI v8.2169SQLyog Ultimate - MySQL GUI v8.2177SQLyog Ultimate - MySQL GUI v8.2169SQLyog Ultimate - MySQL GUI v8.2166SQLyog Ultimate - MySQL GUI v8.2180

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2182 SQLyog Ultimate - MySQL GUI v8.2183SQLyog Ultimate - MySQL GUI v8.2184

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2186SQLyog Ultimate - MySQL GUI v8.2187 SQLyog Ultimate - MySQL GUI v8.2188

SQLyog Ultimate - MySQL GUI v8.2118MySQL - 5.5.20 : 90

SQLyog Ultimate - MySQL GUI v8.2118MySQL - 5.5.20 : 92

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2159 SQLyog Ultimate - MySQL GUI v8.2169MySQL - 5.5.20 : 68 MySQL - 5.5.20 : 97SQLyog Ultimate - MySQL GUI v8.2166 MySQL - 5.5.20 : 99Database00Database01

SQLyog Ultimate - MySQL GUI v8.2128Database03

SQLyog Ultimate - MySQL GUI v8.2128SQLyog Ultimate - MySQL GUI v8.2182 Database06SQLyog Ultimate - MySQL GUI v8.2184

SQLyog Ultimate - MySQL GUI v8.2128Database09

SQLyog Ultimate - MySQL GUI v8.2128Database11 SQLyog Ultimate - MySQL GUI v8.2169Database13 Database14MySQL - 5.5.20 : 61SQLyog Ultimate - MySQL GUI v8.2180

SQLyog Ultimate - MySQL GUI v8.2134Database18 SQLyog Ultimate - MySQL GUI v8.2167Database13SQLyog Ultimate - MySQL GUI v8.2162Database22Database23

SQLyog Ultimate - MySQL GUI v8.2134Database25 SQLyog Ultimate - MySQL GUI v8.2167Database13SQLyog Ultimate - MySQL GUI v8.2162Database29Database23

SQLyog Ultimate - MySQL GUI v8.2134Database32 SQLyog Ultimate - MySQL GUI v8.2167Database13SQLyog Ultimate - MySQL GUI v8.2162Database36Database23

SQLyog Ultimate - MySQL GUI v8.2134Database39 SQLyog Ultimate - MySQL GUI v8.2167Database13SQLyog Ultimate - MySQL GUI v8.2162Database43Database23

SQLyog Ultimate - MySQL GUI v8.2134Database46 SQLyog Ultimate - MySQL GUI v8.2167Database13SQLyog Ultimate - MySQL GUI v8.2162Database50Database23

SQLyog Ultimate - MySQL GUI v8.2134SQLyog Ultimate - MySQL GUI v8.2182 Database54SQLyog Ultimate - MySQL GUI v8.2184

SQLyog Ultimate - MySQL GUI v8.2128SQLyog Ultimate - MySQL GUI v8.2192

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2186SQLyog Ultimate - MySQL GUI v8.2187 SQLyog Ultimate - MySQL GUI v8.2188

SQLyog Ultimate - MySQL GUI v8.2128SQLyog Ultimate - MySQL GUI v8.2182 Database64SQLyog Ultimate - MySQL GUI v8.2184

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2192

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2192

SQLyog Ultimate - MySQL GUI v8.2192

Trong phần ghi chú mình đã giải thích rồi nên các bạn đọc trong đó nhé, và đây là FULL code cho HTML lẫn PHP:

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

SQLyog Ultimate - MySQL GUI v8.2115

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2117

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2119

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2121

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2123

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2125SQLyog Ultimate - MySQL GUI v8.2126SQLyog Ultimate - MySQL GUI v8.2127

SQLyog Ultimate - MySQL GUI v8.2128SQLyog Ultimate - MySQL GUI v8.2129SQLyog Ultimate - MySQL GUI v8.2130 SQLyog Ultimate - MySQL GUI v8.2131SQLyog Ultimate - MySQL GUI v8.2132SQLyog Ultimate - MySQL GUI v8.2127

SQLyog Ultimate - MySQL GUI v8.2134SQLyog Ultimate - MySQL GUI v8.2135SQLyog Ultimate - MySQL GUI v8.2136 SQLyog Ultimate - MySQL GUI v8.2137SQLyog Ultimate - MySQL GUI v8.2138 SQLyog Ultimate - MySQL GUI v8.2139

SQLyog Ultimate - MySQL GUI v8.2134SQLyog Ultimate - MySQL GUI v8.2141SQLyog Ultimate - MySQL GUI v8.2142 SQLyog Ultimate - MySQL GUI v8.2137SQLyog Ultimate - MySQL GUI v8.2144 SQLyog Ultimate - MySQL GUI v8.2145SQLyog Ultimate - MySQL GUI v8.2138 SQLyog Ultimate - MySQL GUI v8.2139

SQLyog Ultimate - MySQL GUI v8.2128SQLyog Ultimate - MySQL GUI v8.2149

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2151

SQLyog Ultimate - MySQL GUI v8.2118- basic09

SQLyog Ultimate - MySQL GUI v8.2118- basic11

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2159 SQLyog Ultimate - MySQL GUI v8.2160SQLyog Ultimate - MySQL GUI v8.2158SQLyog Ultimate - MySQL GUI v8.2162SQLyog Ultimate - MySQL GUI v8.2163SQLyog Ultimate - MySQL GUI v8.2164

SQLyog Ultimate - MySQL GUI v8.2128MySQL - 5.5.20 : 25

SQLyog Ultimate - MySQL GUI v8.2128SQLyog Ultimate - MySQL GUI v8.2166 SQLyog Ultimate - MySQL GUI v8.2167SQLyog Ultimate - MySQL GUI v8.2168SQLyog Ultimate - MySQL GUI v8.2169SQLyog Ultimate - MySQL GUI v8.2156SQLyog Ultimate - MySQL GUI v8.2162SQLyog Ultimate - MySQL GUI v8.2172SQLyog Ultimate - MySQL GUI v8.2173

SQLyog Ultimate - MySQL GUI v8.2128MySQL - 5.5.20 : 36

SQLyog Ultimate - MySQL GUI v8.2128MySQL - 5.5.20 : 38 SQLyog Ultimate - MySQL GUI v8.2167MySQL - 5.5.20 : 40SQLyog Ultimate - MySQL GUI v8.2184

SQLyog Ultimate - MySQL GUI v8.2128MySQL - 5.5.20 : 02

SQLyog Ultimate - MySQL GUI v8.2128MySQL - 5.5.20 : 04MySQL - 5.5.20 : 05MySQL - 5.5.20 : 06MySQL - 5.5.20 : 07MySQL - 5.5.20 : 06MySQL - 5.5.20 : 09/*99

SQLyog Ultimate - MySQL GUI v8.2128MySQL - 5.5.20 : 12

SQLyog Ultimate - MySQL GUI v8.2128MySQL - 5.5.20 : 14MySQL - 5.5.20 : 15/*99

SQLyog Ultimate - MySQL GUI v8.2128MySQL - 5.5.20 : 59

SQLyog Ultimate - MySQL GUI v8.2128MySQL - 5.5.20 : 61 MySQL - 5.5.20 : 62MySQL - 5.5.20 : 38/*99

SQLyog Ultimate - MySQL GUI v8.2128MySQL - 5.5.20 : 66

SQLyog Ultimate - MySQL GUI v8.2128MySQL - 5.5.20 : 68 MySQL - 5.5.20 : 69MySQL - 5.5.20 : 61/*99

SQLyog Ultimate - MySQL GUI v8.2128MySQL - 5.5.20 : 73

SQLyog Ultimate - MySQL GUI v8.2128SQLyog Ultimate - MySQL GUI v8.2159 SQLyog Ultimate - MySQL GUI v8.2169SQLyog Ultimate - MySQL GUI v8.2177SQLyog Ultimate - MySQL GUI v8.2169SQLyog Ultimate - MySQL GUI v8.2166SQLyog Ultimate - MySQL GUI v8.2180

SQLyog Ultimate - MySQL GUI v8.2134SQLyog Ultimate - MySQL GUI v8.2182 SQLyog Ultimate - MySQL GUI v8.2183SQLyog Ultimate - MySQL GUI v8.2184

SQLyog Ultimate - MySQL GUI v8.2128SQLyog Ultimate - MySQL GUI v8.2186SQLyog Ultimate - MySQL GUI v8.2187 SQLyog Ultimate - MySQL GUI v8.2188

SQLyog Ultimate - MySQL GUI v8.2134MySQL - 5.5.20 : 90

SQLyog Ultimate - MySQL GUI v8.2134MySQL - 5.5.20 : 92

SQLyog Ultimate - MySQL GUI v8.2134SQLyog Ultimate - MySQL GUI v8.2159 SQLyog Ultimate - MySQL GUI v8.2169MySQL - 5.5.20 : 68 MySQL - 5.5.20 : 97SQLyog Ultimate - MySQL GUI v8.2166 MySQL - 5.5.20 : 99Database00Database01

- basic97Database03

- basic97SQLyog Ultimate - MySQL GUI v8.2182 Database06SQLyog Ultimate - MySQL GUI v8.2184

- basic97Database09

- basic97Database11 SQLyog Ultimate - MySQL GUI v8.2169Database13 Database14MySQL - 5.5.20 : 61SQLyog Ultimate - MySQL GUI v8.2180

*********************************************************************12Database18 SQLyog Ultimate - MySQL GUI v8.2167Database13SQLyog Ultimate - MySQL GUI v8.2162Database22Database23

*********************************************************************12Database25 SQLyog Ultimate - MySQL GUI v8.2167Database13SQLyog Ultimate - MySQL GUI v8.2162Database29Database23

*********************************************************************12Database32 SQLyog Ultimate - MySQL GUI v8.2167Database13SQLyog Ultimate - MySQL GUI v8.2162Database36Database23

*********************************************************************12Database39 SQLyog Ultimate - MySQL GUI v8.2167Database13SQLyog Ultimate - MySQL GUI v8.2162Database43Database23

*********************************************************************12Database46 SQLyog Ultimate - MySQL GUI v8.2167Database13SQLyog Ultimate - MySQL GUI v8.2162Database50Database23

*********************************************************************12SQLyog Ultimate - MySQL GUI v8.2182 Database54SQLyog Ultimate - MySQL GUI v8.2184

- basic97SQLyog Ultimate - MySQL GUI v8.2192

SQLyog Ultimate - MySQL GUI v8.2134SQLyog Ultimate - MySQL GUI v8.2186SQLyog Ultimate - MySQL GUI v8.2187 SQLyog Ultimate - MySQL GUI v8.2188

- basic97SQLyog Ultimate - MySQL GUI v8.2182 Database64SQLyog Ultimate - MySQL GUI v8.2184

SQLyog Ultimate - MySQL GUI v8.2134SQLyog Ultimate - MySQL GUI v8.2192

SQLyog Ultimate - MySQL GUI v8.2128SQLyog Ultimate - MySQL GUI v8.2192

SQLyog Ultimate - MySQL GUI v8.2118SQLyog Ultimate - MySQL GUI v8.2192

SQLyog Ultimate - MySQL GUI v8.2118*********************************************************************68

SQLyog Ultimate - MySQL GUI v8.2116SQLyog Ultimate - MySQL GUI v8.2153

SQLyog Ultimate - MySQL GUI v8.2154

Lời kết:

Hy vọng qua bài viết đơn giản này sẽ giúp các bạn có cái nhìn toàn diện hơn về cách xây dựng một chức năng tìm kiếm với lệnh LIKE trong php và MYSQL, từ đó đào sâu và phát triển hơn nửa để có thể đáp ứng được một số yêu cầu tìm kiếm dữ liệu chuyên sâu hơn. Hẹn gặp các bạn ở các bài tiếp theo ^^