CallCenter PHP SQL App

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
CallComm
Forum Newbie
Posts: 4
Joined: Sat Feb 14, 2009 10:02 am

CallCenter PHP SQL App

Post by CallComm »

Hi everyone, i wonder if anyone has any ideas for me. Let me explain what im looking for then what i already have set up.

I want my users (Agents) to be able to log into a PHP website (form), click next, receive one row from my SQL database, in which i have already uploaded 5000 leads.

The agent calls the number, then clicks the correct disposition (check box or typed disposition) that info (the original row info) and the new info (disposition) is put back in the same row in the SQL database, then the agent receives the next available row not yet called.

Heres what i have: SQL database with uploaded data, a PHP script able to input info only.

I would like suggestions on what i need to do to get to my goal.

Thanks,
Robert
CallComm
inquisitivedzign
Forum Newbie
Posts: 4
Joined: Sat Mar 28, 2009 9:51 pm

Re: CallCenter PHP SQL App

Post by inquisitivedzign »

As mysqli_fetch_all() returns all the rows as an array in a single step, it may consume more memory than some similar functions such as mysqli_fetch_array(), which only returns one row at a time from the result set. Further, if you need to iterate over the result set, you will need a looping construct that will further impact performance. For these reasons mysqli_fetch_all() should only be used in those situations where the fetched result set will be sent to another layer for processing.

http://us3.php.net/mysqli.mysqlnd

GOOGLE is developers best friend!
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: CallCenter PHP SQL App

Post by josh »

Vonage 3PCC
Post Reply