{"id":13792,"date":"2021-08-12T07:48:42","date_gmt":"2021-08-12T07:48:42","guid":{"rendered":"https:\/\/freehost.page\/?p=13792"},"modified":"2021-08-12T07:48:42","modified_gmt":"2021-08-12T07:48:42","slug":"cau-lenh-php-sql-ho-ten","status":"publish","type":"post","link":"https:\/\/kiencang.net\/cau-lenh-php-sql-ho-ten\/","title":{"rendered":"C\u00e1c h\u00e0m, c\u00e2u l\u1ec7nh PHP v\u00e0 SQL x\u1eed l\u00fd h\u1ecd t\u00ean s\u1ed1 l\u01b0\u1ee3ng l\u1edbn"},"content":{"rendered":"\n

M\u00f4i tr\u01b0\u1eddng hosting: VPS Vultr High Frequency + Plesk Web Admin SE mi\u1ec5n ph\u00ed. Ri\u00eang v\u1ec1 c\u00e1c \u1ee9ng d\u1ee5ng PHP t\u1ef1 vi\u1ebft, Plesk c\u00f3 v\u1ebb t\u1ed1t h\u01a1n so v\u1edbi control panel c\u00f3 t\u00ean CyberPanel.<\/p>\n\n\n\n

D\u1eef li\u1ec7u l\u00e0 T\u00ean l\u00e0 t\u00ean khai sinh<\/strong>, kh\u00f4ng ph\u1ea3i bi\u1ebft hi\u1ec7u, b\u00fat danh,.v.v.<\/p>\n\n\n\n

Gi\u1ea3 d\u1ee5 t\u00f4i c\u00f3 database t\u00ean ducanh<\/code>, user l\u00e0 nguyen<\/code>, trong \u0111\u00f3 c\u00f3 b\u1ea3ng tennguoi<\/code> c\u1ea7n x\u1eed l\u00fd d\u1eef li\u1ec7u. <\/p>\n\n\n\n

B\u1ea3ng g\u1ed3m c\u00e1c c\u1ed9t hoten<\/code> (VARCHAR 100) cho h\u1ecd t\u00ean; ngay<\/code> (VARCHAR 50) cho ng\u00e0y th\u00e1ng n\u0103m sinh; gioi<\/code> (VARCHAR 50) cho gi\u1edbi t\u00ednh v\u00e0 thutu<\/code> (INT) \u0111\u1ec3 l\u00e0m kh\u00f3a ch\u00ednh, t\u0103ng t\u1ef1 \u0111\u1ed9ng \u0111\u1ec3 l\u00e0 th\u1ee9 t\u1ef1 cho c\u00e1c h\u00e0ng trong b\u1ea3ng. <\/p>\n\n\n\n

B\u1ea3ng m\u00e3 b\u1ea1n n\u00ean \u0111\u1ec3 l\u00e0 utf8mb4_unicode_ci<\/code> thay v\u00ec utf8_general_ci<\/code> ho\u1eb7c utf8mb4 _general_ci<\/code> v\u00ec c\u00e1c l\u1ee3i \u00edch li\u00ean quan \u0111\u1ebfn vi\u1ec7c s\u1eafp x\u1ebfp.<\/p>\n\n\n\n

\u0110\u1ea7u ti\u00ean l\u00e0 file database.php<\/code> \u0111\u1ec3 k\u1ebft n\u1ed1i c\u01a1 s\u1edf d\u1eef li\u1ec7u:<\/p>\n\n\n\n

<?php\n$dsn = 'mysql:host=localhost:3306;dbname=ducanh';\n$db = new PDO($dsn, 'nguyen', '@abc@12345%');\n?><\/code><\/pre>\n\n\n\n

C\u00e2u l\u1ec7nh \u0111\u1ec3 l\u1ea5y th\u00f4ng tin h\u1ecd t\u00ean:<\/p>\n\n\n\n

    $query=\"SELECT * FROM tennguoi\";\n    $result=$db->query($query); \n    foreach ($result as $value) {\n       $hoten = $value['hoten'];\n    \/\/ c\u00e1c h\u00e0m x\u1eed l\u00fd h\u1ecd t\u00ean s\u1ebd \u0111\u01b0\u1ee3c vi\u1ebft \u1edf \u0111\u00e2y\n}<\/code><\/pre>\n\n\n\n

Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea3ng c\u1ee7a ch\u00fang ta c\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0ng (v\u00ed d\u1ee5 100 ng\u00e0n) vi\u1ec7c x\u1eed l\u00fd \u0111\u1ed3ng lo\u1ea1t c\u00f3 th\u1ec3 g\u00e2y qu\u00e1 t\u1ea3i. Khi \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 gi\u1edbi h\u1ea1n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng th\u00eam c\u00e2u l\u1ec7nh \u0111i\u1ec1u ki\u1ec7n Where trong $query, v\u00ed d\u1ee5:<\/p>\n\n\n\n

$query=\"SELECT * FROM tennguoi\" Where thutu < 30000\"<\/code><\/pre>\n\n\n\n

Truy v\u1ea5n tr\u00ean ch\u1ec9 l\u1ea5y c\u00e1c th\u00f4ng tin c\u00f3 thutu d\u01b0\u01a1i 30 ng\u00e0n, thay v\u00ec l\u1ea5y to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 th\u1ec3 l\u00ean \u0111\u1ebfn h\u00e0ng 100 ng\u00e0n h\u00e0ng.<\/p>\n\n\n\n

Chu\u1ea9n h\u00f3a d\u1eef li\u1ec7u<\/h2>\n\n\n\n

D\u1eef li\u1ec7u l\u1edbn th\u01b0\u1eddng \u0111\u01b0\u1ee3c thu th\u1eadp t\u1eeb nhi\u1ec1u ngu\u1ed3n, do \u0111\u00f3 t\u00ecnh tr\u1ea1ng kh\u00f4ng th\u1ed1ng nh\u1ea5t \u0111\u1ecbnh d\u1ea1ng th\u01b0\u1eddng xuy\u00ean x\u1ea3y ra. L\u1ed7i ch\u1ee7 y\u1ebfu l\u00e0 l\u1ed7i nh\u1eadp li\u1ec7u.<\/p>\n\n\n\n

M\u1ee5c \u0111\u00edch c\u1ee7a vi\u1ec7c chu\u1ea9n h\u00f3a d\u1eef li\u1ec7u l\u00e0 \u0111\u1ec3 l\u00e0m cho c\u00e1c t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c ch\u00ednh x\u00e1c h\u01a1n. D\u1eef li\u1ec7u c\u1ea7n \u0111\u01b0a v\u1ec1 c\u00f9ng m\u1ed9t \u0111\u1ecbnh d\u1ea1ng th\u00ec \u0111i\u1ec1u \u0111\u00f3 m\u1edbi kh\u1ea3 thi.<\/p>\n\n\n\n

C\u00e1c h\u1ecd t\u00ean nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y s\u1ebd l\u00e0m c\u00e1c th\u1ed1ng k\u00ea b\u1ecb l\u1ec7ch, v\u00ed d\u1ee5:<\/p>\n\n\n\n