Tuesday, July 28, 2009

What is sql and php in building a website?

I am having problems with sql and php. Well rather the people I am working with to build a website. I have no clue what either of those things are or what they do. HELP ME PLEASE!!

What is sql and php in building a website?
You will have real big problems if you are trying to build with those things and not know what they are. Try looking through wikipedia for the definitions of each of those. A summary i can give you goes like this:





SQL is the language used to query (retrieve or insert) data into the database. So the database stores all your data. SQL is a standard language that is used to manipulate data on all databases. Samples of databases are MySQL, Oracle, MS-SQL, Sybase, PostgreSQL





PHP is a server-side language (meaning it executes on the server and is not dependent on the client which can be any browser) meant to display data to the user.





PHP is needed to connect to the database and use SQL to retrieve the data, and then PHP displays the data to the user. The user will be reading the data from a web browser.





The best example is Email or even yahoo answers. Your Questions and my answers are held in a database. But to take it out you need to ask for the right thing from the database. For this you need SQL. And to display it to the user... that is what PHP is for.








Good Luck.
Reply:SQL (probably MySQL) is a database which allows you to store and query tables. PHP is a server side scripting language which you use to make dynamic web pages (often utilizing mysql)
Reply:PHP is a programming language for the web. Its used to make web pages dynamic instead of just static content. Its actually put right in there with the HTML usually. SQL is another programming language of sorts, except its used only for dealing with databases. I'd imagine these two languages are used together on a website so that a webpage can pull something from a database and do something with the data from the database. Hope it makes sense.


No comments:

Post a Comment