I have installed the latest Apache and PHP and both are working properly. But now I am having problems with the MySQL database. I don’t know the steps to configure PHP to work with it. I followed the documentation at php.net but I think I am doing something wrong, that’s why it is not working. Please don’t tell me to download a bundled software that includes all three(Apache, PHP and MySQL). I just want to “try” all three seperately.
- Managing Spam via IMAP
- Computer Virus On My Computer- Never!
- How To Determine The Origin Of Spam?
- 2008: Major Concerns for Network and Systems Administrators
- Spam Filtering
- How Anti Spam Software Works
- How Bayesian Spam Filters Work
- Google’s Tag To Remove Content Spamming
- What is the Point of Do-follow Links on Blogs?
- MBR_CHECKSUM_MISMATCH Hard Drive Error and Recovery
If you want to create a website that is driven through a database, and taking data from that database on a regular basis to display pages, then you first need to work out which database solution to use.
A popular combination used by many is mySQL.
If you have your own server then you’ll need to install this, however if you use shared hosting services or providers then the case will probably be that it is already on your server or can be installed.
Once that is done, you should upload something called PhpMyAdmin to the server, as this will easily enable you to create and manage your tables.
Once the infrastructure is up and running, you need to create your tables which can be done without any commands through the PhpMyAdmin interface.
In terms of creating your site itself, you will then need to use simple queries to take data out of the database and if necessary put data back into the database.
In order to learn how to do this there is no substitute for buying a simple book on the subject, or alternatively reading some of the clear and excellent online tutorials.
Depending on the operating system version, the web server software and version, the mySQL DB version, you will have different requirements.
Attached to various links both on mySQL and PHP for Windows and Linux/Unix installations.
well in order to get the php to function with the MySQL you need to enable the the MySQL .dll in your php.ini Goto your php program and open the php.ini file. Search for the following two lines
;extension=php_mysql.dll
;extension=php_mysqli.dll
delete the ; from in front of them both so they look like
extension=php_mysql.dll
extension=php_mysqli.dll
that should enable them to work with the mysql commands in php. Hope that works for ya…