I Want A Php Code To Display The Most Popular...

free web hosting
Open Discussion > CONTRIBUTE > Computers > Programming Languages > PHP Programming

I Want A Php Code To Display The Most Popular...

XtremeGamer99
I want a PHP code to display the most popular clicks/links on certain pages.

Can anyone help?

Reply

virrey
you need to create a counter database for each url
in your site
increment each time (using php)
then create the stats

Reply

whatknows
virrey is right on. Think about added code to the top of each of the pages you wish to track. The query could insert $PHP_SELF into a page column, giving you a row for each page load.

Alternately you could set up another field as "hits" and then do a query to see if a row for that page is already in the database. If it is, use UPDATE, if not, INSERT.

Eventually when MySQL 4.1 goes from Gamma release to General, you will be able to use "INSERT... ON DUPLICATE KEY SET..." which will let the database decide whether to update or insert.

Reply

jordanliuhao
You need a counter to track the clicks.

There are 3 ways to do this.

One is shared memory. Reference http://ca.php.net/manual/en/function.shm-attach.php

One is files. You track the count in your file. Be care of the synchronize problem.
the process should be:

<?
fopen()
flock(LOCK_EX)
fread()
count++
fwrite()
flock(LOCK_UN)
fclose()

?>

One is database. You save the click to database.


QUOTE(XtremeGamer99 @ Sep 21 2004, 02:32 PM)
I want a PHP code to display the most popular clicks/links on certain pages.

Can anyone help?
*


Reply

FaLgoR
QUOTE
you need to create a counter database for each url
in your site
increment each time (using php)
then create the stats

or, in the full code, it will be just like this:

create an database table whit the following rows:
-id
-name
-clicks

and an page called link.php:

CODE
<?
mysql_connect("localhost","user","password");
mysql_select_db("databasename");

if(!$ref) // if area hadn't be specified
die("You didn't specified an area!");

$ref = stripslashes($ref); // security reason

mysql_query("UPDATE table SET clicks=(clicks+1) WHERE name='$ref';");

include("$ref.htm"); // include the real page
?>


Now, you just need to fill the database with your areas and change all links. If the link was games.htm, it will be link.php?ref=games
That's all :] if the script doesn't run, post again and I'll fix the problems.

 

 

 


Reply

FaLgoR
i've forgot... just completing.
to display the most popular in tables, just write this code:

show.php

CODE

<?
// don't forget to connect with database
?>
<table border="0">
<tr>
<td>Area</td>
<td>Clicks</td>
</tr>
<?
$query = mysql_query("SELECT * FROM table ODER BY clicks LIMIT 5;"); // if you want to show 10 most popular, change 5 for 10, or if you want the 15 more, change for 15... blah blah blah

while($most = mysql_fetch_array($query)){
?>
<tr>
<td><?=$most[name]?></td>
<td><?=$most[clicks]?></td>
</tr>
<?
}
?>
</table>


that's all! You know, if this script doesn't run, post here and I'll fix it. And don't forget to conect whit the database in the top of this page. If u don't know how, just look at my other post. There is an example. I hope I've helped you! \_

Reply

alexwhin
FaLgoR thanx for the tip man that will be very useful

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.

Recent Queries:-
  1. php select * from oder - 930.99 hr back. (1)
Similar Topics

Keywords : php code display popular

  1. How do you test your php code - (80)
    We know that php is a server side scripting language. So we will need a server with the php parser
    to parse/test our code. How are you doing that. Do you upload it to a server for testing or did you
    instal php and the server (apache) on your computer (localhost)...
  2. How To Display Images Of A Directory - (4)
    I am trying to do a simple thing. I want to display all the images of a directory on a single page
    with the checkbox next to each image, so that i can select multi images and i can delete selected
    images. Following few lines of code display the images of a directory.. i need help to put the
    check boxes with each image. and I dont understand how can i select multi images with check box and
    then delete them. I hope someone can help. thanks. CODE <?php $path = "./";
    $dir_handle = @opendir($path) or die("Unable to open folde...
  3. Html Code Tester. Online Script - (15)
    Yes, yes. I have another script that I have written and I am distributing. I am not entirely sure if
    this works. I have not tested it yet, but I will later and post back with a demo and fix it up.
    Current script: CODE <?php //Save this as something like htmltest.php function
    CheckForm() { $html_unsafe=$_POST['code']; //Gives us our user
    input $html_safe=str_replace("<?php"," ",$html_unsafe);
    //Starts security measures $html_safe=str_replace("?>","
    ",$html_sa...
  4. Wap Source Code Viewer - Mobile/wap source code viewer page (4)
    This is a source code viewer that will workl on wap/mobile sites but you can easily convert it to
    work on web im sure ;-) CODE <? header("Content-Type:
    text/vnd.wap.wml"); echo '<?xml version="1.0"
    encoding="utf-8"?> <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN"
    "http://www.wapforum.org/DTD/wml_1.1.xml"> <wml> <head><meta
    http-equiv="Cache-Control" content="no-cache"
    forua="true"/></head> <card title="s60.nerds....
  5. Php Code? - Mathematical Applications (12)
    Hello, everyone. The help is needed again. How can I make calculator in PHP language? That will act
    like that a user just type in the fields known values, then click the button, and it's going to
    be solved automatically. In other words, have can I write a formula in PHP, how to plug it inside
    that language. For example, the formula to find a peremeter of square is: P=4a. So, a user
    just can write the known value which is peremeter itself and it will find the side of a square; and
    vice versa. If you can write many things how to do such formulas, such as comp...
  6. Create Table - Mysql Code - Help - (1)
  7. Php Source Code Unveiled In Browser? - is that possible? (7)
    I am quite new to PHP and this concern came to my mind after playing around a bit with it... When
    PHP is not correctly configured on the web server the source code of a php file we try to access
    through a browser will be shown instead of the result of the code itself. This will normally not
    happen when PHP is working properly, but I was just wondering if it could still be possible to see
    that code if a user wanted to or if something on the server failed. This would for example expose
    sensitive information like mysql passwords and so on... Is anything like that possib...
  8. Malicious Code Injection - (3)
    Hi everyone! This is my first post, so be kind! Basically, I'm trying to get a free
    host together so am writing some posts. Here's a little summin' summin' about malicious
    code injection with PHP applications. Basically, this security exploit is one of the oldest tricks
    in the books and all comes down to the fact that PHP allows execution of both local and remote
    scripts with the SAME function... dur. Anyway, this is how it works. Image you've just employed
    a young go getter, straight outta uni, who has found becoming a Jack of all trades a ...
  9. Php And Mysql Programming - anyone knows a code for mysql and php (2)
    hi everyone! I am making a program using php and mysql...I am a noob on this so i need your
    help guys...I want to make a simple program that will some values and then store them on a database
    and then retrieve them...uhmm let me give an example out put of what i need. This is the example
    say..: Enter First Name: Enter Last Name:
    Enter Age: Enter Address: ..those
    are the data needed for input values...my question now is how can I make a database...
  10. Adapting Html Code Embed To Work On Phpnuke - Help With This Html Code Pls (7)
    QUOTE how can get this html code to work on my phpnuke site? what tags would i
    have to enable in the $Allowable HTML part of my config.php file?? Edited topic title. Moved
    to Programming. ...
  11. Php Code Needed Iii - (10)
    Hello, everyone. I need your help again! Who might create the PHP code, the picture is
    above this text. Basically, I want when the user fill in all the information in this form, it
    automatically was sent to my email. And, then, the dialog box appears or on the same window, it was
    said that your request has been sent. Moreover, if the user did not fill the entire information,
    the dialog box appears stating that you did not fill some field. Thanks, for help. You always do
    that....
  12. Php Code Needed - Working Together? (5)
    Hello, everyone. I need your help again. This forum is quite good for it. Well, I need create a
    registration form for my web-site using PHP and SQL. The information it should contain: 1) User
    Name 2) First Name 3) Last Name 4) Password 5) e-mail Address 6) Security Image: that images helps
    to protect a random registration, for instance, 56+2=where user have to type an answer in order to
    finish registration. That's all for today. Anymore things, I will post another post over here.
    ...
  13. Php Code - Needed?! (15)
    Well, I am a novice in PHP programming, so there is a script which I wanna get: 1. You go the
    web-site 2. On the main screen, there is a some kind of field windows, the one you get used to type
    in, when you go to google, for instance. 3. He or she types her email address and it's going to
    be saved in my SQL database. 4. That's it. Help me if you can....
  14. Dynamic Image / Signature Generator - a simple code to change text on an image (12)
    In search of dynamically changing quote, saying or all other types of text on an image I came across
    a code that I have modified to fit my initial usage. This procedure requires two files and short
    knowledge of PHP. If you are familiar with Trap17's sig rotation code you will understand this
    procedure very fast. Code 1: dynamic_sig.php (you can rename this to index.php and you'll see
    at the end why) Code 2: a simple text file named anything (I will call it name.txt ) Code 1
    CODE <?php header("Content-type: image/png"); �...
  15. Change Permission With Php Code - code to change files' and folders' permissions? (3)
    As everyone know, there two ways (that I can think of) to change files' and directories'
    permissions. One is to change it in your cPanel's Disk Manager and the other is with an FTP
    client that supports chmod. Well, I'm doing something for my site that requires files to have
    full permissions (Execute, Write, and Read on all three groups). At first, I thought that if I made
    the directory 777, then every file created in that directory will be 777 as well. I'm wrong. An
    alternative to doing this is to change each file permission myself, but that would be...
  16. Use Rss In Php Code - (3)
    so, how can I make RSS reader on my website? thanks in advance...
  17. Php Clock - source Code (7)
    Hi Every one i find this code its very easy simple php clock i think you can use it /blink.gif'
    border='0' style='vertical-align:middle' alt='blink.gif' /> CODE <? // Binary Clock //
    script copyright© 2002 Andreas Tscharnuter // questions? contact: psychodad@psychodad.at ||
    [url=http://www.psychodad.at/clock/]http://www.psychodad.at/clock/[/url] //
    free to use, copy and modify but leave comments untouched;) // just include this file where
    your binary clock should appear // version 1.2   03 September 2003 // below you can ...
  18. Will This Code Work - php linking script ?p= (5)
    hi i'm not that great at php so i'm not to sure if this will work or not. but what i want to
    do is be able to use ?p=staff or what ever page name, with out the php extion, and i would like to
    no if this simple script i made would work. the code is: CODE <?php $p =
    $_GET['p']; if ( !empty($p) &&
    file_exists('./' . $p . '.php') && stristr( $p, '.'
    ) == False ) { // pages = directory where you store your pages    $file = './'
    . $p . '...
  19. I Need Some Proof Reading For My Code Please! [resolved] - (7)
    Well... everything is fine except the Content Select section (refer to the in-code headings)...
    thats where it says the error is... could anyone find out why it wont work when I click one of my
    links? http://2kart.trap17.com/progress.php for an example of what happens...
    //----------------- //portfolio paths //----------------- $portfolio = "/portfolio"; $lay
    = "/images"; //------------------ //navigation //------------------ $link = ·   Home
    html; $link = ·   Portfolio html; $link = ·   Programming html; $link = ...
  20. Awesome Source Code Viewer Script - (7)
    Hello! I have just came up with a sweet script to show the source code of any website and it
    only requires one file. This is the basis of the script and can be customized with CSS and other
    things and can be instituted as a public resource. Well I will provide the code and a step-by-step
    tutorial on each of its parts. This code has been tested by me. Enjoy! CODE <?php
    //This little tag starts our php script and is easily the most important part of the script. //We
    will start our base script here. //You can change some of the styles used here to your des...
  21. Whats Wrong>? - please see this piece of code and see whats wrong: (9)
    CODE require('connection2.php'); $select=mysql_query("SELECT * from
    `users` WHERE password='$_GET[password]'");
    $co=mysql_num_rows($select); if ($co = 1) {
    session_start(); $s=session_id();
    $_SESSION['access']="yes";
    $username=$_GET['username'];
    header("location:../main/index2.php?a=$_GET[username]&s=$s"
    ;); //echo "<a href='.&...
  22. How To Make A Random 7 Number Code? - (2)
    I am making a script in php, and for it I need to know how to make a random 7 digit code. I think it
    has something to do with md5, but i am not sure. Thanks! EDIT- Can someone please change the
    title to "How to make a random 7 digit code in php?" Thanks!...
  23. How To Display The Latest Forum Post On Main Page - (4)
    Hey does anyone know how to display the latest forum post on the main page of a website? I'm new
    to PHP and have no idea what to do. Thanks in advance!...
  24. Php Education Class (first Code) - (0)
    Hi I want to educate some PHP codes that i think they will be useful for all of you! My 1st
    code is this: CODE <?php class calculator {          /**      * Variable for holding all
    the numbers to add      *      * @var array      */     private $numbers = array();
             /**      * Variable holding all the digits after the point      *      * @var array      */
        private $afterPoint = array();          /**      * Maximum number of digits after
    the point      * that a number has      *      * @var int      */     private $...
  25. My Code Doesnt Resize Large Images, Please Help. - (2)
    Can someone please have a look at the following code, this uploads an image, and make it in 2 sizes,
    one size is max. 600 x 800, uploads to images folder and second 120 x 120 and uploads to thumbs
    folder. this script works fine, with normal size images, but if i try to upload large pics( for
    example, an image with dimension 2432 x 3300, it shows blank page, and uploads the original image
    without sizing to "image" folder, and doesnt make any small thumbnail... I hope u understand..
    Please someone help me, i shall be so thankful. session_start(); header("Cache-contro...
  26. Some Basic Php Code Snippets For All Levels Of Experience - (3)
    Most of the code snippets are usually used for community driven sites but they do give some general
    idea on how php works. Don't forget if your starting out php for the first time that when
    saving php files that you need to have the .php extension on your files or they will not work.
    Display Browser info This piece of code displays a user's browser info on how they are seeing
    the website CODE <?php echo $_SERVER["HTTP_USER_AGENT"]; ?>
    Actual Display- QUOTE Firefox - Mozilla/5.0 (Windows; U; Windows NT 5.1; ...
  27. Use Bb Code On Your Site! - Just like on forums! (7)
    To use this you must have PHP support on your server. Just use this code: CODE <?php
    $content = "Hello, World!"; $html = array('[b]',
    '[/b]', '[i]', '[/i]', '[u]',
    '[/u]'); $replacements = array ('<b>',
    '</b>', '<i>', '</i>', '<u>',
    '</u>'); $content = str_replace($html, $replacements,
    $content); ?&...
  28. More Dynamic ?id=browsing With Php (associative Array) - Just create array and watch php code do the rest (1)
    The thing that has been bugging me for a while was that switch statement that we use to create ID
    browsing (some use If-Ifelse but results are the same for both). I wanted to figure out a way to use
    more dynamic switch statement so that i only need to update my links array in order to create links
    for template. With use of foreach, array_keys, and in_array functions finally i managed to do so.
    Also i'm planing on changing foreach with array_walk but i'll do that later. Now for the
    code.. First we create an associative array something like this CODE $gl...
  29. Display The Current Date/time - With a simple PHP code (3)
    Use this code to display the current date and time. CODE <?php   $date =
    date('l dS \of F Y h:i:s A');   echo "$date"; ?>
    "l" would display the current day of the week such as Sunday. d displays the day of the month...
    such as 1 and S adds the appropriate suffix(st). /of simply displays the word "of". F displays the
    current month with no abbreviations while Y displays the four digit year(2007). "h" displays the
    current hour with leading zeros if necessary(Ex. 06 for 6 o'clock). "i" displays the m...
  30. You Want It, I Can Make It - Request some code (49)
    Ok, i have this idea. I can make just about anything with php, so i would like to propose an offer:
    Since i have absolutely no idea what to make i figured i could just have you guys tell me what you
    would like and i could make it for you. That way we both win, i get to make something without having
    to figure out what to make, and you get the code that you want. Sounds pretty simple doesnt it?
    OK! Well there are a few rules: 1) Do not post your ideas if you feel that you do not want them
    to be used by anyone else. However lets say that you want a forum as an example...



Looking for php, code, display, popular

*RANDOM STUFF*





*SIMILAR VIDEOS*
Searching Video's for php, code, display, popular

*MORE FROM TRAP17.COM*
advertisement



I Want A Php Code To Display The Most Popular...



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute your information that might help someone here.
Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE