![L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP
4. X? l? k?t qu? tr? v?
? Hi?n th? d? li?u tr? v?
? Hi?n th? d? li?u tr? v?
UserName Password
cursor
C S? d?ng h┐m
C S? d?ng h┐m A AA
$row = mysql_fetch_array($result)
$row = mysql_fetch_array($result) B BB
C CC
C S? l??ng FIELD
C S? D DD
$num = mysql_num_fields($result);
$num = mysql_num_fields($result); ´ ´
X XX
C Truy c?p ??n t?ng FIELD
C Truy c?p ??n t?ng FIELD Y YY
echo $row[＾UserName￣];
echo $row[＾UserName￣]; Z ZZ
Ho?c
Ho?c
echo $row[0];
echo $row[0];
? 2007 Khoa CNTT - ?HKHTN](https://image.slidesharecdn.com/08webcourse-phpketnoicsdl-130411234250-phpapp02/85/08-web-course-php-ket-noi-csdl-12-320.jpg)
![L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP
T?ng h?p c│c b??c thao t│c CSDL MySQL
<?php
// 1. Ket noi CSDL
$connection = mysql_connect(＾hostname",＾username",＾password");
mysql_select_db(＾database_name", $connection);
// 2. Chuan bi cau truy van & 3. Thuc thi cau truy van
$strSQL = "SELECT * FROM TableName￣;
$result = mysql_query($strSQL);
// 4.Xu ly du lieu tra ve
while ($row = mysql_fetch_array($result))
{
for ($i=0; $i<mysql_num_fields($result); $i++)
echo $row[$i] . " ";
}
// 5. Dong ket noi
mysql_close($connection);
?>
? 2007 Khoa CNTT - ?HKHTN](https://image.slidesharecdn.com/08webcourse-phpketnoicsdl-130411234250-phpapp02/85/08-web-course-php-ket-noi-csdl-16-320.jpg)
![Presentatie jeroen tmn boost, 10 2-2011 [alleen-lezen]](https://cdn.slidesharecdn.com/ss_thumbnails/presentatiejeroentmnboost10-2-2011alleen-lezen-110221014526-phpapp02-thumbnail.jpg?width=560&fit=bounds)
More Related Content
Viewers also liked (20)
Similar to 08 web course php ket noi csdl (20)
![S vnet.vn 51. [silde b┐i gi?ng] l?p tr━nh tr┷n m?i tr??ng windows v?i ado.net...](https://cdn.slidesharecdn.com/ss_thumbnails/svnet-vn-51-sildebiginglptrnhtrnmitrngwindowsviado-net-minhtun-130110113838-phpapp01-thumbnail.jpg?width=560&fit=bounds)
More from Tr??ng D?y Ngh? (20)
08 web course php ket noi csdl
- 1. L?p tr━nh v┐ Thi?t k? Web 1 Ba?i 9 Thao t│c CSDL v?i PHP Khoa CNTT C ?H.KHTN ? 2007 Khoa C?ng ngh? th?ng tin
- 2. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP N?i dung ? C│c b??c thao t│c v?i CSDL ? M?t s? v?n ?? khi thao t│c v?i CSDL ? 2007 Khoa CNTT - ?HKHTN
- 3. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP N?i dung ? C│c b??c thao t│c v?i CSDL ? M?t s? v?n ?? khi thao t│c v?i CSDL ? 2007 Khoa CNTT - ?HKHTN
- 4. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP C│c b??c thao t│c CSDL trong PHP 1. K?t n?i v?i CSDL 2. X?y d?ng c?u truy v?n d? li?u 3. Th?c thi c?u truy v?n 4. X? l┴ k?t qu? tr? v? t? c?u truy v?n SELECT 5. Ng?t k?t n?i v?i CSDL ? 2007 Khoa CNTT - ?HKHTN
- 5. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP C│c b??c thao t│c CSDL trong PHP 1. K?t n?i v?i CSDL 2. X?y d?ng c?u truy v?n d? li?u 3. Th?c thi c?u truy v?n 4. X? l┴ k?t qu? tr? v? t? c?u truy v?n SELECT 5. Ng?t k?t n?i v?i CSDL ? 2007 Khoa CNTT - ?HKHTN
- 6. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP 1. T?o K?t n?i CSDL Connection Database PHP Pages ? K?t n?i MySQL v┐ Ch?n CSDL resource mysql_connect(string host, string LoginName, string password) int mysql_select_db(string dbName, resource connection) <?php $connection = mysql_connect(＾localhost",＾root￣,＾root"); mysql_select_db(＾TestDB", $connection); ?> ? 2007 Khoa CNTT - ?HKHTN
- 7. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP C│c b??c thao t│c CSDL trong PHP 1. K?t n?i v?i CSDL 2. X?y d?ng c?u truy v?n d? li?u 3. Th?c thi c?u truy v?n 4. X? l┴ k?t qu? tr? v? t? c?u truy v?n SELECT 5. Ng?t k?t n?i v?i CSDL ? 2007 Khoa CNTT - ?HKHTN
- 8. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP 2. X?y d?ng c?u truy v?n (tt) SQL V┴ d? INSERT strSQL = ＾ INSERT INTO Users (UserName, Password) VALUES (｀admin',｀123')＾ DELETE strSQL = ＾ DELETE FROM Users WHERE UserName = ｀lvminh¨ ＾ UPDATE strSQL = ＾ UPDATE Users SET Password = ｀abc' WHERE UserName = ｀admin¨ ￣ SELECT strSQL = ＾ SELECT * FROM Users WHERE UserName = ｀admin¨ ￣ ? 2007 Khoa CNTT - ?HKHTN
- 9. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP C│c b??c thao t│c CSDL trong PHP 1. K?t n?i v?i CSDL 2. X?y d?ng c?u truy v?n d? li?u 3. Th?c thi c?u truy v?n 4. X? l┴ k?t qu? tr? v? t? c?u truy v?n SELECT 5. Ng?t k?t n?i v?i CSDL ? 2007 Khoa CNTT - ?HKHTN
- 10. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP 3. Th?c thi c?u truy v?n 011010011 Connection 011010011 Database PHP Pages Query resource mysql_query(string SQL_cmd, resource connection) <?php $strSQL = ＾INSERT INTO Users (UserName, Password) VALUES (｀admin',｀123｀)￣; mysql_query($strSQL); ?> Insert Delete Update <?php $strSQL = ＾SELECT * FROM Users￣; $result = mysql_query($strSQL); Select ?> ? 2007 Khoa CNTT - ?HKHTN
- 11. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP C│c b??c thao t│c CSDL trong PHP 1. K?t n?i v?i CSDL 2. X?y d?ng c?u truy v?n d? li?u 3. Th?c thi c?u truy v?n 4. X? l? k?t qu? tr? v? t? c?u truy v?n SELECT 5. Ng?t k?t n?i v?i CSDL ? 2007 Khoa CNTT - ?HKHTN
- 12. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP 4. X? l? k?t qu? tr? v? ? Hi?n th? d? li?u tr? v? ? Hi?n th? d? li?u tr? v? UserName Password cursor C S? d?ng h┐m C S? d?ng h┐m A AA $row = mysql_fetch_array($result) $row = mysql_fetch_array($result) B BB C CC C S? l??ng FIELD C S? D DD $num = mysql_num_fields($result); $num = mysql_num_fields($result); ´ ´ X XX C Truy c?p ??n t?ng FIELD C Truy c?p ??n t?ng FIELD Y YY echo $row[＾UserName￣]; echo $row[＾UserName￣]; Z ZZ Ho?c Ho?c echo $row[0]; echo $row[0]; ? 2007 Khoa CNTT - ?HKHTN
- 13. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP ? 2007 Khoa CNTT - ?HKHTN
- 14. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP C│c b??c thao t│c CSDL trong PHP 1. K?t n?i v?i CSDL 2. X?y d?ng c?u truy v?n d? li?u 3. Th?c thi c?u truy v?n 4. X? l┴ k?t qu? tr? v? t? c?u truy v?n SELECT 5. Ng?t k?t n?i v?i CSDL ? 2007 Khoa CNTT - ?HKHTN
- 15. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP 5. Ng?t k?t n?i d? li?u bool mysql_close(resource connection) ; T? ??ng th?c thi khi k?t th┣c m? l?nh nh? c? ch? t? ??ng thu r│c (garbage collector) C PHP4,5 ? 2007 Khoa CNTT - ?HKHTN
- 16. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP T?ng h?p c│c b??c thao t│c CSDL MySQL <?php // 1. Ket noi CSDL $connection = mysql_connect(＾hostname",＾username",＾password"); mysql_select_db(＾database_name", $connection); // 2. Chuan bi cau truy van & 3. Thuc thi cau truy van $strSQL = "SELECT * FROM TableName￣; $result = mysql_query($strSQL); // 4.Xu ly du lieu tra ve while ($row = mysql_fetch_array($result)) { for ($i=0; $i<mysql_num_fields($result); $i++) echo $row[$i] . " "; } // 5. Dong ket noi mysql_close($connection); ?> ? 2007 Khoa CNTT - ?HKHTN
- 17. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP N?i dung ? C│c b??c thao t│c v?i CSDL ? M?t s? v?n ?? khi thao t│c v?i CSDL ? 2007 Khoa CNTT - ?HKHTN
- 18. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP ? 2007 Khoa CNTT - ?HKHTN
- 19. L?p tr━nh v┐ Thi?t k? Web 1 C B┐i 9: Thao t│c CSDL v?i PHP M?t s? v?n ?? - MySQL & Font Unicode ? Font UNICODE Encode Decode <?php mysql_query(＾set names ｀utf-8¨￣); ?> ? 2007 Khoa CNTT - ?HKHTN