In PHP, data can be inserted into a MySQL database using an Before proceeding with this example, the following basic requirements are needed:<\/p>\n\n\n\n Create a basic HTML form to enter the product category, product name, and product price.<\/p>\n\n\n\n Create the PHP database connection and custom insert function.<\/p>\n\n\n\n Create a table named If you following above step you get final code like this.<\/p>\n\n\n\n The HTML form collects the category, product name, and product price.<\/p>\n\n\n\n When the Save<\/strong> button is clicked, the submitted values are stored in the The data is then inserted into the In this example, a custom PHP function is used to insert product details into a MySQL database. The function accepts the table name and data as parameters, allowing the insert query to be created using the provided values.<\/p>\n\n\n\n The The example uses the The category ID, product name, and product price are inserted into the table.<\/p>\n\n\n\n The function is called using:<\/p>\n\n\n\n <\/p>\n\n\n\n How to Install Apache, PHP, and MySQL on Red Hat 7?<\/a><\/p>\n\n\n\nINSERT<\/code> query. When database operations are used repeatedly, creating a custom function can make the code easier to manage and reuse. This article explains how to create a custom PHP function for inserting data into a MySQL table and how to use it with an HTML form to insert product details.<\/p>\n\n\n\nPrerequisites<\/h2>\n\n\n\n
\n
Implementation<\/h2>\n\n\n\n
Step 1: Create a Basic HTML Page with Form<\/h3>\n\n\n\n
<form method=\"POST\" action=\"\" id=\"addproduct-form\">\n\n<label for=\"hd-desc\">Select Category<\/label>\n\n<select name=\"cat_id\" id=\"cat-id\">\n<option value=\"\" selected=\"\">Select Category<\/option>\n<option value=\"8\">mobile<\/option>\n<option value=\"9\">Tv<\/option>\n<option value=\"10\">XYZ<\/option>\n<option value=\"11\">mobile2<\/option>\n<option value=\"12\">Tv2<\/option>\n<option value=\"13\">Tv 3<\/option>\n<\/select>\n\n<label for=\"hd-desc\">Product Name<\/label>\n\n<input id=\"product-name\" name=\"product_name\" placeholder=\"Enter Category\" value=\"\" type=\"text\">\n\n<label for=\"hd-desc\">Product Price<\/label>\n\n<input id=\"product-price\" name=\"product_price\" placeholder=\"Enter Price\" value=\"\" type=\"text\">\n\n<!-- <input type=\"submit\" name=\"save\"> -->\n\n<button type=\"submit\" name=\"save\" class=\"btn btn-success\" value=\"save\" id=\"add-save\">Save<\/button>\n\n<\/form><\/pre>\n\n\n\n
Step 2: Create PHP Connection String, Query Insert Function and Form Submit Action<\/h3>\n\n\n\n
<?php\n\ndefine(\"DB_HOST\", \"localhost\");\n\ndefine(\"DB_USER\", \"root\");\n\ndefine(\"DB_PSSWD\", \"\");\n\ndefine(\"DB_NAME\", \"test\");\n\n$conn = mysql_connect(DB_HOST,DB_USER,DB_PSSWD);\n\nmysql_select_db(DB_NAME, $conn);\n\nfunction qry_insert($table, $data)\n{\n $fields = array_keys($data); \n\n $values = array_map(\"mysql_real_escape_string\", array_values($data));\n\n return mysql_query(\"INSERT INTO $table(\".implode(\",\", $fields).\") VALUES ('\".implode(\"','\", $values).\"');\") or die(mysql_error());\n}\n\nif(isset($_POST['save']))\n{\n $data = array(\n 'cat_id' => $_POST['cat_id'],\n 'pname' => $_POST['product_name'],\n 'price' => $_POST['product_price']\n );\n\n $qry = qry_insert('product',$data);\n}\n\n?><\/pre>\n\n\n\nStep 3: Create the Product Table<\/h3>\n\n\n\n
product<\/code> using the following code.<\/p>\n\n\n\nCREATE TABLE `product` (\n `pid` int(11) NOT NULL AUTO_INCREMENT,\n `pname` varchar(100) NOT NULL,\n `price` int(11) NOT NULL,\n `pimg` varchar(100) NOT NULL,\n `cat_id` int(11) NOT NULL,\n PRIMARY KEY (`pid`)\n) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1<\/pre>\n\n\n\n
Step 4: Create the Final Code<\/h3>\n\n\n\n
<?php\n\ndefine(\"DB_HOST\", \"localhost\");\n\ndefine(\"DB_USER\", \"root\");\n\ndefine(\"DB_PSSWD\", \"\");\n\ndefine(\"DB_NAME\", \"karthik\");\n\n$conn = mysql_connect(DB_HOST,DB_USER,DB_PSSWD);\n\nmysql_select_db(DB_NAME, $conn);\n\nfunction qry_insert($table, $data)\n{\n $fields = array_keys($data); \n\n $values = array_map(\"mysql_real_escape_string\", array_values($data));\n\n return mysql_query(\"INSERT INTO $table(\".implode(\",\", $fields).\") VALUES ('\".implode(\"','\", $values).\"');\") or die(mysql_error());\n}\n\nif(isset($_POST['save']))\n{\n $data = array(\n 'cat_id' => $_POST['cat_id'],\n 'pname' => $_POST['product_name'],\n 'price' => $_POST['product_price']\n );\n\n $qry = qry_insert('product',$data);\n}\n\n?><\/pre>\n\n\n\nHTML<\/h3>\n\n\n\n
<!DOCTYPE html>\n\n<html>\n\n<head>\n\n<title>Insert function<\/title>\n\n<\/head>\n\n<body>\n\n<form method=\"POST\" action=\"\" id=\"addproduct-form\">\n\n<label for=\"hd-desc\">Select Category<\/label>\n\n<select name=\"cat_id\" id=\"cat-id\">\n\n<option value=\"\" selected=\"\">Select Category<\/option>\n\n<option value=\"8\">mobile<\/option>\n\n<option value=\"9\">Tv<\/option>\n\n<option value=\"10\">XYZ<\/option>\n\n<option value=\"11\">mobile2<\/option>\n\n<option value=\"12\">Tv2<\/option>\n\n<option value=\"13\">Tv 3<\/option>\n\n<\/select>\n\n<label for=\"hd-desc\">Product Name<\/label>\n\n<input id=\"product-name\" name=\"product_name\" placeholder=\"Enter Category\" value=\"\" type=\"text\">\n\n<label for=\"hd-desc\">Product Price<\/label>\n\n<input id=\"product-price\" name=\"product_price\" placeholder=\"Enter Price\" value=\"\" type=\"text\">\n\n<!-- <input type=\"submit\" name=\"save\"> -->\n\n<button type=\"submit\" name=\"save\" class=\"btn btn-success\" value=\"save\" id=\"add-save\">Save<\/button>\n\n<\/form>\n\n<\/body>\n\n<\/html><\/pre>\n\n\n\n
How It Works<\/h2>\n\n\n\n
$data<\/code> array. The qry_insert()<\/code> function receives the table name and data array and creates the INSERT<\/code> query.<\/p>\n\n\n\nproduct<\/code> table using mysql_query()<\/code>.<\/p>\n\n\n\nConclusion<\/h2>\n\n\n\n
Frequently Asked Questions<\/h2>\n\n\n\n
What is the purpose of the
qry_insert()<\/code> function?<\/h3>\n\n\n\nqry_insert()<\/code> function is a custom function used to insert data into a database table.<\/p>\n\n\n\nWhich table is used in this example?<\/h3>\n\n\n\n
product<\/code> table.<\/p>\n\n\n\nWhat product details are inserted?<\/h3>\n\n\n\n
How is the insert function called?<\/h3>\n\n\n\n
$qry = qry_insert('product',$data);<\/pre>\n\n\n\nRelated Articles<\/h2>\n\n\n\n