Experts, is PHP and MySQL right for my project?

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
Nplaneta
Forum Newbie
Posts: 3
Joined: Tue Dec 21, 2010 9:37 am

Experts, is PHP and MySQL right for my project?

Post by Nplaneta »

I am looking to securely and efficiently take data from an online survey to a database that is compatible with a commonly used statistical software package (e.g. SPSS).

Is PHP the right platform for me to develop the survey on and what kind of database should I write to, MySQL?

Thanks,
Nick
User avatar
Jonah Bron
DevNet Master
Posts: 2764
Joined: Thu Mar 15, 2007 6:28 pm
Location: Redding, California

Re: Experts, is PHP and MySQL right for my project?

Post by Jonah Bron »

Yes, PHP is beyond capable of doing that. And you can use whatever database you want; MySQL is the most popular.
Nplaneta
Forum Newbie
Posts: 3
Joined: Tue Dec 21, 2010 9:37 am

Re: Experts, is PHP and MySQL right for my project?

Post by Nplaneta »

Thanks. Does anyone know if MySQL provides a good input for statistical software packages?
User avatar
Jonah Bron
DevNet Master
Posts: 2764
Joined: Thu Mar 15, 2007 6:28 pm
Location: Redding, California

Re: Experts, is PHP and MySQL right for my project?

Post by Jonah Bron »

Nplaneta wrote:... provides a good input ...
I don't know what that means. Do you mean would it work with statistics software? I suppose, if the software is setup to use MySQL. It's just another relational database...
Nplaneta
Forum Newbie
Posts: 3
Joined: Tue Dec 21, 2010 9:37 am

Re: Experts, is PHP and MySQL right for my project?

Post by Nplaneta »

Jonah Bron wrote:
Nplaneta wrote:... provides a good input ...
I don't know what that means. Do you mean would it work with statistics software? I suppose, if the software is setup to use MySQL. It's just another relational database...
Exactly. That's the piece I'm missing. Does anyone know off-hand if the common statistical software packages (i.e. SPSS, SAS, STATA, etc.) are setup to work with MySQL?
User avatar
Jonah Bron
DevNet Master
Posts: 2764
Joined: Thu Mar 15, 2007 6:28 pm
Location: Redding, California

Re: Experts, is PHP and MySQL right for my project?

Post by Jonah Bron »

I don't know, but :google:
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Experts, is PHP and MySQL right for my project?

Post by califdon »

To reinforce what Jonah said, I merely searched for "spss" in Google and from the Wikipedia article on it I quickly found this sentence:
SPSS can read and write data from ASCII text files (including hierarchical files), other statistics packages, spreadsheets and databases. SPSS can read and write to external relational database tables via ODBC and SQL.
Since MySQL, of course, is a SQL based database, it is suitable, as is Postgres and nearly any other relational database. You can no doubt find similar information on other statistical software by the same method I used.
Post Reply