PHP/mySQL and VoIP

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
steviechan83
Forum Newbie
Posts: 4
Joined: Mon Jul 31, 2006 11:47 am

PHP/mySQL and VoIP

Post by steviechan83 »

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
User avatar
kbrown3074
Forum Contributor
Posts: 119
Joined: Thu Jul 20, 2006 1:36 pm

Post by kbrown3074 »

asterisk would be on your server side. Do you have a softphone client to connect the call?
steviechan83
Forum Newbie
Posts: 4
Joined: Mon Jul 31, 2006 11:47 am

Softphones

Post by steviechan83 »

I do not have any softphone client yet because I'm not sure how to go about this.

If you have any good links or sites where I can learn how to integrate my php app with any voip software. Please let me know.

Basically, I need to be able to have this so that when the link is clicked a softphone will call the phone number.

Company AYZ, 604-941-2300

Also, I need it to go from the softphone to mysql in order to store the call records.

>> Company AYZ, 604-941-2300, July 31, 2006 10:00 AM, 10 minutes
>> Company AYZ, 604-941-2300, July 30, 2006 10:00 AM, 5 minutes
>> Company AYZ, 604-941-2300, July 29, 2006 10:00 AM, 2 minutes


Are there any voip software available for free or not free that would allow me to do this?

Thanks

Stephen
User avatar
kbrown3074
Forum Contributor
Posts: 119
Joined: Thu Jul 20, 2006 1:36 pm

Post by kbrown3074 »

first off..you running linux or windows? If you are running Windows..look to spend a good amount of money on softphones/licenses. If you are runnin linux..there are quite a few softphone clients out there. How you would integrate them..that Im not really sure. The company I work for uses a predictive dialer(EIS) to make the calls and use a php app to do data capture.

Do you have the asterisk box set up already? Do you have the voip cards that you need? I dont know the full spectrum of getting stuff up for this but I have some clues on what the sysadmins did to set it up.
steviechan83
Forum Newbie
Posts: 4
Joined: Mon Jul 31, 2006 11:47 am

Post by steviechan83 »

Thanks for your reply !

I'm currently running windows and this will be a single-user or two-user application that i need this for.
Do you have the asterisk box set up already? Do you have the voip cards that you need? I dont know the full spectrum of getting stuff up for this but I have some clues on what the sysadmins did to set it up.
I do not have asterisk set up and no VoIP card. I guess I need to do much more research than i thought.

In the beginning i thought somehow i can just make it use an application like "SKYPE" and then somehow capture the call-records.

Thanks for the advice.

Stephen
User avatar
kbrown3074
Forum Contributor
Posts: 119
Joined: Thu Jul 20, 2006 1:36 pm

Post by kbrown3074 »

You gotta integrate the asterisk box with your frontend app somehow. I know my boss is looking into a new way that our agents can work from home and he is looking for a citrix server to run the frontend using desktop images. I know a guy at work got asterisk running fine at home using Linux..not sure how much of a pain it is in Windows.
Post Reply