This board has been transferred to www.wsc.co.uk,

    why not join us there

One Touch Football - Archive   
my profile | directory login | search | faq | forum home

  next oldest topic   next newest topic
» One Touch Football - Archive » World » php/mySQL help wanted

 - UBBFriend: Email this page to someone!    
Author Topic: php/mySQL help wanted
Guy Potger
Member
Member # 1315

 - posted      Profile for Guy Potger     Send New Private Message       Edit/Delete Post 
(Apropos a half-remembered conversation in the pub, and apropos a half-scribbled note)


What is used/can be used/is available as the middle layer between php at the front end, and mySQL as the back-end database server.

Any thoughts/help/guidance gratefully received.

Thanks.

Posts: 2834 | From: Sheffield | Registered: Aug 2005  |  IP: Logged | Report this post to a Moderator
Cavalry Trouser Tips
Member
Member # 1274

 - posted      Profile for Cavalry Trouser Tips     Send New Private Message       Edit/Delete Post 
You are probably talking about a database abstraction layer. I use ADOdb.

Edit: although you could try ezSQL too.

[ 17.10.2006, 13:54: Message edited by: Cavalry Trouser Tipps ]

Posts: 4359 | From: Mekonta | Registered: Jul 2005  |  IP: Logged | Report this post to a Moderator
PR7th Heaven
Member
Member # 796

 - posted      Profile for PR7th Heaven     Send New Private Message       Edit/Delete Post 
PHP has a lot of built-in functions for interacting directly with mySQL should you wish. mysql_connect, mysql_query and so on. An abstraction layer would typically use these or similar functions to make the tasks of reading and writing data more straightforward. There are loads out there, and it's not a huge job to write your own either.

If you're talking about PHP-based database management options (something like SQL Server's enterprise manager for example) then PHP MyAdmin is a common choice, although it is lagging behind MySQL quite a bit at present. It's still perfectly serviceable for basic management and configuration, but doesn't go very far in terms of WYSIWYG.

Posts: 906 | From: The other end of Stretford | Registered: Jan 2004  |  IP: Logged | Report this post to a Moderator
Cavalry Trouser Tips
Member
Member # 1274

 - posted      Profile for Cavalry Trouser Tips     Send New Private Message       Edit/Delete Post 
I use Navicat for both MySQL and PostgreSQL database administration.

It costs $99, but is worth every cent.

Posts: 4359 | From: Mekonta | Registered: Jul 2005  |  IP: Logged | Report this post to a Moderator
Cavalry Trouser Tips
Member
Member # 1274

 - posted      Profile for Cavalry Trouser Tips     Send New Private Message       Edit/Delete Post 
Of course, if you're building a web application and want it to be a fun experience, may I suggest jibbing off PHP completely and checking out the wonderful Ruby On Rails framework.

Ruby is a great language and Rails is a joy to work with. There are loads of articles and tutorials too.

Posts: 4359 | From: Mekonta | Registered: Jul 2005  |  IP: Logged | Report this post to a Moderator
Malcolm X
Member
Member # 45

 - posted      Profile for Malcolm X     Send New Private Message       Edit/Delete Post 
Databases nearly failed me on my degree.

Hate the goddammed things.

Posts: 14206 | From: Laughing at the budgie hearts | Registered: May 2002  |  IP: Logged | Report this post to a Moderator
Barndoorio
Member
Member # 69

 - posted      Profile for Barndoorio     Send New Private Message       Edit/Delete Post 
Amatuer!
Posts: 5360 | From: Glorious Taunton | Registered: May 2002  |  IP: Logged | Report this post to a Moderator
Guy Potger
Member
Member # 1315

 - posted      Profile for Guy Potger     Send New Private Message       Edit/Delete Post 
Thanks folks.

I'll pass this on.

Posts: 2834 | From: Sheffield | Registered: Aug 2005  |  IP: Logged | Report this post to a Moderator
   

   Close Topic   Feature Topic   Move Topic   Delete Topic next oldest topic   next newest topic
Hop To:


Contact Us | WSC

Powered by Infopop Corporation
UBB.classic™ 6.7.2

    This board has been transferred to www.wsc.co.uk,

    why not join us there