Programs in PHP
19. Program to Insert records into the table in Database.<?php $conn = mysqli_connect('servername','username','password','databasename'); if(!$conn) { die('Connection failed!'.mysqli_error($conn)); } $sql = "INSERT INTO tablename('sno','name','pwd') VALUES('101','Surya','surya123')"; if(mysqli_query($conn,$sql)) { echo "Record Inserted"; } else { echo mysql_error(); } ?> ------------------------------------------------------------- Note: When we using XAMPP or WAMP, servername = localhost, username = root, password is empty.
Father of PHP