PHP Editor For MySql

[jereece]

I am kind of new at this, so I hope this is not a dumb question. I have a MySql database on my web site. I have added a table and fields to hold information (i.e. name, phone, areas of expertise, etc.). Now I need to build a web form for users to post their information and I also want a web page so that users can search the data for people with particular areas of experties. I have pretty good HTML skills, but have never connected to a database or read from a database. So, is there a PHP Editor that I can use to make this easy. Since I don't do this often, something WYSIWYG would be nice, but I am open to learning new things the hard way if needed.

Thanks for your suggestions.

Jim

[msheresh]

PhpED from NuSphere has DB Wizzard - it will walk you through making connection to the database (e.g. MySQL) and will generate PHP code implementing connection to the db. Their website is www.nusphere.com.
Good luck!

[jereece]

At $300, that's a little too expensive for the simple task I am trying to do. Plus, we are a non-profit organization and out annual budget is very small. So if anyone has any other suggestions, I would appreciate it.

Thanks,
Jim

[msheresh]

I had dealings with them, they have discounts for non-profits and their service is great, they reply to emails right away. I don't remember who I emailed to, I suggest going to Contact us on their web site

[jereece]

The non-profit price is still $240. Our organization is just way to small to afford this and what I need to do only involves a few pieces of data. So I will look elsewhere for something or just learn how to manually do this.

Thanks for the suggestion.

Jim

[Tubaplayer.com]

I don't know what your budget is, but I'd take a look at phprunner. Costs 99$, but you get a 21-day trial to try it out first, fully functional. I used it make a sheet music arhive, and I'm still using that archive. Only downside is that it has a "To remove this, buy a license" thing.

Not wysiwyg, but very easy to use and very advanced! I probably did what would have taken me 10 days to do manually in one afternoon.

http://www.xlinesoft.com/phprunner/download.htm

Edit: Sorry, thought it was 99$, seems it's 199$. New version (3.0) har better UI, and template editor. Still not full wysiwyg, but even better than the one I tried. I'll try 3.0 now!

Paal

[kdittyr]

I have tried out a few different ide's and have found three that are really usefull:

1. Webuilder 2006 $39.85 http://www.blumentals.net/webuilder/

the above IDE has an SQL browsers in it that will help you to connect to a database and create a query.

2. PHP Designer 2006 (2007 is out now for $69) http://www.mpsoftware.dk/
3. StarPHP donation http://www.starphp.com/