Customer Log program using PHP MYSQL and a Wiki?

Question

I have 200 customers. "Hopefully that will dramatically increase in a few years" My goal is to create a Wiki that will have a page (profile) for each customer. It will store basic info (address, phone, etc) and will also documents each visit along with a summary of each vist, eg. -

Sept 4, 2006 - Customer was mad
Sept 10, 2006 - Customer was happy
etc.

I have a PHP calendar that I would also like to have on each page of the wiki.

Here are my 2 questions -

1) What is the best Wiki to use for this type of project, where I will be able to intergrate PHP code and has a friendly interface?

2) I want to use MySQL, but until I figure out how I am going to set everything up, I am entering all the data in a Excel spreadsheet. What is the best way to set up the fields in Excel to later on be transferred to a MySQL database, and then be intergrated into the Wiki? For now I just have - "Visit Date 1, Visit Notes 1, Visit Date 2, Visit Notes 2,....."

I am eager to get this Wiki built, but for now, I need to know that the data I am collecting everyday is being put in the proper format.

Answer 1

At work we use Tiki Wiki. Tikiwiki is a full featured Free Software (GNU/LGPL) Wiki/CMS/Groupware written in PHP
and maintained by an active and international community of benevolent contributors.

http://tikiwiki.org/Download

They also have info on using MySql at
http://tikiwiki.org/tiki-index.php?page=InstallDatabaseAdmin&highlight=mysql

Answer 2

Repying to dhvrm's comment. You should not use mysql_pconnect instead of mysql_connect. mysql_pconnect causes apache to create a new and constant connect to mysql the entire time the user is on your website. It will increase server and database load. You should connect to the database and release it as soon as you’re done. Plus, If you have limited mysql to only 50 connects this means only 50 people could use your website at once. Instead of 50 connections to the database at once.