Connecting to MySQL in Delphi for PHP (AppObsess)
Posted by Michael on Sunday, March 22, 2009 · 2 Comments
In this video tutorial I begin building an ongoing project called AppObsess, which I will use as a generic and very simple application engine using the Smarty Template engine and the MySQL database. I begin this video series having applied the techniques from the other video’s: Creating Editable Forms for Smarty Templates and Creating Dynamic Smarty Variables in Delphi for PHP.
Connecting to a MySQL database in Delphi for PHP is an extremely simple task. In this video I create a data module and a config file containing the connection strings, include the files and execute the program. That’s the entire video in a nutshell. Most of the video is spent getting up to speed on the state of the application.
The core code is written in a file called maindb.php (the data module) and it looks like this:
-
$MainData->MySQLDB->Host = HOSTNAME;
-
$MainData->MySQLDB->DatabaseName = DATABASE;
-
$MainData->MySQLDB->UserName = USERNAME;
-
$MainData->MySQLDB->UserPassword = PASSWORD;
-
$MainData->MySQLDB->Open();
-
if (! $MainData->MySQLDB->Connected) {
-
}
As always, you should have much better error control handling then I added for this simple tutorial. My connection testing was just to make sure something stupid didn’t happen while I was creating this video.
The config.inc file is very simple as well and only contains the connection strings for MySQL. It looks like this:
The starting template I am using for this AppObsess web framework in Delphi for PHP is the Blue Obsess template available from my XHTML/CSS Templates page.
The starting database SQL I have for this application is:
-
DROP DATABASE IF EXISTS obsess;
-
CREATE DATABASE IF NOT EXISTS obsess;
-
USE obsess;
-
-
CREATE TABLE page (
-
id bigint(20) NOT NULL AUTO_INCREMENT,
-
page_name varchar(200) NOT NULL,
-
page_body text NOT NULL,
-
-
UNIQUE KEY page_name (page_name),
-
PRIMARY KEY (id, page_name)
-
) TYPE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1000;
If you would like to download this application in the state it is for this video, you can download it using the link below. The .SQL file, the template, and the Delphi for PHP project code is all included.
Free Membership Required: Please Login or Register to read the rest of this content.
Hi, I’m coming from many years of Delphi Win32 experience and I was looking for a starter in Delphi 4 php.
Your videos provided what I was looking for – please keep ‘em coming and thanks a lot,
Alex
I plan to create more. I’m currently in China and working on a few things, and the quality of my sound might not be that great but I am putting more video together for Delphi for PHP development, as well as other things.
Thanks!