Tagged Questions
29
votes
9answers
2k views
Why isn't protection against SQL injection a high priority?
On Stack Overflow, I see a lot of PHP code in questions and answers that have MySQL queries that are highly vulnerable to SQL injection attacks, despite basic workarounds being widely available for ...
16
votes
10answers
1k views
Struggling as a programmer. Need some advice [closed]
I've been a developer now for a number of years. I'm pretty good at what I do and can "get the job done".
But, there is a difference between "getting the job done" and "doing the job properly". Let's ...
12
votes
3answers
738 views
How to build completely modular web applications
In the coming months we're going to begin a project where we take a system we've built for a client (v1) and rebuild it from scratch. Our goal with v2 is to make it modular, so that this specific ...
9
votes
11answers
2k views
Why did Facebook, Wordpress, vBulletin use PHP/MySQL?
Is there a reason regarding the goals of these sites of using PHP? I mean is it PHP/MySQL is the most suitable tools to run these sites or is it the reason because no other languages but PHP were ...
9
votes
5answers
323 views
When is it better to offload work to the RDBMS rather than to do it in code?
Okay, I'll cop to it: I'm a better coder than I am at databases, and I'm wondering where thoughts on "best practices" lie on the subject of doing "simple" calculations in the SQL query vs. in the ...
8
votes
5answers
636 views
Advice for good web server development setup
A month or so ago I created my first LAMP stack and implemented a simple web site that exercised each letter in that acronym. However my development setup was much less than ideal.
I don't really ...
7
votes
4answers
414 views
what is a good way to show mysql experience?
As always, if this is a duplicate question that I have yet to uncover, please feel free to close or delete it.
I'm attempting to get into the programming industry. I've focused mainly on PHP due to ...
7
votes
1answer
184 views
Need help - brainstorming php scheduler class
I've never written a php class before from scratch. But I guess you have to start somewhere right? I've got an idea, but need help with logic. Please tell me what you think. Below is shorthand ...
7
votes
4answers
202 views
OOP design question
I'm working on an application written in PHP using OOP principles. The classes in my application usually represent a table in the database; for instance, 'student', 'teacher', 'class', 'schedule', ...
6
votes
5answers
302 views
Most common website scalability pitfalls
We are designing a website/web application where we hope to to achieve high user counts and, in general, lots of use. More specifically, we intend to be using PHP as the programming/scripting language ...
6
votes
2answers
180 views
How should I organize the words of a sentence for better outputs/maintenance and performance?
Having this sentence (consider many sentences in the future)
David Henderson Houston patented the first roll film for cameras in
1881.
I can make questions like
1. Who patented the roll film?
...
5
votes
1answer
194 views
General approach to re-factoring an large, very badly written legacy system [closed]
Possible Duplicate:
Techniques to re-factor garbage and maintain sanity?
What is a good way to refactor a large, terribly written code base by myself?
Really open question here. I'm not ...
5
votes
3answers
322 views
what are the best tips for storing images in a database?
Is it appropriate to store the image files in the database? Or it would be better to store only the path of the file in the database, while keeping the file itself on the server?
Are there any other ...
5
votes
8answers
222 views
How to (professionally) back up reasons for choosing open source technologies in a large project
I know the title is a bit vague so I'll try to be more precise in explaining what's my actual question (I apologize in advance if this is a duplicate).
I work for a small company (8 people) that ...
5
votes
2answers
509 views
What is the best way to handle different TimeZones?
I'm working on a web application where there will be many different users from all over the world making updates. I'm wondering what the best way to handle timezones would be? Ideally, as an event ...
