desiredforsome
asked on
Script for ASterisk phonebook
I found this script online and have my sql setup and all and can verify the user can login and view tables but it will not work.
I am using elastix and when i browse to this page it is just blank,
<?
$URL = 'http://192.168.2.152/';
// Choose how many results to return if search term produces a lot of output
$per_page = '10';
// Change here to match your own passwords
$mysql_conn = mysql_connect('localhost', 'rooot', 'password');
// Dont change anything from here unless you know what you are doing
mysql_select_db('asterisk' , $mysql_conn );
$NAME=$_GET["name"];
$FROM=$_GET["FROM"];
$TO=$_GET["TO"];
if ( ($FROM=='') and ($TO=='') )
{
//check to see how many
$result= mysql_query("SELECT count(users.name) as total
FROM users
WHERE users.name LIKE '%$NAME%' ", $mysql_conn);
$howmany = mysql_fetch_row($result);
if ($howmany[0] > $per_page)
{
$start = 0;
$index = 0;
$total = $howmany[0];
$remain = $per_page;
print("\n");
print("<YealinkIPPhoneDire ctory>\n") ;
while ($start < ($total + 1))
{
$limitstart = 'LIMIT '.$start.','.$per_page;
$result = mysql_query("SELECT name,extension
FROM users
WHERE name LIKE '%$NAME%' ORDER BY name $limitstart", $mysql_conn);
$row = mysql_fetch_row($result);
$from = $row[0];
if (($total - $start) < $per_page) { $remain = $total - $start; }
for ($i = 1; $i < $remain; ++$i) { $row = mysql_fetch_row($result); }
$to = $row[0];
print("<SoftKeyItem>\n");
print("\t<Name>");
print($index);
print("</Name>\n");
print("\t<URL>");
print($URL."search.php?FRO M=".$from. "&TO=".$to );
print("</URL>\n");
print("</SoftKeyItem>\n");
$start = $start + $per_page;
$index = $index+1;
}
print("</YealinkIPPhoneDir ectory>\n" );
} else {
$result = mysql_query("SELECT name,extension,extension
FROM users
WHERE users.name LIKE '%$NAME%'
ORDER BY name ", $mysql_conn);
print("\n");
print("<YealinkIPPhoneDire ctory>\n") ;
while($row = mysql_fetch_row($result))
{
print("<DirectoryEntry>\n" );
print("\t<Name>");
print($row[0]."- ".$row[1] );
print("</Name>\n");
print("\t<Telephone>");
print($row[2]);
print("</Telephone>\n");
print("</DirectoryEntry>\n ");
}
print("</YealinkIPPhoneDir ectory>\n" );
}
} else {
$result = mysql_query("SELECT name,extension,extension
FROM users
WHERE name>='$FROM' AND name<='$TO'
ORDER BY name", $mysql_conn);
print("\n");
print("<YealinkIPPhoneDire ctory>\n") ;
while($row = mysql_fetch_row($result))
{
print("<DirectoryEntry>\n" );
print("\t<Name>");
print($row[0]."- ".$row[1] );
print("</Name>\n");
print("\t<Telephone>");
print($row[2]);
print("</Telephone>\n");
print("</DirectoryEntry>\n ");
}
print("</YealinkIPPhoneDir ectory>\n" );
}
?>
I am using elastix and when i browse to this page it is just blank,
<?
$URL = 'http://192.168.2.152/';
// Choose how many results to return if search term produces a lot of output
$per_page = '10';
// Change here to match your own passwords
$mysql_conn = mysql_connect('localhost',
// Dont change anything from here unless you know what you are doing
mysql_select_db('asterisk'
$NAME=$_GET["name"];
$FROM=$_GET["FROM"];
$TO=$_GET["TO"];
if ( ($FROM=='') and ($TO=='') )
{
//check to see how many
$result= mysql_query("SELECT count(users.name) as total
FROM users
WHERE users.name LIKE '%$NAME%' ", $mysql_conn);
$howmany = mysql_fetch_row($result);
if ($howmany[0] > $per_page)
{
$start = 0;
$index = 0;
$total = $howmany[0];
$remain = $per_page;
print("\n");
print("<YealinkIPPhoneDire
while ($start < ($total + 1))
{
$limitstart = 'LIMIT '.$start.','.$per_page;
$result = mysql_query("SELECT name,extension
FROM users
WHERE name LIKE '%$NAME%' ORDER BY name $limitstart", $mysql_conn);
$row = mysql_fetch_row($result);
$from = $row[0];
if (($total - $start) < $per_page) { $remain = $total - $start; }
for ($i = 1; $i < $remain; ++$i) { $row = mysql_fetch_row($result); }
$to = $row[0];
print("<SoftKeyItem>\n");
print("\t<Name>");
print($index);
print("</Name>\n");
print("\t<URL>");
print($URL."search.php?FRO
print("</URL>\n");
print("</SoftKeyItem>\n");
$start = $start + $per_page;
$index = $index+1;
}
print("</YealinkIPPhoneDir
} else {
$result = mysql_query("SELECT name,extension,extension
FROM users
WHERE users.name LIKE '%$NAME%'
ORDER BY name ", $mysql_conn);
print("\n");
print("<YealinkIPPhoneDire
while($row = mysql_fetch_row($result))
{
print("<DirectoryEntry>\n"
print("\t<Name>");
print($row[0]."- ".$row[1] );
print("</Name>\n");
print("\t<Telephone>");
print($row[2]);
print("</Telephone>\n");
print("</DirectoryEntry>\n
}
print("</YealinkIPPhoneDir
}
} else {
$result = mysql_query("SELECT name,extension,extension
FROM users
WHERE name>='$FROM' AND name<='$TO'
ORDER BY name", $mysql_conn);
print("\n");
print("<YealinkIPPhoneDire
while($row = mysql_fetch_row($result))
{
print("<DirectoryEntry>\n"
print("\t<Name>");
print($row[0]."- ".$row[1] );
print("</Name>\n");
print("\t<Telephone>");
print($row[2]);
print("</Telephone>\n");
print("</DirectoryEntry>\n
}
print("</YealinkIPPhoneDir
}
?>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window
may need to be;
Open in new window