Results 1 to 3 of 3

Threaded View

  1. #1

    Thread Starter
    WiggleWiggle dclamp's Avatar
    Join Date
    Aug 2006

    [PHP Example] Using MySQL w/PHP


    Here i am going to show you (quickly) how to use MySQL in PHP.

    If you are not familiar with MySQL, then take a look here

    Connecting to MySQL Server
    The following is generic code to connecting to a MySQL Server. Typically you will be using your local mysql server on your computer / web server

    PHP Code:
    ("localhost""USERNAME""PASSWORD") or die("could not connect to MySQL server");
    Selecting a MySQL Database
    Before you can make MySQL queries, you need to select a database that has the information you need. This typically comes after you connect to a database

    PHP Code:
    ("databasename") or die("could not select MySQL database");
    Preforming a Query (Update/Insert/Delete/Truncate/Num_Rows)
    A query is a message sent to the sql server either asking for information, or telling it to input or change information. This example shows how to Update/Insert/Delete/Truncate from database

    PHP Code:
    $query mysql_query($sql);

    $numrows mysql_num_rows($query);

    // then you can use $numrows in an IF statement
    Preforming a Query (Select)
    Select query will be the most used query (for most people). It allows you to select rows from a table with many option for selecting the correct row. I will show 2 examples. 1) Selecting just one row; 2) selecting an ARRAY of rows.

    PHP Code:
    "SELECT * FROM `members` WHERE memberID='1' LIMIT 1";
    $query mysql_query($sql);
    $result mysql_fetch_array($query);

    //echo $result['COLUMN'];

    echo $result['memberID'];
    // etc...

    More coming soon!
    Last edited by dclamp; Mar 25th, 2008 at 12:08 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts


Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.