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
Experts, is PHP and MySQL right for my project?
Moderator: General Moderators
- 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?
Yes, PHP is beyond capable of doing that. And you can use whatever database you want; MySQL is the most popular.
Re: Experts, is PHP and MySQL right for my project?
Thanks. Does anyone know if MySQL provides a good input for statistical software packages?
- 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?
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 wrote:... provides a good input ...
Re: Experts, is PHP and MySQL right for my project?
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?Jonah Bron wrote: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 wrote:... provides a good input ...
- 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?
I don't know, but 

Re: Experts, is PHP and MySQL right for my project?
To reinforce what Jonah said, I merely searched for "spss" in Google and from the Wikipedia article on it I quickly found this sentence:
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.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.