WeberDev.com PHP and MySQL Code

LOG IN
BEGINNER GUIDES |  PHP CLASSES |  CODE SEARCH |  ARTICLES SEARCH |  PHP FORUMS |  PHP MANUAL |  PHP FUNCTIONS LIST |  WEB SITE TEMPLATES
Start typing to search for PHP and MySQL Code Snippets and Articles Search
Submit a code Example / Snippet Join us on FaceBook
Submit a code Example / Snippet Submit Your Code
Poker Tournaments Poker Tournaments
Poker Guide for Developers Poker Guide for Developers
Search Engine Optimization Monitor SEO Monitor
Web Site UpTime Monitor UpTime Monitor
Your Personal Examples List My Favorite Examples
Your Personal Articles List My Favorite Articles
Edit Account Info Update Your Profile
More Weber Sites
PHP Code Search
Web Development Forums
Learn MySQL Playing Trivia
PHPBB2 Templates
Web Development Resources
Web Development Content
Internet Security Software
Recommended Links
PHPClasses
PHP Editor
PHP Jobs
Vision.To Design
Ajax Tutorials
PHP Programming Help
PHP/MySQL Programming
Webmaster Resources
Webmaster Forum
XML meta language
website builder
Recommended
פרייסז - הכח לקנות עובר לידיים שלך
Texas Holdem Poker Evangelists

Go Back Add a Comment Send this example to a friend Add this Article to your personal favoritest for easy future access to your favorite Code Examples and Articles. Submit a code example Print this code example.
BACK ADD A COMMENT SEND TO A FRIEND ADD TO MY FAVORITES ADD CODE EXAMPLES PRINT
PHP Code Examples Submit your own code snippets Latest Code Examples RSS Feed
Title : Cut your MySQL Connections to 1 line of code
Categories : PHP, Beginner Guides, Databases, MySQL Update Picture
Jason Locashio
Date : May 27th 2004
Grade : 2 of 5 (graded 4 times)
Viewed : 15609
File : No file for this code example.
Images : No Images for this code example.
Search : More code by Jason Locashio
Action : Grade This Code Example
Tools : My Examples List
Code

Submit your own code examples  Submit your own code examples 
 

I got tired of typing the connection code for MySQL on every PHP page, so we built this simple little function. Credit to Adam Presley of mighty-atom.com for his input.

<?php
//--------------------------------------------------------------
// CONSTANTS
//--------------------------------------------------------------
define("DBSERVER", "qwerty.com");
define("DBUSER", "LimitedUser");
define("DBPASS", "N0tAPa55w02d");

$SQL = "";
$LastError = "";


function DatabaseConnect()
{
   global $LastError;

    $LastError = "";

    //-----------------------------
    // Connect to the mysql server.
    //-----------------------------
    $dbHandle = @mysql_connect(DBSERVER, DBUSER, DBPASS);
    if ($dbHandle == false) {
        $LastError = "Unable to connect to the database server: " . mysql_error();
        return false;
    }

    mysql_select_db("test");

    return true;
}
?>



Related Code Examples
Newbie Notes #10 - Generating drop downs
Categories : PHP, MySQL, HTML, Beginner Guides, Databases
Making a simple Hit-Log using PHP and MySql
Categories : PHP, Log Files, Beginner Guides, Databases, MySQL
bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases
This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server.
Categories : Databases, MySQL, Complete Programs, PHP, Databases
Specify your connection settings and create a link to a MySQL database.
Categories : PHP, PHP Classes, Databases, MySQL, Beginner Guides
for each record, do this to the first record, and do that to any subsequent record
Categories : PHP, Databases, MySQL, Beginner Guides
Convert a File database into MySQL
Categories : PHP, Filesystem, Databases, MySQL, Beginner Guides
Newbie Notes #4 - Trapping dumb MySQL query errors
Categories : PHP, Databases, MySQL, Debugging, Beginner Guides
mySQL/PHP/search with multientry form and table output with colored rows
Categories : PHP, Beginner Guides, MySQL, HTML and PHP, Databases
email new items in db
Categories : PHP, Email, Databases, MySQL, Beginner Guides
Add, Edit /Update & Delete all in one Contact Management Form
Categories : PHP, MySQL, Databases, Beginner Guides
How to Insert a Date Format Into MySQL from PHP
Categories : PHP, Databases, MySQL, Date Time, Beginner Guides
free, search engine, indexing, system, information, web, ftp, http, free, software, cgi, php, MySQL, database, php3, FreeBSD, Linux, Unix, UdmSearch
Categories : MySQL, Complete Programs, PHP, Databases, Search
http://phpMySearch.web4.hm - The phpMySearch search engine system is a completeworld wide web indexing and searching system for a small domain or intranet.
Categories : Search Engines, PHP, Databases, MySQL
Required form fields that pull from MySQL database
Categories : PHP, HTML and PHP, Databases, MySQL