Tagged Questions
12
votes
6answers
1k views
Interacting With Data Using Multiple Databases/Servers
All of the projects that I've had to deal with so far have only required a single database on a single server. I'm interested in learning more about how projects that need to scale move to multiple ...
11
votes
7answers
840 views
How can I get programmers to stop writing code vulnerable to SQL injection?
Sometimes you get busy and delegate small tasks to junior programmers. But if you don't pay close enough attention you find yourself with this kind of code in production:
class DivtoggleController ...
8
votes
6answers
621 views
What kind of Web development projects benefit from using ORM?
I'll start by saying that I've done 95% of my database work using SQL. Recently, I did some investigation of various ORMs, such as NHibernate and Doctrine.
I can see the advantages of not needing to ...
8
votes
4answers
355 views
Should database queries be abstracted out of the page itself?
When writing page generation in PHP, I often find myself writing a set of files littered with database queries. For example, I might have a query to fetch some data about a post directly from the ...
7
votes
1answer
346 views
How to document an algorithm properly with sample data?
I am wondering what should an algorithm documentation contain? Can't locate a proper guideline to follow. I have in mind to include
summary of the algorithm
description of the algorithm
flowcharts
...
5
votes
4answers
854 views
What are the advantages to using SQL query builders?
Are there any advantages to using a query builder, rather than using raw SQL?
E.g.
$q->select('*')
->from('posts')
->innerJoin('terms', 'post_id')
->where(...)
vs:
SELECT * FROM ...
5
votes
1answer
447 views
OpenID implementation - PHP, Javascript, MySQL
I've started doing some research on the technologies that I will need for my website.
I'm trying to implement a really simple website with OpenID user registration. The website will store a block of ...
3
votes
3answers
581 views
Why put SQL statement in a variable before using mysql_query()?
I'm been working with PHP on and off for a bit now, and I've seen plenty of code both ways:
$sql = "SELECT …";
mysql_query($sql);
vs
mysql_query("SELECT…");
Is there a reason for separating the ...
3
votes
2answers
1k views
How can I design a model layer without ORM, and when should I use it?
I'm a PHP developer who started with CodeIgniter. In it, designing models was easy: it seemed like each method defined in models was the equivalent of static methods in a normal, objected-oriented ...
3
votes
7answers
309 views
OOP (php) for beginners - some unclarities
I started reading some tutorials about OOP, because I want to learn the basics.
I have a question about it. I understand how you can have a object "Car" and give it a color like this ...
2
votes
2answers
148 views
Better way to search for text in two columns
Here is the scenario. I am making a custom blogging software for my site. I am implementing a search feature. It's not very sophisticated - basically it just takes the search phrase entered and runs ...
2
votes
1answer
307 views
Which would be a better way to load data via ajax
I am using google maps and returning html/lat/long from my MySQL database
Currently
A user picks a business category e.g; "Video Production".
an ajax call is sent to a CodeIgniter controller
the ...
2
votes
1answer
286 views
Active Record library with support for both SQL and NoSQL?
I'm looking for a PHP Active Record library that supports both SQL and NoSQL drivers (mongodb in particular). It doesn't matter if it actually has the NoSQL driver, I can write it myself, as long as ...
1
vote
2answers
365 views
Registration: Email hash and verifying only one account per email
I'm using a registration function that hashes the email in PBKDF2 with a random and unique Salt each time. The hashes email and his salt are saved in the DB. No problem with that.
The problem is that ...
1
vote
3answers
325 views
PHP ORM style of querying
Ok so I have made an ORM library for PHP. It uses syntax like so:
*(assume that $business_locations is an array)*
Business::type(Business:TYPE_AUTOMOTIVE)->
...
