Crud of books

-

 books/index.php

<!-- resources/views/books/index.blade.php -->


<x-app-layout>

    <div class="container mx-auto p-4">

        <div class="flex justify-between items-center mb-4">

            <h1 class="text-2xl font-bold">Books</h1>


            <!-- Search Form -->

            <form method="GET" action="{{ route('books.index') }}" class="flex items-center space-x-2">

                <input type="text" name="search" value="{{ request('search') }}" placeholder="Search by title or author" class="px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm">

                <button type="submit" class="bg-blue-500 text-white px-4 py-2 rounded">Search</button>

                @if(request('search'))

                    <a href="{{ route('books.index') }}" class="bg-gray-500 text-white px-4 py-2 rounded">Clear Search</a>

                @endif

            </form>


            <a href="{{ route('books.create') }}" class="bg-blue-500 text-white px-4 py-2 rounded">Add New Book</a>

        </div>


        <table class="min-w-full bg-white border border-gray-200 rounded-lg">

            <thead>

                <tr class="w-full bg-gray-100 border-b border-gray-200">

                    <th class="py-2 px-4 text-left">ID</th>

                    <th class="py-2 px-4 text-left">Title</th>

                    <th class="py-2 px-4 text-left">Author</th>

                    <!-- th class="py-2 px-4 text-left">ISBN</>

                    <th class="py-2 px-4 text-left">Published Date</th -->

                    <th class="py-2 px-4 text-left">Status</th>

                    <th class="py-2 px-4 text-left">Actions</th>

                </tr>

            </thead>

            <tbody>

                @forelse ($books as $book)

                    <tr>

                        <td class="py-2 px-4 border-b">{{ $book->id }}</td>

                        <td class="py-2 px-4 border-b">{{ $book->title }}</td>

                        <td class="py-2 px-4 border-b">{{ $book->author }}</td>

                        <!-- td class="py-2 px-4 border-b">{{ $book->isbn }}</>

                        <td class="py-2 px-4 border-b">{{ \Carbon\Carbon::parse($book->published_date)->format('Y-m-d') }}</td -->

                        <td class="py-2 px-4 border-b">{{ ucfirst($book->status) }}</td>

                        <td class="py-2 px-4 border-b flex space-x-2">

                            <a href="{{ route('books.show', $book) }}" class="text-blue-500">View</a>

                            <a href="{{ route('books.edit', $book) }}" class="text-green-500">Edit</a>


                            <!-- Check Out / Return Buttons -->

                            @if ($book->status == 'available')

                                <form action="{{ route('books.checkout', $book->id) }}" method="POST">

                                    @csrf

                                    <button type="submit" class="text-yellow-500">Check Out</button>

                                </form>

                            @else

                                <form action="{{ route('books.return', $book->id) }}" method="POST">

                                    @csrf

                                    <button type="submit" class="text-green-500">Return</button>

                                </form>

                            @endif


                            <!-- Delete Form -->

                            <form action="{{ route('books.destroy', $book) }}" method="POST" class="inline">

                                @csrf

                                @method('DELETE')

                                <button type="submit" class="text-red-500">Delete</button>

                            </form>

                        </td>

                    </tr>

                @empty

                    <tr>

                        <td colspan="7" class="py-2 px-4 text-center">No books found</td>

                    </tr>

                @endforelse

            </tbody>

        </table>

    </div>

</x-app-layout>






books/show.blade.php

<!-- resources/views/books/show.blade.php -->


<x-app-layout>

    <div class="container mx-auto p-4">

        <h1 class="text-2xl font-bold mb-4">Book Details</h1>


        <div class="bg-white p-6 border border-gray-200 rounded-lg">

            <p><strong>ID:</strong> {{ $book->id }}</p>

            <p><strong>Title:</strong> {{ $book->title }}</p>

            <p><strong>Author:</strong> {{ $book->author }}</p>

            <p><strong>ISBN:</strong> {{ $book->isbn }}</p>

            <p><strong>Published Date:</strong> {{ \Carbon\Carbon::parse($book->published_date)->format('Y-m-d') }}</p>

            <p><strong>Status:</strong> {{ ucfirst($book->status) }}</p>


            <div class="mt-4">

                <a href="{{ route('books.edit', $book) }}" class="bg-green-500 text-white px-4 py-2 rounded">Edit</a>

                <a href="{{ route('books.index') }}" class="bg-gray-500 text-white px-4 py-2 rounded ml-4">Back to list</a>


                <!-- Check Out / Return Buttons -->

                @if ($book->status == 'available')

                    <form action="{{ route('books.checkout', $book) }}" method="POST" class="inline">

                        @csrf

                        <button type="submit" class="bg-yellow-500 text-white px-4 py-2 rounded ml-4">Check Out</button>

                    </form>

                @else

                    <form action="{{ route('books.return', $book) }}" method="POST" class="inline">

                        @csrf

                        <button type="submit" class="bg-green-500 text-white px-4 py-2 rounded ml-4">Return</button>

                    </form>

                @endif

            </div>

        </div>

    </div>

</x-app-layout>






books/edit.blade.php

<!-- resources/views/books/edit.blade.php -->


<x-app-layout>

    <div class="container mx-auto p-4">

        <h1 class="text-2xl font-bold mb-4">Edit Book</h1>


        <form action="{{ route('books.update', $book) }}" method="POST" class="bg-white p-6 border border-gray-200 rounded-lg">

            @csrf

            @method('PUT')

            <div class="mb-4">

                <label for="title" class="block text-sm font-medium text-gray-700">Title</label>

                <input type="text" id="title" name="title" value="{{ old('title', $book->title) }}" class="mt-1 block w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm" required>

                @error('title')

                    <p class="text-red-500 text-sm">{{ $message }}</p>

                @enderror

            </div>

            <div class="mb-4">

                <label for="author" class="block text-sm font-medium text-gray-700">Author</label>

                <input type="text" id="author" name="author" value="{{ old('author', $book->author) }}" class="mt-1 block w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm" required>

                @error('author')

                    <p class="text-red-500 text-sm">{{ $message }}</p>

                @enderror

            </div>

            <div class="mb-4">

                <label for="isbn" class="block text-sm font-medium text-gray-700">ISBN</label>

                <input type="text" id="isbn" name="isbn" value="{{ old('isbn', $book->isbn) }}" class="mt-1 block w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm" required>

                @error('isbn')

                    <p class="text-red-500 text-sm">{{ $message }}</p>

                @enderror

            </div>

            <div class="mb-4">

                <label for="published_date" class="block text-sm font-medium text-gray-700">Published Date</label>

                <input type="date" id="published_date" name="published_date" value="{{ old('published_date', \Carbon\Carbon::parse($book->published_date)->format('Y-m-d')) }}" class="mt-1 block w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm" required>

                @error('published_date')

                    <p class="text-red-500 text-sm">{{ $message }}</p>

                @enderror

                

            </div>

            <div class="mb-4">

                <label for="status" class="block text-sm font-medium text-gray-700">Status</label>

                <select id="status" name="status" class="mt-1 block w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm" required>

                    <option value="available" {{ old('status', $book->status) == 'available' ? 'selected' : '' }}>Available</option>

                    <option value="checked_out" {{ old('status', $book->status) == 'checked_out' ? 'selected' : '' }}>Checked Out</option>

                </select>

                @error('status')

                    <p class="text-red-500 text-sm">{{ $message }}</p>

                @enderror

            </div>

            <button type="submit" class="bg-blue-500 text-white px-4 py-2 rounded">Update Book</button>

            <a href="{{ route('books.index') }}" class="ml-4 text-gray-600">Back to list</a>

        </form>

    </div>

</x-app-layout>






books/create.blade.php

<!-- resources/views/books/create.blade.php -->


<x-app-layout>

    <div class="container mx-auto p-4">

        <h1 class="text-2xl font-bold mb-4">Add New Book</h1>


        <form action="{{ route('books.store') }}" method="POST" class="bg-white p-6 border border-gray-200 rounded-lg">

            @csrf

            <div class="mb-4">

                <label for="title" class="block text-sm font-medium text-gray-700">Title</label>

                <input type="text" id="title" name="title" value="{{ old('title') }}" class="mt-1 block w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm" required>

                @error('title')

                    <p class="text-red-500 text-sm">{{ $message }}</p>

                @enderror

            </div>

            <div class="mb-4">

                <label for="author" class="block text-sm font-medium text-gray-700">Author</label>

                <input type="text" id="author" name="author" value="{{ old('author') }}" class="mt-1 block w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm" required>

                @error('author')

                    <p class="text-red-500 text-sm">{{ $message }}</p>

                @enderror

            </div>

            <div class="mb-4">

                <label for="isbn" class="block text-sm font-medium text-gray-700">ISBN</label>

                <input type="text" id="isbn" name="isbn" value="{{ old('isbn') }}" class="mt-1 block w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm" required>

                @error('isbn')

                    <p class="text-red-500 text-sm">{{ $message }}</p>

                @enderror

            </div>

            <div class="mb-4">

                <label for="published_date" class="block text-sm font-medium text-gray-700">Published Date</label>

                <input type="date" id="published_date" name="published_date" value="{{ old('published_date') }}" class="mt-1 block w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm" required>

                @error('published_date')

                    <p class="text-red-500 text-sm">{{ $message }}</p>

                @enderror

            </div>

            <div class="mb-4">

                <label for="status" class="block text-sm font-medium text-gray-700">Status</label>

                <select id="status" name="status" class="mt-1 block w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm" required>

                    <option value="available" {{ old('status') == 'available' ? 'selected' : '' }}>Available</option>

                    <option value="checked_out" {{ old('status') == 'checked_out' ? 'selected' : '' }}>Checked Out</option>

                </select>

                @error('status')

                    <p class="text-red-500 text-sm">{{ $message }}</p>

                @enderror

            </div>

            <button type="submit" class="bg-blue-500 text-white px-4 py-2 rounded">Add Book</button>

            <a href="{{ route('books.index') }}" class="ml-4 text-gray-600">Back to list</a>

        </form>

    </div>

</x-app-layout>






Web.php

<?php


use App\Http\Controllers\ProfileController;

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\BookController;


/*

|--------------------------------------------------------------------------

| Web Routes

|--------------------------------------------------------------------------

|

| Here is where you can register web routes for your application. These

| routes are loaded by the RouteServiceProvider and all of them will

| be assigned to the "web" middleware group. Make something great!

|

*/


Route::get('/', function () {

    return view('welcome');

});


Route::middleware(['auth' , 'verified'])->group(function () {

    Route::get('/dashboard', function () {

            return view('dashboard');

        })->name('dashboard');

        

    // Book management routes

    Route::resource('books', BookController::class);


    // Additional routes that require authentication

    // For example, checking out and returning books

    Route::post('books/{id}/checkout', [BookController::class, 'checkout'])->name('books.checkout');

    Route::post('books/{id}/return', [BookController::class, 'return'])->name('books.return');


});


// Route::get('/dashboard', function () {

//     return view('dashboard');

// })->middleware(['auth', 'verified'])->name('dashboard');


Route::middleware('auth')->group(function () {

    Route::get('/profile', [ProfileController::class, 'edit'])->name('profile.edit');

    Route::patch('/profile', [ProfileController::class, 'update'])->name('profile.update');

    Route::delete('/profile', [ProfileController::class, 'destroy'])->name('profile.destroy');

});


require __DIR__.'/auth.php';







BookController.php

<?php


namespace App\Http\Controllers;


use Illuminate\Http\Request;

use App\Models\Book;

use Illuminate\Support\Facades\DB;

use Illuminate\Support\Facades\Log;


class BookController extends Controller

{

     // GET /books

     public function index(Request $request)

     {

        $query = $request->input('search');

        

        // Filter books by title or author if search query is present

        $books = Book::when($query, function($queryBuilder) use ($query) {

            return $queryBuilder->where('title', 'like', "%{$query}%")

                                ->orWhere('author', 'like', "%{$query}%");

        })->get();

        

        return view('books.index', compact('books'));

     }

 

     // GET /books/create

     public function create()

     {

         return view('books.create');

     }

 

     // POST /books

     public function store(Request $request)

     {

         $validatedData = $request->validate([

             'title' => 'required|string|max:255',

             'author' => 'required|string|max:255',

             'isbn' => 'required|string|unique:books,isbn|max:13',

             'published_date' => 'nullable|date',

             'status' => 'required|in:available,checked_out',

         ]);

 

         Book::create($validatedData);

 

         return redirect()->route('books.index')->with('success', 'Book added successfully.');

     }

 

     // GET /books/{id}

     public function show(Book $book)

     {

         return view('books.show', compact('book'));

     }

 

     // GET /books/{id}/edit

     public function edit(Book $book)

     {

         return view('books.edit', compact('book'));

     }

 

     // PUT/PATCH /books/{id}

     public function update(Request $request, Book $book)

     {

         $validatedData = $request->validate([

             'title' => 'required|string|max:255',

             'author' => 'required|string|max:255',

             'isbn' => 'required|string|unique:books,isbn,' . $book->id . '|max:13',

             'published_date' => 'nullable|date',

             'status' => 'required|in:available,checked_out',

         ]);

 

         $book->update($validatedData);

 

         return redirect()->route('books.index')->with('success', 'Book updated successfully.');

     }

 

     // DELETE /books/{id}

     public function destroy(Book $book)

     {

         $book->delete();

 

         return redirect()->route('books.index')->with('success', 'Book deleted successfully.');

     }

 

     // POST /books/{id}/checkout

     public function checkout($id)

     {

        // Find the book by ID

        $book = Book::findOrFail($id);

        $book->status = 'checked_out';

        $book->update();

 

         return redirect()->route('books.index')->with('success', 'Book checked out successfully.');

     }

 

     // POST /books/{id}/return

     public function return($id)

     {

        // Find the book by ID

        $book = Book::findOrFail($id);

        $book->status = 'available';

        $book->update();


        return redirect()->route('books.index')->with('success', 'Book returned successfully.');


     }

}




Models/Book.php

<?php


namespace App\Models;


use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;


class Book extends Model

{

    use HasFactory;


    protected $fillable = [

        'title',

        'author',

        'description',

        'published_date',

        'pages',

        'isbn',

        'status'

    ];


    // If you have relationships, define them here

    // e.g., public function user() { return $this->belongsTo(User::class); }

}




database/migration/bookmigration.php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('books', function (Blueprint $table) {
            $table->id();
            $table->string('title')->nullable(false);
            $table->string('author')->nullable(false);
            $table->string('isbn')->unique();
            $table->date('published_date')->nullable();
            $table->enum('status', ['available', 'checked_out'])->default('available');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('books');
    }
};




Comments

Post a Comment

Please do not enter any spam link in the comment box.

Popular posts from this blog

AUTOMATA DEFINITIONS

-
 AUTOMATA DEFINITIONS THIS SUBJECT IS FULLY BASED ON EXAMPLES, DEFINITIONS, GRAMMAR RULES, DIAGRAMS AND THEOREMS. IMPORTANT DEFINITIONS:  DFA:    A Deterministic Finite State Automaton (DFSA) is denoted by M and it is a set of 5-tuples i.e. M=(Q, Σ, δ, q 0 , F) where, * Q is a non-empty finite set of states * Σ is a non-empty finite set of input symbols *  q 0 is the initial state or starting state. (q0 ∈ Q) * F is a non-empty finite set of final state. (F ⊆ Q). * δ (pronounce delta) is the transition function. Q x Σ → Q. δ(q,a) = p means, if  the automation is in state q and reading a symbol a, it goes to state p in the next instant, moving the pointer one cell to the right. NDFA:    A Non-Deterministic Finite State Automaton (NFSA) is denoted by M and it is a set of 5-tuples i.e. M=(Q, Σ, δ, q 0 , F) where, * Q is a non-empty finite set of states * Σ is a non-empty finite set ...
Read more

DMA IN MP

-
  What is DMA and Why it is used? Direct memory access (DMA) is a mode of data transfer between the memory and I/O devices. This happens without the involvement of the processor. We have two other methods of data transfer, programmed I/O and Interrupt driven I/O. Let’s revise each and get acknowledge with their drawbacks. In programmed I/O, the processor keeps on scanning whether any device is ready for data transfer. If an I/O device is ready, the processor fully dedicates itself in transferring the data between I/O and memory. It transfers data at a high rate, but it can’t get involved in any other activity during data transfer. This is the major drawback of programmed I/O. In Interrupt driven I/O, whenever the device is ready for data transfer, then it raises an interrupt to processor. Processor completes executing its ongoing instruction and saves its current state. It then switches to data transfer which causes a delay. Here, the processor doesn’t keep scanning for periphe...
Read more

MAKING POWERPOINT SLIDES

-
Making PowerPoint Slides Avoiding the Pitfalls of Bad Slides   Tips to be Covered    Outlines  Slide Structure  Fonts  Color  Background  Graphs  Spelling and Grammar  Conclusions  Questions   Outline    Make your 1 st or 2 nd slide an outline of your presentation – Ex: previous slide  Follow the order of your outline for the rest of the presentation  Only place main points on the outline slide – Ex: Use the titles of each slide as main points     Slide Structure – Good    Use 1-2 slides per minute of your presentation  Write in point form, not complete sentences  Include 4-5 points per slide  Avoid wordiness: use key words and phrases only     Slide Structure - Bad   This page contains too many words for a presentation slide. It is not written in point form, making it difficult both for your audience to read and for you to present each point. Although there are exactly the same number of points on this slide a...
Read more

Java Interview Questions

-
  Java Interview Questions 1. What are the differences between C++ and Java? C++ is not platform-independent; the principle behind C++ programming is “write once, compile anywhere.” In contrast, because the byte code generated by the Java compiler is platform-independent, it can run on any machine, Java programs are written once and run everywhere. ·         Languages Compatibility. C++ is a programming language that is based on the C programming language . Most other high-level languages are compatible with C++. Most of the languages of Java are incompatible. Java is comparable to those of C and C++. ·         Interaction with the library. It can access the native system libraries directly in C++. As a result, it’s better for programming at the system level. Java’s native libraries do not provide direct call support. You can use Java Native Interface or access the libraries. ·         Characteristics. C++ distinguishes it...
Read more

TONGUE TWISTER ENGLISH

-
  Tongue twisters are a great way to practice and improve pronunciation and fluency. They can also help to improve accents by using alliteration, which is the repetition of one sound. They’re not just for kids, but are also used by actors, politicians, and public speakers who want to sound clear when speaking. Below, you will find some of the most popular English tongue twisters. Say them as quickly as you can. If you can master them, you will be a much more confident speaker. Peter Piper picked a peck of pickled peppers A peck of pickled peppers Peter Piper picked If Peter Piper picked a peck of pickled peppers Where’s the peck of pickled peppers Peter Piper picked? Betty Botter bought some butter But she said the butter’s bitter If I put it in my batter, it will make my batter bitter But a bit of better butter will make my batter better So ‘twas better Betty Botter bought a bit of better butter How much wood would a woodchuck chuck if a woodchuck could chuck wood? He would ch...
Read more

Image upload code in laravel

-
 Uploading images in a Laravel application is a common task. Here's a step-by-step guide to implementing image upload functionality using Laravel: ### Step 1: Set Up the Form for Image Upload First, create a form in your Blade template to allow users to upload an image. ```blade <!-- resources/views/upload.blade.php --> <!DOCTYPE html> <html lang="en"> <head>     <meta charset="UTF-8">     <meta name="viewport" content="width=device-width, initial-scale=1.0">     <title>Image Upload</title> </head> <body>     <h1>Upload an Image</h1>          <form action="{{ route('image.upload') }}" method="POST" enctype="multipart/form-data">         @csrf         <div>             <label for="image">Choose an image:</label>             ...
Read more

how to use vim editor in gitbash

-
 Using the Vim editor in Git Bash is similar to using it in any terminal environment. Vim is a powerful text editor available on most Unix-based systems, including the Git Bash environment on Windows. Here’s a basic guide on how to use Vim within Git Bash: ### 1. **Opening Vim**    - To open a file in Vim, navigate to the directory containing your file using Git Bash and type:      ```bash      vim filename      ```      Replace `filename` with the name of the file you want to edit. If the file doesn’t exist, Vim will create it when you save. ### 2. **Basic Vim Modes**    - **Normal Mode:** This is the default mode when you open Vim. In this mode, you can navigate through the file and issue commands.    - **Insert Mode:** This mode allows you to insert text into the file. To enter Insert Mode from Normal Mode, press `i`.    - **Command Mode:** This mode is used for saving, quitting, ...
Read more

Test Node js ( API Creating and Test in Postman )

-
  BACKEND MACHINE TEST F.M: 50 TIME: 1 HR 30 MIN Question: 1 You have a develop API with CRUD OPERATION and test that API using POSTMAN TOOL: NOTE: CREATE A NEW APP FOR THE API CREATION AND INSTALL THE DEPENDENCY REQUIRED FOR API CREATION. NOTE THE BELOW POINTS:  CREATE A MODAL SCHEMA FOR RAILINFO :  Fields :  { _id:’’ , train_no:’’ , train_name:’’ , src_station:’’,dest_station:’’,platform_no:’’,dep_time:’’,arr_time:’’}  CREATE THE CONTROLLER FOR THE BELOW OPERATIONS ON API :  FETCH ALL TRAIN INFO  FIND SPECIFIC TRAIN INFO based on src_station , dest_station  INSERT TRAIN INFO  UPDATE TRAIN INFO based on train_no  DELETE TRAIN INFO based on train _id  CREATE THE PROPER ROUTING FOR API.  TEST EACH ENDPOINTS USING POSTMAN and provide the screenshots Attached.  Task Overview: You need to develop an API that supports CRUD operations (Create, Read, Update, Delete) for train information. The API will be tested using the Postman tool. The steps below will guide you through...
Read more

Template of Survey papers

-
Image
  Template for submission of Survey papers for           Literature survey (PaperCode) First A. Author, Second B. Author, Jr., and Third C. Author F. A. Author, Paper Name, Department of Computational Science, University, India ( e-mail: author1@ xyz.com). S. A. Author, Paper Name,  Department of Computational Science,University, India ( e-mail: author2@ xyz.com). T. A. Author, Paper Name , Department of Computational Science, University, India ( e-mail: author3@ xyz.com).     ABSTRACT Fill the text from your manuscript in different sections as shown below. Fill the text from your manuscript in different sections as shown below. Fill the text from your manuscript in different sections as shown below. Fill the text from your manuscript in different sections. Fill the text from your manuscript in different sections. Fill the text from your manuscript in different sections. Fill the text from your manuscript in different...
Read more