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
SQLyog Ultimate - MySQL GUI v8.2194 chính là tên của button tìm kiếm. Như vậy để kiểm tra người dùng click hay chưa thì ta chỉ cần kiểm tra tên của button đó có tồn tại hay không.
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 ^^