HTMLify

Insert-Data-In-Table.php
Views: 144 | Author: djdj
<?php

    //for connection to database
    $servername = "localhost";
    $username = "root";
    $password = "";
    $database = "sabkacode"; //already created db

    //create connection
    $conn = mysqli_connect($servername, $username, $password, $database);

    if(!$conn){
        die('Connection fail!!'.mysqli_connect_error());
    }
    else{
    echo "Connection was successful\n";
    }

    //create database
    $sql = "CREATE DATABASE sabkacode1";
    $result = mysqli_query($conn, $sql);

    //Check for the db create success or not
    if($result){
        echo "\nThe db was create successfully\n";
    }else{
        echo "The db was not create successfully becoz of this error " .mysqli_error($conn);
    }

    //create table
    $sql1 = "CREATE TABLE `user` (`sno` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(10) NOT NULL, `mobile` VARCHAR(10) NOT NULL, PRIMARY KEY(`sno`))";
    $result1 = mysqli_query($conn, $sql1);
    
      //Check for the table create success or not
      if($result1){
        echo "\nThe table was create successfully\n";
    }else{
        echo "The table was not create successfully becoz of this error " .mysqli_error($conn);
    }

    //Insert data into the table
    $sql2 = "INSERT INTO `user` (`name`, `mobile`) VALUES ('Ram', '8532824533')";
    $result2 = mysqli_query($conn, $sql2);

    ////Check for the insert data success or not
    if($result2){
        echo "\nInsert was  successfully\n";
    }else{
        echo "Insert was not  successfully becoz of this error " .mysqli_error($conn);
    }




?>

Comments