Lecture Web technologies and programming – Lecture 27: Retrieving data, delete, update from database - TRƯỜNG CÁN BỘ QUẢN LÝ GIÁO DỤC THÀNH PHỐ HỒ CHÍ MINH

Bạn đang xem bản rút gọn của tài liệu. Xem và tải ngay bản đầy đủ của tài liệu tại đây (810.27 KB, 20 trang )

(1)<div class='page_container' data-page=1></div>
(2)<div class='page_container' data-page=2></div>
(3)<div class='page_container' data-page=3></div>
(4)<div class='page_container' data-page=4>

• Creating database in MySQL using 
WAMP

• Connecting PHP with MySQL

• Inserting data in database

• CONNECTIONS: user registration

• FILES super global variable

• File uploading in PHP

• Storing reference of uploaded file in

database

• User registration in CONNECTIONS

web application with file upload

</div>
(5)<div class='page_container' data-page=5>

• Retrieving data from MySQL using PHP
• CONNECTIONS: login functionality

• Deleting records in MySQL using PHP

</div>
(6)<div class='page_container' data-page=6>

• Connection with database

• Execute Select SQL command

• Make display structure

• Write data

</div>
(7)<div class='page_container' data-page=7>

<?php

mysql_connect(“localhost”,”root”,””) or 
die(“Error in connection”);

mysql_select_db(“testdatabase”) or

die(“Error in Selection”);

</div>
(8)<div class='page_container' data-page=8>

• The SELECT statement is used to

select data from one or more tables:
• SELECT command in SQL:

SELECT column-name

FROM table-name
SELECT user_Name

FROM users

SELECT *

</div>
(9)<div class='page_container' data-page=9>

• Condition selection:

SELECT column-name

FROM table-name

WHERE condition

</div>
(10)<div class='page_container' data-page=10>

<?php

include(‘connection.php’);

$sql = ‘select * from users’;

$result = mysql_query($sql);

</div>
(11)<div class='page_container' data-page=11>

• Counting rows:

– mysql_num_rows(variable);

<?php

include(‘connection.php’);

$sql = ‘select * from users’;

$result = mysql_query($sql);

</div>
(12)<div class='page_container' data-page=12>

<tr>

<th> User Name</th>
<th> User Email</th>

<th> User Password</th>
<th> User Picture</th>

</div>
(13)<div class='page_container' data-page=13>

• mysql_fetch_array(result-resource);

</div>
(14)<div class='page_container' data-page=14>

$result=

$row = mysql_fetch_array($result);

1 Ali 123 upload/123ali.jpg
2 Umar 123 upload/123umar.jpg

$row= 1 Ali 123 upload/123ali.jpg

user_I
d
user_Nam
e
user_Emai
l
user_Passwo
rd

user_Pictur
e

0 1 2 3 4

echo $row 
[1];

echo

</div>
(15)<div class='page_container' data-page=15>

<tr>

<th> User Name</th>
<th> User Email</th>

<th> User Password</th>
<th> User Picture</th>

</tr>
<tr>

<td> <img src= “<?php echo $row[4]; ?

>”> </td>

User
Name

User Email User

Password

User
Picture
Ali

</div>
(16)<div class='page_container' data-page=16>

16
<table border=‘1’>
Heading Row
<?php
while($rows = 
mysql_fetch_array($result))
{
?>
<tr>

</tr>

<?php } ?>

</table>

Name Password Picture
Ali

m 123

Umar umar@yahoo.
com

</div>
(17)<div class='page_container' data-page=17>

Starts a 
HTML 
page
Connection to 
database

Select 
command

</div>
(18)<div class='page_container' data-page=18>

Headin
g row

</div>
(19)<div class='page_container' data-page=19>

Displays name

Displays email
Displays

password

Displays

</div>
(20)<div class='page_container' data-page=20>

Records in user’s 
table

</div>

Lecture Web technologies and programming – Lecture 27: Retrieving data, delete, update from database - TRƯỜNG CÁN BỘ QUẢN LÝ GIÁO DỤC THÀNH PHỐ HỒ CHÍ MINH

Tài liệu liên quan

Tài liệu bạn tìm kiếm đã sẵn sàng tải về