Pull Info From Database

[yukisho]

I made this script to show the status of game servers, well I got it to show the server status info, but nothing else. This is my script:

<title>World of Warcraft Private Server Status</title>
<center><?php
/*
CREATE TABLE `servers` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `sname` VARCHAR(30) NOT NULL,
  `sip` VARCHAR(16) NOT NULL,
  `website` VARCHAR(50),
  `lport` INT(5) NOT NULL,
  `sport` INT(5) NOT NULL,
  `comment` TEXT NOT NULL,
  PRIMARY KEY(`id`)
);
*/

 $dbh=mysql_connect ("localhost", "yukisho_servers", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("yukisho_servers");

echo "<table border='2'>";
echo "<tr>";
echo "<td>";
echo "<strong>Current Servers:</strong><br>";
  $sql = "SELECT * FROM `servers`";
  if(!($getServers = mysql_query($sql))) {
    echo "ERROR! Cannot retrieve servers.<br>".mysql_error();
  } else {
    while($s = mysql_fetch_object($getServers)) {
      echo "Name: $sname";
      echo "<br>";
      $checkLogin = @fsockopen($s->sip, $s->lport, $errno, $errstr, 3);
      if(!$checkLogin) {
	  echo "Server Status: <img src=\"/images/offline.gif\"><br>";
      }  else {
        echo "Server Status: <img src=\"/images/online.gif\"><br>";
      }

  echo "Website: ";

  echo "Comments: ";
  echo "<br>";

echo "<br>";
    }
  }
if(isset($_POST['addServer'])) {
  $sql = "INSERT INTO `servers` ( `sname` , `sip` , `website` , `lport` , `sport` , `comment` ) VALUES ('".$_POST['sName']."', '".$_POST['sIP']."', '".$_POST['website']."', '".$_POST['lPort']."', '".$_POST['sPort']."', '".$_POST['comment']."')";
  if(!mysql_query($sql)) {
    echo "ERROR! Server not added.<br>".mysql_error();
  } else {
    echo "Server added successfully.";
  }
}
echo "</td>";
echo "</tr>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<tr>";
echo "<td>";
echo "<form method=\"post\" action=\"".$_SERVER['PHP_SELF']."\">
<strong>Add a Server</strong><br>
Server Name: <input type=\"text\" name=\"sName\"><br>
Server IP: <input type=\"text\" name=\"sIP\"><br>
Server Port: <input type=\"text\" name=\"sPort\" value=\"\"><br>
Login Port: <input type=\"text\" name=\"lPort\" value=\"\"><br>
Website: <input type=\"text\" name=\"website\"><br>
Comment:
<textarea name=\"comment\" cols=\"50\" rows=\"5\"></textarea><br>
<input type=\"submit\" name=\"addServer\" value=\"Add Server\">
</form>";
echo "</td>";
echo "</tr>";
echo "</table>";

?></center>

[tomhath]

Instead of this:

 echo "Name: $sname";

Try this:

 echo "Name: " . $s->sname;

And you aren't echoing anything here...

      echo "Website: ";

  echo "Comments: ";

[yukisho]

thanks it works perfectly. Now can I get help on adding my style.css to the page. I added at the top include "./style.css"; but it doesnt seem to work.

[tomhath]

That form of include is when you want a php script to be inserted at that point. For a CSS file, move it outside of the php tags and use this:

<link rel="stylesheet" type="text/css" href="style.css" />

<?php
... rest of your script...
?>