Can I run PHP/MySQL from my desktop? - GoFuckYourself.com

96ukssob · 10-31-2011, 12:05 PM

Im tired of trying to cram shit into Excel and a much easier option is to dump everything into MySQL and run a few PHP scripts to output what I need.

I don't have M$ Access as that would be another, maybe easier solution, but besides running PHP/MySQL is there a better option? How hard would it be to set this up?

Inter-Sex · 10-31-2011, 12:07 PM

http://www.apachefriends.org/en/xampp.html

Serge Litehead · 10-31-2011, 12:08 PM

been running mysql/apache/php locally on windows for a long time now, back in days it was rather complicated to set it up, now you just click install and everything installs most of time without any need to troubleshoot, easily.

WarChild · 10-31-2011, 12:10 PM

Another option you might consider is MS SQL Server Express. It's free.

Value · 10-31-2011, 12:21 PM

Here's the portable version of the xampp
http://portableapps.com/apps/development/xampp

fris · 10-31-2011, 12:33 PM

apache friends is your friend

KickAssJesse · 10-31-2011, 12:34 PM

You can install MAMP for Mac or WAMP for Windows.

Horny Dude · 10-31-2011, 12:41 PM

Way better to develope locally then upload everything when ur done. Do a search for WAMP programs, plenty of cool free ones

nation-x · 10-31-2011, 12:43 PM

I prefer Zend Server

Why · 10-31-2011, 01:56 PM

run ubuntu in a virtual machine, it will be easier to port your code over to a linux box... dont run xamp under windows unless you have to.

BSleazy · 10-31-2011, 02:00 PM

You could always use the database program in Open Office, which is free.

blazin · 10-31-2011, 02:05 PM

Quote:

Originally Posted by Why

run ubuntu in a virtual machine, it will be easier to port your code over to a linux box... dont run xamp under windows unless you have to.

I would recommend this normally but seems like an overkill for what he needs. I would just install the windows version of mysql and then get yourself a good mysql client.

raymor · 10-31-2011, 02:16 PM

All of our desktops have MySQL installed right along with the rest of the system. Put in the OS disk, point it to our kickstart file, and come back 45 minutes later to a complete system with Apache, mysql, Firefox, OpenOffice, everything we need. I guess with Windows you have to install one thing at a time though.

Seriously once you're at the point where whipping out a quick PHP script is easier than clicking dozens and dozens of buttons, that's about the time to seriously consider Linux on the desktop.

Klen · 10-31-2011, 02:57 PM

Xampp is some kind of standard for running php/mysql on desktop,dont see point bothering with anything else.

Tempest · 10-31-2011, 03:10 PM

Quote:

Originally Posted by bossku69

Im tired of trying to cram shit into Excel and a much easier option is to dump everything into MySQL and run a few PHP scripts to output what I need.

I don't have M$ Access as that would be another, maybe easier solution, but besides running PHP/MySQL is there a better option? How hard would it be to set this up?

Running PHP, MySQL on your own system is great for running lots of private scripts and also for having dev versions of your sites on your system. Setting it all up individually can be a bit of a pain unless you're technically inclined.. PHP in particular.. So go with xampp for a much simpler install.

Another option in terms of the DB part, would be to setup the DB on one of your servers and then just access it via php from your desktop. That way, assuming your server gets backed up, your "personal" data will also get backed up. Could also just run your scripts on the server itself. That way you have access it to it from any computer system anywhere as opposed to just from home.

Chosen · 10-31-2011, 03:34 PM

Of course you can

10-31-2011, 12:05 PM	#1
96ukssob So Fucking Banananananas Industry Role: Join Date: Mar 2003 Location: If I was in your ass you'd know it Posts: 12,991	Can I run PHP/MySQL from my desktop? Im tired of trying to cram shit into Excel and a much easier option is to dump everything into MySQL and run a few PHP scripts to output what I need. I don't have M$ Access as that would be another, maybe easier solution, but besides running PHP/MySQL is there a better option? How hard would it be to set this up? __________________ Email: Clicky on Me

10-31-2011, 12:08 PM	#3
Serge Litehead Confirmed User Industry Role: Join Date: Dec 2002 Location: Behind the scenes Posts: 5,190	been running mysql/apache/php locally on windows for a long time now, back in days it was rather complicated to set it up, now you just click install and everything installs most of time without any need to troubleshoot, easily. __________________ SilverCrocodile.com Adult web design since '05

10-31-2011, 12:10 PM	#4
WarChild Let slip the dogs of war. Industry Role: Join Date: Jan 2003 Location: Bermuda Posts: 17,263	Another option you might consider is MS SQL Server Express. It's free. __________________ .

10-31-2011, 12:33 PM	#6
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,359	apache friends is your friend __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

10-31-2011, 12:34 PM	#7
KickAssJesse Confirmed User Industry Role: Join Date: Jul 2008 Location: Los Angeles Posts: 942	You can install MAMP for Mac or WAMP for Windows. __________________ Contact - email: jesse~AT~atkcash~DOT~com - Skype: kickassjesse - ICQ: 386185547 ATK Cash $$$

10-31-2011, 12:07 PM	#2
Inter-Sex Confirmed User Industry Role: Join Date: Nov 2005 Location: Spain :) Posts: 2,231	http://www.apachefriends.org/en/xampp.html

10-31-2011, 12:21 PM	#5
Value Confirmed User Join Date: Feb 2010 Posts: 116	Here's the portable version of the xampp http://portableapps.com/apps/development/xampp

10-31-2011, 12:41 PM	#8
Horny Dude Earn enough to buy coffee Industry Role: Join Date: May 2002 Location: San Diego, Ca. Posts: 4,912	Way better to develope locally then upload everything when ur done. Do a search for WAMP programs, plenty of cool free ones __________________

10-31-2011, 12:43 PM	#9
nation-x Confirmed User Industry Role: Join Date: Mar 2004 Location: Rock Hill, SC Posts: 5,370	I prefer Zend Server

10-31-2011, 01:56 PM	#10
Why MFBA Industry Role: Join Date: Mar 2003 Location: PNW Posts: 7,230	run ubuntu in a virtual machine, it will be easier to port your code over to a linux box... dont run xamp under windows unless you have to.

10-31-2011, 02:00 PM	#11
BSleazy Confirmed User Industry Role: Join Date: Aug 2002 Location: USA Posts: 6,721	You could always use the database program in Open Office, which is free. __________________ icq 156131086

10-31-2011, 02:16 PM	#13
raymor Confirmed User Join Date: Oct 2002 Posts: 3,745	All of our desktops have MySQL installed right along with the rest of the system. Put in the OS disk, point it to our kickstart file, and come back 45 minutes later to a complete system with Apache, mysql, Firefox, OpenOffice, everything we need. I guess with Windows you have to install one thing at a time though. Seriously once you're at the point where whipping out a quick PHP script is easier than clicking dozens and dozens of buttons, that's about the time to seriously consider Linux on the desktop. Last edited by raymor; 10-31-2011 at 02:19 PM..

10-31-2011, 02:57 PM	#14
Klen Industry Role: Join Date: Aug 2006 Location: Little Vienna Posts: 32,235	Xampp is some kind of standard for running php/mysql on desktop,dont see point bothering with anything else.

10-31-2011, 03:34 PM	#16
Chosen VIPPay.com \| AdultWebSponsors.com Industry Role: Join Date: Aug 2001 Posts: 63,151	Of course you can