<?php 

require_once('db_config.php');

function stringToDigits($str) {
	$str = strtolower($str);
	$from = 'abcdefghijklmnopqrstuvwxyz';
	  $to = '22233344455566677778889999';
	return preg_replace('/[^0-9]/', '', strtr($str, $from, $to));
} 

mysql_connect($db_host, $db_user, $db_passwd)
                or die('Could not connect: ' . mysql_error());

mysql_select_db($db_name) or die('Could not select database');

// perform a query to get all unindexed rows
$query = "SELECT extension, lastname FROM people where digit_index is null";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());


//iterate through each row, calculating the index and updating
while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
	$exten = $line['extension'];
	$lastname = $line['lastname'];
	$index = stringToDigits($lastname);
	$query = sprintf("update people set digit_index='%s' where extension='%s'",$index,$exten);
	echo "Indexing extension $exten: $lastname -> $index\n";
	mysql_query($query) or die('Query failed: ' . mysql_error());
}

mysql_close();

?>