c0deM0nK424
Programmer
okay here is the situation - i've not dabbled with PhP since late 2010-mid 2012 and back then I was unemployed and trying to brush up on my web design/development/programming skills by writing interesting code snippets and functions with PhP - nothing amazing, just your usual PhP to pull data out of a MySQL DB and manipulate it some form or manner behind the scenes (server-side scripting). I also wrote php code that could traverse through complex XML files and 'pull' out certain child node values depending on what the user wanted to view, using a form - a form presented to a user. I used SimpleXML at the time heh
Fast foward to now - and i am being asked to design and build a website for a client who leases/sells properties in certain parts of London, to close business clients from abroad.
The aim here is to allow my client to be able to add, delete and update property information - which makes sense as some point down the line he will need to add new properties himself to the website if and when he aquires one.
What I'm being asked to do is have a simple real-easte search like facility - this will be a page on the website which is going to be similar to a lot of real-estate websites that have a search facility.
To begin with i want to try and keep it simple, meaning I want to offer the appropriate search criteria presented to them via checkboxes and/or drop down menus. preferably both.
when the user has selected his/her search criteria (price, no. of rooms, etc) and fires the 'search' button - only THOSE properties that meet and satisfy the users search criteria will be neatly displayed as results on the page.
Am I far off from thinking that the normal and most approached way of doing this is precisely using PHP and MYSQL ?
can i store images for the properties in a MySQL database folks ? would it be a 'blob' data type or something ??
never done that before hence why im asking.
How should I approach this one ?
Fast foward to now - and i am being asked to design and build a website for a client who leases/sells properties in certain parts of London, to close business clients from abroad.
The aim here is to allow my client to be able to add, delete and update property information - which makes sense as some point down the line he will need to add new properties himself to the website if and when he aquires one.
What I'm being asked to do is have a simple real-easte search like facility - this will be a page on the website which is going to be similar to a lot of real-estate websites that have a search facility.
To begin with i want to try and keep it simple, meaning I want to offer the appropriate search criteria presented to them via checkboxes and/or drop down menus. preferably both.
when the user has selected his/her search criteria (price, no. of rooms, etc) and fires the 'search' button - only THOSE properties that meet and satisfy the users search criteria will be neatly displayed as results on the page.
Am I far off from thinking that the normal and most approached way of doing this is precisely using PHP and MYSQL ?
can i store images for the properties in a MySQL database folks ? would it be a 'blob' data type or something ??
never done that before hence why im asking.
How should I approach this one ?