Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Can you help me understand why the $type shows an error - Error: Type must be a valid integer preocess_form.php

Can you help me understand why the $type shows an error - Error: Type must be a valid integer preocess_form.php

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Can you help me understand why the $type shows an error - Error: Type must be a valid integer

preocess_form.php

<?php
 
$db_host = "localhost";
$db_username = "root";
$db_pass = "";
$db_name = "sc_test";
 
$con = mysqli_connect($db_host, $db_username, $db_pass) or die("Could not connect to MySQL");
mysqli_select_db($con, $db_name) or die("Could not select database");
 
if ($_SERVER["REQUEST_METHOD"] == "POST") {
// Retrieve form data
$sku = $_POST['sku'] ?? '';
$name = $_POST['name'] ?? '';
$price = $_POST['price'] ?? '';
$type = $_POST['type'] ?? '';
$attribute = $_POST['attribute'] ?? '';
 
// Validate the type value
if (!is_numeric($type)) {
die("Error: Type must be a valid integer");
}
$type = intval($type);
 
// Perform the database query to insert the data
$query = "INSERT INTO products (sku, name, price, type, attribute) VALUES ('$sku', '$name', '$price', '$type', '$attribute')";
mysqli_query($con, $query) or die("Query failed: " . mysqli_error($con));
 
// Redirect to the product list page
header("Location: index.php");
exit();
}
 
?>

 

 

phpMyAdmin SQL Dump version 5.2.0 https://www.phpmyadmin.net/ Host: localhost Generation Time: May 08, 2023 at 11:07 AM Server version: 10.4.24-MariaDB PHP Version: 7.4.29 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*140101 SET /*140101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*140101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*140101 SET NAMES utf8mb4 */; Database: sc_test' Table structure for table products" CREATE TABLE `products ( *sku varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, "price float NOT NULL, `type` int(11) NOT NULL, "attribute` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL > ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; COMMIT; /*140101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*140101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*140101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Transcribed Image Text:phpMyAdmin SQL Dump version 5.2.0 https://www.phpmyadmin.net/ Host: localhost Generation Time: May 08, 2023 at 11:07 AM Server version: 10.4.24-MariaDB PHP Version: 7.4.29 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*140101 SET /*140101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*140101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*140101 SET NAMES utf8mb4 */; Database: sc_test' Table structure for table products" CREATE TABLE `products ( *sku varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, "price float NOT NULL, `type` int(11) NOT NULL, "attribute` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL > ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; COMMIT; /*140101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*140101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*140101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Mathematical functions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS