Man In Tan Posted March 18, 2012 Share Posted March 18, 2012 I know this sounds like a stupid question, but what is the best way to store user input in PHP? I'm a bit late to the database scene. Until now, I've been using flat files, out of ease, but I really need to use something more efficient, if I'm going to develop applications people will want to use. And because I'm developing free software, I need free databases. I also need it to run in non-Windows environments. I've done some research, and PHP supports many types of database software, including several flavors of SQL, which seems to be the most popular. But I'd hate to start working with one, just to need to switch later. What would you recommend, and why? Link to comment Share on other sites More sharing options...
birbal Posted March 18, 2012 Share Posted March 18, 2012 mysql currently is most popular for web based applications which is also supported in unix and windows platform. most of the host support it.sql is general purpose language to query database server. so it should not be trouble to switch it later if you grasp sql once.start with http://php.net/mysqlior more for more compatible databse handling http://php.net/pdo Link to comment Share on other sites More sharing options...
Starfall Posted March 18, 2012 Share Posted March 18, 2012 I don't think you need to care about the type of the database you are programming the webscript for.ADODB for instance, has a system that makes your code work in all kinds of database platforms.But if you want a recommendation for a web database, most websites use MySQL. I'd recommend it. It is simple and comes with home webserver packages like wamp or xampp. Link to comment Share on other sites More sharing options...
Man In Tan Posted March 18, 2012 Author Share Posted March 18, 2012 Alright, thank you to both of you! One last question. I downloaded the latest version from the MySQL website, and tried to install it using these directions: http://0gb.us/?mysqlBut when I got to the configure line ("./configure --prefix=/usr/local/mysql"), I got an error. about no such file existing. I've never had ./configure fail before. Any ideas? Link to comment Share on other sites More sharing options...
boen_robot Posted March 22, 2012 Share Posted March 22, 2012 Compiling is tough... try installing the pre-compiled version with instructions such as these. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.