Insert, update, delete operations in PHP - Mini Project: Build & Apply

Insert, update, delete operations

📖 Scenario: You are managing a small library system. You need to keep track of books using PHP arrays. You will add new books, update existing book details, and remove books when they are no longer available.

🎯 Goal: Build a PHP script that performs insert, update, and delete operations on an array representing books in a library.

📋 What You'll Learn

Create an associative array called $books with specific book entries

Add a new book entry to the $books array

Update the author of an existing book in the $books array

Delete a book entry from the $books array

Print the final $books array

💡 Why This Matters

🌍 Real World

Managing collections of data like books, users, or products often requires adding, updating, and deleting entries in arrays or databases.

💼 Career

Understanding how to manipulate data structures is essential for backend development, data processing, and building dynamic applications.

1

Create the initial books array

Create an associative array called $books with these exact entries: '1984' => 'George Orwell', 'To Kill a Mockingbird' => 'Harper Lee', and 'The Great Gatsby' => 'F. Scott Fitzgerald'.

PHP

# Create the initial books array
# Your code here

Need a hint?

Use square brackets [] to create an associative array with book titles as keys and authors as values.

2

Add a new book entry

Add a new book entry to the $books array with the key 'Brave New World' and the value 'Aldous Huxley'.

PHP

 'George Orwell',
    'To Kill a Mockingbird' => 'Harper Lee',
    'The Great Gatsby' => 'F. Scott Fitzgerald'
];
# Add the new book 'Brave New World' by 'Aldous Huxley' below
# Your code here

Need a hint?

Use the syntax $array['key'] = 'value'; to add a new entry to an associative array.

3

Update an existing book author

Update the author of the book '1984' in the $books array to 'Eric Arthur Blair'.

PHP

 'George Orwell',
    'To Kill a Mockingbird' => 'Harper Lee',
    'The Great Gatsby' => 'F. Scott Fitzgerald'
];
$books['Brave New World'] = 'Aldous Huxley';
# Update the author of '1984' to 'Eric Arthur Blair' below
# Your code here

Need a hint?

To update a value, assign a new value to the existing key like $array['key'] = 'new value';.

4

Delete a book entry and print the array

Remove the book 'The Great Gatsby' from the $books array using the unset() function. Then print the $books array using print_r().

PHP

 'George Orwell',
    'To Kill a Mockingbird' => 'Harper Lee',
    'The Great Gatsby' => 'F. Scott Fitzgerald'
];
$books['Brave New World'] = 'Aldous Huxley';
$books['1984'] = 'Eric Arthur Blair';
# Remove 'The Great Gatsby' from the array
# Print the $books array
# Your code here

Need a hint?

Use unset($array['key']); to delete an entry. Use print_r($array); to display the array.