Hi there

Me and my other half have a website for our game server...we would like to show stats that relate to the game that are stored on a SQL database on the website...any help would be appreciated

Thanks

I am still a novice so I'm not 100% sure but I believe you can do that with PHP.

How do you collect your stats, is this user input?

Ibbo

Yea php would work...use this (Change DB_HOST, DB_USERNAME, DB_PASSWORD, and DB_NAME to fit your specific database details.)

<?php

if (isset($_POST['submitted']))
{
if (!empty($_POST['gametitle']))
{
$gt = $_POST['gametitle'];

@mysql_connect (DB_HOST, DB_USERNAME, DB_PASSWORD) or die('Error');

@mysql_select_db (DB_NAME) or die ('Error');

$query = "SELECT column_name FROM table_name WHERE column_name='%$gt%'";

$result = @mysql_query($query);

if (mysql_num_rows($result) > 0)
{

$data = mysql_fetch_array($result, MYSQL_NUM);

foreach($data as $dbdata)
{
echo "<br><br>" . $dbdata;
}
}
else
{
echo "No results found";
}
}
else
{
echo "Please specify a game title!";
}
}

?>

<form action="" method="post">
Search game: <input type="text" name="gametitle"><br>
<input type="submit" name="submit" value="Search">
<input type="hidden" name="submitted" value="TRUE">
</form>

Originally Posted by JLEville

Yea php would work...use this (Change DB_HOST, DB_USERNAME, DB_PASSWORD, and DB_NAME to fit your specific database details.)

<?php

if (isset($_POST['submitted']))
{
if (!empty($_POST['gametitle']))
{
$gt = $_POST['gametitle'];

@mysql_connect (DB_HOST, DB_USERNAME, DB_PASSWORD) or die('Error');

@mysql_select_db (DB_NAME) or die ('Error');

$query = "SELECT column_name FROM table_name WHERE column_name='%$gt%'";

$result = @mysql_query($query);

if (mysql_num_rows($result) > 0)
{

$data = mysql_fetch_array($result, MYSQL_NUM);

foreach($data as $dbdata)
{
echo "<br><br>" . $dbdata;
}
}
else
{
echo "No results found";
}
}
else
{
echo "Please specify a game title!";
}
}

?>

<form action="" method="post">
Search game: <input type="text" name="gametitle"><br>
<input type="submit" name="submit" value="Search">
<input type="hidden" name="submitted" value="TRUE">
</form>

Nice post . This will be helpful to me. I am learning PHP now so every tip helps!

Add to my talkapation man!

Originally Posted by JLEville

Add to my talkapation man!

Done!! Sorry about, still new here, learning the ropes and the lingo .

It was a good post definitely worth the talkaptation!