Skip to content

Instantly share code, notes, and snippets.

View chiragmongia's full-sized avatar

Chirag Mongia chiragmongia

3 followers · 2 following
  • Gurgaon
View GitHub Profile
@chiragmongia
chiragmongia / Exerciseform.html
Created February 20, 2013 07:19
<html>
<body bgcolor="#F0F8FF">
<h1 align="center">HTML form exercise</h1>
<p>
<font color="red">Please note: </font>
This Example demonstrates how HTML forms can be used. Submit button should
submit the button and reset button should reset the form(revert the changes
in form fields). The form layout should be the same as below.<br>
<form action="MAILTO:chiragmongia05@gmail.com" method="post;">
<b>Contact form</b><br>
@chiragmongia
chiragmongia / SQL_Exercise1
Created February 22, 2013 10:43
Part-1
desc tastes;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name | varchar(40) | YES | | NULL | |
| filling | varchar(40) | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
@chiragmongia
chiragmongia / SQL_Exercise2
Created February 22, 2013 10:51
create database vtapp;
create user 'vtapp_user'@'localhost' identified by 'pass';
grant all on vtapp.* to 'vtapp_user'@'localhost';
@chiragmongia
chiragmongia / SQL_Exercise4
Created February 22, 2013 11:21
$ mysqldump -uroot -p exercise1 > newbackup.sql;
Enter password:
mysql>create database restored;
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| exercise1 |
@chiragmongia
chiragmongia / SQL_Exercise-Alter Table
Created February 23, 2013 11:48
desc testing_table ;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| username | varchar(30) | YES | | NULL | |
| roll_no | int(5) | YES | | NULL | |
| first_name | varchar(30) | YES | | NULL | |
| last_name | varchar(30) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
@chiragmongia
chiragmongia / SQL_Exercise3
Created February 23, 2013 11:50
desc user_type;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| usertype | varchar(20) | YES | | NULL | |
| user | varchar(20) | YES | | NULL | |
+----------+-------------+------+-----+---------+-------+
desc user_category;
+----------+-------------+------+-----+---------+-------+
@chiragmongia
chiragmongia / Ruby_Exercise1
Created March 6, 2013 07:54
arr= "Ruby is scripting language".split(//)
h1 = Hash.new(0)
arr.each { |word| h1[word] += 1}
h1.each {|word, h1| puts word+"-"+h1.to_s}
@chiragmongia
chiragmongia / Ruby_Exercise2
Created March 11, 2013 12:36
def fibonacci(number)
first = 0
second = 1
while first <= number
yield first
temp = first
first = second
second = first + temp
end
end
@chiragmongia
chiragmongia / Ruby_Exercise- Replace - Regex
Created March 11, 2013 12:39
p 'Enter text'
a = gets
puts a.gsub(/[aeiou]|[AEIOU]/, '*')
@chiragmongia
chiragmongia / Ruby_Exercise4
Created March 17, 2013 17:23
def palindrome
print "Enter the string\n"
line = gets.chomp
if line.reverse == line
p "String is a palindrome!"
else
p "String is not a palindrome!"
end
end