Hi folks, today I bring a mini tuto indicating step by step to install PHP5 + Apache 2 + PostgreSQL some another package to provide us with the modification of the database or as a smarty template for our dear html not wrap up in chaos. It is worth mentioning that in addition to the packages we were lowered down a lot but these are dependent and need to run the selected package. There are two options to start the download, we can do from our preferred package manager Synaptic (or Adept for KDE), or from terminal using apt-get eg
guido guido-amd @ ~ $ sudo apt-get install \\ Packagename \\
remember that we can use pipes, eg
guido guido-amd @ ~ $ sudo apt-get install \\ Packagename \\ \\ nombreDePaquete2 \\ ... \\ Packagename \\
later give you an example ... We download the following packages: __________________________________________________________________________ 
php5
scripting language embedded in HTML server (metapackage)
This package is a metapackage that, when installed , guaranteed to have installed at least one of the four versions of the PHP5 interpreter installed server. Delete this package does not remove PHP5 from your system, however, may delete other packages that depend on it. PHP5
http://www.php.net/
__________________________________________________________________________
apache2 Next generation, scalable, extendable web server. Apache v2 is the next generation of the omnipresent Apache web server. This version, which is rewritten from scratch, introduces many new improvements, such as threads, a new API, IPv6 support, filter request / response, and more.
Official Website:
http://httpd.apache.org/
__________________________________________________________________________
php5-pgsql
This package provides a module for connections to PostgreSQL databases
directly from PHP scripts. It also includes a module for use with
pdo_pgsql the PHP Data Objects Data Object extension.
PHP5 is an HTML-embedded language script. Much of its syntax is borrowed of C, Java and Perl with a couple of unique PHP-specific features thrown in. The goal of
language is to allow web developers to write dynamically generated pages
quickly. __________________________________________________________________________
php-db
PHP PEAR abstraction layer
database DB is a database abstraction layer providing data:
* OO-style query API * portability
features that make programs written for one DBMS work
with other DBMS's
* A DSN (name of data source) to specify the format server databases
* Prepare and execute (bind) emulation for databases that do not support
natively
* Results subject of consultation each response
* Portable error codes * sequence emulation
* Sequential and non sequential row of collection, as well as bulk fetching * formats download
rows as associative arrays, ordered arrays or objects * row limit support * Transactions support * table information interface * DocBook and API documentation
phpDocumentor
DB propio capas en la parte superior de PHP la base de datos existente extensiones.
Los conductores de las siguientes extensiones pasar la suite de prueba y
proporcionar intercambiabilidad de todos cuando la base de datos de la portabilidad
opciones están activadas:
fbsql, IBASE, Informix, mSQL, mssql,
mysql, mysqli, oci8, ODBC, pgsql,
SQLite y Sybase.
__________________________________________________________________________
smarty
Motor de plantillas para PHP
Smarty es un motor de plantillas para PHP. Más concretamente,
facilitates a manageable way to separate application logic and content of your presentation
.
template play different roles,
or in most cases are not the same person. For example, suppose are creating a website that shows a newspaper article. The article title, theme, author and body are content elements, contain no information on how to perform. They are passed into Smarty the application, then the template edit
design templates and uses a combination of HTML tags and template tags
format for the presentation of these elements (HTML tables,
background colors, font sizes, style sheets, etc) One day the programmer 
need to change the way the article content is retrieved (a change
application logic.) This change does not affect the template designer need to change the way the article content is retrieved (a change , the content will still arrive in the template exactly the same
. Similarly, if the template designer wants to completely redesign the templates
, this does not require application changes
logic. Therefore, the programmer can make changes to the application logic
without the need to restructure templates, and
template designer can make changes to templates without breaking application logic
.
Official Website:
http://smarty.php.net/
__________________________________________________________________________
pgadmin3
graphical management tool for PostgreSQL pgAdmin III is a database design and management application for use with PostgreSQL
. The application can be used to manage PostgreSQL 7.3 and above
run on any platform.
for developing complex databases. The
graphic interface supports all PostgreSQL features and makes administration easy . The application also includes SQL syntax editor, a server-side code editor, an SQL / batch / shell job scheduling agent, support Slony-I replication engine and much more. server connection can be made using TCP / IP or Unix Domain Sockets (on * nix platforms
) and can be SSL encrypted for security. N
additional drivers are required to communicate with the database server.
Official Website: __________________________________________________________________________
phpPgAdmin
Joint PHP scripts to administer PostgreSQL over the WWW (ie via Web) PhpPGAdmin is intended to handle the administration of PostgreSQL over the WWW
. Currently you can:
- Create and drop databases
- Create, copy, delete and modify tables / views / sequences / functions
- Edit and add fields (to the extent Postgres) - Execute any SQL-statement, even
lot of questions - Key management in the fields - Load text files into tables - Create and read dumps of tables - Giving a single database - Manage users
postgres __________________________________________________________________________ 
Ready
these packages for now, to download all the terminal type or copy
guido guido-amd @ ~ $ sudo apt-get install apache2 php5 php5-pgsql-db php smarty pgadmin3 phpPgAdmin
For now prove our point your browser apache localhost or 127.0.0.1 (for default) if aperece
It Work's felcitaciones your apache is installed correctly. Later'll post some examples to start learning a touch more ...
Greetings ... Source 
0 comments:
Post a Comment