Insert record in Database

This post will help you to learn the basics of inserting the record in the database using ci framework.

Table Structure

Culumn_Name	Data_type
Id	Auto number(int)
Name	Varchar(50)
Email	Varchar(50)
Phone	Varchar(15)
Msg	Varchar(255)

Configure Database

Goto App (Application in older CI) folder then open Config folder then Database.php file change db parameter as per your configuration. 

Database.php 

$db['default'] = array(
       'dsn' => '',
       'hostname' => 'localhost',
       'username' => 'username',
       'password' => 'password',
       'database' => 'db_name',
       'dbdriver' => 'mysqli',
       'dbprefix' => '',
       'pconnect' => FALSE,
       'db_debug' => (ENVIRONMENT !== 'production') ,
       'cache_on' => FALSE,
       'cachedir' => '',
       'char_set' => 'utf8',
       'dbcollat' => 'utf8_general_ci',
       'swap_pre' => '',
       'encrypt' => FALSE,
       'compress' => FALSE,
       'stricton' => FALSE,

File upload with new name (PHP)

This post will help you to upload an image file to server with A new name . File name will be database auto increment field value . So no name conflict will be arise.

function SaveSliderImage($file)
{

$stmt = $this->conn->stmt_init();
if ($stmt->prepare("insert into  ueks98_si_jsj_os9 (id,id1,id2)   values(NULL,?,?)"))
{
//Get File Extension
$tmpstr=strtolower($_FILES[$file]['name']);
$extnsn=end(explode(".",$tmpstr));

Show file on HTML page using file control

This post will help you to show preview of selected file from html file control because by default HTML file control only show the selected file name. So file preview is best way to show user that whether he is selected right file or not.

HTML

<input type="file" id="bfile" id="bfile" class="form-control" accept="image/x-png,image/jpeg" onChange="readURL(this)">

<br><img id="blah" style="margin:auto;display:block" />

JS

function readURL(input) {

  

Solved : July, 2010 M4.2-R4: INTRODUCTION TO MULTIMEDIA

1. Multiple Choice

1.1 : D
1.2 : D
1.3 : A
1.4 : A
1.5 : C
1.6 : C
1.7 : C
1.8 : B
1.9 : C
1.10: B

Solved : January, 2011 M4.2-R4: INTRODUCTION TO MULTIMEDIA

1. Multiple Choice

1.1 : A

1.2 : D

1.3 : C

1.4 : B

1.5 : A

1.6 : D

Core Java series Programs

Q 1  : Write a program to print sum of following series of given terms ?

Terms=5
Series = (1)+(1+2)+(1+2+3)+(1+2+3+4) + (1+2+3+4+5)
Sum=35

Solution :  

Using Nested Loop 

import java.util.*;
class nextedloop
{
 
    public static void main(String args [])
    {

Compare of core java nested loop

This is will show you to compare of all three types of loops (while,do-while and for) and print a triangle pattern.

import java.util.*;

public class star

{

    

    static void sop(String ar)

    {

        System.out.println(ar);

    }

   public static void main(String args[])

   {

       int i,j,k;

       Scanner sc=new Scanner(System.in);

Pascal Triangle

Q: Write a program to make pascal triangle ?

Answer :

Pascal Triangle :

Pascal's Triangle is more than just a big triangle of numbers. There are two major areas where Pascal's Triangle is used, in Algebra and in Probability / Combinatorics.

Rule 

Get multiple list using single object

MVC transfer data from controller to list in the form of list. If a page needs to load multiple lists using razor then you will have to wrap multiple lists into single object list. Following code will help you to accomplish this.

Modal

public class MarketingStaffModal

   {

      public string  ID  {get;set;}

       public string Name {get;set;}

      

   }

Jquery Radio button operations

Check selected radio button

HTML

<input type="radio" value="Active" checked name="rdostatus" />Active

HTML inside if

HTML example for Radio button  inside of if-else using C# MVC

Code :

  @if(@Model.Status=="1")

  {

       @:<input type="radio" value="Active" checked name="rdostatus" />Active

July, 2011 M4.2-R4: INTRODUCTION TO MULTIMEDIA

1. Multiple Choice

1.1 : A
1.2 : D
1.3 : C
1.4 : B
1.5 : C
1.6 : A
1.7 : B
1.8 : D
1.9 : A
1.10 : A

2. True/False

2.1 : T
2.2 : T
2.3 : F
2.4 : F
2.5 : F
2.6 : F
2.7 : F
2.8 : F
2.9 : T
2.10 : F

3. Match the column

3.1 : F
3.2 : M
3.3 : I
3.4 : K
3.5 : B
3.6 : D
3.7 : L
3.8 : C
3.9 : E
3.10 : G

4. Fill in the Blanks

4.1 : I
4.2 : D
4.3 : H
4.4 : K
4.5 : G
4.6 : M
4.7 : E
4.8 : F
4.9 : A
4.10 : B

Next Set

Last Created Store Procedure SQL Server

SELECT * FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_TYPE = N'PROCEDURE' and ROUTINE_SCHEMA = N'dbo'

order by last_altered desc

Next Query

Solved : January, 2012 M4.2-R4: INTRODUCTION TO MULTIMEDIA

Multiple Choice

1.1 : C
1.2 : A
1.3 : D
1.4 : A

Get input type file size in KB

HTML

<input type="file" class="upload" onchange="readURL(this)" id="file" accept="image/x-

png,image/jpeg" />

<input type="button" value="Upload" class="btn btn-default" style="margin:auto;display:block" onclick="checksize(this)" />

Java Script

Get File Name in JavaScript:

document.getElementById('file').files[0].name

Get File Size in JavaScript:

Alter Table SQL Server

Making Unique key

Syntax :

alter table your_table add constraint constraint_Name  unique(yourcolumn);

2013 M4.2-R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice

1.1 : A

1.2 : C

1.3 : B

1.4 : C

1.5 : A

1.6 ; B

1.7 : A

1.8 : A

Jquery Preloader

Girfa Student Help

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specim

Solved July, 2013 M4.2-R4: INTRODUCTION TO MULTIMEDIA

1  Multiple Choice

1.1 : D
1.2 : B
1.3 : A
1.4 : D
1.5 : D
1.6 : A

1.7 : D
1.8 : A
1.9 : D
1.10 : B

2 True/False

2.1 : T
2.2 : T
2.3 : T

January, 2014 M4.2-R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice

1.1 : B
1.2 : A
1.3 : B
1.4 : C
1.5 : B
1.6 : D
1.7 : A

HTML Tag CSS

<a> style change

    a.menu:link {color:black;}      /* unvisited link */

    a.menu:visited {color:black;}  /* visited link */

    a.menu:hover {color:#CCFF99;}  /* mouse over link */

    a.menu:active {color:yellow;}  /* selected link */

    a.menu:link{text-decoration: none} /* Hide Underline of link */

Example : <a class="menu">Link test</a>

Next Example

Setup locale date time zone

SQL server saves date in local region format, for example if you’re in india and hosting your site with godaddy and choose Asia server then your date will be 12 hour forward compare to current region.

July, 2014 M4.2- R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice

1.1 : C

1.2 : A

1.3 : C

1.4 : B

1.5 : C

1.6 : C
1.7 : A
Explanation : Old 2D cel animation and stop-motion animation both fall under the category of traditional animation,  both may use digital methods of filming in the end. The matters is the method of producing the animation itself. Cel animation uses hand-drawing, hand-inking, and hand-painting thousands of frames on clear cels that are displayed against painted backgrounds and photographed in rapid sequence, on the other end stop-motion animation involves working with physical models and objects captured on camera one frame at a time.

This hands-on method requires a team of artists, cleanup artists, painters, directors, background artists, and camera crews, along with the storyboard artists and scriptwriters to work out the original concepts. For large-scale projects, the amount of time, labor, and equipment involved is staggering.

1.8 : B

January 2015 M4.2-R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice

1.1 : D
1.2 : A
1.3 : C
1.4 : A
1.5 : B
1.6 : B

July, 2015 M4.2-R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice

1.1 : C
1.2 : D
1.3 : A
1.4 : D

M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN-July-12 Solved

Multiple Choice

1.1 : A
1.2 : B
1.3 : D
1.4 : A
1.5 : A
1.6 : D
1.7 : B
1.8 : C

M2-R4 INTERNET TECHNOLOGY AND WEB DESIGN-Jan-13 Solved

Multiple Choice

1.1 : C
1.2 : C
1.3 : B
1.4 : A
1.5 : B
1.6 : D
1.7 : D
1.8 : C
1.9 : B
1.10 : D

Input type pattern

Form tag is one of the key tags of HTML through which users data are sent on server. While making a form there are lots of validation implemented to allow valid data only. As a developer we all know about importance of validation and we do lots of JS code for validation. Working with JS is not an easy task for beginner.

HTML 5 introduce built in validation using regular expression using pattern property. If you are using patter regular expression then this will save your time and it is supported by all model browsers. So using pattern, you do not to worry about browser compatibility.

Following code will help you to understand basics of pattern. Ones you will implement basics then after using regular expression you will be able to implement complicated validation rule.

Name :

Six Digit Pin :

Email :

INTERNET TECHNOLOGY AND WEB DESIGN July, 2013 Solved

Multiple Choice

1.1 : C
1.2 : B
1.3 : B
1.4 : B
1.5 : C

M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN January, 2014 Solution

Multiple Choice

1.1 : D
1.2 : C
1.3 : C
1.4 : A
1.5 : A
1.6 : C

Solved July, 2014 M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN

Multiple Choice

1.1 : B
1.2 : C
1.3 : B
1.4 : A
1.5 : C
1.6 : B

Solved July, 2015 M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN

Multiple Choice

1.1 : C
1.2 : A
1.3 : B
1.4 : D
1.5 : C
1.6 : A
1.7 : A
1.8 : C

Solved January, 2015 M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN

Multiple Choice

1.1 : C

1.2 : A

Explanation : Shortest Seek Time First

1.3 : D

Explanation : 

Seek time: Say you're reading some data from the (0,4). You receive instructions to read from track (2,5). The time it takes for you to move from track 0 to track 2 is seek time.

M1-R4: IT TOOLS AND BUSINESS SYSTEMS July 2011 Solution

Multiple Choice

1.1 : A
1.2 : B
1.3 : B
1.4 : A
1.5 : C
1.6 : D
1.7 : D

Paper IT Tools and Business Systems January 2011 Solution

Multiple Choice

1.1 : D
1.2 : D
1.3 : B
1.4 : A
1.5 : D
1.6 : B
1.7 : B

IT Tools and Business Systems -July-2010 Solution

Multiple Choice

1.1 : B
1.2 : B
1.3 : B
1.4 : D
1.5 : B
1.6 : A
1.7 : B
1.8 : A
1.9 : C

IT TOOLS AND BUSINESS SYSTEMS Jan-12 Solved

Multiple Choice

1.1 : B
1.2 : B
1.3 : C
1.4 : D
1.5 : C
1.6 : A
1.7 : B

July, 2012 M1-R4: IT TOOLS AND BUSINESS SYSTEMS Solution

Multiple Choice

1.1 : D
1.2 : D
1.3 : D
1.4 : D
1.5 : D

Paper M1-R4: IT TOOLS AND BUSINESS SYSTEMS-jan-13 Solution

Multiple Choice

1.1 : A
1.2 : C
1.3 : B
1.4 : D
1.5 : A
1.6 : B
1.7 : D
1.8 : A
1.9 : D
1.10 : C

July, 2013 M1-R4: IT TOOLS AND BUSINESS SYSTEMS Solution

Multiple Choice

1.1 : C
1.2 : D
1.3 : B
1.4 : C
1.5 : A
1.6 : D
1.7 : C
1.8 : B
1.9 : B
1.10 : C

CSS Selector

This page will help you to learn how you can user CSS on various types of HTML tag. If you have knowledge of CSS selector then you can make big changes of fo

July-2014 M1-R4: IT TOOLS AND BUSINESS SYSTEMS Answer

Multiple Choice

1.1 : C

1.2 : B

1.3 :  D

1.4 : B

1.5 : D

1.6 : D

Image zoom inside of div

HTML

<div class="con">

<img src="1.jpg" class="test"/>

</div>

CSS

.test

{

       height:200px;

       width:200px;

Solution : July, 2015 M1-R4: IT TOOLS AND BUSINESS SYSTEMS

Multiple Choice :

1. D
2.C
3.D
4.:A
5:C

6: B

import multiple CSS using single link

CSS file

File A1

.r1

{

       color:red;

}

File A2

.r2

{

       color:green;

}

File A3

.r2

Get Date Time (dd/mm/yyyy)

<script>

       var d = new Date();

       document.write(d.getDate() + '/' + (d.getMonth() + 1) + '/' + d.getFullYear());

Rules to declare a valid variable

List out the rules to declare a valid variable in ‘C’ program. Evaluate the following expression and show the hierarchy of operations:
( 2 + 4 ) / 3 + 2%3 * 2 – 5

Solution : 

Read List out the rules to declare a valid variable 

Expression Solve Steps

• (2+4)/3+2%3*2-5
• 6/3+2%3*2-5

Humanoid Robot MBA Project

Humanoid
Robot

Table of Content

    1. Acknowledgement

    2. Certificate

    3. Student  declaration

    4. Introduction

Structure Programming

Structure programming is a programming approach in which all the programming task is achieved through function/Methods that is sometimes it’s called modular programming. Structure programming uses procedure approach to solve a program using top down methodology. 

One big advantage of structure programming language is simplicity because we have to design programming task in modules which are connected to each other and can be called from any functions. We have all the modern powerful programming stuff like loop, switch-case, if-else etc that help to reduce the uses of goto statement because goto statement makes our program unstructured due to random move to any other statements.

While Loop with example

Q : Write and explain the action of WHILE statement. Develop a program in ‘C’ language to compute the average of every third integer number lying between 1 and 100. Include appropriate documentation.

Solution : 

While Loop

Array Input using function

A, B and C are three 3x3 matrices containing real elements. Write a ‘C’ function to input from user appropriate values into matrices A and B. Use suitable loops. Make use of pointers if necessary.

Solution : 

/*==============================

Girfa Student Help

Program : 3x3 Array input using function

More Program : http://girfahelp.blogspot.in/p/2-d-array-programming.html

================================*/

#include<stdio.h>

#include<conio.h>

#define MAX 3

void input(int [][MAX]);

void print(int [][MAX]);

HTML Sample Paper

Internet & Web Design (HTML)

Note : each Question carry one marks of part and only three question need to attempt in part two, each carry 10 marks . No negative marks penalty for wrong answer.

Name : __________________                                                                                                                   Time : 45  Minute

Part 1

Multiple Choice

1. ………. Is Self-close tag .
A) strong   B) pre   C)img   D) None

2. Each property of HTML tag is separated by
A) Double quote   B) Single quote   C) /   D)None

3.  Special character code in HTML start with ….
A) &    B)@     C)#    D)None

4.  tag doesn't usually appear in your document. But identify the page's author, keywords used for searching.
A) <head>    B) <title>   C) <meta>    D)<script>

5. Which of the following is odd one for a form.

Structure sorting,searching with array

Define a structure that describes a hotel. It should have members that include the name, address, grade, average room charge and number of rooms.

Write a function to perform the following tasks.

i) To print all hotels details of a given grade in order of charges.
ii) To print hotel details with room charges less than given values.

Solution :

/********************************

     Program : Structure sorting,searching with array

     for more program visit :http://girfahelp.blogspot.in/p/c-language-structure-programming.html

**********************************/

#include<stdio.h>

#include<conio.h>

#include<string.h>

#define MAX 10

typedef struct ht

{

     char name[30];

     char address[40];

     char grade;

     int room;

     int charge;

}hotel;

void input(hotel*,int);

void print(hotel *);

void printbyRate(hotel *,int,int);

void printByGrade(hotel *str,char,int s);

void main()

{

     int i,opt,rate;

     hotel rec[MAX];

     char ch;

     clrscr();

     printf("How many record you want to insert>> ");

     scanf("%