95 posts tagged with PHP and mysql (View popular tags)

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

How can I migrate PHPBB3 to BBPress? [more inside]
posted on Sep 22, 2008 - 0 answers

Looking for a new webhost, with PHP and MySQL [more inside]
posted on Sep 9, 2008 - 24 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 on Aug 18, 2008 - 4 answers

Is there a simple PHP/MYSQL commenting system available anywhere on the internets? The Google has failed me. [more inside]
posted on Aug 15, 2008 - 11 answers

How does web scraping work with PHP/mySQL? What best practices are there? [more inside]
posted on Aug 6, 2008 - 15 answers

CodeFilter: I am looking for online classes mainly in the area of web programming (PHP, MySQL, AJAX, etc.). [more inside]
posted on Jul 24, 2008 - 3 answers

I'm a tech for a school district. One of my high schools was hit by lightning. The computer that my faculty uses to clock in every day (a windows 95 machine) died. I need a replacement ASAP. [more inside]
posted on Jul 21, 2008 - 6 answers

After working in a mostly LAMP (Linux, Apache, MySQL, PHP) environment the last few years, I need to make a quick switch to WISA (Windows, IIS, MS SQL, ASP). [more inside]
posted on May 18, 2008 - 6 answers

Suggest an offline booking system, no wait... Suggest a one-click WAMP solution, no wait... Flash and flat files mebbe? [more inside]
posted on May 17, 2008 - 1 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 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 on May 2, 2008 - 8 answers

Moving an Excel spreadsheet schedule into MySQL/PHP [more inside]
posted on Apr 28, 2008 - 4 answers

I'm trying to run a MySQL query that returns rows in order by a value stored in a string (but it will also include the non-matching strings). This is not as easy as I would hope. Code inside! [more inside]
posted on Apr 9, 2008 - 15 answers

How can I put a login box on every page of my website? [more inside]
posted on Feb 25, 2008 - 5 answers

URLs with ampersands (&) screwing up my website database calls. [more inside]
posted on Jan 23, 2008 - 7 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 on Jan 7, 2008 - 9 answers

WorpressFilter Blog gone blank, Admin section is fine - help ! [more inside]
posted on Jan 6, 2008 - 8 answers

MediaWiki install: Apache, MySQL, & PHP already on my machine? [more inside]
posted on Jan 4, 2008 - 5 answers

Hi, I would like some recommendations for (preferably open source or inexpensive) web based software that I can implement for my church. Everyone takes turns bringing refreshments, playing songs, etc... and there are waaaaay too many "Who can do it on Sunday the 16th? on Sunday the 26th?" e-mails going around and it gets very confusing to keep track. [more inside]
posted on Dec 12, 2007 - 10 answers

I've been trying to get a 600 record Excel database into MySQL, and failed at every turn. There must be a way! [more inside]
posted on Dec 5, 2007 - 14 answers

MySQL monster query is timing out. Anything I can do about it? (Long question, possible a cure for insomnia.) [more inside]
posted on Nov 19, 2007 - 16 answers

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

I'm after a PHP+MySQL app along the lines of Dell's Idea Storm site. [more inside]
posted on Oct 26, 2007 - 4 answers

I have an idea for yet another hairbrained social networking website (which paradoxically might hit it big :-) ). I've coded most of it up on a linux server using apache, php, mysql at softlayer.com. The hostname is registered at godaddy (which I can change if desirable). What's the minimum I need to do the following (I'd rather work on the website application logic and learn as little as possible about mail server administration for now): [more inside]
posted on Oct 23, 2007 - 8 answers

I've got the skills and knowledge, mostly, but I'd like to get a better workflow with PHP/MySQL development. [more inside]
posted on Oct 11, 2007 - 15 answers

How do I pass this password in the correct form to MySQL? [more inside]
posted on Sep 29, 2007 - 12 answers

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

Without access to PHP, MySQL, or any other fancy server-side stuff I still need to have dynamic pages. What are my options? [more inside]
posted on Sep 12, 2007 - 11 answers

PHP/TransactionFilter: Designing a web application where users will have actual monetary accounts. What is the best way to approach this? [more inside]
posted on Sep 10, 2007 - 8 answers

I am going to be creating a website that tracks events, and I'd like the user experience to be easy and configurable. Can you recommend an event management software? [more inside]
posted on Sep 6, 2007 - 1 answers

From two MySQL tables, I need to fetch a list of customers who DOES NOT have an invoice issued to them within the past 2 months. More details about the table structures inside. [more inside]
posted on Sep 3, 2007 - 10 answers

How to do separation of public and private data on the web with PHP/MySQL? I'm creating a website for a business, with 2 sections - public and admin (staff). The admin section is secured with .htaccess and is intended to be used by office staff to enter customer requirements as they come in, and edit product listings. However, I worry about the security and suspect there is probably a better way. [more inside]
posted on Aug 28, 2007 - 8 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 on Jul 6, 2007 - 17 answers

MySQL, PHPMyAdmin and XML imports/export problem... [more inside]
posted on Jun 22, 2007 - 10 answers

Why doesn't this code from O'Reilly's PHP and MySQL work for me? [more inside]
posted on Jun 16, 2007 - 16 answers

How do I put html form field values into a MySQL database and create the field if it doesn't exist, without declaring or manually updating every single variable? [more inside]
posted on May 12, 2007 - 14 answers

Rather than updating the entire table every time a user updates a form (their profile page, for instance), I'd like the quickest way to detect ONLY the edited fields, and update those accordingly. [more inside]
posted on May 10, 2007 - 13 answers

GoDaddy hosting has become intolerably slow: is it certainly their fault? If so, can I do anything about it? If it isn't their fault, what am I doing wrong? [more inside]
posted on Mar 29, 2007 - 9 answers

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

Programmers block: I have a table in my database. It has events that occurred and the unix time stamp (seconds since the unix epoch) stored in it. I can't decide on the most efficient way (or even if there is one) to list the dates on which events have been recorded. [more inside]
posted on Jan 24, 2007 - 3 answers

There are so many ideas I can think of for websites, but don't have the full skills (or time to learn the skills) to generate the Php/Mysql code and interaction. Is there a good application that can create the coding and website for me, if I give it the right information?
posted on Jan 13, 2007 - 11 answers

PHPfilter- I need to select several records from a MySQL db, based on their audto_increment id in the db. I know the numbers, but for some (stupid for sure) reason I can't get it to pull the records. [more inside]
posted on Jan 7, 2007 - 6 answers

What web technology/language should I learn to make simple online apps and just generally enhance my bare-bones knowledge of HTML? [more inside]
posted on Dec 10, 2006 - 18 answers

How can I strip the seconds off when displaying a MYSQL datetime variable, using only PHP commands, not MYSQL commands like "DATE_FORMAT"? [more inside]
posted on Nov 28, 2006 - 14 answers

Recommendations for a book to teach myself php and MySQL? [more inside]
posted on Nov 20, 2006 - 8 answers

I need a PHP script "generator" to do Change/add/delete/edit on a MySQL database. Is there a auto generator of such a script? (I use 1&1 - with ssh and a shell, and a XP machine at home) Thanks!
posted on Oct 22, 2006 - 8 answers

Now that I'm getting familiar with PHP and MySQL et al, what should I add to my portfolio to make myself hirable? [more inside]
posted on Oct 20, 2006 - 4 answers

I'm writing a php/mySQL script to create new records in my GOALS table by comparing all possible combinations of one or more records from my EXPENSES table with information pulled from my ACCOUNTS table. The actual comparison and record generation should prove relatively simple, but the 'all possible combinations' bit is kicking my butt. I simply cannot fathom a control structure that will facilitate that requirement. [more inside]
posted on Oct 10, 2006 - 9 answers

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

Help me improve my PHP and MySQL skills with useful resources on the web. [more inside]
posted on Sep 25, 2006 - 10 answers

What is the best strategy to limit using processing resources in doing a zip code radius query? (explained inside) [more inside]
posted on Aug 28, 2006 - 12 answers

About to create a PHP/MySQL CMS and web site for a client entirely in Japanese, what do I need to know? [more inside]
posted on Aug 28, 2006 - 7 answers

I am getting spam to addresses picked up from a PHP mail script - can I stop this? [more inside]
posted on Aug 20, 2006 - 13 answers

I need some PHP/MySQL forum software with certain features. [more inside]
posted on Aug 13, 2006 - 5 answers

Through a mutual friend, I've been approached to develop the back end of a website. My compensation for my work will be a percentage of the profits this website brings in. I have no idea what percentage to ask for, or what's fair. [more inside]
posted on Jul 22, 2006 - 15 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 on Jul 17, 2006 - 8 answers

MysqlFilter: I need someone with mighty mysql-Fu to help me out here. I have a list of items stored in my database (60 or so per user), they get sent to the flash application that I have, then once the user is done with everything, they press "save" (20 to 60 times a day), and it saves the list of items back to the database. I was doing an insert on duplicate update, but this doesnt get rid of the items that may have been deleted. [more inside]
posted on Jul 7, 2006 - 10 answers

Are PHP/mySQL applications inherently insecure and unstable? [more inside]
posted on Jun 22, 2006 - 18 answers

I'm useless at self-directed book learning, and I'm desperate to add PHP/MySQL to my skillset. I've found this class at PCC, but I'd like to hear if folks know about other classes in the Portland, Oregon area, especially if you know a good one.
posted on Jun 5, 2006 - 7 answers

DBAs: Is this a case where I *should not* normalize my database? (PHP/MySQL 4.0.24 question). Long explanation of the situation inside. [more inside]
posted on Apr 27, 2006 - 25 answers

I'm looking for a something (php/mysql) that will help me build a simple database driven website. The CMS i've seen and used (such as drupal, post nuke) seem like overkill. [more inside]
posted on Apr 25, 2006 - 11 answers

Database experts: I'm setting up a tagging system for a site I run. What's the most efficient way to go about it? [more inside]
posted on Apr 24, 2006 - 11 answers

I'm writing a small app to store my contacts. There's a little tool to search for names. When I search for "Jo", the results should display all names starting with "jo", followed by those with "jo" in the middle: 1. Joanna 2. John 3. Jonathan 4. Marjorie 5. Mojo How do I do this using a single SQL statement?
posted on Mar 9, 2006 - 14 answers

I'm looking for some sort of Web-Based-Mail system that I can install on my server that I would be able to interface through PHP or Ruby. [more inside]
posted on Feb 7, 2006 - 7 answers

WebDevFilter: ™, ', and ' walk into my database, but only ô, ë, and í come back out. [more inside]
posted on Nov 28, 2005 - 12 answers

I want to learn PHP and MySQL. I just installed both onto my Mac OS 10.4.2 machine to serve as a sort of testing ground. I also downloaded CocoaMySQL. It's asking for a host, user and password. I assume the host is localhost. However, I can't figure out how to create a user. Can anybody help with that? Also, what would you recommend as the best learning resources for somebody who can get around HTML and CSS, but has very little programming experience?
posted on Sep 30, 2005 - 8 answers

SoftwareFilter: Need a portal / groupware or CMS solution with the following features: [more inside]
posted on Aug 25, 2005 - 14 answers

Half way through a form, a user decides that they'd like to add a category to a selection list. How can I facilitate this without also losing everything they've typed into the form so far? [more inside]
posted on Aug 24, 2005 - 17 answers

I am tasked with writing a web-based accounting software in PHP-MySQL. My background in accounting is minimal. I understand enough of debits & credits & transactions and such, but I'd like to find some resources which could help me in working out the programming workflow, database relationships, etc, ie the technical parts of developing such a system.
posted on Aug 6, 2005 - 14 answers

Does any one know how to find the most common result for a column returned from a mysql select request?
posted on Jul 28, 2005 - 6 answers

Can anybody recommend a good, free, preferably open source php-mysql contact management web application I can install on my own server?
posted on Jul 25, 2005 - 14 answers

Heh. I am in the strange position of being far more capable of managing Unix/Linux/OS X than I am Windows XP, and, for development purposes, I'd like to install WordPress on my Windows box. [more inside]
posted on Jun 6, 2005 - 4 answers

Can you recommend a good, free, PHP/MySQL search script I can add to a web site? [more inside]
posted on Apr 7, 2005 - 10 answers

How should I keep data encrypted in my database? (php, mysql help) [more inside]
posted on Mar 23, 2005 - 10 answers

Free server-oriented Linux distribution with GUI config tools? [more inside]
posted on Mar 21, 2005 - 4 answers

My fiancée and I are currently in the thick of planning our August wedding. Is there something like Basecamp that I can install on my home server to help us keep track of the thousand-and-one-details? [more inside]
posted on Mar 13, 2005 - 8 answers

I need to convert several dynamic websites (database driven and templated) into static ones so that they can put on a CD. [more inside]
posted on Feb 24, 2005 - 13 answers

What's the best way to ensure 99.999% service of a MySQL server? I'm looking for information on best practices for redundancy, and what the best way to acheive hot-failover would be ... or if it's better to use a cluster. [more inside]
posted on Feb 22, 2005 - 7 answers

Is there a script (perl or php, no MySQL because I don't understand it and don't want to learn it) that password-protects a webpage so that it can be viewed only by someone who logs in with a username and a password, and also logs that user, so that you can have a record (very important) of who's viewed the page? If so, where can I get me one?
posted on Jan 26, 2005 - 11 answers

Looking for solid, basic client extranet tools... [+]
posted on Jan 25, 2005 - 13 answers

I'm developing a form Adobe Acrobat which, when submitting, calls a php script, which performs an INSERT into a MySQL database, then comes back with a "Thank you" web page. The script is called just fine and the INSERT works, but the browser hangs on the Thank You page. [more inside]
posted on Jan 6, 2005 - 4 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 on Dec 10, 2004 - 18 answers

Php / MySql question. [MI]
posted on Dec 9, 2004 - 15 answers

MySQL, Apache, and PHP:
I can pull a phpinfo and it says that both mysql and dbx functions are compiled in and enabled, but when I run mysql_connect or dbx_connect, it can't connect. Apache and PHP work together and I can get into MySQL and do stuff via client. How can I make them talk when everything else I have says that they should already be talking?
posted on Nov 15, 2004 - 17 answers

I need a package to facilitate collaboration among a group of people spread across the Internet/globe. Ideally it would track staff, projects, to-do lists and contacts. Open source (PHP/mySQL) would be ideal. Any suggestions?
posted on Nov 4, 2004 - 11 answers

myPHPadmin : I'm trying to get it to run an line of MySQL and it's complaining. Anyone got any thoughts? [MI]
posted on Nov 4, 2004 - 9 answers

PHP / MySQL Q: Is there anywhere I can get a script that will scan the contents of a page when it loads and replace a certain value with a string of text? {more}
posted on Oct 4, 2004 - 10 answers

I build a lot of "community" sites - that is, not web communities, but websites that support specific communities. So I'm hunting around for a good set of decent and free PHP/MySQL scripts to do the sorts of things these communities often demand. Now up? A public events calendar and classified ads. AskMeFi has helped before, so hat in hand, I come back to the well hoping for more. [More Inside]
posted on Aug 6, 2004 - 3 answers

GeekLearningFilter: I need to learn how to do some fun stuff with php and MySQL or PostgreSQL. Of course I shall expand on this within...
posted on Jul 19, 2004 - 6 answers

What's your favorite WAMP installer? (and, of course ,why?)
posted on Jul 19, 2004 - 4 answers

I've been fascinated for a while with stiff like tradesports.com and the ill-fated DARPA terrorism futures market, and got to thinking about building a fake, toy futures market. There are systems out there that simulate markets, but they're either simple portfolio charters or they have randomly wobbling shares. I'm much more interested in valuations created by groups of users gaming on the outcome of real events.

Ideally, as I'm very lazy, someone will have written one of these already, but I've googled away and had no joy. It could be me not knowing the lingo used to describe these things.

Failing this can anybody recommend a framework to work within? I'm thinking of something (probably the usual php/mysql) with e-mail/users/password recovery etc. built in for me to start from. Maybe the toy market would be best developed as a plug in to something?
posted on Mar 28, 2004 - 6 answers

I have been looking at changing my web development focus from Windows/ASP/.NET to LAMP(Linux, Apache, MySQL, PHP/Python/Perl) because my gut is telling me that this is where things are going. Oh, Java should be in there as well.

What's the skinny on LAMP in the real world (Netcraft surveys aside)? Is it difficult to change to LAMP/Java? Is the open source thing really sticking?
posted on Jan 9, 2004 - 14 answers

I'm interested in filling out my workday learning perl, php and mysql at my own speed. I have no programming background. Anybody have any good experiences with any online courses, or any other advice? Money is not an object, what is important is good structure (logical progression of concepts) and the ability to get personalized help when needed.
posted on Dec 17, 2003 - 25 answers

I'm new to Mac OS X's command line and a little nervous about using it to install Mysql. After doing some research on the net I found what might be an alternative: installing Apache2, PHP4 and Mysql from Server Logistics . The post claims that by also installing one of the Barebones text editors and Tinkertool I could avoid having to use the command line altogether. It was also suggested that the Server Logistics Complete Packages are more powerful versions of Apache and Php than apple ships (I'm on Panther). Has anyone done an install this way? Any other suggestions? Should I just get over it and use the damn command line?
posted on Dec 16, 2003 - 13 answers