Extracting URL's from mysql database and setting as single word clickable link

Question

I would like to extract URL's from a mysql database. However I wish to link the URL to a single word 'CLICK' in a table.

The snippet of code below extracts data from a mysql database and puts it in a table as a series of rows. For each row there is a respective URL which I also wish to extract from the database. Instead of showing the full and long URL I just want to have the word CLICK against each row which people can then click to access that URL. Can any body tell me how that is done?

        $q="SELECT * FROM railstp WHERE DOWNLOAD='$changeday'";
                $r=mysqli_query($mysql_link,$q);

                if ($r)
                {
                echo "<strong>Network Rail Schedule (STP) updates downloaded: $changeday</strong>";
                echo "<p> </p>";
                echo "<Table id='customers'>
                <tr>
                <th>Headcode</th>
                <th>Traction</th>
                <th>From</th>
                <th>To</th>
                <th>Departing</th>
                <th>Destination</th>
                <th>Depart</th>
                <th>Arrive</th>
                <th>ATOC</th>
                <th>Runs</th>
                <th>Load</th>
                <th>Speed</th>
                </tr>";

                while ($row=mysqli_fetch_array($r,MYSQLI_ASSOC))
                {
                echo "<tr>";
                echo "<td>".$row['HEADCODE']."</td>";
                echo "<td>".$row['TRACTION']."</td>";
                echo "<td>".$row['STARTDATE']."</td>";
                echo "<td>".$row['ENDDATE']."</td>";
                echo "<td>".$row['DEPART']."</td>";
                echo "<td>".$row['ARRIVE']."</td>";
                echo "<td>".$row['DEPARTTIME']."</td>";
                echo "<td>".$row['ARRIVALTIME']."</td>";
                echo "<td>".$row['ATOC']."</td>";
                echo "<td>".$row['RUNS']."</td>";
                echo "<td>".$row['LOAD']."</td>";
                echo "<td>".$row['SPEED']."</td>";
                echo "</tr>";
                }
                echo "</Table>";
                }
                else {echo '<p>'.mysqli_error($mysql_link).'</p>' ;}
                }
                show_records($mysql_link);
                mysqli_close($mysql_link);

ironcito · Accepted Answer · 2013-07-31 20:36:11Z

2

In its simplest form:

<a href="<?php echo $URL;?>">CLICK</a>

answered Jul 31, 2013 at 20:36

ironcito

8376 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Robert Dickey Over a year ago

That about sums it up

user2635961 Over a year ago

Thanks Ironcito. Do I put this within the <td> </td> table area. Sorry pretty new to all of this

ironcito Over a year ago

I don't know exactly how you want to do it. If the URL is a field in the database, then you could add a line like @Vacation9 said, changing the name of the field if necessary.

sdamashek · Accepted Answer · 2013-07-31 20:37:30Z

0

Add this to your row code:

echo "<td><a href='".$row['URL']."'>CLICK</a></td>";

What this does is add the URL as the parameter to the link but as the link text only show CLICK. Replace URL with the column name for your url.

answered Jul 31, 2013 at 20:37

sdamashek

6281 gold badge5 silver badges13 bronze badges

1 Comment

user2635961 Over a year ago

Just tried it out. Worked perfectly first time. Thanks again Vacation9 and Ironcito

Collectives™ on Stack Overflow

Extracting URL's from mysql database and setting as single word clickable link

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related