[RESOLVED] Viewing mysql data as URL

vipernet

Good day all,

Here is my code for view data within my SQL database:

<html>
<title></title>
<head></head>
<body>

<?php
mysql_connect("localhost", "Username", "Password") or
    die("Could not connect: " . mysql_error());
mysql_select_db("MySQL_Name");

$sql = mysql_query("SELECT * FROM Tablename");

while($row = mysql_fetch_array($sql)) {
$name = stripslashes($row['name']);
$link = stripslashes($row['link']);
$room = $row['room'];

echo" <table width=\"100%\" cellpadding=\"3\" cellspacing=\"1\" border=\"1\">"
  . "<tr> "
  . "  <th>Computer</th>"  

  . "  <th>Computer Name</th>"
  . "  <th>Room #</th>"
  . "  </tr>"
  . "  <tr>"
  ."    <td align=\"center\">$name</td>"  

  . "   <td align=\"center\">$link</td>"
  . "   <td align=\"center\">$room</td>"
  . "</tr>"
  . "</table>";
}



?> 
</body>
</html>

Output show up like ( in a table of course):

Computer 	Computer Name 	Room #
1 	http://ComputerName:5800 	1

How do i make it so that the Computer Name shows up as a clickable link?

Also how do i make it so the:
Computer Computer Name Room #
does repeat itself with more data:

Computer 	Computer Name 	Room #
3 	http://CompName:5800 	3
Computer 	Computer Name 	Room #
1 	http://ComputerName:5800 	1

nemonoman

First off, you need to study some basic HTML.

How does one create 'a clickable link'? (hint: <a href=...)

Next -- about duplicates:
The data being returned is the data in your database. So either clean up that data, or figure how to get only unique values. For example: at the end of your query add:
GROUP BY name

wilku

vipernet wrote:
Good day all,

How do i make it so that the Computer Name shows up as a clickable link?

Doesn't this line give you a hint?

. "   <td align=\"center\">$link</td>"

It echoes the varible $link in a table cell. Now, how does a link in html look like?

<a href="url goes here">Text goes here (can be url as well)</a>

Combine those two togethere and you'll get your clickable link.

vipernet wrote:
Also how do i make it so the:
Computer Computer Name Room #
does repeat itself with more data:

The way you wrote it, header of the table should repeat with every row from database. In fact you echo separate table for every record.

vipernet

haha ya i guess i overlooked the easy way 😛

I figured i was missing something with how its stored in SQL or something

 . "   <td align=\"center\">$link</td>"

Changed it to:

 . "   <td align=\"center\"><a href='$link'>$link</a></td>"

and that seems to work.

thanks for help on the URL, but as for the Table header showing up over every entry, any suggestions there?

vipernet

wilku wrote:
The way you wrote it, header of the table should repeat with every row from database. In fact you echo separate table for every record.

Ya im still learning/understanding from what i read on tutorials/php site.

I just want to repeat the data and have the Table header stay at the top:

I tried playing with this script:
but can't seem to figure it out.

nemonoman

Change the loop. Put the header outside the loop.

$sql = mysql_query("SELECT * FROM Tablename");
echo" <table width=\"100%\" cellpadding=\"3\" cellspacing=\"1\" border=\"1\">"
  . "<tr> "
  . "  <th>Computer</th>"  

  . "  <th>Computer Name</th>"
  . "  <th>Room #</th>"
  . "  </tr>";
while($row = mysql_fetch_array($sql)) {
$name = stripslashes($row['name']);
$link = stripslashes($row['link']);
$room = $row['room'];
echo"  <tr>"
  ."    <td align=\"center\">$name</td>"  

  . "   <td align=\"center\">$link</td>"
  . "   <td align=\"center\">$room</td>"
  . "</tr>"
} 
echo "</table>";

vipernet

Error with that code:

Parse error: syntax error, unexpected '}', expecting ',' or ';' in view.php on line 29

Line 29 is the }

$sql = mysql_query("SELECT * FROM school");
echo" <table width=\"100%\" cellpadding=\"3\" cellspacing=\"1\" border=\"1\">"
  . "<tr> "
  . "  <th>Computer</th>"  

  . "  <th>Computer Name</th>"
  . "  <th>Room #</th>"
  . "  </tr>";

while($row = mysql_fetch_array($sql)) {
$name = stripslashes($row['name']);
$link = stripslashes($row['link']);
$room = $row['room'];

echo"  <tr>"
  ."    <td align=\"center\">$name</td>"  

  . "   <td align=\"center\">$link</td>"
  . "   <td align=\"center\">$room</td>"
  . "</tr>"
} 
echo "</table>";

Now what i did try was:


echo "  <tr>"
  ."    <td align=\"center\">$name</td>"  

  . "   <td align=\"center\"><a href='$link'>$link</a></td>"
  . "   <td align=\"center\">$room</td>"
  . "</tr>"
  . "</table>";
}

Which displays the data fine, but its only showing one Row of data and other info is just listed outside of the table .

nemonoman

Jeez. Get on my case for a missing semi-colon?? Learn to look at your code.

$sql = mysql_query("SELECT * FROM school"); 
echo" <table width=\"100%\" cellpadding=\"3\" cellspacing=\"1\" border=\"1\">" 
  . "<tr> " 
  . "  <th>Computer</th>"   

  . "  <th>Computer Name</th>" 
  . "  <th>Room #</th>" 
  . "  </tr>"; 

while($row = mysql_fetch_array($sql)) { 
$name = stripslashes($row['name']); 
$link = stripslashes($row['link']); 
$room = $row['room']; 

echo"  <tr>" 
  ."    <td align=\"center\">$name</td>"   

  . "   <td align=\"center\">$link</td>" 
  . "   <td align=\"center\">$room</td>" 
  . "</tr>" ; // here's where the missing semicolon caused the line 29 problem
} 
echo "</table>";

vipernet

you rock man thansk allot for your help,

Sorry i didn't mean to come accross as getting on your case. Im still learning so i wouldn't have known that yet,

Again thanks for all your help.