HTML form, add the data into it and submit it to the database by connecting it to MySQL database using PHP.

<?php
// database connection code
// $con = mysqli_connect('localhost', 'database_user', 'database_password','database');

$con = mysqli_connect('localhost', 'root', '','db_connect');

// get the post records
$txtName = $_POST['txtName'];
$txtEmail = $_POST['txtEmail'];
$txtPhone = $_POST['txtPhone'];
$txtMessage = $_POST['txtMessage'];

// database insert SQL code
$sql = "INSERT INTO `tbl_contact` (`Id`, `fldName`, `fldEmail`, `fldPhone`, `fldMessage`) VALUES ('0', '$txtName', '$txtEmail', '$txtPhone', '$txtMessage')";

// insert in database 
$rs = mysqli_query($con, $sql);

if($rs)
{
	echo "Contact Records Inserted";
}

?>

View another examples Add Own solution

3.8

Justin D 70 points

                                    &lt;?php
//Step1
 $db = mysqli_connect('localhost','username','password','database_name')
 or die('Error connecting to MySQL server.');
?&gt;

&lt;html&gt;
 &lt;head&gt;
 &lt;/head&gt;
 &lt;body&gt;
 &lt;h1&gt;PHP connect to MySQL&lt;/h1&gt;
&lt;/body&gt;
&lt;/html&gt;

Thank you! 5

3.8 (5 Votes)

Marc van Dongen 100 points

                                    $con = mysqli_connect('localhost', 'root', '',&rsquo;db_connect&rsquo;);
The &ldquo;db_connect&rdquo; is our database name that we created before.
After connection database you need to take post variable from the form. See the below code
$txtName = $_POST['txtName'];
$txtEmail = $_POST['txtEmail'];
$txtPhone = $_POST['txtPhone'];
$txtMessage = $_POST['txtMessage'];

Thank you! 0

4.3

Koray Tugay 80 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;

Thank you! 10

4.3 (10 Votes)

Are there any code examples left?

Find Add Code snippet

New code examples in category PHP

PHP 2022-03-27 22:40:03 index:of curiosa 2019 mp4
PHP 2022-03-27 22:35:13 Dijkstra’s algorithm php
PHP 2022-03-27 22:35:12 get_declared_classes
PHP 2022-03-27 22:30:23 php move index of a value to first position in array
PHP 2022-03-27 22:25:01 wordpress get_date
PHP 2022-03-27 21:30:38 php shorten string with dots
PHP 2022-03-27 21:10:46 php header 500
PHP 2022-03-27 21:05:06 laravel schedule run
PHP 2022-03-27 20:25:12 Get page title, excerpt or content by id
PHP 2022-03-27 20:00:27 php convert date from dd/mm/yyyy to yyyy-mm-dd

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

use mysql in html how to insert data into database through form in php insert into database php through forms how to connect mysql database to html website php on submit insert into database how to connect mysql and html html with mysql write code to insert form data to mysql database in Php html mysql database connection html form insert data into mysql php how to connect html and mysql how to connect mysql to own html websites connect mysql to html and write sql html code for connecting to mysql database connecting html website to mysql; interact with mysql database html php form submit insert to database inserting into the database using submit button in php insert data through a form to mysql database php how to insert data into mysql db using form in php database using mysql with html connect html to mysql php code for inserting data into database from form sql server how to insert data in database in php using html form how to insert data in database using php form Write a program in PHP-MySql to insert data from a form into a database how to access mysql database in html create html form insert data into mysql database using php connecting a html page to a mysql db add things with html form in php data into database using how to do mysql in html connect mysql to website html using html with mysql how to insert form data into a mysql database using php mysql with html how to add data into the database using php form form to add data to sql database php how to add submit button with sql database in php insert into database with a php page form how to link mysql with html how to inserta data into database using php from html form how to insert data into database from html form using php how to connect html with my sql html connect with Mysql database how insert data to database using php and html form add data from html form to a sql database using php connect form to database php can we use MySQL with HTMl connect mysql with html mysql database in html script how to connect mysql to html PHP code for inserting data into database from form add data from php form into your database how to insert into database in php from form php code to insert data into database from form insert html form data into mysql database using php how to connect html to mysql database how to connect mysql database to html web page connecting my html to mySQL how can i connect my html to mysql create an html form and insert data into the database using php how to connect html to xampp database connect html to phpmyadmin php insert user data into file how to link a database to html html and sql connection coonnnect html db how to connect html form with mysql database using php how to connect to mysql database using php in html how to connect php with html php form with mysql database php form to sql database connect mysql to html connect mysql database to html page html connect sql database connect html with database insert form data to mysql using php how to connect html and php and mysql how to connect html form to mysql database how to post table values in mysql submit mysql from html form php submit mysql from html form how to connect html to database with mysql without php php form connect to mysql database html to php connection how to post into mysql $total_value how to connect a html with myssql database adding sql to html how to connect a html file with mysql database insert data from php form to mysql database how to execute insert query in mysql using php in html page without button how to connect mysql with html files insert into database php enter html in mysql php how to send form data to mysql database using php submit button for more information in database php mysql insert form values into database using php how to connect html to database with mysql php insert php insert mysql how to attach database to html php form to post to mysql how to link a mysql to html insert data to table mysql php linking a form to myql database how to insert database by form label in sqli from php html connect to db insert form data in php database downlode code insert set mysql php send text from html form to my sql uing php insert data in db in php from form to database php take in information from html form and store it in database with phpmyadmin How to Connect HTML Form with MySQL Database using sql php form data save mysql php how to insert data from php file to phpmyadmin how to connect html in database php add mysql simple html form database insert table to mysql html how to connect html form to mysql database with php write to a database in php input from html to database mysql submit myslq how to create table in outlook body using php mysql do you need a php website to connect a database html how to connect html to sql database connect html with php html code connect how to store data in data base using php an html how to insert data in table using input fields how to connect the mysql database in html when adding how to connect html to data insert html css to mysql php how to connect html to database html with database connection coding how to connect html website with database php how to connect form connect form to database mysql how to connect the mysql database in html connect to mysql database html how to save data from html form to a database using php how to use mysql with html html mysql connection how to create an html form that stores data in a mysql database using php php form submit to database how to connect database to html website how connect php to html link html page to sql database connect html to mysql database HTML form, add the data into it and submit it to the database by connecting it to MySQL database using PHP. create an html form , add the data into it and submit it to the database by connecting it to MySql database using PHP how to connect html to database with sql server connect php to html how connect html to php how connect input with php in html how to connect form with database using php html connect to database html form with database connection connect php to html form html form with database html connect to mysql connection database from html how toconnect mysql database with html php code to store data in database from html form how to connect an html form with a database how to connect a php with a html how to create a database in html how to connect html file with sql by localhost how to connect sql database to html web page connect sql to html connecting database to html page CONNECTING SQL TO HTML connecting html form to sql database on hosting how to add db file in html connect form to database php form with database connection html login form connect to mysql database html form connect to mysql database html connect database how to connect database to html html form connect to database

HTML form, add the data into it and submit it to the database by connecting it to MySQL database using PHP.

Welcome Back!

Create a Free Account