Pages

Jun 18, 2012

Web Applications Development


For beginners of Web development,my biggest advice is to understand HTML and once you think you're done with html basics,move on to other wings of CSS,PHP etc.Here I would like to share my experiences with web development and the journey which I think will help any beginner in Web development to land successfully int their projects.

Two years before, I was wondering how are the web applications been build and maintained ! Then I began to start from its basic element -HTML. Of course to get a good grip on any web designed application , you need to be good at HTML.So I understood the basics tag elements, implementation of forms, styling and table features in HTML. The base at HTML will certainly will contribute towards your progress in CSS. A sound knowledge in CSS is helpful in designing your own outline in web designing. The concepts of div and customizing the elements, will lead to custom outline design of web page.  

To advance in dynamic environment of web page, better to know javascript. The functionality feature along with hidden code feature, helps to develop a very good application platform. The form validity feature is the functionality i really liked in javascript. So now once you come through HTML, CSS, JavaScript- i would say you have paved your platform for web applications.

Now to go a step ahead is the wonderful language of PHP. Php acts as a link between your application and and data storage.MySql comes handy once you look for a back end support. Acting as a base, mysql extends the feature to create tables,alter it,update it and many more features which helps in data storage. The basic things to learn in mysql are to design- how to create tables,adding constraints,insert into table, updating tables, retrieving the contents from table based on view and constraints.

Now php supports html inside it .Its really easy to embed html inside a php page.Just put ur each lines of html into a  echo ""  statement.

So easy I guess to change your html page to php page. Now like javascript , php helps in  hiding the code content from being viewed. So it offers security compared to html.Also Php helps to add queries to its page, which helps in acting as a interface between application and tables of mysql platform and helps in transfer of data.

Below is a basic php code of how to connect to sql and retrieve contents from it , verify and step ahead.The code basically connects with mysql, retrieves data and thus takes action on basis of it.



php
$conn=mysql_connect("localhost","root","pwd");//enter password of mysql instead of pwd
if(!$conn)
{
die('COUDNOT CONNECT SUCCESSFULLY:'.mysql_error());
}
mysql_select_db("dbname",$conn);
$query="SELECT * FROM ACCOUNT WHERE USER='abc' AND PASS='passed' ";
$res1=mysql_query($query,$conn);
$num1=mysql_num_rows($res1);//retrieves number of available tuples corresponding to query

if($num1 != null)
{
}

mysql_close($rohi);
?>


Similarly i would suggest to learn the basic php code of Inserting the contents into table , displaying the contents of a table , which will help you to achieve almost 80% of your tasks in PHP.The basic starting of all these features will be same as above.

So now for people loving Java and JSP, I would suggest all the steps you followed in PHP is equally applicable in java too.Also for lovers of Oracle,SQL, and M' Access , the contents I mentioned about MySql is equally applicable.

For Java the code for connectivity will differ as the example given below:

import java.sql.*;
import javax.sql.*;

class DBConn
{
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection conn=DriverManager.getConnection("jdbc:odbc:db_pwd");//
//code for inserting contents
PreparedStatement ps=conn.prepareStatement("insert into ACCOUNT values(?,?,?)");
ps.setString(1,"abc");
ps.setString(2,"pass");
ps.setInt(3,100);

System.out.println("Rows Inserted"+ps.executeUpdate());


//code to retrieve contents
Statement stm=conn.createStatement();
ResultSet rs=stm.executeQuery("select * from stud");

while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getInt(3));
}
}catch(SQLException e)
{
System.out.println("Exception" +e);
}
catch (ClassNotFoundException cnfe){
System.out.println("" + cnfe);
}

}
} 

Now using jsp, we can integrate HTML,CSS along with Java for advanced features.Same like php, here to embed HTML into JSP, we just need to embed html into a statement called  out.println();

Similarly the concept of Servlets helps in modularizing the components. So you can take PHP of JSP as the front end of your projects and build on its appearance and functionalities. Meanwhile we can fix mysql/oracle/Ms Access as back end and work on how data are normalized into tables and adding constraints properly to maintain data security.

To begin with basic web development, its very easy once you think you've got enough basics of HTML.For me, HTML have lead me to a point of confidence and passion to learn the other parts of Web applications. I would personally suggest sites like w3schools will definitely help any one in web application development field

Some of the common workable web application projects include student-management system,hospital management system, event managements systems etc.

Anybody who have queries on above contents do post your queries and I'll try my level best to answer your queries.

1 comment:

  1. It can easily blend with Adobe Flash to create innovative web apps and it is a powerful tool for creating rich internet applications. This platform enables to deliver solutions with speed and ease. It reduces the time and the cost involved in development work. Experienced Silverlight developers will know the pros and cons of working with this tool and will be able to deliver innovative solutions to cater to your business requirements.

    Web Applications Development

    ReplyDelete