Scribd Logo
Upload

Welcome to Scribd!

  • 25 views

    PHP Is A Server

    Uploaded by

    Ashish Tiwari
    This document provides an introduction to PHP and SQL. It explains that PHP is a server-side scripting language commonly used to build dynamic web applications that interface with databases like MySQL. It also describes SQL as the standard language for accessing and manipulating database management systems and their tables, rows, and columns of data. Key points are that PHP and SQL are often used together to build web applications that retrieve, update, and manipulate data stored in databases.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd

    PHP Is A Server

    Uploaded by

    Ashish Tiwari
    25 views3 pages
    This document provides an introduction to PHP and SQL. It explains that PHP is a server-side scripting language commonly used to build dynamic web applications that interface with databases like MySQL. It also describes SQL as the standard language for accessing and manipulating database management systems and their tables, rows, and columns of data. Key points are that PHP and SQL are often used together to build web applications that retrieve, update, and manipulate data stored in databases.

    Original Title

    PHP is a server

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an introduction to PHP and SQL. It explains that PHP is a server-side scripting language commonly used to build dynamic web applications that interface with databases like MySQL. It also describes SQL as the standard language for accessing and manipulating database management systems and their tables, rows, and columns of data. Key points are that PHP and SQL are often used together to build web applications that retrieve, update, and manipulate data stored in databases.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    25 views3 pages

    PHP Is A Server

    Uploaded by

    Ashish Tiwari
    This document provides an introduction to PHP and SQL. It explains that PHP is a server-side scripting language commonly used to build dynamic web applications that interface with databases like MySQL. It also describes SQL as the standard language for accessing and manipulating database management systems and their tables, rows, and columns of data. Key points are that PHP and SQL are often used together to build web applications that retrieve, update, and manipulate data stored in databases.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 3

    PHP is a server-side scripting language.

    What You Should Already Know


    Before you continue you should have a basic understanding of the following:

     HTML/XHTML
     JavaScript

    What is PHP?
     PHP stands for PHP: Hypertext Preprocessor
     PHP is a server-side scripting language, like ASP
     PHP scripts are executed on the server
     PHP supports many databases (MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL,
    Generic ODBC, etc.)
     PHP is an open source software
     PHP is free to download and use

    What is a PHP File?


     PHP files can contain text, HTML tags and scripts
     PHP files are returned to the browser as plain HTML 
     PHP files have a file extension of ".php", ".php3", or ".phtml"

    What is MySQL?
     MySQL is a database server
     MySQL is ideal for both small and large applications
     MySQL supports standard SQL
     MySQL compiles on a number of platforms
     MySQL is free to download and use

    PHP + MySQL
     PHP combined with MySQL are cross-platform (you can develop in Windows and serve
    on a Unix platform)
    Why PHP?
     PHP runs on different platforms (Windows, Linux, Unix, etc.)
     PHP is compatible with almost all servers used today (Apache, IIS, etc.)
     PHP is FREE to download from the official PHP resource: www.php.net
     PHP is easy to learn and runs efficiently on the server side

    Where to Start?
    To get access to a web server with PHP support, you can:

     Install Apache (or IIS) on your own server, install PHP, and MySQL
     Or find a web hosting plan with PHP and MySQL support

    Introduction to SQL

    SQL is a standard language for accessing and manipulating databases.

    What is SQL?
     SQL stands for Structured Query Language
     SQL lets you access and manipulate databases
     SQL is an ANSI (American National Standards Institute) standard

    What Can SQL do?


     SQL can execute queries against a database
     SQL can retrieve data from a database
     SQL can insert records in a database
     SQL can update records in a database
     SQL can delete records from a database
     SQL can create new databases
     SQL can create new tables in a database
     SQL can create stored procedures in a database
     SQL can create views in a database
     SQL can set permissions on tables, procedures, and views
    SQL is a Standard - BUT....
    Although SQL is an ANSI (American National Standards Institute) standard, there are many
    different versions of the SQL language.

    However, to be compliant with the ANSI standard, they all support at least the major commands
    (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

    Note: Most of the SQL database programs also have their own proprietary extensions in addition
    to the SQL standard!

    Using SQL in Your Web Site


    To build a web site that shows some data from a database, you will need the following:

     An RDBMS database program (i.e. MS Access, SQL Server, MySQL)


     A server-side scripting language, like PHP or ASP
     SQL
     HTML / CSS

    RDBMS
    RDBMS stands for Relational Database Management System.

    RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM
    DB2, Oracle, MySQL, and Microsoft Access.

    The data in RDBMS is stored in database objects called tables.

    A table is a collection of related data entries and it consists of columns and rows.

    You might also like