asad_black Posted March 24, 2009 Share Posted March 24, 2009 this is my page : http://jugnoo.tv/category_story.php in which list of videos is exist...! click on the thumbnail video will be started..! now i want to display that how many viewers visit the videos like on youtube and the no. visits shows on that page when after clicking on the thumbnail...! for example i want to display the no. of visits on the following page: http://jugnoo.tv/idpage.php?id=68 i have already database and also want to save no. of visit of individual videos in database...! i have no idea how to do this..! http://jugnoo.tv/idpage.php?id=68 the code of above page in which i want to display the no. of visits..! <table width="100%" cellpadding="0" cellspacing="0" class="playertable" border="0"> <tr> <td bgcolor="#FF9900"> <?php $vid_id = $_GET['id']; $con = mysql_connect("localhost","sample","sample"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("sample", $con); $result = mysql_query("SELECT * FROM links WHERE id =$vid_id"); echo "<table border='0'> <tr valign=top> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr valign=top>"; //echo "<td>" . $row['kw'] . "</td>"; //echo "<td>" . $row['des'] . "</td>"; echo "<td>" . $row['embed'] . "</td>"; echo "<td width='20'></td>"; echo "<td class=ddesc>" . $row['ddes'] . "</td>"; //echo "<td valgin=top >" . $row['text'] . "</td></center>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?></td> </tr> </table> Quote Link to comment Share on other sites More sharing options...
lonewolf217 Posted March 24, 2009 Share Posted March 24, 2009 add a new parameter to the end of your link like &hit=1 if $_GET['hit'] is set, then increment a counter in the database and display the new value if you want to include people who direct link to the video, you can just keep a counter of how many times you run a query for a particular ID Quote Link to comment Share on other sites More sharing options...
asad_black Posted March 25, 2009 Author Share Posted March 25, 2009 thank you so much sir Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.