If I learn SQL and how databases work in general will it be easier to understand PHP? ?

Question

and how it works with databases?

Answer 1

probably...php is relatively simple anyway

Answer 2

other than the ability to connect to other language API's what does SQL have to do with php? i mean people use it for this alot,, but generally the guy who programs the php site IS NOT AS WELL programming the backend database queries,,, hes more or so relaying what he needs to the DBA,,, so the answer is no,,, PHP is easy enough to learn without confusing urself with the SQL in the interim,,, even if,, which SQL would u learn? nearly each RDBMS uses it's own version of SQL which is the structured query language or "standard" query language as i like to call,, because what is "SQL" other than what "should be"; ur query should be something along the lines of



select * from where



to comply with SQL standards,



PHP is different it's a language,,, there is no different variations of PHP,, it's just php,,, it connects to a DBA via API ,, mysql, oracle, etc etc, and can manipulate data,,, simple,,, all u need to learn as a php programmer is the proper connection string;

further more dynamic web tenchology is not only accomplished thru php,, it could be perl,,, AJAX, java applications (which most are), etc etc etc,, we can query a DB with many different programming and scripting languages,, that doesn't mean as a web programmer u built the DB...

Answer 3

You will first need to understand php enough to get it to build pages and read the input from forms. Understanding databases involves being able to set up tables suitable for the type of data being stored, with the correct data in each table and use of IDs to link data from one table to others. Your best option would probably be to download an Apache server distribution like Wamp, which includes the mysql database, the web server and php. You can then use the manuals for php and mysql by searching for them under php manual and mysql manual, as they are very detailed and easy to follow. This is a good training platform, but also a very good development platform for building, modifying and testing sites.

Answer 4

Firstly, I agreed with Rickpoint. PHP is a web interface application.



SQL is the language to retrieve, insert, query and update data through

typing command line statements to interface with different type of database.



To understand database work, Database itself is a program that consist of tables,columns and functions keys. Database program like MYSQL, PostgreSQL and Oracle all have their own kind of rules to follow, running at back-end in server.



SQL client software, PHP interface and HTML all are considered as Front End software program running on client node to interface with

server.



SQL language is long, so many good programmer would design Forms for easy retrieve, query and posting data to their server to avoid repetition of SQL commands text which can be tedious.



I have try to understand database itself which really took me two years

to understand before you really can put them into use. You need alot

of practice and refer to good books from O'reilly



Newbie database user :-) hopes above enlighten you.

Answer 5

Nope. SQL is basically a database manipulation language, and PHP is a general programming language that can also use databases.

Answer 6

No they are technologically unrelated, both language or at least SQL and PHP's equivelent should be within a Web programmer's repertoire but database and Web programming is segregated.

Answer 7

nope. PHP is something to do with web development. SQL is needed for database stuff. you'll have to program using SQL when you need to build databases using database management systems such as MySQL, PostGre SQL.



But, anyways for development you'll hafta develop databases and then connect them to web applications, which are built using PHP.

Answer 8

yeh you should learn how sql works. It will really help you when creating prodejects (such as a blog or user authentication system) as most of them use databases.