Àâòîðèçàöèÿ
Ïîèñê ïî óêàçàòåëÿì
Bulger B., Greenspan J., Wall D. — MySQL/PHP Database Applications
Îáñóäèòå êíèãó íà íàó÷íîì ôîðóìå Íàøëè îïå÷àòêó?
Íàçâàíèå: 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.
ßçûê: Ðóáðèêà: Ðóêîâîäñòâà ïî ïðîãðàììíîìó îáåñïå÷åíèþ /Ñòàòóñ ïðåäìåòíîãî óêàçàòåëÿ: Ãîòîâ óêàçàòåëü ñ íîìåðàìè ñòðàíèö ed2k: ed2k stats Èçäàíèå: 2nd EditionÃîä èçäàíèÿ: 2003Êîëè÷åñòâî ñòðàíèö: 818Äîáàâëåíà â êàòàëîã: 13.05.2005Îïåðàöèè: Ïîëîæèòü íà ïîëêó |
Ñêîïèðîâàòü ññûëêó äëÿ ôîðóìà | Ñêîïèðîâàòü ID
Ïðåäìåòíûé óêàçàòåëü
Problems, data-storage methods See Anomalies Procedural code 21—22 220—221 Process, ending 590 Products, catalog records, constructor (__CONSTRUCT()) 422—423 Products, catalog records, ID value of new image (UPLOAD()) 430 Products, catalog records, image matching display (THUMBNAIL()) 430 Products, catalog records, images (IMG()) 429—430 Products, catalog records, LIST_ALL_CHILDREN() and LIST_CHILDREN() 423—424 Products, catalog records, mappings, retrieving (LIST_MAPPED_STYLES()) 426—428 Products, catalog records, notes, adding (ADD_NOTES()) 424—425 Products, catalog records, overloading methods (__GET() and __CALL()) 430—431 Products, catalog records, PRICE() 423 Products, catalog records, record, saving (WRITE_TO_DB()) 428—429 Products, catalog records, style, inserting (MAP_STYLE()) 429 Products, catalog records, unmapped root-level styles, retrieving (LIST_UNMAPPED_STYLES()) 425 Products, printing, catalog 435—436 Products, printing, list in shopping cart (DISPLAY.PHP) 492—493 Project management, application goals 537—541 Project management, code, active projects, showing 544—545 Project management, code, authentication 546—548 Project management, code, file contents, displaying 553 Project management, code, logging in and establishing session 544 Project management, code, new project, creating 545 Project management, code, projects' status, viewing 548—552 Project management, code, session management 545—546 Project management, code, uploading files 545 552 Project management, code, user, adding 545 Project management, code, viewing files 545 Project management, database design, application users 542 Project management, database design, described 541 Project management, database design, files 543—544 Project management, database design, mapping to users 543 Project management, database design, projects 542 Project management, database design, status 542 Project management, database design, tasks 543 Project management, database design, user types 541—542 Properties, array of (get_object_vars()) 164 Properties, defined 209 Properties, empty, leaving out (DATA_FIELDS()) 418 Properties, value, setting in catalog classes (BUILD()) 414 Protocol, encryption and security 482 Public-key encryption 481 Query, common, dealing with 676—680 Query, for later-named table (FETCH_SIMPLE_QUERY()) 415 Query, laying out in table (select_to_table()) 679 Query, printing (PRINT_ENTRY()) 248—249 Query, returning in one result set (union) 86 Query, shorthand (db_values_array()) 372—373 Query, writing safely (SAFE_MYSQL_QUERY()) 243—244 Questions, survey 298—303 Quotation marks, magic 581 Radians, degrees, converting segment from 709 Radians, segment, converting to degrees 708 Radio Button 675 Raising to power of Y (POW) 705 Random array elements, creating (SHUFFLE()) 163 Random array elements, picking (ARRAY_RAND()) 162—163 Random floating-point value (RAND) 707 Random number generator 177—178 632 Random winner, drawing (admin/get_winner.php) 303 Range, retrieving values within (between) 70—71 Reading, file line by line (FILE()) 173 Reading, from file pointer to specified number of bytes or to the end (FREAD()) 172 Record, catalog, classes, updating (UPDATE_RECORD()) 419 Record, catalog, creating (CREATE_RECORD()) 419 Record, catalog, deleting (DELETE_FROM_DB()) 417 Record, catalog, getting by ID value (FETCH_FROM_DB()) 416—417 Record, catalog, returning single (FETCH_RECORD()) 416 Record, catalog, saving (WRITE_TO_DB()) 428—429 Record, content-management system, getting (db_fetch_record()) 369—372 Record, content-management system, story (fetch_story()) 375—376 Record, shopping cart tree structure 488—490 Recording most recent changes in date and time columns (timestamp) 36 Referential integrity 19—20 Regular expression, character classes 661—663 Regular expression, characters 660—661 Regular expression, described 659 Regular expression, example 665—667 Regular expression, functions, altering to use in case-insensitive expressions (sql_regcase()) 145—146 Regular expression, functions, described 142—143 633 Regular expression, functions, match, testing string (ereg()) 143—144 Regular expression, functions, PCRE 146—148 633—634 Regular expression, functions, string, replacing based on complex patterns (EREG_REPLACE()) 144—145 Regular expression, multiple occurrences 663—665 Regular expression, patterns, matching to series of known characters (literal patterns) 659—660 Regular expression, Perl string, transforming into array (PREG_SPLIT()) 152—153 Regular expression, specifying “or” 665 Regular expression, string expression, matching (REGEXP and NOT REGEXP) 698 Regular expression, string, transforming into array (SPLIT()) 151—152 Relational databases, benefits of 3—5 Relationships, database design, many-to-many 17—19 Relationships, database design, one-to-many 15—16 Relationships, database design, one-to-one 16—17 Reloading user grants 605 Remainder of # divided by M (MOD) 703 Removing See deleting Repeating string 717 Replacing, arguments in strings (STR_REPLACE()) 140 Replacing, non-alphanumeric characters in URL, functions (rawurlencode()) 185 Replacing, PCRE (PREG_REPLACE()) 147 Replacing, string based on complex patterns (PREG_REPLACE()) 144—145 Replacing, table data 61—64 Reporting level, error functions (error_reporting()) 186 Request, shopping cart code 487—488 Request, SOAP 522—523 Required files 199 Reset form 675 Resource, testing for (is_resource()) 114 Resource, type other than, testing for (is_scalar()) 114 Response, SOAP 523 Response, tracking 333—336 Restricting, grouped rows (having predicate) 80 Restricting, number of rows returned (limit) 73 Retrieving, handlers (SESSION_SET_SAVE_HANDLER()) 485 Retrieving, limited rows (where clause) from table 67—70 Retrieving, mappings, catalog products (LIST_MAPPED_STYLES()) 426—428 Retrieving, table data (select) 64—67 Retrieving, unmapped root-level styles, catalog products (LIST_UNMAPPED_STYLES()) 425 Retrieving, values, with predicate (in/not in) 71—72 Retrieving, values, with wildcard characters (like clause) 72 Retrieving, values, within a range (between) 70—71 Return values, generated by called function, in original order (ARRAY_MAP()) 158—159 Return values, PHP functions 135—136 Return values, user-defined functions 203—205 Reusable functions 321 Reversing, character order (REVERSE) 717 Reversing, string (STRREV()) 141 Reversing, text cleanup (REVERSE_CLEANUP_TEXT()), Guestbook 2003 239—240 Revoke statement, user privileges 602 604 Right-padded string (RPAD) 713 Rightmost len characters (RIGHT) 714 Rights, granting to users 597—598 ROLLBACK() catalog classes 422 Rounding, floating-point (floor()) variable functions 149 Rounding, to integer and specified number of decimal places (ROUND) 704 Row, counting number in each group (count() function) 74—77 Row, grouped, restricting (having predicate) 80 Row, HTML tags 672—673 Row, restricting number returned (limit parameter) 73 Row, retrieving limited (where clause) from table 67—70 Row, specifying order returned (order by command) 73 Runtime Labs 50 SAPI (Server Application Programming Interface) 189 Saving, catalog class values (WRITE_TO_DB()) 420 Saving, record (WRITE_TODB()), catalog products class 428—429 Scalar variable, returning as integer or floating-point variable (INTVAL() and FLOATVAL()) 153 Screen, variable, printing entire contents (PRINT_R()) 166 Script, control functions, argument string, outputting and then terminating script (die()) 176 Script, control functions, code stored in variable, executing (eval()) 176 Script, control functions, function's arguments, obtaining information (func_get_arg(), func_get_args(), and func_num_args()) 176—177 Script, control functions, language constructs (include(), include_once(), require(), and require_once()) 177 Script, control functions, testing for existence (function_exists()) 177 Script, control functions, user-defined function 176 Script, Guestbook 2003 259 Script, problem-tracking system, customer response (write_customer.php) 466—473 Script, problem-tracking system, enter or updating problem (problem.php) 464—465 Script, problem-tracking system, form (problem_entry_form.php) 465—466 Script, problem-tracking system, staff members, logging in (staff/problems.php) 473—475 Script, sample catalog 434—439 Script, shopping cart, checkout 495—504 Script, shopping cart, creating cart (CART.PHP) 493—495 Script, shopping cart, list of categories or specific products, printing (DISPLAY.PHP) 492—493 Script, terminating after outputting argument string (die()) 176 Searching, full-text, string comparison functions (MATCH...AGAINST) 699 Second normal form 11—13 Seconds, converting time to (SEC_TO_TIME) 730 Seconds, formatting current time (TIME_TO_SEC) 730 Seconds, since Unix Epoch (MICROTIME()) 169—170 Security, catalog, determining 402—403 Security, certificates 481—482 Security, content-management system 353—355 Security, described 480—481 Security, global variables, problems with 101 Security, malicious text, barring (CLEANUP_TEXT()) 239 Security, password 235 732 Security, problem-tracking system 444 Security, public-key / private-key 481 Security, reversing text cleanup (REVERSE_CLEANUP_TEXT()) 239—240 Security, secure protocol 482 Security, shopping cart 479 Security, survey application 265—266 Security, threaded discussion 314—315 Security, tools 482 Seeding random number generator (mt_srand()) 178 Segment, degrees, converting to radians (RADIANS) 709 Segment, radians, converting to degrees (DEGREES) 708 Select, form field 675 Select, HTML form input 565—566 Select, query, testing 124 Selecting database values (db_fetch_record()) 670 Self join tables 85—86 Self-made character classes 662—663 Sending email to customer (notify_customer()) 461—462 Sending error message (trigger_error() and user_error()) 187 Server Application Programming Interface See SAPI Server, application, writing 534—535 Server, availability on 44—45 Server, HTTP, communicating with (header()) 179—180 Server, version, finding 731 Service call 526—527 Session, browser-passed variables, accessing 106—107 Session, establishing 544 Session, functions 635—637 Session, handling, user-defined functions 680—682 Session, PHP functions 179 Session, project management code 545—546 Session, settings, changing 582 Session, shopping cart, database variable format (SESSION_ENCODE()) 485 Session, shopping cart, described 483 Session, shopping cart, handlers, storing, retrieving, and writing custom (SESSION_SET_SAVE_HANDLER()) 485 Session, shopping cart, killing (SESSION_DESTROY()) 485 Session, shopping cart, PHP variables, creating (SESSION_DECODE()) 485 Session, shopping cart, start (SESSION_START()) 485 Sharing information (book_constants()) 291 Shopping cart, Apache, configuring for credit-card authorization 482—483 Shopping cart, application scope and goals 477—479 Shopping cart, code classes 486—492 Shopping cart, credit-card processor 486 Shopping cart, data 479—480 Shopping cart, encryption and security configuration 480—482 Shopping cart, scripts, checkout 495—504 Shopping cart, scripts, creating cart (CART.PHP) 493—495 Shopping cart, scripts, printing categories or specific products (DISPLAY.PHP) 492—493 Shopping cart, sessions 483—485 Simple Object Access Protocol See SOAP Simplexml 509—511 Sine (SIN) 706 Single record, returning (FETCH_RECORD()) 416 Site configuration, sharing information (book_constants()), HTML survey 291 Slashdot headline 511—512 Slashes, adding to insert and update queries in strings (ADDSLASHES()) 138 Slashes, insert and update queries, adding to (ADDSLASHES()) 138 Slashes, removing from insert and update queries (STRIPSLASHES()) 138—139 Sleepycat software 41 Smallest argument (LEAST) 707—708 Smallest integer value not greater than X (CEILING) 703 SOAP (Simple Object Access Protocol), body 521—522 SOAP (Simple Object Access Protocol), complex data types 523—524 SOAP (Simple Object Access Protocol), described 519 SOAP (Simple Object Access Protocol), envelope 520—521 SOAP (Simple Object Access Protocol), NuSOAP, application goals, determining 527—528 SOAP (Simple Object Access Protocol), NuSOAP, Babelfish application 532—534 SOAP (Simple Object Access Protocol), NuSOAP, Barnes & Noble application 528—531 SOAP (Simple Object Access Protocol), NuSOAP, described 524—526 SOAP (Simple Object Access Protocol), NuSOAP, server application, writing 534—535 SOAP (Simple Object Access Protocol), NuSOAP, service call, sample 526—527 SOAP (Simple Object Access Protocol), request 522—523 SOAP (Simple Object Access Protocol), response 523 Socket domain connection (fsock) 627 Sorting array by ascending or alphabetical order 163 Sorting by any column type (order by) 73 Soundex string 716 Space character (#) 717 SQL statements, indenting 196—197 SQL statements, running, insert 676—677 SQL statements, running, update 677—678 Square root, non-negative (SQRT) 705 Staff members, logging in (staff/problems.php) 473—475 Staff members, table (fetch_staff()) 453—454 Stages, content-management system, looking up (stage(), stage_id(), stages()) 379—380 Standard deviation of expr (STD/STDDEV) 733 Start form 673 Start output buffering (OB_START()) 188 Start shopping cart session (SESSION_START()) 485 State name function 670 Statement used to create table 47—48 Status, file 625—626 Status, information commands 587—590 Status, MySQL 589 Status, problem-tracking system, tracking (status_change()) 462—464 Status, project, viewing 548—552 Status, table 47 Status, tasks within projects 542 Stopping sessions (SESSION_DESTROY()) 0 Stored procedures 21—22 Storing, handlers (SESSION_SET_SAVE_HANDLER()), shopping cart session 485 Story, content-management system, finding by author (function fetch_author()) 378 Story, content-management system, record, getting (fetch_story()) 375—376 Story, content-management system, table of, creating or updating (write_story()) 382—387 Story, content-management system, version, getting (fetch_story_version()) 376—378 Stream, image 182 String functions, ASCII-code value 709 String functions, character count (STRLEN()) 140 String functions, comparison, full string (STRCMP) 699 String functions, comparison, full-text searching (MATCH...AGAINST) 699 String functions, comparison, string expression, matching against regular expression (REGEXP and NOT REGEXP) 698 String functions, comparison, wildcard characters, pattern matching (LIKE and NOT LIKE) 697 String functions, concatenation of arguments (CONCAT) 711—712 String functions, conversion, capitalization (STRTOLOWER(), STRTOUPPER(), UCFIRST(), and UCWORDS()) 141 String functions, conversion, character order, reversing (REVERSE) 717 String functions, conversion, from, replacing with to (REPLACE) 716 String functions, conversion, HTML break, adding after each newline (NL2BR()) 141—142 String functions, conversion, HTML escape codes, translating characters into (HTMLENTITIES() and HTMLSPECIALCHARS()) 139 String functions, conversion, lower case, changing characters to (LCASE) 718 String functions, conversion, numbers, converting bases (CONV) 710 String functions, conversion, replacing arguments (STR_REPLACE()) 140 String functions, conversion, reversing (STRREV()) 141 String functions, hexadecimal value (HEX) 711 String functions, HTML and PHP tags, removing (STRIP_TAGS()) 137—138 String functions, index (FIELD) 718
Ðåêëàìà
|
|
Î ïðîåêòå