phpeveryday.com

The best tutorial of php, php framework, php strategies, object oriented oriented,


PHP MySQL: MySQL Syntax Orders

Tag: mysql, database, syntax   Category: PHP Database
post: 02 Mar 2008 read: 1,112


php mysql basic step by step tutorial - part 7: PHP do not provide special functions for data operation, so the sintaks weared is MySQL sintaks orders. In order to do the data operation by using PHP, so here is the sequence as follow:

  1. Connection to database
  2. Declare a variable string that contains of the next MySQL syntax order
  3. Run the MySQL syntax by using of mysql_query() function. If the syntax will produce the next output, declaration one variable to accomodate the result
  4. Take the result of the run MySQL syntax by using the functions of mysql_fetch_array(), mysql_fetch_row(), mysql_num_rows, etc. It depends to the output wanted format



    Series this article:
    PHP MySQL: Connecting to Database Use mysql_connect()
    PHP MySQL: Making Database Use mysql_create_db()
    PHP MySQL: Making Table
    PHP MySQL: The Data Type of Field
    PHP MySQL: Char and Varchar Data Type
    PHP MySQL: Data Type of Date
    PHP MySQL: MySQL Syntax Orders
    PHP MySQL: Inserting Data
    PHP MySQL: Creating Form Insert Data
    PHP MySQL: Display Data
    PHP MySQL: mysql_fetch_row() Function
    PHP MySQL: mysql_fetch_array() Function
    PHP MySQL: Editing data
    PHP MySQL: Deleting data
    PHP MySQL: Adding Field Table
    PHP MySQL: Editing Field Table
    PHP MySQL: Deleting Field Table

| Give Your Opinion | Recommend
Share and Bookmark to: These icons link to social bookmarking sites where readers can share and discover new web pages.
digg del.icio.us technorati Ma.gnolia BlinkList

Recommended articles by other readers:
Web Services: How PHP Kiss VB.NET? (Part 1)
Chart: How to Build Cool Animation Real Time Chart
Joomla: Fast Road to Understand Component Programming
Email: Send Attachement Mail
mod_rewrite - Part 1: create your "fantasy" URL

What do You Think?
Your Name *:
Email *:
(Will not be published)
Website/URL:
Your Comment *:
* Required


615
posting