Table and white spaces

xoligy · March 3, 2010

Ok i have used a form to enter data into the db, now some of the fields i had to enter are blank. So when i called back the data from the db into a table i have horrid white spaces, whats the best way to deal with these?

Calling the data:

$missions = mysql_query("select * from missions where location='jersey'");
echo "<table border='1' width='750px'>";
echo "<tr><td colspan='9' align='center'>Missions</td></tr>";
echo "<tr><td>Mission</td><td>Level</td><td>Location</td><td>Loot</td><td>Total Ngy</td><td>bronze</td><td>bronze</td><td>bronze</td><td>bronze</td></tr>";
while($row = mysql_fetch_array( $missions )) {
echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
}

Entering the data:

if (!function_exists("cln")) {
   function cln( $value ){
    if( get_magic_quotes_gpc() ){
           $value = stripslashes( $value );
         }
         //check if this function exists
         if( function_exists( "mysql_real_escape_string" ) ) 
         {
           $value = mysql_real_escape_string(trim(strip_tags(htmlspecialchars(( $value )))));
         }
         //for PHP version < 4.3.0 use addslashes
         else
         {
           $value = addslashes( $value );
         } 
         return $value;
     }
}
if($addmission){
$mission = cln($mission);
$location = cln($location);
$loot = cln($loot);
$level = cln($level);
$energy = cln($energy);
$energy1 = cln($energy1);
$bronze = cln($bronze);
$silver = cln($silver);
$gold = cln($gold);
$platinum = cln($platinum);
$result = mysql_query("INSERT INTO `missions` (`id`, `mission`, `location`, `loot`, `level`, `energy`, `energy1`, `bronze`, `silver`, `gold`, `platinum`) VALUES (NULL, '".$mission."', '".$location."', '".$loot."', '".$level."', '".$energy."', '".$energy1."', '".$bronze."', '".$silver."', '".$gold."', '".$platinum."')")
or die (mysql_error());
//echo $result;
}

Thanks for any help in advance

aeroswat · March 3, 2010

Ok i have used a form to enter data into the db, now some of the fields i had to enter are blank. So when i called back the data from the db into a table i have horrid white spaces, whats the best way to deal with these?

Calling the data:

$missions = mysql_query("select * from missions where location='jersey'");
echo "<table border='1' width='750px'>";
echo "<tr><td colspan='9' align='center'>Missions</td></tr>";
echo "<tr><td>Mission</td><td>Level</td><td>Location</td><td>Loot</td><td>Total Ngy</td><td>bronze</td><td>bronze</td><td>bronze</td><td>bronze</td></tr>";
while($row = mysql_fetch_array( $missions )) {
echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
}

Entering the data:

if (!function_exists("cln")) {
   function cln( $value ){
    if( get_magic_quotes_gpc() ){
           $value = stripslashes( $value );
         }
         //check if this function exists
         if( function_exists( "mysql_real_escape_string" ) ) 
         {
           $value = mysql_real_escape_string(trim(strip_tags(htmlspecialchars(( $value )))));
         }
         //for PHP version < 4.3.0 use addslashes
         else
         {
           $value = addslashes( $value );
         } 
         return $value;
     }
}
if($addmission){
$mission = cln($mission);
$location = cln($location);
$loot = cln($loot);
$level = cln($level);
$energy = cln($energy);
$energy1 = cln($energy1);
$bronze = cln($bronze);
$silver = cln($silver);
$gold = cln($gold);
$platinum = cln($platinum);
$result = mysql_query("INSERT INTO `missions` (`id`, `mission`, `location`, `loot`, `level`, `energy`, `energy1`, `bronze`, `silver`, `gold`, `platinum`) VALUES (NULL, '".$mission."', '".$location."', '".$loot."', '".$level."', '".$energy."', '".$energy1."', '".$bronze."', '".$silver."', '".$gold."', '".$platinum."')")
or die (mysql_error());
//echo $result;
}

Thanks for any help in advance

You have whitespaces because of an empty field? Uhh... You are using a table so really you can't do anything about it... What are you trying to do? Eliminate that part of the table? You could have css make it look like its not there if the field is blank. But if you completely got rid of the tag it would make your table look like it's not supposed to.

jtgraphic · March 3, 2010

run a quick check to see if there is data, and if there isn't put in a non-breaking space: " "

I'm not sure if that's what you're looking for?

aeroswat · March 3, 2010

run a quick check to see if there is data, and if there isn't put in a non-breaking space: " "

That's just some more white space

I'm not sure if that's what you're looking for?

This is the real answer

jtgraphic · March 3, 2010

Thanks, lol

I wasn't sure if he was trying to fix that issue where a cell doesn't have any contents and it just shows the 'upper' part of a 3d border. I was just grasping. I suspect that once we find out the specifics of the question, the answer will be easy.

aeroswat · March 3, 2010

Thanks, lol

I wasn't sure if he was trying to fix that issue where a cell doesn't have any contents and it just shows the 'upper' part of a 3d border. I was just grasping. I suspect that once we find out the specifics of the question, the answer will be easy.

Ya this is a question where he should provide more information because what he currently seems to be asking for is a very simple answer.

xoligy · March 3, 2010

Sorry should of posted an image of what i ment, i suppose the " " would work yes, and i guess i could add a condition that if the field is empty to echo " " in that empty field?

Anyway here is a screenshot of the table and very basic site one row has the suggested answer in the first row and the second row how it normally would look (guess this issue is solved)

http://img515.imageshack.us/img515/9631/whitespaces.png

Next question is, im doing things by clicking a link 'missions.php?action=whatever' and the page displays the info required. Is tehre away to remove the links from the bottom without it messing up the layout? exit; } removes the css footer.

jtgraphic · March 3, 2010

I'm not really clear on what you're after, but if you're just looking to remove the links, why not just remove your echo statement? Can I see the code for the whole page?

xoligy · March 3, 2010

Sure!

<?php
session_start();
if (!isset($_SESSION['username'])) {
header("Location: login.php");
}
include('db.php');
include('process.php');  
?>
<title><?=$title?></title>
<link rel="stylesheet" href="style.css" type="text/css" media="screen" />
<div id="container">
    <div id="header">
        <h1>
            Site name
        </h1>
    </div>
    <div id="navigation">
        <ul>
            <li><a href="index.php">Home</a></li>
            <li><a href="#">About</a></li>
            <li><a href="#">Services</a></li>
            <li><a href="#">Contact us</a></li>
        </ul>
    </div>
    <div id="content-container">
        <div id="section-navigation">
            <ul>
                <?include'left.php';?>
            </ul>
        </div>
        <div id="content">
<? 
if($action=='all'){
$missions = mysql_query("select * from missions");
echo "<table border='1' width='750px'>";
echo "<tr><td colspan='9' align='center'>Missions</td></tr>";
echo "<tr><td>Mission</td><td>Level</td><td>Location</td><td>Loot</td><td>Total Ngy</td><td>bronze</td><td>bronze</td><td>bronze</td><td>bronze</td></tr>";
while($row = mysql_fetch_array( $missions )) {
echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
}
echo "</table>";
}
if($action=='bronx'){
$missions = mysql_query("select * from missions where location='bronx'");
echo "<table border='1' width='750px'>";
echo "<tr><td colspan='9' align='center'>Missions</td></tr>";
echo "<tr><td>Mission</td><td>Level</td><td>Location</td><td>Loot</td><td>Total Ngy</td><td>bronze</td><td>bronze</td><td>bronze</td><td>bronze</td></tr>";
while($row = mysql_fetch_array( $missions )) {
echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
}
echo "</table>";
}
if($action=='downtown'){
$missions = mysql_query("select * from missions where location='downtown'");
echo "<table border='1' width='750px'>";
echo "<tr><td colspan='9' align='center'>Missions</td></tr>";
echo "<tr><td>Mission</td><td>Level</td><td>Location</td><td>Loot</td><td>Total Ngy</td><td>bronze</td><td>bronze</td><td>bronze</td><td>bronze</td></tr>";
while($row = mysql_fetch_array( $missions )) {
echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
}
echo "</table>";
}
if($action=='jersey'){
$missions = mysql_query("select * from missions where location='jersey'");
echo "<table border='1' width='750px'>";
echo "<tr><td colspan='9' align='center'>Missions</td></tr>";
echo "<tr><td>Mission</td><td>Level</td><td>Location</td><td>Loot</td><td>Total Ngy</td><td>bronze</td><td>bronze</td><td>bronze</td><td>bronze</td></tr>";
while($row = mysql_fetch_array( $missions )) {
echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
}
echo "</table>";
}
if($action=='vegas'){
$missions = mysql_query("select * from missions where location='las vegas'");
echo "<table border='1' width='750px'>";
echo "<tr><td colspan='9' align='center'>Missions</td></tr>";
echo "<tr><td>Mission</td><td>Level</td><td>Location</td><td>Loot</td><td>Total Ngy</td><td>bronze</td><td>bronze</td><td>bronze</td><td>bronze</td></tr>";
while($row = mysql_fetch_array( $missions )) {
echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
}
echo "</table>";
}
if($action=='miami'){
$missions = mysql_query("select * from missions where location='miami'");
echo "<table border='1' width='750px'>";
echo "<tr><td colspan='9' align='center'>Missions</td></tr>";
echo "<tr><td>Mission</td><td>Level</td><td>Location</td><td>Loot</td><td>Total Ngy</td><td>bronze</td><td>bronze</td><td>bronze</td><td>bronze</td></tr>";
while($row = mysql_fetch_array( $missions )) {
echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
}
echo "</table>";
}
if($action=='chinatown'){
$missions = mysql_query("select * from missions where location='chinatown'");
echo "<table border='1' width='750px'>";
echo "<tr><td colspan='9' align='center'>Missions</td></tr>";
echo "<tr><td>Mission</td><td>Level</td><td>Location</td><td>Loot</td><td>Total Ngy</td><td>bronze</td><td>bronze</td><td>bronze</td><td>bronze</td></tr>";
while($row = mysql_fetch_array( $missions )) {
echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
}
echo "</table>";
}
if($action=='coney island'){
$missions = mysql_query("select * from missions where location='coney island'");
echo "<table border='1' width='750px'>";
echo "<tr><td colspan='9' align='center'>Missions</td></tr>";
echo "<tr><td>Mission</td><td>Level</td><td>Location</td><td>Loot</td><td>Total Ngy</td><td>bronze</td><td>bronze</td><td>bronze</td><td>bronze</td></tr>";
while($row = mysql_fetch_array( $missions )) {
echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
}
echo "</table>";
}
if($action=='moscow'){
$missions = mysql_query("select * from missions where location='moscow'");
echo "<table border='1' width='750px'>";
echo "<tr><td colspan='9' align='center'>Missions</td></tr>";
echo "<tr><td>Mission</td><td>Level</td><td>Location</td><td>Loot</td><td>Total Ngy</td><td>bronze</td><td>bronze</td><td>bronze</td><td>bronze</td></tr>";
while($row = mysql_fetch_array( $missions )) {
echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
}
echo "</table>";
}
?>

<table>
<tr>
<td><a href='missions.php?action=all'>All</a></td>
</tr>
<tr>
<td><a href='missions.php?action=bronx'>Bronx</a></td>
</tr>
<tr>
<td><a href='missions.php?action=downtown'>Downtown</a></td>
</tr>
<tr>
<td><a href='missions.php?action=jersey'>Jersey</a></td>
</tr>
<tr>
<td><a href='missions.php?action=vegas'>Las Vegas</a></td>
</tr>
<tr>
<td><a href='missions.php?action=miami'>Miami</a></td>
</tr>
<tr>
<td><a href='missions.php?action=chinatown'>Chinatown</a></td>
</tr>
</table>
</div>
        
        <div id="footer">
            <a href="http://www.maxdesign.com.au/articles/css-layouts/three-fixed/">max design layout</a>
        </div>
    </div>
</div>

jtgraphic · March 3, 2010

You're talking about the links at the bottom, right? Just (re)move that table.

xoligy · March 3, 2010

That table is what the user see's first, they then click what they want from that table and the correct table is displayed, but i dont want that table displayed after they have clicked it... i'll keep playing with it thanks

aeroswat · March 3, 2010

That table is what the user see's first, they then click what they want from that table and the correct table is displayed, but i dont want that table displayed after they have clicked it... i'll keep playing with it thanks

What do you want displayed when they click it? All the links do is send a GET variable to the same page in order to determine which table to display.

jtgraphic · March 3, 2010

I cleaned up some dupe code and added an if statement for if there is no action. Try it out and let me know how it works.


<?php
session_start();

if (!isset($_SESSION['username']))
	header("Location: login.php");

include('db.php');
include('process.php');  

?>
<head>
<title><?=$title?></title>
<link rel="stylesheet" href="style.css" type="text/css" media="screen" />
</head>
<body>
<div id="container">
	<div id="header">
		<h1>Site name</h1>
	</div>
	<div id="navigation">
		<ul>
		<li><a href="index.php">Home</a></li>
		<li><a href="#">About</a></li>
		<li><a href="#">Services</a></li>
		<li><a href="#">Contact us</a></li>
		</ul>
	</div>
	<div id="content-container">
		<div id="section-navigation">
			<ul><? include'left.php'; ?></ul>
		</div>
		<div id="content">
			<table border='1' width='750px'>
				<tr><td colspan='9' align='center'>Missions</td></tr>
				<tr>
					<td>Mission</td>
					<td>Level</td>
					<td>Location</td>
					<td>Loot</td>
					<td>Total Ngy</td>
					<td>bronze</td>
					<td>bronze</td>
					<td>bronze</td>
					<td>bronze</td>
				</tr>
				<?
					if($action=='all'){
						$missions = mysql_query("select * from missions");

						while($row = mysql_fetch_array( $missions )) {
							echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
						}
					}
					if($action=='bronx'){
						$missions = mysql_query("select * from missions where location='bronx'");

						while($row = mysql_fetch_array( $missions )) {
							echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
						}
					}

					if($action=='downtown'){
						$missions = mysql_query("select * from missions where location='downtown'");

						while($row = mysql_fetch_array( $missions )) {
							echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
						}
					}

					if($action=='jersey'){
						$missions = mysql_query("select * from missions where location='jersey'");

						while($row = mysql_fetch_array( $missions )) {
							echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
						}
					}

					if($action=='vegas'){
						$missions = mysql_query("select * from missions where location='las vegas'");

						while($row = mysql_fetch_array( $missions )) {
						echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
						}
					}

					if($action=='miami'){
						$missions = mysql_query("select * from missions where location='miami'");

						while($row = mysql_fetch_array( $missions )) {
							echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
						}
					}

					if($action=='chinatown'){
						$missions = mysql_query("select * from missions where location='chinatown'");

						while($row = mysql_fetch_array( $missions )) {
							echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
						}
					}

					if($action=='coney island'){
						$missions = mysql_query("select * from missions where location='coney island'");

						while($row = mysql_fetch_array( $missions )) {
							echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
						}
					}

					if($action=='moscow'){
						$missions = mysql_query("select * from missions where location='moscow'");

						while($row = mysql_fetch_array( $missions )) {
							echo "<tr><td>".$row['mission']."</td><td>".$row['level']."</td><td>".$row['location']."</td><td>".$row['loot']."</td><td>".$row['energy1']."</td><td>".$row['bronze']."</td><td>".$row['silver']."</td><td>".$row['gold']."</td><td>".$row['platinum']."</td></tr>";
						}
					}
				?>
			</table>

			<? if(@isset($action) || $action =='') { ?>
				<table>
					<tr><td><a href='missions.php?action=all'>All</a></td></tr>
					<tr><td><a href='missions.php?action=bronx'>Bronx</a></td></tr>
					<tr><td><a href='missions.php?action=downtown'>Downtown</a></td></tr>
					<tr><td><a href='missions.php?action=jersey'>Jersey</a></td></tr>
					<tr><td><a href='missions.php?action=vegas'>Las Vegas</a></td></tr>
					<tr><td><a href='missions.php?action=miami'>Miami</a></td></tr>
					<tr><td><a href='missions.php?action=chinatown'>Chinatown</a></td></tr>
				</table>
			<? } ?>
		</div>

		<div id="footer">
			<a href="http://www.maxdesign.com.au/articles/css-layouts/three-fixed/">max design layout</a>
		</div>
	</div>
</div>
</body>

xoligy · March 3, 2010

Thanks jt for having a look into it, after playing with the code i did sort it out was having a dumb moment i guess. I will definatly be having a deeper look into the unnecassary code removal tho that was interesting not seent hat in a tutoral yet

Only isses i had with your code were...

1. table header was being showed on the links page (easily removed tho)

2. links still being showed

here was all i had to do:

<?php
$action=$_GET['action'];
if($action!=''){ echo'';}else{
?>

<table>
<tr>
<td><a href='missions.php?action=all'>All</a></td>
</tr>
<tr>
<td><a href='missions.php?action=bronx'>Bronx</a></td>
</tr>
<tr>
<td><a href='missions.php?action=downtown'>Downtown</a></td>
</tr>
<tr>
<td><a href='missions.php?action=jersey'>Jersey</a></td>
</tr>
<tr>
<td><a href='missions.php?action=vegas'>Las Vegas</a></td>
</tr>
<tr>
<td><a href='missions.php?action=miami'>Miami</a></td>
</tr>
<tr>
<td><a href='missions.php?action=chinatown'>Chinatown</a></td>
</tr>
</table>
<?}?>

Thanks again, now for me to play with the code remval i guess for smaller pages

jtgraphic · March 3, 2010

Awesome. Glad to help. I supposed I would have noticed those if I had tested it

xoligy · March 3, 2010

haha nps thanks again xD

Sign In

Table and white spaces

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

Join the conversation

Important Information