What's new

PHP HELP

C

Carl Robles

Forum Veteran
Elite
Joined
Sep 8, 2019
Posts
736
Solutions
12
Reaction
2,041
Points
687
<?php
require('dbconn.php');
?>
<?php
if ($_SESSION['RollNo']== 'admin' ) {
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>LMS</title>
<link type="text/css" href="bootstrap/css/bootstrap.min.css" rel="stylesheet">
<link type="text/css" href="bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet">
<link type="text/css" href="css/theme.css" rel="stylesheet">
<link type="text/css" href="images/icons/css/font-awesome.css" rel="stylesheet">
<link type="text/css" href='You do not have permission to view the full content of this post. Log in or register now.'
rel='stylesheet'>
</head>
<body>
<div class="navbar navbar-fixed-top">
<div class="navbar-inner">
<div class="container">
<a class="btn btn-navbar" data-toggle="collapse" data-target=".navbar-inverse-collapse">
<i class="icon-reorder shaded"></i></a><a class="brand" href="index.php">LMS </a>
<div class="nav-collapse collapse navbar-inverse-collapse">
<ul class="nav pull-right">
<li class="nav-user dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown">
<img src="images/user.png" class="nav-avatar" />
<b class="caret"></b></a>
<ul class="dropdown-menu">
<li><a href="index.php">Your Profile</a></li>
<!--li><a href="#">Edit Profile</a></li>
<li><a href="#">Account Settings</a></li-->
<li class="divider"></li>
<li><a href="logout.php">Logout</a></li>
</ul>
</li>
</ul>
</div>
<!-- /.nav-collapse -->
</div>
</div>
<!-- /navbar-inner -->
</div>
<!-- /navbar -->
<div class="wrapper">
<div class="container">
<div class="row">
<div class="span3">
<div class="sidebar">
<ul class="widget widget-menu unstyled">
<li class="active"><a href="index.php"><i class="menu-icon icon-home"></i>Home
</a></li>
<li class="active"><a href="../qr/index.php"><i class="menu-icon icon-home"></i>Visit Hours
</a></li>
<li><a href="message.php"><i class="menu-icon icon-inbox"></i>Messages</a>
</li>
<li><a href="recieve.php"><i class="menu-icon icon-inbox"></i>Recieve Message</a>
</li>
<li><a href="student.php"><i class="menu-icon icon-user"></i>Manage Students </a>
</li>
<li><a href="book.php"><i class="menu-icon icon-book"></i>All Books </a></li>
<li><a href="addbook.php"><i class="menu-icon icon-edit"></i>Add Books </a></li>
<li><a href="requests.php"><i class="menu-icon icon-tasks"></i>Issue/Return Requests </a></li>
<!-- <li><a href="recommendations.php"><i class="menu-icon icon-list"></i>Book Recommendations </a></li> -->
<li><a href="current.php"><i class="menu-icon icon-list"></i>Currently Issued Books </a></li>
<li><a href="pre.php"><i class="menu-icon icon-list"></i>Previously Borrowed Books </a></li>
<li><a href="history.php"><i class="menu-icon icon-list"></i>Recent Deletion Books </a></li>
</ul>
<ul class="widget widget-menu unstyled">
<li><a href="logout.php"><i class="menu-icon icon-signout"></i>Logout </a></li>
</ul>
</div>
<!--/.sidebar-->
</div>
<div class="span9">
<form class="form-horizontal row-fluid" action="book.php" method="post">
<div class="control-group">
<label class="control-label" for="Search"><b>Search:</b></label>
<div class="controls">
<input type="text" id="Textbook" name="Textbook" placeholder="Enter Book Section , Book Name, or book Status" class="span8" required>
<button type="submit" name="submit"class="btn">Search</button>
</div>
</div>
</form>
<br>
<form class="form-horizontal row-fluid" action="lab.php" method="post">
<div class="control-group">
<label class="control-label" for="Search"><b>Select Section:</b></label>
<div class="controls">
<select name = "Section" tabindex="1" value="SC" data-placeholder="" class="span3" required style="float:left;">
<!-- <option value="<?php echo $status?>"><?php echo $status ?> </option> -->
<option value="" style="text-align: center;"></option>
<option value="General Reference">General Reference</option>
<option value="Reference">Reference</option>
<option value="Filipiniana">Filipiniana</option>
<option class="Periodical">Periodical</option>
<option value="Reserved Books"> Reserved Books</option>
<option value="Graduate Studies">Graduate Studies</option>
<option value="Special Collections">Special Collection</option>
<option value="Rare Book"> Rare Book</option>
<option value="Computer Internet Area">Computer Internet Area</option>
</select>
<label class="control-label" for="Search"><b>Select Status:</b></label>
<div class="controls">
<select name = "Status" tabindex="1" value="SC" data-placeholder="Select Status" class="span2">
<!-- <option value="<?php echo $status?>"><?php echo $status ?> </option> -->
<option value="" style="text-align: center;"></option>
<option value="GOOD">GOOD</option>
<option value="DAMAGE">DAMAGE</option>
<option value="DILAPIDATED">DILAPIDATED</option>

</select>
<button type="submit" name="submit"class="btn">Generate Report</button>

</div>
</div>
</form>
<br>
<?php
if(isset($_POST['submit']))
{$s=$_POST['Textbook'];
$sql="select * from LMS.book where Section like '%$s%' OR Textbook like '%$s%' OR Status like '%$s%'";
// $sql = "select * from LMS.book where BookId = '$s' or Textbook like '%s%' ";
// $name=$row['Textbook'];
// $rs = $conn->query($sql);
}
else
$sql="select * from LMS.book";
$result=$conn->query($sql);
$rowcount = mysqli_num_rows($result);
if(!($rowcount))
echo "<br><center><h2><b><i>No Results</i></b></h2></center>";
else
{

?>
<form action="excel.php" method="post" style="float: left;">
<input type="submit" name="export_excel" class="btn btn-success" value="Export All Books">
</form>

<form action="delallb.php" method="post">


<table class="table" id = "tables">
<thead>
<tr>
<th>Book identification Number</th>
<th>Section</th>
<th>Book name</th>
<th>Availability</th>

<th>Actions</th>

</tr>
</thead>
<tbody>
<?php

//$result=$conn->query($sql);
while($row=$result->fetch_assoc())
{

$bookid=$row['BookId'];

$section = $row['Section'];
$name=$row['Textbook'];
$avail=$row['Availability'];



?>
<tr>
<td><?php echo $bookid ?></td>
<td><?php echo $section ?></td>
<td><?php echo $name ?></td>
<td><b><?php echo $avail ?></b></td>

<td><center>
<a href="bookdetails.php?id=<?php echo $bookid; ?>" class="btn btn-primary">Details</a>
<a href="edit_book_details.php?id=<?php echo $bookid; ?>" class="btn btn-success">Edit</a>


<input type="hidden" name="bookid" value="<?php echo $bookid ?>">
<input type="hidden" name="name" value="<?php echo $bookid ?>">
<input type="hidden" name="item" value="all book">
<input type="hidden" name="deletor" value="admin">
</form>
</center></td>

</tr>
<?php }} ?>
</tbody>
</table>
</div>
<!--/.span9-->
</div>
</div>
<!--/.container-->
</div>
<div class="footer">
<div class="container">
<b class="copyright">&copy; 2024. Carl R. Robles </b>All rights reserved.
</div>
</div>

<!--/.wrapper-->
<script src="scripts/jquery-1.9.1.min.js" type="text/javascript"></script>
<script src="scripts/jquery-ui-1.10.1.custom.min.js" type="text/javascript"></script>
<script src="bootstrap/js/bootstrap.min.js" type="text/javascript"></script>
<script src="scripts/flot/jquery.flot.js" type="text/javascript"></script>
<script src="scripts/flot/jquery.flot.resize.js" type="text/javascript"></script>
<script src="scripts/datatables/jquery.dataTables.js" type="text/javascript"></script>
<script src="scripts/common.js" type="text/javascript"></script>

</body>
</html>

<?php }
else {
echo "<script type='text/javascript'>alert('Access Denied!!!')</script>";
} ?>

paanu po ito dagdagan ng suggestive analysis po yung parang facebook na kapag may inistalk ka lalabas sa recently search nyo po need kopo help
 
To add a suggestive analysis feature to your web application where recent searches are displayed similar to Facebook's "Recently Searched" functionality, you can follow these steps:

1. Database Setup: You need to have a table in your database to store the search history of users. The table can have columns like user_id, search_query, timestamp, etc.

2. Capture Search Queries: Whenever a user performs a search, you need to store the search query in the database along with the user's ID and a timestamp. You can do this by modifying your existing search form submission logic to insert the search query into the database.

3. Display Recent Searches: On your dashboard or search page, you can display the recent searches made by the user. Retrieve and display the search history for the logged-in user from the database. You can show this in a visually appealing way, like a list of recent searches with timestamps.

4. Implement Suggestive Analysis: To improve the user experience, you can implement a suggestive analysis feature. You can use AJAX to fetch suggestions based on the user's partially typed search query. As the user types, show a dropdown list of suggestions based on the search history or popular searches.

5. Update Search History: When a user clicks on a suggestion from the dropdown list, you can update the search history for that user. This will help in refining future suggestions based on the user's behavior.

6. Privacy and Security: Ensure that the search history feature respects user privacy and data security. Users should have the option to delete their search history if needed.

Here are some code snippets to get you started:

### Capture Search Query
PHP: 
// After processing the search form submission
if(isset($_POST['submit'])){
    $searchQuery = $_POST['Textbook'];
    // Store search query in the database
    $userId = $_SESSION['user_id'];
    $timestamp = date('Y-m-d H:i:s');
    $insertQuery = "INSERT INTO search_history (user_id, search_query, timestamp) VALUES ('$userId', '$searchQuery', '$timestamp')";
    // Execute the insert query here
}

### Display Recent Searches
PHP: 
// Retrieve and display recent searches
$userId = $_SESSION['user_id'];
$recentSearchQuery = "SELECT search_query, timestamp FROM search_history WHERE user_id = '$userId' ORDER BY timestamp DESC LIMIT 5";
// Execute the query and display the search history

### Suggestive Analysis (AJAX)
You can use JavaScript/jQuery to implement this feature. Here's a basic example:
JavaScript: 
$('#Textbook').keyup(function(){
    var query = $(this).val();
    $.ajax({
        url: 'suggestive_analysis.php',
        method: 'POST',
        data: {query: query},
        success: function(response){
            // Display suggestions in a dropdown
        }
    });
});

In your suggestive_analysis.php file, you can handle the AJAX request, fetch suggestions based on the partial query, and return the results.

By following these steps and customizing the code snippets according to your application's structure, you can implement a suggestive analysis feature similar to Facebook's "Recently Searched" functionality.
 

Similar threads

Popular Tags

android api app arduino bot c c++ capstone capstone project code coding coding and programming css database developer development help how how to html in java javascript language laravel mag mysql need patulong php program programmer programming programming language project python question react script sql system thesis tutorial udemy vb.net visual basic web web development website with

About this Thread

  • 1
    Replies
  • 52
    Views
  • 2
    Participants
Last reply from:
🤖

New Topics

Popular On This Forum

Online statistics

Members online
1,158
Guests online
4,122
Total visitors
5,280
Back
Top