Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a land phone that displays the caller ID. I want to use a some interface or cable to connect the phone to a pc and then connect it to mysql, check if the user is available in the database, and if not, I add him, (name, number, location)

share|improve this question
    
this question is pretty vague. Any more info ? which phone, which cable, what pbx, etc ? –  Sirex Feb 10 '12 at 11:48
    
@Sirex, I don't know which phone yet, I'll ask the client and tell you, but lets say that you were contacted by a client who want you to create a software for him that displays the numbers of his clients and add clients info, how would you do it? there are phone cables that can be plugged in the pc, the main issue i have is how to connect the phone to mysql or any database whatsoever –  Someone Like You Feb 10 '12 at 11:54
    
@SomeoneLikeYou As Martin Lee said below, you need a card (probably PCIE) that can handle POTS (Sorry - that should read PSTN). I imagine the manufacturer of the card will have some sort of API which you need to then write an application to sit in between the card API and the DB. –  R4D4 Feb 10 '12 at 12:08
    
Most PBX systems let the PBX administrator associate names with numbers and have those displayed on the handset for incoming calls based on incoming caller-ID. The alternative is CTI –  RedGrittyBrick Feb 10 '12 at 12:11
    
@RedGrittyBrick but pbx phone don't tell you the location of the client, he needs the location as well –  Someone Like You Feb 10 '12 at 12:16
add comment

closed as not a real question by Nifle, Simon Sheehan, ChrisF, RedGrittyBrick, Dave M Feb 10 '12 at 13:21

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

up vote 0 down vote accepted

Taking the information from your question, I tend to think that a custom-built system consisting of Asterisk PBX and a custom-written software that can query a MySQL database from Asterisk can help you.

The telephone line that you are going to use should probably support the CallerID functionality.

share|improve this answer
    
does Switchvox do the job? because it says on the page that Switchvox is easier to use than asterisk –  Someone Like You Feb 10 '12 at 12:11
    
Could be, but you need a customizable solution therefore open-source Asterisk might be the best choice. –  Martin Lee Feb 10 '12 at 19:37
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.