Inserting data to the table using php

Once the table is created, the next job is to insert data into the table. For this ,we use the INSERT INTO command. The program below describes how to insert data to the table in the database.

<?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 the table
$sql="INSERT INTO firsttable VALUES(1,'jino');";
if($conn->query($sql)===TRUE)
{
    $last_id=$conn->insert_id;
    echo "new record inserted sucessfully created<br>last inserted row is:".$last_id;
}
else
{
    echo "error :".$conn->error;
}
$conn->close();
?>

Output:

new record inserted sucessfully


The num:1 and user:jino that we entered are stored in the table in the database. You can see how to view the entered data from the database directly in the next page.

⇐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