Tagged Questions
3
votes
1answer
129 views
Technique for multiple users on same datasets
This is more a learning question than coding, but I'm certain it's a common issue for anyone developing administration systems or applications in php/mysql/js etc.
I've developed quite a complex ...
2
votes
1answer
146 views
How can I integrate and store sessions in my database, as opposed to storing them in a cookie and file system?
I've never worked with sessions in a database before, and I'm a little unclear on how they work. I have a user class already designed which stores user information: username, password, email etc. I ...
6
votes
2answers
179 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?
...
4
votes
4answers
346 views
When is it necessary to use ORM tools?
I was raised in a part of web developmentland where the creation of websites is mostly synonymous with Wordpress, FTP, Joomla, and procedural code, instead of things like TDD, A/B testing, Doctrine, ...
5
votes
3answers
321 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 ...
0
votes
1answer
94 views
Looking for an up-to-date PHP Auth script to manage users
I have a client that has a rather generic, but established, website up and running. He now wants to add a simple UserAuth mechanism by which users can register (name,email) and access "member pages". ...
1
vote
2answers
223 views
Is it more efficient to query once for all settings, or query whenever a setting is needed?
For my blog script I have a usergroup and permission system set up. Each user is assigned to a usergroup and I have a long list of permission settings. Both are stored in a MySQL database.
At the ...
0
votes
1answer
55 views
Should I implement functionality for an xml file+schema?
I am working on a script to get data from excel spreadsheets to a database. The data is from surveys conducted by our office where the data comes in with very little formatting. At the moment, the ...
2
votes
1answer
174 views
CMS and Databases vs. DIY
I have been programming for many years now, primarily in PHP and the like and would consider myself an intermediate programmer. Some of my online projects have now gone global and very widely used, i ...
1
vote
5answers
657 views
Does AJAX need to use a server-side language such as PHP/ASP.NET/Java to access a database?
Does AJAX need to use a server-side language such as PHP/ASP.NET/Java to access a database? Or some sort of web service tied to these languages? Or is AJAX able to communicate directly with the ...
2
votes
1answer
218 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 ...
2
votes
4answers
187 views
Advice on making sure e-commerce site is secure using PHP and MySQL
Like the title says, I would like some advice from knowledgable web developers on figuring out security issues for my e-commerce site.
I am designing the database as well as the code that ...
3
votes
2answers
498 views
how facebook calculates mutual friends?
In your opinion, how facebook calculates mutual friends?
Has it cached all mutual friends for each user? Let MySQL calculate through a query? Makes a query to the database and then it calculates the ...
4
votes
3answers
270 views
How do I determine which language/framework is best for our web-based project?
I'm in the early stages of development for a web application that has three developers (myself included) working on it. The project is, at its core, a web-based database that will be used by around ...
1
vote
1answer
53 views
What things should be considered in the license etc when you're using some open source projects/ tools in your application
What things should be considered in the license etc when you're using some open source projects/ tools in your application(in my case, specifically a web application/website) ?
What are the ...