Posted By

czapata on 11/24/08

Tagged

mysql
php

Versions (?)

Last Edited at 11/24/08 10:54am

Statistics

Viewed 736 times

Favorited by 2 user(s)

Related snippets

Quick MySQL Connection Test

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

<?php
 
     # Define MySQL Settings
     define("MYSQL_HOST", "");
     define("MYSQL_USER", "");
     define("MYSQL_PASS", "");
     define("MYSQL_DB", "");
 
     $conn = mysql_connect("".MYSQL_HOST."", "".MYSQL_USER."", "".MYSQL_PASS."") or die(mysql_error());
     mysql_select_db("".MYSQL_DB."",$conn) or die(mysql_error());
 
     $sql = "SELECT * FROM YourTableName";
     $res = mysql_query($sql);
 
     while ($field = mysql_fetch_array($res))
     {
         echo 'FieldName1: ' . $field['fieldname1'] . '<br />';
         echo 'FieldName2: ' . $field['fieldname2'] . '<br /><br />';
     }
?>