Click here to Skip to main content
15,920,596 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
GeneralRe: Voting Functionality -- Incoming Traffic Pin
Ray Cassick20-Jan-11 8:45
Ray Cassick20-Jan-11 8:45 
QuestionAny good sofwtare design software? Pin
venomation12-Jan-11 15:03
venomation12-Jan-11 15:03 
AnswerRe: Any good sofwtare design software? Pin
Pete O'Hanlon12-Jan-11 21:25
mvePete O'Hanlon12-Jan-11 21:25 
AnswerRe: Any good sofwtare design software? Pin
David Skelly12-Jan-11 22:23
David Skelly12-Jan-11 22:23 
AnswerRe: Any good sofwtare design software? Pin
Stefan_Lang4-Feb-11 0:43
Stefan_Lang4-Feb-11 0:43 
QuestionNeed Design Ideas Pin
Kevin Marois12-Jan-11 10:41
professionalKevin Marois12-Jan-11 10:41 
AnswerRe: Need Design Ideas Pin
Pete O'Hanlon12-Jan-11 21:24
mvePete O'Hanlon12-Jan-11 21:24 
AnswerRe: Need Design Ideas Pin
GParkings2-Sep-11 2:40
GParkings2-Sep-11 2:40 
QuestionApplication design code samples Pin
Chesnokov Yuriy12-Jan-11 4:29
professionalChesnokov Yuriy12-Jan-11 4:29 
AnswerRe: Application design code samples Pin
Eddy Vluggen12-Jan-11 4:52
professionalEddy Vluggen12-Jan-11 4:52 
AnswerRe: Application design code samples Pin
Kevin Marois12-Jan-11 5:54
professionalKevin Marois12-Jan-11 5:54 
QuestionSCRUM Pin
Civic0610-Jan-11 9:44
Civic0610-Jan-11 9:44 
AnswerRe: SCRUM Pin
Praveen Raghuvanshi10-Jan-11 17:47
professionalPraveen Raghuvanshi10-Jan-11 17:47 
GeneralRe: SCRUM Pin
Civic0611-Jan-11 2:10
Civic0611-Jan-11 2:10 
GeneralRe: SCRUM Pin
Praveen Raghuvanshi11-Jan-11 18:54
professionalPraveen Raghuvanshi11-Jan-11 18:54 
GeneralRe: SCRUM Pin
Ravi Sant17-Jan-11 21:57
Ravi Sant17-Jan-11 21:57 
QuestionObject heuristic Pin
Leslie Sanford5-Jan-11 11:35
Leslie Sanford5-Jan-11 11:35 
AnswerRe: Object heuristic Pin
Luc Pattyn5-Jan-11 13:06
sitebuilderLuc Pattyn5-Jan-11 13:06 
GeneralRe: Object heuristic Pin
Leslie Sanford5-Jan-11 13:51
Leslie Sanford5-Jan-11 13:51 
GeneralRe: Object heuristic Pin
Luc Pattyn5-Jan-11 14:06
sitebuilderLuc Pattyn5-Jan-11 14:06 
AnswerRe: Object heuristic Pin
Paul Michalik7-Jan-11 1:24
Paul Michalik7-Jan-11 1:24 
QuestionDatabase Code Pin
Leslie Sanford5-Jan-11 5:46
Leslie Sanford5-Jan-11 5:46 
I'm looking for ideas/guidance on how to design serverside functionality for interacting with a database. My situation is pretty typical. I have PHP "scripts" that receive request variables. Based on the parameters passed to it, the script queries a database, formats the returned data in some way, and returns it, usually in JSON format.

I've tried taking various approaches to managing the code for this. For example, I've written sets of functions for querying the databse, e.g. getCustomerByName, getProductsByPrice, etc., with each of these functions containing the necessary SQL code. The problem is that you can have an explosion of these types of functions. And sometimes the queries can get quite nuanced so that you wind up with long named functions like getCustomerByNameAndCountry. This approach doesn't seem to scale well, and has made me a little disillusioned with encapsulating SQL queries in functions.

I was thinking about making functions that are more generalized. Something like getCustomer($columns, $where, $orderBy). In other words, parts of the SQL query would be defined outside of the function and passed in. As long as everything is escaped properly, this should be safe. This approach would mean put the responsibility of parsing the request parameters, determining exactly what is being asked for, and then transforming the request parameters into partial SQL statements that would be passed to general functions for performing the actual query.

But then maybe the functions aren't needed at all?

Anyway, I'm relatively new to DB/severside programming; I've been doing it for less than a year, and I'm still struggling with how to structure a system. Any thoughts are welcome.
AnswerRe: Database Code Pin
dasblinkenlight12-Jan-11 11:42
dasblinkenlight12-Jan-11 11:42 
QuestionMatching between product and customer personal information Pin
Yanshof3-Jan-11 20:07
Yanshof3-Jan-11 20:07 
AnswerRe: Matching between product and customer personal information Pin
dasblinkenlight13-Jan-11 6:24
dasblinkenlight13-Jan-11 6:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.