Inserting records in database with input box

Not only we can insert the data by directly in with the php INSERT command but also we can insert the data using a form. That is, we can read data from the user in the form of an input box inwhich the user type the data to be inserted in the input box and when they click on the submit button, the data are passed to the database. The following program will show how to insert data to the database with a form.

First we need to create a php file named insform.php

<div>
<form action=save.php method=post>
Num:<input type=text name=numm>
<br>
Name:<input type=text name=namee><br><br>
<INPUT type=submit name=submit>
</form>
</div>

Then we need to create another file named save.php

<?php
$servername="localhost";
$username="root";
$password="";
$dbname="mydb";
//connecting...
$conn=new mysqli($servername,$username,$password,$dbname);
//checking...
if($conn->connect_error)
{
    die("connection failed:".$conn->connect_error);
}
//inserting into ting table

if(isset($_POST["submit"]))
{
    $num=$_POST['numm'];
    $name=$_POST['namee'];
   
$sql="INSERT INTO firsttable (num,user) VALUES('$num','$name')";
if(mysqli_query($conn,$sql))
{
    echo "added sucessfully";
}
else{
    echo "error:".$sql."".msqli_error($conn);
}
mysqli_close($conn);
}
?>


Output





⇐Prev
Next⇒

Comments

Post a Comment

Popular posts from this blog

Node.js Cheat Sheet

Image
To start a new node project, type  C:\Users\jinoy\OneDrive\Desktop\MERN>npm init -y      The basic syntax of calling a function in node.js with express is : const   functionname  = ()  =>  { console . log ( "hello world" ); } functionname (); To call a function after every 5 seconds : setInterval (()  =>  {      console . log ( "hello" ); }, 5000  ); To call a function only once after 4 second : setTimeout (() => { console . log ( "test" ); }, 4000 ); To run a script.js file on terminal, type : C:\Users\jinoy\OneDrive\Desktop\MERN>node script.js  OR C:\Users\jinoy\OneDrive\Desktop\MERN>node script To stop a function that is executing on every interval( time to call function again) : const   interval  =  setInterval (()  =>  {      console . log ( "hello" ); }, 1000  ); setTimeout (() => {      clearInterva...
Read more

Codeigniter ! Simple But Powerful

Image
CodeIgniter is a powerful PHP framework with a very small footprint, built for developers who need a simple and elegant toolkit to create full-featured web applications. It is the second largest php framework for website development (first-Laravel). Due to its simplicity, it is the most used framework ever than laravel. Actually these frameworks are only used for developing large scale website. The important thing about this framework is that it is using MVC principle . A MVC or Model View Control framework has a controller that controls all the pages in the website. There can be any number of controller created in codeigniter. The orginal webpages or the contents are placed in the folder named view .  Note : Don't touch the forder named system because it is the soul of the codeigniter Next ⇒
Read more

Bootstrap ? What is it ?

Image
Have you ever thinked about designing a file that can contain different styles which can be ewhile writing every code. Here is the answer. A Bootstrap is the most popular CSS Framework for developing responsive and mobile-first websites. Bootstrap is a free and open source front enddevelopment framework for the creation of websites and web apps. The Bootstrap framework is built on HTML, CSS, and JavaScript (JS) to facilitate the development of responsive, mobile-first sites and apps. The bootstrap file contain many CSS style , JavaScript and HTML which can be called any number of times during the execution of the program. The bootstrap file is a W3C accepted standard file wich can be used to develop a stylish website easly. Here you can download the bootstrap file directly from my website. It is the now available latest version of the bootstrap file. Version : 4.3.1 Click on the link below to download the bootstrap file. Bootstrap version 4.3.1 If you need ...
Read more