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

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

اصطلاحنامه مجموعه ها مرورالفبایی لغت نامه دهخدا

➟

جستجو در لغت نامه

بیشتر

کتابخانه شخصی پرسش از کتابدار ارسال منبع

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

Kevin Yank

| ،

افزودن به کتابخانه شخصی

میخواهم بخوانم

درحال خواندن

خوانده شده

ارسال به دوستان

آدرس پست الکترونیک گیرنده :

آدرس پست الکترونیک فرستنده :

نام و نام خانوارگی فرستنده :

پیغام برای گیرنده ( حداکثر 250 حرف ) :

کد امنیتی را وارد نمایید

ارسال

جستجو در متن کتاب

بیشتر

تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب

➟

جستجو در لغت نامه

بیشتر

لیست موضوعات

Sitemap

Table of Contents

Build Your Own Database Driven Website Using PHP & MySQL

What''s In This Book

The Book''s Web Site

The SitePoint Forums

The SitePoint Tech Times

Chapter 1: Installation

Windows Installation

Linux Installation

Mac OS X Installation

Post-Installation Setup Tasks

If Your Web Host Provides PHP and MySQL

Your First PHP Script

Chapter 2: Getting Started with MySQL

Logging On to MySQL

So what''s SQL?

Creating a Database

Creating a Table

Inserting Data into a Table

Viewing Stored Data

Modifying Stored Data

Deleting Stored Data

Chapter 3: Getting Started with PHP

Basic Syntax and Commands

Variables and Operators

User Interaction and Forms

Control Structures

Multipurpose Pages

Chapter 4: Publishing MySQL Data on the Web

Connecting to MySQL with PHP

Sending SQL Queries with PHP

Handling SELECT Result Sets

Inserting Data into the Database

" Homework " Solution

Chapter 5: Relational Database Design

Rule of Thumb: Keep Things Separate

Dealing with Multiple Tables

Simple Data Relationships

Many-to-Many Relationships

Chapter 6: A Content Management System

Managing Authors

Deleting Authors

Editing Authors

Managing Categories

Chapter 7: Content Formatting and Submission

Out with the Old

Regular Expressions

String Replacement with Regular Expressions

Splitting Text into Pages

Putting it all Together

Automatic Content Submission

Chapter 8: MySQL Administration

Backing up MySQL Databases

MySQL Access Control

Checking and Repairing MySQL Data Files

Chapter 9: Advanced SQL

Column and Table Name Aliases

GROUPing SELECT Results

Limiting Results with HAVING

Chapter 10: Advanced PHP

Server-Side Includes with PHP

Semi-Dynamic Pages

Chapter 11: Storing Binary Data in MySQL

Binary Column Types

Viewing Stored Files

The Complete Script

Advanced Considerations

Chapter 12: Cookies and Sessions in PHP

A Simple Shopping Cart

Appendix A: MySQL Syntax

CREATE DATABASE

LOAD DATA INFILE

LOCK/UNLOCK TABLES

Appendix B: MySQL Functions

Mathematical Functions

String Functions

Date and Time Functions

Miscellaneous Functions

Functions for Use with GROUP BY Clauses

Appendix C: MySQL Column Types

Numerical Types

Character Types

Date/Time Types

Appendix D: PHP Functions for Working with MySQL

mysql_affected_rows

mysql_create_db

mysql_data_seek

mysql_escape_string

mysql_fetch_array

mysql_fetch_assoc

mysql_fetch_field

mysql_fetch_lengths

mysql_fetch_object

mysql_fetch_row

mysql_field_flags

mysql_field_len

mysql_field_name

mysql_field_seek

mysql_field_table

mysql_field_type

mysql_free_result

mysql_get_client_info

mysql_get_host_info

mysql_get_proto_info

mysql_get_server_info

mysql_insert_id

mysql_list_fields

mysql_list_tables

mysql_num_fields

mysql_select_db

mysql_tablename

mysql_unbuffered_query

List of Figures

List of Sidebars

توضیحات

افزودن یادداشت جدید

USE

USE db_name

This simple query sets the default database for MySQL queries in the
current session. Tables in other databases may still be accessed as db_name.tbl_name.