php insert and display data

Solutions on MaxInterview for php insert and display data by the best coders in the world

showing results for - "php insert and display data"

02 Mar 2020

1<?php
2//including the database connection file
3include("config.php");
4if(isset($_POST['Submit'])) {    
5$pname = $_POST['pname'];
6$pcode = $_POST['pcode'];
7$pprice = $_POST['pprice'];
8        
9// checking empty fields
10if(empty($pname) || empty($pcode) || empty($pprice)) {                
11if(empty($pname)) {
12echo "<font color="red">Product Name field is empty.</font><br>";
13}
14if(empty($pcode)) {
15echo "<font color="red">Product Code field is empty.</font><br>";
16}
17if(empty($pprice)) {
18echo "<font color="red">Product Price  field is empty.</font><br>";
19}
20//link to the previous page
21 echo "<br><a href="javascript:self.history.back();">Go Back</a>";
22 } else { 
23// if all the fields are filled (not empty)             
24//insert data to database
25$result = mysqli_query($cser, "INSERT INTO crud2(pname,pcode,pprice) VALUES('$pname','$pcode','$pprice')");
26        
27//display success message
28echo "<font color="green">Data added successfully.</font>";
29        
30}
31}
32?>
33

source

similar questions

insert form value into database php php insert array into mysql table php pdo insert data to sql ajax request for inserting php data to db php insert a form data into 2 tables how to start on row 2 spreadsheet inserting to database using php insert php code how to insert html table data into database using php php mysql insert variables into database php insert array into mysql insert javascript in php how to insert json data into mysql using php php insert in array allert in php

queries leading to this page

php insert data into table insert and show data in php php insert into database and get data insert data using insert value in php get data insert php how to insert data in php how to inserrt data in php insert data into table php how to insert data in table in php php insert data query how to insert data into sql and print data in php how to insert data in table in sql using php php code for inserting data from datatble into database insert data in db using php insert data in sql using php php data insert get from data and insert into database php insert data into table sql php data insert query in php insert data into sql using php insert value in db from php how to insert value and show in sql php how to print my php insert statement insert data php insert data into table using php insert data in database using php get and insert result php php show insert data php return insert data php inser data how to insert data in sql using php insert data in sql php data insert into database using php table data insert using php data insert ini php oop php code to insert data into database insert sql data in php how to insert data using php insert data with database using php insert data in database by php insrt data into the database in php insert data query in sql php php script to insert data php insert data then return the row insterted insert data table in php insert data into database using php insert data sql with php insert data into sql table using php data insert in table php how to insert data into table in sql using php php insert data how insert data in database using php insert and view data in php insert data in sql with php insert data to db php php insert and display data php inset into db insert data in table in sql using php isert table into table php sercure way to insert php data insert data in php insert data into database php insert the result value in database using php insert data in table in php php insert and display data