Library_Management_System/blogsearch.php at main · shohancs/Library_Management_System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
<?php include "inc/head.php"; ?>


	<?php
		if (isset($_GET['blog'])) {
			$searchBlog = $_GET['blog'];
			$sql = "SELECT * FROM blogs WHERE blog_id='$searchBlog'";
			$blogSql = mysqli_query($db, $sql);

			while( $row = mysqli_fetch_assoc($blogSql) ) {
	          $blog_id        = $row['blog_id'];
	          $image        = $row['image'];
	          $blog_title     = $row['blog_title'];
	          $blog_text      = $row['blog_text'];
	          $status       = $row['status'];
	          $join_date      = $row['join_date'];
	          ?>

	          <section class="blog-details">
		        <div class="container d-flex justify-content-between align-items-center">
		          <div>
		            <h2 class="text-light" style=" font-family: 'Righteous', cursive;
		          font-size: 40px;">Blog Details</h2>
		          </div>
		          <div>
		            <img src="assets/images/shape-dots.svg" alt="" class="img-fluid" style="opacity: .5; width: 50%;">
		          </div>
		        </div>
		      </section>

				<section class="blog_details_search pt-5">
					<div class="container">
						<div class="row">
							<div class="col-lg-12">
								<div class="row">
									<!-- Card Part Start -->
			                        <div class="col-lg-9 blog-item pb-4">
			                            <div class="book-thumbnail">
			                              <?php
			                                  if (!empty($image)) { ?>
			                                    <img src="admin/dist/img/books/<?php echo $image; ?>" alt="" style="width: 100%; border-radius: 10px;">
			                                  <?php }
			                                  else { ?>
			                                    <img src="admin/dist/img/books/blank_book.jpg" alt="" style="width: 100%; height: 300px;">
			                                  <?php }
			                                ?>

			                                <!-- <div class="author-info">
			                                  <span class="tarikh"><h1><?php echo $join_date; ?></h1></span>
			                                </div> -->

			                            </div>

			                            <div class="pt-3">
			                            	<p class="tarikhhh"><?php echo $join_date; ?></p>
			                            </div>

			                            <div class="pt-2">
			                              <h4 class="btitle"><?php echo $blog_title; ?></h4>

			                              <div>
			                              	<?php

			                              		$sql = "SELECT * FROM users WHERE role = 1 ORDER BY user_id ASC LIMIT 1";
																	  		$allUserData = mysqli_query($db, $sql);

																	  		while( $row = mysqli_fetch_assoc($allUserData) ) {
																	  			$user_id  		= $row['user_id'];
																	  			$fullname  		= $row['fullname'];
																	  			$email  			= $row['email'];
																	  			$password  		= $row['password'];
																	  			$phone  			= $row['phone'];
																	  			$address  		= $row['address'];
																	  			$image  			= $row['image'];
																	  			$role  				= $row['role'];
																	  			$status  			= $row['status'];
																	  			$join_date  	= $row['join_date'];
																	  			?>
																	  				<div class="d-flex align-items-center" style="color: #777;">
																	  					<i class="far fa-user" aria-hidden="true" style="margin-right: 5px;"></i>
																	  					By <?php echo $fullname; ?>
																	  				</div>

																	  			<?php
																	  		}

			                              	?>


			                              </div>

			                              <p class="pera"><?php echo $blog_text; ?></p>
			                            </div>


			                        </div>
	                        		<!-- Card Part End -->


	                        		<!-- Sidebar Content Start -->
						      <?php include "inc/blog_sidebar.php"; ?>
						      <!-- Sidebar Content End -->
								</div>
                         	</div>


						</div>
					</div>
				</section>

	         <?php }

		}
	?>

<?php include "inc/footer.php"; ?>