Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
8
Impact
~2k people reached

  • 0 posts edited
  • 3 helpful flags
  • 19 votes cast
Dec
23
awarded  Popular Question
Dec
26
comment Designing a Web Application with Two Different Backend Databases
I've done my best to make "Joins" between the two DBs as infrequent and simple as possible for that very reason. Both DBs are as independent as possible. Could you elaborate more on the connection pool? With the current set up, the SQL Servers are completely separate from the application so the connection is made when it is needed (which is most of the time). I don't really control the connection, just the credentials. If the client so chooses, they could turn off the server holding their data and the application would no longer function.
Dec
26
asked Designing a Web Application with Two Different Backend Databases
Dec
24
comment Which is better: to include HTML inside PHP code or outside it?
+1 For being good advice for everyone. Alternate control syntax and short tags are immensely important for getting started with templates and separation of logic from presentation.
Dec
4
awarded  Editor
Dec
4
revised Generating Deep Arrays: Shallow to Deep, Deep to Shallow or Bad idea?
Arrays are not cups.
Dec
4
awarded  Commentator
Dec
4
comment Generating Deep Arrays: Shallow to Deep, Deep to Shallow or Bad idea?
To clarify, the end goal is a single, complex report. The complexity however does not come from user input (which is minor, usually 2 parameters, never more than 6), it comes from the data itself. It takes 7 SEPARATE queries just to get all of the data. From there it needs to be organized for output. Backbone.js is cool but because of the fact that I just need "click button, see report", I want to avoid too much fancy javascript. And I must admit, I'm struggling to get any existing MVCs to work for this situation, as it's a very non-conventional setup.
Nov
30
comment Using which technique does facebook and pininterest show images?
Trello also uses the History API and pushState extensively.
Nov
21
asked Generating Deep Arrays: Shallow to Deep, Deep to Shallow or Bad idea?
Oct
22
comment Is a simple iPhone app more appealing to users than a mobile website?
+1 You aren't building an application, you are building a website(from the sound of it). So it should be a website, not an application. It shouldn't even be referred to as web app, don't say HTML5. It's just a mobile website (images and text).
Oct
15
awarded  Citizen Patrol
Oct
12
answered What is the proper way to create a cross-fade effect?
Oct
8
awarded  Teacher
Sep
28
answered Web Developer or Web Designer
Sep
12
awarded  Supporter
Sep
12
awarded  Scholar
Sep
12
accepted Does the deprecation of mysql_* functions in PHP carry over to other Databases(MSSQL)?
Sep
12
comment Does the deprecation of mysql_* functions in PHP carry over to other Databases(MSSQL)?
Thank you for helping me understand this subject a little more. I think the takeaway is that PDO's are most useful at saving you from your own bad decisions.
Sep
12
comment Does the deprecation of mysql_* functions in PHP carry over to other Databases(MSSQL)?
This helps to answer a lot of my questions. One last question, mssql can be as secure as PDO, but it seems to be more difficult. Without prepared statements, I would need to filter input VERY thoroughly. That said, how can one do that with MSSQL? mysql_real_escape_string is decent, but not compatible and there is no equivalent function for MSSQL. What would be a go to solution to avoid SQL injection WITHOUT the use of prepared statements in MSSQL. Preferably not this