The power of PHP and MySQL

[hoggbottom59]

I am planning on setting up a db backend on Linux with MySQL.

I wish to use PHP to access it.

From an MS Access background this is all new to me. I would like to know how much you can do with PHP. Can you perform any of the same clever tricks as with VBA?

Thanks,
59.

 

[oharab]

I was thinking of doing the same, just to prove to my employers that computers are more than Wintel!
I have no experience of it (yet!), but PHP seems a very powerful tool, that will give you much of the power & flexibility of Access, though you will be pretty limited by the limitations of an html interface. That said, there are loads of easy to interface html databases on the web, so the biggest limitation will be your imagination.
Best of luck in your project, let us know how you get on!

Cheers

ben ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------

 

[hoggbottom59]

Here's a few links to try then.

Good Luck.

Leon.

 

[LittleHavoc]

I have started writing websites using PHP and Mysql about a year ago, and can't imaging changing to anything else.

There are a lot of sites hosting this configuration, and I have also set-up my Win2000 machine with PHP,MySQL using IIS. It's very easy to get to grips with and if you use phpMyAdmin, you can manipulate the database with extreme ease (like Access).

MySQL(free) however is much more stable and less demanding than Access. It is more comparable to SQL Server(lots of money to get and host).

You can use PHP to interface with most databases not just MySQL, these include MS Access.

Try looking at

http://www.phpbuilder.com

and webmonkey for some easy to follow tutorials.

I strongly advise getting to grips with PHP, you can get very powerful programs/websites (including intranet) quite quickly.

 

[hoggbottom59]

Cheers I'll take a look.

Just realised I never put the two links in my posting!

http://perl.about.com/gi/dynamic/offsite.htm?site=http://www.nr1webresource.com/article.php3?id=152

http://www.phpwizard.net/projects/phpMyAdmin/

Leon.

 

[ErikZ]

I had no experence with PHP or MySQL. But I've taken a year's worth of database classes and come contract work with Access.

In short order and some "How To" books, I built a nice little dynamic webpage. It works great and I've had no technical problems.

If you are used to Access, I strongly suggest getting a graphical interface program for MySQL.