Any decent PHP/MySQL programs out there?

Emzi · November 14th, 2007, 11:55 AM

Hi all,

I'm currently developing a project using PHP and MySQL although to be honest, I'm not that great on either of these things and am resorting to using Dreamweavers automatic queries/codes etc. Which is ok, but it's giving me a bit of a headache - and to top it all off, Dreamweaver has decided to crash on me on one particular file that I need to edit (which I'm now having to use notepad to edit - which would be fine if I were an expert at PHP).

Annnywayyy... are there any programs similar to Dreamweaver in that it automaticallly does the PHP code for you but not as bad as Dreamweaver in terms of crashes / unreliability? A program that's merely aimed at PHP/MySQL users??

I'd really appreciate it if anyone could point me in the right direction here.

Thanks

karinne · November 14th, 2007, 11:59 AM

There was one that was suggested a few weeks back

Code Lobster ... check the HTML Editors thread for the link ... I think it's the last post.

As for MySQL ... it's a database so ... there's no "software" that you use. You just need to learn how to make SQL statements which is pretty easy. Just look up the documentation online.

Marc · November 14th, 2007, 02:40 PM

To run the SQL statements i use TOAD which i find very helpful! It also highlights brackets for you

.

sannbe · November 14th, 2007, 03:06 PM

I personally use Xampp for SQL/PHP. It gives you them plus an apache server to test on. I originally tried to install them individually, but my lack of knowledge made it impossible. http://www.apachefriends.org/en/xampp.html

Marc · November 14th, 2007, 03:15 PM

Yep, i use that aswell Sara (sannbe) - great tool! I only use TOAD to connect to the MySQL Database and execute, create, drop tables

.

AcidCorrosion · November 14th, 2007, 04:47 PM

I currently use WAMP plus something called phpDesigner professional 2007. I got the program from my friend, and the validation can prove pretty useful.

WAMP is your basic apache server, with mysql, php,python,perl. Easy to setup, easy to use

prizm · December 11th, 2007, 04:35 PM

Quote:

Originally Posted by sannbe

I personally use Xampp for SQL/PHP. It gives you them plus an apache server to test on. I originally tried to install them individually, but my lack of knowledge made it impossible. http://www.apachefriends.org/en/xampp.html

Wow, that program is awesome! Thanks so much!

JustinStudios · December 11th, 2007, 04:46 PM

Xampp isn't bad but then again I stay away from code done by others as much as possible. I like to make my own code and build my own library because 1) I know it works, and 2) I know what each thing does and how they do it PLUS I got a listing on what values it returns and how. Also, I do Object Oriented Programming and most of these "add component" is bloated and isn't very OOP friendly.

BTW MySQL does have a easy to use program, it's called PHPMYAdmin.. You can install this on your "server" your running Xampp on. It makes database creation as easy as click and select.

Marc · December 11th, 2007, 04:49 PM

I used to use PHPMyAdmin but it was far too slow and annoying. Toad is a lot, lot better!

prizm · December 11th, 2007, 04:52 PM

Yes, phpMyAdmin works well and comes with the Xampp package. It looks to be for those lacking knowledge in that area like me. I'm just learning so it helps to see the generated code to learn from. It's a start...

JustinStudios · December 11th, 2007, 04:57 PM

Never used Toad before.. Looks neat Ima try it out :P