[PHP/mysql installation package compiler]

Hi,

I have a timesheet php application and would like to demo the application to another client on their machine.

So my question is:

Does anyone have any suggestions on how to create or setup the environment and then deploy the application with just an installer?

myapplication.exe

is there any way to install WAMP and then put my files in the correct directory?


Has anyone ever used Inno Setup to do this? if so can you please give me some advice.

http://www.jrsoftware.org/isinfo.php

Thanks in advance

Stephen

[PHP/MySQL and voIP]

Hi

Does anyone here have experience with creating a php application that could use a voIP application such as asterisk, skype, etc.?

For example,

I have a table with two columns "customers" and "phone numbers".  I'm not sure if this is possible or how to go about it, but I want to make it so that when users click a phone number, the voip application will get invoked and make the call?

Also I would like to store the entire call records into a mysql database.

I've done some research to see which VoIP software I could use.  I found asterisk but I'm not sure if this will integrate well with what I'm trying to accomplish.

Does anyone have any suggestions or concepts?

Thanks

Stephen

---

[How to eliminate words (a-z) in a phone field?]

Well yes i see that validating the input is necessary which I do have in place now.  But I'm trying to clean up an existing customer database where the phone number field has all sorts of weird formats  :(

Thanks for the suggestion though :)

[How to eliminate words (a-z) in a phone field?]

Thanks for all the suggestion and help. 

I found that the first approach is more flexible than the second approach because the second approach cannot handle 1-800-123-1231 numbers

However, with the first approach when i have numbers like (604)192-12312 with no dash.  The regex would not work.  Also cases were there it is "Jan 19;27" would give me 1927.

I'm not familar with regex but I'm learning :) I was wondering how I should go about this?

I tried another regex to specify whether the separator is either a dash space, or a period but this would not work either

$regex = "/
            \(?     # optional parentheses
              \d{3} # 3 Digit
            \)?     # optional parentheses
            [-\s.]? # separator is either a dash, a space, or a period.
              \d{3} # 3 digit
            [-\s.]  # another separator
              \d{4} # 4 digit
           /x";

Thanks

STephen

[How to eliminate words (a-z) in a phone field?]

Hi

I have a field phoneNum and it contains phone numbers in all sort of formats.

xxx-xxx-xxxx
(xxx)-xxx-xxxx
Branch: xxx-xxxx
Plant: xxx-xxxx
xxx-xxxx/?

I would like to change all the phone number to a standard format to XXX-XXX-XXXX.

Could anyone suggest an approach or show me an example? is there some way i can preprocess the data and then store it into another column?

I've thought of using regex or using LIKE CONCAT()?


Also, i'm using PHP 5 and mySQL 4.0.15

Thanks

Stephen