Insert Operation Using php mysql with Java Script Validation | Sanwebcorner

Insert Operation Using php mysql with Java Script Validation

Insert Operation Using php mysql with Java Script Validation:

insert operation using php
In this program contains Perfect Insert operation from Html form to My Sql . In this post i am using Javascript for Form Validation.

Using this program you have to learn how to insert the data using php and mysql.

Program Code:.

create database:

CREATE DATABASE 'getinsearch'

create Table:

CREATE TABLE  `getinsearch`.`san` (
`companyname` VARCHAR( 150 ) NOT NULL ,
`address` VARCHAR( 350 ) NOT NULL ,
`contactnumber` INT( 200 ) NOT NULL ,
`mail` VARCHAR( 200 ) NOT NULL ,
`url` VARCHAR( 150 ) NOT NULL ,
`category` VARCHAR( 80 ) NOT NULL
) ENGINE = MYISAM ;


Index.php:


<?php
include("db.php");
if(isset($_POST['submit']))
{
$name=$_POST['company1'];
$address=$_POST['address1'];
$contact=$_POST['contact1'];
$mail=$_POST['email1'];
$url=$_POST['url1'];
$category=$_POST['category1'];
$insert=mysql_query("insert into san(companyname,address,contactnumber,mail,url,category)values('$name','$address','$contact','$mail','$url','$category')");
if($insert)
{
echo "<script>alert('inserted success')</script>";
}
else
{
echo "<script>alert('inserted failure')</script>";
}
}
?>




<script type="text/javascript">
function validation()
{
var company1=document.insertform.company1.value;//document.getElementById('name').value
if(company1=="")
{
alert('Please Enter Company Name');
//document.getElementById('san').innerHTML="please enter the name";
document.insertform.company1.focus();
return false;
}
var address1=document.insertform.address1.value;
if(address1=="")
{
alert('Plese Enter Address');
document.insertform.address1.focus();
return false;
}
var contact1=document.insertform.contact1.value;
if(contact1=="")
{
alert('Please Enter Contact Number');
document.insertform.contact1.focus();
return false;
}
/*<!--else
{
var pra=/^([0-9_\-\.\+\,])$/;
if(pra.test(contact1)==false)
{
alert('Enter Correct Contact Number');
document.insertform.contact1.focus();
return false; 
}
}-->*/
var email1=document.insertform.email1.value;
if(email1=="")
{
alert('Please Enter Email ID');
document.insertform.email1.focus();
return false;
}
else
{
var ex=/^(([A-Za-z0-9_\-\.])+\@([A-Za-z0-9_\-\.])+\.([A-Za-z]{2,4}))$/;
 if(ex.test(email1)==false)
 {
  alert('Please Enter Valid Email ID');
document.insertform.email1.focus();
return false;
 }
}
var url1=document.insertform.url1.value;
if(url1=="")
{
alert('Please Enter Url');
document.insertform.url1.focus();
return false;
}
var category1=document.insertform.category1.value;
if(category1=="")
{
alert('Please Enter Category');
document.insertform.category1.focus();
return false;
}


}


</script>
<?php include('head.php')?>
<div align="center" style="width:2050px;">

</div>

<div class="center">
<h1 style="margin-left:50px; text-decoration:underline; text-align:center;">Insert Data </h1>

<form action="" method="post" onsubmit="return validation()"  name="insertform" >
<strong class="lab">Company Name:</strong> <input class="textbox" type="text"  name="company1" style="margin-left:72px; "><br /><br />
<strong class="lab">Address:</strong> <input class="textbox" type="text" name="address1" style="margin-left:138px;"><br /><br />
<strong class="lab">Contact Numbers:</strong> <input class="textbox" type="text" name="contact1"  style="margin-left:60px;"><br /><br />
<strong class="lab">Email ID:</strong> <input class="textbox" type="text" name="email1" style="margin-left:129px;"><br /><br />
<strong class="lab">Website ID:</strong> <input class="textbox" type="text" name="url1" style="margin-left:110px;"><br /><br />
<strong class="lab">Category:</strong> <input class="textbox" type="text" name="category1" style="margin-left:128px;"><br /><br />
<input type="submit" class="submit" name="submit" id="submit" value="Insert">

</form>

</div>



<?php include('foot.php')?>



head.php:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="style.css" />
<title>Insert Data to Database</title>
<meta name="description" content="san insert data to database">



<meta name="author" content="getinn">
<meta charset="UTF-8">

</head>

<body>
<div class="head">
<BR />
<marquee style="color:#FFFFFF; letter-spacing:1PX;">How to insert data Form to database using php and mysql with Javascript Validation</marquee>

</div>

foot.php:




<div class="footer">
<br><br>
<p style="color:#FEFEFE; text-align:right; margin-right:80px;">Copyright &copy; 2014 | san web corner  &nbsp;<a href="http://www.sanwebtutorials.blogspot.in/">san web corner</a></p>
</div>

</body>
</html>
db.php:
<?php

$conn=mysql_connect("localhost", "root", "") or die("Error connecting to database: ".mysql_error());
$db=mysql_select_db("getinsearch")or die('Database not connected');
?>

style.css



html, body {
  height: 100%;
  width: 100%;
  padding: 0;
  margin: 0;
  background-color:#FFFFFF;
}
.head
{
background-color:#a0c631;
height:60px;
}
.footer
{
background-color:#a0c631;
height:120px;
}






table
{
margin:0 auto;
font-family:Tahoma, Geneva, sans-serif;
margin-top:5px;
}


#text
{
font-family: Arial, Helvetica, sans-serif;
font-size: 14px;
height:40px;
border: 1px solid #898989;
}
#search {

font-size: 14px;
color:#FFFFFF;
padding: 12px 38px;
background: -moz-linear-gradient(
top,
#1d8cb1 0%,
#0f7ea3);
background: -webkit-gradient(
linear, left top, left bottom, 
from(#7c9b20),
to(#8eb420));
border: 1px solid #518206;
}
#search:hover
{
background:#5C9607;
}

.sansearch
{
width:500px;
size:10px;
margin-left:auto;
margin-right:auto;
}


.center
{
height:440px;
width:700px;
margin-left:auto;
margin-right:auto;
margin-top:50px;
margin-bottom:50px;
border:1px solid #B8B8B8;
border-radius:10px;




}

.container
{
width:1100px;
margin-left:auto;
margin-right:auto;
}


.san
{
width:800px;
margin-left:auto;
margin-right:auto;
border:1px solid #E3E3E3;
border-radius:10px;
height:auto;
line-height:20px;
padding-left:60px;
min-height:80px;
padding-top:10px;
padding-bottom:40px;
line-height:32px;
font-size:18px;





}

.textbox
{
height:30px;
width:300px;
border:1px solid #340001;
}
.lab
{
font-size:19px;
color:#050505;
font-weight:bold;
margin-left:50px;
}

.submit
{
height:30px;
width:100px;
border:1px solid #D3D3D3;
margin-left:350px;
margin-top:10px;


background-color:#6A9511;
color:#FFFFFF;
}


db.php:

<?php

$conn=mysql_connect("localhost", "root", "") or die("Error connecting to database: ".mysql_error());
$db=mysql_select_db("getinsearch")or die('Database not connected');
?>


Download Code


Post a Comment

Labels

360 degree view product image 3d rotate 3d text 3step-form Accordion menu ajax All Browsers Animated Background Gradient animation audio controller auto complete Best accordion menu bootstrap border bounce effect on hover Breadcrumb calculate age by dob calendar Captcha change image on mouse move color chooser countdown Counter on scroll Css css animation css buttons css hover css3 customized upload Button Date picker delete data from table Different scroll speed email otp verification email verifier Embed eventlist Expanding Menu feedbck form flash news section close button full screen menu Google custom search Google Maps Google reCAPTCHA Google site search gradient hide menu Horizontal News ticker Hover Htm Html html dropdown html form html5 html5 form validation Iframe image hover increment decrement textbox value based on select box Javascript Jquery js Layered image effect on mouse hover lock & unlock page scroll marquee marquee with close button mobile number validation mobile otp login Multi-level-drop-down-menu multi-level-form Multi-Step-form mysql News ticker on hover change text to image our team page password strength checker Photoshop PHP populate html selectbox Popup image on click the link pure css Question type form Random password Redirect page Based on the select box while submit the form responsive responsive menu responsive popup box Responsive Vertical Time line design rotate image selectbox based on select box simple coming soon page simple countdown based on end date simple typing effect slider sliding tab sms otp login statistic counter on scroll switch tag shape team member Time picker toggle toggle view transparent button underline animation up down slide validation vertical fixed sidebar Webtips Youtube