Sign in Get Started

php insert and display data

Joe Dark 
<?php
//including the database connection file
include("config.php");
if(isset($_POST['Submit'])) {    
$pname = $_POST['pname'];
$pcode = $_POST['pcode'];
$pprice = $_POST['pprice'];
        
// checking empty fields
if(empty($pname) || empty($pcode) || empty($pprice)) {                
if(empty($pname)) {
echo "<font color="red">Product Name field is empty.</font><br>";
}
if(empty($pcode)) {
echo "<font color="red">Product Code field is empty.</font><br>";
}
if(empty($pprice)) {
echo "<font color="red">Product Price  field is empty.</font><br>";
}
//link to the previous page
 echo "<br><a href="javascript:self.history.back();">Go Back</a>";
 } else { 
// if all the fields are filled (not empty)             
//insert data to database
$result = mysqli_query($cser, "INSERT INTO crud2(pname,pcode,pprice) VALUES('$pname','$pcode','$pprice')");
        
//display success message
echo "<font color="green">Data added successfully.</font>";
        
}
}
?>
View another examples Add Own solution
Log in, to leave a comment

3.4
5
Cersei 100 points 

                                    &lt;!DOCTYPE html&gt;
&lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;
&lt;head&gt;
&lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=utf-8&quot; /&gt;
&lt;title&gt;Contact Form - PHP/MySQL Demo Code&lt;/title&gt;
&lt;/head&gt;

&lt;body&gt;
&lt;fieldset&gt;
&lt;legend&gt;Contact Form&lt;/legend&gt;
&lt;form name=&quot;frmContact&quot; method=&quot;post&quot; action=&quot;contact.php&quot;&gt;
&lt;p&gt;
&lt;label for=&quot;Name&quot;&gt;Name &lt;/label&gt;
&lt;input type=&quot;text&quot; name=&quot;txtName&quot; id=&quot;txtName&quot;&gt;
&lt;/p&gt;
&lt;p&gt;
&lt;label for=&quot;email&quot;&gt;Email&lt;/label&gt;
&lt;input type=&quot;text&quot; name=&quot;txtEmail&quot; id=&quot;txtEmail&quot;&gt;
&lt;/p&gt;
&lt;p&gt;
&lt;label for=&quot;phone&quot;&gt;Phone&lt;/label&gt;
&lt;input type=&quot;text&quot; name=&quot;txtPhone&quot; id=&quot;txtPhone&quot;&gt;
&lt;/p&gt;
&lt;p&gt;
&lt;label for=&quot;message&quot;&gt;Message&lt;/label&gt;
&lt;textarea name=&quot;txtMessage&quot; id=&quot;txtMessage&quot;&gt;&lt;/textarea&gt;
&lt;/p&gt;
&lt;p&gt;&nbsp;&lt;/p&gt;
&lt;p&gt;
&lt;input type=&quot;submit&quot; name=&quot;Submit&quot; id=&quot;Submit&quot; value=&quot;Submit&quot;&gt;
&lt;/p&gt;
&lt;/form&gt;
&lt;/fieldset&gt;
&lt;/body&gt;
&lt;/html&gt;

3.4 (5 Votes)
0
Are there any code examples left?
Find Add Code snippet
New code examples in category PHP
SHOW MORE
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
how to print my php insert statement how to insert data in table in phpmyadmin how to insert data in phpmyadmin using php form data insert ini php oop phpmyadmin insert data with php insert sql data to phpmyadmin php how to insert data from exces to phpmyadmin insert data in table in sql using php phpmyadmin sql insert data demo insert data into table phpmyadmin how to insert data into database using phpmyadmin insert data table in php how to get data in html table from phpmyadmin insert data in db using php how to insert data in table in sql using php how to add a new data in phpmyadmin insert the result value in database using php insert data into phpmyadmin using php insert data in database using php insert data to db php how to insert data in mysql phpmyadmin using sql how to insert data in mysql phpmyadmin how to insert data in sql using phpmyadmin insert data in table in php php show insert data how insert data in database using php insert data in database by php insert data into table using php add data to my phpmyadmin insert and show data in php insert data in sql php insert command to insert data in phpmyadmin how to add data into database phpmyadmin how to insert data to phpmyadmin from wordpress php add sql data in phpmyadmin insert data in sql with php get from data and insert into database php data insert into database using php phpmyadmin insert data using sql php insert data insert data into table php how to insert value and show in sql php insert data php how to add data to phpmyadmin table php code to insert data into database how to insert data in phpmyadmin how to insert data in php add data in phpmyadmin using sql how to insert data in phpmyadmin table using php php insert in database html form mysql php php inset into db insert query php php insert and display data Database_Insert function php insert database function php php add values in a databse send data to php database php mysql insert row create php form insert into mysql insert statement for php php insert mysql exemple insertquery in php how to insert data in database in php save data in database using php php script for data query insert php mysql insert into insert mysql ' in php insert values php db php mysqli insert values insert to db php php insert mysqli insert data into php without knowing table php form to mysql how to insert data in mysql using php post mysql how to insert in php table insert in core php how to insert to php how to insert into mysql php insert() php how to echo data and insert in mysqli using php insert query in core php how instert data using mysqli php function insert data into database php insert' php code insert into mysql database insert to table sql php asend datta to mysql how to insert data using php insert query insert get value php how to add php to a sql database ?insert php php squl insert databas php sql isnert into how to add to a sql database in php insert record from table using php php form using mysql insert my sql php php mysql connect insert add data to database from website php php script for inserting data into database insert mysqli example php insert into insert data in php insert into mysql php into table insert data using function in php insert into php sql insert data inside tablephp pdo php file insert into mysql insert into mysql using php php insert mysql how to put data in database using php mysql insert query in php how to insert data in php mysql php form with database php code to insert data into mysql insert database insert data into db using php php mysqli_query insert insert query in ph[p mysql insert into php insert values mysql html sql insert query php input data to database php how to execute insert query in mysql using php in html page put data in table from database php insert into database table php insert sql from form insert query in php mysqli insert php sql insert php html form php mysql insert mysqli hoe send data to db using php insert query in mysql php php mysql function insert into table insert form data in database using php simple insert user php mysql php insert example php insert sql php insert where php insert from a function how to write sql insert query in php php insert data into mysql php mysql insert php mysql insert data insert php on ' php query insert into mysql php insert into mysql insert data phpmysql insert into table in mysql using php how to insert string data in php mysql php while inserting table in sql connection in php mysqli insert example php code to insert employee data in mysqli by pdo php post value add to database php send data to database post to db php php mysql connection insert query php sample form to insert data on the table php insert data from form to mysql database php script to add data to mysql database insert into sql php add value to table with php query php insert how to add an input in mysql php insert data in php database table data insert in php insert set mysql php7 insert query mysql php php post mysql insert data using php in mysql inserting records with php how to store data in mysql insert in php mysqli insert to database php form how to add in sql query in php mysql insert in pdo php sql insertion get mysql using \ on save INSERT INTO WITH PHP php form mysql example html form php mysql insert sample project insert into database mysql php insert data html to mysql database insert data html to mysql data into database mysql from html php insert into php0 mysql data save insert html to mysql insert into sql from php post syntax for mysql insertion emails using php syntax for mysql insertion using php insert data into database inphp insert data in table using php 7. Create a HTML Form and Insert Data Into The Database Using PHP how to insert data in table in sql usin php insert value to database php php save data to database insert into database from form php insert item in table using php mysql simple html for inserting data into mysql database php insert into database with sql php code to save record in to db store the data inserted by the user php form database php insert into mysql 'n insert mysql php form store data in database using php inserting into mysql php insert to database php insert mysql php html form insert php html mysql php insert into table from form insert via php pdo php basic save to .db from php save to sql from php Create a HTML Form and Insert Data Into The Database Using PHP html form to insert data into database php php @insert get inserting values in sql core php mysqli insert into inserting data in sql core php php sql insert query values %s php sql insert query perform insert data php insert w3schools php insert to php php mysql add statmewnt insert data to mysql using php how to save data in mysql database using php Insert mysql php query mysql insert in php create a row mysql in php $mysqli insert insert into database form php how to execute an insert into in php sql php insert query php mysql add add data to database php mysql how to insert data in sql using php how to add data to database in php mysql insert into query in php function php insert into database where user php insert into database where insert function in php php how to add stuff to a database connection error insert into mysql php php msql insert in php syntax for writing insert into php function to insert data into mysql php mysqli post php mysql insert query php mysql write to database how to get input value in php and insert in mysql how to insert form into db using php php get results from sql insert insert into php perform sinple mysql insert script in php insert value into table sql php insert into mysql from php form $mysqli-&gt;query(&quot;INSERT INTO insert into sql in php php add to sql insert data into database using php insert data from php to mysql php insert form add item to sql php php insert with msqli mysqli insert form data insert value in table in php using sqli insert into db php op how to insert data into table using php how to insert data in sql php insert created at into databse php sqli insert php mysql inset in php inserting into db php form to database php how to run insert query in php how to add row to table sql with php php query to insert into database insert data into php inster into php php7 insert into mysql function to insert data in mysql php insert in php 2020 how to add data using table in php how to insert data into mysql database in php insert data in phph php instert into database insert into function php php form mysql how to insert into a table sql with php data insert in core php data insert in php mysqli_connect insert into table slq insert php inserting into html PHP php insert query command php insert data into database php insert data from database mysqli insert into query example insert into database from html form insert data from html form to mysql database php insert quesry in PHP insert form in php post sql to database php mysql php insert into write to database with php php table insert add to table php insert to db using php insert using php save data mysql php how to insert query in php php how to add a new entry to a table php mysql send data send php to mysql mysql insert using php insert a form into a database php how to insert data to database from a form php insert query phpmyadmin sql inset on php php insert to mysql from php form php sql inserst insert data into database php how to insert php value into mysqli query php data insert insert in php mysql php content to database msql insert in php php insert query data into mysql php submit sql query insert data from a form into phphmysql save data in mysql using php add data to mysql table using php mysql connect and insert php insert into msyql how to insert in mysql i php insete data to database php input data form php mysql insert data in mysql php insert data to mysql database using php add data to database php insert row dengan php mysql insert tow dengan php mysql insert row php mysql insert data into table sql with php php insert into sql data sql insert query in php insert data sql php dokan php mysql insert mysqli javascript php sql enter data into table get and post record to database php adding data to user table in php how to use insert query in php insert sql using php fetch() insert sql using php insert into database with php html form php mysql insert exernally php sql add row mysqli_query insert save in database php stored into database php save form data php mysql php mysql insert into table how to add a number in php database the brower was how to insert form data in database using php mysqli write to database Insert query msqli insert into phpmyadmin php submit the form data in mqsql table in php php coe to create and insert data in table create and insert data in database usibng php code create table in databse using php and insert values create a databse in php using form insert the data into it how to insert php form data into mysql database how to add data in row in php how to put data in an mysql database using php insert data from usong php insert data in php using mysqli how to insert html syntax to mysql insert a record in php insert into php in html query insert into php how to cheak for inserted user in php in database how to insert data from user in php how to insert data into phpmyadmin using php
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with
Not registered?
Sign up takes less than a minute

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source