Site icon T4Tutorials.com

Search a Record from database in PHP MySQL

Search a Record from database in PHP MySQL

Let’s start the code of “Search a Record from database in PHP MYsql”.

File 1: Index.php

<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="UTF-8" name="viewport" content="width=device-width"/>
		<link rel="stylesheet" type="text/css" href="css/bootstrap.css"/>
	</head>
<body>
	<div class="col-md-3"></div>
	<div class="col-md-6 well" style="width: 95% !important;left: 40px;position: absolute; padding: 40px; padding-bottom: 100px; background-color: lightgrey;">
		<h3 style="color: green" class="text-primary">Search Box - PHP</h3>
		<hr style="border-top:2px dashed #ccc;"/>
		<div class="col-md-1"></div>
		<div class="col-md-10">
			<br />
			<br />
			<form class="form-inline" method="POST" action="index.php">
				<div class="input-group col-md-12">
					<input type="text" class="form-control" placeholder="Search" name="keyword" required="required" style="border: 2px; padding: 20px;" />
					<span class="input-group-btn">
						<button class="btn btn-primary" name="search" style="background-color: green !important;border-color: green; " ><span class="glyphicon glyphicon-search"></span></button>
					</span>
				</div>
			</form>
			<br />
			<br/>
			<br/>
			<center><button type="button" class="btn btn-primary" data-toggle="modal" data-target="#form_modal" style="background-color: green !important;border-color: green; padding-left:20px; padding-right:20px; padding-top: 5px; padding-bottom: 5px;">Insert data</button></center>
			<?php include 'find.php'?>
			<a  style="color: green; text-decoration: none;" href="https://t4tutorials.com/"><h3>Visit T4Tutorials.com</h3></a>
		</div>
	</div>
	
	<div class="modal fade" id="form_modal" tabindex="-1" role="dialog" aria-hidden="true">
		<div class="modal-dialog">
			<form action="insert_content.php" method="POST" enctype="multipart/form-data">
				<div class="modal-content">
					<div class="modal-body">
						<div class="col-md-2"></div>
						<div class="col-md-8">
							<div class="form-group">
								<label>Subject</label>
								<input type="text" class="form-control" name="title" required="required"/>
							</div>
							<div class="form-group">
								<label>Data</label>
								<textarea class="form-control" style="resize:none; height:250px;" name="data" required="required"></textarea>
							</div>
						</div>
					</div>
					<div style="clear:both;"></div>
					<div class="modal-footer">
						<center>
						<button name="save" class="btn btn-primary" style="background-color: green !important; border-color: green; padding-left:20px; padding-right:20px; padding-top: 5px; padding-bottom: 5px;"><span class="glyphicon glyphicon-save"></span> Insert</button>
						<button type="button" class="btn btn-danger" style="background-color: red !important; border-color: red; padding-left:20px; padding-right:20px; padding-top: 5px; padding-bottom: 5px;" data-dismiss="modal"><span class="glyphicon glyphicon-remove"></span> Exit</button>
						</center>
					</div>
				</div>
			</form>
		</div>
	</div>
<script src="js/jquery-3.2.1.min.js"></script>
<script src="js/bootstrap.js"></script>
</body>
</html>

File 2: Find.php

<?php
	if(ISSET($_POST['search'])){
		$keyword = $_POST['keyword'];
?>
<div>
	<h2>Result</h2>
	<hr style="border-top:2px dotted #ccc;"/>
	<?php
		require 'connection.php';
		$query = mysqli_query($conn, "SELECT * FROM `posts` WHERE `subject` LIKE '%$keyword%' ORDER BY `subject`") or die(mysqli_error());
		while($fetch = mysqli_fetch_array($query)){
	?>
	<div style="word-wrap:break-word;">
		<a href="find_post.php?id=<?php echo $fetch['post_id']?>"><h4><?php echo $fetch['subject']?></h4></a>
		<p><?php echo substr($fetch['data'], 0, 100)?>...</p>
	</div>
	<hr style="border-bottom:1px solid #ccc;"/>
	<?php
		}
	?>
</div>
<?php
	}
?>

File 3: Find_post.php

<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="UTF-8" name="viewport" content="width=device-width"/>
		<link rel="stylesheet" type="text/css" href="css/bootstrap.css"/>
	</head>
<body>
	<div class="col-md-3"></div>
	<div class="col-md-6 well">
		<h3 class="text-primary">PHP - Simple Search Box</h3>
		<hr style="border-top:1px dotted #ccc;"/>
		<a href="index.php" class="btn btn-success">Back</a>
		<?php
			require 'connection.php';
			if(ISSET($_REQUEST['id'])){
				$query = mysqli_query($conn, "SELECT * FROM `posts` WHERE `post_id` = '$_REQUEST[id]'") or die(mysqli_error());
				$fetch = mysqli_fetch_array($query);
		?>
				<h3><?php echo $fetch['subject']?></h3>
				<p><?php echo nl2br($fetch['data'])?></p>
		<?php
			}
		?>
		
	</div>
</body>
</html>

Insert_content.php

<?php
	require_once 'connection.php';
	if(ISSET($_POST['save'])){
		$subject = addslashes($_POST['subject']);
		$data = addslashes($_POST['data']);
		mysqli_query($conn, "INSERT INTO `posts` VALUES('', '$subject', '$data')") or die(mysqli_error());
		header('location: index.php');
		
	}
?>

Database for Search a Record from database in PHP MySQL

Download – How to search a record from database in php mysql