Import Data from excel to MySQL

If you want to Import data to MySQL table from excel sheet, then follow the following instructions.

Example:

-Your excel sheet as:

rollno name marks
1 vanesh  78
2 ganesh  88
3 ramlal  70
4 ramesh  68


-Create mysql table student, contaiing follwing colums:

rollno
name
marks

-Save table. now your table created.
-Go to excel sheet, remove first row. i.e.
rollno name marks

-and save excel sheet as .csv file
 (make sure your file is saved as .csv extension for example student.csv)

-Now go to your PhpMyadmin
-Select your table
-Click on Import
-Choose File
-Click on GO Button.

--Your excel data is now imported successfully.

-Check it by clicking on Browse.

I think, it may helps you.

Expecting your feedback. 

(Article Submitted By --Vanesh Mali, SOFTWARE ENGINEER @Pune)



How to print particular Div using Javascript






While working in a web page, we were required to print only one section (say a div content) of a page.
There is a single line Javascript code to do printing:

"window.print();"

However, this function would print the whole page content, which is not what we want.


Solution:-
Example:
<!-- HTML CODE-->

<html><head><title>print</title> </head><body>


<div id="divPrint">

    <h1>This is content to print</h1>

</div>
<a onClick="javascript:printDiv()">Print</a>


<div id="notPrint">

    <h1>No need to print</h1>
</div>


   
</body></html>


<!--END HTML CODE-->


<!--javascript code to print perticular div-->


<script>

function printDiv()
        {
            var divElements = document.getElementById('divPrint').innerHTML;
                    var oldPage = document.body.innerHTML;

                    document.body.innerHTML ="<html><head><title>print</title> </head><body>"+divElements+"</body></html>" ;

                    window.print();

                    document.body.innerHTML = oldPage;

            }
</script>

<!-- END javascript code to print perticular div-->






Explaination:

<a onClick="javascript:printDiv()">Print</a>
when we click on Print link (hyperlink) javascript printDiv function will called and print window will opened.

printDiv() :
Use this function where ever you want the function to print the part of the page.

var divElements:
In this example, divElements, oldPage are variables.
JavaScript variables are containers for storing data values.

getElementById():
The getElementById() method returns the element that has the ID attribute with the specified value.
This method is one of the most common methods in the HTML DOM, and is used almost every time you want to manipulate, or get info from, an element on your document.
Returns null if no elements with the specified ID exists.


innerHTML:
The innerHTML property sets or returns the HTML content (inner HTML) of an element.
An ID should be unique within a page. However, if more than one element with the specified ID exists, the getElementById() method returns the first element in the source code.

window.print():
Prints the current page.
The print() method prints the contents of the current window.
The print() method opens the Print Dialog Box, which lets the user to select preferred printing options.





Urgently Required PHP Developer for Hyderabad






Position Name : PHP Developer.
Location : Hyderabad
Criteria : Minimum 0.6+ year Exp.
Salary : Rs. 15,000/- per month + Depends upon your interview
Interested Candidates forward your CV on jobs@itgateway.co.in & mention in subject line Apply for PHP Developer For Hyderabad .






Learn PHP : Hour 1






What is PHP?
PHP is a powerful scripting language that fits gracefully into HTML and puts the tools for creating dynamic websites in the hands of the people — even people like me who were too lazy to learn Perl scripting and other complicated backend hoodoo.


PHP is an acronym for "PHP: Hypertext Preprocessor"
PHP is a widely-used, open source scripting language
PHP scripts are executed on the server
PHP is free to download and use



Basic PHP Syntax:
A PHP script can be placed anywhere in the document.

A PHP script starts with
<?php
 and ends with
 ?>



<?php
// PHP code goes here
?>

The default file extension for PHP files is ".php".

A PHP file normally contains HTML tags, and some PHP scripting code.


First Simple Program:

<html>
    <head>
        <title>Example</title>
    </head>
    <body>

        <?php
            echo "Welcome to PHP";
   //echo is used for printing
        ?>

    </body>
</html>


Output to the Browser:
Welcome to PHP


Note: PHP statements end with a semicolon (;).






Comments in PHP:
A comment in PHP code is a line that is not read/executed as part of the program. Its only purpose is to be read by someone who is looking at the code.

Comments can be used to:

Let others understand what you are doing
Remind yourself of what you did - Most programmers have experienced coming back to their own work a year or two later and having to re-figure out what they did. Comments can remind you of what you were thinking when you wrote the code

PHP supports several ways of commenting:

Example:
<html>
<body>

<?php
// This is a single-line comment


/*
This is a multiple-lines comment block
that spans over multiple
lines
*/

// You can also use comments to leave out parts of a code line
$x = 5 /* + 15 */ + 5;
echo $x;
?>

</body>
</html>

Output to the Browser:
10





Most Important iOS Interview Questions:






1.What is latest iOS version?
2.What is latest Xcode version?
3.What is latest mac os version , and tell the Mac os Name as well?4.What is iPad screen sizes?
5.what is iPhone screen sizes?
6.What are the features is iOS  7 and iOS 8?
7.Who invented Objective c?
8.What is Cococa and cocoa touch?
9.What is Objective c?
10. how declare methods in Objective c? and how to call them?
11. What is property in Objective c?
12.What is meaning of "copy" keyword?
13.What is meaning of "readOnly" keyword?
14.What is meaning of "retain" keyword?
15.What is meaning of "assign" keyword?
16.What is meaning of "automic" keyword?
17.What is meaning of "nonautomic" keyword?
18.What is difference between "assign" and "retain" keyword?
19.What is meaning of "synthesize" keyword ?
20.What is "Protocol" on objective c?
21.What is use of UIApplication class?
22.What compilers apple using ?
23.What is synchronized() block in objective c? what is the use of that?
24. What is the "interface" and "implementation"?
25.What is "private", "Protected" and "Public" ?
26. What is the use of "dynamic" keyword?
27.What is "Delegate" ?
28.What is "notification"?
29.What is difference between "protocol" and "delegate"?
30.What is "Push Notification"?
31.How to deal with SQLite database?
32.What is storyboard?
33.What is Category in Objective c?
34.What is block in objective c?
35. How to parse xml? explain in deep.
36.How to parse JSON? explain in deep.
37.How to use reusable cell in UITableview?
38.What is the meaning of "strong"keyword?
39.What is the meaning of "weak" keyword?
40.What is difference strong and  weak reference ? explain.
41.What is ARC ? How it works? explain in deep.
42. What manual memory management ?  how it work?
43. How to find the memory leaks in MRC?
44.what is use of NSOperation? how NSOperationque works?
45.How to send crash report from device?
46.What is autorealease pool?
47.What happens when we invoke a method on a nil pointer?48.Difference between nil and Nil.
49.What is fast enumeration?





50. How to start a thread? explain in deep.
51.How to download something from the internet?
52.what is synchronous web request and asynchronous ?
53. Difference between sax parser and dom parser ?
54.Explain stack and heap?
55.What are the ViewController  lifecycle in iOS?
56.Difference between coredata & sqlite?
57.Steps for using core data?
58.Procedure to push the app in AppStore?
59.What are the Application lifecycle in iOS?
60.Difference between release and autorelease ?
61.How to start a selector on a background thread
62.What happens if the methods doesn’t exist
63.what happens if you remove   the object from the array, and   you try to use it?
64.Difference between HTML & XML?
65.What are iOS SDK Tools?
66.what are the Delegate Methods for XML Parsing?
67.What is XML parsing?





JavaScript

JavaScript is:-

-a lightweight, interpreted programming language
-Designed for creating network-centric applications
-Complementary to and integrated with Java
-Complementary to and integrated with HTML
-Open and cross-platform

Advantages of JavaScript:-

-Less server interaction: You can validate user input before sending the page off to the server. This saves server traffic, which means less load on your server.
-Immediate feedback to the visitors: They don't have to wait for a page reload to see if they have forgotten to enter something.


JavaScript Syntax:-
A JavaScript consists of JavaScript statements that are placed within the <script>... </script> HTML tags in a web page.

Your First JavaScript Script:-
Let us write our class example to print out "Hello World".

<html>
<body>
<script language="javascript" type="text/javascript">
   document.write("Hello World!")
</script>
</body>
</html>


The script tag takes two important attributes:

language: This attribute specifies what scripting language you are using. Typically, its value will be javascript. Although recent versions of HTML (and XHTML, its successor) have phased out the use of this attribute.

type: This attribute is what is now recommended to indicate the scripting language in use and its value should be set to "text/javascript".
we call a function document.write which writes a string into our HTML document. This function can be used to write text, HTML, or both. So above code will display following result:

Hello World!










Introduction to CodeIgniter:






CodeIgniter is a powerful PHP framework with a very small footprint, built for developers who need a simple and elegant toolkit to create full-featured web applications.

CodeIgniter is based on the Model-View-Controller development pattern. MVC is a software approach that separates application logic from presentation. In practice, it permits your web pages to contain minimal scripting since the presentation is separate from the PHP scripting.

CodeIgniter is a dynamically instantiated, loosely coupled system with high component singularity. It strives for simplicity, flexibility, and high performance in a small footprint package.

CodeIgniter is a toolkit for people who build web applications using PHP. Its goal is to enable you to develop projects much faster than you could if you were writing code from scratch, by providing a rich set of libraries for commonly needed tasks, as well as a simple interface and logical structure to access these libraries. CodeIgniter lets you creatively focus on your project by minimizing the amount of code needed for a given task.

Really fast. We challenge you to find a framework that has better performance than CodeIgniter.

MVC=>
Models are PHP classes that are designed to work with information in your database.
A view is simply a web page, or a page fragment, like a header, footer, sidebar, etc. In fact, views can flexibly be embedded within other views (within other views, etc., etc.) if you need this type of hierarchy.
The controller communicates with the model and the view.
The controller is primarily for co-ordination between the view and the model.

the Model contains the data and behaviour of the application, the View is responsible for displaying it to the user and the Controller deals with user input.


Download the CodeIgniter Version 2.2.0 from:
www.codeigniter.com

all versions available for download at:
https://ellislab.com/codeigniter/user-guide/installation/downloads.html







 Benefits of using CodeIgniter:

-Codeigniter is fast, reliable, lightweight and more capable.
-PHP framework is an easy debug that allows you easily to get out the errors in your development. Codeigniter Development can extend your PHP coding to get the specific functions through frameworks.
-In web Development, many features are almost the same so that you can describe the same code in different way.
-Codeigniter PHP Development is a most easy way to utilize a modular programs.
-Codeigniter PHP Development is compatible with most web servers, numerous operating systems and platforms.
-For many relational database management systems, PHP can be used.
-In worldwide, PHP developers are located and without any difficulty with Codeigniter PHP development you can find enormous amount of support through forums and blogs.
-Codeigniter has an outstanding performance as well as presentation.
-While configuring the PHP framework, Codeigniter is famous among developer because of effort investment.
-Using CodeIgniter, You can construct your own cleaner URI lines
-No commercialism - It’s 100% free and they don’t offer to force you to buy products/services. (Unlike Zend Framework)
-Offers flexibility and easy management With MVC based framework.

What is malware?

What is malware?

Answer:

"software which is specifically designed to disrupt or damage a computer system"


“Malware” is short for “malicious software” - computer programs designed to infiltrate and damage computers without the users consent. “Malware” is the general term covering all the different types of threats to your computer safety such as viruses, spyware, worms, trojans, rootkits and so on.

Malware stands for "Malicious Software"

This may refer to anything that, without the user's consent, modifies or misuses the system in any way.

For example, you may download a "game" which has been purposely written to fake crash. You may think nothing's happened, but in the background, it could've modified your system in a certain way, or is logging your keystrokes, etc.

Malware can be detected using antivirus software.

The term "malware" covers all sorts of malicious software designed to harm a computer or network. Malware can be installed on your machine without your knowledge, often through deceptive links or downloads posing as something desirable.

Kinds of malware include (but are not limited to):
-Viruses
-Worms
-Spyware
-Adware
-Trojan horses

Requirement on Software Testing

Client- Datamatics
Skill- Software Testing 
Job Location- Pune / Banglore /Chennai
Interview Location- Banglore
Yop- 2012 / 2013/2014
Qualification- BSC / BCA / BCS (CS/IT Only)
Percentage- 60% throughout


Address:- Qspiders. No 582, Sunny Pride, 5th floor, Behind JM road McDonalds,
                   Near Z Bridge, above DCC Computer mall Deccan gymkhana
                    Pune-411004

Regards,
Sheetal / Priti
+91- 8600544415 / 9096055556

About Google:

Founders: Larry Page and Sergey Brin met at Stanford University in 1995. By 1996, they had built a search engine (initially called BackRub) that used links to determine the importance of individual webpages.


Google.com is registered as a domain on September 15,1997.
The name—a play on the word "googol," a mathematical term for the number represented by the numeral 1 followed by 100 zeros—reflects Larry and Sergey's mission to organize a seemingly infinite amount of information on the web.


CEO:-
Larry Page, Google’s original CEO until 2001, took up the title again in April 2011. Eric Schmidt, now our executive chairman, served in the role for 10 years.


visit for google history:-
http://www.google.co.in/about/company/history/

Job openings For BE/BTECH/IT





Job openings For BE/BTECH/IT: (PUNE)>>>
(Freshers and experienced)






Company: Survik Software
Job Positions:-

Excel (Spreadsheet) programmers

Jr. Data Scientists

BI Trainees

Business Objects Programmer

SPSS Programmers

Database programmers

Sr. Operations Research / Data Analyst / Data Scientists

Business Analyst

Jr. Maintenance Engineers





Apply>>>>
http://www.survik.com/about-us/current-openings



Walk-in Interview @Human Capital”Software Developer / Mobile Application developer/ Software Tester ( fresher recruitment)” Bangalore





Experience: 0- 1 year

Walkin Date: Every Day in December 2014
Time:9:30am to 5:30pm

venue/ Address:
 628/A,1ST floor,Indira Nagar,
 Near BDA Complex and Canara Bank,

Qualification: B.E/B.Tech/M.Tech (any Stream)/ MCA/MSc (IT/Comp) with 60% marks.
Pass out years allowed: 2012, 2013, 2014
No of Openings: 20





Projects to work: Humancapital.in ( recruitment and HRMS ), Abhinavbharat.in ( education and LMS),
citycare.in ( services management like justdial), cityland.in(real estate ERP/CRM)

Technologies: Java/J2EE, Struts, Spring, JSP, JSF, Hibernate, My SQL/ ASP.Net MSSQL/ Php/ Android, IOS
Other Open Sources Technologies covered: Liferay, Sugar CRM, Magento, OffbiZ ERP


Recruitment Procedure: Technical Interview, HR Interview and Offer





Training: Very good training will be provided to all joinees for 2 months, and inducted into projects.


Salary: Initially 10,000/- PM fixed and 10000/- for month variable: total 20000 per month. Variable salary paid based on coding performance.


Contact: Bhageeradha/Srinivas –  8050040432, 9845155440
Please send resumes to swjobs@humancapital.in





Humancapital Management Private Limited
HumanCapital Management Private Limited, a 100% dedicated HR Services Organization with planned presence across 640 districts in India, and currently planning to establish 10,000 employment centers across all cities, towns, and villages in India to provide comprehensive Human Resource Management Services and facilitate the employment of all eligible persons in the client organizations.

HumanCapital is also providing Franchisee Business opportunities for skilled and competent Human Resource management, Sales and Marketing Professionals with interest in entrepreneurship/self employment and authorizing them to represent HumanCapital Branch for delivery of products and services to customers within the limits of the terms and conditions

Human capital Management Private Limited was established in 2010 at Bangalore, and currently expanding to all cities in India.

Interview address:-
Thanks & Regards
Human Capital Management Pvt Ltd
628/A,1ST floor,Indira Nagar,
Near BDA Complex and Punjab National Bank,
Above Canara Bank,
Bangalore-560038.
Contact no:080-45300815





Syntel Walk-in Drive for Freshers on 4th and 5th Dec 2014





Syntel is an U.S based multinational information technology company which provides integrated technology and business services.Now they conduct walk-in drive for freshers on 4th and 5th December 2014.

Name of the Company: Syntel

Job Role: Associate/sr Associate

Educational Qualification: Any Graduates

Required Experience: 0 – 3 years

Expected Salary: Best in Industry

Job Location: Chennai

Job Description:

Candidates who are looking to work in Syntel should have good communication skills and analytical skills.

Candidates who are pursuing/pursued CA/CS/ICWA need not apply.

Flexibility to work in any shift be it a continuous Night shifts or Day shifts or Rotational Shifts is mandatory.

Walk-in Details:

Walk-in Date: 4th & 5th December 2014

Interview Timings: 11:00 AM till 1:00 PM

Venue:





Syntel,

Chennai

Plot No. H7/H8, SIPCOT IT Park,

Old Mahabalipuram Road,

Navallur Post Siruseri, Chennai.




Urgent Requirement For Non-Technical





Job Post Date: 02nd Dec 2014
 
Excellent job opportunity for Our Client 
Designation: Software Engineer. 
Num of Positions: 10 
Job Location: Pune (Wanworie). 
PFB Job Description: 
Qualification: MCA, BE IT, BE. Computers, B Tech, MSC Computers, MSC Comp, MCM, BE Mech, BE. Electronics Engg, (Computer Grads) 

Experience: Fresher only 

Shift timings: 24/7 Rotational Shift. 

Mandatory Bond for 1 yr. 

We are looking for only Male Candidates. 

Mandatory Skill Set: 

1. Non-technical: Good spoken English. 
2. Technical: MySql, PHP & Linux. 

Roles & Responsibilities: 

1. Design and develop the technical solution. 
2. Need to send bulk mails which is into email marketing. 
3. Generating reports for the project using PHP, JavaScript, and Linux. 
4. Configuration of Server for ESP (Email Service Provider) in Linux using SMTP Relay, IP-Domain binding, setting up Name Servers for the End User Domains, Configuration of Domain, and IP Configuration of Server via Linux.
Contact:
Interested candidates send us their resume on hr@exinformatics.com or call us on 020-65100228




Job | Urgently Required - "Technical Trainer" (Full-time) at SEED Infotech Ltd, Pune





Job Post Date:  02/12/2014

SEED Infotech Ltd, Pune
 
We are pleased to inform you that your candidature has been shortlisted for the role of Technical Trainer position with us. The details are mention below

Job Role: Technical Trainer - Dot Net /Java Technology

Job Description:
* Conducting Lectures.
* Conducting Lab.
* Conducting Seminar (if required)
* Able to deliver other responsibilities as per business requirement.

Qualification : Technical Graduate

Experience: 0-3 yrs with good communication skills and proficiency in Dot Net /JavaTechnology.

Note:- The candidate needs to travel within Pune to conduct Lectures.





Venue Details: 
SEED Infotech Ltd.
69,Yashodhan Office, Behind Hotel Marriott,
Near Shivaji Housing Society,
Senapati Bapat Road,
Pune - 411016, INDIA

Contact Person: Nirupama
If you have any query pl feel free to call me on 9922412072
nirupama.sarkar@seedinfotech.com