PHP Help: outputting "Array"

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Sakaki
Forum Newbie
Posts: 12
Joined: Mon Dec 02, 2002 12:37 pm

PHP Help: outputting "Array"

Post by Sakaki »

Does anyone know why php will output the word "array" when pulling information from a table? Here's an example http://www.rpgdb.com/view_game.php?game_id=37 . All the information for the entry is outputted correctly except for the theme field. It seems to only be occurring with recent entries that are added. I checked the code and table but can't seem to figure out why it does this. Any help?
User avatar
cheatboy00
Forum Contributor
Posts: 151
Joined: Sat Jun 29, 2002 10:36 am
Location: canada
Contact:

Post by cheatboy00 »

um I'm not totally sure the problem but it could be that your actually putting Array and not $Array, or somthing along those lines. It would help if you showed the lines of code that has that in it.

also about this website does/will it include online RPG's?
Sakaki
Forum Newbie
Posts: 12
Joined: Mon Dec 02, 2002 12:37 pm

Post by Sakaki »

here's the code for the submit.php page:

Code: Select all

<?php
<?
include "include_fns.php";
if(!$userdata['session_logged_in']) {		// checks if user is logged in
	header("Location: forum/login.php?redirect=../submit.php");
	exit;
}
include "header.php";

if (!isset($submit)) {
?>

<script type="text/javascript" language="JavaScript" src="sub_popup.js"></script>


<!--Content Top-->

<table bgcolor="#FFFFFF" border=0 cellspacing=0 cellpadding=5 width=100%>


<form enctype="multipart/form-data" action="submit.php" method="post">

<tr>
	<td bgcolor=#000000 colspan=2><font size=2 color=#FFFFFF><b>Game Entry</b></font></td>

</tr>

<tr>
	<td bgcolor=#FFFFFF colspan=2>To add a new rpg to the database please enter information in the fields below. Use commas for multiple information in a field.  Please note required fields are noted with a * .</td>
</tr>

<tr>
	<td>&nbsp;<b>Game Name:</b></td>
	<td><input type=text name=game_name maxlength=100 size=30>*<br></td>
</tr>

<tr>
	<td>&nbsp;<b>Box Art Front:</b></td>
	<td><input type="file" name="box_front" size="30"> <font size=-2><a href="javascript:popUp('refs/uploads.html')"><b>Uploading Guidelines</b></a></font></td>
</tr>

<tr>
	<td>&nbsp;<b>Box Art Back:</b></td>
	<td><input type="file" name="box_back" size="30"></td>
</tr>

<tr>
	<td>&nbsp;<b>Platform (s):</b></td>
	<td><input type=text name=platform maxlength=100 size=30>* <font size=-2><a href="javascript:popUp('refs/platforms.html')"><b>See List</b></a></font></td>
</tr>

<tr>
	<td>&nbsp;<b>Publisher:</b></td>
	<td><input type=text name=publisher maxlength=100 size=30><br></td>
</tr>

<tr>
	<td>&nbsp;<b>Developer:</b></td>
	<td><input type=text name=developer maxlength=100 size=30><br></td>
</tr>

<tr>
	<td>&nbsp;<b>Country(s):</b></td>
	<td><input type=text name=country maxlength=100 size=30> <font size=-2><a href="javascript:popUp('refs/countries.html')"><b>See List</b></a></font></td>
</tr>

<tr>
	<td>&nbsp;<b>Release Year:</b></td>
	<td><input type=text name=release_date maxlength=100 size=10></td>
</tr>

<tr>
	<td>&nbsp;<b>Availability:</b></td>
	<td><select name="availability">
		<option value="">--Select Availability--</option>
		<option value="Yes">Yes</option>
		<option value="No">No</option>
		</select>
	</td>
</tr>


<tr>
	<td>&nbsp;<b>Director:</b></td>
	<td><input type=text name=director maxlength=100 size=30><br></td>
</tr>

<tr>
	<td>&nbsp;<b>Lead Artist:</b></td>
	<td><input type=text name=lead_artist maxlength=100 size=30><br></td>
</tr>

<tr>
	<td>&nbsp;<b>Concept Designer:</b></td>
	<td><input type=text name=concept_des maxlength=100 size=30><br></td>
</tr>

<tr>
	<td>&nbsp;<b>Music Composer:</b></td>
	<td><input type=text name=music_comp maxlength=100 size=30><br></td>
</tr>

<tr>
	<td>&nbsp;<b>Genre:</b></td>
	<td><input type=text name=music_comp maxlength=100 size=30> <font size=-2><a href="javascript:popUp('refs/genres.html')"><b> See List</b></a></font>
		</td>
</tr>

<tr>
	<td>&nbsp;<b>Theme:</b></td>
	<td><select name="theme">
		<option value="">--Select Theme--</option>
		<option value="Fantasy">Fantasy</option>
		<option value="Medieval">Medieval</option>
		<option value="Sci-Fi">Sci-Fi</option>
		<option value="Cyberpunk">Cyberpunk</option>
		<option value="Post Apocalyptic">Post Apocalyptic</option>
		<option value="Mech">Mech</option>
		<option value="Horror">Horror</option>
		<option value="Western">Western</option>
		<option value="Japanese">Japanese</option>
		<option value="Anime">Anime</option>
		<option value="Thriller">Thriller</option>
		<option value="Mystery">Mystery</option>
		<option value="Dating Sim">Dating Sim</option>
		<option value="Unique">Unique</option>
		</select>
		
		</td>
</tr>

<tr>
	<td>&nbsp;<b>Number of Players:</b></td>
	<td><select name="num_players">
		<option value="1">1</option>
		<option value="2">2</option>
		<option value="3">3</option>
		<option value="4">4</option>
		<option value="0">Unlimited</option>
		</select>
	<br></td>
</tr>

<tr>
	<td>&nbsp;<b>Graphics:</b></td>
	<td><select name="graphics">
		<option value="">--Select Graphics--</option>
		<option value="3D">3D</option>
		<option value="2D">2D</option>
		<option value="text">Text</option>
		</select>
		<font size=-2><a href="javascript:popUp('refs/graphics.html')"><b> Description</b></a></font>
	<br></td>
</tr>

<tr>
	<td>&nbsp;<b>View:</b></td>
	<td><select name="view">
		<option value="">--Select View--</option>
		<option value="Isometic">Isometric</option>
		<option value="Overhead">Overhead</option>
		<option value="Platform">Platform</option>
		<option value="Side-Scroler">Side Scroller</option>
		<option value="First-Person">First Person</option>
		<option value="3rd-Person">Third Person</option>
		</select>
		<font size=-2><a href="javascript:popUp('refs/view.html')"><b> Description</b></a></font>
		</td>
</tr>

<tr>
	<td>&nbsp;<b>Game Description:</b></td>
	<td><TEXTAREA NAME="game_desc" ROWS=10 COLS=30></TEXTAREA>*<br></td>
</tr>

<tr>
	<td>&nbsp;<b>Screenshot 1:</b></td>
	<td><input type="file" name="screen01" size="30"> <font size=-2><a href="javascript:popUp('refs/uploads.html')"><b>Uploading Guidelines</b></a></font></td>
</tr>


<tr>
	<td>&nbsp;<b>Screenshot 2:</b></td>
	<td><input type="file" name="screen02" size="30"></td>
</tr>


<tr>
	<td>&nbsp;<b>Screenshot 3:</b></td>
	<td><input type="file" name="screen03" size="30"></td>
</tr>

<tr>
	<td>&nbsp;<b>Link 1:</b></td>
	<td><input type="text" name="link01" size="30"></td>
</tr>

<tr>
	<td>&nbsp;<b>Link 2:</b></td>
	<td><input type="text" name="link02" size="30"></td>
</tr>

<tr>
	<td>&nbsp;<b>Link 3:</b></td>
	<td><input type="text" name="link03" size="30"></td>
</tr>

<tr>
	<td colspan=2 align="center">
<input type=hidden name="MAX_FILE_SIZE" value="25000">
<input type=hidden name="game_id" value="<? print $game_id ?>">
<input type=submit name="submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</div>

	</td>
</tr>
</table>

<?
	
	} else {

	if (!db_connect()) {
		print "Error: could not connet to the database.  Please try again later.";
		exit;
	}
	
	switch (false) {
		case $game_name:
			print "<br>Please go <a href="submit.php">back</a> and enter a game name";
			exit;
		case $platform:
			print "<br>Please go <a href="submit.php">back</a> and enter a platform";
			exit;
		case $game_desc:
			print "<br>Please go <a href="submit.php">back</a> and enter a short description of the game";
			exit;
	}
	
	if ($_FILES['box_front']['tmp_name'] != "") {
		copy($_FILES['box_front']['tmp_name'], "ul_imgs/".$_FILES['box_front']['name']) 
		or die("Couldn't copy the file!");
	}
	
	if ($_FILES['box_back']['tmp_name'] != "") {
		copy($_FILES['box_back']['tmp_name'], "ul_imgs/".$_FILES['box_back']['name']) 
		or die("Couldn't copy the file!");
	}

	if ($_FILES['screen01']['tmp_name'] != "") {
		copy($_FILES['screen01']['tmp_name'], "ul_imgs/".$_FILES['screen01']['name']) 
		or die("Couldn't copy the file!");
	}
	
	if ($_FILES['screen02']['tmp_name'] != "") {
		copy($_FILES['screen02']['tmp_name'], "ul_imgs/".$_FILES['screen02']['name']) 
		or die("Couldn't copy the file!");
	}
	
	if ($_FILES['screen03']['tmp_name'] != "") {
		copy($_FILES['screen03']['tmp_name'], "ul_imgs/".$_FILES['screen03']['name']) 
		or die("Couldn't copy the file!");
	}
	
	$game_name = addslashes($game_name);
	$box_front = "ul_imgs/".$_FILES['box_front']['name'];
	$box_back = "ul_imgs/".$_FILES['box_back']['name'];
	$platform = addslashes($platform);
	$publisher = addslashes($publisher);
	$developer = addslashes($developer);
	$country  = addslashes($country );
	$release_date = addslashes($release_date);
	$availability = addslashes($availability);
	$director = addslashes($director);
	$lead_artist = addslashes($lead_artist);
	$concept_des = addslashes($concept_des);
	$music_comp = addslashes($music_comp);
	$genre = addslashes($genre);
	$theme = addslashes($theme);
	$num_player = addslashes($num_players);
	$graphics = addslashes($graphics);	
	$view = addslashes($view);	
	$game_desc = addslashes($game_desc);
	$screen01 = "ul_imgs/".$_FILES['screen01']['name'];
	$screen02 = "ul_imgs/".$_FILES['screen02']['name'];
	$screen03 = "ul_imgs/".$_FILES['screen03']['name'];
	
	$query = "insert into game_info (game_name, box_front, box_back, platform, publisher, developer, country, release_date, availability, director, lead_artist, concept_des, music_comp, genre, theme, num_players, graphics, view, game_desc, screen01, screen02, screen03, last_update_by) values ('".$game_name."', '".$box_front."', '".$box_back."', '".$platform."', '".$publisher."', '".$developer."', '".$country."', '".$release_date."', '".$availability."', '".$director."', '".$lead_artist."', '".$concept_des."', '".$music_comp."', '".$genre."', '".$theme."', '".$num_players."', '".$graphics."', '".$view."', '".$game_desc."','".$screen01."','".$screen02."','".$screen03."','".$auth_user."')";
	$result = mysql_query($query);
	
	if ($result) {
		echo mysql_affected_rows()." game added to the queue.";
	} else {
		echo $query;
	}
	
	$query = "select game_id from game_info order by last_update desc limit 1";
	$result = mysql_query($query);
	$row = mysql_fetch_array($result);
	
	$num_links=0;
	
	if ($link01) {
		$query = "insert into links (game_id, link_url, link_name) values ('".$row[0]."','".$link01."','".$link01."')";
		$result = mysql_query($query);
		if ($result) {
			$num_links += 1;
		}
	}
	
	if ($link02) {
		$query = "insert into links (game_id, link_url, link_name) values ('".$row[0]."','".$link02."','".$link02."')";
		$result = mysql_query($query);
		if ($result) {
			$num_links += 1;
		}
	}
	
	if ($link03) {
		$query = "insert into links (game_id, link_url, link_name) values ('".$row[0]."','".$link03."','".$link03."')";
		$result = mysql_query($query);
		if ($result) {
			$num_links += 1;
		}
	}
	
	if ($num_links) {
		print "<br>". $num_links ." link(s) added.";
	}
	
	print "<BR><BR><BR><BR> -> <a href="index.php"><b>View Games</b></a>";
	
	}
?>


</body>
</html>

?>
Sakaki
Forum Newbie
Posts: 12
Joined: Mon Dec 02, 2002 12:37 pm

Post by Sakaki »

Here's the code for the view_game.php page where the games are displayed..

Code: Select all

<?php
<?
include "include_fns.php";
include "header.php";

if (!db_connect()) {
	die("Could not connect to database!");
}
$query = "select * from game_info where game_id = $game_id";
$result = mysql_query($query);
if (!$result) {
	die(do_mysql_err()."<br>".$query.";");
}
$row = mysql_fetch_array($result);

print "<table bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=5 width=100%>\n";
print "<tr><td>\n";
print "<table bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=4 width=100%>\n";
print "<tr><td><font face=arial size=+1><b><u>$row[game_name]</u></b></font></td></tr>\n";
print "<tr><td valign=top>
<b>Platform(s)</b><br>$row[platform] <BR><BR> 
<b>Publisher</b><br>$row[publisher] <BR><BR>
<b>Developer</b><br>$row[developer] <BR><BR>
<b>Country(s)</b> <br>$row[country] <BR><BR>
<b>Release Date</b> <BR>$row[release_date] <BR><BR>
<b>Availability</b> <BR>$row[availability]<BR><BR>
</td>\n";

print "<td valign=top>
<b>Genre</b> <BR>$row[genre] <BR><BR>
<b>Theme</b> <BR>$row[theme] <BR><BR>
<b>Number of Players</b> <BR>$row[num_players] <BR><BR>
<b>Graphics</b> <BR>$row[graphics]<BR><BR>
<b>View</b> <BR>$row[view] <BR><BR>
</td>\n";

print "<td valign=top>
<b>Director</b><BR> $row[director] <BR><BR>
<b>Lead Artist</b><BR> $row[lead_artist] <BR><BR>
<b>Concept Designer</b><BR> $row[concept_des] <BR><BR>
<b>Music Composer</b><BR> $row[music_comp] <BR><BR>
</td></tr></table>\n";

print "<table bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=4 width=100%>\n";
print "<tr><td><b><u>Game Description</u></b></td></tr>\n";
print "<tr><td>".stripslashes($row[game_desc])."</td></tr></table>\n";

// average user rating
$query = "select * from ratings where game_id = $game_id";
$result = mysql_query($query);

if (!$result) {
	print "Error: no results returned (rating)";
}

$num_ratings = mysql_num_rows($result);

if ($num_ratings) {
	for ($i=0; $i<$num_ratings; $i++) {
		$rating = mysql_fetch_array($result);
		$total += $rating[rating];
	}
	
	$average = $total / $num_ratings;

	print "<BR><table bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=4 width=100%>
	<tr><td><b>Average User Rating: ".round($average)."</b> </td></tr></table>\n";
}
?>

<form action="rate.php" method="post">
<table cellpadding=0 cellspacing=0 border=0><tr>
	<td><b>Rate This Game:</b></td>
	<td>&nbsp;&nbsp;<select name="rating">
		<option value="1">1
		<option value="2">2
		<option value="3">3
		<option value="4">4
		<option value="5">5
	<br></td>
	<td>&nbsp;&nbsp;<input type=hidden name="game_id" value=<?print $game_id?>><input type="submit" value="Rate It"></td>
</tr></table>
</form>

<?
print "<table bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=4 width=100%>
<tr><td><b><u>User Opinions</u> | <a href="add_opinion.php?game_id=$game_id">Add Your Own</a></b>";

// user opinions

$query = "select * from opinions where game_id = $game_id";
$result = mysql_query($query);

if (!$result) {
	print "Error: no results returned (links)";
}
for ($i=0; $i<mysql_num_rows($result); $i++) {
	$opinion = mysql_fetch_array($result);
	print "<br><br><i>Posted by <b>$opinion[username]</b></i><br>".stripslashes($opinion[opinion]);
}

print "</td></tr></table></td>\n";


print "<td valign=top><table bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=4 width=100%><tr><td><a href="$row[box_front]"><img src="$row[box_front]" height=200></a></td><td><a href="$row[box_back]"><img src="$row[box_back]" height=200></a></td></tr></table>\n";

print "<BR><BR><table bgcolor=#666666 border=0 cellspacing=0 cellpadding=1 width=100%>\n";
	
print "<tr><td><font color=#FFFFFF><b><u>Screenshots</u></b></font></td></tr><tr>\n";
print "<td><table border=0 cellspacing=0 cellpadding=4 width=100%>\n";
print "<tr><td bgcolor=#FFFFFF align=center><a href="javascript:popUp('$row[screen01]')"><img src="$row[screen01]" width=160 height=112 border=0></a></td>
<td bgcolor=#FFFFFF align=center><a href="javascript:popUp('$row[screen02]')"><img src="$row[screen02]" width=160 height=112 border=0></a></td><td bgcolor=#FFFFFF align=center><a href="javascript:popUp('$row[screen03]')"><img src="$row[screen03]" width=160 height=112 border=0></a></td></tr></table></td></tr></table>\n";

print "<BR><table border=0 cellspacing=0 cellpadding=4 width=100%>
<tr><td align=left bgcolor=#FFFFFF><b><u>Web Links</u></b></td></tr><tr><td>\n";

// links
$query = "select * from links where game_id = $game_id";
$result = mysql_query($query);

if (!$result) {
	print "Error: no results returned (links)";
}
for ($i=0; $i<mysql_num_rows($result); $i++) {
	$link = mysql_fetch_array($result);
	print "<b><a href="$link[link_url]">$link[link_name]</a></b><br>";
}

print "</td></tr></table></td></tr>
</table>\n";

?>

</body>
</html>

?>
Sakaki
Forum Newbie
Posts: 12
Joined: Mon Dec 02, 2002 12:37 pm

Post by Sakaki »

Yes the site will cover online rpgs too..
Post Reply