streaming audio files in webserver using php
Posted: Mon Apr 19, 2010 8:02 am
Hey guys, I am trying to develop a web app. What it does is, we have a HTML page set up which allows our clients to log-in to their account. When we communicate with our clients we leave our audio files (generally our meeting agenda) to their account, so they can listen to it in windows media player without allowing them to download the file from our server.
My main page looks something like :
What I am trying to do now is create a unique URL for audio file for each client, and the URL is valid for 10 days. After that the URL is invalid and they cant listen to that audio file. How can I do that?
Here is my approach, but I think I need to add some more code. Could you please guide me
Here is my checklogin.php file :
help will be appreciated. Thanks,
newbee_phper
My main page looks something like :
Code: Select all
<html>
<body>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form name="form1" method="post" action="checklogin.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3"><strong>Member Login </strong></td>
</tr>
<tr>
<td width="78">Username</td>
<td width="6">:</td>
<td width="294"><input name="myusername" type="text" id="myusername"></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input type = "password" name="mypassword" type="text" id="mypassword"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Login"></td>
</tr>
</table>
</td>
</form>
</tr>
</table>
</body>
</html>
Here is my approach, but I think I need to add some more code. Could you please guide me
Here is my checklogin.php file :
Code: Select all
<?php
$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="members"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
// To protect MySQL injection.
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1)
{
// Register $myusername, $mypassword and redirect to file "successful_login.php"
session_register("myusername");
session_register("mypassword");
$file = "/message.wma"; // location of the message
$ maxtime = "1209600"; // valid for 2 weeks
$timeCheck = date('U');
if ($timeCheck >= $maxtime)
{
printf<a href = "http://www.domain.com/test.html"><audio src = "http://www.domain.com/allmessage">
</audio></a>
// I am planning to embed the below code in test.html page!
<embed type="application/x-mplayer2" pluginspage="http://www.microsoft.com/Windows/MediaPlayer/" name="mediaplayer1"
ShowStatusBar="true" EnableContextMenu="false" autostart="false" width="320" height="240" loop="false" src="<?PHP echo
$file ?>" />
}
}
else
{
echo "Wrong Username or Password";
}
?>newbee_phper