Need advice: MySQL / Apache - simplest approach

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
gumshoe
Forum Newbie
Posts: 4
Joined: Fri May 11, 2007 11:09 am

Need advice: MySQL / Apache - simplest approach

Post by gumshoe »

Well I hope this is the right forum to ask this in. If not, please redirect me.

I am looking for advice.

I am a Borland Delphi user, at present working in Delphi 7.
After a number of precious weekends trying different things, and having tried all kinds of approaches to this, I am still not able to do more than list a MySQL database in a dbGRid. All I want to do is have a few listboxes, taking a selection from each one to build a simply query to the MySQL database. I want the dbGrid then to show the query result. It's all running, it's all there and in place, but for some reason I keep running into deadends every way I turn when I try to do this simple thing. It's something that I can do for the desktop inside of an hour, why is the internet approach so hard?

As successful users of this medium, what is the simplest way to do the above, in your opinion, and can you help me get over this frustration?

Delphi for PHP has no help and little support, and why do I need something that advanced for this anyway? I've tried some automated programs to no avail. In looking at some information on early versions such as Delphi 2, it looks to me like this type of process has been available since the early days of Delphi. The solution must be easy, and I just need somebody to give me a bit of direction. I'm willing to learn whatever I have to do, as long as I know it will actually work in the end.

I am using Apache server with recent versions of MySQL and PHP, but might have access to an NT server soon if that will help.

Thanks for listening.

Gumshoe
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Post by alex.barylski »

First off, I fail to see how PHP comes into play here?

Secondly, Delphi probably uses data binding technology like VB or other RAD tools, so you need to connect a data-source aware control to a data source.

If your MySQL is running on a remote server and not locally, where I assume your Delphi application is running, you need to make sure bind-address is cleared (I think) in the mysql my.cnf file. Also make sure to add the appropriate user to the user table in MySQL.

Those last two steps took me a day and a half to figure out, which is where I am willing to bet you are going wrong.

Hope this helps :)
Post Reply