Introduction to Database Programming using PHP and MySQL

Introduction to Database Programming using PHP and MySQL Revision 1.1 June 14, 2010 by Aloysius Indrayanto (C) 2010 AnemoneSoft.com This document is multi-licensed under the Creative Commons Attribution Share-Alike (CC-BY-SA) license version 3.0 and the GNU Free Documentation License (GNU FDL) version 1.3 or later. Introduction to Database Programming using PHP and MySQL Page 1 of 12 1. Introduction LAMP (an acronym for Linux, Apache, MySQL, and PHP) is basically the most popular solution stack to deliver a general-purpose web

and application server. A solution stack is a full set of software components bundled together to provide a specific solution. Basically, the exact combination of software included in LAMP can be modified, depending on the need of the developer. For example, PHP can be replaced with Python, Perl, or other scripting language. In MS Windows, the package is called WAMP. In Mac OS, it is called MAMP. In Solaris, it is called SAMP. In OpenBSD it is called OpAMP, etc. PHP: Hypertext Preprocessor was invented by Rasmus Lerdorf in 1995. PHP is both a general-purpose programming language and a scripting language. PHP can be used to develop general-purpose applications (with and without graphical interface) as well as dynamic web pages or web applications. PHP is an interpreted language. Currently, PHP is maintained by The PHP Group. PHP is free and open source. MySQL Community Server is a free and open source RDBMS (Relational Database Management System) that runs as a server to provide a multi-user database system. The original MySQL was developed by Michael Widenius. Currently, MySQL is owned and sponsored by Sun Microsystems, a subsidiary of Oracle Corporation. MySQL has been used in large-scale products, such as Wikipedia, Google,...

Website: anemonesoft.com | Filesize: 147kb
No of Page(s): 13
download: http://anemonesoft.com/files/tutorial/idpm-handout-en.pdf

MySQL Tutorial - University of Ibadan

This tutorial is inspired by the examples of this book : MySQL™ The definitive guide to using, programming, and administering MySQL 4.1 and 5.0 Third Edition By Paul DuBois – SAMS March 2005 Design & Conception: P.K helped by A.D, L.W & S.S. A MySQL Tutorial Basic Database Terminology Many relational database concepts are really quite simple. In fact, much of the appeal of relational databases stems from the simplicity of their foundational concepts. Structural Terminology Within the database world,

MySQL is classified as a relational database management system (RDBMS). That phrase breaks down as follows: • The database (the "DB" in RDBMS) is the repository for the information you want to store, structured in a simple, regular fashion: o The collection of data in a database is organized into tables. o Each table is organized into rows and columns. o Each row in a table is a record. o Records can contain several pieces of information; each column in a table corresponds to one of those pieces. • The management system (the "MS") is the software that lets you use your data by allowing you to insert, retrieve, modify, or delete records. • The word "relational" (the "R") indicates a particular kind of DBMS, one that is very good at relating (that is, matching up) information stored in one table to information stored in another by looking for elements common to each of them. The power of a relational DBMS lies in its capability to pull data from those tables conveniently and to join information from related tables to produce answers to questions that can't be answered from individual tables alone. Here's an example that shows how a relational...

Website: ui-n2.loria.fr | Filesize: 453kb
No of Page(s): 58
download