I have created a form on html coding and im really blank on how to get the input data in a data base bellow is the program i coded now i want its input from the website to be stored in a excel file

Question

<section id="contact" >

<div class="container">

<div class="row">

<div class="sec-title text-center wow animated fadeInDown">

<h2>Contact</h2>

<p>Leave a Message</p>

</div>

<div class="col-md-7 contact-form wow animated fadeInLeft">

<form action="#" method="post">

<div class="input-field">

<input type="text" name="name" class="form-control" placeholder="Your Name...">

</div>

<div class="input-field">

<input type="email" name="email" class="form-control" placeholder="Your Email...">

</div>

<div class="input-field">

<input type="text" name="subject" class="form-control" placeholder="Subject...">

</div>

<div class="input-field">

<textarea name="message" class="form-control" placeholder="Messages..."></textarea>

</div>

<button type="submit" id="submit" class="btn btn-blue btn-effect">Send</button>

</form>

</div>

<div class="col-md-5 wow animated fadeInRight">

<address class="contact-details">

<h3>Contact Us</h3>

<p><i class="fa fa-pencil"></i>company name<span>address,</span> <span>more address.</span></p><br>

<p><i class="fa fa-phone"></i>phone number</p>

<p><i class="fa fa-envelope"></i>email id</p>

</address>

</div>

</div>

</div>

</section>

Answer 1

In your <form action="#" method="post"> replace the # with the url of a form processing end point that reads the POST data and dose CRUD actions with it.

Research PHP as a starting point to process your POST data.(There are many other scripting and programming languares you can use but PHP is a good starting point.)

For example your # could be replaced with "processform.php" on your server and processform.php will process your forms data.

Many examples exist to help you construct your php form processing functions.

Once your form processor has captuered the POST data then you must connect php to a DataBase like MySql. because it is the DB that saves your form POST data so it can be read back into other parts of your php programs and passed to your HTML for rendering to the user.

Answer 2

Web pages can create forms, but you will need to post the data to an endpoint that can persist the form data to a database. Excel is not able to save this data, so you will want to leverage a middleware app to process the form data, and a sql database(MySQL, postgreslql, MSSQL, etc.) to store the data for later retrieval.