Gecko [ ubschool.org.in ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
BCG	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
book_image	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
fonts	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
include	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
jsjs	[ DIR ]	drwxr-xr-x
less	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
upload	[ DIR ]	drwxr-xr-x
.htaccess	199 B	-rw-r--r--
.mad-root	0 B	-rw-r--r--
about_us.php	9.82 KB	-rw-r--r--
add_admin.php	8.78 KB	-rw-r--r--
add_book.php	15.62 KB	-rw-r--r--
add_modal_example.php	1.98 KB	-rw-r--r--
add_modal_example.txt	1.99 KB	-rw-r--r--
add_modal_example_2.php	1.98 KB	-rw-r--r--
add_modal_example_2.txt	1.98 KB	-rw-r--r--
add_modal_example_3.php	1.96 KB	-rw-r--r--
add_user.php	11 KB	-rw-r--r--
admin.php	5.01 KB	-rw-r--r--
admin_profile.php	5.01 KB	-rw-r--r--
allowed_days.php	5.23 KB	-rw-r--r--
allowed_qntty.php	5.09 KB	-rw-r--r--
book.php	6.85 KB	-rw-r--r--
book_print.php	3.89 KB	-rw-r--r--
book_print1.php	3.89 KB	-rw-r--r--
book_print2.php	3.89 KB	-rw-r--r--
book_print3.php	3.88 KB	-rw-r--r--
book_print4.php	3.9 KB	-rw-r--r--
book_print5.php	3.89 KB	-rw-r--r--
book_print6.php	3.9 KB	-rw-r--r--
borrow.php	3.27 KB	-rw-r--r--
borrow_book.php	16.83 KB	-rw-r--r--
borrow_book_query.php	1.74 KB	-rw-r--r--
borrow_query.php	546 B	-rw-r--r--
borrowed_book.php	5.42 KB	-rw-r--r--
borrowed_print.php	4.82 KB	-rw-r--r--
borrowed_print_sort.php	5.4 KB	-rw-r--r--
borrowed_report.php	4.26 KB	-rw-r--r--
borrowed_search.php	7.49 KB	-rw-r--r--
copy.txt	8.66 KB	-rw-r--r--
currentdate.php	578 B	-rw-r--r--
damage_books.php	6.84 KB	-rw-r--r--
datepicker.php	1.62 KB	-rw-r--r--
db_limsysuim.sql	786.67 KB	-rw-r--r--
delete_admin.php	206 B	-rw-r--r--
delete_temporary.php	2.85 KB	-rw-r--r--
delete_user.php	196 B	-rw-r--r--
edit_admin.php	10.05 KB	-rw-r--r--
edit_book.php	17.14 KB	-rw-r--r--
edit_user.php	11.89 KB	-rw-r--r--
error_log	672 B	-rw-r--r--
footer.php	16.41 KB	-rw-r--r--
hard_bound.php	6.84 KB	-rw-r--r--
hawid ka barcode.txt	3.57 KB	-rw-r--r--
hawid.txt	3.01 KB	-rw-r--r--
hawid_borrow_book.txt	10.19 KB	-rw-r--r--
hawiddd.txt	11.3 KB	-rw-r--r--
header.php	3.4 KB	-rw-r--r--
home.php	3.91 KB	-rw-r--r--
import_members.php	2.58 KB	-rw-r--r--
import_members_query.php	1.02 KB	-rw-r--r--
index.php	292.73 KB	-rw-r--r--
info.php	20 B	-rw-r--r--
issue_book_report_by_name.php	6.15 KB	-rw-r--r--
layout.php	2.29 KB	-rw-r--r--
lmsdb.sql	1.27 MB	-rw-r--r--
login.php	616 B	-rw-r--r--
logout.php	339 B	-rw-r--r--
lost_books.php	6.84 KB	-rw-r--r--
member_print.php	3.96 KB	-rw-r--r--
members_barcode_print.php	3.02 KB	-rw-r--r--
new_books.php	6.83 KB	-rw-r--r--
old_books.php	6.83 KB	-rw-r--r--
penalty.php	5.18 KB	-rw-r--r--
print_attendance.php	3.22 KB	-rw-r--r--
print_attendance_sort.php	3.32 KB	-rw-r--r--
print_barcode.php	3.43 KB	-rw-r--r--
print_barcode1.php	2.74 KB	-rw-r--r--
print_barcode11.php	3.39 KB	-rw-r--r--
print_barcode12.php	3.39 KB	-rw-r--r--
print_barcode13.php	3.39 KB	-rw-r--r--
print_barcode14.php	3.4 KB	-rw-r--r--
print_barcode15.php	3.39 KB	-rw-r--r--
print_barcode16.php	3.4 KB	-rw-r--r--
print_barcode_individual.php	2.85 KB	-rw-r--r--
print_barcode_individual1.php	2.03 KB	-rw-r--r--
print_barcode_individual1_1.ph...	2.11 KB	-rw-r--r--
print_issue_book_name.php	5.74 KB	-rw-r--r--
print_returned_book.php	6.18 KB	-rw-r--r--
print_returned_book_name.php	5.68 KB	-rw-r--r--
print_returned_sort.php	4.99 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x
report.php	7.15 KB	-rw-r--r--
report_by_title.php	2.07 KB	-rw-r--r--
report_by_volume.php	2.6 KB	-rw-r--r--
return_book_report_by_name.php	5.91 KB	-rw-r--r--
returned_book.php	8.04 KB	-rw-r--r--
returned_book_print.php	6.8 KB	-rw-r--r--
returned_book_search.php	8.83 KB	-rw-r--r--
returned_report.php	4.26 KB	-rw-r--r--
scripts.php	12.71 KB	-rw-r--r--
session.php	123 B	-rw-r--r--
session_user.php	385 B	-rw-r--r--
settings.php	549 B	-rw-r--r--
sidebar_menu.php	6.04 KB	-rw-r--r--
slide.php	2.55 KB	-rw-r--r--
sort_borrowed_book.php	5.37 KB	-rw-r--r--
sort_report.php	4.4 KB	-rw-r--r--
sort_returned_book.php	5.95 KB	-rw-r--r--
sort_returned_book_copy.txt	5.49 KB	-rw-r--r--
sub_rep.php	6.86 KB	-rw-r--r--
top_nav.php	2.07 KB	-rw-r--r--
update_members_status.php	193 B	-rw-r--r--
user.php	6.18 KB	-rw-r--r--
user_log_in.php	5.51 KB	-rw-r--r--
user_log_print.php	3.29 KB	-rw-r--r--
user_log_search.php	6.82 KB	-rw-r--r--
user_print_sort.php	3.46 KB	-rw-r--r--
view_admin.php	3.42 KB	-rw-r--r--
view_barcode.php	2.62 KB	-rw-r--r--
view_book.php	3.95 KB	-rw-r--r--
view_book_barcode.php	3.1 KB	-rw-r--r--
view_graph.php	6.46 KB	-rw-r--r--
view_members_barcode.php	3.21 KB	-rw-r--r--
view_user.php	3.61 KB	-rw-r--r--

Code Editor : add_book.php

<?php

include ('include/dbcon.php');
						$query = mysqli_query($conn,"SELECT * FROM `barcode` ORDER BY mid_barcode DESC ") or die (mysqli_error());
						$fetch = mysqli_fetch_array($query);
						$mid_barcode = $fetch['mid_barcode'];
						
						$new_barcode =  $mid_barcode + 1;
						$pre_barcode = "GPBLGR";
						$suf_barcode = "LMS";
						$generate_barcode = $pre_barcode.$new_barcode.$suf_barcode;

<?php include ('header.php'); ?>

<div class="page-title">
            <div class="title_left">
                <h3>
					<small>Home / Books /</small> Add Book
                </h3>
            </div>
        </div>
        <div class="clearfix"></div>
 
        <div class="row">
            <div class="col-md-12 col-sm-12 col-xs-12">
                <div class="x_panel">
                    <div class="x_title">
                        <h2><i class="fa fa-plus"></i> Add Book</h2>
                        <ul class="nav navbar-right panel_toolbox">
                            <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a></li>
                        
                            <li><a class="close-link"><i class="fa fa-close"></i></a></li>
                        </ul>
                        <div class="clearfix"></div>
                    </div>
                    <div class="x_content">

<form method="post" enctype="multipart/form-data" class="form-horizontal form-label-left">
							<input type="hidden" name="new_barcode" value="<?php echo $new_barcode; ?>">
							
								<div class="form-group">
                                    <label class="control-label col-md-4" for="first-name">ACC. No <span class="required" style="color:red;">*</span>
                                    </label>
                                    <div class="col-md-4">
                                        <input type="text" name="book_number" id="first-name2" required="required" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
								
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="first-name">Book Title <span class="required" style="color:red;">*</span>
                                    </label>
                                    <div class="col-md-4">
                                        <input type="text" name="book_title" id="first-name2" required="required" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
								
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="first-name">Author 1 <span class="required" style="color:red;">*</span>
                                    </label>
                                    <div class="col-md-4">
                                        <input type="text" name="author" id="first-name2" required="required" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="first-name">Author 2
                                    </label>
                                    <div class="col-md-4">
                                        <input type="text" name="author_2" id="first-name2" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="first-name">Author 3
                                    </label>
                                    <div class="col-md-4">
                                        <input type="text" name="author_3" id="first-name2" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="first-name">Author 4
                                    </label>
                                    <div class="col-md-4">
                                        <input type="text" name="author_4" id="first-name2" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="first-name">Author 5
                                    </label>
                                    <div class="col-md-4">
                                        <input type="text" name="author_5" id="first-name2" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="last-name">Book Published date
                                    </label>
                                    <div class="col-md-4">
                                        <input placeholder="mm-dd-yy" type="text" name="book_pub" id="last-name2" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="last-name">Publisher Name
                                    </label>
                                    <div class="col-md-4">
                                        <input type="text" name="publisher_name" id="last-name2" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="last-name">ISBN <span class="required" style="color:red;">*</span>
                                    </label>
                                    <div class="col-md-4">
                                        <input type="text" name="isbn" id="last-name2" class="form-control col-md-7 col-xs-12" required="required">
                                    </div>
                                </div>
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="last-name">Copyright Year
                                    </label>
                                    <div class="col-md-4">
                                        <input placeholder="YYYY" type="text" name="copyright_year" id="last-name2" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="last-name">Book Copies <span class="required" style="color:red;">*</span>
                                    </label>
                                    <div class="col-md-1">
                                        <input type="number" name="book_copies" step="1" min="0" max="1000" required="required"  class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="last-name">Status <span class="required" style="color:red;">*</span>
                                    </label>
									<div class="col-md-4">
                                        <select name="status" class="select2_single form-control" tabindex="-1" required="required">
											<option value="New">New</option>
											<option value="Old">Old</option>
											<option value="Lost">Lost</option>
											<option value="Damaged">Damaged</option>
											<option value="Replacement">Replacement</option>
											<option value="Hardbound">Hardbound</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="last-name">Category <span class="required" style="color:red;">*</span>
                                    </label>
									<div class="col-md-4">
                                        <select name="category_id" class="select2_single form-control" tabindex="-1" required="required">
										<?php
										$result= mysqli_query($conn,"select * from category") or die (mysqli_error());
										while ($row= mysqli_fetch_array ($result) ){
										$id=$row['category_id'];
										?>
                                            <option value="<?php echo $row['category_id']; ?>"><?php echo $row['classname']; ?></option>
										<?php } ?>
                                        </select>
                                    </div>
                                </div>
								<div class="form-group">
                                    <label class="control-label col-md-4" for="last-name">Source
                                    </label>
                                    <div class="col-md-4">
                                        <input type="text" name="source" id="last-name2" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
								<div class="form-group">
                                    <label class="control-label col-md-4" for="last-name">Bill Number
                                    </label>
                                    <div class="col-md-4">
                                        <input type="text" name="bill_no" id="last-name2" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
								<div class="form-group">
                                    <label class="control-label col-md-4" for="last-name">Bill Date
                                    </label>
                                    <div class="col-md-4">
                                        <input placeholder="mm-dd-yy" type="text" name="bill_date" id="last-name2" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
								<div class="form-group">
                                    <label class="control-label col-md-4" for="last-name">price
                                    </label>
                                    <div class="col-md-4">
                                        <input placeholder="" type="text" name="price" id="last-name2" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
                                <div class="form-group">
                                    <label class="control-label col-md-4" for="last-name">Book Image
                                    </label>
                                    <div class="col-md-4">
                                        <input type="file" style="height:44px;" name="image" id="last-name2" class="form-control col-md-7 col-xs-12">
                                    </div>
                                </div>
                                <div class="ln_solid"></div>
                                <div class="form-group">
                                    <div class="col-md-9 col-sm-9 col-xs-12 col-md-offset-3">
                                        <a href="book.php"><button type="button" class="btn btn-primary"><i class="fa fa-times-circle-o"></i> Cancel</button></a>
                                        <button type="submit" name="submit" class="btn btn-success"><i class="fa fa-plus-square"></i> Submit</button>
                                    </div>
                                </div>
                            </form>
							
            <?php

include ('include/dbcon.php');
			if (!isset($_FILES['image']['tmp_name'])) {
			echo "";
			}else{
			$file=$_FILES['image']['tmp_name'];
			$image = $_FILES["image"] ["name"];
			$image_name= addslashes($_FILES['image']['name']);
			$size = $_FILES["image"] ["size"];
			$error = $_FILES["image"] ["error"];
			{
						if($size > 10000000) //conditions for the file
						{
						die("Format is not allowed or file size is too big!");
						}
						
					else
						{

move_uploaded_file($_FILES["image"]["tmp_name"],"upload/" . $_FILES["image"]["name"]);			
					$book_image=$_FILES["image"]["name"];
					
					$book_title=$_POST['book_title'];
					$category_id=$_POST['category_id'];
					$author=$_POST['author'];
					$author_2=$_POST['author_2'];
					$author_3=$_POST['author_3'];
					$author_4=$_POST['author_4'];
					$author_5=$_POST['author_5'];
					$book_copies=$_POST['book_copies'];
					$book_pub=$_POST['book_pub'];
					$publisher_name=$_POST['publisher_name'];
					$isbn=$_POST['isbn'];
					$copyright_year=$_POST['copyright_year'];
					$status=$_POST['status'];
					
					$book_number=$_POST['book_number'];
					$source=$_POST['source'];
					$bill_no=$_POST['bill_no'];
					$bill_date=$_POST['bill_date'];
					$price=$_POST['price'];
					
					
					$pre = "GPBLGR";
					$mid = $_POST['new_barcode'];
					$suf = "LMS";
					$gen = $pre.$mid.$suf;
					
					if ($status == 'Lost') {
						$remark = 'Not Available';
					} elseif ($status == 'Damaged') {
						$remark = 'Not Available';
					} else {
						$remark = 'Available';
					}
					
					{
					mysqli_query($conn,"insert into book (book_title,category_id,author,author_2,author_3,author_4,author_5,book_copies,book_pub,publisher_name,isbn,copyright_year,status,book_barcode,book_image,date_added,remarks,book_number,source,bill_no,bill_date,price)
					values('$book_title','$category_id','$author','$author_2','$author_3','$author_4','$author_5','$book_copies','$book_pub','$publisher_name','$isbn','$copyright_year','$status','$gen','$book_image',NOW(),'$remark','$book_number','$source','$bill_no','$bill_date','$price')")or die(mysqli_error());
					
					mysqli_query($conn,"insert into barcode (pre_barcode,mid_barcode,suf_barcode) values ('$pre', '$mid', '$suf') ") or die (mysqli_error());
					}
					header("location: view_barcode.php?code=".$gen);
					}
                }
            }
            ?>
						
                        
                    </div>
                </div>
            </div>
        </div>

<?php include ('footer.php'); ?>

${this.title}

Code Editor : add_book.php