• 0

Random number in html/php link


Question

I'd like to generate a random number from between 1 and 5000,

This is how a link normally looks on my website - http://mysite.net/in...ils.php?mid=754

The code for this is generated by <a href="http://mysite.net/index.php/details.php?mid='.$v['id'].'"> (the number is chosen depending on which link is selected. - the ID is being retrieved from a database)

I'd like to create a seperate link that whenever its clicked it throws a random number in place. Can anyone help me achieve this?

Link to comment
https://www.neowin.net/forum/topic/1059738-random-number-in-htmlphp-link/
Share on other sites

10 answers to this question

Recommended Posts

  • 0


<a href="http://mysite.net/index.php/details.php?mid=<?php echo rand(1,15000); ?>">LINK</a>
[/CODE]

That should do it

If it is already between PHP tags then

[CODE]
<a href="http://mysite.net/index.php/details.php?mid='. rand(1,15000) .'">LINK</a>
[/CODE]

  • 0
  On 23/02/2012 at 13:27, Lingwo said:


<a href="http://mysite.net/index.php/details.php?mid=<?php echo rand(1,15000); ?>">LINK</a>
[/CODE]

That should do it

Thanks that worked :D

I do however have a slight problem, in a few cases there is an ID missing (when I've made a mistake and deleted an entry in the database) so it throws up an error when its tries to retrieve 54 for example and there isn't a 54 in the database.

Is there any way around this?

  • 0

Only way i can see is either do an if on the details.php page to say "if the returned query row count is 0" then display a friendly error or write function that will grab all the ID's from a database and then randomize a number from that.

Is this a site you've made yourself or is it running on an existing software?

  • 0

Forget the random ID in the URL. Just create a page that randomly selects a page from your database. Use SQL to do this.

Depending on what database you're using, it will look something like this:

SELECT * FROM table
ORDER BY RAND()
LIMIT 1[/CODE]

http://www.petefreit...om/item/466.cfm

This is how you'd want to implement something like StumbleUpon.

  • 0
  On 23/02/2012 at 17:14, marklcfc said:

Do I just stick that code in a php file?

No, you would have to modify the code that reads the page-id from the URL and uses it to look up the page in the database. Somewhere, there will be code that looks like:

SELECT * FROM table WHERE pageid=mid[/CODE]

[color=#282828]That code will return the data for the page that was specified in the URL. Instead, you want something more like:

[CODE]SELECT * FROM table ORDER BY RAND() LIMIT 1[/CODE]

[/color]

[color=#282828]Of course, you have to change the part that says "table" to the name of the table you are reading in the database.[/color]

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • TCL 75" 4K Smart TV hits lowest price, now less than £500 by Paul Hill Are you in the UK and looking for a massive 75-inch Ultra HD 4K HDR TV at a relatively affordable price? If so, check out this TCL (75P755K) 75-inch TV now because it’s at its lowest price of just £499.00, down 15% from £589.00. The model in question is slightly older, from 2024, but it’s still an excellent home entertainment upgrade given its feature set and aggressive price point. What you get: Features for the price The feature set of this model is definitely pretty impressive. It supports 4K HDR, wide colour gamut, and multiple HDR formats including HDR10+ and Dolby Vision. It also leverages MEMC (Motion Estimation & Motion Compensation), a proprietary algorithm from TCL that helps to reduce motion display blur and keep motion trails to a minimum. While MEMC will do heavy lifting to ensure the best picture, the TV only has a 60Hz refresh rate, but an effective rate of 120Hz thanks to efforts by TCL. This TCL model features Dolby Atmos 2.0 that immerses you more in whatever you’re watching on the TV. In terms of software, this TV comes with Google TV (based on Android) which is well-known and widely supported, ensuring you can use all the apps you depend on. It also supports Google Assistant, Chromecast, and voice control. The Chromecast support allows you to easily stream from your computer or phone to the TV to share what you’re watching to the people around you. The Google Assistant support can also be good if you have smart home devices around the house that can connect to it. The audio features for this TV are also good and mean you don’t need to buy a separate sound bar immediately. User experience and potential considerations According to What Hi-Fi, which reviewed the smaller 65-inch version of this TV, TCL’s TV delivers when it comes to HDR; gaming features such as low input lag, VRR, and Game Bar; wide colour gamut, and the operating system. What it didn’t like about the TV was the limited brightness, which degraded the HDR in bright rooms; the average motion handling; the lack of bass; the lack of local dimming; and the budget-oriented build quality. Making the smart buy decision If you can overlook its limitations, this TV could be a good pick if you need a new TV in the living room on a budget. If you are a serious gamer looking for a high refresh rate, or someone in a very bright room, then you will probably want to look elsewhere. Amazon is also offering free add-on services including wall mounting and unpack. If you do decide to pick up this TCL TV and find a fault with it, you have 30-days from getting the receipt to return it. TCL 75P755K 75-inch 4K TV: £499 (Amazon UK) - MSRP £589 / 15% off This Amazon deal is U.K. specific, and not available in other regions unless specified. If you don't like it or want to look at more options, check out the Amazon UK deals page here. Get Prime, Prime Video, Music Unlimited, Audible or Kindle Unlimited, free for the first 30 days As an Amazon Associate we earn from qualifying purchases.
    • I came here to post something similar, you beat me to it. Why on earth would somebody buy Windows again, even this shady grey-market cheap key, when they already have it and an upgrade from 10 to 11 is free?
    • I maintain that the Cybertruck was a social experiment.  "Can we convince the massively insecure petrol guzzling, Dodge Ram loving, right wing idiots to buy a poorly built, underpowered, underspecified, electric vehicle that they know everyone will laugh at them in"
    • Wish you could set the WiFi country without setting an SSID. This would stop the warning on every boot.
  • Recent Achievements

    • Week One Done
      theevergreentree earned a badge
      Week One Done
    • Dedicated
      Fryer Tuck earned a badge
      Dedicated
    • Week One Done
      luxoxfurniture earned a badge
      Week One Done
    • First Post
      Uranus_enjoyer earned a badge
      First Post
    • Week One Done
      Uranus_enjoyer earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      439
    2. 2
      +FloatingFatMan
      247
    3. 3
      snowy owl
      226
    4. 4
      ATLien_0
      212
    5. 5
      Xenon
      152
  • Tell a friend

    Love Neowin? Tell a friend!