Can anyone give me advice on dealing with checkboxes in PHP, to hand off to SQL. [more inside]
posted by opsin on Jan 30, 2009 - 8 answers

I need a front end for an online database of contacts, the easier the better. [more inside]
posted by sleevener on Oct 5, 2008 - 7 answers

I usually design sites using either plain html/css or Wordpress for its CMS capabilities. However, one client has just asked if there can be a database on his site, which they can add to and visitors/members of the site can purchase "entities" from. This obviously needs a database with a usable front-end for the client and an ability to connect to a payment gateway to purchase "entities". Can anyone help advise on a PHP/MySQL package to do this? I do not have the skills to build a database from scratch (I plan to learn, but cannot do so in the timescales needed for this potential assignment), and I'm presuming there must be a solution out there...
posted by wibbler on Aug 18, 2008 - 4 answers

Which version of PHP should I start to learn, and how? I know HTML and CSS, and intend to build with Drupal (or similar) and its many extensions. [more inside]
posted by prophetsearcher on May 4, 2008 - 12 answers

MySQL sorting issue. When I have "first name" and "last name" columns, and I'm sorting primarily by "last name." Some entries have only a "first name," and rather than have those end up at either the start or end of the sort, I'd like it to pretend the "first name" IS the "last name" and sort accordingly. Is there a way to do this with the SQL SELECT statement or should I just edit the data? [more inside]
posted by dnash on May 2, 2008 - 8 answers

How can I connect to a SQL Server 2005 database using windows authentication with PHP? [more inside]
posted by logic vs love on Mar 20, 2008 - 6 answers

I'm planning on starting a database freelancing business. I understand a lot of people prefer Microsoft Access or FileMaker. With the current evolving trend of applications going on the web and add to that my somewhat good experience with PHP, HTML, Javascript and CSS I'm seeking a cross platform efficient application environment. This is why I believe Access and FileMaker are not an option, I'm also more experienced with high level languages than I am with Access or FileMaker. [more inside]
posted by mrbloo on Mar 13, 2008 - 11 answers

I'm looking for a way to organize a list of members of my neighborhood association, preferably something web-based, but that doesn't require the actual members to log in. [more inside]
posted by epersonae on Feb 11, 2008 - 5 answers

For database usage, is it better to store data in XML or serialized format? In particular, PHP serialization. [more inside]
posted by destro on Jan 18, 2008 - 10 answers

How do I query data from one MySQL table, but I also need to get a single piece of data from a second table too? Should I be doing a JOIN, or a separate query? [more inside]
posted by gramcracker on Jan 7, 2008 - 9 answers

Sum of data for all months, including months with no rows, in MySQL? [more inside]
posted by tmcw on Nov 15, 2007 - 7 answers

WordPressFilter: Can I do something like this site with WordPress? [more inside]
posted by SansPoint on Sep 16, 2007 - 8 answers

How do I make sure a page loads with a fresh copy and not from the users cache? [more inside]
posted by LoopyG on Aug 9, 2007 - 7 answers

What are the best database-driven Web application development frameworks out there right now? More specifically, please orient me to toolsets you know of that are similar to Ruby on Rails. [more inside]
posted by killdevil on Jul 6, 2007 - 17 answers

An 800 item database driven site in PHP and MySQL? Am I crazy? [more inside]
posted by mysterious1der on Mar 1, 2007 - 21 answers

I have been asked to write a database application that will be running in a storefront situation and will allow the user to enter data on what is sold (in this case, bicycles and bicycle accessories and parts) and generate basic bookkeeping reports (i.e. end-of-day sales, quarterly sales, that sort of thing.) [more inside]
posted by evisceratordeath on Dec 20, 2006 - 8 answers

How would you write an application in PHP that tracks multiple users, and the users' multiple sites? [more inside]
posted by gradient on Dec 5, 2006 - 7 answers

Bridging PHP and Python object serialization [more inside]
posted by Blazecock Pileon on Oct 10, 2006 - 7 answers

Are there any free PHP and MySQL based apps for setting up a bootleg trading site? [more inside]
posted by SansPoint on Sep 27, 2006 - 2 answers

MySQL/PHPmyAdmin for a band: How do I easily create a repository of lyrics that can be brought in for multiple albums? [more inside]
posted by Brainy on Jul 17, 2006 - 8 answers

I know how to make database-driven web sites using Windows servers, Access, IIS, and ASP.

I want to learn how to do the same using Linux, Apache, MySQL, PHP, and... whatever you use instead of Access.

Where do I start?
posted by Mwongozi on Dec 10, 2004 - 18 answers

I know, I know -- not another web photogallery AskMe question, but: I've actually settled on the gallery itself. I'm using JAlbum. Having made the choice, though, I'm left with two questions:

1. JAlbum makes nice galleries, but doesn't create a top-level index page. (I could hand-code it, but my wife will be doing most of the updating and I don't want her to have to go mucking around in HTML.) The easiest solution, I'd think, would be just to reformat the directory listing into something attractive -- all I really need to communicate to the user is descriptive folder names and upload dates, but I'd prefer to make something more handsome than the standard Apache page. Can anyone recommend a particular PHP file system manager or other solution?

2. JAlbum's auto upload is ridiculously slow -- better just to FTP it. When JAblum makes a gallery, though, it includes a lot of stuff I'm not using -- icon sets, borders, etc. It's not a ton of space, but I'm going to uploading a lot of these galleries, and it'll add up. Is there a programmatic way I can stop JAlbum from including all this, instead of weeding it out before each upload? (I'm using the BluPlusPlus skin.)
posted by blueshammer on Sep 5, 2004 - 1 answer

I need to set up a database-driven document archive of mostly text files and links. I want the archive to have a tree structure and allow the public to browse it without logging in. I want each file to have a description. I prefer PHP or Perl and need to use it on a shared hosting account. I would think something open source like this would be out there, but I can't find it. Any advice?
posted by johnnydark on Sep 4, 2004 - 2 answers