Index - Build Your Own DatabaseDriven Website Using PHP amp;amp; MySQL [Electronic resources] نسخه متنی

Index

M

magic quotes, Magic Quotes

and mysql_escape_string, mysql_escape_string

mail, Email in PHP

MAX_FILE_SIZE

hidden form
field, Handling File Uploads

my.cnf, Installing MySQL, MySQL Packet Size

max_allowed_packet, MySQL Packet Size

my.ini, see my.cnf

myisamchk, Checking and Repairing MySQL Data Files

MySQL, Who Should Read This Book, Welcome to the Show

administration, MySQL Administration

assigning a root password, Post-Installation Setup Tasks

backing up data, Standard Backups Aren't Enough, Incremental Backups using Update Logs, see also update logs

command-line client, Logging On to MySQL

controlling access to, MySQL Access Control

tips, Access Control Tips, Checking and Repairing MySQL Data Files

data files, Checking and Repairing MySQL Data Files

getting started with, Getting Started with MySQL

installing

in Linux, Installing MySQL

in Windows, Installing MySQL

killing server process, Locked Out?

logging
on to, Logging On to MySQL

lost password recovery, Locked Out?

password, Logging On to MySQL

removing packaged
versions, Linux Installation

repairing corrupt data
files, Checking and Repairing MySQL Data Files

restoring backed up data, Database Backups using mysqldump, Incremental Backups using Update Logs

running automatically
at start-up, Installing MySQL

transaction support, Transactions in MySQL

user
name, Logging On to MySQL

MySQL
column types

TEXT, Creating a Table

MySQL
functions

CONNECTION_ID, Miscellaneous Functions

COUNT, GROUPing SELECT Results

DATABASE, Miscellaneous Functions

LAST_INSERT_ID, Miscellaneous Functions

MIN, Functions for Use with GROUP BY Clauses

SYSDATE, Date and Time Functions

SYSTEM_USER, Miscellaneous Functions

VERSION, Miscellaneous Functions

MySQL column
types

DATE, Date/Time Types

DATETIME, Date/Time Types

TIME, Date/Time Types

YEAR, Date/Time Types

MySQL column types, MySQL Column Types

BIGINT, Numerical Types

BLOB, Character Types

CHAR, Character Types

DECIMAL, Numerical Types

DOUBLE, Numerical Types

ENUM, Automatic Content Submission, Character Types

FLOAT, Numerical Types

for binary
data, Binary Column Types

INT, Creating a Table, Numerical Types

LONGBLOB, Character Types

LONGTEXT, Character Types

MEDIUMBLOB, Character Types

MEDIUMINT, Numerical Types

MEDIUMTEXT, Character Types

SET, Character Types

SMALLINT, Numerical Types

TEXT, Character Types

TEXT vs. BLOB types, Binary Column Types

TIMESTAMP, Date/Time Types

TINYBLOB, Character Types

TINYINT, Numerical Types

TINYTEXT, Character Types

VARCHAR, Character Types

MySQL functions, GROUPing SELECT Results, MySQL Functions

ABS, Mathematical Functions

ACOS, Mathematical Functions

ADDDATE, Date and Time Functions

ASCII, String Functions

ASIN, Mathematical Functions

ATAN, Mathematical Functions

ATAN2, Mathematical Functions

AVG, Functions for Use with GROUP BY Clauses

BENCHMARK, Miscellaneous Functions

BIN, String Functions

BIT_AND, Functions for Use with GROUP BY Clauses

BIT_LENGTH, String Functions

BIT_OR, Functions for Use with GROUP BY Clauses

CASE, Control Flow Functions

CEILING, Mathematical Functions

CHAR, String Functions

CHAR_LENGTH, String Functions

CHARACTER_LENGTH, String Functions

CONCAT, String Functions

CONCAT_WS, String Functions

CONV, String Functions

COS, Mathematical Functions

COT, Mathematical Functions

COUNT, Viewing Stored Data, Functions for Use with GROUP BY Clauses, Functions for Use with GROUP BY Clauses

omitting NULLs, LEFT JOINs

CURDATE, Date and Time Functions

CURRENT_DATE, Date and Time Functions

CURRENT_TIME, Date and Time Functions

CURRENT_TIMESTAMP, Date and Time Functions

CURTIME, Date and Time Functions

DATE_ADD, Date and Time Functions

DATE_FORMAT, Date and Time Functions

DATE_SUB, Date and Time Functions

DAYNAME, Date and Time Functions

DAYOFMONTH, Date and Time Functions

DAYOFWEEK, Date and Time Functions

DAYOFYEAR, Date and Time Functions

DECODE, Miscellaneous Functions

DEGREES, Mathematical Functions

ELT, String Functions

ENCODE, Miscellaneous Functions

ENCRYPT, Miscellaneous Functions

EXP, Mathematical Functions

EXPORT_SET, String Functions

FIELD, String Functions

FIND_IN_SET, String Functions

FLOOR, Mathematical Functions

FORMAT, Miscellaneous Functions

FROM_DAYS, Date and Time Functions

FROM_UNIXTIME, Date and Time Functions

GET_LOCK, Miscellaneous Functions

GREATEST, Mathematical Functions

HEX, String Functions

HOUR, Date and Time Functions

IF, Control Flow Functions

IFNULL, Control Flow Functions

INET_ATON, Miscellaneous Functions

INET_NTOA, Miscellaneous Functions

INSERT, String Functions

INSTR, String Functions

LCASE, String Functions

LEAST, Mathematical Functions

LEFT, Viewing Stored Data, String Functions

LENGTH, String Functions

LOAD_FILE, String Functions

LOCATE, String Functions

LOG, Mathematical Functions

LOG10, Mathematical Functions

LPAD, String Functions

LTRIM, String Functions

MAKE_SET, String Functions

MD5, Miscellaneous Functions

MID, String Functions

MINUTE, Date and Time Functions

MOD, Mathematical Functions

MONTH, Date and Time Functions

MONTHNAME, Date and Time Functions

NOW, Date and Time Functions

NULLIF, Control Flow Functions

OCT, String Functions

OCTET_LENGTH, String Functions

ORD, String Functions

PASSWORD, Miscellaneous Functions

PERIOD_ADD, Date and Time Functions

PERIOD_DIFF, Date and Time Functions

PI, Mathematical Functions

POSITION, String Functions

POW, Mathematical Functions

POWER, Mathematical Functions

QUARTER, Date and Time Functions

RADIANS, Mathematical Functions

RAND, Mathematical Functions

RELEASE_LOCK, Miscellaneous Functions

REPEAT, String Functions

REPLACE, String Functions

REVERSE, String Functions

RIGHT, String Functions

ROUND, Mathematical Functions

RPAD, String Functions

RTRIM, String Functions

SEC_TO_TIME, Date and Time Functions

SECOND, Date and Time Functions

SESSION_USER, Miscellaneous Functions

SIGN, Mathematical Functions

SIN, Mathematical Functions

SOUNDEX, String Functions

SPACE, String Functions

SQRT, Mathematical Functions

STD, Functions for Use with GROUP BY Clauses

STDDEV, Functions for Use with GROUP BY Clauses

SUBDATE, Date and Time Functions

SUBSTRING, String Functions

SUBSTRING_INDEX, String Functions

SUM, Functions for Use with GROUP BY Clauses

TAN, Mathematical Functions

TIME_FORMAT, Date and Time Functions

TIME_TO_SEC, Date and Time Functions

TO_DAYS, Date and Time Functions

TRIM, String Functions

TRUNCATE, Mathematical Functions

UCASE, String Functions

UNIX_TIMESTAMP, Date and Time Functions

USER, Miscellaneous Functions

WEEK, Date and Time Functions

WEEKDAY, Date and Time Functions

YEAR, Date and Time Functions

YEARWEEK, Date and Time Functions

mysql.server, Installing MySQL

mysql_affected_rows, Sending SQL Queries with PHP, mysql_affected_rows, mysql_data_seek

mysql_close, mysql_close

mysql_connect, Connecting to MySQL with PHP, mysql_connect

mysql_create_db, mysql_create_db

mysql_db_name, mysql_db_name, mysql_list_fields

mysql_db_query, mysql_db_query

mysql_drop_db, mysql_drop_db

mysql_errno, mysql_errno

mysql_error, Sending SQL Queries with PHP, mysql_error

mysql_escape_string, mysql_escape_string

mysql_fetch_array, Handling SELECT Result Sets, mysql_fetch_array

mysql_fetch_assoc, mysql_fetch_assoc

mysql_fetch_field, mysql_fetch_field

mysql_fetch_lengths, mysql_fetch_lengths

mysql_fetch_object, mysql_fetch_object

mysql_fetch_row, mysql_fetch_row

mysql_field_flags, mysql_field_flags

mysql_field_len, mysql_field_len

mysql_field_name, mysql_field_name

mysql_field_seek, mysql_field_seek

mysql_field_table, mysql_field_table

mysql_field_type, mysql_field_type

mysql_free_result, mysql_free_result

mysql_get_client_info, mysql_get_client_info

mysql_get_host_info, mysql_get_host_info

mysql_get_proto_info, mysql_get_proto_info

mysql_get_server_info, mysql_get_server_info

mysql_insert_id, Adding Jokes, INSERT, mysql_insert_id

mysql_list_dbs, mysql_list_dbs

mysql_list_tables, mysql_list_tables

mysql_num_fields, mysql_num_fields

mysql_num_rows, mysql_num_rows

mysql_pconnect, mysql_pconnect

mysql_query, Sending SQL Queries with PHP, mysql_query

using result
sets from, Handling SELECT Result Sets

mysql_result, mysql_result

mysql_select_db, Connecting to MySQL with PHP, mysql_select_db

mysql_tablename, mysql_tablename

mysql_unbuffered_query, mysql_unbuffered_query

mysqld.exe

choosing MySQL server version, Installing MySQL

mysqldump, Database Backups using mysqldump