Game Playing System

davidknag · January 2, 2011

so i have an idea for a system that basicly shows a swf, how to play, and description all managed by sql.

the url would be like: "www.example.com/play.php?id=531"

my sql table would be like this:

___________________

id name swfname description howto

1 example ex1.swf destroy your enemies with your gun mouse to aim, click to shoot

2 example2 ex2.swf race your friends with this new game! Arrow keys to move. Space to use powerup.

________________

I need help creating a system that looks at the id provided in the url, then grabs the information in the sql and broadcasts the swf, and posts the title up top and the description and howto below.

anyone have any idea how to do this?

fortnox007 · January 2, 2011

Uhm just for my sense, what is the relation of the get variable ( 531) and the stuff in the database? is it a game id?

BLaZuRE · January 2, 2011

I have tons of ideas, but then I'd spend hours of coding and GIMP'ing and I would probably end up with a flashy website I'd probably want to keep for myself .

Try http://php.net/manual/en/reserved.variables.get.php, http://dev.mysql.com/doc/refman/5.0/en/select.html, http://php.net/manual/en/function.echo.php.

You have to get the variables (sanitize and validate if you know how), query the game you want by using your id variable, echo out the title and content using PHP.

If those pages don't make sense to you, then look up MySQL and PHP tutorials on the Internet.

Update us if you have more specific questions.

davidknag · January 2, 2011

Uhm just for my sense, what is the relation of the get variable ( 531) and the stuff in the database? is it a game id?

yeah

davidknag · January 2, 2011

I have tons of ideas, but then I'd spend hours of coding and GIMP'ing and I would probably end up with a flashy website I'd probably want to keep for myself .

Try http://php.net/manual/en/reserved.variables.get.php, http://dev.mysql.com/doc/refman/5.0/en/select.html, http://php.net/manual/en/function.echo.php.

You have to get the variables (sanitize and validate if you know how), query the game you want by using your id variable, echo out the title and content using PHP.

If those pages don't make sense to you, then look up MySQL and PHP tutorials on the Internet.

Update us if you have more specific questions.

thanks this will be useful(:

fortnox007 · January 2, 2011

Ah I thought so than it would make sense to add an extra column as a game id, that way you can fetch all the rows with a certain game id. because now this 531 ID makes no sense at all.

Ones you done that,

you can do

<?php
include('connection-file.php'); //connection stuff

if(isset($_GET['id'])){  
     $query_var = (int)$_GET['id']; // force it to be an integer
     $query = "SELECT * your_table WHERE gameID = '$query_var'";
     
     $result = mysqli_query($dbc, $query);
     while($row =  mysqli_fetch_array($result)) { //this output should be filtered in a real world
         echo '<h2>TITLE: '.$row['title'].'</h2><br />';
         echo 'some flash object here with the right variable'.$row['swfname'].'<br />';
         echo '<h3>How To: '.$row['howto'].'</h3>';
     }
}// I forgot this last bracket 
?>

if you want to limit the rows use LIMIT 1 for instance in your query at the end.

-edit: it could be nice to add some 'else - clauses' for instance if someone types ?id=lalalala (int)$_GET['id'] will become 0.

davidknag · January 2, 2011

Hmm... nothing :s

<?php
$con = mysql_connect("ip's_shall_be_hidden","1","1");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  
  mysql_select_db("games", $con);
if(isset($_GET['id'])){  
     $query_var = (int)$_GET['id']; // force it to be an integer
 $sql=" SELECT FROM games WHERE id = '$query_var'";
     
     $result = mysqli_query($dbc, $query);
     while($row =  mysqli_fetch_array($result)) { //this output should be filtered in a real world
         echo '<h2>TITLE: '.$row['title'].'</h2><br />';
         echo 'some flash object here with the right variable'.$row['swfname'].'<br />';
         echo '<h3>How To: '.$row['howto'].'</h3>';
     }
}//
?>

i know it wont play the flash object or anything yet because i dont have the embed tag but i dont get anything returned when i open the page

http://atomicpool.com/play.php?id=1

also, how would i put the 'name' of the game in the title of the page?

Pikachu2000 · January 2, 2011

You're mixing the mysql and mysqli extensions. Use one or the other, not both.

fortnox007 · January 2, 2011

your using the old mysql_connect use mysqli_connect

<?php
$con = mysqli_connect('host', 'user', 'password', 'database');

if(isset($_GET['id'])){
     $query_var = (int)$_GET['id']; // force it to be an integer

$sql=" SELECT FROM games WHERE id = '$query_var'";

     $result = mysqli_query($con, $query);
     while($row =  mysqli_fetch_array($result)) { //this output should be filtered in a real world
         $string1= '<h2>TITLE: '.$row['title'].'</h2><br />';
         $string2= 'some flash object here with the right variable'.$row['swfname'].'<br />';
         $string3= '<h3>How To: '.$row['howto'].'</h3>';
     }
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="nl" lang="nl" >
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
        <title><?php $row['title'];?></title>
    </head>
    <body>
        <?php echo $string1.$string2.$string3;  ?>
    </body>
</html>

-edit this can be done cleaner, but it works i guess ::)

-edit2: i changed var $dbc into $con

davidknag · January 2, 2011

your using the old mysql_connect use mysqli_connect

<?php
$con = mysqli_connect('host', 'user', 'password', 'database');

if(isset($_GET['id'])){
     $query_var = (int)$_GET['id']; // force it to be an integer

$sql=" SELECT FROM games WHERE id = '$query_var'";

     $result = mysqli_query($con, $query);
     while($row =  mysqli_fetch_array($result)) { //this output should be filtered in a real world
         $string1= '<h2>TITLE: '.$row['title'].'</h2><br />';
         $string2= 'some flash object here with the right variable'.$row['swfname'].'<br />';
         $string3= '<h3>How To: '.$row['howto'].'</h3>';
     }
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="nl" lang="nl" >
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
        <title><?php $row['title'];?></title>
    </head>
    <body>
        <?php echo $string1.$string2.$string3;  ?>
    </body>
</html>

-edit this can be done cleaner, but it works i guess ::)

-edit2: i changed var $dbc into $con

its still not exporting the data :-\

<?php
$con = mysqli_connect('localhost', 'webuser', 'davidknag', 'games');

if(isset($_GET['id'])){
     $query_var = (int)$_GET['id']; // force it to be an integer

$sql=" SELECT FROM games WHERE id = '$query_var'";

     $result = mysqli_query($dbc, $query);
     while($row =  mysqli_fetch_array($result)) { //this output should be filtered in a real world
         $string1= '<h2>TITLE: '.$row['title'].'</h2><br />';
         $string2= 'some flash object here with the right variable'.$row['swfname'].'<br />';
         $string3= '<h3>How To: '.$row['howto'].'</h3>';
     }
}

?>

fortnox007 · January 2, 2011

you mean importing

and look at my edit2......

you still have:

$result = mysqli_query($dbc, $query);

instead of

$result = mysqli_query($con, $query);

davidknag · January 2, 2011

you mean importing

and look at my edit2......

you still have:
$result = mysqli_query($dbc, $query);
instead of
$result = mysqli_query($con, $query);

hmm... didn't appear to do anything lol

<html>
<head>
<title>Play Game - AtomicPool.com</title>
<link rel="icon" type="image/png" href="icon.png">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<link href="style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><img src="images/index_01.jpg" alt="" width="1000" height="217" border="0" usemap="#Map"></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><a href="index.html" onmouseover="document.home.src='images/hover_02.gif'" onmouseout="document.home.src='images/index_02.gif'""><img name="home" src="images/index_02.gif" alt="" width="269" height="55" border="0"></a></td>
        <td><a href="gl.html"onmouseover="document.gl.src='images/hover_03.gif'" onmouseout="document.gl.src='images/index_03.gif'""><img name="gl" src="images/index_03.gif" alt="" width="159" height="55" border="0"></a></td>
        <td><a href="about.html"onmouseover="document.about.src='images/hover_04.gif'" onmouseout="document.about.src='images/index_04.gif'""><img name="about" src="images/index_04.gif" alt="" width="177" height="55" border="0"></a></td>
        <td><a href="contact.php"onmouseover="document.contact.src='images/hover_05.gif'" onmouseout="document.contact.src='images/index_05.gif'""><img name="contact" src="images/index_05.gif" alt="" width="168" height="55" border="0"></a></td>
        <td><a href="http://AtomicPool.com/blog/"onmouseover="document.blog.src='images/hover_06.gif'" onmouseout="document.blog.src='images/index_06.gif'""><img name="blog" src="images/index_06.gif" alt="" width="227" height="55" border="0"></a></td>
      </tr>
    </table></td>
  </tr>
</table>
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#01151E"><table width="100%" border="0" cellspacing="10" cellpadding="0">
      <tr>
        <td width="10%"> </td>
        <td width="81%"><table width="100%" border="0" cellspacing="10" cellpadding="0">
          <tr>
            <td width="11%" rowspan="2"><img src="images/index_09.jpg" width="111" height="114" alt=""></td>
            <td width="89%"><strong>The website is in a its test development state. If you find any bugs, please Report a bug.</strong></td>
          </tr>
          <tr>
            <td><a href="contact.php"><img src="images/index_12.gif" alt="" width="110" height="24" border="0"></a></td>
          </tr>
        </table></td>
        <td width="9%"> </td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><img src="images/index_16.gif" width="1000" height="29" alt=""></td>
  </tr>
  <tr>
    <td class="bg1"><table width="100%" border="0" cellspacing="10" cellpadding="0">
      <tr>
        <td width="10%"> </td>
        <td width="81%"><table width="100%" border="0" cellspacing="10" cellpadding="0">
          <tr>
            <td><table width="100%" border="0" cellpadding="0" cellspacing="10">
              <tr>

                <td><h2 class="blye2"><i></i></h2>
						  <?php
$con = mysqli_connect('localhost', 'webuser', 'davidknag', 'games');

if(isset($_GET['id'])){
     $query_var = (int)$_GET['id']; // force it to be an integer

$sql=" SELECT FROM games WHERE id = '$query_var'";

     $result = mysqli_query($con, $query);
     while($row =  mysqli_fetch_array($result)) { //this output should be filtered in a real world
         $string1= '<h2>TITLE: '.$row['title'].'</h2><br />';
         $string2= 'some flash object here with the right variable'.$row['swfname'].'<br />';
         $string3= '<h3>How To: '.$row['howto'].'</h3>';
     }
}

?>
                <br>
				<br></br>
				<br></br>
				<br></br>
				<br></br>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td><table width="812" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td height="217" background="images/index_24.gif"><table width="100%" border="0" cellspacing="10" cellpadding="0">
                  <tr>
                    <td width="24%"> </td>
                    <td width="76%"><table width="100%" border="0" cellspacing="10" cellpadding="0">
                      <tr>
                        <tr>
                            <td width="33%"><strong>.<br>
                              <br>
                              </strong></td>
                            <td width="33%"><strong>.<br>
                              <br>
                              </strong></td>
                            <td width="34%"><strong>.<br>
                              <br>
                              </strong></td>
                          </tr>
                        </table></td>
                      </tr>
                    </table></td>
                  </tr>
                </table></td>
              </tr>
            </table></td>
          </tr>
        </table></td>
        <td width="9%"> </td>
      </tr>
    </table></td>
  </tr>
</table>
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#005d7b"><table width="100%" border="0" cellspacing="10" cellpadding="0">
      <tr>
        <td width="50%" align="center"><a href="#"><strong></strong></a><strong class="blye-text-regular"></strong></td>
        <td width="50%" align="center">&copy Copyright 2011 AtomicPool.com</td>
      </tr>
    </table></td>
  </tr>
</table>

<map name="Map"><area shape="rect" coords="752,80,885,139" href="http://davidknag.com/"></map></body>
</html>

-edit this is the sql table: http://atomicpool.com/sql.png

fortnox007 · January 2, 2011

lol ok, but did you even look at my example, it should pretty much work, and i placed some parts in the <head> to give <title> a dynamic value.

Are you sure your credentials are correct, and the names used in the query? do they match the table column's

-edit seems your columns match

-edit I supose you typed in an id like this http://yourdomain.com?id=1

otherwise nothing will pop up since it wont enter the first part of the if clause.. and maybe also put something in the how to.

also for now i would leave out the table crap, to isolate the problem instead of bringing in more stuff to cause an error.

davidknag · January 2, 2011

lol ok, but did you even look at my example, it should pretty much work, and i placed some parts in the <head> to give <title> a dynamic value.

Are you sure your credentials are correct, and the names used in the query? do they match the table column's

-edit seems your columns match

-edit I supose you typed in an id like this http://yourdomain.com?id=1

otherwise nothing will pop up since it wont enter the first part of the if clause.. and maybe also put something in the how to.

yes i did lol i was going to do that later but i didn't notice "<?php echo $string1.$string2.$string3; ?>" down below

uhmm hmm this is my database: http://atomicpool.com/sql.png

<?php
$con = mysqli_connect('atomicpool.com', 'webuser', 'davidknag', 'games');

if(isset($_GET['id'])){
     $query_var = (int)$_GET['id']; // force it to be an integer

$sql=" SELECT FROM games WHERE id = '$query_var'";

     $result = mysqli_query($con, $query);
     while($row =  mysqli_fetch_array($result)) { //this output should be filtered in a real world
         $string1= '<h2>TITLE: '.$row['title'].'</h2><br />';
         $string2= 'some flash object here with the right variable'.$row['swfname'].'<br />';
         $string3= '<h3>How To: '.$row['howto'].'</h3>';
     }
}

?>
<html>
<head>
<title><?php $row['title'];?> - AtomicPool.com</title>
</head>
etc etc etc
<?php echo $string1.$string2.$string3;  ?>

fortnox007 · January 2, 2011

no no no, you need to echo those strings between the body tag.

try to do some error reporting, I can't do anything with , "not working"

$con = mysqli_connect('atomicpool.com', 'webuser', 'davidknag', 'games')
or die(mysqli_error($con));

oh hehe i think i found it:

$sql=" SELECT FROM games WHERE id = '$query_var'";

make it

$query=" SELECT FROM games WHERE id = '$query_var'";

davidknag · January 2, 2011

no no no, you need to echo those strings between the body tag.

http://atomicpool.com/play.php?id=1

duhh

it is between body..

etc etc etc

sorry for the misunderstanding

<?php
$con = mysqli_connect('atomicpool.com', 'webuser', 'davidknag', 'games');

if(isset($_GET['id'])){
     $query_var = (int)$_GET['id']; // force it to be an integer

$sql=" SELECT FROM games WHERE id = '$query_var'";

     $result = mysqli_query($con, $query);
     while($row =  mysqli_fetch_array($result)) { //this output should be filtered in a real world
         $string1= '<h2>TITLE: '.$row['title'].'</h2><br />';
         $string2= 'some flash object here with the right variable'.$row['swfname'].'<br />';
         $string3= '<h3>How To: '.$row['howto'].'</h3>';
     }
}

?>
<html>
<head>
<title><?php $row['title'];?> - AtomicPool.com</title>
<link rel="icon" type="image/png" href="icon.png">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<link href="style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><img src="images/index_01.jpg" alt="" width="1000" height="217" border="0" usemap="#Map"></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><a href="index.html" onmouseover="document.home.src='images/hover_02.gif'" onmouseout="document.home.src='images/index_02.gif'""><img name="home" src="images/index_02.gif" alt="" width="269" height="55" border="0"></a></td>
        <td><a href="gl.html"onmouseover="document.gl.src='images/hover_03.gif'" onmouseout="document.gl.src='images/index_03.gif'""><img name="gl" src="images/index_03.gif" alt="" width="159" height="55" border="0"></a></td>
        <td><a href="about.html"onmouseover="document.about.src='images/hover_04.gif'" onmouseout="document.about.src='images/index_04.gif'""><img name="about" src="images/index_04.gif" alt="" width="177" height="55" border="0"></a></td>
        <td><a href="contact.php"onmouseover="document.contact.src='images/hover_05.gif'" onmouseout="document.contact.src='images/index_05.gif'""><img name="contact" src="images/index_05.gif" alt="" width="168" height="55" border="0"></a></td>
        <td><a href="http://AtomicPool.com/blog/"onmouseover="document.blog.src='images/hover_06.gif'" onmouseout="document.blog.src='images/index_06.gif'""><img name="blog" src="images/index_06.gif" alt="" width="227" height="55" border="0"></a></td>
      </tr>
    </table></td>
  </tr>
</table>
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#01151E"><table width="100%" border="0" cellspacing="10" cellpadding="0">
      <tr>
        <td width="10%"> </td>
        <td width="81%"><table width="100%" border="0" cellspacing="10" cellpadding="0">
          <tr>
            <td width="11%" rowspan="2"><img src="images/index_09.jpg" width="111" height="114" alt=""></td>
            <td width="89%"><strong>The website is in a its test development state. If you find any bugs, please Report a bug.</strong></td>
          </tr>
          <tr>
            <td><a href="contact.php"><img src="images/index_12.gif" alt="" width="110" height="24" border="0"></a></td>
          </tr>
        </table></td>
        <td width="9%"> </td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><img src="images/index_16.gif" width="1000" height="29" alt=""></td>
  </tr>
  <tr>
    <td class="bg1"><table width="100%" border="0" cellspacing="10" cellpadding="0">
      <tr>
        <td width="10%"> </td>
        <td width="81%"><table width="100%" border="0" cellspacing="10" cellpadding="0">
          <tr>
            <td><table width="100%" border="0" cellpadding="0" cellspacing="10">
              <tr>

                <td><h2 class="blye2"><i></i></h2>
					<?php echo $string1.$string2.$string3;  ?>	  
                <br>
				<br></br>
				<br></br>
				<br></br>
				<br></br>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td><table width="812" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td height="217" background="images/index_24.gif"><table width="100%" border="0" cellspacing="10" cellpadding="0">
                  <tr>
                    <td width="24%"> </td>
                    <td width="76%"><table width="100%" border="0" cellspacing="10" cellpadding="0">
                      <tr>
                        <tr>
                            <td width="33%"><strong>.<br>
                              <br>
                              </strong></td>
                            <td width="33%"><strong>.<br>
                              <br>
                              </strong></td>
                            <td width="34%"><strong>.<br>
                              <br>
                              </strong></td>
                          </tr>
                        </table></td>
                      </tr>
                    </table></td>
                  </tr>
                </table></td>
              </tr>
            </table></td>
          </tr>
        </table></td>
        <td width="9%"> </td>
      </tr>
    </table></td>
  </tr>
</table>
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#005d7b"><table width="100%" border="0" cellspacing="10" cellpadding="0">
      <tr>
        <td width="50%" align="center"><a href="#"><strong></strong></a><strong class="blye-text-regular"></strong></td>
        <td width="50%" align="center">&copy Copyright 2011 AtomicPool.com</td>
      </tr>
    </table></td>
  </tr>
</table>

<map name="Map"><area shape="rect" coords="752,80,885,139" href="http://davidknag.com/"></map></body>
</html>

fortnox007 · January 2, 2011

change $sql in to $query,

than your ready

fortnox007 · January 2, 2011

this should work (i removed tables just to make sure they aren't faking up)

<?php
$con = mysqli_connect('atomicpool.com', 'webuser', 'davidknag', 'games')or die(mysqli_error($con));

if(isset($_GET['id'])){
     $query_var = (int)$_GET['id']; // force it to be an integer

$query=" SELECT FROM games WHERE id = '$query_var'";

     $result = mysqli_query($con, $query)or die(mysqli_error($con));
     while($row =  mysqli_fetch_array($result)) { //this output should be filtered in a real world
         $string1= '<h2>TITLE: '.$row['title'].'</h2><br />';
         $string2= 'some flash object here with the right variable'.$row['swfname'].'<br />';
         $string3= '<h3>How To: '.$row['howto'].'</h3>';
     }
}

?>
<html>
<head>
<title><?php $row['title'];?> - AtomicPool.com</title>
<link rel="icon" type="image/png" href="icon.png">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<link href="style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<?php echo $string1.$string2.$string3; ?>
</body>
</html>

-edit: so $sql is now $query and $dbc is now $con I also added some error reporting stuff.

davidknag · January 2, 2011

. domo

fortnox007 · January 2, 2011

are you sure ::) : ::) i just saw a fancy looking site with all the stuff needed except for howto, but you didnt fill that in in the database

davidknag · January 2, 2011

are you sure : i just saw a fancy looking site

hehehe umm yah the title still doesn't work

edit: changed

$con=" SELECT FROM games WHERE id = '$query_var'";

to

$query=" SELECT * FROM games WHERE id = '$query_var'";

works amazinglyy... except the title is still blank.. :/

<?php
$con = mysqli_connect('localhost', 'webuser', 'davidknag', 'games')or die(mysqli_error($con));

if(isset($_GET['id'])){
     $query_var = (int)$_GET['id']; // force it to be an integer

$query=" SELECT * FROM games WHERE id = '$query_var'";

     $result = mysqli_query($con, $query)or die(mysqli_error($con));
     while($row =  mysqli_fetch_array($result)) { //this output should be filtered in a real world
         $string1= '<h2>TITLE: '.$row['title'].'</h2><br />';
         $string2= 'some flash object here with the right variable'.$row['swfname'].'<br />';
         $string3= '<h3>How To: '.$row['howto'].'</h3>';
     }
}

?>
<html>
<head>
<title><?php $row['title'];?> - AtomicPool.com</title>
<link rel="icon" type="image/png" href="icon.png">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<link href="style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><img src="images/index_01.jpg" alt="" width="1000" height="217" border="0" usemap="#Map"></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><a href="index.html" onmouseover="document.home.src='images/hover_02.gif'" onmouseout="document.home.src='images/index_02.gif'""><img name="home" src="images/index_02.gif" alt="" width="269" height="55" border="0"></a></td>
        <td><a href="gl.html"onmouseover="document.gl.src='images/hover_03.gif'" onmouseout="document.gl.src='images/index_03.gif'""><img name="gl" src="images/index_03.gif" alt="" width="159" height="55" border="0"></a></td>
        <td><a href="about.html"onmouseover="document.about.src='images/hover_04.gif'" onmouseout="document.about.src='images/index_04.gif'""><img name="about" src="images/index_04.gif" alt="" width="177" height="55" border="0"></a></td>
        <td><a href="contact.php"onmouseover="document.contact.src='images/hover_05.gif'" onmouseout="document.contact.src='images/index_05.gif'""><img name="contact" src="images/index_05.gif" alt="" width="168" height="55" border="0"></a></td>
        <td><a href="http://AtomicPool.com/blog/"onmouseover="document.blog.src='images/hover_06.gif'" onmouseout="document.blog.src='images/index_06.gif'""><img name="blog" src="images/index_06.gif" alt="" width="227" height="55" border="0"></a></td>
      </tr>
    </table></td>
  </tr>
</table>
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#01151E"><table width="100%" border="0" cellspacing="10" cellpadding="0">
      <tr>
        <td width="10%"> </td>
        <td width="81%"><table width="100%" border="0" cellspacing="10" cellpadding="0">
          <tr>
            <td width="11%" rowspan="2"><img src="images/index_09.jpg" width="111" height="114" alt=""></td>
            <td width="89%"><strong>The website is in a its test development state. If you find any bugs, please Report a bug.</strong></td>
          </tr>
          <tr>
            <td><a href="contact.php"><img src="images/index_12.gif" alt="" width="110" height="24" border="0"></a></td>
          </tr>
        </table></td>
        <td width="9%"> </td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><img src="images/index_16.gif" width="1000" height="29" alt=""></td>
  </tr>
  <tr>
    <td class="bg1"><table width="100%" border="0" cellspacing="10" cellpadding="0">
      <tr>
        <td width="10%"> </td>
        <td width="81%"><table width="100%" border="0" cellspacing="10" cellpadding="0">
          <tr>
            <td><table width="100%" border="0" cellpadding="0" cellspacing="10">
              <tr>

                <td><h2 class="blye2"><i></i></h2>
					<?php echo $string1.$string2.$string3;  ?>	  
                <br>
				<br></br>
				<br></br>
				<br></br>
				<br></br>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td><table width="812" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td height="217" background="images/index_24.gif"><table width="100%" border="0" cellspacing="10" cellpadding="0">
                  <tr>
                    <td width="24%"> </td>
                    <td width="76%"><table width="100%" border="0" cellspacing="10" cellpadding="0">
                      <tr>
                        <tr>
                            <td width="33%"><strong>.<br>
                              <br>
                              </strong></td>
                            <td width="33%"><strong>.<br>
                              <br>
                              </strong></td>
                            <td width="34%"><strong>.<br>
                              <br>
                              </strong></td>
                          </tr>
                        </table></td>
                      </tr>
                    </table></td>
                  </tr>
                </table></td>
              </tr>
            </table></td>
          </tr>
        </table></td>
        <td width="9%"> </td>
      </tr>
    </table></td>
  </tr>
</table>
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#005d7b"><table width="100%" border="0" cellspacing="10" cellpadding="0">
      <tr>
        <td width="50%" align="center"><a href="#"><strong></strong></a><strong class="blye-text-regular"></strong></td>
        <td width="50%" align="center">&copy Copyright 2011 AtomicPool.com</td>
      </tr>
    </table></td>
  </tr>
</table>

<map name="Map"><area shape="rect" coords="752,80,885,139" href="http://davidknag.com/"></map></body>
</html>

fortnox007 · January 2, 2011

lol place echo infront of it! (read some about php btw lols)

<title><?php echo $row['title'];?></title>

davidknag · January 2, 2011

lol place echo infront of it! (read some about php btw lols)
<title><?php echo $row['title'];?></title>

LOL

haha i feel stupid

fortnox007 · January 2, 2011

nice ::) lol, good luck mate

nice looking site btw, (despite the interesting use of tables ::) )

davidknag · January 2, 2011

nice lol, good luck mate

nice looking site btw, (despite the interesting use of tables )

hmm...

<?php
$con = mysqli_connect('localhost', 'webuser', 'davidknag', 'games')or die(mysqli_error($con));

if(isset($_GET['id'])){
     $query_var = (int)$_GET['id']; // force it to be an integer

$query=" SELECT * FROM games WHERE id = '$query_var'";

     $result = mysqli_query($con, $query)or die(mysqli_error($con));
     while($row =  mysqli_fetch_array($result)) { //this output should be filtered in a real world
         $string1= '<td><h2 class="blye2"><i>'.$row['title'].'</i></h2><br />';
         $string2= 'dd'.$row['swfname'].'<br />';
         $string3= 'Description: '.$row['description'].'<br/>';
	 $string4= 'How To: '.$row['howto'].'</h3>';
     }
}

?>
<html>
<head>
<title><?php echo $row['title'];?> - AtomicPool.com</title>

nope

Sign In

Game Playing System

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information