how to insert html table data into database using php

Solutions on MaxInterview for how to insert html table data into database using php by the best coders in the world

showing results for - "how to insert html table data into database using php"

19 Nov 2018

1<!DOCTYPE html>
2<html>
3<head>
4  <title>Add Records in Database</title>
5</head>
6<body>
7
8<?php
9include "dbConn.php"; // Using database connection file here
10
11if(isset($_POST['submit']))
12{		
13    $fullname = $_POST['fullname'];
14    $age = $_POST['age'];
15
16    $insert = mysqli_query($db,"INSERT INTO `tblemp`(`fullname`, `age`) VALUES ('$fullname','$age')");
17
18    if(!$insert)
19    {
20        echo mysqli_error();
21    }
22    else
23    {
24        echo "Records added successfully.";
25    }
26}
27
28mysqli_close($db); // Close connection
29?>
30
31<h3>Fill the Form</h3>
32
33<form method="POST">
34  Full Name : <input type="text" name="fullname" placeholder="Enter Full Name" Required>
35  <br/>
36  Age : <input type="text" name="age" placeholder="Enter Age" Required>
37  <br/>
38  <input type="submit" name="submit" value="Submit">
39</form>
40
41</body>
42</html>
43

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 create a table with php in html how to start on row 2 spreadsheet inserting to database using php insert php code php insert and display data php mysql insert variables into database how to display data from mysql database into html table using php php insert array into mysql insert javascript in php how to insert json data into mysql using php

queries leading to this page

insert data into database in php automatically how to put data from database to table in php html table data insert to mysql php how to insert data to dbeaver table from php form php insert data into html table php add data to database php php insert html into mysql php code for inserting data from datatble into database how to add data to mysql table with php how to add data to database in php insert html table data in php how to insert a new sql table in php code with mysql databases how to insert a data in database using php how to insert data into database using php function how to insert data into database using php php code to insert data into database insert data into sql server table using php insert html into php database how to insert html table data into database using php add to html table php insert data in database using php and html how do i insert html table data into mysql php how to insert data into mysql database table using php how to insert data in dbeaver in php php script to insert data in the database php script to insert data and show table script 5 creating tables 2c inserting data in to table 2c inserting data through html forms in php ppts php add to html table html php insert data into mysql 5 creating tables 2c inserting data in to table 2c inserting data through html forms in php ppt html table data insert to mysql database php how to insert datatable values into database in php how to insert data to database in php create table and insert data sql php insert datatable data into database using php insert data into html table using jquery php php insert a new record in a database table through a web form insert php database into html table how to insert html table data into database using php