The goal is to code php files so I have the ability to perform CRUD functions on categories.
I don't know what I'm doing wrong and why I'm getting an undefined index. Check the image below!
Undefined index: category_name in C:\wamp\www\Inventory separate\updateCategory.php on line 21
Line 21
$category_name = $_POST['category_name'];
updateCategory.php
require 'database.php';
$id = null;
if ( !empty($_GET['id'])) {
$id = $_REQUEST['id'];
}
if ( null==$id ) {
header("Location: index.php");
}
if ( !empty($_POST)) {
// keep track validation errors
$category_nameError = null;
$category_category_idError = null;
// keep track post values
$category_category_id = $_POST['id'];
$category_name = $_POST['category_name'];
// validate input
$valid = true;
if (empty($category_name)) {
$category_nameError = 'Please enter Category name';
$valid = false;
}
if (empty($category_category_id)) {
$category_idError = 'Please enter Category id';
$valid = false;
}
// update data
if ($valid) {
$pdo = Database::connect();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "UPDATE category set id = ?, category_name = ? WHERE id = ?";
$q = $pdo->prepare($sql);
$q->execute(array($category_category_id,$category_name,$id));
Database::disconnect();
header("Location: index.php");
}
} else {
$pdo = Database::connect();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "SELECT * FROM category where id = ?";
$q = $pdo->prepare($sql);
$q->execute(array($id));
$data = $q->fetch(PDO::FETCH_ASSOC);
$category_category_id = $data['id'];
$category_name = $data['category_name'];
Database::disconnect();
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<link href="css/bootstrap.min.css" rel="stylesheet">
http://js/bootstrap.min.js
</head>
<body>
Update a Category
<form class="form-horizontal" action="updateCategory.php?id=<?php echo $id?>" method="post">
">
Category Id
">
</div>
">
Category Name
">
</div>
</form>
</div>
</div> <!-- /container -->
</body>
</html>
index.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<link href="css/bootstrap.min.css" rel="stylesheet">
http://js/bootstrap.min.js
</head>
<body>
Product Menu
Id
CategoryId
Brand
Name
Barcode
Price
query($sql) as $row) {
echo '';
echo ''. $row['id'] . ' ';
echo ''. $row['category_id'] . ' ';
echo ''. $row['brand'] . ' ';
echo ''. $row['name'] . ' ';
echo ''. $row['barcode'] . ' ';
echo ''. $row['price'] . ' ';
echo '';
echo 'Read';
echo ' ';
echo 'Update';
echo ' ';
echo 'Delete';
echo ' ';
echo ' ';
}
?>
Category Menu
Category Id
Category Name
query($sql) as $row) {
echo '';
echo ''. $row['id'] . ' ';
echo ''. $row['category_name'] . ' ';
echo '';
echo 'Read';
echo ' ';
echo 'Update';
echo ' ';
echo 'Delete';
echo ' ';
echo ' ';
}
Database::disconnect();
?>
</div>
</body>
</html>
<!--
PHP CRUD Grid
CategoryId
Catengory Name
$sql2 = 'SELECT * FROM category ORDER BY id DESC';
foreach ($pdo->query($sql2) as $row) {
echo '';
echo ''. $row['id'] . ' ';
echo ''. $row['category_name'] . ' ';
echo '';
echo 'Read';
echo ' ';
echo 'Update';
echo ' ';
echo 'Delete';
echo ' ';
echo ' ';
}
Database::disconnect();
?>
</tbody>
</table> -->
0 comments:
Post a Comment