By GokiSoft.com|
14:49 14/12/2020|
Học PHP
[Share Code] Tạo website bán hàng trong 15 phút - Lập trình PHP/MySQL
- Web -> ubuntu
- mysql
- php
=> XAMPP => start (mysql + apache)
- Phân tích database: T2008A
- tạo bảng news
- title
- thumbnail
- created_at
- updated_at
- content
create table news (
id int primary key auto_increment,
title varchar(150) not null,
thumbnail varchar(500),
content longtext,
created_at datetime,
updated_at datetime
)
- Khâu code:
<!DOCTYPE html>
<html>
<head>
<title>News Page</title>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css">
<!-- jQuery library -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<!-- Popper JS -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
<!-- Latest compiled JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<div class="panel panel-primary">
<div class="panel-heading">
<h1 style="text-align: center;">DANH SACH BAI VIET</h1>
</div>
<div class="panel-body">
<?php
// su dung code PHP -> thuc hien lay du lieu tu database va hien thi ra website
//Ket noi toi CSDL (mysql - phpmyadmin)
$con = mysqli_connect('localhost', 'root', '', 'T2008A');
//Thuc hien lay du lieu tu database
$sql = 'select * from news';
$result = mysqli_query($con, $sql);
while ($row = mysqli_fetch_array($result, 1)) {
echo '<div class="row">
<div class="col-md-4">
<img src="'.$row['thumbnail'].'" style="width: 100%">
</div>
<div class="col-md-8">
<p>'.$row['title'].'</p>
<p>'.$row['updated_at'].'</p>
</div>
</div>';
}
//Dong ket noi.
mysqli_close($con);
?>
</div>
</div>
</div>
</body>
</html>Tags:
Phản hồi từ học viên
5
(Dựa trên đánh giá ngày hôm nay)
