How should I create a database of real estate? :)

[Ryan M.]

As the title says: How should I go about this?

Anyway, the problem is that I want to create a database of real estate. Simple, really. If only I knew PHP. And MySQL. And, preferably, I'd like to be able to manipulate the database using a web interface.

So... is there a premade software out there which I can use to edit the MySQL database and easily search and return results where I don't have to do any/minimal PHP stuff? I'm good at following directions, I just don't know it right now and am too lazy to learn unless necessary.

Yeah, I'm in a hurry, so ask questions if you're confused about what I mean.

[Raven_Writer]

Originally Posted by Ryan Morehart

As the title says: How should I go about this?

Anyway, the problem is that I want to create a database of real estate. Simple, really. If only I knew PHP. And MySQL. And, preferably, I'd like to be able to manipulate the database using a web interface.

So... is there a premade software out there which I can use to edit the MySQL database and easily search and return results where I don't have to do any/minimal PHP stuff? I'm good at following directions, I just don't know it right now and am too lazy to learn unless necessary.

Yeah, I'm in a hurry, so ask questions if you're confused about what I mean.

What exactly do you want for it?? Also, what is the purpose??

If you'd like to find a script on your own, you can go here *<-- not Google -->*

Most are free (or cost very little).

[robot180]

Remember that if you want to use PHP or MySQL, you need a server that supports it. I am not sure if you want the database on your computer or on a web server. If you want it on your computer than use Microsoft Access or Excell. If you want it on a web server, you need one that has PHP and MySQL or similar languages and databases.

[Raven_Writer]

Originally Posted by robot180

Remember that if you want to use PHP or MySQL, you need a server that supports it. I am not sure if you want the database on your compurer or on a web server. If you want it on your computer than use Microsoft Access or Excell. If you want it on a web server, you need one that has PHP and MySQL or similar languages and databases.

You can set up a server on your own computer, for testing and not, and it doesn't even take up 50 megs to set up (for me anyways). I just used phpdev (search sourceforge.net for it). It gives you a few package options, the most basic is PHP 4 (maybe 5), and MySQL 3.2.x for only a 10 meg download.

[phrontist]

Simple: Don't.

I've done a lot of stuff with GIS and almost every municipality in the country has an online real-estate assesment database that is really easy to interface too. Google for it.

[Max Lobovsky]

I'll have to agree with Phrontist. The only reason I could see you doing such a project is just for the sake of learning PHP. Actually, I take that back, I have no idea what you are doing so I can't really comment. It sounds like all you want to do is store some information and search it? Can't you just make an Excel spread sheet and put it online? Regardless, please give us more information so we can help you better.

[Joshua May]

Originally Posted by Ryan Morehart

So... is there a premade software out there which I can use to edit the MySQL database and easily search and return results where I don't have to do any/minimal PHP stuff? I'm good at following directions, I just don't know it right now and am too lazy to learn unless necessary.

As far as creating the MySQL Database and adding and editing items in it, phpMyAdmin works great. However, you have to script your own interface (or there might be some available that I don't know about) if you want to edit the database from a webpage.

[Pierson]

I don't know what your end-all-be-all-goal is... but you can use MS Access.. and do a data access page which allows you to manipulate the database through a web browser...

What do you want to do? Build a database to keep track of renters? There might even be an Access template to do what you want to do!

[Ryan M.]

Originally Posted by Raven_Writer

You can set up a server on your own computer, for testing and not, and it doesn't even take up 50 megs to set up (for me anyways). I just used phpdev (search sourceforge.net for it). It gives you a few package options, the most basic is PHP 4 (maybe 5), and MySQL 3.2.x for only a 10 meg download.

Yes, I already have a server setup with MySQL, PHP, and Apache. And they work.

Describing the problem in more detail:
My dad's a real estate agent. I'm creating a website for him and one of the things I pretty much have to have have on it is a list of the houses he's currently selling.

However, I've decided it doesn't matter right now. When I do end up needing this, I'll bring it up again. Thanks to all who discouraged me...

[robot180]

I have an idea then, a photo gallery. However, add in some stuff to store more information about each house and display it below each picture or display a link to a page that displays thew information.