Re: Connect to MySQL Database from PHP - Archaic Binary Forums

Home

Forums

	Forum Threaded View

Welcome, Guest
Please remember that if you wish to join in the conversations, you must register an account or login.

Archaic Binary Forums

General

PHP Programming

Re: Connect to MySQL Database from PHP (1 viewing) (1) Guest

Favoured: 0

TOPIC: Re: Connect to MySQL Database from PHP

Forum Tools

zharvek (Admin)

Server Admin, Webmaster, Programming, Eh More...

Admin

Posts: 69

Connect to MySQL Database from PHP 8 Months, 2 Weeks ago Karma: 4

Code:

Standard PHP Connect to MySQL

<?php

    // Connect to database server
    $hd = mysql_connect("myhost", "username", "password")
          or die ("Unable to connect");

    // Select database
    mysql_select_db ("database", $hd)
          or die ("Unable to select database");

    // Execute sample query
    $res = mysql_query("SELECT * FROM customer", $hd)
          or die ("Unable to run query");

    // Query number of rows in rowset
    $nrows = mysql_num_rows($res);

    // Output
    echo "The query returned $nrows row(s):\n\n";

    // Iteration loop, for each row in rowset
    while ($row = mysql_fetch_assoc($res))
    {
        // Assigning variables from cell values
        $data1 = $row["title"];
        $data2 = $row["fname"];
        $data3 = $row["lname"];
        $data4 = $row["phone"];

        // Outputting data to browser
        echo "ROW# $nr : $data1 $data2 $data3 $data4\n";
    }

    // Close the MySQL connection
    mysql_close($hd);

?>

Report to moderator Logged