• 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

    • hey guys its not counterfeit. i did test its ok needs formatting but how do i do that i need to go in dos and disk Disk Management anyone know step by step please 
    • The first link on the github page gives me a very, very red page warning me about phishing........
    • Hey Nick! 👋 No worries at all — you're not alone in this, and it's great you're asking for help. Let me walk you through a simple, step-by-step fix using the tool mentioned on that AOMEI Partition Assistant guide — it really does the trick for many people with this exact issue! ✅ Here’s how to restore your USB back to full 256GB on Windows 11: Download & Install AOMEI Partition Assistant Go to the link you shared: AOMEI Partition Assistant and click the Download Freeware button. Insert your USB stick (Sandisk Ultra 256GB) Make sure it's properly connected. Wait for the system to detect it. Launch AOMEI Partition Assistant Once open, you'll see all your connected drives listed. Locate your USB Drive Look for the one that says something like Disk X – Removable and shows only 3.1GB or so. Right-click on your USB Drive’s Partition Then select Delete Partition → confirm the deletion. Now, right-click on the unallocated space (it should now show full unallocated capacity) Choose Create Partition → format it as FAT32 or exFAT (recommended for larger drives) → click OK. Click “Apply” in the top left corner Then hit Proceed to execute the pending operations. Wait a bit... and boom! 🎉 Your USB should now be restored to its full 256GB capacity!
    • When Facebook bought Beat Saber, they promised exactly this would never happen. Facebook can’t not lie.
  • Recent Achievements

    • First Post
      Fuzz_c earned a badge
      First Post
    • First Post
      TIGOSS earned a badge
      First Post
    • Week One Done
      slackerzz earned a badge
      Week One Done
    • Week One Done
      vivetool earned a badge
      Week One Done
    • Reacting Well
      pnajbar earned a badge
      Reacting Well
  • Popular Contributors

    1. 1
      +primortal
      713
    2. 2
      ATLien_0
      279
    3. 3
      Michael Scrip
      209
    4. 4
      +FloatingFatMan
      201
    5. 5
      Steven P.
      131
  • Tell a friend

    Love Neowin? Tell a friend!