PHP and PostgreSQL. Advanced Web Programming2002
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] scanning ports nmap 2nd scope (object orientation) 2nd 3rd scripts (PHP) parameters passing to scripts 2nd 3rd second nornal forms (relational databases) security Apache authentication 2nd applications 2nd cookies accessing values components creating deleting problems 2nd databases high-availability systems 2nd application examples 2nd 3rd 4th 5th 6th 7th monitoring 2nd 3rd 4th 5th 6th 7th 8th 9th 10th network firewalls network Internet connections RAID (Redundant Array of Disks) systems redundancy software 2nd networks PostgreSQL networks 2nd 3rd 4th 5th nmap 2nd PHP authentication 2nd 3rd PostgreSQL transaction isolation levels potential threats 2nd servers 2nd 3rd SELECT command 2nd SELECT INTO command 2nd 3rd vs. views 2nd SELECT operation (relational databases) SELECT statements subselects subqueries 2nd 3rd views CREATE RULE command 2nd CREATE VIEW command 2nd 3rd DROP RULE command 2nd 3rd DROP VIEW command 2nd selecting data 2nd self-joins 2nd 3rd sending dynamic images as files e-mail 2nd 3rd sequences creating modifying 2nd 3rd serials 2nd 3rd 4th temporary tables, creating in servers application servers PHP 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th e-mail servers mailboxes 2nd 3rd 4th IMAP servers retrieiving status data locking explicit locking 2nd 3rd 4th PostgreSQL servers tracing connections 2nd 3rd 4th security 2nd 3rd potential threats 2nd session IDs 2nd 3rd session management cookies accessing values components creating deleting problems 2nd session IDs 2nd 3rd variables registering 2nd 3rd 4th 5th session-driven shopping cards 2nd 3rd session-driven shopping carts setting time zones 2nd 3rd shared memory daemons installing shopping carts (Web shops) cookie-driven shopping carts 2nd 3rd 4th 5th 6th 7th 8th 9th 10th session-driven shopping carts 2nd 3rd 4th SHOW command (PostgreSQL) queries optimizing 2nd 3rd shuffle function (PHP) 2nd simple classes building 2nd sizing dynamic images SMTP (e-mail protocol) software high-availability systems 2nd sort command (PHP) 2nd Soundex algorithm 2nd 3rd 4th indexes 2nd 3rd 4th 5th installing 2nd special characters 2nd escaping sprintf (PHP) SQL aliases 2nd self-joins 2nd 3rd BLOBs (Binary Language Objects) 2nd lo_export function lo_import function lo_unlink function commands COPY command 2nd 3rd DELETE command EXPLAIN command 2nd 3rd 4th 5th LOCK command UPDATE command functions lower function (PHP) queries combining 2nd 3rd 4th 5th 6th regular expressions 2nd 3rd 4th 5th 6th escaping characters rules 2nd creating 2nd 3rd removing 2nd 3rd subselects subqueries 2nd 3rd SQL (Structured Query Language) < = operators AND operators clauses WHERE 2nd commands COMMENT 2nd CREATE SEQUENCE CREATE TABLE 2nd 3rd 4th DELETE DROP TABLE INSERT 2nd LIMIT OFFSET 2nd SELECT 2nd SELECT INTO 2nd 3rd 4th 5th UPDATE 2nd constraints CHECK constraint 2nd CREATE TABLE command 2nd DEFAULT constraint 2nd foreign keys 2nd 3rd 4th 5th 6th 7th 8th INITIALLY DEFERRED constraints INITIALLY IMMEDIATE constraints NOT NULL constraint 2nd NULL constraint primary keys 2nd UNIQUE constraint data aggregating 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th data types 2nd formatting output 2nd functions caching 2nd overloading 2nd removing running writing 2nd 3rd 4th history of 2nd indexes B-tree indexes CREATE INDEX command 2nd 3rd DROP INDEX command hashes R-tree indexes REINDEX command inheritance 2nd 3rd 4th serials 2nd 3rd 4th sql_inheritance 2nd joins writing 2nd 3rd 4th 5th 6th mathematical functions 2nd mathematical operators 2nd NULL values 2nd OR operators PostgreSQL data types 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd sequences modifying 2nd 3rd special characters escaping statements building 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd CASE statements 2nd 3rd tables building 2nd 3rd modifying 2nd 3rd 4th transactions 2nd 3rd 4th 5th BEGIN command COMMIT command 2nd reads 2nd 3rd ROLLBACK command 2nd transaction isolation levels trigonometric functions SQL (Structured Query Language); 2nd sql function 2nd SQL statement fetch function SQL statements sql function 2nd sql_inheritance (PostgreSQL) 2nd sql_regcase function (PHP) SQLs transforming ERMs (Entity Relationship Models) to SQL rules SSL PostgreSQL secure authentication 2nd 3rd 4th stacks (PHP) 2nd 3rd starting Apache 2nd apachectl command database daemons (PostgreSQL) 2nd postmaster daemon 2nd 3rd 4th 5th postmaster daemons starting/stopping PostgreSQL 2nd 3rd 4th 5th stat command (PHP) 2nd statements BETWEEN statements break statements (PHP) 2nd 3rd building 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th < = operators AND operators CREATE SEQUENCE command escaping special characters formatting output 2nd INSERT command 2nd LIMIT command NULL values 2nd OFFSET command 2nd OR operators SELECT command 2nd SELECT INTO command 2nd 3rd 4th 5th WHERE clauses 2nd building; 2nd CASE statements 2nd 3rd case statements (PHP) 2nd 3rd 4th 5th continue statements (PHP) 2nd 3rd DELETE statements views 2nd DISTINCT statements else statements (PHP) 2nd elseif statements (PHP) EXCEPT statements if statements (PHP) 2nd 3rd INSERT statements views 2nd 3rd 4th 5th INTERSECT statements LIKE statements (regular expressions) 2nd 3rd NOT LIKE statements (regular expressions) SELECT statements subselects 2nd 3rd 4th 5th 6th views 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th switch statements (PHP) 2nd 3rd 4th 5th UNION statements UPDATE statements views 2nd static inheritance 2nd static variables (PHP) stock charts creating 2nd 3rd 4th 5th 6th 7th drawgrid function 2nd genimage function 2nd 3rd strcmp (PHP) strftime function (PHP) string fgetc function (PHP) string fgets function (PHP) string fgetss function (PHP) string filetype function (PHP) string fread function (PHP) string readlink function (PHP) string realpath function (PHP) string tempnam function (PHP) strings (PHP) stripslashes function (PHP) strlen function (PHP) strtolower function (PHP) 2nd strtotime function (PHP) strtoupper function (PHP) 2nd structures control structures (PHP) && operators and operators break statements 2nd 3rd case statements 2nd 3rd 4th 5th continue statements 2nd 3rd DO..WHILE loops 2nd else statements 2nd elseif statements FOR loops 2nd 3rd if statements 2nd 3rd or operators switch statements 2nd 3rd 4th 5th WHILE loops 2nd 3rd 4th xor operators subqueries 2nd 3rd subselects subqueries 2nd 3rd substring indexes creating 2nd 3rd 4th fulltextindex packages (PostgreSQL) installing SUM functions summary function (e-mail) 2nd 3rd 4th superusers postgres 2nd switch statements (PHP) 2nd 3rd 4th 5th system tables pg_triggers 2nd systems security potential threats 2nd |