By GokiSoft.com| 10:14 30/10/2021|
Học PHP

[Examination] Thi kết thuc môn PHP - Thi Thực Hành - Đề 2


Tags:



Phản hồi từ học viên

5

(Dựa trên đánh giá ngày hôm nay)

Đào Mạnh Dũng [C2010L]
Đào Mạnh Dũng

2021-05-18 14:35:01


#book.php


<?php
	require_once('db/dbhelper.php');
	$BookList = executeResult('select * from book');
?>
<!DOCTYPE html>
<html>
<head>
	<title>Book Page</title>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<meta name="robots" content="all,follow">

	<!-- 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>
	<style type="text/css">
		.container .row {
			min-height: 1000px;
		}
	</style>
</head>
<!-- body -->
<div class="container">
	<form method="get">
    <div class="form-group">
      <label for="usr">Name Book:</label>
      <input type="text" class="form-control" id="usr" name="title">
    </div>
    <button type="submit" class="btn btn-success">Submit</button>
  </form>
	<table class="table table-bordered" style="margin-top: 20px">
				<thead>
					<tr>
						<th>No</th>
						<th>Title</th>
						<th>số lượng</th>
						<th>mã ISBN</th>
						<th>năm xuất bản</th>
					</tr>
				</thead>
				<tbody>
<?php
	foreach ($BookList as $item) {
		$count = 0;
if(!empty($_GET))
		{

			if(strstr($item['title'],$_GET['title']))
		echo '
			<tr>
				<td>'.(++$count).'</td>
				<td>'.$item['title'].'</td>
				<td>'.$item['avaliable'].'</td>
				<td>'.$item['ISBN'].'</td>
				<td>'.$item['pub_year'].'</td>
			</tr>';
		}
		else 
			echo '
			<tr>
				<td>'.(++$count).'</td>
				<td>'.$item['title'].'</td>
				<td>'.$item['avaliable'].'</td>
				<td>'.$item['ISBN'].'</td>
				<td>'.$item['pub_year'].'</td>
			</tr>';
	}
?>
				</tbody>
			</table>
</div>


#config.php


<?php
define('HOST', 'localhost');
define('USERNAME', 'root');
define('PASSWORD', '');
define('DATABASE', 'bt1718');


#dbhelper.php


<?php
require_once('config.php');

/**
* Su dung cho cac lenh: insert, update, delete
*/
function execute($sql) {
	//Mo ket noi toi database
	$conn = mysqli_connect(HOST, USERNAME, PASSWORD, DATABASE);
	mysqli_set_charset($conn, 'utf8');

	//query
	mysqli_query($conn, $sql);

	//Dong ket noi
	mysqli_close($conn);
}

/**
* Su dung cho cac lenh: select
*/
function executeResult($sql, $onlyOne = false) {
	//Mo ket noi toi database
	$conn = mysqli_connect(HOST, USERNAME, PASSWORD, DATABASE);
	mysqli_set_charset($conn, 'utf8');

	//query
	$resultset = mysqli_query($conn, $sql);

	if($onlyOne) {
		$data = mysqli_fetch_array($resultset, 1);
	} else {
		$data = [];
		while(($row = mysqli_fetch_array($resultset, 1)) != null) {
			$data[] = $row;
		}
	}
	//Dong ket noi
	mysqli_close($conn);

	return $data;
}


Đỗ tuấn anh [T1907A]
Đỗ tuấn anh

2020-07-01 08:53:44



<?php 
define('HOST','localhost');
define('DATABASE','quanlysach');
define('USERNAME','root');
define('PASSWORD','');
?>
config.php



db.php
<?php
require_once ('config.php');


function execute($sql) {
	
	$conns = mysqli_connect(HOST, USERNAME, PASSWORD, DATABASE);


	mysqli_query($conns, $sql);


	mysqli_close($conns);
}


function executeResult($sql) {

	$conns = mysqli_connect(HOST, USERNAME, PASSWORD, DATABASE);


	$resultset = mysqli_query($conns, $sql);
	$List      = [];
	while ($row = mysqli_fetch_array($resultset, 1)) {
		$List[] = $row;
	}

	mysqli_close($conns);

	return $List;
}



books.php
<?php
require_once ('db.php');
?>
<!DOCTYPE html>
<html>
<head>
	<title>Student Management</title>

	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css">


	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>


	<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>


	<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">
				<span>Quản Lý Sách</span>
				<form method="GET">
					<input type="text" name="s" class="form-control" style="margin-top: 15px; margin-bottom: 15px;" placeholder="Tìm kiếm theo tên">
				</form>
			</div>
			<div class="panel-body">
				<table class="table table-bordered">
					<thead>
						<tr>
							<th>STT</th>
							<th>Tựa sách</th>
							<th>Tác giả</th>
							<th>Nhà Xuất Bản</th>
							<th>Năm xuất bản </th>
							<th>Số lượng</th>
						</tr>
					</thead>
					<tbody>
                    <?php
if (isset($_GET['s']) && $_GET['s'] != '') {
	$sql = 'select * from structure where title like "%'.$_GET['s'].'%"';
} else {
	$sql = 'select * from structure';
}

$BooksList = executeResult($sql);

$index = 1;
foreach ($BooksList as $bks) {
	echo '<tr>
			<td>'.($index++).'</td>
			<td>'.$bks['title'].'</td>
			<td>'.$bks['author'].'</td>
			<td>'.$bks['ISBN'].'</td>
            <td>'.$bks['year'].'</td>
            <td>'.$bks['available'].'</td>
		</tr>';
}
?>




product.php
<?php
require_once ('db.php');

$title = $author = $ISBN = $year = $available ='';

if (!empty($_GET)) {
	$s_id = '';

	if (isset($_GET['title'])) {
		$title = $_GET['title'];
	}

	if (isset($_GET['author'])) {
		$author = $_GET['author'];
	}

	if (isset($_GET['ISBN'])) {
		$ISBN = $_GET['ISBN'];
    }
    if (isset($_GET['year'])) {
		$year = $_GET['year'];
    }
    if (isset($_GET['available'])) {
		$available = $_GET['available'];
	}

	if (isset($_['id'])) {
		$s_id = $_GET['id'];
	}

	
	if ($title != '' && $year != '') {
	
        $sql = "insert into structure(title, author, ISBN, year,available) value ('$title', '$author', '$ISBN','$year','$available')";
        query($query);
	}



	execute($sql);

	header('Location: books.php');
	die();
}


Trần Ngọc Hải [T1907A]
Trần Ngọc Hải

2020-07-01 08:52:42


Index
<?php
require_once('db_help.php');
?>
<!DOCTYPE html>
<html>
<head>
	<title>QLTV</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>
	<style type="text/css">
		.bg-image {
			/* The image used */
			background-image: url("https://doanhnhanplus.vn/wp-content/uploads/2020/03/dnp-library-13032020.jpg");
		}

		th,td{
			color: #fff;
		}

	</style>


</head>
<body class="bg-image">
	<div class="container" >
		<div class="panel panel-primary">
			<div style="color: white; text-align: center; margin-bottom: 30px; " class="panel-heading">
				<h1 style="margin-bottom: 50px;">Quản lý thông tin sách</h1>
				<form method="get">
					<input type="text" name="search" class="form-control" style="margin-top: 15px; margin-bottom: 15px;" placeholder="Tìm kiếm">
				</form>
			</div>
			<div class="panel-body">
				<table class="table table-bordered">
					<thead>
						<tr>
							<th>STT</th>
							<th>ID Tác Giả</th>
              <th>Tên Sách</th>
              <th>Tác Giả</th>
							<th>Năm Xuất Bản</th>
              <th>Số lượng</th>
						</tr>
					</thead>
					<tbody>
						<?php
						if (isset($_GET['search']) && $_GET['search'] != '') {
							$sql = 'select * from structure where title like "%'.$_GET['search'].'%"';
						} else {
							$sql = 'select * from structure';
						}
            if (isset($_GET['search']) && $_GET['search'] != '') {
							$sql = 'select * from structure where bookid like "%'.$_GET['search'].'%"';
						} else {
							$sql = 'select * from structure';
						}
            if (isset($_GET['search']) && $_GET['search'] != '') {
							$sql = 'select * from structure where ISBN like "%'.$_GET['search'].'%"';
						} else {
							$sql = 'select * from structure';
						}
            if (isset($_GET['search']) && $_GET['search'] != '') {
							$sql = 'select * from structure where pub_year like "%'.$_GET['search'].'%"';
						} else {
							$sql = 'select * from structure';
						}
            if (isset($_GET['search']) && $_GET['search'] != '') {
							$sql = 'select * from structure where availiable like "%'.$_GET['search'].'%"';
						} else {
							$sql = 'select * from structure';
						}

						$structureList = executeResult($sql);

						$index = 1;
						foreach ($structureList as $structure) {
							echo '<tr>
							<td>'.($index++).'</td>
							<td>'.$structure['authorid'].'</td>
							<td>'.$structure['title'].'</td>
							<td>'.$structure['ISBN'].'</td>
							<td>'.$structure['pub_year'].'</td>
              <td>'.$structure['availiable'].'</td>
							</tr>';
						}
						?>
					</tbody>
				</table>
			</div>
		</div>
	</div>

</body>
</html>


db_help.php
<?php
require_once ('config.php');

/**
 * insert, update, delete -> su dung function
 */
function execute($sql) {
	//create connection toi database
	$conn = mysqli_connect(HOST, USERNAME, PASSWORD, DATABASE);

	//query
	mysqli_query($conn, $sql);

	//dong connection
	mysqli_close($conn);
}

/**
 * su dung cho lenh select => tra ve ket qua
 */
function executeResult($sql) {
	//create connection toi database
	$conn = mysqli_connect(HOST, USERNAME, PASSWORD, DATABASE);

	//query
	$resultset = mysqli_query($conn, $sql);
	$list      = [];
	while ($row = mysqli_fetch_array($resultset, 1)) {
		$list[] = $row;
	}

	//dong connection
	mysqli_close($conn);

	return $list;
}


config.php
<?php
define('HOST', 'localhost');
define('DATABASE', 'db_qltv');
define('USERNAME', 'root');
define('PASSWORD', '');


Lê Minh Bắc [T1907A]
Lê Minh Bắc

2020-07-01 08:52:07

database name abcdef



CREATE TABLE structure(
	bookid int(11) not null primary key auto_increment,
    authorid int(11) not null,
    title varchar(55 not null),
    ISBN varchar(25)not null , 
    pub_year smallint(6) not null, 
    available tinyint(4) not null
)


Lê Minh Bắc [T1907A]
Lê Minh Bắc

2020-07-01 08:50:48

database.php

<?php
define('HOST', 'localhost');
define('DATABASE', 'abcdef');
define('USERNAME', 'root');
define('PASSWORD', '');

dbhelper.php



<?php
require_once('database.php');
function execute($sql) {
	$con = mysqli_connect(HOST, USERNAME, PASSWORD, DATABASE);
	mysqli_query($con, $sql);
	mysqli_close($con);
}

function execute_Result($sql) {
	$con = mysqli_connect(HOST, USERNAME, PASSWORD, DATABASE);
	$resultset  = mysqli_query($con, $sql);
	$resultList = [];
	while ($row = mysqli_fetch_array($resultset, 1)) {
		$resultList[] = $row;
	}
	mysqli_close($con);

	return $resultList;
}

home.php



<?php
require_once ('database.php');
require_once ('dbhelper.php');
require_once ('process-form.php');
?>

<!DOCTYPE html>
<html>
<head>
	<title>Trang chủ</title>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
	<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Acumin">
	<link href="https://unpkg.com/aos@2.3.1/dist/aos.css" rel="stylesheet">
	<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
	<script src="https://unpkg.com/aos@2.3.1/dist/aos.js"></script>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
	<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>
	<style>
		/* Make the image fully responsive */
		.carousel-inner img {
			width: 100%;
			height: 500px;
		}
	</style>
	<style type="text/css">
		body {
			font-family: "Acumin", sans-serif;
		}
		a:hover {
			text-decoration-line: none;
			color: white;
		}

		a {color: black;}
		td:hover{
			background-color: red;
			color: white;
		}

	</style>
</head>
<body>
	<nav class="navbar navbar-expand-sm bg-dark navbar-dark">
		<a class="navbar-brand" href="home.php">Trang chủ</a>

		<ul class="navbar-nav">
			<li class="nav-item">
				<a class="nav-link" href="#">Sản phẩm</a>
			</li>
			<li class="nav-item">
				<a class="nav-link" href="#">Liên hệ</a>
			</li>
			<li class="nav-item">
				<a class="nav-link" href="index.php">Trang quản lý</a>
			</li>
		</ul>
	</nav>
	<div class="container-fluid pb-4 mb-4">  
		<div id="myCarousel" class="carousel slide" data-ride="carousel">
			<!-- Indicators -->
			<ol class="carousel-indicators">
				<li data-target="#myCarousel" data-slide-to="0" class="active"></li>
				<li data-target="#myCarousel" data-slide-to="1"></li>
				<li data-target="#myCarousel" data-slide-to="2"></li>
			</ol>

			<!-- Wrapper for slides -->
			<div class="carousel-inner" >
				<div class="carousel-item active">
					<img src="https://bit.ly/2A91Iev">
				</div>

				<div class="carousel-item">
					<img src="https://bit.ly/3eMdRFy" >
				</div>
				
				<div class="carousel-item">
					<img src="https://bit.ly/387ZlFg">
				</div>
			</div>

			<!-- Left and right controls -->
			<a class="carousel-control-prev" href="#myCarousel" data-slide="prev">
				<span class="carousel-control-prev-icon"></span>
			</a>
			<a class="carousel-control-next" href="#myCarousel" data-slide="next">
				<span class="carousel-control-next-icon"></span>
			</a>
		</div>
	</div>
	<div class="container pb-4 mb-4">
		<div class="row">
			<div class="col-md-3" data-aos="fade-right">
				<h1 style="text-align: left;">
					<i class="fa fa-star"></i>
					<i class="fa fa-star"></i>
					<i class="fa fa-star"></i>
					<br>
					<i class="fa fa-star"></i>
					<i class="fa fa-star"></i>
					<br>
					<i class="fa fa-star"></i>

				</h1>
			</div>
			<div class="col-md-6" data-aos="fade-up">
				<h1 style="text-align: center" data-aos="fade-down">!!!!~~<i class="fa fa-cog fa-spin"></i><i class="fa fa-cog fa-spin"></i>~~<i class="pb-4 mb-4 fa fa-mobile-phone" style="font-size: 100px"></i>~~<i class="fa fa-cog fa-spin"></i><i class="fa fa-cog fa-spin"></i>~~!!!!</h1>
			</div>
			<div class="col-md-3" data-aos="fade-left">
				<h1 style="text-align: right;">
					<i class="fa fa-star"></i>
					<i class="fa fa-star"></i>
					<i class="fa fa-star"></i>
					<br>
					<i class="fa fa-star"></i>
					<i class="fa fa-star"></i>
					<br>
					<i class="fa fa-star"></i>
				</h1>
			</div>
		</div>
		<h3 style="text-align: center" data-aos="fade-up">Ở đây chúng tôi có những thứ ngon hơn cả người yêu cũ của bạn</h3>
		<!-- 		<i class="fa fa-cog fa-spin"></i><i class="fa fa-cog fa-spin"></i> -->
		<div class="container">
			<div class="row">
				<div class="col-md-4"></div>
				<div class="col-md-4"></div>
				<div class="col-md-4"></div>
			</div>
		</div>
	</div>

	<footer class="bg-dark" style="width:100%;height: 70px; line-height: 70px; text-align: center; color: white;">
		Copyright &copy; 2020 LeMinhBac.ClassT1907A | Số 8C,Tôn Thất Thuyết - Mỹ Đình - Nam Từ Liêm - Hà Nội
	</footer>


</body>
<script>
	AOS.init();
</script>
</html>

index.php



<?php
require_once ('dbhelper.php');
?>
<!DOCTYPE html>
<html>
<head>
	<title>Liet ke thong tin</title>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
	<link href="https://unpkg.com/aos@2.3.1/dist/aos.css" rel="stylesheet">
	<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
	<script src="https://unpkg.com/aos@2.3.1/dist/aos.js"></script>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
	<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>
	<body>
		<nav class="navbar navbar-expand-sm bg-dark navbar-dark">
			<a class="navbar-brand" href="home.php">Trang chủ</a>

			<ul class="navbar-nav">
				<li class="nav-item">
					<a class="nav-link" href="#">Sản phẩm</a>
				</li>
				<li class="nav-item">
					<a class="nav-link" href="#">Liên hệ</a>
				</li>
				<li class="nav-item">
					<a class="nav-link" href="index.php">Trang quản lý</a>
				</li>
			</ul>
		</nav>
		<div class="container">
			<div class="panel panel-primary">
				<div class="panel-heading">
					Quan ly sach FPT Aptech
					<form method="get">
						<input type="text" name="s" class="form-control" style="margin-top: 15px; margin-bottom: 15px;" placeholder="Tìm kiếm theo tên">
					</form>
				</div>
				<div class="panel-body">
					<table class="table table-bordered">
						<thead>
							<tr>
								<th>STT</th>
								<th>bookID</th>
								<th>AuthorID</th>
								<th>Title</th>
								<th>ISBN</th>
								<th>pub_Year</th>
								<th>Available</th>
							</tr>
						</thead>
						<tbody>
							<?php
							if (isset($_GET['s']) && $_GET['s'] != '') {
								$sql = 'select * from structure where title like "%'.$_GET['s'].'%"';
							} else {
								$sql = 'select * from structure';
							}

							$List = execute_Result($sql);

							$index = 1;
							foreach ($List as $item) {
								echo '<tr>
								<td>'.($index++).'</td>
								<td>'.$item['bookid'].'</td>
								<td>'.$item['authorid'].'</td>
								<td>'.$item['title'].'</td>
								<td>'.$item['ISBN'].'</td>
								<td>'.$item['pub_year'].'</td>
								<td>'.$item['available'].'</td>
								</tr>';
							}
							?>
						</tbody>
					</table>
					<button class="btn btn-success mt-4 mb-4" onclick="window.open('input.php', '_self')">Thêm sach</button>
				</div>
			</div>
		</div>
		<footer class="bg-dark" style="width:100%;height: 70px; line-height: 70px; text-align: center; color: white;">
			Copyright &copy; 2020 LeMinhBac.ClassT1907A | Số 8C,Tôn Thất Thuyết - Mỹ Đình - Nam Từ Liêm - Hà Nội
		</footer>


	</body>
	<script>
		AOS.init();
	</script>
	</html>

input.php



<?php
require_once ('dbhelper.php');
require_once ('process-form.php');
?>

<!DOCTYPE html>
<html>
<head>
  <title>Nhập thông tin sach</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
  <link href="https://unpkg.com/aos@2.3.1/dist/aos.css" rel="stylesheet">
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
  <script src="https://unpkg.com/aos@2.3.1/dist/aos.js"></script>
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>
  <body>
    <nav class="navbar navbar-expand-sm bg-dark navbar-dark">
      <a class="navbar-brand" href="home.php">Trang chủ</a>

      <ul class="navbar-nav">
        <li class="nav-item">
          <a class="nav-link" href="#">Sản phẩm</a>
        </li>
        <li class="nav-item">
          <a class="nav-link" href="#">Liên hệ</a>
        </li>
        <li class="nav-item">
          <a class="nav-link" href="index.php">Trang quản lý</a>
        </li>
      </ul>
    </nav>
    <div class="container">
      <div class="panel panel-primary">
        <div class="panel-heading">
          <h2 class="text-center">Thêm sach</h2>
        </div>
        <div class="panel-body">
          <form method="post">
            <div class="form-group">
              <label for="title">AuthorID</label>
              <input type="number" name="bookid" value="<?=$bookid?>" style="display: none;">
              <input required="true" type="text" class="form-control" id="authorid" name="authorid" value="<?=$authorid?>">
            </div>
            <div class="form-group">
              <label for="title">Title</label>
              <input required="true" type="text" class="form-control" id="title" name="title" value="<?=$title?>">
            </div>
            <div class="form-group">
              <label for="ISBN">ISBN</label>
              <input type="text" class="form-control" id="ISBN" name="ISBN" value="<?=$ISBN?>">
            </div>
            <div class="form-group">
              <label for="pub_year">Pub_Year</label>
              <input type="number" class="form-control" id="pub_year" name="pub_year" value="<?=$pub_year?>">
            </div>
            <div class="form-group">
              <label for="pub_year">Available</label>
              <input type="number" class="form-control" id="available" name="available" value="<?=$available?>">
            </div>
            <button class="btn btn-success">Save</button>
          </form>
        </div>
      </div>
    </div>
    <footer class="bg-dark" style="width:100%;height: 70px; line-height: 70px; text-align: center; color: white;">
      Copyright &copy; 2020 LeMinhBac.ClassT1907A | Số 8C,Tôn Thất Thuyết - Mỹ Đình - Nam Từ Liêm - Hà Nội
    </footer>
  </body>
  </html>

process-form.php



<?php  
if (!empty($_POST)) {
  if (isset($_POST['bookid'])) {
    $bookid = $_POST['bookid'];
  }

  if (isset($_POST['authorid'])) {
    $authorid = $_POST['authorid'];
  }

  if (isset($_POST['title'])) {
    $title = $_POST['title'];
  }

  if (isset($_POST['ISBN'])) {
    $ISBN = $_POST['ISBN'];
  }

  if (isset($_POST['pub_year'])) {
    $pub_year = $_POST['pub_year'];
  }

  if (isset($_POST['available'])) {
    $available = $_POST['available'];
  }

  $authorid  = str_replace('\'', '\\\'', $authorid);
  $title    = str_replace('\'', '\\\'', $title);
  $ISBN  = str_replace('\'', '\\\'', $ISBN);
  $pub_year = str_replace('\'', '\\\'', $pub_year);
  $available = str_replace('\'', '\\\'', $available);


    $sql = "insert into structure(authorid, title, ISBN, pub_year, available) value ('$authorid', '$title', '$ISBN', '$pub_year', '$available')";

  execute($sql);
  header('Location: index.php');
  die();
}


hoangduyminh [T1907A]
hoangduyminh

2020-07-01 08:50:00



CREATE TABLE BOOK(
    bookid int PRIMARY key AUTO_INCREMENT,
    authorid int,
    title varchar(55),
    ISBN varchar(25),
    pub_year SMALLINT(6),
    avalible tinyint(4)
)


nguyễn văn huy [T1907A]
nguyễn văn huy

2020-07-01 08:49:54



CREATE TABLE books(
    bookid    int(11)   PRIMARY key,
    authorid  int(11),
    title     varchar(30),
    ISBN      varchar(20),
    pub_year  int(20),
    avallable int(20)
    )


Nguyễn Văn Quang [T1907A]
Nguyễn Văn Quang

2020-07-01 08:49:25



<?php 
 require_once ('difine.php');
 ?>
<!DOCTYPE html>
<html>
<head>
	<title>Quan Ly San Pham</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">
				Quản lý thư viện
				<form method="get">
					<input type="text" name="s" class="form-control" style="margin-top: 15px; margin-bottom: 15px;" placeholder="Tìm kiếm theo tên">
				</form>
			</div>
			<div class="panel-body">
				<table class="table table-bordered">
					<thead>
						<tr>
							<th>Bookid</th>
							<th>Authorid</th>
							<th>Title</th>
							<th>ISBN</th>
							<th>PUB_YEAR</th>
							<th>Availbale</th>
						</tr>
					</thead>
					<thead>
						<tbody>
				<?php
				if (isset($_GET['s']) && $_GET['s'] != '') {
	                $sql = 'select * from book where title like "%'.$_GET['s'].'%"';
                     } else {
	            $sql = 'select * from book';
                      }

				$bookList = executeResult($sql);
				$index = 1;
				foreach ($bookList as $book) {
				    echo ' <tr>
				 	            <td>'.($index++).'</td>
				 	            <td>'.$book['authorid'].'</td>
				 	            <td>'.$book['title'].'</td>
				 	            <td>'.$book['ISBN'].'</td>
				 	            <td>'.$book['pub_year'].'</td>
				 	            <td>'.$book['available'].'</td>

				 </tr>';
				}
				 ?>			

						</tbody>
					</thead>
				</table>
			</div>
		</div>
	</div>
</body>
</html>




<?php 
define('HOST', 'localhost');
define('DATABASE', 'examination');
define('USERNAME', 'root');
define('PASSWORD', '');
 ?>




<?php 
require_once('config.php');
function execute($sql){
	$con = mysqli_connect(HOST, USERNAME, PASSWORD, DATABASE);

	mysqli_query($con, $sql);

	mysqli_close($con);
}
function executeResult($sql){
	$con = mysqli_connect(HOST, USERNAME, PASSWORD, DATABASE);

	$resultset = mysqli_query($con, $sql);
	$data = [];
	while ($row = mysqli_fetch_array($resultset, 1)) {
		$data[] = $row; 
	}

	mysqli_close($con);
	
    return $data;
}

 ?>






CREATE TABLE BOOK(
    bookid int PRIMARY key AUTO_INCREMENT,
    authorid int,
    title varchar(55),
    ISBN varchar(25),
    pub_year SMALLINT(6),
    avalible tinyint(4)
)


Minh Nghia [T1907A]
Minh Nghia

2020-07-01 08:47:38



<?php
define('HOST', 'localhost');
define('DATABASE', 'examphp');
define('USERNAME', 'root');
define('PASSWORD', '');



CREATE TABLE librady( 
    id int PRIMARY key AUTO_INCREMENT not null, 
    bookid int(11) not null, 
    authorid int(11) not null, 
    title varchar(55) not null, 
    ISBN varchar(25) not null, 
    pub_year SMALLINT(6) not null, 
    available tinyint(4) not null 
    )



<?php
    require_once('config.php');

    function execute($sql){
    	$conn = mysqli_connect(HOST,USERNAME, PASSWORD, DATABASE);
    	//QUERY

    	mysqli_query($conn, $sql);

    	mysqli_close($conn);
    }

    function executeResult($sql){
    	//create connection toi database
    	$conn = mysqli_connect(HOST, USERNAME,PASSWORD,DATABASE);

    	$resultSet = mysqli_query($conn, $sql);
    	$list = [];
    	while($row = mysqli_fetch_array($resultSet, 1)){
    		$list[] = $row;
    	}

    	mysqli_close($conn);
    	return $list ;
    }
?>



 <?php 

require_once('dbhelper.php');

 ?>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta name="description" content="">
  <meta name="author" content="">
  <title>Book Manage</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>
  <style type="text/css">
    img.card-img-top {
    height: 300px;
}
    body{
      margin-top: 100px;
    }
    a.btn.btn-danger {
        margin-left: 15px;
    }
    p.btn.btn-success {
        margin-top: 16px;
    }
    span.btn.btn-primary {
      margin-left: 15px;
  }
  </style>
</head>

<body>

  <!-- Navigation -->
  <nav class="navbar navbar-expand-lg navbar-dark bg-dark fixed-top">
    <div class="container">
      <a class="navbar-brand" href="#">Book</a>
      <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false" aria-label="Toggle navigation">
        <span class="navbar-toggler-icon"></span>
      </button>
      <div class="collapse navbar-collapse" id="navbarResponsive">
        <ul class="navbar-nav ml-auto">
          <li class="nav-item active">
            <a class="nav-link" href="home.php">Home
              <span class="sr-only">(current)</span>
            </a>
          </li>
          <li class="nav-item">
            <a class="nav-link" href="#">About</a>
          </li>
          
          <li class="nav-item">
            <a class="nav-link" href="contact.php">Contact</a>
          </li>
          <li class="nav-item">
            <a class="nav-link" href="login.php">Login</a>
          </li>
        </ul>
      </div>
    </div>
  </nav>

  <!-- Page Content -->
  <div class="container">

    <div class="row">

      <div class="col-lg-3">

        <h1 class="my-4">Category</h1>
        <div class="list-group">
          <a href="#" class="list-group-item">Book</a>
          <a href="#" class="list-group-item">Author</a>
          
        </div>

      </div>
      <!-- /.col-lg-3 -->

      <div class="col-lg-9">

        <div id="carouselExampleIndicators" class="carousel slide my-4" data-ride="carousel">
          <ol class="carousel-indicators">
            <li data-target="#carouselExampleIndicators" data-slide-to="0" class="active"></li>
            <li data-target="#carouselExampleIndicators" data-slide-to="1"></li>
            <li data-target="#carouselExampleIndicators" data-slide-to="2"></li>
          </ol>
          <div class="carousel-inner" role="listbox">
            <div class="carousel-item active">
              <img class="d-block img-fluid" src="https://www.taidanang.com/wp-content/uploads/2018/10/thu-vien-co.jpg" style="width: 100%" alt="First slide">
            </div>
            <div class="carousel-item">
              <img class="d-block img-fluid" src="https://kenh14cdn.com/thumb_w/660/2018/9/26/hoatran-img8128-15379796123021454685583.jpg" style="width: 100%" alt="Second slide">
            </div>
            <div class="carousel-item">
              <img class="d-block img-fluid" src="https://ak.picdn.net/shutterstock/videos/14714218/thumb/1.jpg" style="width: 100%" alt="Third slide">
            </div>
          </div>
          <a class="carousel-control-prev" href="#carouselExampleIndicators" role="button" data-slide="prev">
            <span class="carousel-control-prev-icon" aria-hidden="true"></span>
            <span class="sr-only">Previous</span>
          </a>
          <a class="carousel-control-next" href="#carouselExampleIndicators" role="button" data-slide="next">
            <span class="carousel-control-next-icon" aria-hidden="true"></span>
            <span class="sr-only">Next</span>
          </a>
        </div>

      <form method="get">
          <input type="text" name="search" class="form-control" style="margin-top: 15px; margin-bottom: 15px;" placeholder="Tìm kiếm theo tên sản phẩm">
        </form>
        <div class="row">


    <?php 
      if (isset($_GET['search']) && $_GET['search'] != '') {
              $sql = 'select * from librady where title like "%'.$_GET['search'].'%"';
            } else {
              $sql = 'select * from librady ';
            }


     
      $bookList = executeResult($sql);
      foreach ($bookList as $book) {
        echo '<div class="col-lg-4 col-md-6 mb-4">
            <div class="card h-100" style="text-align:center;>
              <a href="#">Book ID :'.$book['bookid'].'</a>
              <div class="card-body">
                <h4 class="card-title">
                  ID AUthor :<a href="#" name="nameproduct1">'.$book['authorid'].'</a>
                </h4>
                <h5 name = "price1">ISBN :'.$book['ISBN'].'</h5>
                <p class="card-text" name = "title1">Tên sách :'.$book['title'].'</p>
                <h1 class="card-text">Năm sản xuất :'.$book['pub_year'].'</h1>
                <h1 class="card-text">Đã bán :'.$book['available'].'</h1>
              </div>
            </div>
          </div>';
      }
     ?>

        <!-- /.row -->

      </div>
      <!-- /.col-lg-9 -->

    </div>
    <!-- /.row -->

  </div>
  <!-- /.container -->

  <!-- Footer -->
  

  <!-- Bootstrap core JavaScript -->
<!--   <script type="text/javascript">
    function ViewProduct(id) {
      console.log(id)
      $.post('GetIdProduct.php', {
        'id': id
      }, function(data) {
        alert(id)
        window.open('productdetails.php');
      })
    }
  </script> -->
  <script src="vendor/jquery/jquery.min.js"></script>
  <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

</body>

</html>


Trương Công Vinh [T1907A]
Trương Công Vinh

2020-07-01 08:47:27

book.php


<?php
require_once ('getBook.php');

 ?>

<!DOCTYPE html>
<html lang="vi">
	<head>
		<meta charset="utf-8">
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta name="viewport" content="width=device-width, initial-scale=1">
		<title>library</title>
		<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:300,300i,400,400i,500,500i">
		<link rel="stylesheet" href="libs/bootstrap/css/bootstrap.min.css">
		<link rel="stylesheet" href="libs/font-awesome/css/font-awesome.min.css">
		<link rel="stylesheet" href="css/main.css">
		<link rel="stylesheet" href="css/responsive.css">
		
	</head>
	<body>
		<div id="wallpaper">
			<header>
				<div class="top">
					<div class="container">
						<div class="row">
							<div class="col-xs-12 col-sm-12 col-md-6 col-lg-6">
								<p>Chào mừng đến với shop bán hàng!</p>
							</div>
							<div class="col-xs-12 col-sm-12 col-md-6 col-lg-6">
								<div class="top-menu">
									<ul>
										<li><a href="#">Giỏ hàng</a></li>
										<li><a href="#">Cửa hàng</a></li>
										<li><a href="#">Tài khoản</a></li>
										<li><a href="#">Liên hệ</a></li>
									</ul>
								</div>
							</div>
						</div>
					</div>
				</div>
				<div class="main-header">
					<div class="container">
						<div class="row">
							<div class="col-6 col-xs-6 col-sm-6 col-md-3 col-lg-3 order-md-0 order-0">
								<div class="logo">
									<a href="#"><img src="images/logo.png" alt=""></a>
								</div>
							</div>
							<div class="col-12 col-xs-12 col-sm-12 col-md-6 col-lg-6 order-md-1 order-2">
								<div class="form-seach-product">
									<form method="GET" >
										<div class="input-seach">
											<input type="text" name="s" id="" class="form-control">
											<button type="submit" ><i class="fa fa-search"></i></button>
										</div>
										<div class="clear"></div>
									</form>
								</div>
							</div>
							<div class="col-6 col-xs-6 col-sm-6 col-md-3 col-lg-3 order-md-2 order-1" style="text-align: right">
								
							</div>
						</div>
					</div>
				</div>
				<div class="main-menu-header">
					<div class="container">
						<div id="nav-menu">
							<ul>
								<li class="current-menu-item"><a href="#">Trang chủ</a></li>
								<li><a href="#">Giới thiệu</a></li>
								<li>
									<a href="#">Sachs</a>
									<ul>
										<li><a href="#">Đời sóng</a></li>
										<li><a href="#">Sinh học</a></li>
										<li><a href="#">Hóa học</a></li>
										<li><a href="#">khác</a></li>
									</ul>
								</li>
								<li ><a href="#">Admin</a></li>

								<li><a href="#">Tin tức</a></li>
								<li><a href="#">Liên hệ</a></li>
							</ul>
						</div>
					</div>
				</div>
			</header>
			<div id="content">
				<div class="container">
					<div class="slider">
						<div id="carouselExampleControls" class="carousel slide" data-ride="carousel">
						  <div class="carousel-inner">
						    <div class="carousel-item active">
						      <img class="d-block w-100" src="https://bitly.com.vn/RecE6" alt="First slide">
						    </div>
						    <div class="carousel-item">
						      <img class="d-block w-100" src="https://bitly.com.vn/RecE6" alt="Second slide">
						    </div>
						  </div>
						  <a class="carousel-control-prev" href="#carouselExampleControls" role="button" data-slide="prev">
						    <span class="carousel-control-prev-icon" aria-hidden="true"></span>
						    <span class="sr-only">Previous</span>
						  </a>
						  <a class="carousel-control-next" href="#carouselExampleControls" role="button" data-slide="next">
						    <span class="carousel-control-next-icon" aria-hidden="true"></span>
						    <span class="sr-only">Next</span>
						  </a>
						</div>
					</div>
				</div>
				<div class="product-box">
					<div class="container">
						<div class="row">
							<div class="col-xs-12 col-sm-12 col-md-12 col-lg-3 order-lg-0 order-1">
								<div class="sidebar">
									<div class="category-box">
										<h3>Danh mục Sách</h3>
										<div class="content-cat">
											<ul>
												<li><i class="fa fa-angle-right"></i> <a href="#">Anh ngữ</a></li>
												<li><i class="fa fa-angle-right"></i> <a href="#">Văn Hóa</a></li>
												<li><i class="fa fa-angle-right"></i> <a href="#">Đời sống</a></li>
												<li><i class="fa fa-angle-right"></i> <a href="#">Thực vật</a></li>
												<li><i class="fa fa-angle-right"></i> <a href="#">Động vật</a></li>
												<li><i class="fa fa-angle-right"></i> <a href="#">Khoa học công nghệ</a></li>
												<li><i class="fa fa-angle-right"></i> <a href="#">IT</a></li>
												<li><i class="fa fa-angle-right"></i> <a href="#"> khác</a></li>
											</ul>
										</div>
									</div>
									<div class="widget">
										<h3>
											<i class="fa fa-bars"></i>
											Tin tức
										</h3>
										<div class="content-w">
											
										</div>
									</div>
									<div class="widget">
										
										<div class="content-banner">
											<a href="#">
												<img src="" alt="">
											</a>
										</div>
									</div>
									<div class="widget">
										<h3>
											<i class="fa fa-facebook"></i>
											Facebook
										</h3>
										<div class="content-fb">
											<div class="fb-page" data-href="" data-tabs="timeline" data-width="" data-height="200" data-small-header="false" data-adapt-container-width="true" data-hide-cover="false" data-show-facepile="true"></div>
										</div>
									</div>
								</div>
							</div>
							<div class="col-xs-12 col-sm-12 col-md-12 col-lg-9 order-lg-1 order-0">
								<div class="product-section">
									<h2 class="title-product">
										<a href="#" class="title">Sách nổi bật</a>
										<div class="bar-menu"><i class="fa fa-bars"></i></div>
										<div class="list-child">
											<ul>
												<li><a href="#">Học C# căn bản a->z</a></li>
												<li><a href="#">Học C# căn bản a->z</a></li>
												<li><a href="#">Học C# căn bản a->z</a></li>
												<li><a href="#">Học C# căn bản a->z</a></li>
											</ul>
										</div>
										<div class="clear"></div>
									</h2>
									<div class="content-product-box">
										<div class="row">
											<?php
foreach ($bookList as  $book) {
	// code...
	echo '<div class="col-xs-12 col-sm-6 col-md-4 col-lg-3">
		<div class="item-product">
			<div class="thumb">
				<a href="#"><img src="https://bitly.com.vn/RecE6" alt=""></a>
				<span class="sale">Còn<br>'.$book['available'].'</span>
				<div class="action">
					<a href="#" class="like"><i class="fa fa-heart"></i> Yêu thích</a>
					<div class="clear"></div>
				</div>
			</div>
			<div class="info-product">
				<h4><a href="#">'.$book['title'].'</a></h4>
				<div class="price">
					<span class="price-current">bookId :'.$book['bookId'].'</span>
					<span class="price-current">ISBN : '.$book['ISBN'].'</span>
                    <span class="price-current"> publish Year : '.$book['pub_year'].'</span>

				</div>
				
				<button type"button" class="view-more btn btn-primary"  >Xem chi tiết</button>

			</div>
		</div>
	</div>';
}
											 ?>
										</div>
									</div>
								</div>


								</div>
							</div>
						</div>
					</div>
				</div>
			</div>
			<footer>
				<div class="container">
					<div class="row">
						<div class="col-xs-12 col-sm-12 col-md-4 col-lg-4">
							<div class="box-footer info-contact">
								<h3>Thông tin liên hệ</h3>
								<div class="content-contact">
									<p>Website chuyên cung cấp thiết bị điện tử hàng đầu Việt Nam</p>
									<p>
										<strong>Địa chỉ:</strong> blue sky
									</p>
									<p>
										<strong>Email: </strong> Quadeptraicom@gmail.com
									</p>
									<p>
										<strong>Điện thoại: </strong> 03xxxxxx
									</p>

								</div>
							</div>
						</div>
						<div class="col-xs-12 col-sm-12 col-md-4 col-lg-4">
							<div class="box-footer info-contact">
								<h3>Thông tin khác</h3>
								<div class="content-list">
									<ul>
										<li><a href="#"><i class="fa fa-angle-double-right"></i> Chính sách bảo mật</a></li>
										<li><a href="#"><i class="fa fa-angle-double-right"></i> Chính sách đổi trả</a></li>
										<li><a href="#"><i class="fa fa-angle-double-right"></i> Phí vẫn chuyển</a></li>
										<li><a href="#"><i class="fa fa-angle-double-right"></i> Hướng dẫn thanh toán</a></li>
										<li><a href="#"><i class="fa fa-angle-double-right"></i> Chương trình khuyến mãi</a></li>
									</ul>
								</div>
							</div>
						</div>
						<div class="col-xs-12 col-sm-12 col-md-4 col-lg-4">
							<div class="box-footer info-contact">
								<h3>Form liên hệ</h3>
								<div class="content-contact">
									<form action="/" method="GET" role="form">
										<div class="row">
											<div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
												<input type="text" name="name" id="" class="form-control" placeholder="Họ và Tên">
											</div>
											<div class="col-xs-12 col-sm-12 col-md-12 col-lg-6">
												<input type="email" name="email" id="" class="form-control" placeholder="Địa chỉ mail">
											</div>
											<div class="col-xs-12 col-sm-12 col-md-12 col-lg-6">
												<input type="text" name="sdt" id="" class="form-control" placeholder="Số điện thoại">
											</div>
											<div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
												<input type="text" name="ms" id="" class="form-control" placeholder="Tiêu đề">
											</div>
											<div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
												<textarea name="ms-d" id="" cols="30" rows="10" class="form-control"></textarea>
											</div>
										</div>
										<button type="submit" class="btn-contact">Liên hệ ngay</button>
									</form>
								</div>
							</div>
						</div>
					</div>
				</div>
				<div class="copyright">
					<p>Copyright © 2020 HKSHOP All Rights Reserved - Design by THIETKEWEB43.COM</p>
				</div>
			</footer>
		</div>
		<script src="libs/jquery-3.4.1.min.js"></script>
		<script src="libs/bootstrap/js/bootstrap.min.js"></script>
		<script src="js/main.js"></script>
		<div id="fb-root"></div>
		<script async defer crossorigin="anonymous" src="https://connect.facebook.net/vi_VN/sdk.js#xfbml=1&version=v6.0"></script>
	</body>
</html>
database


CREATE TABLE structure(
bookId int PRIMARY KEY AUTO_INCREMENT,
authorId int,
title varchar(55),
ISBN varchar(25),
pub_year SMALLINT(6),
available int
)

config.php
<?php

define('HOST', 'localhost');
define('DATABASE', 'laravellearning');
define('USERNAME', 'root');
define('PASSWORD', '');
 ?>

dbhelper.php
<?php
require_once('config.php');
function execute($sql) {
	$con = mysqli_connect(HOST, USERNAME, PASSWORD, DATABASE);

	mysqli_query($con, $sql);


	mysqli_close($con);

}

function execute_result($sql) {

	$con = mysqli_connect(HOST, USERNAME, PASSWORD, DATABASE);

	$resultset  = mysqli_query($con, $sql);
	$resultList = [];
	while ($row = mysqli_fetch_array($resultset, 1)) {
		$resultList[] = $row;
	}


	mysqli_close($con);

	return $resultList;
}

 ?>

getBook.php
<?php
require_once ('dbhelper.php');

$bookList=[];



if (isset($_GET['s']) && $_GET['s'] != '') {
   $sql = 'select * from structure where title like "%'.$_GET['s'].'%"';
} else {
   $sql = 'select * from structure';
}
$bookList = execute_result($sql);
?>


Đăng nhập để làm bài kiểm tra

Chưa có kết quả nào trước đó