regarding whitelist of calls

[mandadi]

Dear All,


I am new to PHP.We have a database table with id,phone number,time of call(Datetime),duration as fields.

It has lots of data. we received many blank calls and fake calls.

My requirement is how to hangup the call from a number which is not in my database.The answer is very urgent for me.

please anybody help me to fix this problem,

Thanks in advance,

Regards,
Swathi.

[bluewalrus]

Not specific enough. Do you have a php script written already that calls people from the numbers in your database, or do you want that, or do you want to log calls coming into your place? Is hangup literal like cancel a phone call, or clear an entry from a list?

[mandadi]

Hello bluealrus,


Thank you for your quick reply,

I didn't write any code for whitelist but i wrote the code for my tollfree number to block the calls which are wrong calls from the front end and those numbers will be updated in the different table.

Now my requirement is i have one database table with phone number,time,duration.
for EX i have 10000 phone numbers in my database i want to hang up or disconnect the call coming from other number out of my 10000 numbers what would i need to write the code to solve this issue.

Thanks in advance,
Regars,
swathi.

[bluewalrus]

Is the incoming phone number a variable already?

[mandadi]

Hello bluewalrus,


For the black list i took the number as $number.

if(isset($_REQUEST['number']))
{
$number=$_REQUEST['number'];
$user_rs=$portal->insertblacklist($extension,$number,$connection);
$db->sql_close();
header("Location: ./tollfree_report.php");
}


function insertblacklist($extension,$number,$con)
{
$sql=new mysql_db();
$this->query="insert into tf_blacklist(number,extension,time) values('$number','$extension',now())";
$this->rs=$sql->query($this->query,$con);
$this->query="update tollfree set blocked='Y' where caller='$number'";
$this->rs=$sql->query($this->query,$con);
return $this->rs;
}


I just want the idea,you can give me the sample code.

This is the code for blaclist.

Thanks and regards,
Swathi.