Index
A
action attribute
AES_DECRYPT() function
AES_ENCRYPT() function
Apache web server
array_diff_assoc()
array_diff_key()
array elements
array_filter() function
array_merge() function
array_merge_recursive()
array_multisort() function
Arrays
assign element to variables
CSV file
extract()
list()
building nested lists
csv_processor()
JSON
merging
array_diff_assoc()
array_diff_key()
array_merge()
array_merge_recursive()
array_pop()
comparison
implode()
strcasecmp()
using union operator
modify elements
array_walk(),182–184
with loop
sort functions
sorting
array_multisort()
permutations
spaceship operator
splat operator
array_slice() function
Array sort functions
array_sum() function
array_walk() function
<a> tag
authenticate_mysqli.php
authenticate_pdo.php
B
basename() function
begin_transaction() method
bindColumn()
bindParam() method
bindValue() method
Boolean values
break keyword
Byte order mark (BOM)
C
callHasChildren() method
Cascading Style Sheets (CSS)
Casting operator
checkFile() method
checkSize() method
Class
avoiding naming conflicts
checkFile() function
conditional statement
constructor
dangerous files
allowAllTypes() method
checkFile() method
checkName() method
moveFile() method
$newName property
pathinfo()
str_replace() function
Upload.php
Upload.php and test uploading files
upload_test folder
definition
$deleteOriginal property
destination folders
DOCTYPE declaration
file_upload.php
$loader object
$messages
$mime parameter
moveFile() method
move_uploaded_file() function
namespace keyword
$permitted property
allowAllTypes()
is_numeric() function
setMaxSize() method
size restriction
upload_test folder
PhpSolutions/File folder
properties
protected keyword
public keyword
public methods
setter method creation
$thumbDestination property
ThumbnailUpload.php creation
try/catch block
upload errors
checkFile() method
$_FILES array
getErrorMessage() method
getMaxSize() method
MIME type
number_format() function
upload() method
Comma-separated values (CSV) file
array_combine() function
conditional statement
fgetcsv() function
print_r()
private folder
Concatenation operator
Content management system
blog table
contents
creation
inserting and updating records
deleting record
EDIT and DELETE link
inserting new records
with MySQLi
with PDO
updating record
with MySQLi
with PDO
SQL UPDATE command
convertToParas() function
counter() generator
count() function
createThumbnail() method
Cross-site scripting (XSS)
D
Database design
compatibility
MySQL
backup data
binary data
case sensitivity
data types
dates and times
insert records
naming rules
numeric column types
predefined lists
table creation
user accounts creation
phpMyAdmin
storage information
break down information
checkpoints
foreign keys
primary keys
Data source name (DSN)
DATE_FORMAT() function
date() function
Dates and time formatting
add() and sub() methods
32-bit processor
createFromDateString() method
createFromFormat() method
DateInterval class
DateInterval static method
DatePeriod classes
DateTime methods
DateTime object creation
DateTimeZone objects
diff() method
format() method
getTimezone() method
htaccess or suser.ini files
modify() method
MySQL
blog_list_mysqli.php or blog_list_pdo.php
checkdate() function
conditional statements
convertDateToISO() function
DATE_ADD() method
date_converter.php
DATE_SUB() method
drop-down menu
explode() function
month, day, and year
NOW() function
<option> tags
SELECT query
sprintf() function
timestamps
utility_funcs.php
MySQLdate() function
period designators
setDate() method
setTime() methods
setTimezone() method
static methods
strftime() method
timezone directive
define() function
DELETE query
display_errors
doubleIt() function
Dump
Dynamic elements
multicolumn table creation
constant
database connection
increment operator (++)
MySQLi version
thumbnails
query string
subset of records
conditional statement
fetch_row() method
$_GET array
LIMIT clause
navigation
navigation links creation
selection
SHOWMAX
$startRow
E
echo command
Email header injection
Email headers
contact.php
Content-Type
filter_input() function
From/Reply-To
mail() function
message body
coding implementation
header() function
htmlentities() function
implode() function
processmail.php
str_replace() function
verification
wordwrap() function
processmail.php
troubleshooting
empty() function
Encryption method
one-way encryption (
see
One-way encryption)
two-way encryption (
see
Two-way encryption)
errorCode() method
errorInfo() method
error message, PHP
copy and paste
security purpose
Escape sequences
execute() method
exec() method
extract() function
F
fclose() function
Feedback form, PHP
check-box groups
count() function
in_array() function
name attribute
usage
coding implementation
drop-down option menu
Email headers (
see
Email headers)
get method
isset() function
Japan Journey website
multiple-choice list
post method
$_POST superglobal array
radio-button groups
single check box
fetch_assoc() method
fetch() method
fetch_row() method
fgetcsv() function
fgets() function
File-based authentication
fgetcsv() function
header() function
login page
logout button creation
restrict access
file_exists() function
$_FILES array
multiple attribute
multiple files upload
name attribute
$uploaded array
upload() method
File system
FilesystemIterator class (
see
FilesystemIterator class)
RegexIterator
csv filename
drop-down menu
PDFs and Word documents
scandir() function
FilesystemIterator class
new keyword
RecursiveDirectoryIterator class
setFlags() method
SplFileInfo methods
File uploads
Class (
see
Class)
configuration settings
directory upload
Mac OS X
Windows
$_FILES array (
see also
$_FILES array)
file_upload.php
image element
isset() function
</form> tag
remote server
<form> tag
move_uploaded_file() function
DOCTYPE declaration
</form> and </body> tags
MAX_FILE_SIZE
$max variable
upload_test folder
security points
flock() function
fopen() function
foreach loop
Foreign-key constraints
definition
delete scripts
CASCADE
errorCode() method
MySQLi
ON DELETE
PDO prepared statement
SET NULL
InnoDB storage engine
setting up
CASCADE
categories table
error message
NO ACTION
Relation view
RESTRICT
SET NULL
transactions
for loop
format() method
free_result() method
fseek() function
ftruncate() function
function keyword
fwrite() function
G
getErrorLevel() method
getFilename() method
getimagesize() function
getMaxSize() method
get method
getOffset() method
H
Hashing algorithm
header() function
</head> tag
</html> tag
htmlentities() function
HTML5 validation
Hypertext Preprocessor (PHP),
see
PHP
I
imagecopyresampled()
implode() function
InnoDB storage engine
phpMyAdmin
remote server
storage_engines.php
table options
Inserting records
decision chain
processing script
Integrated development environment (IDE)
Internet Information Services (IIS)
Internet service providers (ISPs)
isset() function
J
JavaScript Object Notation (JSON)
K
krsort()
L
lastInsertId() method
Linking table
list()
M
Mail transport agent (MTA)
method attribute
MIME type
move_uploaded_file() function
Multidimensional array
Multipage forms
Multiple database tables
cross-reference table
conditional statement
Inline comments
<option> tag
$selected_categories
referential integrity (
see
Referential Integrity)
Multiple queries as block
InnoDB storage engine
MySQLi transaction
PDO transaction
update sequence
update sequence, MySQLi
conditional statement
error messages
query() method
SQL queries
$trans_error
update sequence, PDO
blog_update_pdo.php
conditional statement
error message
$trans_error
try/catch block
Multiple tables
cross-reference table
details page building
article and image
convertToParas() function
database connection file
DATE_FORMAT() function
<figure> element
<h2> tags
NULL
placeholder image and text
read-only connection
SELECT query
SQL query
existing table alter
extra column addition
foreign key insertion
drop-down menu
MySQLi
PDO
principle
images and blog
INNER JOIN
intelligent link creation
many-to-many
one-to-many
one-to-one
primary and foreign keys
primary/parent table
records finding
referential integrity
secondary/child table
WHERE clause
MySQL
backup data
binary data
case sensitivity
data and times
data types
insert records
naming rules
numeric column types
predefined lists
remote server setup
table creation
user accounts creation
MySQL Improved (MySQLi) extension
connecting with
connection and database queries
image table
mysql_02.php
prepared statements
bind_param() method
bind_result() method
close() method
conditional statement
DOCTYPE declaration
execute() method
fetch_assoc() method
fetch() method
prepare() method
stmt_init() method
store_result() method
result set
reusable database connector
connection.php
connection_test.php
exit() function
getMessage() method
troubleshooting
sanitize text results
SELECT query
N
name attribute
natsort()
nextElement() public method
Null coalescing operator
number_format() function
O
ob_end_clean() function
ob_end_flush() function
Object
Object-oriented programming (OOP)
One-way encryption
advantages and disadvantages
authentication
DOCTYPE declaration
MySQLi
PDO
$_SESSION
new table creation
password_verify() function
usage
user registration form
bindParam() method
conditional statement
DOCTYPE declaration
errorInfo() method
$errors array
MySQLi
PhpSolutions/Authenticate folder
register_db.php
register_user_mysqli.php
rowCount() method
P
Parameter binding
parse_url() function
password_needs_rehash()
Password security
check() method
CheckPassword class
conditional statements
DOCTYPE declaration
encryption
filesize() function
fopen() modes
$errors array
getErrors() method
password_hash() function
password_verify() function
preg_match() method
requireMixedCase() method
trim() method
user registration system
password_verify() function
Perl-compatible regular expression (PCRE)
Photo gallery
CSS style rules
display image
DOCTYPE declaration
getimagesize() function
table cell
using MySQLi
dynamic elements (
see
Dynamic elements)
gallery_01.php coding
store images, database
thumbnails creation
PHP
advantage
associative array
basename() function
conditional statement
configuration settings
custom functions or classes
date() function
display_errors control
document-relative links
double extension
double-quoted string
download link creation
EDIT and DELETE link
editing php.ini
error control operator
error message
existence variables
features
file_exists() and is_readable()
File Explorer window
filename extension
footer.php and load index.php
functions/class definitions
get_filename.php
header() function
if else statement
include_once commands
include_path directive
individual programs
inserting new records
with MySQLi
with PDO
installations
local test environment
location
MAMP installations
menu.php and load index.php
multidimensional array
nest functions
ob_start() function
overview
phpsols
random image
random_image.php and index.php
reading and writing files (
see
Reading and writing files)
redirect error pages
require_once commands
script editor features
security
security risks
server-side includes
set_include_path()
site-root-relative path
static version of index.php
str_replace() function
superglobal arrays
testing and configuring MAMP
Apache and MySQL ports
testing and security
ucfirst() function
ucwords() function
ugly gap
updating record
with MySQLi
with PDO
url_include directive
URLs
virtual hosts
web server’s include_path
website supports
Parse error
RTF
PHP Data Objects (PDO)
column modification
connecting with
connection and database queries
count() function
image table
prepared statements
anonymous placeholders
bindColumn()
bindParam()
bindValue()
DOCTYPE declaration
execute() method
fetch() method
named placeholders
prepare() method
result set
rowCount() function
SELECT query
phpinfo(),14
PHP mail() function
PHP Scripts
arithmetic operators
array definition
associative array
black box
Boolean values
combined arithmetic assignment operators
combined concatenation operator
commands/statements
comparison operators
complex numbers
conditional statements
custom-built function
data types
DateTime class
DateTimeZone object
doubleIt() function
double-quoted string
double quotes/single quotes
echo shortcut syntax
embedded language
empty array
error messages report
error-handling code
page blank
escape sequences
functions
half-measures/maybes
heredoc syntax
implicit Boolean values
increment (++) and decrement (--) operators
indenting code
indexed array
inspect arrays
join strings
logical operators
loops
multidimensional arrays
multi-line comments
object-oriented programming
passing argument
passing reference argument
Passing values functions
properties and methods
quick checklist
server-side language
single-line comment
single-quoted string
storage
superglobal arrays
switch statement
temporary variables
ternary operator
typographical error
variables and functions
assignment operator
naming variables
versatile loop
website
while and do while
$_POST array
post method
print_r() function
Processing and validating user input
block emails
conditional statement
contact.php
foreach loop
isSuspect() function
client-side validation
mail() function
reusable script
conditional statement
$errors/$missing
foreach loop
labels
$missing/$errors
PHP conditional statement
processmail.php
self-processing form
sticky form fields creation
comments text area
echo command
htmlentities() function
Q
query() method
R
rand() function
random_image.php and index.php
range() function
readfile() function
Reading and writing files
append mode
CSV file (
see
Comma-separated values (CSV) file)
fclose() function
flock() function
fopen() function
fseek() function
ftruncate() function
functions
internal pointer
modes
overwriting existing file
text file
array_slice() function
echo command
explode() function
file() function
file_get_contents() function
filesystem
nl2br()function
Referential integrity
blog_insert_mysqli.php
casting operator
$catError
conditional statement
$_FILES
foreign key
getFilenames() method
getMessages() method
$_POST array
upload() method
categories and images
blog_insert_mysqli.php
check box
conditional statement
<form> tag
multiple-choice <select> list
toggle_fields.js
cross-reference table
categories
composite primary key
file uploading
foreign-key constraints (
see
Foreign-key constraints)
InnoDB storage engine
INSERT query
PDO version
primary keys
Remote file access
RSS feeds
<script> tags/hyperlinks
SimpleXML (
see
SimpleXML)
strip_tags() function
return keyword
Rich Text Format (RTF)
rowCount() method
RSS feeds
S
sayHi() function
scandir() function
Secure Sockets Layer (SSL) connection
Self-processing form
server-side includes (SSI)
session_name()
Sessions
creation
destroying
file-based authentication
fgetcsv() function
header() function
login page
logout button creation
restrict access
headers already sent
ini_set() function
multipage forms
password security
check() method
CheckPassword class
DOCTYPE declaration
encryption
$errors array
filesize() function
fopen() modes
getErrors() method
password_hash() function
password_verify() function
preg_match() method
requireMixedCase() method
trim() method
user registration system
PHPSESSID
regenerate session ID
restrict access
DOCTYPE declaration
ob_start()
session_destroy()
setcookie()
stored variables
time() function
unset variables
Sessions
setTimezone() method
SHOWMAX
SimpleXML
foreach loop
<item> elements
RSS news feed
BBC World News
DateTime format() method
foreach loop
LimitIterator class
newsfeed.css
setTimezone() method
sort()
splat operator
SplFileInfo getRealPath() method
SQL commands
DELETE
INSERT
SELECT
UPDATE
SQL injection
definition
insertion
conditional statement
</form> tag
<option> tag
MySQLi version
PDO version
rowCount() method
prepared statement
strategies
SQL queries
case-insensitive
numbers
SELECT keyword
LIKE keyword
ORDER BY clause
specific columns selection
WHERE clause
strings
whitespace
Standard PHP Library (SPL)
See also
See also
FilesystemIterator class
strcasecmp() function
stripos()
str_replace() function
strtolower() function
switch() function
T
Text extraction
<br/> tags method
conditional statement
getFirst() function
HTML record storage
implode() function
LEFT() method
MySQL
DATE_FORMAT() method
paragraph extraction
PHP substr() method
preg_split() function
<p> tags method
strrpos() and substr() method
Thumbnail images
basename() function
<body> tag
checkType() method
class
See also
(
see also
Class)
createThumbnail() method
destination folder
dimension calculation
imagecopyresampled()
Mac OS X
MIME type
checkType() method
DOCTYPE declaration
getimagesize()
image selection
$maxSize property
PhpSolutions folder
test() method
server’s capabilities
setter methods creation
abs() function
caret (^)
DIRECTORY_SEPARATOR constant
image selection
is_numeric() function
preg_match()
setMaxSize() method
strpos() function
substr() function
test() method
Thumbnail.php coding
using GD functions
Time limit sessions
<title> tag
trim() function
Two-way encryption
advantages and disadvantages
AES_DECRYPT() function
AES_ENCRYPT() function
usage
user authentication with
MySQLi
PDO
users_2way table
Type declarations
Type juggling
Typographic conventions
U
ucfirst() function
ucwords() function
UNIQUE index
UPDATE query
URL encoding
V
Validating user input,
see
Processing and validating user input
valid() method
var_dump() function
W, X, Y, Z
Web page, PHP
advantages
maintenance
pictorial representation
World Wide Web Consortium’s (W3C) Markup Validation Service
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.