Ãëàâíàÿ    Ex Libris    Êíèãè    Æóðíàëû    Ñòàòüè    Ñåðèè    Êàòàëîã    Wanted    Çàãðóçêà    ÕóäËèò    Ñïðàâêà    Ïîèñê ïî èíäåêñàì    Ïîèñê    Ôîðóì   
blank
Àâòîðèçàöèÿ

       
blank
Ïîèñê ïî óêàçàòåëÿì

blank
blank
blank
Êðàñîòà
blank
Bulger B., Greenspan J., Wall D. — MySQL/PHP Database Applications
Bulger B., Greenspan J., Wall D. — MySQL/PHP Database Applications



Îáñóäèòå êíèãó íà íàó÷íîì ôîðóìå



Íàøëè îïå÷àòêó?
Âûäåëèòå åå ìûøêîé è íàæìèòå Ctrl+Enter


Íàçâàíèå: MySQL/PHP Database Applications

Àâòîðû: Bulger B., Greenspan J., Wall D.

Àííîòàöèÿ:

This guide explains how to write web-based applications with PHP and MySQL and get data-driven web sites up and running, then walks through a sample guest book, survey, content management system, discussion board, and shopping cart. The second edition covers MySQL 4.0. The CD-ROM contains MySQL, the Apache web server, PHP 4, and example applications.


ßçûê: en

Ðóáðèêà: Ðóêîâîäñòâà ïî ïðîãðàììíîìó îáåñïå÷åíèþ/

Ñòàòóñ ïðåäìåòíîãî óêàçàòåëÿ: Ãîòîâ óêàçàòåëü ñ íîìåðàìè ñòðàíèö

ed2k: ed2k stats

Èçäàíèå: 2nd Edition

Ãîä èçäàíèÿ: 2003

Êîëè÷åñòâî ñòðàíèö: 818

Äîáàâëåíà â êàòàëîã: 13.05.2005

Îïåðàöèè: Ïîëîæèòü íà ïîëêó | Ñêîïèðîâàòü ññûëêó äëÿ ôîðóìà | Ñêîïèðîâàòü ID
blank
Ïðåäìåòíûé óêàçàòåëü
String functions, input, concatenating (STR_REPEAT())      139—140
String functions, INSERT      717
String functions, integers, ASCII-code values of (CHAR)      711
String functions, leading and trailing spaces, removed (TRIM)      715—716
String functions, leading spaces, removed (LTRIM)      715
String functions, left-padded (LPAD)      713
String functions, leftmost len characters (LEFT)      713—714
String functions, len characters long (SUBSTRING)      714
String functions, length      712
String functions, manipulation      610—614
String functions, measuring (ELT)      718
String functions, octal value (OCT)      710
String functions, one-way hash of string, returning (CRYPT())      139
String functions, position of last occurrence of search character (STRRPOS())      140—141
String functions, position of substring (INSTR)      713
String functions, position, LOCATE      712—713
String functions, position, STRPOS()      140
String functions, repeating certain number of times (REPEAT)      717
String functions, returning as binary value (BIN)      710
String functions, right-padded (RPAD)      713
String functions, rightmost len characters (RIGHT)      714
String functions, slashes      138—139
String functions, soundex string      716
String functions, space characters (#)      717
String functions, specially-formatted ASCII string (ORD)      709
String functions, STRCHR() and STRSTR()      140
String functions, substring, returning (SUBSTR())      141
String functions, SUBSTRING_INDEX      714—715
String functions, text, image (GETIMAGESIZE())      181
String functions, trailing-space characters, removed (RTRIM)      715
String functions, upper case, changing characters to (UCASE)      719
String functions, white spaces, trimming (TRIM())      139
String, argument, value writing to file (FWRITE())      172
String, array elements, concatenating (JOIN())      154
String, array, turning into (IMPLODE())      151
String, cleaning up for use as HTML tag (make_page_title())      670
String, connection, content-management system      362—365
String, date      36
String, delimiting, PHP scripts      94—96
String, encrypting for Unix      731—732
String, for matches to a pattern (PREG_MATCH_ALL())      148
String, formatting according to C-style pattern (SPRINTF())      166
String, match, testing for (ereg())      143—144
String, MD5 checksum, calculating      732
String, one-way hash, returning (CRYPT())      139
String, password, encrypting and decrypting      732
String, Perl regular expression string, transforming into array (PREG_SPLIT())      152—153
String, regular expression, transforming into array (SPLIT())      151—152
String, replacing based on complex patterns (EREG_REPLACE())      144—145
String, transforming into array (EXPLODE())      150—151
String, type of variable, returning as (GETTYPE())      153
String, URL functions, encoding (urlencode())      185
String, variable functions, testing (is_array(), is_numeric(), and is_string())      148
String, zero-length      24
Style, catalog, class      433—434
Style, catalog, inserting (MAP_STYLE())      429
Style, catalog, printing      436—437
Submit field, form      674
Subpattern      147
Subqueries, correlated      86—87
Subset of columns, grouping (group by options)      79—80
Substring, position (INSTR)      713
Substring, returning (SUBSTR())      141
SUBSTRING_INDEX      714—715
Subtitles, HTML element      672
Sum of given column, returning (sum() function)      77—78
Sunday, week beginning (DAYOFWEEK)      719—720
Superset, text values (set)      32—33
Survey application, claim code, checking (claim.php)      304—308
Survey application, code overview      270—273 274—276
Survey application, database design      266—270
Survey application, described      294—298
Survey application, HTML functions, arguments, handling      276—281
Survey application, HTML functions, character separating directory names (path_separator())      292
Survey application, HTML functions, checkbox, default status      290—291
Survey application, HTML functions, directory, adding to default path (ADD_TO_INCLUDE_PATH())      292—293
Survey application, HTML functions, initialization code      293—294
Survey application, HTML functions, questions, adding, editing and deleting (admin/questions.php)      298—303
Survey application, HTML functions, random winner, drawing (admin/get_winner.php)      303
Survey application, HTML functions, scope and goals      261—266
Survey application, HTML functions, site configuration, sharing information (book_constants())      291
Survey application, HTML functions, tags, creating common (FROM /BOOK/FUNCTIONS/HTML/)      281—289
Survey application, HTML functions, text field, printing      289—290
Survey application, HTML functions, winner, notifying (admin/winners.php)      303—304
System requirements, back-of-the-book CD      557
Table structure (first normal form)      10—11
Table, BerkeleyDB      40—41
Table, catalog, inherited classes (LEGAL_VALUES())      420—421
Table, catalog, query for later-named (FETCH_SIMPLE_QUERY())      415
Table, columns, adding      42
Table, columns, definitions, changing      43—44
Table, columns, dropping      43
Table, columns, types      29—37
Table, content-management system, authors (write_author())      381—382
Table, content-management system, building for workflow stages (stage_table_name())      380—381
Table, content-management system, of stories, creating or updating (write_story())      382—387
Table, creating      26—29 47—48
Table, data storage, simple and problematic      6
Table, default working, defining (use command)      27
Table, deleting data      59—61
Table, described      600—601
Table, eliminating duplicate data (distinct clause)      70
Table, Flush      591
Table, group by and aggregate functions      74—80
Table, Heap      41
Table, HTML tags, cell      673
Table, HTML tags, closing      672
Table, HTML tags, row      672—673
Table, HTML tags, table inside paragraph (start_table())      672
Table, indexes, adding      43
Table, indexes, creating      37—38
Table, indexes, dropping      43
Table, InnoDB      40—41
Table, inserting data      53—55
Table, interfaces      23
Table, joining      80—87
Table, MyISAM      39—40
Table, name, changing      41—42
Table, name, returning result (FETCH_SIMPLE())      415—416
Table, null values      24—25
Table, query, laying out in (select_to_table())      679
Table, replacing data      61—64
Table, retrieving values, select statement      64—67
Table, retrieving values, with predicate (in/not in)      71—72
Table, retrieving values, with wildcard characters (like clause)      72
Table, retrieving values, within a range (between)      70—71
Table, rows, restricting number returned (limit parameter)      73
Table, rows, retrieving limited (where clause)      67—70
Table, rows, returned, restricting number (limit)      73
Table, rows, specifying order returned (order by command)      73
Table, selecting values (db_fetch_record())      670
Table, separating into multiple new      5
Table, SQL, deleting from (delete_row())      678
Table, staff (fetch_staff())      453—454
Table, status (show command)      47
Table, updating data      55—59
Table, user      599—600
Table, username and password, verifying against (authenticate())      669
Table, viewing      45
Tags, creating common for HTML survey (FROM /BOOK/FUNCTIONS/HTML/)      281—289
Tags, HTML and PHP, removing (cleanup_text())      669
Tags, Netscape references      696
Tags, string, cleaning up for use as HTML (make_page_title())      670
Tags, title (MAKE_PAGE_TITLE())      240
Tangent (TAN)      706
Tasks, project management database      543
Tasks, status, project management database      542
Terminating, command (G)      176
Terminating, script after outputting argument string (die())      176
Testing end of file (FEOF())      172
Testing for array (is_array())      113
Testing for Boolean (is_bool())      113—114
Testing for existence of directory (IS_DIR())      174
Testing for existence of file (FILE_EXISTS())      173
Testing for existence of script control functions (function_exists())      177
Testing for floating-point or double number (is_double())      113
Testing for NULL value (nullop())      373—374
Testing for object (is_object())      114
Testing for resource (is_resource())      114
Testing for text string (is_string())      113
Testing for type of variable (gettype())      114
Testing for type other than array, object, or resource (is_scalar())      114
Testing value, finding (isset())      112
Testing variable functions for type (is_array(), is_numeric(), and is_string())      148
Testing variables for empty setting      112—113
Testing variables for integer (is_int())      113
Testing variables for NULL      113
Testing whether values identical      119
Text box, form (textarea_field())      673—674
Text entry, HTML form input (textarea)      566—567
Text field, form      674
Text field, printing, HTML survey      289—290
Text file, address book, creating      4
Text string, image function (GETIMAGESIZE())      181
Text string, storing, char      30
Text string, storing, described      29
Text string, storing, large strings and binary objects (tinytext / tinyblob, text /blob, mediumtext / mediumblob, longtext)      31—32
Text string, storing, limited potential values (enum)      32
Text string, storing, values, defined superset (set)      32—33
Text string, storing, varchar      30
Text string, testing for (is_string())      113
Text, buttons      569
Text, form      673
Text, HTTP, blocking further headers (header_sent())      180
Text, manipulating with user-defined functions      669—670
Text, testing contents      119—121
Third normal form      13—14
Threaded discussion, application scope and goals      312—316
Threaded discussion, code, main functions      320—321
Threaded discussion, data      316—320
Threaded discussion, described      311—312
Threaded discussion, error-handling and debugging, constant, defining to use in bitmask (get_constant())      345—347
Threaded discussion, error-handling and debugging, described      332—333
Threaded discussion, error-handling and debugging, function, calling when error occurs (error_handler())      337—345
Threaded discussion, error-handling and debugging, level displayed and logged      333
Threaded discussion, error-handling and debugging, simplifying (push_handler() and pop_handler())      337
Threaded discussion, error-handling and debugging, tracking responses to types      333—336
Threaded discussion, form data, inserting into database (create_topic())      329—332
Threaded discussion, function displayed and described (display_kids())      321—326
Threaded discussion, information about given topic, displaying (display_topic())      326—329
Threaded discussion, reusable functions      321
Threads, viewing active      589—590
Thumbnails images      183 430
Time, current (CURTIME)      729
Timeout lock      732—733
Timestamp, UNIX      729—730
Title, Guestbook 2003 tags (MAKE_PAGE_TITLE())      240
To, replacing from in string (REPLACE)      716
Token replacement      369
Topic, information about given topic, displaying (display_topic()) threaded discussion      326—329
Tracking error responses      333—336
Transaction      20—21 421—422
Translating, escape code characters into HTML (HTMLENTITIES() and HTMLSPECIALCHARS())      139
Tree structure      488—490
Trimming white space      139
Triple equals sign (===)      93
Troubleshooting, CD, back-of-the-book      560
True or false, if statement      118—122
True or false, variable functions (isset())      148
True or false, whether key exists in array (ARRAY_KEY_EXISTS())      158
Truncating to D decimals (TRUNCATE)      704
Turning off, output buffering (OB_END_CLEAN(), OB_END_FLUSH())      188
Two-digit year format (year[(2|4)]), date and time columns      37
Two-dimensional arrays, assigning, PHP scripts      99
Type of variable, returning as string (GETTYPE())      153
Type of variable, setting      634—635
Type of variable, testing (is_array(), is_numeric(), and is_string(), gettype())      114 148
Type, image function (GETIMAGESIZE())      181
Type, image, checking (EXIF_IMAGETYPE())      183
Type-conversion functions, array elements, case-insensitive pattern match (split())      155
Type-conversion functions, array elements, comparing variables      92—93
Type-conversion functions, array elements, concatenating in a string (JOIN())      154
Type-conversion functions, array elements, converting into variables (COMPACT())      153
Type-conversion functions, array elements, described      149—150
Type-conversion functions, array elements, floating-point numbers, converting to formatted string (NUMBER_FORMAT())      154
Type-conversion functions, array elements, key / value pairs, pulling from array and making into standalone variables (EXTRACT())      153—154
Type-conversion functions, array elements, Perl regular expression string, transforming into array (PREG_SPLIT())      152—153
Type-conversion functions, array elements, regular expression string, transforming into array (SPLIT())      151—152
Type-conversion functions, array elements, scalar variable, returning as integer or floating-point variable (INTVAL() and FLOATVAL())      153
Type-conversion functions, array elements, setting to specified (SETTYPE())      153
Type-conversion functions, array elements, string, transforming into array (EXPLODE())      150—151
Type-conversion functions, array elements, type of variable, returning as string (GETTYPE())      153
Type-conversion functions, array, creating and populating with elements (RANGE())      154
Type-conversion functions, array, turning into string (IMPLODE())      151
U.S. dollar value, formatting (money())      670
Unencoding non-alphanumeric characters in URL functions (rawurldecode())      185
Uniform Resource Locator      See URL
Unix, CD, back-of-the-book      557
Unix, epoch, time since      730
Unix, installation, MySQL/PHP, described      575—578
Unix, installation, MySQL/PHP, PHP/Apache      578—580
Unix, seconds since Epoch (MICROTIME())      169—170
Unix, string, encrypting      731—732
Unix, timestamp      729—730
Unmapped root-level styles, retrieving (LIST_UNMAPPED_STYLES())      425
Unmask value, setting (UMASK())      173
Unordered (ul_list())      672
Unsetting variable functions      148
Update queries, adding slashes (ADDSLASHES())      138
Update queries, removing slashes (STRIPSLASHES())      138—139
Update queries, testing      124
Update, anomalies      5 8
Update, SQL statements, running      677—678
Updating catalog record (UPDATE_RECORD())      419
Updating content-management system, authors table (write_author())      381—382
Updating content-management system, stories table (write_story())      382—387
Updating data in tables      55—59
Updating problem-tracking system, individual entries (history_entry())      459—461
Updating problem-tracking system, script (problem.php)      464—465
Uploaded file, check and then move (MOVE_UPLOADED_FILE())      175
Uploaded file, HTTP, checking (IS_UPLOADED_FILE())      174
Uploading files to catalog      409—410
Uploading files, project management      545 552
Uppercase, letters, changing (STRTOLOWER(), STRTOUPPER(), UCFIRST(), and UCWORDS())      141
Uppercase, string, changing (STRTOLOWER(), STRTOUPPER(), UCFIRST(), and UCWORDS())      141
URL (Uniform Resource Locator), control characters      186
URL (Uniform Resource Locator), described      184—185
URL (Uniform Resource Locator), file pointer, opening to indicated (FOPEN())      171—172
URL (Uniform Resource Locator), non-alphanumeric characters      185
URL (Uniform Resource Locator), string, encoding (urlencode())      185
URL (Uniform Resource Locator), undoing encoding (urldecode())      185
User administration, database table      600—601
User administration, grant statement      602—604
User administration, reloading grants      605
User administration, revoke statement      602 604
User administration, rights, granting      597—598
User administration, tables_priv      601—602
User administration, user table      599—600
User administration, viewing grants      604
User authentication, content-management system (content/authenticate.php)      387—389
User authentication, getting from browser or verifying against database table (authenticate())      669
User authentication, Guestbook 2003 library (GUESTBOOK_AUTHENTICATE())      244—248
User, error message, sending (trigger_error() and user_error())      187
User, postings, finding all (fetch_user())      378—379
User, project management database, adding information      545
User, project management database, design      542
User, project management database, mapping      543
User, project management database, types      541—542
User, project management database, verifying information, (CREATE_ENTRY())      250—253
User, validating (connect_validate_login())      374—375
1 2 3 4 5 6 7
blank
Ðåêëàìà
blank
blank
HR
@Mail.ru
       © Ýëåêòðîííàÿ áèáëèîòåêà ïîïå÷èòåëüñêîãî ñîâåòà ìåõìàòà ÌÃÓ, 2004-2025
Ýëåêòðîííàÿ áèáëèîòåêà ìåõìàòà ÌÃÓ | Valid HTML 4.01! | Valid CSS! Î ïðîåêòå