Internet Programming Laboratory Report
Internet Programming Laboratory Report
ENGINEERING - VILLUPURAM
(A Constituent College of Anna University, Chennai)
VILLUPURAM - 605103
NAME : …………………………
[Link] : …………………………
DEPARTMENT : …………………………
YEAR / SEM : …………………………
UNIVERSITY COLLEGE OF ENGINEERING VILLUPURAM
(A CONSTITUENT COLLEGE OF ANNA UNIVERSITY CHENNAI)
DATE:
PROGRAM :
[Link]
<html>
<head>
<title>Image map</title>
</head>
<body>
<map id="picture">
<area href="[Link]" shape="circle" coords="155,358,30"
alt="tamilnadu"\>
<area href="[Link]" shape="circle" coords="115,322,20" alt="karnataka"\>
<area href="[Link]" shape="circle" coords="161,300,30"
alt="andhra pradesh"\>
<area href="[Link]" shape="circle" coords="122,367,30" alt="kerala"\>
</map>
<img src=" [Link]" alt="India" usemap="#picture"\>
</body>
</html>
[Link]
<html>
<head>
<title>About Tamilnadu</title>
</head>
<body>
<center><h1>Tamilnadu</h1></center>
<hr/>
<ul>
<li>Area: 1,30,058 [Link]</li>
<li>Capital: Chennai</li>
<li>Language: Tamil</li>
<li>Population: 6,21,10,839</li>
</ul>
</body>
</html>
[Link]
<html>
<head>
<title>About Karnataka</title>
</head>
<body>
<center><h1>Karnataka</h1></center>
<hr/>
<ul>
<li>Area: 1,91,791 [Link]</li>
<li>Capital: Bangalore</li>
<li>Language: Kannada</li>
<li>Population: 5,27,33,598</li>
</ul>
</body>
</html>
[Link]
<html>
<head>
<title >About Andhrapradesh</title>
</head>
<body>
<center><h1>Andhrapradesh</h1></center>
<hr/>
<ul>
<li>Area: 2,75,068 [Link]</li>
<li>Capital: Hyderabad</li>
<li>Language: Telugu</li>
<li>Population: 7,57,27,541</li>
</ul>
</body>
</html>
[Link]
<html>
<head>
<title>About Kerala</title>
</head>
<body>
<center><h1>Kerala</h1></center>
<hr/>
<ul>
<li>Area: 38,863 [Link]</li>
<li>Capital: Trivandrum</li>
<li>Language: Malayalam</li>
<li>Population: 3,18,38,619</li>
</ul>
</body>
</html>
OUTPUT:
Result:
EX:NO:2 WEB PAGES WITH CSS
DATE:
PROGRAM:
[Link]
h1,h2{
text-decoration: underline;
font-style: italic;
text-align: center;
}
#body{
background-color: tan;
border: red dotted;
text-align: center;
}
.div{
border: peru solid;
}
*{
letter-spacing:1px;
}
a:link{
color: black;
}
a:visited{
color: yellow;
}
a:hover{
color: green;
}
a:active{
color: blue;
}
ul li{
font-size:small;
}
[Link]
<html>
<head>
<title>FLOWERS</title>
<!--Extended Style Sheet -->
<link rel="stylesheet" type="text/css" href="[Link]">
<!--Embed Style sheet-->
<style type="text/css">
p{
background-color: lightgrey;
text-align: justify;
margin: 2em 7em;
}
</style>
</head>
<body id="body">
<h1>FLOWER</h1>
<p>
<span style="font: 200 x-large fantasy">Flower</span>
sometimes known as a bloom or blossom, is the
reproductive structure found in flowering plants.
The flower is God's finest workmanship in the
world. It is his finest gift to the [Link] have
seen the flowers of many kinds and to many colors.
In India we see the flowers like
</p>
<!--Inline Style Sheet-->
<table style="background-position: center; text-align: center; padding: 3px;">
<tr>
<td align="left">
<div class="div">
<ul>
<li><a href="">Lily</a></li>
<li><a href="">Lotus</a></li>
<li><a href="">Rose</a></li>
<li><a href="">Jasmine</a></li>
</ul>
</div>
</td>
</tr>
</table>
</body>
</html>
OUTPUT:
Result:
EX:NO:3 HTML FORM VALIDATION USING JAVA SCRIPT
DATE:
PROGRAM:
[Link]:
<html>
<head>
<title> ONLINE BOOK STORES</title>
</head>
<body bgcolor="pink">
<marquee>
<h1 align=”center”>
<b><u><font color="white">ONLINE BOOK STORAGE</u></font> </b>
</h1>
</marquee>
<h2 align="center">
<b>
</h2>
<h3 align="center">
REGISTRATION FORM</font></i><br><br>
<a href="[Link]"><font
color="black"><i>PAYMENT</font></i><br><br>
</body>
</html>
[Link]:
<html>
<body bgcolor=”blue”>
<br><br><br>
<script language=”javascript”>
function validate(){
var flag=1;
flag=0;
}
if(flag = =1){
alert(“VALID INPUT”);
[Link]("[Link]","right");
}else{
alert(“INVALID INPUT”);
//[Link]();
}
}
</script>
<form name=”myform”>
<div align=”center”>
<pre>
LOGIN ID: <input type=”text” name=”id”><br>
</body>
</html>
[Link]:
<html>
<body bgcolor=”blue”>
<br><br>
<script language=”javascript”>
Function validate(){
var str = [Link];
var x;
if(flag= =1){
alert("VALID INPUT");
}else
{
alert("INVALID INPUT");
[Link]();
}
}
</script>
<form name="myform">
<div align="center">
<pre>
NAME :<input type="text" name = "name"><br>
</div>
<br><br>
<div align="center">
<input type="submit" value="ok" onClick="validate()">
<input type="reset" value="clear">
</div>
</form>
</body>
</html>
[Link]:
<html>
<body bgcolor="pink">
<br><br><br>
<div align="center">
<pre>
</pre>
<br><br>
</div>
<br><br>
<div align="center">
</div>
</body>
</html>
[Link]:
<html>
<body bgcolor="pink">
<br><br><br>
<div align="center">
<pre>
</pre>
<br><br>
</div>
<br><br>
<div align="center">
</div>
</body>
</html>
[Link]:
<html>
<body bgcolor="pink">
<br><br><br>
<script language="javascript">
function validate(){
var flag=1;
if(
[Link] = ="" ||
[Link] = ="" ||
[Link] = ="" ||
[Link] = =""
){
flag=0;
}
var str=[Link];
var x;
x=[Link](i,1);
if(!(x<=9)){
flag=0;
break;
}
str=[Link];
for(var i=0; i<[Link] ;i++){
x=[Link](i,1);
if(!(x<=9)){
flag=0;
break;
}
}
if(flag = =1){
alert("VALID INPUT");
}else{
alert("INVALID INPUT");
[Link]();
}
}
</script>
<form name="myform">
<div align="center">
<pre>
LOGIN ID :<input type="text" name="id"><br>
PASSWORD :<input type="password" name="pwd"><br>
AMOUNT :<input type="text" name="amount"><br>
</pre>
<br><br>
</div>
<br><br>
<div align="center">
</div>
</form>
</body>
</html>
[Link]:
<html>
<body bgcolor="pink">
<br><br><br>
<script type="text/javascript">
function validate(){
var flag=1;
alert("VALID INPUT");
}else{
alert("INVALID INPUT");
[Link]();
}
</script>
<form name="myform">
<div align="center">
<pre>
</div>
<br><br>
<div align="center">
</div>
</form>
</body> </html>
OUTPUT :
Result:
EX:NO:4a INVOKING SERVLETS FROM HTML FORMS
DATE:
0
PROGRAM
[Link]
<html>
<head>
<title>Student Information Form</title>
</head>
<body>
<center>
<form name="form1"
action="[Link]
<h3>Enter student information in following fields -</h3>
<table>
<tr>
<td><b>Roll Number</b></td>
<td><input type="text" name="Roll Number" size="25" value=" "></td>
</tr>
<tr>
<td><b>Student Name</b></td>
<td><input type="text" name="Student Name" size="25" value=" "></td>
</tr>
<tr>
<td><b>Student Address</b></td>
<td><input type="text" name="Address" size="50" value=" "></td>
</tr>
<tr>
<td><b>Phone</td>
<td><input type="text" name="Phone" size="25" value=" "></td>
</tr>
<tr>
<td><b>Total Marks</td>
<td><input type="text" name="Total Marks" size="10" value=" "></td>
</tr>
</table>
<input type="submit" value="submit">
</form>
</center>
</body>
</html>
my_servletDemo .java
import [Link].*;
import [Link].*;
import [Link].*;
public class my_servletDemo extends GenericServlet
{
public void service(ServletRequest req , ServletResponse res)
throws ServletException , IOException
{
PrintWriter out=[Link]();
Enumeration en=[Link]();
while([Link]())
{
String name_received=(String)[Link]();
[Link](name_received+ " = ");
String value_received = [Link](name_received);
[Link](value_received);
[Link](" ");
}
[Link]();
}
}
[Link]
Result:
EX:NO:4b SESSION TRACKING USING HIDDEN FORM FIELDS(cookies)
DATE:
Program:
[Link]:
<html>
<center>
<h1>WELCOME TO REGISTRATION PAGE</h1>
<select name="profession">
<option value="engineer">ENGINEER</option>
<option value="teacher">TEACHER</option>
<option value="businessman">BUSINESSMAN</option>
</select><br><br>
</form>
</center>
</body>
</html>
[Link]:
<web-app version="2.4"
xmlns="[Link]
xmlns:xsi="[Link]
xsi:schemaLocation="[Link]
[Link]
<welcome-file-list>
<welcome-file>[Link]</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>RegistrationServletOne</servlet-name>
<servlet-class>RegistrationServletOne</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>RegistrationServletOne</servlet-name>
<url-pattern>/registerone</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>RegistrationServletTwo</servlet-name>
<servlet-class>RegistrationServletTwo</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>RegistrationServletTwo</servlet-name>
<url-pattern>/registertwo</url-pattern>
</servlet-mapping>
</web-app>
[Link]:
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
[Link]("text/html");
[Link]("<center>");
[Link]("<h1>COMPLETE THE REGISTRATION</h1>");
[Link]("</center>");
[Link]("</body></html>");
[Link]();
}}
[Link]:
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
[Link]("text/html");
[Link]("<h1>REGISTRATION SUCCESSFUL..........</h1>");
[Link]("</center>");
[Link]("</body></html>");
[Link]();
}
OUTPUT:
Result:
EX:NO:4c SESSION TRACKING FOR HIT COUNT
DATE:
Program:
[Link]:
import [Link].*;
import [Link];
import [Link].*;
import [Link].*;
import [Link].*;
public class PageHitCounter extends HttpServlet {
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
[Link]("text/html");
// This method executes whenever the servlet is hit
// increment hitCount
hitCount++;
PrintWriter out = [Link]();
"</body> </html>");
}
}
[Link]:
<web-app version="2.4"
xmlns="[Link]
xmlns:xsi="[Link]
xsi:schemaLocation="[Link]
[Link]
<servlet>
<servlet-name>PageHitCounter</servlet-name>
<servlet-class>PageHitCounter</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>PageHitCounter</servlet-name>
<url-pattern>/PageHitCounter</url-pattern>
</servlet-mapping>
</web-app>
OUTPUT:
✓ Create a servlet(i.e)[Link]
✓ Compile the servlet by using the following command javac
[Link]
✓ The class file will generated, copy this class file to the location C: \Program
Files\Apache Software Foundation\webapps\WEB-INF\classes
✓ Edit the [Link] file present at WEB-INF folder
✓ Open the web browser and give the URL for [Link]
Result:
EX:NO:5 ONLINE EXAMINATION RESULTS USING SERVLET
DATE:
PROGRAM :
[Link]
<html>
<head><title>Online Examination</title>
<script language="javascript">
function validation(Form_obj) {
if(Form_obj.Seat_no.[Link]= =0){
alert("Please,fill up the Seat Number");
Form_obj.Seat_no.focus();
return false;
}
if(Form_obj.[Link]= =0){
alert("Please,fill up the Name");
Form_obj.[Link]();
return false;
}
return
true;
}
</script>
</head>
<body bgcolor="lightgreen">
<center>
<h1>OnLine Examination</h1>
</center>
<form action="StudentServlet3" method="post" name="entry"
onSubmit="return validation(this)">
<input type="hidden" value="list" name="action">
<table>
<tr>
<td><h3>Seat Number:</h3></td>
<td><input type="text" name="Seat_no"></td>
</tr>
<tr>
<td><h3>Name:</h3></td>
<td><input type="text" name="Name" size="50"></td>
</tr>
<hr/>
<tr>
<td><b>Total Marks:10(Each question carries equal marks) </b></td>
<td></td>
<td></td>
<td></td>
<td><b>Time: 15 Min.</b></td>
</tr>
</table>
<hr/>
<b>1. Apache is an open source web server</b><br/>
<input type="radio" name="group1" value="True">True
<input type="radio" name="group1" value="False">False<br> <br>
<center>
<input type = "submit" value="Submit">
<input type = "reset" value="Clear"><br><br>
</center>
</form>
</body>
</html>
[Link]
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
Connection connect=null;
Statement stmt=null;
ResultSet rs=null;
public void doPost (HttpServletRequest request, HttpServletResponse
response) throws ServletException, IOException{
//Establishing Connection to the Database try
{
[Link]("[Link]");
String url = "jdbc:odbc:StudentDB1";
connect = [Link](url, " ", " ");
} catch(ClassNotFoundException e){
[Link]();
} catch(SQLException e){
[Link]();}
catch(Exception e){
[Link]();
}
[Link]("text/html");
PrintWriter out=[Link]();
[Link]("<html>");
[Link]("<head>");
[Link]("</head>");
[Link]("<body bgcolor=pink>");
[Link]("<center>");
[Link]("<br><br>");
[Link]("<h2>Students Database</h2>");
[Link]("<table border=5>");
try
{
stmt = [Link]();
String query = "SELECT * FROM StudentTable WHERE
Name="+"'"+Name+"'"; rs =
[Link](query);
[Link]("<th>"+"Seat_no"+"</th>");
[Link]("<th>"+"Name"+"</th>");
[Link]("<th>"+"Marks"+"</th>");
while([Link]()) {
[Link](" <tr>");
[Link](" <td>"+ [Link](1) + "</td>");
[Link](" <td> "+ [Link](2) +" </td>");
[Link](" <td> "+[Link](3) +" </td>");
[Link](" </tr>");
}
[Link]("</table>");
}catch(SQLException e){}
finally {
try {
if(rs!=null)
[Link]();
if(stmt!=null)
[Link]();
if(connect!=null)
[Link]();
}catch(SQLException
e){[Link]("<h1>Thanks</h1>\n");
[Link]("</table>");
[Link]("</center>");
[Link]("</body></html>");
}
}
}
[Link]
DATE:
Program:
[Link]
<%@ page language="java" import="[Link].*" %>
<%
a1= a2 = a3 = a4 = a5=0;
Connection connect=null;
Statement stmt=null;
ResultSet rs=null;
[Link]("[Link]");
if([Link]("action") != null){
SeatNum = [Link]("Seat_no");
Name = [Link]("Name");
ans1 =[Link]("group1");
if([Link]("True"))
a1=2;
else
a1=0;
ans2 = [Link]("group2");
if([Link]("True"))
a2=0;
else
a2=2;
ans3 = [Link]("group3");
if([Link]("True"))
a3=0;
else
a3=2;
ans4 = [Link]("group4");
if([Link]("True"))
a4=2;
else
a4=0;
ans5 = [Link]("group5");
if([Link]("True"))
a5=0;
else
a5=2;
int Total=a1+a2+a3+a4+a5;
stmt = [Link]();
VALUES (' " +SeatNum + " ', ' " + Name + " ', ' "+Total+ " ')";
int result = [Link](query);
[Link]();
stmt = [Link]();
%>
<html><head><title>Student Mark List</title>
</head>
<body bgcolor="khaki">
<center>
<h2>Students Marksheet</h2>
<tr>
<td><b>Seat_No</b></td>
<td><b>Name</b></td>
<td><b>Marks</b></td>
</tr>
<%while([Link]() { %>
<tr>
<td><%=[Link](1)%></td>
<td> <%=[Link](2)%></td>
<td> <%=[Link](3)%></td>
</tr>
<% }
[Link]();
[Link]();
[Link]();
%>
</table>
</center>
<br/> <br/><br/>
<table>
<tr><td><b>Date:<%=new [Link]().toString()
%></td></tr>
<tr><td><b>Signature: X.Y.Z. <b></td></tr>
</table>
<div>
<a href="[Link]
here to go back</a>
</div>
</body>
</html>
<html>
<head><title>Online Examination</title>
<script language="javascript">
function validation(Form_obj) {
if(Form_obj.Seat_no.[Link] = =0){
return false;
}
if(Form_obj.[Link]= =0){
}
return true;
</script>
</head>
<form action="[Link]
method="post"
name="entry" onSubmit="return validation(this)">
<tr>
<td><h3>Seat Number:</h3></td>
<td><input type="text" name="Seat_no"></td>
</tr>
<tr>
<td><h3>Name:</h3></td>
<tr>
<td><b>Total Marks:10(Each question carries equal marks)
</b></td>
<td></td>
<td></td>
<td></td>
<td><b>Time: 15 Min.</b></td>
</tr>
</table>
<hr/>
<br/>
value="False">False<br>
<br/>
value="False">False<br>
<br/>
value="False">False<br>
<hr/>
<center>
<input type = "submit" value="Submit">
</form>
<%}%>
OUTPUT :
Result:
EX:NO:7 ONLINE BOOKS CATALOGUE
DATE:
Program:
[Link]:
<%@page contentType="text/html" pageEncoding="UTF-8" %>
<!DOCTYPE html>
<html>
<head>
img:hover{
width:100%;
height:100%;
</style>
</head>
<body>
<h1>Books Catalogue</h1>
<form action="[Link]">
name="category">
<option value="Maths">Maths</option>
<div id ="s1"></div>
<script>
function display() {
var m = [Link]("category").value;
XMLHttpRequest();
[Link]=function(){
{
[Link]("s1").innerHTML = [Link];
}
};
[Link]("GET","[Link]?category="+m,true);//url rewriting
[Link]();
</script>
[Link]:
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
<style>
.box {
display: flex;
align-items: center;
justify-content: center;
.box div {
width: 100%;
height: 100%;
.price {
color: grey;
font-size: 25px;
img{
width:20%;
}
</style>
</head>
<body>
<%
String category = [Link]("category");
[Link]("[Link]");
Connection con=
[Link]("jdbc:derby://localhost:1527/shopping");
Statement st = [Link]();
String query="select bookid,author,price from catalogue where
category='"+category+"'";
ResultSet rs = [Link](query);
%>
<h1>List of Books</h1>
<div class="box">
<%
while([Link]())
{%>
<div>
<img src="<%=[Link](1)%>.jpg"/>
<p>Author:<%=[Link](2)%></p>
<p class="price">Rs.<%=[Link](3)%></p>
</div> <%
}
[Link]();
%>
</div>
</body>
</html>
Output:
Result:
EX:NO:8 EXTRACTING INFORMATION FROM THE XML
DATE:
Program:
[Link]
<!DOCTYPE html>
<html>
<head>
<title>Searching for XML Elements </title>
<script>
function readXMLData()
{
var xmlDocumentObject, id , name , addr, phone, email;
xmlDocumentObject=new XMLHttpRequest();
[Link]("GET","[Link]",false);
[Link]();
xmlDocumentObject=[Link];
id = [Link]("userid");
name = [Link]("username");
address = [Link]("address");
phone = [Link]("phone");
email = [Link]("email");
for (i = 0; i < [Link]; i++)
{
output=id[i].[Link];
if (output == [Link]("myText").value)
{
[Link] = id[i].[Link] + "<br> " +
name[i].[Link] + "<br> " +
address[i].[Link] + "<br> " +
phone[i].[Link] + "<br>" +
email[i].[Link];
}
}
}
</script>
</head>
<body>
<h1>Search User</h1>
<input type="text" id="myText" value="">
<input type="button" value="Get User Details" onclick="readXMLData()">
<p>
<div id="displayDIV"> </div>
</body>
</html>
Output:
Result:
EX:NO:9a FORM VALIDATION USING PHP REGULAR EXPRESSION
DATE:
Program:
[Link]:
<!DOCTYPE HTML>
<html>
<head>
<style>
.error {
color: #FF0000;
}
</style>
</head>
<body>
<?php
$nameErr = $emailErr = $genderErr = $websiteErr = "";
$name = $email = $gender = $comment = $website = "";
if ($_SERVER["REQUEST_METHOD"] = = "POST") {
if (empty($_POST["name"])) {
} else {
$name = test_input($_POST["name"]);
if (!preg_match("/^[a-zA-Z-' ]*$/",$name)) {
$nameErr = "Only letters and white space allowed";
}
}
if (empty($_POST["email"])) {
$email = test_input($_POST["email"]);
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
}
}
if (empty($_POST["website"])) {
$website = "";
} else {
$website = test_input($_POST["website"]);
if (!preg_match("/\b(?:(?:https?|ftp):\/\/|www\.)[-a-z0-9+&@#\/%?=~_|!:,.;]*[-
a-z0-
9+&@#\/%=~_|]/i",$website)) {
if (empty($_POST["comment"])) {
$comment = "";
} else {
$comment = test_input($_POST["comment"]);
}
if (empty($_POST["gender"])) {
$gender = test_input($_POST["gender"]);
}}
function test_input($data) {
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
?>
<h2>PHP Form Validation Example</h2>
<p><span class="error">* required field</span></p>
<br><br>
$comment;?></textarea>
<br><br>
Gender:
<input type="radio" name="gender" <?php if (isset($gender) &&
$gender=="female") echo "checked";?> value="female">Female
</form>
<?php
echo "<br>";
echo $website;
echo "<br>";
echo $comment;
echo "<br>";
echo $gender;
?>
</body>
</html>
Output:
Result:
EX:NO:9b STORING A FORM DATA IN PHP
DATE:
A
Program:
[Link]
<!DOCTYPE html>
<html>
<head>
<style>
.error {
color: #FF0000;
}
</style>
</head>
<body>
<?php
$nameErr = $emailErr = $genderErr = $websiteErr = "";
$name = $email = $gender = $comment = $website =$result= "";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if (empty($_POST["name"])) {
$nameErr = "Name is required";
} else {
$name = test_input($_POST["name"]);
if (!preg_match("/^[a-zA-Z ]*$/",$name)) {
$nameErr = "Only letters and white space allowed";
}}
if (empty($_POST["email"])) {
$emailErr = "Email is required";
} else {
$email = test_input($_POST["email"]);
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
$emailErr = "Invalid email format";
}}
if (empty($_POST["website"])) {
$website = "";
} else {
$website = test_input($_POST["website"]);
if (!preg_match("/\b(?:(?:https?|ftp):\/\/|www\.)[-a-z0-9+&@#\/%?=~_|!:,.;]*[-a-z0-
9+&@#\/%=~_|]/i",$website))
{
$websiteErr = "Invalid URL";
}}
if (empty($_POST["comment"])) {
$comment = "";
} else {
$comment = test_input($_POST["comment"]);
}
if (empty($_POST["gender"])) {
$genderErr = "Gender is required";
} else {
$gender = test_input($_POST["gender"]);
}
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "iplab";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "INSERT INTO register (name, email,website,comments,gender)
VALUES ('$name', '$email', '$website','$comment', '$gender')";
if ($conn->query($sql) = = = TRUE)
{
$result="New Record Inserted Successfully";
} else
{
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
}
function test_input($data) {
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
?>
<h2>Registration Form</h2>
<p><span class="error">* required field</span></p>
<form method="post" action="<?php echo
htmlspecialchars($_SERVER["PHP_SELF"]);?>">
Name: <input type="text" name="name">
<span class="error">* <?php echo $nameErr;?></span>
<br><br>
E-mail: <input type="text" name="email">
<span class="error">* <?php echo $emailErr;?></span>
<br><br>
Website: <input type="text" name="website">
<span class="error"><?php echo $websiteErr;?></span>
<br><br>
Comment: <textarea name="comment" rows="5" cols="40"></textarea>
<br><br>
Gender:
<input type="radio" name="gender" value="female">Female
<input type="radio" name="gender" value="male">Male
<span class="error">* <?php echo $genderErr;?></span>
<br><br>
<input type="submit" name="submit" value="Submit">
</form>
<?php
echo $result;
?>
</body></html>
OUTPUT:
RESULT:
EX:NO:10 WEB SERVICE FOR FINDING PEOPLE’S OPINION
DATE:
Aim:
Program:
[Link]
<!Doctype html>
<html lang="en">
<head>
<script
src="[Link]
<script src="js/[Link]"></script>
</head>
<body>
<div class="wrap">
<?php
// retrive post
include('[Link]');
include ('[Link]');
dbConnect();
$query = mysql_query(
'SELECT *
FROM post
WHERE post_id = 1');
$row = mysql_fetch_array($query);
?>
<div class="post">
</div>
<?php
$comment_query = mysql_query(
"SELECT *
FROM comment
LIMIT 15");
?>
<h2>Comments.....</h2>
<div class="comment-block">
<div class="comment-item">
<div class="comment-avatar">
</div>
<div class="comment-post">
</div>
</div>
<?php endwhile?>
</div>
<label>
<span>Name *</span>
</label>
<label>
<span>Email *</span>
</label>
<label>
<span>Your comment *</span>
here...." required></textarea>
</label>
</form>
</div>
</body>
</html>
Ajax_Comment.php
<?php
include('[Link]');
include('[Link]');
dbConnect();
$name = mysql_real_escape_string($_POST['name']);
$mail = mysql_real_escape_string($_POST['mail']);
$comment = mysql_real_escape_string($_POST['comment']);
$postId = mysql_real_escape_string($_POST['postid']);
mysql_query("
INSERT INTO comment
?>
<div class="comment-item">
<div class="comment-avatar">
</div>
<div class="comment-post">
</div>
</div>
<?php
dbConnect(0);
endif
?>
[Link]
<?php
# db configuration
define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PASS', 'root');
define('DB_NAME', 'dbname');
?>
[Link]
<?php
/**
* @param bool
*/
function dbConnect($close=true){
if (!$close) {
mysql_close($link);
return true;
if (!mysql_select_db(DB_NAME, $link))
return false;
/**
* gravatar Image
* @see [Link]
*/
$url = "[Link]
return $url;
?>
[Link]
/* general styling */
*{
margin: 0;
padding: 0;
box-sizing: border-box;
-webkit-box-sizing: border-box;
-moz-box-sizing: border-box;
-webkit-font-smoothing: antialiased;
-moz-font-smoothing: antialiased;
-o-font-smoothing: antialiased;
font-smoothing: antialiased;
text-rendering: optimizeLegibility;
}
body{
text-transform: inherit;
color: #333;
background: #e7edee;
width: 100%;
.wrap{
width: 720px;
background: white;
-webkit-border-radius: 5px;
-moz-border-radius: 5px;
border-radius: 5px;
overflow: hidden;
a{
text-decoration: none;
color: #333;
}
h1{
font-size: 2.8em;
text-align: center;
margin: 25px 0;
h2{
font-size: 1.5em;
margin: 8px 0
h3{
font-size: 1.2em;
margin: 5px 0;
h3 span{
font-weight: normal;
font-size: 1em;
.item{
clear: both;
margin:0;
padding: 10px;
overflow: hidden;
.item:last-child{
.item:hover{
background: #f9f9f9
.post{
padding: 10px 0;
.comment-block{
.comment-item{
overflow: hidden;
width: 500px;
clear: both;
padding: 10px;
border-radius: 5px;
margin: 5px;
.comment-avatar{
width: 60px;
float: left;
.comment-avatar img{
width: 60px;
height: 60px;
border-radius: 5px;
.comment-post{
width: 400px;
float: left;
#form{
clear: both;
margin: 10px;
width: 500px;
/* form styling */
input[type="text"],
input[type="email"],
input[type="tel"],
input[type="url"],
textarea {
width:100%;
background: #fff;
font-size: 13px;
line-height: 20px;
margin: 0;
margin:0 0 5px;
border-radius:5px;
textarea {
height:100px;
max-width:100%;
input[type="submit"] {
cursor:pointer;
width:100%;
border:none;
background:#991D57;
color:#FFF;
margin:0 0 5px;
padding:10px;
border-radius:5px;
input[type="submit"]:hover {
input[type="submit"]:active {
input:focus,
textarea:focus {
outline:0;
label{
display: block;
margin: 5px 0;
font-weight: 900;
cursor: pointer;
.alert{
display: none;
margin: 20px 0;
color: #468847;
background-color: #dff0d8;
border-color: #d6e9c6;
-webkit-border-radius: 4px;
-moz-border-radius: 4px;
border-radius: 4px;
[Link]
$(document).ready(function(){
var form = $('form');
[Link]('submit', function(e) {
[Link]();
$.ajax({
url: 'ajax_comment.php',
type: 'POST',
cache: false,
beforeSend: function(){
[Link]('Submitting...').attr('disabled', 'disabled');
},
success: function(data){
$('.comment-block').append(item);
[Link]('reset');
[Link]('Submit Comment').removeAttr('disabled');
},
error: function(e){
alert(e);
});
});
})
Output:
Result: