Alternating Color

teknospr · March 4, 2011

Good day:

I'm trying to get the following output to alternate colors of background (white and gray or other colors). Any help will be appreciated.

(This is the entire script so far.)

<html>

<body>

<?php

$connection = mysql_connect("localhost",

"username",

"password");

mysql_select_db("articles", $connection);

$query="SELECT * FROM articles WHERE id=1";

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

?>

<tr>

<th>Article</th>

<th>Description</th>

<th>Location</th>

</tr>

<?php

$i=0;

while ($i < $num) {

$f1=mysql_result($result,$i,"article");

$f2=mysql_result($result,$i,"year");

$f3=mysql_result($result,$i,"description");

$f4=mysql_result($result,$i,"location");

$f5=mysql_result($result,$i,"link")

?>

<tr>

</tr>

<tr>

</tr>

<?php

$i++;

}

?>

</body>

</html>

MatthewJ · March 4, 2011

You could do something like

<?php
$i=0;
while ($i < $num) {
$backgroundclass = (($i % 2) == 0) ? 'gray' : 'white';
$f1=mysql_result($result,$i,"article");
$f2=mysql_result($result,$i,"year");
$f3=mysql_result($result,$i,"description");
$f4=mysql_result($result,$i,"location");
$f5=mysql_result($result,$i,"link")
?>

<tr class='<?php echo $backgroundclass ?>'>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td ><font face="Arial, Helvetica, sans-serif"><?php echo  "<a href=\"$f5\" target=\"_blank\">$f4</a>"; ?></font></td>
</tr>
<tr>
</tr>

Then just create css classes called gray and white and have them set the color appropriately.

teknospr · March 4, 2011

Thank you. I have to look up the css cause I have never worked with it, doing all the coding in html and some php. This is a page we are building for a community service so that's why its so important and Ive been bugging so much.

teknospr · March 4, 2011

No luck with css. Any other way it can be done?

kenrbnsn · March 4, 2011

Instead of defining a CSS class, you can use in-line styling:

<tr style='backgroundcolor:<?php echo $backgroundclass ?>'>

But CSS doesn't have to be hard. In this case, put the following in the "<head>" area of your html:

<style>
    .gray {
         backgroundcolor: gray;
    }

    .white {
        backgroundcolor: white;
    }
</style>

When you say "No luck with css", how much did you look?

Ken

teknospr · March 4, 2011

Looked up about 15 examples. Changed the code and created the css file but it was not changing the background, which I'm sure has to do with a mistake or mistakes I made. Even though I have html and php minor experience, I honestly have never worked with css. I am pretty new at this, but the project is worth the time. I'm gonna try what you just sent right now.

cunoodle2 · March 4, 2011

Looked up about 15 examples. Changed the code and created the css file but it was not changing the background, which I'm sure has to do with a mistake or mistakes I made. Even though I have html and php minor experience, I honestly have never worked with css. I am pretty new at this, but the project is worth the time. I'm gonna try what you just sent right now.

Post the css code you have so far and we will help you fine tune it.

teknospr · March 4, 2011

This is the css example I tried to apply. I can rewrite it again in the code I have, since it didnt work and I just moved on to try something else that didnt work for me, another example that had php and used variables and adding up a number, but the odd and even numbers routine is beyond what I know right now. Anyway, this is the example I tried to apply:

<html>

<head>

<title>Table example</title>

</head>

<body>

<table>

<tr>

</tr>

<?php

$toons = array("Bugs Bunny", "Daffy Duck", "Tom Cat", "Jerry Mouse");

$rowclass = 0;

foreach ($toons as $toon) {

?>

</tr>

<?php

$rowclass = 1 - $rowclass;

} ?>

MatthewJ · March 4, 2011

<html>
<head>
<title>Page Title</title>

<style>
.gray { backgroundcolor: gray; }
.white { backgroundcolor: white; }
</style>

</head>
<body>
<?php
  $connection = mysql_connect("localhost",
        "username",
        "password");

    mysql_select_db("articles", $connection);
$query="SELECT * FROM articles WHERE id=1";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table border="1" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Article</font></th>
<th><font face="Arial, Helvetica, sans-serif">Year</font></th>
<th><font face="Arial, Helvetica, sans-serif">Description</font></th>
<th><font face="Arial, Helvetica, sans-serif">Location</font></th>

</tr>

<?php
$i=0;
while ($i < $num) {
$backgroundclass = (($i % 2) == 0) ? 'gray' : 'white';
$f1=mysql_result($result,$i,"article");
$f2=mysql_result($result,$i,"year");
$f3=mysql_result($result,$i,"description");
$f4=mysql_result($result,$i,"location");
$f5=mysql_result($result,$i,"link")
?>

<tr class='<?php echo $backgroundclass ?>'>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td ><font face="Arial, Helvetica, sans-serif"><?php echo  "<a href=\"$f5\" target=\"_blank\">$f4</a>"; ?></font></td>
</tr>
<tr>
</tr>

<?php
$i++;
}
?>
</body>
</html>

teknospr · March 4, 2011

I did use it actually. Just revised it right now to make sure I wrote it correctly but its not working. Dont know if it has to do with the php version or something else.

Here is the code exactly as I have it:

<html>

<head>

<title>Articles</title>

<style>

.gray { backgroundcolor: gray; }

.white { backgroundcolor: white; }

</style>

</head>

<body>

<?php

$connection = mysql_connect("localhost",

"username",

"password");

mysql_select_db("articles", $connection);

$query="SELECT * FROM articles WHERE id=1";

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

?>

<tr>

<th>Article</th>

<th>Description</th>

<th>Location</th>

</tr>

<?php

$i=0;

while ($i < $num) {

$backgroundclass = (($i % 2) == 0) ? 'gray' : 'white';

$f1=mysql_result($result,$i,"article");

$f2=mysql_result($result,$i,"year");

$f3=mysql_result($result,$i,"description");

$f4=mysql_result($result,$i,"location");

$f5=mysql_result($result,$i,"link")

?>

</tr>

<tr>

</tr>

<?php

$i++;

}

?>

</body>

</html>

teknospr · March 4, 2011

I checked the code, the query works and the table is populated, but the colof of the table is plain white, its not alternating. Any help will be appreciated.

This is the exact code:

<html>

<head>

<title>Articles</title>

<style>

.gray { backgroundcolor: gray; }

.white { backgroundcolor: white; }

</style>

</head>

<body>

<?php

$connection = mysql_connect("localhost",

"username",

"password");

mysql_select_db("articles", $connection);

$query="SELECT * FROM articles WHERE id=1";

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

?>

<tr>

<th>Article</th>

<th>Description</th>

<th>Location</th>

</tr>

<?php

$i=0;

while ($i < $num) {

$backgroundclass = (($i % 2) == 0) ? 'gray' : 'white';

$f1=mysql_result($result,$i,"article");

$f2=mysql_result($result,$i,"year");

$f3=mysql_result($result,$i,"description");

$f4=mysql_result($result,$i,"location");

$f5=mysql_result($result,$i,"link")

?>

</tr>

<tr>

</tr>

<?php

$i++;

}

?>

</body>

</html>

MatthewJ · March 4, 2011

Post the source code of the parsed page...

And use code tags

kenrbnsn · March 4, 2011

Replace

<style>
.gray { backgroundcolor: gray; }
.white { backgroundcolor: white; }
</style>

with

<style>
.gray { background-color: gray; }
.white { background-color: white; }
</style>

While you're at it, you might want to use this modified code:

<html>
<head>
	<title>Articles</title>

	<style>
		.gray { background-color: gray; }
		.white { background-color: white; }
		.fontface {
			font-family: Arial, Helvetica, sans-serif;
		}
	</style>

</head>
<body>
	<?php
	$connection = mysql_connect("localhost",
	"username",
	"password");

	mysql_select_db("articles", $connection);
	$query="SELECT article, year, description, link, location FROM articles WHERE id=1";
	$result=mysql_query($query);
	?>
<table border="1" cellspacing="2" cellpadding="2">
	<tr>
		<th class='fontface'>Article</th>
		<th class='fontface'>Year</th>
		<th class='fontface'>Description</th>
		<th class='fontface'>Location</th>
	</tr>
		<?php
		$backgroundclass = 'white';
		while ($row = mysql_fetch_assoc($result)) {
			$backgroundclass = ($backgroundclass == 'white') ? 'gray' : 'white';
			?>
	<tr class='<?php echo $backgroundclass ?>'>
		<td class='fontface'><?php echo $row['article']; ?></td>
		<td class='fontface'><?php echo $row['year']; ?></td>
		<td class='fontface'><?php echo $row['description']; ?></td>
		<td class='fontface'><?php echo  "<a href='{$row['link']}' target='_blank'>{$row['location']}</a>"; ?></td>
	</tr>
	<?php
		}
	?>
</body>
</html>

Ken

teknospr · March 4, 2011

Tried both and both work perfect. Thanks.

Pikachu2000 · March 4, 2011

When posting code, please enclose it within the forum's

 . . .

BBCode tags.

teknospr · March 4, 2011

Got it. Thanks. Sorry about the newbie mistake.

Sign In

Alternating Color

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

Archived

Important Information