Inserting multiple records in to table with php

As we inserted , we can insert multiple record into the table. The string concatenation operator(.=) allows to execute multiple sql commands in a single php code.

<?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(4,'febin');";
$sql .="INSERT INTO firsttable VALUES(5,'ashly');";
$sql .="INSERT INTO firsttable VALUES(6,'hyfa');";
$sql .="INSERT INTO firsttable VALUES(7,'tisha');";

if($conn->multi_query($sql)===TRUE)
{
    echo "new records inserted sucessfully";

}
else
{
    echo "error :".$conn->error;
}

$conn->close();
?>


We can insert any number of queries with this Concatenation operator. It concatinates all the sql queries and starts to execute the sql commands together.

Output:
new rows inserted sucessfully


⇐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