Untitled

1a

<html>
    <head>
        <title>Fibonacci</title>
    </head>
    <body>
        <script type = text/javascript>
        function fibo(n)
        {
            var res;
            if(n==0)
            {
                res = 0;
            }
            else if(n==1)
            {
                res = 1;
            }
            else
            {
                res = fibo(n-1)+fibo(n-2);
            }
            return res;
        }
        function PrintFibo(num)
        {
            var i;
            document.write("<h2><b/><i/>The Fibonacci Series for "+a+"</h2>\n");
            for(i=0;i<=num;i++)
            {
                document.write(fibo(i) + "<br />");
            }
        }
        var a = prompt("Enter a number");
        PrintFibo(a);

        </script>
    </body>
</html>

1b


<html>
    <head>
        <title>Squares</title>
    </head>
    <body>
        <script type = "text/javascript">
            var msg = "The Number and it's squares are \n";
            var n = prompt("Enter a number");
            var i;
            for(i=1;i<=n;i++)
            {
                msg = msg+i+" - "+i*i+"\n";
            }
            alert(msg);
        </script>
    </body>
</html>

2a


<html>
<head>
    <title>USN Validation</title>
</head>
<body bgcolor="lightblue">
    <script type="text/javascript">
        function func(USN)
        {
            var pattern1=/^[1-4][A-Z]{2}[0-9]{2}[A-Z]{2}[0-9]{3}$/
            if(!USN.value.match(pattern1)||USN.value.length==0)
            {
                alert("Invalid USN")
                return false
            }
            else
                alert("USN ("+USN.value+") is Valid")
        }
    </script>
    <form action="">
            <h3> Enter Your USN Number: </h3>
            <input type="text" name="USN">
            <br />
            <br />
            <input type="submit" value="submit" onclick="func(USN)"/>
            <input type = "reset" value="reset"/>
    </form>
</body>
</html>


2b


<html>
<head>
<title>USN and Semester Validation</title>
</head>
<body bg color = "lightblue">
<script type="text/javascript">
function disp(usn,sem)
{
    var pattern1=/^[1-4][A-Z]{2}[0-9]{2}[A-Z]{2}[0-9]{3}$/
    if(!usn.value.match(pattern1)||usn.value.length==0)
    {
        alert("Invalid USN!\nEnter a valid USN")
        return false;
    }
    else
        alert("USN valid!");
    var pattern2=/^[1-8]$/
    if(!sem.value.match(pattern2)||sem.value.length==0)
    {
        alert("Invalid Semester!\nEnter a valid Semester");
        return false;
    }
    else
        alert("Semester valid!");
}
</script>
<form action="">
<pre>
Enter the Usn
<input type="text" name="usn" /> <br/>

Enter the semester
<input type="text" name="sem" /> <br/>
<input type="submit" value="submit" onclick="disp(usn,sem)" />  <input type="reset" value="reset" />
</pre>
    </form>
</body>
</html>


3a


<html>
    <head>
        <title>Stacking</title>
        <script type = "text/javascript">
        function bringThisUp(div1,div2,div3)
        {
            document.getElementById("paragraph1").style.zIndex = div1;
            document.getElementById("paragraph2").style.zIndex = div2;
            document.getElementById("paragraph3").style.zIndex = div3;
        }
        </script>
        <style type ="text/css">
        .paragraph
        {
            border: solid 4px;
            width:4in;
            height:3in;
            position:absolute;
        }
        #paragraph1
        {
            left:5in;
            top:1.5in;
            zIndex:0;
            border-color:black;
            background-color:red;
        }
        #paragraph2
        {
            left:6in;
            top:2in;
            zIndex:1;
            border-color:black;
            background-color:blue;
        }
        #paragraph3
        {
            left:7in;
            top:2.5in;
            zIndex:2;
            border-color:black;
            background-color:green;
        }
        </style>
    </head>
    <body bgcolor="white" text = "black">
    <h1>
    <div id = "paragraph1" class = "paragraph" onmouseover = "bringThisUp(2,0,1)" align = "center"><br /><br />
    This is the first paragraph
    </div>
    <div id = "paragraph2" class = "paragraph" onmouseover = "bringThisUp(0,2,1)" align = "center"><br /><br />
    This is the second paragraph
    </div>
    <div id = "paragraph3" class = "paragraph" onmouseover = "bringThisUp(0,1,2)" align = "center"><br /><br />
    This is the third paragraph
    </div>
    </h1>
    </body>
</html>


3b


<html>
    <head>
        <title>Stacking</title>
        <script type = "text/javascript">
        function bringThisUp(currDiv)
        {
            var myDiv = document.getElementById(currDiv);
            currIndex=myDiv.style.zIndex;
            myDiv.style.zIndex="3";
        }
        function sendThisBack(currDiv)
        {
            var myDiv = document.getElementById(currDiv);
            myDiv.style.zIndex=currIndex;
        }
        </script>
        <style type ="text/css">
        .paragraph
        {
            border: solid 4px;
            width:4in;
            height:3in;
            position:absolute;
        }
        #paragraph1
        {
            left:5in;
            top:1.5in;
            zIndex:0;
            border-color:black;
            background-color:red;
        }
        #paragraph2
        {
            left:6in;
            top:2in;
            zIndex:1;
            border-color:black;
            background-color:blue;
        }
        #paragraph3
        {
            left:7in;
            top:2.5in;
            zIndex:2;
            border-color:black;
            background-color:green;
        }
        </style>
    </head>
    <body bgcolor="white" text = "black">
    <h1>
    <div id = "paragraph1" class = "paragraph" onmouseover = "bringThisUp(this.id)" onmouseout = "sendThisBack(this.id)" align = "center"><br /><br />
    This is the first paragraph
    </div>
<div id = "paragraph2" class = "paragraph" onmouseover = "bringThisUp(this.id)" onmouseout = "sendThisBack(this.id)" align = "center"><br /><br />
    This is the second paragraph
    </div>
<div id = "paragraph3" class = "paragraph" onmouseover = "bringThisUp(this.id)" onmouseout = "sendThisBack(this.id)" align = "center"><br /><br />
    This is the third paragraph
    </div>
    </h1>
    </body>
</html>


4a.xml


<?xml version = "1.0"?>
<?xml-stylesheet type="text/css" href="4a.css"?>
<VTU>
    <student>
        STUDENT INFO
        <USN>1JT15CS001</USN>
        <name>Arun</name>
        <college>JIT</college>
        <branch>CSE</branch>
        <YOJ>2015</YOJ>
        <email>arun@gmail.com</email>
    </student>
    <student>
        <USN>1JT15CS002</USN>
        <name>Gopal</name>
        <college>JIT</college>
        <branch>CSE</branch>
        <YOJ>2015</YOJ>
        <email>gopal@gmail.com</email>
    </student>
    <student>
        <USN>1JT15CS003</USN>
        <name>Sanjay</name>
        <college>JIT</college>
        <branch>CSE</branch>
        <YOJ>2015</YOJ>
        <email>san@gmail.com</email>
    </student>
</VTU>


4a.css

USN
{
    display:block;
    color:blue;
    font-style:italic;
}
college
{
    display:block;
    color:green;
    font-style:italic;
}
branch
{
    display:block;
    color:red;
    font-style:italic;
}
email
{
    display:block;
    color:blue;
    font-style:italic;
}


4b.xml


<?xml version = "1.0" encoding="ISO-8889-1"?>
<?xml-stylesheet type="text/xsl" href="4b.xsl"?>
<VTU>
    <student>
        <name>Arun</name>
        <usn>1JT15CS001</usn>
        <college>JIT</college>
        <branch>CSE</branch>
        <year>2015</year>
        <email>arun@gmail.com</email>
    </student>
    <student>
        <name>Gopal</name>
        <usn>1JT15CS002</usn>
        <college>JIT</college>
        <branch>CSE</branch>
        <year>2015</year>
        <email>gopal@gmail.com</email>
    </student>
    <student>
        <name>Sanjay</name>
        <usn>1JT15CS003</usn>
        <college>JIT</college>
        <branch>CSE</branch>
        <year>2015</year>
        <email>san@gmail.com</email>
    </student>
</VTU>


4b.xsl


<?xml version = "1.0" encoding="ISO-8889-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
    <body>
        <h2>VTU Student Information</h2>
        <table border="1">
            <tr bgcolor="#99cd32">
                <th>name</th>
                <th>usn</th>
                <th>collegeName</th>
                <th>branch</th>
                <th>year</th>
                <th>email</th>
            </tr>
        <xsl:for-each select="VTU/student">
        <xsl:choose>
            <xsl:when test="name='Gopal'">
            <tr bgcolor="#ff00ff">
                <td><xsl:value-of select="name"/></td>
                <td><xsl:value-of select="usn"/></td>
                <td><xsl:value-of select="college"/></td>
                <td><xsl:value-of select="branch"/></td>
                <td><xsl:value-of select="year"/></td>
                <td><xsl:value-of select="email"/></td>
            </tr>
            </xsl:when>
            <xsl:otherwise>
            <tr>
                <td><xsl:value-of select="name"/></td>
                <td><xsl:value-of select="usn"/></td>
                <td><xsl:value-of select="college"/></td>
                <td><xsl:value-of select="branch"/></td>
                <td><xsl:value-of select="year"/></td>
                <td><xsl:value-of select="email"/></td>
            </tr>
            </xsl:otherwise>
        </xsl:choose>
        </xsl:for-each>
        </table>
        <h2>Selected student is highlighted</h2>
    </body>
</html>
</xsl:template>
</xsl:stylesheet>


5a.pl


#! /usr/bin/perl

use CGI ':standard';

print header;
print start_html("Lab 5a");
print "SERVER INFORMATION <br/><br/>";
print "Server Name = $ENV{'SERVER_NAME'} <br/><br/>";
print "Server Software = $ENV{'SERVER_SOFTWARE'}<br/><br/>";
print "Server Protocol = $ENV{'SERVER_PROTOCOL'}<br/><br/>";
print "CGI Revision = $ENV{'GATEWAY_INTERFACE'}<br/><br/>";
print end_html;


5b.html

<html>
    <head>
        <title>Lab 5b</title>
    </head>
    <body>
        <form action ="http://localhost/cgi-bin/5b.pl" method="POST">
        <h3>Enter the Unix command!</h3>
        <input type = "text" name = "cmd"/>
        <input type ="submit" value = "Execute"/>
        </form>
    </body>
</html>


5b.pl

#! /usr/bin/perl

use CGI':standard';

print header;
print start_html("Lab 5b");
$c=param('cmd');
system($c);
print end_html;


6a.html


<html>
<head><title>Lab 6a</title></head>
<body>
<form action = "http://localhost/cgi-bin/6a.pl">
<label>Enter Name: <input type="text" name="usrname"/></label>
<input type = "submit"/>
</form>
</body>
</html>


6a.pl


#! /usr/bin/perl
use CGI':standard';
print header;
print start_html("Lab 6a");
$n = param('usrname');
$range = 4;
$a = int(rand($range));
if($a == 0)
{
print "Hi ";
}
elsif($a == 1)
{
print "Hello ";
}
elsif($a == 2)
{
print "Bye ";
}
else
{
print "How are u? "
}
print $n;
print end_html;


6b.pl

#! /usr/bin/perl
use CGI':standard';
print header;
print start_html("Lab 6b");
open(FILE,'<count.txt');
$a = <FILE>;
$a++;
close(FILE);
open(FILE,'>count.txt');
print FILE "$a";
close(FILE);
print h1("Number of visiters are $a");
print end_html;


7.pl


#! /usr/bin/perl
use CGI':standard';
($s,$m,$h) = localtime(time);
$delay = 1;
print "Refresh: ", $delay, "\n";
print header;
print start_html("Lab 7");
print "Time = $h:$m:$s";
print end_html;


8.html


<?xml version="1.0" encoding="UTF-8"?
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www/w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
    <body>
        <form action="http://localhost/cgi-bin/8.pl" method="post">
            <table>
                <tr>
                    <td>Enter your name </td> <td><input type="text" name="name"></td>
                </tr>
                    <td>Enter your age </td> <td><input type="text" name="age"></td>
                </tr>
                <tr>
                    <td>Click here to send </td> <td><input type="submit" value="Send"></td>
                </tr>
            </table>
        </form>
    </body>
</html>


8.pl


#! /usr/bin/perl
print "Content-type: text/html\n\n";
print "<HTML><TITLE>Result of the insert operation </TITLE>";
use CGI ':standard';
use DBI;
$dbh=DBI->connect("DBI:mysql:db8","root","jit123");
$name=param("name");
$age=param("age");
$qh=$dbh->prepare("insert into tb values('$name','$age')");
$qh->execute();
$qh=$dbh->prepare("select * from tb");
$qh->execute();
print "<table border size=1><tr><th>Name</th><th>Age</th></tr>";
while ( ($name,$age)=$qh->fetchrow())
{
       print "<tr><td>$name</td><td>$age</td></tr>";
}
print "</table>";
$qh->finish();
$dbh->disconnect();
print"</HTML>";


9.php


<?php
$inTwoMonths = 60*60*24*60+time();
setcookie('lastVisit',date("h:i:s A - m/d/y"), $inTwoMonths);
if(isset($_COOKIE['lastVisit']))
    $visit=$_COOKIE['lastVisit'];
else
    echo "You've got some expired cookies!";
echo "Your last visit was - ". $visit;
?>


10.php

<?php
session_start();
if(isset($_SESSION['views']))
    $_SESSION['views']=$_SESSION['views']+1;
else
    $_SESSION['views']=1;
echo "Page views = ".$_SESSION['views'];
?>


11.html


<html>
<head>
    <title>HTML, PHP and MySQL</title>
</head>
<body>
    <h3>    Enter information</h3>
    <form action="http://localhost/akshay11a.php" method="POST">
        <pre>
Name
<input type="text" name="name" />

Address 1
<input type="text" name="address1" />

Address 2
<input type="text" name="address2" />

E-mail
<input type="text" name="email" />

<input type="submit" value="Submit" />  <input type="reset" value="Clear" />
        </pre>
    </form>

    <form action="http://localhost/akshay11b.php" method="POST">
        <pre>
Enter the name
<input type="text" name="name" />

<input type="submit" value="Submit" />
        </pre>
    </form>
</body>
</html>


11a.php


<?php

$name=htmlspecialchars($_POST['name']);
$address1=htmlspecialchars($_POST['address1']);
$address2=htmlspecialchars($_POST['address2']);
$email=htmlspecialchars($_POST['email']);

$connection = mysql_connect("localhost", "root", "jit123") or die(mysql_error());
mysql_select_db("akshay") or die(mysql_error());
$sql = "insert into user(name, addr1, addr2, email) values ( '$name', '$address1', '$address2', '$email');";

mysql_query($sql) or die(mysql_error);
echo "Values inserted";

?>


11b.php


<html>
<body>


<?php

$name=htmlspecialchars($_POST['name']);

$connection = mysql_connect("localhost", "root", "jit123") or die(mysql_error());
mysql_select_db("akshay") or die(mysql_error());
$sql = "select * from user where name like '$name%';";

$result = mysql_query($sql) or die(mysql_error);
?>

<table border="1">
<tr><th>Name</th><th>Address 1</th><th>Address 2</th><th>E-Mail</th></tr>

<?php

while($cols=mysql_fetch_row($result))
{
    echo "<tr>
            <td>$cols[0]</td>
            <td>$cols[1]</td>
            <td>$cols[2]</td>
            <td>$cols[3]</td>
            </tr>";
}

?>
</table>
</body>
</html>


12


## Program 12:
### Build a Rails application to accept book information viz. Accession number, title, authors, edition and publisher from a web page and store the information in a database and to search for a book with the title specified by the user and to display the search results with proper headings.
***

### Procedure for execution:

* Open a terminal and run `mkdir rails_app && cd $_`
* Create a new app called books using the command `rails new books -d mysql`
* Run the command `cd books/config` and open the database.yml file to set mysql username and password by running the command `nano database.yml`. The *username* and *password* are required to be filled at 3 sections in the file.
* The following is a sample snippet from the database.yml file-

     adapter: mysql2
     encoding: utf8
     reconnect: false
     database: books_development
     pool: 5
     username: root
     password: pass
     socket: /var/run/mysqld/mysqld.sock

* Save the file by `ctrl+x` and then `y`.
* Now run `cd ..` and make sure that you are present in the `rails_app/books` directory.
* Run the command `rake db:create`
* Next, run `rails generate controller books index`
* Next, run `rails generate model book access_no:integer title:string author:string edition:integer
publisher:string`
* Run `rake db:migrate`
* Now, `cd app/views/books` and edit the file `nano index.html.erb` -

* Also, edit the file `nano search.html.erb`
* Now, `cd ../../controllers` and edit the file `nano books_controller.rb`
* Next, run `cd ../../config` and edit `nano routes.rb` file.
* Finally, run `cd ..` and start the rails server by running the command `rails s`
* Open a browser and in the address bar type `localhost:3000` to check if the rails server is running. If yes, add to the URL, `localhost:3000/books/index`.
* Enter the input & on successfully inserting data, search for the same from the browser. The output is displayed in a table on the browser.

###Explaination

* The rails new command has created a Rails application in a new directory called books
* The -d options in the rails new command allows us to specify which DBMS to use. The default is sqlite. However we use mysql
* The database.yml file has all the cofiguration information which allows our application to connect, create and modify the database
* You run rake db:create once and only once, and you run it first. Then you run rake db:migrate every time you add/change a migration
* The rails generate controller command created a lot of files and directories. We are interested in two of them for now :-
    * app/controllers/books_controller.rb
    * app/views/books/index.html.erb
* Inside Rails application, the controller file is placed inside app/controllers directory
* ####The Controller
    * User types a URL, lets say http://localhost:3000/pages/home. If the Rails server is running, the request first reaches the Rails router.
    * ![Alt text](./l6_block_dia_vc.png)

    * The Router checks the config/routes.rb file to see if there is an entry matching the URL requested. In our case there is a route entry - get "pages/home". In short, the route matches incoming URL `/pages/home` to home action in Pages controller. So the request is forwarded to the Pages controller, home action.

    * ![Alt text](./l5_pages.png)


    * In our program the BooksController is a class. Intially there is an empty method index inside the class. The method is also called index action in the Books controller.

                class BooksController < ApplicationController

                def index

                end

    * This action serves the url /books/index when accessed. Even though the index action is an empty method, it fetches the file /apps/views/books/index.html.erb and displays it on the browser.

* ####The Model
    * Rails interact with the database through models. In our program we have a model called Book. This ensures that the our model is independent of the DBMS
    * When you create a model, the name is singular and the name starts with capital letter. Book, instead of Books
    * In our model we have the following attributes

        * access_no:integer
        * title:string
        * author:string
        * edition:integer
        * publisher:string

    * The `rails generate model` command also creates a migration file present under db/migrate
    * The migration file is like schema which defines the database table structure
    * rake db:migrate pushes the database changes from the migration file to the actual database
    * If you end up doing a mistake you can always undo the creation of a model using

                   rails destroy model Book

    * If you want to delete the database from the DBMS once the model has been migrated use

                    rake db:rollback
* ####Ruby Tags
* RoR has the following 2 tags :
    * <% %> : The output of this tag will NOT be displayed on the browser
    * <%= %> : The output will be displayed on the browser
###Code:
* **index.html.erb**
```erb
    <h1>Books</h1><br>
    <h3 style="text-align: center;">Add a book</h3><br>
    <%= form_tag("/books/add", :method=>"post") do %>
    <form action="/books/add" method="post"> <br>
    Access No:<%= text_field_tag(:b_access_no) %>
    //create input tags of given type and id
    <input type="text" id=":b_access_no"><br>
    <br>Title: <%= text_field_tag(:b_title) %>
    <input type="text" id=":b_title"><br>
    <br>Author: <%= text_field_tag(:b_author) %>
    <input type="text" id=":b_author"><br>
    <br>Edition: <%= text_field_tag(:b_edition) %>
    <input type="text" id=":b_edition"><br>
    <br>Publisher: <%= text_field_tag(:b_publisher) %>
    <input type="text" id=":b_publisher"><br>
    <br><br>
    <%= submit_tag("Add Book") %>
    <input type="submit" value="Add Book"><br>
    <% end %>
    <br>
    <h3 style="text-align: center;">Search for a book</h3><br>
    <%= form_tag("/books/search", :method=>"post") do %>
    <form action="/books/search" method="post"><br>
    Title: <%= text_field_tag(:bs_title) %>
    <input type="text" id=":bs_title"><br>
    <br><br>
    <%= submit_tag("Search") %>
    <input type="submit" value="Search"><br>
    <% end %>
    <br>
```

* **search.html.erb**
```erb
    <h1>Search Result</h1><br>
    <table border=1><br>
    <% @t=Book.find_by_title(params[:bs_title]) %>
    //RoR creates a find_by_attribute method for our model. In our case we are asked to search by title hence we are using the find_by_title function. This function takes a string as parameter. Here we are using the the value in :bs_title that was passed on using post method when the button was pressed. This function returns an array. Arrays in ruby begin with the '@' symbol
    <br>
    <tr><br>
    <th>Access No.</th><br>
    <th>Title</th><br>
    <th>Author</th><br>
    <th>Edition</th><br>
    <th>Publisher</th><br>
    </tr><br>
    <tr><br>
     //Elements of an array are accessed by the "." operator followed by the attribute name.
     //In our case we are accessing the access_no that was returned to the array t.
    <td> <%=  @t.access_no %> </td>
    <td> <%= @t.title %> </td>
    <td> <%= @t.author %> </td>
    <td> <%= @t.edition %> </td>
    <td> <%= @t.publisher %> </td>
    </tr><br>
    </table><br>
    <br><br><br>
    <a href="/books/index">Back</a>
    <br>
```
* **books_controller.rb**
```ruby
    class BooksController < ApplicationController
    //auto-generated  code
    def index
    //auto-generated  code
    end
    //auto-generated  code<br>
    def add
    //create a new action called add which performs the below action
    Book.create(:access_no=>params[:b_access_no],:title=>params[:b_title],:author=>params[:b_author],:edition=> params[:b_edition],:publisher=> params[:b_publisher])
    //the create method is used to add a vlaue to the DB. The values to be added are fetched from the post method using the param function
    redirect_to :action => 'index'
    //once the add button is clicked this specifes which page is to be displayed.Here the index page is redisplayed
    end
    def search
    //defines the search action. Just displayes search.html.erb on browser
    end
    end
```
* **routes.rb**
```ruby
    Books::Application.routes.draw do
    //auto generated code
    match "books/index" => "books#index", :as => :index
    //use the action defined under index when request for /books/index is recieved<br>
    match  "books/add" => "books#add", :via => :post
    //use action defined under add when request for books/add is recieved via post method<br>
    match  "books/search" => "books#search", :via => :post
    //use action defined under search when request for books/search is recieved via post method<br>
```