WT Slip Solutions

Doubt slips (7,11,12,13,14,15,16,22,23,24,25,26,27,28)
Slip 1
Write a PHP script to keep track of number of times the web page has been accessed (Use Session
Tracking).
//program to keep track of no of times the web page is visited using SESSION
<?php
session_start();
if(isset($_SESSION[‘c’]))
$_SESSION[‘c’]+=1;
echo”<br>Welcome for the “.$_SESSION[‘c’].” times”;
else
$_SESSION[‘c’]=1;
echo”<br>Welcome for the first times”;
?>
Slip 2
Write a PHP script to change the preferences of your web page like font style, font size, font color,
background color using cookie. Display selected setting on next web page and actual implementation
(with new settings) on third page (Use Cookies).
Ass1_a2_21.php
<?php
$fn=$_REQUEST[‘fn’];
$fs=$_REQUEST[‘fs’];
$s=$_REQUEST[‘s’];
$bg=$_REQUEST[‘bg’];
$fc=$_REQUEST[‘fc’];
setcookie(‘fn’,$fn);
setcookie(‘fs’,$fs);
setcookie(‘s’,$s);
setcookie(‘bg’,$bg);
setcookie(‘fc’,$fc);
echo “$fn<br>”;
echo “$fs<br>”;
echo “$s<br>”;
echo “$bg<br>”;
echo “$fc<br>”;
?>
<!DOCTYPE html>
<html lang=”en”>
<head>
<meta charset=”UTF-8”>
<meta http-equiv=”X-UA-Compatible” content=”IE=edge”>
<meta name=”viewport” content=”width=device-width, initial-scale=1.0”>
<title>Document</title>
</head>
<body>
<form action=”ass1_a2_2.php”>
<b>Enter some Text</b>
<br>
<textarea name=’ta’ rows=”20” cols=”60”></textarea>
<input type=”submit” value=”show”>
</form>
</body>
</html>
ass1_a2_2.php
<?php
$fn=$_COOKIE[‘fn’];
$fs=$_COOKIE[‘fs’];
$s=$_COOKIE[‘s’];
$bg=$_COOKIE[‘bg’];
$fc=$_COOKIE[‘fc’];
$txt=$_REQUEST[‘ta’];
echo”<body bgcolor=$bg>”;
echo”<font color=$fc face=$fn size=$s>$txt</font>”;
echo”</body>”;
?>
ass1_a2.html
<!DOCTYPE html>
<head>
</head>
<body>
<form action=”ass1_a2_1.php”>
<b>Font name</b><br>
<select name=”fn”>
<option value=”Jokerman”>Jokerman</option>
<option value=”Ink Free”>Ink Free</option>
<option value=”Kristen ITC”>Kristen ITC</option>
</select><br><br>
<b>Font Style</b><br>
<select name=”fs”>
<option value=”Regular”>Regular</option>
<option value=”Oblique”>Oblique</option>
<option value=”Bold”>Bold</option>
</select><br><br>
<b>Size</b><br>
<select name=”s”><br>
<option value=”3”>small</option>
<option value=”5”>medium</option>
<option value=”7”>large</option>
</select><br><br>
<b>Background color</b>
<select name=”bg”><br>
<option value=”red”>red</option>
<option value=”green”>green</option>
<option value=”blue”>blue</option>
</select><br><br>
<b>Font Color</b>
<select name=”fc”><br>
<option value=”red”>red</option>
<option value=”green”>green</option>
<option value=”blue”>blue</option>
</select><br><br>
<input type=”submit” value=”Apply”>
</form>
</body>
</html>
Slip 3
Write a PHP script to accept username and password. If in the first three chances, username and
password entered is correct then display second form with “Welcome message” otherwise display
error message. [Use Session]
ass1_b1.html
<!DOCTYPE html>
<head>
<meta charset=”UTF-8”>
<meta http-equiv=”X-UA-Compatible” content=”IE=edge”>
<meta name=”viewport” content=”width=device-width, initial-scale=1.0”>
</head>
<body>
<form action=”ass1_b1.php”>
Enter Username <input type=”text” name=”uname”><br><br>
Enter Password <input type=”text” name=”password”><br><br>
<input type=”submit” value=”Login”>
</form>
</body>
</html>
ass1_b1.php
<?php
session_start();
$u=$_REQUEST[‘uname’];
$p=$_REQUEST[‘password’];
if(isset($_SESSION[‘c’]))
if($u==’admin’&& $p==’123’ && $_SESSION[‘attempt’]<=3)
echo “Welcome”;
else if($_SESSION[‘attempt’]<=3)
echo “Error occur”;
$_SESSION[‘attempt’]+=1;
else
echo “reach maximum attempt”;
else
$_SESSION[‘c’]=1;
$_SESSION[‘attempt’]=1;
if($u==’admin’&& $p==’123’ && $_SESSION[‘attempt’]<=3)
{
echo “valid”;
?>
Slip 4
Write a PHP script to accept Employee details (Eno, Ename, Address) on first page. On second page
accept earning (Basic, DA, HRA). On third page print Employee information (Eno, Ename, Address,
Basic, DA, HRA, Total) [ Use Session].
Empinfo.html
<!DOCTYPE html>
<html >
<head>
</head>
<body>
<form action=”empinfo.php”>
Employee no:<br><input type=”text” name=eno><br>
Employee name:<br><input type=”text” name=ename><br>
Adress:<br><input type=”text” name=addr><br>
<input type=”submit” value=”next”>
</form>
</body> </html>
empinfo.php
<?php
session_start();
$_SESSION[‘eno’]=$_GET[‘eno’];
$_SESSION[‘ename’]=$_GET[‘ename’];
$_SESSION[‘addr’]=$_GET[‘addr’];
?>
<form action=”showempinfo.php”>
Basic:<br><input type=”text”name=”basic”><br>
DA:<br><input type=”text”name=”da”><br>
HRA:<br><input type=”text”name=”hra”><br>
<input type=”submit” value=”next”>
</form>
showempinfo.php
<?php
session_start();
$basic=$_GET[‘basic’];
$da=$_GET[‘da’];
$hra=$_GET[‘hra’];
$eno=$_SESSION[‘eno’];
$ename=$_SESSION[‘ename’];
$addr=$_SESSION[‘addr’];
$total=$basic+$da+$hra;
echo”<br>Employee details:”;
echo”<br>Emp no: $eno”;
echo”<br>Emp name: $ename”;
echo”<br>Emp address: $addr”;
echo”<br>Basic: $basic”;
echo”<br>DA: $da”;
echo”<br>HRA: $hra”;
echo”<br>Total salary=$total”;
?>
<table border=”1”>
<th colspan=”2”>Employee details</th>
<tr><td>Employee name</td><td><?php echo”$ename”?></td></tr>
<tr><td>Employee no</td><td><?php echo”$eno”?></td></tr>
<tr><td>Employee address</td><td><?php echo”$addr”?></td></tr>
<tr><td>Basic</td><td><?php echo”$basic”?></td></tr>
<tr><td>DA</td><td><?php echo”$da”?></td></tr>
<tr><td>HRA</td><td><?php echo”$hra”?></td></tr>
</table>
Slip 5
Create XML file named “Item.xml”with item-name, item-rate, item quantity Store the details of 5
Items of different Types
Item.xml
<items>
<item>
<itemname>Pencil</itemname>
<itemrate>10</itemrate>
<quantity>3</quantity>
</item>
<item>
<itemname>Pen</itemname>
</item>
<item>
<itemname>Eraser</itemname>
</item>
<item>
<itemname>Sharpner</itemname>
</item>
<item>
<itemname>Compass</itemname>
</item>
</items>
Slip 6
Write PHP script to read “book.xml” file into simpleXML object. Display attributes and elements .
( simple_xml_load_file() function )
Book.xml
<?xml version=’1.0’ encoding =’UTF-8’ ?>
<bookstore>
<books category=”technical”>
<book_no>1</book_no>
<book_name>def</book_name>
<author_name>xxx</author_name>
<price>100</price>
<year>1990</year>
</books>
<books category=”Cooking”>
<book_no>2</book_no>
<book_name>ccc</book_name>
<author_name>aaa</author_name>
<price>200</price>
<year>1950</year>
</books>
<books category=”YOGA”>
<book_no>3
<book_name>ddd</book_name>
<author_name>zzz</author_name>
<price>150</price>
<year>2016<year>
</books>
</bookstore>
Book.php
<?php
$xml=simplexml_load_file(“Book.xml”) or die(“eror:cannot create object”);
var_dump($xml);
?>
Slip 7
Write a PHP script to read “Movie.xml” file and print all MovieTitle and ActorName of file using
DOMDocument Parser. “Movie.xml” file should contain following information with at least 5 records
with values. MovieInfoMovieNo, MovieTitle, ActorName ,ReleaseYear
<?php
$doc = new DOMDocument;
$doc->load('Movie.xml');
$movies = $doc->getElementsByTagName('MovieInfo');
foreach ($movies as $movie) {
$titles = $movie->getElementsByTagName('MovieTitle');
$title = $titles->item(0)->nodeValue;
$actors = $movie->getElementsByTagName('ActorName');
$actor = $actors->item(0)->nodeValue;
echo $title . ': ' . $actor . '<br>';
?>
Slip 8
Write a JavaScript to display message ‘Exams are near, have you started preparing for? (use alert box )
and Accept any two numbers from user and display addition of two number .(Use Prompt and confirm
box)
Add.html
<!DOCTYPE html>
<html>
<head>

</head>
<body>
<script>
alert(“Exams are near, have you started preparing for?”);
var num1 = prompt(“Enter the first number”);
var num2 = prompt(“Enter the second number”);
var sum = parseInt(num1) + parseInt(num2);
confirm(“The sum of the two numbers is “+sum);
</script>

</body>
</html>
Slip 9
Write a JavaScript function to validate username and password for a membership form
Validate.html
<!DOCTYPE html>
<html >
<head>

</head>
<body>
<script>
function validateForm(username, password) {
if (username.length < 3 || password.length < 6) {
return false;
}
else {
return true;
}
}

let username = prompt(“Please enter your username”);
let password = prompt(“Please enter your password”);

if (validateForm(username, password)) {
alert(“You have successfully logged in!”);

} else {
alert(“Sorry, your username or password was invalid.”);
}
</script>
</body>
</html>
Slip 10
Create a HTML file to insert text before and after a Paragraph using jQuery. [Hint : Use before( ) and
after( )]
Beforeafter.html
<html>
<head>
<title>jQuery Before and After</title>
<script src=”https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js”></script>
<script>
$(document).ready(function(){
$(“p”).before(“<b>Text Before Paragraph</b>”);
$(“p”).after(“<b>Text After Paragraph</b>”);
});
</script>
</head>
<body>
<p>This is a paragraph.</p>
</body>
</html>
Slip 11
Write a Javascript program to accept name of student, change font color to red, font size to 18 if student
name is present otherwise on clicking on empty text box display image which changes its size (Use
onblur, onload, onmousehover, onmouseclick, onmouseup)
<html>
<head>
<title>Student Name</title>
<script>
function changeStyle(element) {
if (element.value == “”) {
element.style.color = “”;
element.style.fontSize = “”;
document.getElementById(“image”).style.display = “block”;
document.getElementById(“image”).style.width = “100px”;
document.getElementById(“image”).style.height = “100px”;
} else {
element.style.color = “red”;
element.style.fontSize = “18px”;
document.getElementById(“image”).style.display = “none”;
}
}
</script>
</head>
<body>
<input type=”text” name=”studentname” />
<img src=”Saifanphoto.png” id=”image” style=”display:none;” />
</body>
</html>
Slip 12
Write AJAX program to read contact.dat file and print the contents of the file in a tabular format when
the user clicks on print button. Contact.dat file should contain srno, name, residence number, mobile
number, Address. [Enter at least 3 record in contact.dat file]
contact.dat file:
1,John,1234567890,0987654321,123 Main St
2,Alex,1234567891,0987654322,456 Park Ave
3,Jack,1234567892,0987654323,789 Pine St
<html>
<head>
<script>
function readData() {
var xhttp = new XMLHttpRequest();
xhttp. {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("printTable").innerHTML = this.responseText;
}
};
xhttp.open("GET", "contact.dat", true);
xhttp.send();
</script>
</head>
<body>
<button type="button" /><br />
<table id="printTable"></table>
</body>
</html>
Slip 13
Write AJAX program where the user is requested to write his or her name in a text box, and the server
keeps sending back responses while the user is typing. If the user name is not entered then the message
displayed will be, “Stranger, please tell me your name!”. If the name is Rohit, Virat, Dhoni, Ashwin or
Harbhajan , the server responds with “Hello, master !”. If the name is anything else, the message will be
“, I don’t know you!”
Demo.html
<html>
<head>
<title>Form for number input</title>
</head>
<body>
<script type="text/javascript">
function getName() {
var name = document.getElementById("name").value;
if (name == "") {
document.getElementById("response").innerHTML = "Stranger, please tell me your name!";
else {
xhttp. {
var response = this.responseText;
document.getElementById("response").innerHTML = response;
};
xhttp.open("GET", "demo.php?name=" + name, true);
xhttp.send();
</script>
<form>
Name: <input type="text" id="name" >
</form>
<div id="response"></div>
</body>
</html>
Demo.php
<?php

if (isset($_GET['name'])) {

$name = $_GET['name'];

if ($name == 'Rohit' || $name == 'Virat' || $name == 'Dhoni' || $name == 'Ashwin' || $name ==

'Harbhajan') {

echo "Hello, master!";

} else {

echo "I don't know you!";

}

}

?>
Slip 14
Create TEACHER table as follows TEACHER(tno, tname, qualification, salary). Write Ajax program to
select a teachers name and print the selected teachers details
<html>
<head>
<script>
function showTeacher(str) {
var xhttp;
if (str == "") {
document.getElementById("teacherDetails").innerHTML = "";
return;
xhttp = new XMLHttpRequest();
xhttp. {
document.getElementById("teacherDetails").innerHTML = this.responseText;
};
xhttp.open("GET", "getTeacherDetails.php?name="+str, true);
xhttp.send();
</script>
</head>
<body>
<form>
<select name="teachers" >
<option value="">Select a teacher:</option>
<?php
$con = mysqli_connect("localhost","my_user","my_password","my_db");
$sql = "SELECT tname FROM teacher";
$result = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($result)) {
echo "<option value='" . $row['tname'] ."'>" . $row['tname'] ."</option>";
mysqli_close($con);
?>
</select>
</form>
<br>
<div id="teacherDetails"><b>Details will be listed here.</b></div>
</body>
</html>
//PHP Script
<?php
$name = $_REQUEST['name'];
$con = mysqli_connect("localhost","my_user","my_password","my_db");
$sql = "SELECT * FROM teacher WHERE tname = '$name'";
$result = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($result)) {
echo "<b>Teacher Number:</b> " . $row['tno'] . "<br>";
echo "<b>Name:</b> " . $row['tname'] . "<br>";
echo "<b>Qualification:</b> " . $row['qualification'] . "<br>";
echo "<b>Salary:</b> " . $row['salary'] . "<br>";
mysqli_close($con);
?>
Slip 15
Write Ajax program to fetch suggestions when is user is typing in a textbox. (eg like google
suggestions. Hint create array of suggestions and matching string will be displayed)
<html>
<head>
<script type="text/javascript">
function suggest()
var arr = ["apple","banana","mango","orange","strawberry","grapes"];
var suggest = "";
var input = document.getElementById("txt1").value;
for(i=0;i<arr.length;i++)
if(arr[i].substring(0,input.length).toLowerCase() == input.toLowerCase())
suggest = suggest+" "+arr[i];
document.getElementById("txt2").innerHTML = suggest;
</script>
</head>
<body>
<input type="text" id="txt1" >
<p>Suggestions: <span id="txt2"></span></p>
</body>
</html>
Slip 16
Write Ajax program to get book details from XML file when user select a book name. Create XML file for
storing details of book(title, author, year, price).
BookInfo.xml
<?xml version="1.0" encoding="utf-8"?>
<BookList>
<Book>
<Title>The Great Gatsby</Title>
<Author>F. Scott Fitzgerald</Author>
<Year>1925</Year>
<Price>$7.99</Price>
</Book>
<Book>
<Title>To Kill a Mockingbird</Title>
<Author>Harper Lee</Author>
<Year>1960</Year>
</Book>
<Book>
<Title>The Catcher in the Rye</Title>
<Author>J.D. Salinger</Author>
<Year>1951</Year>
</Book>
</BookList>
Html file :
<!DOCTYPE html>
<html lang="en">
<head>

</head>
<body>

<script>
function getBookDetails(bookName) {
xhttp. {
var xmlDoc = this.responseXML;
var book = xmlDoc.getElementsByTagName("Book");
for (var i = 0; i < book.length; i++) {
if (book[i].getElementsByTagName("Title")[0].childNodes[0].nodeValue == bookName) {
alert("Author: " + book[i].getElementsByTagName("Author")[0].childNodes[0].nodeValue + "\n"

+
"Year: " + book[i].getElementsByTagName("Year")[0].childNodes[0].nodeValue + "\n" +
"Price: " + book[i].getElementsByTagName("Price")[0].childNodes[0].nodeValue);
}
}
}
};
xhttp.open("GET", "BookInfo.xml", true);
xhttp.send();
}

// Call the getBookDetails function
getBookDetails("The Catcher in the Rye");
</script>
</body>
</html>

Slip 17
Write a Java Script Program to show Hello Good Morning message onload event using alert box and
display the Student registration from.
<!DOCTYPE html>
<head>

</head>
<body>
<script>
window.>
alert(“Hello Good Morning!”);
var name = prompt(“Please enter your name: “);
var email = prompt(“Please enter your email address: “);
var contact = prompt(“Please enter your contact number: “);

alert(“Thank you for registering!\nName: “ + name + “\nEmail: “ + email + “\nContact Number: “

+ contact);
}
</script>
</body>
</html>
Slip 18
Write a Java Script Program to print Fibonacci numbers on onclick event. Write a Java Script Program to
print Fibonacci numbers on onclick event.
<html>
<head>
<title>Fibonacci Series</title>
<script type=”text/javascript”>
function ibonacci(n)
var a = 0, b = 1, c;
document.write(“<h3>Fibonacci Series till “+n+”</h3>”);
document.write(a+” “+b+” “);
for (var i = 2; i <= n; i++)
{
c = a + b;
a = b;
b = c;
document.write(c+” “);
}
</script>
</head>
<body>
<form >
Enter number:<br><input type=”text” name=n>
<input type=”button” value=”Generate Fibonacci” />
</form>
</body>
</html>
Slip 19
Write a Java Script Program to validate user name and password on onSubmit event.
Validate.html
<html>
<head>
<script>
function validate(){
var username = document.getElementById(“username”).value;
var password = document.getElementById(“password”).value;

if (username == “”){
alert(“Username cannot be empty”);
return false;
if (password == “”){
alert(“Password cannot be empty”);
return false;
}
alert(“User Name and Password Validated!”);
return true;
</script>
</head>
<body>
<form validate()”>
Username: <input type=”text” id=”username”>
<br>
Password: <input type=”password” id=”password”>
<br>
<input type=”submit” value=”Submit”>
</form>
Slip 20
create a student.xml file containing at least 5 student information
student.xml
<?xml version=”1.0” encoding=”UTF-8”?>
<Students>
<Student>
<Name>John Doe</Name>
<Age>25</Age>
<Gender>Male</Gender>
<Major>Computer Science</Major>
<GPA>3.8</GPA>
</Student>
<Student>
<Name>Jane Doe</Name>
<Age>23</Age>
<Gender>Female</Gender>
<Major>English</Major>
<GPA>3.6</GPA>
</Student>
<Student>
<Name>Jacob Smith</Name>
<Age>22</Age>
<Gender>Male</Gender>
<Major>History</Major>
<GPA>3.2</GPA>
</Student>
<Student>
<Name>Jennifer Smith</Name>
<Age>24</Age>
<Gender>Female</Gender>
<Major>Biology</Major>
<GPA>3.9</GPA>
</Student>
Slip 21
Add a JavaScript File in Codeigniter. The Javascript code should check whether a number is positive or
negative.
<!DOCTYPE html>
<head>
</head>
<body>
<script type=”text/javascript”>
function checkPositiveOrNegative(number){
if (number > 0){
alert(“The number is positive”);
} else if (number < 0){
alert(“The number is negative”);
} else {
alert(“The number is 0”);
}
}

</script>
<form >
Enter number:<br><input type=”text” name=n>

<input type=”button” value=”Check” />
</form>
</body>
</html>
Slip 22
<?php
$hostname = “localhost”; //hostname
$username = “root”; //username
$password = “”; //password
$dbname = “testdb”; //database name

//Connect to the database
$dbhandle = mysql_connect($hostname, $username, $password)
or die(“Unable to connect to MySQL”);

//Select a database to work with
$selected = mysql_select_db($dbname,$dbhandle)
or die(“Could not select testdb”);

//Create table
$sql = “CREATE TABLE student
(
rollno INT NOT NULL,
name VARCHAR(30) NOT NULL,
class VARCHAR(20) NOT NULL
)”;

$retval = mysql_query( $sql, $dbhandle );
if(! $retval )
{
die(‘Could not create table: ‘ . mysql_error());
}
echo “Table student created”;
Slip 23
Create a table student having attributes(rollno, name, class) containing atleast 5 recodes . Using
codeigniter, display all its records.
CREATE TABLE student (
rollno INT,
name VARCHAR(30),
class VARCHAR(30)
);
INSERT INTO student VALUES
(1, 'Bob', 'Sophomore'),
(2, 'Tom', 'Senior'),
(3, 'John', 'Freshman'),
(4, 'Emily', 'Junior'),
(5, 'Jordan', 'Senior');
//Codeigniter
$this->db->select('*');
$this->db->from('student');
$query = $this->db->get();
$result = $query->result_array();
foreach ($result as $row)
echo $row['rollno'].' '.$row['name'].' '.$row['class'].'<br>';
Slip 24
Write a PHP script to create student.xml file which contains student roll no, name, address, college and
course. Print students detail of specific course in tabular format after accepting course as input from
user
<?php
$course = $_POST['course'];
$xml = new DOMDocument("1.0", "UTF-8");
$xml->formatOutput = true;
$xml_student = $xml->createElement("student");
$xml_student = $xml->appendChild($xml_student);
$xml_rollno = $xml->createElement("rollno", "001");
$xml_rollno = $xml_student->appendChild($xml_rollno);
$xml_name = $xml->createElement("name", "John");
$xml_name = $xml_student->appendChild($xml_name);
$xml_address = $xml->createElement("address", "Bangalore");
$xml_address = $xml_student->appendChild($xml_address);
$xml_college = $xml->createElement("college", "ABC");
$xml_college = $xml_student->appendChild($xml_college);
$xml_course = $xml->createElement("course", "Computer Science");
$xml_course = $xml_student->appendChild($xml_course);
$xml->save("student.xml");
$xml = simplexml_load_file('student.xml');
echo "<table>";
echo "<tr>";
echo "<th>Roll No</th>";
echo "<th>Name</th>";
echo "<th>Address</th>";
echo "<th>College</th>";
echo "<th>Course</th>";
echo "</tr>";
foreach($xml->children() as $student) {
if($student->course == $course) {
echo "<tr>";
echo "<td>".$student->rollno."</td>";
echo "<td>".$student->name."</td>";
echo "<td>".$student->address."</td>";
echo "<td>".$student->college."</td>";
echo "<td>".$student->course."</td>";
echo "</tr>";
echo "</table>";
?>
Slip 25
Write a script to create “cricket.xml” file with multiple elements as shown below:
<CricketTeam>
<Team country=”Australia”>
<player>____</player>
<runs>______</runs>
<wicket>____</wicket>
</Team>
</CricketTeam>
Write a script to add multiple elements in “cricket.xml” file of category, country=”India”
#!/bin/bash
#create xml file
echo '<CricketTeam>' > cricket.xml
#add elements
echo '<Team country="Australia">' >> cricket.xml
echo '<player>___</player>' >> cricket.xml
echo '<runs>___</runs>' >> cricket.xml
echo '<wicket>___</wicket>' >> cricket.xml
echo '</Team>' >> cricket.xml

#add elements of category, country="India"
echo '<Team country="India">' >> cricket.xml
echo '<player>___</player>' >> cricket.xml
echo '<runs>___</runs>' >> cricket.xml
echo '<wicket>___</wicket>' >> cricket.xml
echo '</Team>' >> cricket.xml
echo '</CricketTeam>' >> cricket.xml
Slip 26
Create employee table as follows EMP (eno, ename, designation, salary). Write Ajax program to select
the employees name and print the selected employee’s details.
EmployeeDetails.html
<html>
<head>
<script language=”javascript” type=”text/javascript”>
function getEmployeeName()
var empName = document.getElementById(“txtName”).value;
var req = new XMLHttpRequest();

req.>
{
if (this.readyState == 4 && this.status == 200)
{
var empDetails = JSON.parse(this.responseText);
alert(“Employee Details-\n\nEmployee No: “+empDetails.eno+”\nEmployee Name:

“+empDetails.ename+”\nDesignation: “+empDetails.designation+”\nSalary: “+empDetails.salary);
}
};
req.open(“GET”, “getEmployeeDetails.php?ename=”+empName, true);
req.send();
</script>
</head>
<body>
Enter employee name: <input type=”text” id=”txtName” name=”txtName” />
<input type=”button” value=”Get Employee Details” />
</body>
</html>
getEmployeeDetails.php
<?php
$ename = $_GET[‘ename’];
$servername = “localhost”;
$username = “username”;
$password = “password”;
$dbname = “myDB”;
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die(“Connection failed: “ . $conn->connect_error);
$sql = “SELECT eno, ename, designation, salary FROM EMP WHERE ename = ‘$ename’”;
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$empDetails = array(‘eno’ => $row[‘eno’], ‘ename’ => $row[‘ename’], ‘designation’ =>

$row[‘designation’], ‘salary’ => $row[‘salary’]);
echo json_encode($empDetails);
$conn->close();
?>
Slip 27
Create web Application that contains Voters details and check proper validation for (name, age, and
nationality), as Name should be in upper case letters only, Age should not be less than 18 yrs and
Nationality should be Indian.(use HTML-AJAX-PHP)
<html>
<head>
<title>Voter Registration</title>
<script src="https://code.jquery.com/jquery-3.4.1.min.js"></script>
<script>
$(document).ready(function () {
$("#form_submit").click(function () {
var form_name = $("#form_name").val();
var form_age = $("#form_age").val();
var form_nationality = $("#form_nationality").val();
if (form_name == "" || form_name == null) {
alert("Name cannot be empty");
}
else if (/[^A-Z]/g.test(form_name)) {
alert("Name should be in Upper Case Letters only");
}
else if (form_age < 18) {
alert("Age should not be less than 18");
}
else if (form_nationality != "Indian") {
alert("Nationality should be Indian");
}
else {
$.ajax({
url: "voter_details.php",
method: "POST",
data: { form_name: form_name, form_age: form_age, form_nationality:
form_nationality },
success: function (data) {
alert(data);
}
})
}
});
});
</script>
</head>
<body>
<form>
Name: <input type="text" name="form_name" id="form_name" value=""> <br>
Age: <input type="number" name="form_age" id="form_age" value=""> <br>
Nationality: <input type="text" name="form_nationality" id="form_nationality" value=""> <br>
<input type="button" name="form_submit" id="form_submit" value="Submit">
</form>
</body>
</html>
<?php
$connect = mysqli_connect("localhost", "root", "", "voter_details");

if(isset($_POST['form_name']) && isset($_POST['form_age']) && isset($_POST['form_nationality'])){
$form_name = $_POST['form_name'];
$form_age = $_POST['form_age'];
$form_nationality = $_POST['form_nationality'];

$query = "INSERT INTO voters (name, age, nationality) VALUES('$form_name', '$form_age',

'$form_nationality')";
$result = mysqli_query($connect, $query);

if($result){
echo "Voter Details Added Successfully";
}
else{
echo "Error in Adding Voter Details";
}
}
?>
Slip 28
Write a PHP script using AJAX concept, to check user name and password are valid or Invalid (use
database to store user name and password).
<html>
<head>
<script>
function validateForm()
let userName = document.forms["myForm"]["user_name"].value;
let password = document.forms["myForm"]["password"].value;
if (userName == "" && password == "")
alert("Username and Password must be filled out");
return false;
if (userName == "")
alert("Username must be filled out");
return false;
}
if (password == "")
alert("Password must be filled out");
return false;
//AJAX Code To Submit Form.
let xhr;
if (window.XMLHttpRequest)
xhr = new XMLHttpRequest();
else if (window.ActiveXObject)
xhr = new ActiveXObject("Msxml2.XMLHTTP");
else
throw new Error("Ajax is not supported by this browser");
xhr.open('POST', 'checklogin.php', true);
xhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xhr.send("user_name=" + userName + "&password=" + password);
xhr. () {
if (xhr.readyState === 4 && xhr.status === 200) {
let response = JSON.parse(xhr.responseText);
if(response == "invalid")
alert("Invalid username or password");

}
else
alert("Login successfully");
</script>
</head>
<body>
<form name="myForm" action="" validateForm()" method="post">
Username: <input type="text" name="user_name">
<br><br>
Password: <input type="password" name="password">
<br><br>
<input type="submit" value="Submit">
</form>
</body>
</html>
<?php
//checklogin.php
$userName = $_POST['user_name'];
$password = $_POST['password'];
//connect to database
$db = new mysqli("localhost", "root", "", "users");
if($db->connect_errno > 0){
die('Unable to connect to database [' . $db->connect_error . ']');
$sql = "SELECT * FROM user_data WHERE user_name = '$userName' AND password = '$password'";
$result = $db->query($sql);
$row = $result->fetch_assoc();
if ($row)
echo json_encode("valid");
else
echo json_encode("invalid");
?>
Slip 29
Write a PHP script for the following: Design a form to accept a number from the user. Perform the
operations and show the results.
1) Fibonacci Series.
2) To find sum of the digits of that number.
(Use the concept of self processing page.)
Show.html
<html>
<head>
<title>Form for number input</title>
</head>
<body>
<form action="Show.php" method="post">
Enter a number: <input type="text" name="num" />
<input type="submit" name="submit" value="Submit" />
</form>
</body>
</html>
Show.php
<?php
if (isset($_POST['submit'])) {
$num = $_POST['num'];
echo "The Fibonacci Series up to the number $num is: <br>";
$x = 0;
$y = 1;
echo $x.' '.$y.' ';
for($i = 2; $i < $num; $i++)
$z = $x + $y;
echo $z.' ';
$x = $y;
$y = $z;
}
echo "<br><br>";
echo "Sum of the digits of the number $num is: <br>";
$sum = 0;
while($num > 0) {
$sum = $sum + ($num % 10);
$num = (int)($num/10);
echo $sum;
?>
Slip 30
Create a XML file which gives details of books available in “Bookstore” from following categories.
1) Yoga
2) Story
3) Technical
Bookcategory.xml
<?xml version="1.0" encoding="UTF-8"?>
<Bookstore>
<Yoga>
<Book>
<Book_Title>The Yoga Book: A Practical Guide to Self-Realization</Book_Title>
<Book_Author>Rajkumar Yogi</Book_Author>
<Book_Price>$14.99</Book_Price>
</Book>
<Book>
<Book_Title>The Complete Idiot's Guide to Yoga</Book_Title>
<Book_Author>Judi Warren, Larry Payne</Book_Author>
</Book>
</Yoga>
<Story>
<Book>
<Book_Title>The Cat in the Hat</Book_Title>
<Book_Author>Dr. Seuss</Book_Author>
</Book>
<Book>
<Book_Title>The Little Prince</Book_Title>
<Book_Author>Antoine de Saint-Exupéry</Book_Author>
</Book>
</Story>
<Technical>
<Book>
<Book_Title>C Programming Language</Book_Title>
<Book_Author>Brian W. Kernighan, Dennis M. Ritchie</Book_Author>
</Book>
<Book>
<Book_Title>The Art of Computer Programming</Book_Title>
<Book_Author>Donald E. Knuth</Book_Author>
</Book>
</Technical>
</Bookstore>

WT Slip Solutions

Uploaded by

Copyright:

Available Formats

WT Slip Solutions

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

WT Slip Solutions

Uploaded by

Copyright:

Available Formats

Doubt slips (7,11,12,13,14,15,16,22,23,24,25,26,27,28)

echo”<br>Welcome for the “.$_SESSION[‘c’].” times”;

echo”<br>Welcome for the first times”;

<meta http-equiv=”X-UA-Compatible” content=”IE=edge”>

<meta name=”viewport” content=”width=device-width, initial-scale=1.0”>

<b>Enter some Text</b>

<textarea name=’ta’ rows=”20” cols=”60”></textarea>

<input type=”submit” value=”show”>

echo”<font color=$fc face=$fn size=$s>$txt</font>”;

<option value=”Ink Free”>Ink Free</option>

<option value=”Kristen ITC”>Kristen ITC</option>

<input type=”submit” value=”Apply”>

<meta http-equiv=”X-UA-Compatible” content=”IE=edge”>

<meta name=”viewport” content=”width=device-width, initial-scale=1.0”>

Enter Username <input type=”text” name=”uname”><br><br>

Enter Password <input type=”text” name=”password”><br><br>

<input type=”submit” value=”Login”>

if($u==’admin’&& $p==’123’ && $_SESSION[‘attempt’]<=3)

echo “Error occur”;

echo “reach maximum attempt”;

if($u==’admin’&& $p==’123’ && $_SESSION[‘attempt’]<=3)

Employee no:<br><input type=”text” name=eno><br>

Employee name:<br><input type=”text” name=ename><br>

Adress:<br><input type=”text” name=addr><br>

<input type=”submit” value=”next”>

<input type=”submit” value=”next”>

echo”<br>Emp no: $eno”;

echo”<br>Emp name: $ename”;

echo”<br>Emp address: $addr”;

<th colspan=”2”>Employee details</th>

<tr><td>Employee name</td><td><?php echo”$ename”?></td></tr>

<tr><td>Employee no</td><td><?php echo”$eno”?></td></tr>

<tr><td>Employee address</td><td><?php echo”$addr”?></td></tr>

<?xml version=’1.0’ encoding =’UTF-8’ ?>

$xml=simplexml_load_file(“Book.xml”) or die(“eror:cannot create object”);

$doc = new DOMDocument;

foreach ($movies as $movie) {

echo $title . ': ' . $actor . '<br>';

alert(“Exams are near, have you started preparing for?”);

var num1 = prompt(“Enter the first number”);

var num2 = prompt(“Enter the second number”);

var sum = parseInt(num1) + parseInt(num2);

confirm(“The sum of the two numbers is “+sum);

function validateForm(username, password) {

if (username.length < 3 || password.length < 6) {

let username = prompt(“Please enter your username”);

let password = prompt(“Please enter your password”);

alert(“You have successfully logged in!”);

alert(“Sorry, your username or password was invalid.”);

<title>jQuery Before and After</title>

$(“p”).before(“<b>Text Before Paragraph</b>”);

$(“p”).after(“<b>Text After Paragraph</b>”);

<input type=”text” name=”studentname” />

<img src=”Saifanphoto.png” id=”image” style=”display:none;” />

2,Alex,1234567891,0987654322,456 Park Ave

var xhttp = new XMLHttpRequest();

if (this.readyState == 4 && this.status == 200) {

xhttp.open("GET", "contact.dat", true);

<button type="button" /><br />

<title>Form for number input</title>

Name: <input type="text" id="name" >
</form>
<div id="response"></div>
</body>
</html>
Demo.php
<?php

if (isset($_GET['name'])) {

$name = $_GET['name'];