Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function audioplayer($id)
- {
- $r_hostname = "192.***.**.***";
- $r_username = "c**";
- $r_password = "*******";
- $link = mysql_connect($r_hostname,$r_username,$r_password);
- $a_hostname = "192.168.***.***";
- $db = mysql_select_db('asterisk', $link);
- $result = mysql_query("SELECT * FROM recording_log WHERE start_time LIKE '".date("Y-m-d")."%' AND filename LIKE 'IL_%-%". $id ."' LIMIT 3",$link);
- #$result = mysql_query("select * from recording_log WHERE filename LIKE 'IL_%-%".$id."'",$link);
- if (!$result) {
- die('Invalid query: ' . mysql_error());
- }
- if($result != '')
- {
- while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
- foreach($row as $column => $value) {
- $array[type] ="wav";
- $array[$column]= $value;
- }
- }
- }
- else {
- $linktwo = mysql_connect($a_hostname,$r_username,$r_password);
- $dbtwo = mysql_select_db('asterisk', $linktwo);
- $resulttwo = mysql_query("SELECT * FROM recording_log WHERE start_time LIKE '".date("Y-m-d")."%' AND filename LIKE 'IL_%-%". $id ."' LIMIT 3",$linktwo);
- while($row = mysql_fetch_array($resulttwo, MYSQL_ASSOC)){
- foreach($row as $column => $value) {
- $array[type] ="mp3";
- $array[$column]= $value;
- }
- }
- }
- return json_encode($array);
- }
- $array[type] ="mp3";
- $array[$type] ="mp3";
- $array["type"] ="mp3";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement