Web Database Applications With Php And Mysql (2nd Edition) [Electronic resources] نسخه متنی

salt

scalar types

scripting languages

JavaScript

PHP
[See PHP]

search.tpl (winestore database)
2nd

search/search.php (winestore database)
2nd
3rd
4th

search/searchform.php (winestore database)
2nd
3rd
4th
5th

Secure Sockets Layer protocol
[See SSL]

security

attacks and special characters

authentication
[See authentication]

queries from user input

sessions and

users and privileges, managing

validation and

SELECT ... INTO OUTFILE statement

<select multiple> tag

SELECT statement

arithmetic and comparison operators

clauses, combining

CREATE TABLE, using with

DISTINCT clause

HAVING clause

INSERT, using with

LIMIT operators

ORDER BY clause

sorting and grouping output

WHERE clause

selectDistinct( ) function (MySQL)

selectFont( ) method (pdf-php)

Sequel

server variables

$_SESSION array

session_destroy( ) function (PHP)
2nd

session_destroy( ) handler function

session_id( ) function (PHP)

session_is_registered( ) function (PHP)

session_readonly( ) function (PHP)

session_register( ) function (PHP)

session_set_save_handler( ) function (PHP)
2nd

session_start( ) function (PHP)
2nd

session_unregister( ) function (PHP)

session_unset( ) function (PHP)

sessionAuthenticate( ) function (PHP)
2nd
3rd

sessionClose( ) handler function

sessionGC( ) garbage collection handler

sessionOpen( ) handler function

sessionRead( ) handler function

sessions
2nd

advantages

authentication and

bookmarks and

cookies

definition

disadvantages

ending

hijacking, prevention

management
2nd
[See also PHP, session management]

configuration

garbage collection

without cookies

performance

PHP accessing functions

with register_globals enabled

PHP API and configuration

security aspects

session hijacking

session identifiers

session identifiers (IDs)

session variables
2nd
3rd

serialization
2nd

storage, database tier

types

unsetting

session-based applications, designing

tracking anonymous users

tracking authenticated users

starting

state information storage

timeouts

validation using

when to use

sessionWrite( ) handler function

set_error_handler( ) function (PHP)

setupQuery( ) function (winestore database)

shapeInfo( ) function (PHP)

shell_exec( ) function (PHP), security risks

shellclean( ) function
2nd

short-circuit evaluation property

SHOW command (MySQL)

showcart.php (winestore database)
2nd
3rd
4th

showcart.tpl (winestore database)
2nd

showCountry( ) function (winestore database)

showerror( ) function (PHP)

showPricing( ) function (winestore database)

showTitle( ) function (winestore database)

showVarieties( ) function (winestore database)

showWine( ) function (winestore database)

sin( ) function (MySQL)

Smarty PHP template engine

SMTP (Simple Mail Transfer Protocol)

sort( ) function (PHP)

sorting arrays
[See arrays, sorting]

special characters

escaping in regular expressions

use in attacks

sprintf( ) function (PHP)

supported conversion types

SQL
2nd
[See also databases]3rd
4th
[See also MySQL]5th

advanced querying

arithmetic and comparison operators

data types for attributes

table creation based on ER modeling

user variables

sqrt( ) function (MySQL)

srand( ) function (PHP)

SSL (Secure Sockets Layer) protocol

start anchors (^) (regular expressions)

starvation

stateful versus stateless applications

static member functions

static member variables

static variables

storage engines
[See table types]

stored procedures

str_pad( ) function (PHP)

str_replace( ) function (PHP)

strcasecmp( ) function (PHP)

strcmp( ) function (PHP)

strftime( ) function (PHP)

string expressions

string functions (MySQL)

string literals

strings
2nd

arrays, splitting into

case, changing

characters

replacing in

translating

trimming from

comparing

formatting

length

padding

regular expressions, matching with
[See regular expressions]

sprintf( ) and printf( ) functions (PHP)

supported conversion types

substrings

extraction from strings

replacing

translating

substrings, replacing

timestamps, generating from date strings

trimming whitespace

validation of

email addresses

legal character tests

URLs

Zip and postcodes

wildcard matching

strlen( ) function (PHP)

strncasecmp( ) function (PHP)

strncmp( ) function (PHP)

strtolower( ) function (PHP)

strtotime( ) function (PHP)
2nd

strtoupper( ) function (PHP)
2nd

strtr( ) function (PHP)

strval( ) function (PHP)

substr( ) function (PHP)

substr_replace( ) function (PHP)

substring( ) function (MySQL)

substrings
[See strings, substrings]

SUM( ) function (MySQL)

superglobals

switch statement

system( ) function (PHP)

security risks of