Adding a EDIT button to a php app?

Question

I am building an application that needs to have a button to edit and when you click the edit button should take me to the edit section in wish will retrieve the information of the item and will let me update it. I will need to: Add a new column to the product HTML table in index.php allowing the user to click on an <a href> link to edit the product Use a query string "?xxx=123" then I need to Create a form that allows the user to update data and then Create a query to get the current data for the product to be edited from the product table and finally I need Create a PHP script that processes the POSTed and updated data I will need to use an UPDATE SQL query. This is what I have done but is ot working. I know is a lot thank you for your guys help

"<?php require_once('database.php');

// Get category ID if (!isset($category_id)) { $category_id = filter_input(INPUT_GET, 'category_id', FILTER_VALIDATE_INT); if ($category_id == NULL || $category_id == FALSE) { $category_id = 1; } } // Get name for selected category $queryCategory = 'SELECT * FROM category WHERE categoryID = :category_id'; $statement1 = $db->prepare($queryCategory); $statement1->bindValue(':category_id', $category_id); $statement1->execute(); $category = $statement1->fetch(); $category_name = $category['categoryName']; $statement1->closeCursor();

// Get all categories $query = 'SELECT * FROM categories ORDER BY categoryID'; $statement = $db->prepare($query); $statement->execute(); $categories = $statement->fetchAll(); $statement->closeCursor();

// Get products for selected category $queryProducts = 'SELECT * FROM products WHERE categoryID = :category_id ORDER BY productID'; $statement3 = $db->prepare($queryProducts); $statement3->bindValue(':category_id', $category_id); $statement3->execute(); $products = $statement3->fetchAll(); $statement3->closeCursor(); ?> <!DOCTYPE html> <html>

<head> <title>My Guitar Shop</title> <link rel="stylesheet" type="text/css" href="main.css" /> </head>

<body> <header><h1>Product Manager</h1></header> <main> <h1>Product List</h1>

<aside>
    <!-- display a list of categories -->
    <h2>Categories</h2>
    <nav>
    <ul>
        <?php foreach ($categories as $category) : ?>
        <li><a href=".?category_id=<?php echo $category['categoryID']; ?>">
                <?php echo $category['categoryName']; ?>
            </a>
        </li>
        <?php endforeach; ?>
    </ul>
    </nav>          
</aside>

<section>
    <!-- display a table of products -->
    <h2><?php echo $category_name; ?></h2>
    <table>
        <tr>
            <th>Code</th>
            <th>Name</th>
            <th class="right">Price</th>
            <th>&nbsp;</th>
              <th>&nbsp;</th>
        </tr>

        <?php foreach ($products as $product) : ?>
        <tr>
            <td><?php echo $product['productCode']; ?></td>
            <td><?php echo $product['productName']; ?></td>
            <td class="right"><?php echo $product['listPrice']; ?></td>
            <td>
            <form action="update_form.php" method="post">
                <input type="hidden" name="product_id"
                       value="<?php echo $product['productID']; ?>">
                <input type="hidden" name="category_id"
                       value="<?php echo $product['categoryID']; ?>">
                <input type="submit" value="edit">
            </form></td>
            <td><form action="delete_product.php" method="post">
                <input type="hidden" name="product_id"
                       value="<?php echo $product['productID']; ?>">
                <input type="hidden" name="category_id"
                       value="<?php echo $product['categoryID']; ?>">
                <input type="submit" value="Delete">
            </form></td>
        </tr>
        <?php endforeach; ?>
    </table>
    <p><a href="add_product_form.php">Add Product</a></p>
    <p><a href="category_list.php">List Categories</a></p>        
</section>

</main> <footer> <p>© <?php echo date("Y"); ?> My Guitar Shop, Inc.</p> </footer> </body> </html>"

"<?php

require('database.php'); $query = 'SELECT * FROM categories ORDER BY categoryID'; $statement = $db->prepare($query); $statement->execute(); $products = $statement->fetchAll(); $statement->closeCursor(); ?> <!DOCTYPE html> <html>

<head> <title>My Guitar Shop</title> <link rel="stylesheet" type="text/css" href="main.css"> </head>

<body> <header><h1>Product Manager</h1></header>

<main>
    <h1>Update Product</h1>
    <form action="update_product.php" method="post"
          id="update_form">

        <label>Category:</label>
        <select name="category_id">
        <?php foreach ($category as $product) : ?>
            <option value="<?php echo $product['productID']; ?>">
                <?php echo $product['productName']; ?>
            </option>
        <?php endforeach; ?>
        </select><br>

        <label>Code:</label>
        <input type="text" name="code" <?php echo $code; ?>><br>

        <label>Name:</label>
        <input type="text" name="name" <?php echo $name; ?>><br>

        <label>List Price:</label>
        <input type="text" name="price" <?php echo $price; ?><br>

        <label>&nbsp;</label>
        <input type="submit" value="Edit"><br>
    </form>
    <p><a href="index.php">View Product List</a></p>
</main>

<footer>
    <p>&copy; <?php echo date("Y"); ?> My Guitar Shop, Inc.</p>
</footer>

</body> </html>"

"<?php // Get the product data

$category_id = filter_input(INPUT_POST, 'category_id', FILTER_VALIDATE_INT); $code = filter_input(INPUT_POST, 'code'); $name = filter_input(INPUT_POST, 'name'); $price = filter_input(INPUT_POST, 'price', FILTER_VALIDATE_FLOAT);

// Validate inputs if ($category_id == null || $category_id == false || $code == null || $name == null || $price == null || $price == false) { $error = "Invalid product data. Check all fields and try again."; include('error.php'); } else { require_once('database.php');

// Add the product to the database  
$query = 'UPDATE products 
            SET category_id = :category_id , code = :code, name = :name, price = :price
            where(:category_id, :code, :name, :price)';

$statement = $db->prepare($query);
$statement->bindValue(':category_id', $category_id);
$statement->bindValue(':code', $code);
$statement->bindValue(':name', $name);
$statement->bindValue(':price', $price);
$statement->execute();
$statement->closeCursor();

// Display the Product List page
include('index.php');

} ?>

"

Welcome to the Treehouse Community

Looking to learn something new?

angel angel

angel angel

Adding a EDIT button to a php app?

Ashish Singh

Ashish Singh