Tutorial Desk

PHP-Mysql Insert by Form

2012-11-11T21:15:00.001+05:30

Mysql Insert using form

For creating dynamic pages it is so important to know how data is inserted in mysql data base.

Example --à

// save as form.php or form.html

<html>

<head><title>connection through form action</title></head>

<body>

//here we can use method=”GET”

//GET is use for passing variables through address bar whereas POST method doesn’t show any pass in url or address bar.

// form fields like input box and buttons etc...

</form>

</body>

</html>

// save as insert.php

<?php

$host=”localhost”; // variable containing hostname

$username=”root”; //variable having username

$password=””;

$dbname=”softfive”;

$tablename=”data”; // data is the table name in softfive database

mysql_connect("$host","$username","$password") or die("Unable to connect"); mysql_select_db("$dbname") or die("Unable to select database");

$name=$_POST[‘name’];

$age=$_POST[‘age’];

// receiving variable value from form.php where ‘name’ is the name of input field

$sql=INSERT INTO $tablename(Name,Age) VALUES(‘$name’,’$age’);

$queryresult=mysql_query($sql);

//passing query to variable , you can do it without passing like mysql_query($sql)

if(!qureyresult) {

echo “failed to insert please retry”;

}

else

{ echo “inserted sucessfull”;

header(‘Location:form.php’);

}

// now upload the both files to server where PHP and mysql installed and run form.php

// note: PHP is case sensitive so don’t use your own words......

PHP Database Connection

2012-11-11T21:12:00.004+05:30

MySql DB connection

Now I am going to tell You how to stabilise a connection with DB.

Syntax:

mysql_connect(nameofserver,username,password);

Exapmle

mysql_connect(“localhost”,”root”,””) or die (“not connected”);

// localhost is use for local server

You can do it by other way also

$myhost=”localhost”;

$username=”root”;

$password=””;

mysql_connect($host,$username,$password) or die (“not connected”);

NOW , How to connect with database

Syntax:

First stabilise the connection with server

mysql_connect(“localhost”,”root”,””) or die (“not connected”);

mysql_select_db(“myDb”) or die(“db not connected”);

Example:

// save as conn.php

mysql_connect(“localhost”,”root”,””) or die (“not connected”);

mysql_select_db(“myDb”) or die(“db not connected”);

echo “I hv got connected”;

PHP Post Method

2012-11-11T21:11:00.001+05:30

POST:

‘POST’ is used for the value sending . the values sent that aren’t appears in url bar.Generally used for login and security.

Here I am going to give an example try it.

// save the below given as “test.php”

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>my post method</title>

</head>

<body>

<label>Enter Name</label>  :<input name="name" type="text" />

<br />

<label> Enter Age</label>  :<input name="age" type="text" />

<br />

</form>

</body>

</html>

// save the below given as action.php

<?php

$var1=$_POST['name'];

$var2=$_POST['age'];

echo "welcome".$var1."  your age is ".$var2;

Now copy these two files to your php server and run “test.php” in browser

PHP Get Method

2012-11-08T21:14:00.000+05:30

GET

‘GET’ is used for the value sending . the values sent that are appears in url bar.

Here I am going to give an example try it.

// save the below given as “test.php”

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>my Get method</title>

</head>

<body>

<label>Enter Name</label>  :<input name="name" type="text" />

<br />

<label> Enter Age</label>  :<input name="age" type="text" />

<br />

</form>

</body>

</html>

// save the below given as action.php

<?php

$var1=$_GET['name'];

$var2=$_GET['age'];

echo "welcome".$var1."  your age is ".$var2;

Now copy these two files to your php server and run “test.php” in browser

PHP functions

2012-11-08T21:11:00.002+05:30

Functions

The beautiful of PHP is the functions of PHP. Come to the types of functions ,

Types of PHP functions, we dividing here

1)User Defined functions

2)PHP In-built Functions.

a) frequently used functions

b) less-frequently used functions

1)User Defined Functions

You can defined your function according to your use

Syntax:

// without passing argument

function myfunction()

{

echo “hello , I am in function without arguments”;

}

myfunction(); // calling the function

Outut :

Hello , I am in function without arguments

// function with argument passing

function myfunction($var)

{

return “hello ”.$var. “ Welcome in function with arguments“;

}

myfunction(“softfive”); // Calling

You can call by following methods-

i. myfunction(“softfive”);

ii. myfunction($var=”softfive”);

iii. myfunction($var); // pass the value of $var

2)PHP In-built Functions.

a) frequently used functions

b) less-frequently used functions

a) frequently used functions

$var=”hello”;

strtolower($var); // output “hello” (used for the lower case letters)

strtoupper($var); // output “HELLO” (used for the upper case letters)

md5($var); // to find hash

md5_file($file); // to file the hash of content of a file

sha1($var); // to find sha

substr($var,0,3); //output “hel”

strlen($var); // calculates the length of a string

trim(“ hello”); // output “hello” (reduces white spaces)

str_replace(“ “,”-“,”hello world”); // output “hello-world”

strcmp(“hello”,”hello”); // returns true

ucwords($var); // output “Hello”

date(“Y-m-d”); // returns the date

date(“Y-m-d H:i:s”); // returns the timestamp

b)less-frequently used functions

print_r($array); // prints the array value (mostly used for debugging purpose)

strrev($var); // output “olleh”

print // to print

echo // to print

require(//file path); // to include a file

require_once(//file path); // to include a file once

include(//file path); (Note include gives warning where as require gives error)

there are so many function that are used lessely or rarely.

PHP for-each and while Loops

2012-11-08T21:07:00.003+05:30

for-each loop

Some of us have the question that why we use for-each when we have already for loop.

So that the answer is for-each loop is used for the array, but how?

Coming to the Syntax:

foreach($arrayname as $value)

{

// code for execution

}

EXAMPLE

$myname=array(“softfive”,”soft”)

foreach($myname as $value)

{

echo $value.” , “;

}

Output

Softfive , soft

WHILE Loops

Now coming to the while loop, many of us used the while loop. The syntax of while loop is same as other programming languages like C,C#,etc.

Syntax:

while(condition)

{

// code for execution

}

Note: In case of while when the condition is true then code executed.

Do-While loop

When we are talking about while loop it is common to come do-while loop.

Syntax:

do{

// code for execution

}while(condition);

EXAMPLE

$a=1;

while($a=5)

{

++$a;

echo $a.”<br />”;

}

Output

IMPORTANT =>

Many of us have the confusion that what is the difference between ‘while’ and ‘do-while’ loop

So the main difference is

WHILE EXECUTED IF THE CONDITION IS TRUE whereas DO WHILE EXECUTED AT LEAST ONE TIME IF THE CONDITION IS FALSE.

EXAMPLE of do-while

$a=1

do{

echo $a;

}while($a=3);

Output

PHP if-else and for loops

2012-11-03T21:49:00.002+05:30

PHP Loops

Loops having a great importance in any language.
1) If-else loop:-

If-else loop used for the condition checking if condition is true then if executed otherwise else executed

Example shown below-

// loop starts

If (condition)

{

}

else

{

}

// loop ends

// Example --à loop1.php

<html>

<body>

<?php

$myname=”softfive”;

If($myname==”softfive”) {

echo “welcome”.””.”$myname”;

}else

echo “In else”;

// note : you can use nested loop

</body>

</html>

2) for loop:-

syntax of for loop is

for(initialisation ;condition ; increment or decrement)

{

// code to execute

}

Example of for loop --àloop2.php

<html>

<body>

<?php

$myname=”5”;

for($i=0 ;$1<$myname ;$++) {

echo “softfive”.” ”.”$i”;

}

echo “for loop executed”;

</body>

</html>

Variables and Operaters of PHP

2012-11-03T21:44:00.003+05:30

PHP Variables

A PHP variable starts with sign ‘$’ and variable name contains only

( _ , a-z , A-Z , 0-9 ).

(Note: PHP is a case sensitive. ‘a’ and ‘A’ are different names and don’t use spaces in variable name)

Some examples of variables are:-

$myname=”softfive”;

$_myname=”softfive”;

$1=”softfive”;

<html>

<body>

<?php

$myname=”softfive”;

echo “my name is: “ ”.” ”$myname”;

// “.” Is used for concatenation two things

</body>

</html>

PHP Operators

Now the question comes that what operators you will use in PHP

Array operators:-
1)      a==b // both have same values
2)      a+b // union of a and b
3)      a===b // checks the value types
4)      a!=b or a<>b // checks a is not equal to b
5)      a.b   // concatenation

Logical operators:-
1)      a && b // AND operator
2)      a || b // OR operator
3)      !a // NOT operator

Arithmetic operators:-
1)      a + b // add
2)      a – b //subtract
3)      a * b //multiplication
4)      a / b //division
5)      –a //minus a

Assignment operators:-

1) a=a+b

2) a=a-b

3) a=a*b

4) a=a/b

5) a=a%b

6) a=b

Other operators:-

1) ++a // pre increment

2) a++ // post increment

3) - -a // pre decrement

4) a-- //post decrement

5) a==b // comparison

6) a>b

7) a<b

8) a>=b

9) a<=b

10) a!=b

Basics of PHP

2012-11-03T21:37:00.003+05:30

PHP Basics

Before starting PHP you should know about HTML ,scripting and the basics of PHP.
Example of PHP application is www.facebook.com .

Now coming to topic,

The first question arises in your mind what is PHP and PHP stands for What?
The answer is PHP HYPERTEXT PREPROCESSOR .

PHP is server side scripting language i.e. you need a server to run the PHP code.

Now the questions comes to extension of PHP,
The extension of PHP are .phtml , .php , .php3.
You can use any of above three for PHP.

When you are concerning with web application then you should aware with the presentation of web pages that uses HTML for the presentation.
In next section we will learn loops uses in PHP.

PHP Syntax

As we know PHP is a scripting language and all the scripting language start with a tag.

PHP start with a tag <?php .....code........ ?>

(Note: don’t gap between <? And php it will be error)

The following example clears all the queries about syntax:-

i) In PHP format-

<?php

echo “Hi this is my first PHP code”;

//”echo” is user for print

// you can also use “print”

//save file as “a.php”.

ii) In HTML context

<html>

<body>

<?php

Echo “welcome in PHP </br>”;

echo “This is my first PHP code”;

</body>

</html>

//save as “name.php”.

Placement Papers

2012-11-03T21:18:00.003+05:30

Placement papers (Free Download Here)

IBM Papers

sample 1 sample 2 sample 3 sample 4

INFOSYS Papers

sample 1 sample 2 sample 3 sample 4

Note: there are mainly two rounds in Infosys first is aptitude and second is HR . Aptitude round contains two section English and quantative & reasoning. If you are not qualify in English section then your quantative section will not consider.
TCS Papers

sample 1 sample 2 sample 3 sample 4

Note: there are mainly three rounds in TCS first is aptitude ,second is TECHNICAL and third one is HR . Aptitude round contains two section English and quantative & reasoning. If you have aggregate 75 % or more in your BE/BTECH/MCA then you will directly consider for TECHNICAL.

ALL THE BEST !!!!
</div>

e-litmus Pattern and Sample

2012-11-03T21:01:00.002+05:30

Syllabus and questions of elitmus pvt Ltd

There are three section each section of 200 marks.
SECTION A-QUANTITATIVE
SECTION B-REASONING
SECTION C-VERBAL
QUANTATIVE (20 QUESTIONS)
In this section the questions like
1) 101+102+............. find the max sum upto temrs 99

2) can be answer by
If n2-n-6 =0 ,n=positive
a)n=-2
b)n=3
c)both

3) In year 2011 there are several student given the e-litmus . out of them 98 percentile student got interview call and those of them 75 % accepted their call . out of them 80% go for interview and the ratio of selection and rejection is 1:4 if there are 100 student are selected then find out the no of students appeared in e-litmus exam..(MUST)

4) If there is a cubical tank and there are 10 pipes that will used to fill and empty the tank.
If 6 pipes fill the tank in 4 hours and 7 pipes empty the tank in 2 hours. then find 9 pipes fill the tank in how much time if 3 pipes are open...
5) three questions based on following(MUST)
S G H J
G T J X
I U D X
R D K U
a) The value of D id
b) Reminder when g is dived by 2
c) Values which are lies between U and S.

6) Percentage qnd profit loss based questions

7) Questions based on number system..

8) Permutations and combinations.(MUST)
So go with a good preparation......

REASONING (20 QUESTIONS)
1)DI- tabular data with conditions 5 question
2) Arrangement ( visiting 3 villages each day, 5 villages... with lots of conditions) 3 questions
3)Coding/Decoding based on multiplication

VERBAL (20 QUESTIONS)
1)3 RC 4 question in each
2)paragraph formation
3)fill in the blank ( appropriate word)
4)grammar

GO WITH A GOOD PREPARATION....BEST OF LUCK

Download this in .doc file
click here

Amcat Pattern and Sample

2012-11-03T20:58:00.001+05:30

Overview (for CSE/IT/MCA) :

There are mainly five sections in AMCAT, these are VERBAL, QUANTATIVE, TECHNICAL (Programing output basis) , PERSONALITY, C++/JAVA/SQL. NO NEGATIVE MARKING

I)Verbal
In verbal section there are no fix number of questions these are approx 20-25 questions.

II)Quantative
In this section no fix questions its lies between 20-40 questions.

III)Technical
This section also having no fix questions lies between 20-35 programing code basis.

IV)Personality
This section is looking lengthy but its easy and no need to prepare questions are more than 60.
E.g.- U like to spread jokes between your friends-
a) very incorrect b)some incorrect c)mostly correct d)very correct.

V)Language(C++/JAVA/SQL)
This section having no fix number of questions and questions are from your selection module mostly conceptual questions are there.

NOTE: After your test there is a sheet provided to you for your telephonic interview this is machine based.

Register Here for My Amcat
Download Sample paper in .doc file
Quantative section
English Comprehension
Logical Reasoning
Computer Programing

ALL THE BEST !!!!