TECH6.0

UaECasher · #1 13-10-2008, 04:22 PM

Hello, So I'm making a real estate site as my computer project

I have finished learning the basics PHP and MySQL and now it's time to implement my knowledge in this project

1st thing came in mind is the structure of the db. I mean which tables,rows should i create and which rows.

can u advice me some ideas thanks

webwizzy · #2 13-10-2008, 05:21 PM

well.. I don't have much idea about real estate (or property dealing sites).

But I would suggest you to search for such sites and see what data they ask for. One popular Indian real estate site I know is http://www.99acres.com/

As you can see on the site's homepage, a quick property search form is there. So from the top of my head, the main table would contain all information of each property in a row. The most basic fields would include:-

UserID creating the record
If its available for Buy Only, Rent Only OR both (0,1,2)
Price
Number of bedrooms
Square feet (area)
Keywords
Type of property like Residential apartment, farmhouse etc. (Make a list)
City where the property is located.
Date when the record was created.
Date when the record was last updated
Log the IP of the user on creation and update. (Mention this in your privacy statement)

and so on..

Efficient, flexible and quick searching for property is the MOST important part for any real estate site. It should be carefully worked on and the process should be made very easy for an end-user.

You can create a table called property whose fields are as described above.
A table called user that contains the information of the person who can list property for sale, rent, etc. (a registered user, in simple words). Verify their validity with advanced techniques like mobile verification system.

This is a BASIC approach for building a real-estate site, a lot more can be done with it. But this info can help you get started atleast. Keep thinking, looking and taking ideas from current sites.

All the best

UaECasher · #3 13-10-2008, 05:34 PM

ok thanks for the help i think i should do a blueprint or list of task i should do in the site

UaECasher · #4 15-10-2008, 08:21 PM

ok my computer teacher says i should make less tables as possiable do you agree?

webwizzy · #5 15-10-2008, 08:24 PM

You would require atleast the property table and the user table. Is two okay for the teacher lol

UaECasher · #6 15-10-2008, 08:32 PM

what about a transaction table?

webwizzy · #7 15-10-2008, 08:34 PM

Make it if you feel the need. I think its important as well.

There's no harm if you even reach 5-10 tables. The project should be worth it, thats all.

UaECasher · #8 15-10-2008, 09:52 PM

i think the transaction table is important because it's the thing will make my site useful (interact with the user) other than the search but we can make something similar to search in HTML (static site) which would not fetch me marks

UaECasher · #9 15-10-2008, 10:22 PM

i have created it as following

Code:

 CREATE TABLE `casherzc_gooo`.`properties` (
`property_ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`price` INT NOT NULL ,
`number_of_bedrooms` INT NOT NULL ,
`area` INT NOT NULL ,
`type_of_property` TEXT NOT NULL ,
`city` TEXT NOT NULL
) ENGINE = MYISAM

UaECasher · #10 15-10-2008, 11:31 PM

what fields you think i should add in transaction table?

webwizzy · #11 15-10-2008, 11:36 PM

fields like id, time_of_transac, ip, userid, fields affected and so on..

UaECasher · #12 16-10-2008, 12:49 AM

hmm OK can you tell me how to get his (customer) IP?

webwizzy · #13 16-10-2008, 12:50 AM

PHP Code:

  $ip=$_SERVER['REMOTE_ADDR'];

UaECasher · #14 16-10-2008, 12:57 AM

Thanks

this will be the longest thread in tech555 or any vb forum who knows lol

UaECasher · #15 16-10-2008, 06:00 PM

ok so now I'm working on the site design http://project.casherz.com/ nothing fancy, wanted to ask if it will be better to change the color of the navbar if i want to put it below the header, and if so what color u think will look nice?

webwizzy · #16 16-10-2008, 06:26 PM

At first I would say, why not keep the color of pages as plain white, with text as black and hyperlinks as red or blue.

You can make a navigation bar in shades of blue or white/blue gradient. Keep it professional and soothing to eyes

UaECasher · #17 16-10-2008, 06:33 PM

look, i don't this will look pro at all

it will be like an empty site lol

webwizzy · #18 16-10-2008, 06:38 PM

well.. It was just an opinion seeing 99acres.com, It has exactly the same color combination that I described. Does it look empty

anyways.. if you wanna keep the colors that you have already, then a navbar in black/grey would do good I think (i am no way a designer lol), just a lil' thought. Why not check dhtmlgoodies or dynamicdrive for some exceptionally well menu bars in javascript and dhtml.

UaECasher · #19 16-10-2008, 07:12 PM

bro how to make a relationship between tables?

webwizzy · #20 16-10-2008, 07:20 PM

I seriously think, google can give a better answer for this.
Read about SQL Join keyword at w3schools.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

TECH6.0

Building a Real Estate site in PHP