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] R-tree indexes (PostgreSQL) RAID (Redundant Array of Independent Disks) systems RAISE EXCEPTION functions 2nd RAISE NOTICE functions 2nd 3rd range function (PHP) readfile function (PHP) reading dynamic images reads dirty reads non-repeatable reads phantom reads records PHP/PostgreSQL database tables adding records inserting records 2nd 3rd 4th retrieving records 2nd 3rd 4th 5th 6th 7th redundancy hardware redundancy redundant array of disks systems. [See RAID systems] registering variables 2nd 3rd 4th 5th regular expressions 2nd 3rd metacharacters 2nd 3rd 4th 5th 6th 7th patterns preg_grep command 2nd preg_match_all command 2nd 3rd preg_quote command preg_replace command 2nd 3rd preg_split command 2nd 3rd Perl 2nd metacharacters 2nd 3rd 4th 5th 6th 7th preg-match function (PHP) 2nd preg_grep command 2nd preg_match_all command 2nd 3rd preg_quote command preg_replace command 2nd 3rd preg_split command 2nd 3rd special symbols POSIX ereg function (PHP) 2nd ereg_replace function (PHP) eregi function (PHP) eregi_replace function (PHP) 2nd sql_regcase function (PHP) special characters 2nd SQL 2nd 3rd 4th 5th 6th escaping characters lower function (PHP) statements LIKE statement 2nd 3rd NOT LIKE statement REINDEX command relational databases 2nd basic operations DIFFERENCE operation INTERSECT operation JOIN operation PRODUCT operation PROJECT operation SELECT operation UNION operation components aggregate expressions aggregate functions constraints data types foreign key columns indexes joins primary key columns relations sequences triggers views data aggregating 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th modifying 2nd 3rd data types 2nd functions mathematical 2nd trigonometric indexes B-tree indexes (PostgreSQL) CREATE INDEX command 2nd 3rd DROP INDEX command hashes (PostgreSQL) R-tree indexes (PostgreSQL) REINDEX command internal views joins writing 2nd 3rd 4th 5th 6th logical views normalization 2nd 3rd first normal forms 2nd second normal forms third normal forms object relational databases inheritance 2nd 3rd 4th operators mathematical 2nd sequences modifying 2nd 3rd SQL (Structured Query Language) < = operators aggregating data 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th AND operators building statements 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd building tables 2nd 3rd COMMENT command 2nd CREATE SEQUENCE command CREATE TABLE command 2nd 3rd 4th data types 2nd DELETE command DROP TABLE command escaping special characters formatting output 2nd history of 2nd indexes 2nd 3rd 4th 5th 6th 7th 8th 9th INSERT command 2nd LIMIT command mathematical functions 2nd mathematical operators 2nd modifying sequences 2nd 3rd modifying tables 2nd 3rd 4th NULL values 2nd OFFSET command 2nd OR operators SELECT command 2nd SELECT INTO command 2nd 3rd 4th 5th trigonometric functions UPDATE command 2nd WHERE clauses 2nd writing joins 2nd 3rd 4th 5th 6th SQL (Structured Query Language); 2nd statements building 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 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th tables building 2nd 3rd 4th 5th 6th 7th 8th 9th 10th modifying 2nd 3rd 4th relations remote files (PHP) 2nd array fgetcsv function array file function array fstat function array lstat function array pathinfo function array stat function basename function bool fclose function bool file_exists function bool flock function bool is_dir function bool is_executable function bool is_file function bool is_link function bool is_readable function bool is_uploaded_file function bool is_writable function bool move_uploaded_file function chgrp function chmod function chown function clearstatcache function copy function dirname function float diskfreespace function float_disk_total_space function int f [See k function] int feof function int fflush function int fileatime function int filectime function int filegroup function int fileinode function int filemtime function int fileowner function int fileperms function int filesize function int fopen function int fpassthru function int fputs function int ftell function int ftruncate function int fwrite function int link function int linkinfo function int mkdir function int pclose function int popen function int readfile function int rename function int rewind function int rmdir function int set_file_buffer function int symlink function int tmpfile function int touch function int umask function int unlink function mixed fscanf function string fgetc function string fgets function string fgetss function string filetype function string fread function string readlink function string realpath function string tempnam function removing databases dropdb (PostgreSQL) 2nd functions DROP FUNCTION command SQL rules 2nd 3rd render function reset command (PHP) 2nd retrieving color information (dynamic images) REVOKE command 2nd 3rd rewind function (PHP) ROLLBACK command 2nd ROLLBACK command (PHP) row-level locking LOCK command RPM packages installing 2nd 3rd removing binary packages 2nd rtrim function (PHP) rules creating 2nd 3rd inheritance 2nd removing 2nd 3rd running functions NULL values SQL PostgreSQL on Windows runtime parameters PostgreSQL setting runtime parameters (PostgreSQL) postgresql.conf file 2nd 3rd 4th 5th 6th 7th |