Ajay Khatri

<form method="GET" action="insert.php">
<input type="text" name="eno" placeholder="Enter EMP No"/>
<input type="text" name="ename" placeholder="Enter EMP NAME"/>
<input type="text" name="esal" placeholder="Enter EMP Salary"/>
<input type="submit" name="addButton" value="Add EMP"/>
</form>

</form>

<?php
$eno = $_GET['eno'];
$ename = $_GET['ename'];
$sal = $_GET['esal'];
$conn = new mysqli("localhost", "root", "","atc");

if ($conn->connect_error) {
  echo "Not Connected";
}else{ 
echo "Connected successfully";
}
$sql = "insert into emp (eno,ename,sal) values (".$eno.",'".$ename."',".$sal.")";
if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>

<?php

$eno = $_GET['eno'];

$ename = $_GET['ename'];

$sal = $_GET['esal'];

$conn = new mysqli("localhost", "root", "","atc");

if ($conn->connect_error) {

echo "Not Connected";

}else{

echo "Connected successfully";

}

$sql = "insert into emp (eno,ename,sal) values (".$eno.",'".$ename."',".$sal.")";

if ($conn->query($sql) === TRUE) {

echo "New record created successfully";

} else {

echo "Error: " . $sql . "<br>" . $conn->error;

}

$conn->close();

CREATE TABLE emp (
  eno int(11) NOT NULL,
  ename varchar(50) NOT NULL,
  sal double NOT NULL
)

CREATE TABLE emp (

eno int(11) NOT NULL,

ename varchar(50) NOT NULL,

sal double NOT NULL

)

Category: Uncategorized

PHP and MySql Database Connectivity