sonucgn.files.wordpress.com  · web viewtypes{display: block; margin-left:40px;margin-top:...

67
16F41A0540 Math Program: <?php echo(abs(6.7) . "<br>"); echo(abs(-6.7) . "<br>"); echo(abs(-3) . "<br>"); echo(abs(3)); ?> OUTPUT:

Upload: others

Post on 16-Sep-2020

0 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Math

Program:

<?php

echo(abs(6.7) . "<br>");

echo(abs(-6.7) . "<br>");

echo(abs(-3) . "<br>");

echo(abs(3));

?>

OUTPUT:

Page 2: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Program:

<?php

$name_one = array("Zack", "Anthony", "Ram", "Salim", "Raghav");

sort($name_one);

foreach($name_one as $value)

{

echo"name_one:$value<br>";

}

ksort($name_one);

foreach($name_one as $value)

{

echo"name_one:$value<br>";

}

$arr = array("13" =>"ASP.Net",

"12" =>"C#",

"11" =>"Graphics",

"4" =>"Video Editing",

"5" =>"Photoshop",

"6" =>"Article",

"4" =>"Placement",

"8" =>"C++",

"7" =>"XML",

"10" =>"Android",

"1" =>"SQL",

"2" =>"PL/Sql",

"3" =>"End",

"0" =>"Java", );

Page 3: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

ksort($arr);

// for-Loop for displaying result

foreach ($arr as $key => $val) {

echo "[$key] = $val</br>";

echo"\n";

}

?>

Page 4: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Output:

Page 5: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

DATE

Program:

<?php

$date=date_create("1997-01-22");

date_time_set($date,12,30,22);

echo date_format($date,"Y-m-d H:i:s");

?>

Output:

Page 6: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

STRING

Program:

<?php

$var_name = 305628;

echo strval($var_name);

echo"<br>";

echo substr("Hello world",3);

?>

Output:-

Page 7: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

DTD FOR COMPUTER:

COMPUTER.XML:

<?xml version = "1.0"?>

<!-- computer.xml for the DTD -->

<?xml-stylesheet type="text/css" href= "com.css"?>

<computer>

<h1>16F41A0540</h1>

<h1>tharun</h1>

<types>TYPES OF COMPUTER

<type>1.Desktop pc

2.laptop

3.palmtop

4.Server

5.Minicomputer

</type>

</types>

<monitor>

<sno>001

</sno>

<make>apple

</make>

<model>123

</model>

<year>1990

</year>

Page 8: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

<size>100kg

</size>

</monitor>

<keyboard>

<sno>021

</sno>

<make>ios

</make>

<model>431

</model>

<year>2001

</year>

<key>106

</key>

</keyboard>

<mouse>

<sno>021

</sno>

<make>okat

</make>

<model>4531

</model>

<year>1991

</year>

<buttons>4

Page 9: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

</buttons>

<scrollwell>yes

</scrollwell>

<type>mx01

</type>

</mouse>

<motherboard>

<sno>121

</sno>

<make>cal

</make>

<model>831

</model>

<year>2005

</year>

<no>32

</no>

<ide>21

</ide>

<sata>2

</sata>

<pcl>23</pcl>

<display>HDMI

</display>

</motherboard>

Page 10: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

</computer>

COM.CSS:

<!--com.css- a style sheet for the computer.xml document-->

h1{font-size:100pt;}

computer{display: block; margin-top: 50px; color: blue;}

types{display: block; margin-left:40px;margin-top: 30pt;color:red}

type{font-size: 28pt;}

monitor{font-size: 28pt;}

sno{display: block; margin-left: 18pt;color:green}

make{display: block;font-size: 18pt;}

made{display: block;font-size: 18pt;}

model{display: block;font-size: 18pt;color:blue}

year{display: block;font-size: 18pt;}

size{display: block; font-size: 18pt;color:green}

keyboard{display: block;font-size: 40pt;}

key{display: block;font-size: 18pt;}

mouse{display: block;font-size: 40pt;color:blue}

buttons{display: block;font-size: 18pt;}

scrollwell{display: block;font-size: 18pt;}

motherboard{display: block;font-size: 40pt;color:blue}

ide{display: block;font-size: 18pt;}

sata{display: block;font-size: 18pt;}

pcl{display: block;font-size: 18pt;}

display{display: block;font-size: 18pt;}

Page 11: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

OUTPUT:

Page 12: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

DTD FOR LIBRARY:

LIBRARY.XML:

<?xml version = "1.0"?>

<!-- library.xml for the DTD -->

<?xml-stylesheet type="text/css" href= "lib.css"?>

<library>16F41A0540

THARUN

<books>

<bookid>001

</bookid>

<name>WT

</name>

<author>craik cook

</author>

<year>2001

</year>

<isbn>a001

</isbn>

<cost>2000

</cost>

</books>

<books>

<bookid>002

</bookid>

<name>HARRY POTER

Page 13: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

</name>

<address>J. K. Rowling

</address>

<isbn>a002

</isbn>

<cost>20000

</cost>

</books>

<user>

<username>tharun

</username>

<id>0001

</id>

<address>jhdfuhsdjfh

</address>

<no.>123445665

</no.>

</user>

<user>

<username>sai

</username>

<id>0002

</id>

<address>jskhdjshfjksdhjkf

</address>

Page 14: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

<no.>1234545455665</no.>

</user>

</library>

LIB.CSS:

<!--library.css- a style sheet for the students.xml document-->

library{display: block; margin-top: 15px; color: blue;}

books{display: block; margin-left:40px;margin-top: 30pt;color:red}

bookid{font-size: 28pt;}

name{font-size: 28pt;}

author{display: block; margin-left:40px;color:green}

year{display: block;font-size: 18pt;}

isbn{display: block;font-size: 18pt;}

cost{display: block;font-size: 18pt;color:blue}

bookid{display: block;font-size: 18pt;}

user{display: block; margin-left:40px;color:green}

username{display: block;font-size: 18pt;}

id{display: block;font-size: 18pt;}

address{display: block;font-size: 18pt;color:blue}

no.{display: block;font-size: 18pt;}

Page 15: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

OUTPUT:-

Page 16: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

DTD FOR BANK:

BANK.XML:

<?xml version = "1.0"?>

<!-- bank.xml for the DTD -->

<?xml-stylesheet type="text/css" href= "ban.css"?>

<bank>16F41A0540

THARUN

<customer>

<id>001

</id>

<name>ram

</name>

<address>near drinage

</address>

</customer>

<account>

<aid>0011

</aid>

<bid>sbin0021

</bid>

<id>001

</id>

<type>savings

</type>

<balance>10000

Page 17: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

</balance>

</account>

<em>

<eid>001

</eid>

<name>raju

</name>

<des>Manager

</des>

<doj>01-02-1998

</doj>

<sal>20110

</sal>

<add>near sbi

</add>

</em>

</bank>

BAN.CSS:

<!--com.css- a style sheet for the bank.xml document-->

bank{display: block; margin-top: 15px; color: blue;}

customer{display: block; margin-left:40px;margin-top: 30pt;color:red}

id{font-size: 18pt;}

name{font-size: 18pt;}

address{display: block; margin-left: 18pt;color:green}

account{display: block;font-size: 40pt;}

Page 18: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

aid{display: block;font-size: 18pt;}

bid{display: block;font-size: 40pt;color:blue}

id{display: block;font-size: 18pt;}

type{display: block;font-size: 18pt;}

balance{display: block;font-size: 18pt;}

em{display: block;font-size: 40pt;color:blue}

eid{display: block;font-size: 18pt;}

name{display: block;font-size: 18pt;}

des{display: block;font-size: 18pt;}

doj{display: block;font-size: 18pt;}

sal{display: block;font-size: 18pt;}

add{display: block;font-size: 18pt;}

Page 19: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

OUTPUT:-

Page 20: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Program:

create.php

<html>

<head>

<title>Untitled Document</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>

<?php

$servername = "localhost";

$username = "root";

$password = "";

// Create connection

$conn = mysqli_connect($servername, $username, $password);

// Check connection

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

echo "Connected successfully";

?>

</body>

</html>

create1.php

<?php

$servername = "localhost";

$username = "root";

Page 21: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

$password = "";

// Create connection

$conn = new mysqli($servername, $username, $password);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

// Create database

$sql = "CREATE DATABASE DB";

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

echo "Database created successfully";

} else {

echo "Error creating database: " . $conn->error;

}

$conn->close();

?>

createt.php

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "DB";

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

Page 23: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$sql = "INSERT INTO MyGuests (firstname, lastname, email)

VALUES ('John', 'Doe', '[email protected]');";

$sql .= "INSERT INTO MyGuests (firstname, lastname, email)

VALUES ('Mary', 'Moe', '[email protected]');";

$sql .= "INSERT INTO MyGuests (firstname, lastname, email)

VALUES ('Julie', 'Dooley', '[email protected]')";

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

echo "New records created successfully";

} else {

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

}

$conn->close();

?>

select.php

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "DB";

Page 24: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$sql = "SELECT id, firstname, lastname FROM MyGuests";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row

while($row = $result->fetch_assoc()) {

echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";

}

} else {

echo "0 results";

}

$conn->close();

?>

Login.php

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Jotorres Login Form</title>

Page 26: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

$password = "";

$dbname = "DB";

$id = $_POST["id"];

$password = $_POST["firstname"];

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$sql = "SELECT id, firstname, lastname FROM MyGuests WHERE id=$id";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row

while($row = $result->fetch_assoc()) {

echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";

}

} else {

echo "0 results";

}

$conn->close();

?>

Page 27: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

OUTPUT:

Page 28: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Cookie

index.html

<html>

<head><h1><b>16F41A0522</b></h1></head>

<form action="login">

User Name:<input type="text" name="userName"/><br/>

Password:<input type="password" name="userPassword"/><br/>

<input type="submit" value="submit"/>

</form></html>

MyServlet1.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class MyServlet1 extends HttpServlet

{

public void doGet(HttpServletRequest request,

HttpServletResponse response) {

try{

response.setContentType("text/html");

PrintWriter pwriter = response.getWriter();

String name = request.getParameter("userName");

String password = request.getParameter("userPassword");

pwriter.print("Hello "+name);

pwriter.print("Your Password is: "+password);

Cookie c1=new Cookie("userName",name);

Page 29: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Cookie c2=new Cookie("userPassword",password);

response.addCookie(c1);

response.addCookie(c2);

pwriter.print("<br><a href='welcome'>View Details</a>");

pwriter.close();

}catch(Exception exp){

System.out.println(exp);

}}}

MyServlet2.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class MyServlet2 extends HttpServlet {

public void doGet(HttpServletRequest request,

HttpServletResponse response){

try{

response.setContentType("text/html");

PrintWriter pwriter = response.getWriter();

Cookie c[]=request.getCookies();

pwriter.print("Name: "+c[1].getValue());

pwriter.print("Password: "+c[2].getValue());

pwriter.close();

}catch(Exception exp){

System.out.println(exp);

} }}

Page 30: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

web.xml

<servlet>

<servlet-name>Servlet1</servlet-name>

<servlet-class>MyServlet1</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>Servlet1</servlet-name>

<url-pattern>/login</url-pattern>

</servlet-mapping>

<servlet>

<servlet-name>Servlet2</servlet-name>

<servlet-class>MyServlet2</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>Servlet2</servlet-name>

<url-pattern>/welcome</url-pattern>

</servlet-mapping>

Page 31: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Output

Page 32: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Session

Session1.java

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

import java.util.*;

public class Session1 extends HttpServlet{

public void doGet(HttpServletRequest request, HttpServletResponse response)

{

try{

response.setContentType("text/html");

PrintWriter out=response.getWriter();

String t1=new String();

String n=new String();

n="nirosha";

HttpSession session=request.getSession();

session.setAttribute("uname",n);

t1=session.getId();

Date createTime=new Date(session.getCreationTime());

Date lastAccessTime=new Date(session.getLastAccessedTime());

out.println("Servlet ID"+t1);

out.println(createTime);

out.println(lastAccessTime);

out.close();

}catch(Exception e){

Page 33: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

System.out.println(e);

}}}

web.xml

<servlet>

<servlet-name>Session1</servlet-name>

<servlet-class> Session1</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name> Session1</servlet-name>

<url-pattern>/ Session1</url-pattern>

</servlet-mapping>

Page 34: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Output

Page 35: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Hidden Form Field

Index3.jsp<!DOCTYPE html>

<html>

<head>

<title>Hidden Form Field  </title>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8

<meta name="viewport" content="width=device-width">

</head>

<body>

<form action="printhiddendata.jsp" method="post">

Enter your name: <input type="text" name="uname">

<br><input type="hidden" name="hide" value="What are you doing">

<input type="submit" value="Go">

</form>

<p>tharun </p>

<p>16F41A0540</p>

</body>

</html>

printhiddendata.jsp<!DOCTYPE HTML>

<html>

<body>

<b>Welcome

Page 36: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

<% out.println(request.getParameter("uname"));

%>

<br>Hidden Fields Are:

<% out.println(request.getParameter("hide"));

%>

</b>

<p>tharun</p>

<p>16F41A0540</p>

</body>

</html>

Page 37: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Output:

Page 38: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Exception Handling

<html>

<head>

<script type="text/javascript" language="javascript">

function InputException(msg)

{

this.val = msg;

this.toString = function()

{ return "Input Exception in = "+this.val;}

}

function AreLetters(msg)

{

var input = msg;

var re = new RegExp("[^a-zA-Z]");

if(input.match(re))

{

oops = new InputException(input);

throw oops;

}

else{document.write("<br>"+input);}

}

function RunTest()

{

var input = prompt("type something","");

Page 39: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

try{AreLetters(input);}

catch(e){document.write("<br>exception occured and caught"+e.toString());}

document.write("<h1>Exception Handling</h1>");

}

</script>

</head>

<body>

<script language="javascript" type="text/javascript">

RunTest();

</script>

</body>

<p>tharun</p>

<p>16f41a0540</p>

</html>

Page 40: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Output:-

Page 41: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Sorting<html>

<head>

<script type="text/javascript">

var num=0;

number=0;

var numarray=new Array();

function array_size()

{

num=prompt("Enter how many number to be sorted","000");

number=parseInt(num);

get_numbers();

}

function get_numbers()

{

if (number!=null && number!="")

{

for( i=0;i<number;i++)

{

n=prompt("Enter the number to be sorted","1");

numarray[i]=parseInt(n);

}

}

sorting()

}

Page 42: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

function sorting()

{

document.writeln("<h1>Sorted Array<h1>");

document.writeln(numarray.sort(sortNumber));

}

function sortNumber(a,b )

{

return a - b;

}

</script>

</head>

<body>

<h1> Click the button to get the Number sorted</h1>

<input type="button" onclick="array_size()" value="Get Array Size" />

</body>

<p>tharun</p>

<p>16f41a0540</p>

</html>

Page 43: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Output:-

Page 44: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Page 48: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

// sql to create table

$sql = "CREATE TABLE MyGuests (

id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

firstname VARCHAR(30) NOT NULL,

lastname VARCHAR(30) NOT NULL,

email VARCHAR(50),

reg_date TIMESTAMP

)";

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

echo "Table MyGuests created successfully";

} else {

echo "Error creating table: " . $conn->error;

}

$conn->close();

?>

Page 50: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

VALUES ('John', 'Doe', '[email protected]');";

$sql .= "INSERT INTO MyGuests (firstname, lastname, email)

VALUES ('Mary', 'Moe', '[email protected]');";

$sql .= "INSERT INTO MyGuests (firstname, lastname, email)

VALUES ('Julie', 'Dooley', '[email protected]')";

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

echo "New records created successfully";

} else {

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

}

$conn->close();

?>

select.php

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "DB";

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$sql = "SELECT id, firstname, lastname FROM MyGuests";

Page 51: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row

while($row = $result->fetch_assoc()) {

echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";

}

} else {

echo "0 results";

}

$conn->close();

?>

Output:-

Page 52: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Update

Program:

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "mb";

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$sql = "UPDATE Guest SET lastname='Doe' WHERE id=2";

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

echo "Record updated successfully";

} else {

echo "Error updating record: " . $conn->error;

}

$conn->close();

?>

Page 53: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Output:

Page 54: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Delete:

Program:

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "mb";

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

// sql to delete a record

$sql = "DELETE FROM Guest WHERE id=3";

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

echo "Record deleted successfully";

} else {

echo "Error deleting record: " . $conn->error;

}

$conn->close();

?>

Page 55: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

Output:

Page 56: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

SIMPLE TEXTFIELD CALCULATOR

PROGRAM:

<html>

<head>

<title>Calculator</title>

</head>

<body>

<form action="calculator" method="get" name="frm">

Enter num1:

<input name="txt1" type="text" />

Enter num2:

<input name="txt2" type="text" />

Operator

<select name="op">

<option value="Addition">Addition</option>

<option value="Subtraction">Subtraction</option>

<option value="multiplication">multiplication</option>

<option value="division">division</option>

</select>

<input type="submit" value="submit" />

<p>Tharun</p>

<p>16F41A0540</p> </form>

</body>

</html>

Calculator.java

Page 57: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class calculator extends HttpServlet {

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

PrintWriter out = response.getWriter();

String n1 = request.getParameter("txt1");

String n2 = request.getParameter("txt2");

String op = request.getParameter("op");

if(op.equals("Addition")){

out.println((Integer.parseInt(n1) + Integer.parseInt(n2)));

}

else if(op.equals("Subtraction")){

out.println(Integer.parseInt(n1) - Integer.parseInt(n2));

}

else if(op.equals("multiplication")){

Page 58: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

out.println(Integer.parseInt(n1) * Integer.parseInt(n2));

}

else{

out.println(Integer.parseInt(n1) / Integer.parseInt(n2));

}

}

}

XML FILE:

<servlet>

<servlet-name>calculator</servlet-name>

<servlet-class>calculator</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>calculator</servlet-name>

<url-pattern>/calculator</url-pattern>

</servlet-mapping>

Page 59: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540

OUTPUT:-

Page 60: sonucgn.files.wordpress.com  · Web viewtypes{display: block; margin-left:40px;margin-top: 30pt;color:red} type{font-size: 28pt;} monitor{font-size: 28pt;} sno{display: block; margin-left:

16F41A0540