Àâòîðèçàöèÿ
Ïîèñê ïî óêàçàòåëÿì
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
Ïðåäìåòíûé óêàçàòåëü
File system, file pointer, opening to indicated file or URL (FOPEN()) 171—172 File system, HTTP, whether uploaded (IS_UPLOADED_FILE()) 174 File system, path elements, cutting off all but base (BASENAME()) 175 File system, PHP functions 170—175 File system, reading from file pointer to specified number of bytes or to the end (FREAD()) 172 File system, reading line by line (FILE()) 173 File system, single line indicated by pointer (FGETS()) 172—173 File system, unmask value, setting (UMASK()) 173 File system, value of string argument, writing to file (FWRITE()) 172 File, adding automatically 581—582 File, File, contents, displaying 553 File, form field 674 File, functions, working with 623—625 File, project management database 543—544 File, status 625—626 File, uploading 409—410 545 552 File, viewing 545 Filtering, array functions 157—158 Finding, stories by author in content-management system (function fetch_author()) 378 Finding, user postings in content-management system (fetch_user()) 378—379 Finding, value (isset()) 112 First element, return and remove (ARRAY_SHIFT()) 160 First normal form 10—11 Floating-point number, converting to formatted string (NUMBER_FORMAT()) 154 Floating-point number, double-precision, storing (double / doubleprecision / real) 35 Floating-point number, numeric columns, storing 34—35 Floating-point number, rounding down (floor()) 149 Floating-point number, scalar, returning as (FLOATVAL()) 153 Floating-point number, testing (is_double()) 113 Flush commands 590—591 font tag, HTML element functions 671 For loop 129—130 foreach loop 130—131 Foreign key 19—20 Form, data, inserting into database (create_topic()) 329—332 Form, elements, checkbox 675 Form, elements, ending 673 Form, elements, file field 674 Form, elements, hidden element 674 Form, elements, image 675 Form, elements, password field 674 Form, elements, radio button 675 Form, elements, reset 675 Form, elements, select (popup) field 675 Form, elements, starting 673 Form, elements, submit field 674 Form, elements, text 673 Form, elements, text box (textarea_field()) 673—674 Form, elements, text field 674 Form, input, blocking vandals 231—234 Form, PHP functions 134 Form, problem-tracking system (problem_entry_form.php) 465—466 Formatting, ASCII string (ORD) 709 Formatting, date and time, current time as seconds (TIME_TO_SEC) 730 Formatting, date and time, full name of month 721 Formatting, date and time, full name of weekday (DAYNAME) 721 Formatting, date and time, hour 722 Formatting, date and time, hour, minute, second (time) 37 Formatting, date and time, setting (DATE_FORMAT) 726—728 Formatting, date and time, two-digit year (year[(2|4)]) 37 Formatting, date and time, week beginning with Monday index (WEEKDAY) 720 Formatting, date and time, week beginning with Sunday index (DAYOFWEEK) 719—720 Formatting, date and time, week of year (YEARWEEK) 722 Formatting, date and time, year 722 Formatting, date and time, year, month, day 36 Formatting, date and time, year, month, day, time 36 Formatting, shopping cart database variable (SESSION_ENCODE()) 485 Formatting, string according to C-style pattern (SPRINTF()) 166 Formatting, U.S. dollar value (money()) 670 From, replacing with to in string (REPLACE) 716 FTP functions 641—643 Function See also Specific functions listed by type Function, BC math 640 Function, calling when error occurs (error_handler()) 337—345 Function, calls, indenting 194—196 Function, displayed and described (display_kids()) 321—326 Function, execution 622 Function, GROUP BY clause 733—734 Function, incremental value, returning last automatically generated 732 Function, reusable, threaded discussion 321 Function, timeout lock 732—733 Gate-keeping See Security GD functions 644—650 GD library configuration (IMAGETYPES()) 183 Global variables 205—208 580 Grant statement, user administration 602—604 Graphical User Interface See GUI database tools Graphics See Image group by and aggregate functions, average (avg()) 78—79 group by and aggregate functions, counting number of rows in each group (count() function) 74—77 group by and aggregate functions, grouped rows, restricting (having predicate) 80 group by and aggregate functions, highest value, removing (max() function) 78 group by and aggregate functions, lowest value, removing (min() function) 78 group by and aggregate functions, subset of columns, grouping (group by options) 79—80 group by and aggregate functions, sum of given column, returning (sum() function) 77—78 Grouping, caption for (legend), HTML form input 569 Guestbook 2003, application, designing 229—230 Guestbook 2003, code overview 235—236 Guestbook 2003, database call, putting together (SELECT_ENTRIES()) 253—254 Guestbook 2003, database design 234—235 Guestbook 2003, defensive and text-handling functions, character-set-encoding value (CHARSET()) 238—239 Guestbook 2003, defensive and text-handling functions, constant (FROM /GUESTBOOK2K/GLOBALS.PHP) 241—242 Guestbook 2003, defensive and text-handling functions, header (FROM /GUESTBOOK2K/HEADER.PHP) 240—241 Guestbook 2003, defensive and text-handling functions, malicious text, barring (CLEANUP_TEXT()) 239 Guestbook 2003, defensive and text-handling functions, reversing text cleanup (REVERSE_CLEANUP_TEXT()) 239—240 Guestbook 2003, defensive and text-handling functions, title tags (MAKE_PAGE_TITLE()) 240 Guestbook 2003, described 229 Guestbook 2003, entries 255—259 Guestbook 2003, form input, blocking vandals 231—234 Guestbook 2003, general utility functions 236—238 Guestbook 2003, header (FROM /GUESTBOOK2K/HEADER.PHP) 240—241 Guestbook 2003, library, viewing (FROM /GUESTBOOK2K/FUNCTIONS.PHP), database call, putting together (SELECT_ENTRIES()) 253—254 Guestbook 2003, library, viewing (FROM /GUESTBOOK2K/FUNCTIONS.PHP), disconnecting (MYSQL_DBCONNECT()) 242—243 Guestbook 2003, library, viewing (FROM /GUESTBOOK2K/FUNCTIONS.PHP), Guestbook 2003, arguments, printing (PRINT_INPUT_FIELDS()) 249—250 Guestbook 2003, library, viewing (FROM /GUESTBOOK2K/FUNCTIONS.PHP), navigational elements, creating (NAV()) 254—255 Guestbook 2003, library, viewing (FROM /GUESTBOOK2K/FUNCTIONS.PHP), queries, writing safely (SAFE_MYSQL_QUERY()) 243—244 Guestbook 2003, library, viewing (FROM /GUESTBOOK2K/FUNCTIONS.PHP), query, printing (PRINT_ENTRY()) 248—249 Guestbook 2003, library, viewing (FROM /GUESTBOOK2K/FUNCTIONS.PHP), user authentication (GUESTBOOK_AUTHENTICATE()) 244—248 Guestbook 2003, library, viewing (FROM /GUESTBOOK2K/FUNCTIONS.PHP), verifying user information (CREATE_ENTRY()) 250—253 Guestbook 2003, necessary pages 230—231 Guestbook 2003, scripts 259 Guestbook 2003, title tags (MAKE_PAGE_TITLE()) 240 GUI (graphical user interface) database tools 48—52 Handlers, session 485 Hash, one-way string (CRYPT()) 139 Header, file, Barnes & Noble application 529 Header, functions 627 Header, Guestbook 2003 (FROM /GUESTBOOK2K/HEADER.PHP) 240—241 Header, HTML, typical 197 Header, HTTP, PHP functions 179—181 Header, including 255—256 Heap 41 Height, image (GETIMAGESIZE()) 181 Heredoc syntax 95 Hexadecimal value (HEX) 711 Hidden element, form 674 Highest value, removing (max() function) 78 Hot key See Access key Hours, formatting 37 722 HTML (HyperText Markup Language) 4.0, character entity references 696 HTML (HyperText Markup Language), break, adding after each newline (NL2BR()) 141—142 HTML (HyperText Markup Language), element functions, anchor tag 671 HTML (HyperText Markup Language), element functions, font tag 671 HTML (HyperText Markup Language), element functions, image tag 671 HTML (HyperText Markup Language), element functions, paragraphs 672 HTML (HyperText Markup Language), element functions, subtitles 672 HTML (HyperText Markup Language), element functions, unordered (bulleted list) (ul_list()) 672 HTML (HyperText Markup Language), escape codes, translating characters into (HTMLENTITIES() and HTMLSPECIALCHARS()) 139 HTML (HyperText Markup Language), forms, access key 568 HTML (HyperText Markup Language), forms, browser-passed variables, accessing 100—102 HTML (HyperText Markup Language), forms, buttons with text and image 569 HTML (HyperText Markup Language), forms, caption for grouping (legend) 569 HTML (HyperText Markup Language), forms, opening and closing tags (form) 561—562 HTML (HyperText Markup Language), forms, overview 562—565 HTML (HyperText Markup Language), forms, select, multiple select 565—566 HTML (HyperText Markup Language), forms, Tab key (tabindex) 568 HTML (HyperText Markup Language), forms, text entry (textarea) 566—567 HTML (HyperText Markup Language), forms, text surrounded by thin line (fieldset) 569 HTML (HyperText Markup Language), functions 627—628 HTML (HyperText Markup Language), removing tags, general(cleanup_text()) 669 HTML (HyperText Markup Language), removing tags, string (STRIP_TAGS()) 137—138 HTML (HyperText Markup Language), removing tags, string for use as (make_page_title()) 670 HTML (HyperText Markup Language), survey, arguments, handling 276—281 HTML (HyperText Markup Language), survey, character separating directory names (path_separator()) 292 HTML (HyperText Markup Language), survey, checkbox, default status 290—291 HTML (HyperText Markup Language), survey, directory, adding to default path (ADD_TO_INCLUDE_PATH()) 292—293 HTML (HyperText Markup Language), survey, initialization code 293—294 HTML (HyperText Markup Language), survey, site configuration, sharing information (book_constants()) 291 HTML (HyperText Markup Language), survey, tags, creating common (FROM /BOOK/FUNCTIONS/HTML/) 281—289 HTML (HyperText Markup Language), survey, text field, printing 289—290 HTML (HyperText Markup Language), tables, cell tag 673 HTML (HyperText Markup Language), tables, closing tag 672 HTML (HyperText Markup Language), tables, inside paragraph tags (start_table()) 672 HTML (HyperText Markup Language), tables, row tags 672—673 HTML (HyperText Markup Language), user-defined functions 671—673 HTTP (HyperText Transfer Protocol) file, testing (IS_UPLOADED_FILE()) 174 HTTP (HyperText Transfer Protocol) header, browser or other HTTP servers, communicating with (header()) 179—180 HTTP (HyperText Transfer Protocol) header, cookie, setting (setcookie()) 180 HTTP (HyperText Transfer Protocol) header, functions 627 HTTP (HyperText Transfer Protocol) header, PHP functions 179—181 HTTP (HyperText Transfer Protocol) header, text, blocking further headers (header_sent()) 180 HyperText Markup Language See HTML ID, customer, problem-tracking system (fetch_customer()) 454—455 ID, getting catalog record by (FETCH_FROM_DB()) 416—417 ID, of new catalog image (UPLOAD()) 430 Identifier 76 if statement, checking against several conditions (if...elseif statement) 125—126 if statement, comparison operators 122 if statement, complex 123—124 if statement, described 701 if statement, syntax 117—118 if statement, true or false, determining 118—122 if statement, when condition is false (if...else statement) 125 IFNULL flow control 700—701 Image, catalog, extending 432—433 Image, catalog, ID value of new (UPLOAD()) 430 Image, catalog, matching display (THUMBNAIL()) 430 Image, catalog, products (IMG()) 429—430 Image, HTML form 569 671 675 Image, PHP functions, copying part of (IMAGECOPYRESIZED()) 181—182 Image, PHP functions, creating new from image stream (IMAGECREATEFROMSTRING()) 182 Image, PHP functions, dimensions 182 Image, PHP functions, GD library configuration (IMAGETYPES()) 183 Image, PHP functions, outputting in PNG format (IMAGEPNG()) 182 Image, PHP functions, thumbnails, retrieving as data stream (EXIF_THUMBNAIL()) 183 Image, PHP functions, type, checking (EXIF_IMAGETYPE()) 183 Image, PHP functions, width, height, type, and text string (GETIMAGESIZE()) 181 Incremental value, returning last automatically, generated 732 Indenting, code blocks 192—194 Indenting, described 191 Indenting, function calls 194—196 Indenting, SQL statements 196—197 Index, adding 43 Index, columns, creating 37—38 Index, described 26 Index, dropping 43 Index, string (FIELD) 718 Index, viewing 46—47 Information, about given discussion topic, displaying (display_topic()) 326—329 Information, functions, assigning value to configuration option (ini_set()) 189 Information, functions, configuration option (ini_get()) 189 Information, functions, loaded extensions (extension_loaded()) 189 Information, functions, PHP environment, guide to all (phpinfo()) 188 Information, functions, SAPI interface, returning (php_sapi_name()) 189 Information, MySQL 588 Information, PHP 628 inheritance 215—218 420—421 initialization code, HTML survey 293—294 InnoDB 40—41 Input, concatenating (STR_REPEAT()) 139—140 Input, HTML forms, access key 568 Input, HTML forms, buttons with text and image 569 Input, HTML forms, caption for grouping (legend) 569 Input, HTML forms, overview 562—565 Input, HTML forms, select, multiple select 565—566 Input, HTML forms, Tab key (tabindex) 568 Input, HTML forms, text entry (textarea) 566—567 Input, HTML forms, text surrounded by thin line (fieldset) 569 Insert anomalies 8 10 Insert queries, slashes, adding to (ADDSLASHES()) 138 Insert queries, slashes, removing (STRIPSLASHES()) 138—139 Inserting, catalog product style (MAP_STYLE()) 429 Inserting, data to tables 53—55 Inserting, date and time into columns 35 Inserting, strings 717 Inserting, with SQL statement 676—677 Installation, MySQL/PHP, Unix/Mac OS X 575—580 Installation, MySQL/PHP, Windows (Microsoft) 571—575 Integer, ASCII-code values of (CHAR) 711 Integer, interfaces 23 211—212 Integer, rounding to integer with specified number of decimal places (ROUND) 704 Integer, scalar, returning (INTVAL()) 153 Integer, storing (int/integer, tinyint, mediumint, bigint) 34 Integer, testing variables for (is_int()) 113 Joining tables, correlated subqueries 86—87 Joining tables, multiple tables 81—82 Joining tables, outer join 82—85 Joining tables, queries, returning in one result set (union) 86 Joining tables, to copy of itself (self) 85—86 Joining tables, two (equi-join) 80—81 Key / value pair, array, returning (EACH()) 161 Key / value pair, pulling from array and making into standalone variables (EXTRACT()) 153—154 Key, and values, exchanging (ARRAY_FLIP()) 155—156 Key, arrays, seeking (ARRAY_KEY_EXISTS()) 159—160 Key, foreign 19—20 Key, in array, returning all (ARRAY_KEYS()) 158 Key, primary, defined 10 11 Key, two-dimensional arrays 99 Key, whether exists in array (ARRAY_KEY_EXISTS()) 158 Killing sessions (SESSION_DESTROY()) 485 Language construct 165 177 Large strings, storing 31—32 Largest argument (GREATEST) 708 Largest integer value not greater than X (FLOOR) 703 Last array element, return and remove (ARRAY_POP()) 160 Leading and trailing spaces, removed (TRIM) 715—716 Leading spaces, removed from string (LTRIM) 715 Leaving out empty properties (DATA_FIELDS()) 418 Left-padded string (LPAD) 713 Leftmost len characters (LEFT) 713—714 len characters 713—714 Length, string functions 712 Level, errors displayed and logged 333 Level, threaded discussion, simplifying (push_handler() and pop_handler()) 337 Library, Guestbook 2003, arguments, printing (PRINT_INPUT_FIELDS()) 249—250 Library, Guestbook 2003, database call, putting together (SELECT_ENTRIES()) 253—254 Library, Guestbook 2003, disconnecting (MYSQL_DBCONNECT()) 242—243 Library, Guestbook 2003, navigational elements, creating (NAV()) 254—255 Library, Guestbook 2003, printing query (PRINT_ENTRY()) 248—249 Library, Guestbook 2003, user authentication (GUESTBOOK_AUTHENTICATE()) 244—248 Library, Guestbook 2003, verifying user information (CREATE_ENTRY()) 250—253 Library, Guestbook 2003, writing safe queries (SAFE_MYSQL_QUERY()) 243—244 Limited potential values (enum), text strings, storing 32 Line, single 172—173 Linux, CD, back-of-the-book 557 List of catalog fields (FIELDLIST()) 417—418 List of categories or specific products, printing (DISPLAY.PHP) 492—493 List of databases (show databases) 45 Listing, catalog products mappings (LIST_MAPPED_STYLES()) 426—428 Listing, children, catalog products class 423—424
Ðåêëàìà
|
|
Î ïðîåêòå