SitePoint Sponsor

User Tag List

Results 1 to 13 of 13
  1. #1
    SitePoint Zealot
    Join Date
    Aug 2008
    Location
    Western Australia
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Real Estate site issue

    A real estate client wants to have on the main page a search facility in a box whereby a client can search for a property/business by selecting: Property or Business, Price Range and Suburb then click and be taken to a selection.

    I am used to doing fairly simple informational sites with very little javascript. Am I right in thinking this would require that? If so, is there anywhere I can obtain a script?

    Would a site like this require a database?

    Thank you!

  2. #2
    SitePoint Member
    Join Date
    Aug 2008
    Location
    Adelaide, Australia
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This would need a database. I would recommend PHP for the serverside language, and MySQL for the database.

    Javascript is just a client side language, not designed for managing content like a list of properties...you could use AJAX to do the queries, but you would need a backend database to store the data

  3. #3
    SitePoint Zealot
    Join Date
    Aug 2008
    Location
    Western Australia
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you, Matthewjumps - as you can tell I am not clued up on this side of things. I can manage CSS and XHTML but this is all. Would I need to get someone else to do the database?

  4. #4
    SitePoint Member
    Join Date
    Aug 2008
    Location
    Adelaide, Australia
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would recommend you invest some time learning it. it adds another dimension to your skills.

    But if thats not an option, yes, get someone to do it for you...

  5. #5
    SitePoint Zealot
    Join Date
    Aug 2008
    Location
    Western Australia
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Would I be able to learn it in time to do a site in a few weeks?

    Thanks for the advice!

  6. #6
    SitePoint Wizard Stomme poes's Avatar
    Join Date
    Aug 2007
    Location
    Netherlands
    Posts
    10,283
    Mentioned
    51 Post(s)
    Tagged
    2 Thread(s)
    Only if you think you can properly learn two whole new languages in a few weeks : ) I don't recommend PHP but its upside is that just about everyone uses it, so possibly there are many scripts already written for you (but the same can be said about Perl and its modules at CPAN). MySQL is a database query language and the speed at which your site can call that information and get it to the screen depends mightily on how well you make and index those tables. This is something that I'd recommend someone do for you, while you're learning. That way, you'll be able to maintain this set-up later, and you could be ready for your next project with the skills in hand (which make you more valuable, no doubt about it).

    But running quickly into any language (even a sloppy one like PHP) is a good way to get slow, uneven results, and possibly security issues (even if real estate info itself isn't anything terribly personal). My company has a similar-sort of real estate site (two actually) and here's something none of my colleagues seem to have thought about (and I cannot implement anything with it because I don't know these languages much either): someone could submit a property to our database, which then gets a URL, and spam everyone to that page, which instead of real home/property information has some sort of spammy info on board.

    You likely also wouldn't want anyone to be able to copy files out of your database so as to use it as their own database too (to make their site look bigger by having more search results for instance). There could possibly be a whole can of worms here, so take your time in learning things The Right Way (as much as that's possible).

  7. #7
    SitePoint Zealot
    Join Date
    Aug 2008
    Location
    Western Australia
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you Stomme poes - a lot to think about.

    I probably should expand my horizons but not at the expense of clients so I will first of all see if they really need a data base driven site, depending on the number of properties they want to list and if so, get someone else to do it for now. Thank you again.

  8. #8
    SitePoint Wizard Stomme poes's Avatar
    Join Date
    Aug 2007
    Location
    Netherlands
    Posts
    10,283
    Mentioned
    51 Post(s)
    Tagged
    2 Thread(s)
    I can't imagine a real estate site without a database-- properties will be moving in and out. Without a database, someone would manually have to upload and delete the data about particular properties as they go on and off the market. That would, I think, be more work and money than developing a database. It's just that building a database should be donee as carefully as building a house, and done by skilled dudez.

  9. #9
    SitePoint Member
    Join Date
    Aug 2008
    Location
    Adelaide, Australia
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Stomme poes View Post
    But running quickly into any language (even a sloppy one like PHP)
    Eh???? Sloppy???

    Which language do you think is not sloppy? ASP? ColdFusion? What?

  10. #10
    SitePoint Wizard Stomme poes's Avatar
    Join Date
    Aug 2007
    Location
    Netherlands
    Posts
    10,283
    Mentioned
    51 Post(s)
    Tagged
    2 Thread(s)
    The Perl community may have biased me, and my husband refuses to run any mailservers with PHP because of security.

    obviously perl biased

    However I myself have had to battle with a colleague who, perhaps because he did PHP before using Perl (and he still uses PHP, so we have some sites in PHP and some in Perl), cannot keep his naming conventions, causing stupid errors because he first would agree to do element names, say, in camelCase and then in his implementation mixes with AllUppercase and someThings_with_underscore and that's a bad, bad, bad habit. Can you keep good habits with PHP? I'm sure you can, but I'll not recommend it to someone who doesn't know any back-end languages. PHP seems easier, and everyone and his brother seem to use it. But while sloppy code will barf in some languages, others let you write utter crap and it still (somehow) works. I'm seeing this more and more as I crawl into Javascript. There's more than one way to do things, but some ways will let your machines get wiped and others will help you better maintain them and protect them.

    And when people dive too quickly into languages, is it just me or are PHP and Javascript the ones they dive into? So, I wanted to warn him of jumping fast into something that looks (on the surface) easy to learn and thus something you can learn in "a few weeks".

    I've heard way too many horror stories about ColdFusion lawlz. But though there's less out there about it, how about Python?

    If Jasnick does searches on database web stuff, s/he'll definitely run into PHP-MySQL pages the most. Like 2 peas in a pod.

  11. #11
    SitePoint Zealot topgrade's Avatar
    Join Date
    Jun 2007
    Posts
    171
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you may check readymade scripts from hotscripts.com in the language of your choice.
    DoFollow Backlink Checker | Internet Marketing and SEO Forums

    22,000+ List of Directories to submit your site. List of Blogs, Forums, Press Release, Social Media... (sort by PR & Alexa)

  12. #12
    SitePoint Zealot
    Join Date
    Aug 2008
    Location
    Western Australia
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks all - I am not completely new to databases - just haven't used them on web sites before. I am doing an informational site for another part of the company and seeing this, it was suggested I do a new one for the real estate side. However, I don't think the client realises what is involved and how different a database driven site would be from a simple informational one and I have no intention of taking on work I could not perform adequately. I do have a colleague who specialises in the technical side of things so if they really want to spend the money, can bring him in.

    Thanks again for the replies.

  13. #13
    SitePoint Enthusiast
    Join Date
    Aug 2008
    Location
    Boston
    Posts
    37
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i ran into the same problem a few months back, was asked to develop a dynamic web application after only working on static sites. took the time to learn mysql and php and now way more confident working with database's and I dont have to subcontract all that type of work out anymore.
    Interstate Web Media
    Small Business Web Solutions
    http://www.interstatewebmedia.com
    http://googleadwords.interstatewebmedia.com


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •