Learn VBA & Macros in 1 Week!

PHP - Alternating Color

Full Excel VBA Course - Beginner to Expert

Alternating Color	View Content

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();
?>
<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) {

$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>
<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>

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Group, Alternating Background Color Based On Category

Alternating Row Colors

Alternating Row Colors

Issue Showing Results - 1 Row Keeps Alternating

Php Gd -> Get Color -> Print Color

Tr Bg Color By Value

Change Row Color

Watermark Border Color

Mixing Rgb Color Values

Datatable In Different Color Rows.

Let Certain Usernames And Messages Appear In Its Own Color

How To Color Label When Passing Value "0"

Add Background Color If Value Is An Odd Number

Color Mixer Script

Imageconvolution: Auto Color

How To Give Certain Numbers Color In Php

Php Security For Hex Color Codes

Moved: Scrollbar Color....

Coding Help, Changing Color!

Learn VBA & Macros for Excel in 1 Week!

Group, Alternating Background Color Based On Category

Similar Tutorials

Good Day,
I am trying to create a table where the background color alternates between colors based on the category. The query sorts the category in alphabetical order. So for every category that is the same the background color will be the same. When the category changes, the background color changes. Alternating between two colors will be fine. I am not even sure where to begin on the sort of loop.

So I want php to create a table like below:

<table width="300" border="1" cellspacing="0" cellpadding="0">
<tr bgcolor="#CCCCCC">
<td width="117">Category 1</td>
<td width="177">Excetion data</td>
</tr>
<tr bgcolor="#CCCCCC">
<td>Category 1</td>
<td>Excetion data</td>
</tr>
<tr bgcolor="#CCCCCC">
<td>Category 1</td>
<td>Excetion data</td>
</tr>
<tr bgcolor="#FFFFCC">
<td>Category 2</td>
<td>Excetion data</td>
</tr>
<tr bgcolor="#FFFFCC">
<td>Category 2</td>
<td>Excetion data</td>
</tr>
<tr>
<td bgcolor="#CCCCCC">Category 3</td>
<td bgcolor="#CCCCCC">Excetion data</td>
</tr>
<tr>
<td bgcolor="#CCCCCC">Category 3</td>
<td bgcolor="#CCCCCC">Excetion data</td>
</tr>
<tr>
<td bgcolor="#CCCCCC">Categor 3</td>
<td bgcolor="#CCCCCC">Excetion data</td>
</tr>
</table>

Alternating Row Colors

Similar Tutorials

I've checked it seems a million tutorials that have all been simplat, but i have been unable to get alternating row colors working when pulling info from a mysql database and displaying in a table.

Any suggestions?

Code: [Select]
<html>
<head>
<LINK href="style.css" rel="stylesheet" type="text/css">
<script language="JavaScript">
function checkAll(){
for (var i=0;i<document.forms[0].elements.length;i++)
{
var e=document.forms[0].elements[i];
if ((e.name != 'allbox') && (e.type=='checkbox'))
{
e.checked=document.forms[0].allbox.checked;
}
}
}
</script>
</head>

<body>
<form id="form1" name="form1" method="post" action="handler.php">
<div align="center"><h1>Unprocessed Applications</h1><input type="submit" name="button" id="button" value="Submit" /></div>
<table id="mytable" cellspacing="0">
<tr>
<th scope="col"><strong>Date</strong></th>
<th scope="col"><strong>ID</strong></th>
<th scope="col"><span class="style1 style3"><strong>First Name</strong></span></th>
<th scope="col"><span class="style1 style3"><strong>Last Name</strong></span></th>
<th scope="col"><div align="center"><span class="style3"></span></div>Check All -></th>
<th scope="col"><div align="center"><input type="checkbox" value="on" name="allbox" onclick="checkAll();"/><br /></div></th>
</tr>

<?php do { ?>

<tr>
<td width="28%"><span class="style1"><?php echo date('F j, Y - g:ia', $row_update['timestamp']); ?></span></td>
<td width="7%"><?php echo $row_update['id']; ?></td>
<td width="17%"><?php echo $row_update['first_name']; ?></td>
<td width="28%"><?php echo $row_update['last_name']; ?></td>
<td width="15%"><div align="center"><?php echo "<a href=\"https://www.*******/index.php?id=". $row_update['id']."\" target='_blank'>View & Print</a>"; ?></div></td>
<td width="5%"><div align="center">
<input type="checkbox" name="checkbox[]" value="<?php echo $row_update['id'] ?>" />
<label for="checkbox"></label>
</div></td>
</tr>
<?php } while ($row_update = mysql_fetch_assoc($update)); ?>

</table>

<label for="button"></label>
<div align="center"><input type="submit" name="button" id="button" value="Submit" /></div>
</form>
</body>
</html>

Alternating Row Colors

Similar Tutorials

The intention is to alternate table rows background color between classes "row0" and "row1" defined elsewhere.
Is this code valid ?

<?php $rowclass = 0; ?>
<table ... >

<tr class="row{ROWCLASS}"> ............ tried also : class="row<?= $rowclass ?>"
     <td>
      ..........
      </td>
</tr>
   <?php $rowclass = 1 - $rowclass; ?>
   
</table>

In the source I cannot see any value for "$rowclass".

Thanks for helping.

Issue Showing Results - 1 Row Keeps Alternating

Similar Tutorials

Hi I have 2 tables that I am searching infor for. One holds the phone info and the other the repairs that are available. I have the code below and it displays on the webpage in a table for the phone information and then another table the repairs but they seem to be separate tables and headers. inbetween them is the phone and the details which separates the repairs but its not in a table. Hopefully the code below will explain better. What I would like it the phone details in one table and then a table full of all the repairs (I am not bothered about a new heading for each repair).

$result = mysql_query("SELECT * FROM phone, phonerepairs WHERE phone.model_no='".$_POST['model']."' AND phone.phone = phonerepairs.phone");

while($row = mysql_fetch_array($result))
{
echo '<td width="70" align="center"><img src="'.$row['icon'].'" width="66"></td>';
echo '<td width="100" align="center">'.$row['model_no'].'</td>';
echo '<td width="130" align="center">'.$row['model'].'</td>';
echo '<td width="50" align="center">'.$row['year'].'</td>';
echo '<td width="150" align="center">'.$row['capacity'].'</td>';
echo '</tr>';
echo '</table><br>';
echo '</p>';
echo '<p>';
echo '<div id="pageheading"><h3><div id="title">Repairs we carry out for '.$row['model'].'</div></h3></div>';
echo '<table width="99%" cellpadding="5" cellspacing="0" border="1">';
echo '</p>';
echo '<p>';
echo '<tr>';
echo '<td align="center"><strong>Image</strong></td>';
echo '<td align="center"><strong>Fault</strong></td>';
echo '<td align="center"><strong>Repair</strong></td>';
echo '<td align="center"><strong>Cost</strong></td>';
echo '</tr>';
echo '<tr>';
echo '<td width="70" align="center"><img src="'.$row['icon'].'" width="66"></td>';
echo '<td width="100" align="center">'.$row['fault'].'</td>';
echo '<td width="130" align="center">'.$row['description'].'</td>';
echo '<td width="50" align="center">&pound'.$row['cost'].'</td>';
echo '</tr>';
echo '</table><br>';

Thanks in advance Martyn

Php Gd -> Get Color -> Print Color

Similar Tutorials

Hello everyone!

I need a little help to get functions names from the GD library.
first i want to say i have a little knowledge with GD library like create image with words and etc.

So , what i'm trying to do is to take image and than
take the color of the first pixel on the top left than do some function work and than
set this pixel on the top left to another color.

now , i know how the algorithm should look like , i just don't know what function i need to use to:
take specific pixel color from the image
set new color for pixel on specific place

i'll be glad if you could help me with that ,
regards , Mor.

Tr Bg Color By Value

Similar Tutorials

im trying to get a row color coded by a $var that is pulled from mysql.
if $val = yes the <tr> = green else red

im only concerned with the table row color atm. the rest of the code is still wip

relavent section of code
<tr bgcolor= <?php "$bgc"; ?>>  // this is were i want the $var placed
<td> <?php echo $rows['sku'] ; ?></td>
<td> <?php echo $rows['rsku']; ?></td>
<td> <?php echo $rows['make']; ?></td>
<td> <?php echo $rows['model']; ?></td>
<td> <?php echo $rows['comments']; ?></td>
<td> <?php echo $rows['sound']; ?></td>
<td> <?php echo $rows['gfx']; ?></td>
<td> <?php echo $rows['recovery']; ?></td>
<td> <?php echo $rows['date']; ?></td>
<td> <?php echo $rows['valby']; ?></td>

<td width="41" align="center"><a href="update.php?id=<?php echo $rows['id']; ?>">update</a></td>
<td width="36" align="center"><a href="delete_ac.php?id=<?php echo $rows['id']; ?>">delete</a></td>
</tr>

<?php

// table bg colour
$choice = strtoupper($rows['gfx']);
if($choice == "PASS"){
$bgc = "#7FFF00" ;
}else{
$bgc = "#8B8989" ; }

}

?>

full code
<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Modify DataBase</title>
</head>

<body>
<p align="center"> </p>
<table width="400" border="1" align="center">
  <tr>
    <td TD BGCOLOR="#FF9900">
<?php

include("config.php");

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$tbl_name="dsgi_serval";

// Retrieve data from database
$search = trim($_POST['search']);
if ($search == '' || $search == ' '){

echo "Search Field is Empty - Please Input an SKU Number!";
die;
}
else{
$sql="select * from $tbl_name WHERE sku LIKE '%$search%'";
$result=mysql_query($sql) or die (mysql_error());
}

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

<table width="800" height="72" border="1" align="center" cellpadding="3" cellspacing="0">


<tr>
<td width="113" align="center"><strong>Orig SKU</strong></td>
<td width="66" align="center"><strong>Recon SKU</strong></td>
<td width="90" align="center"><strong>Make</strong></td>
<td width="169" align="center"><strong>Model</strong></td>
<td width="58" align="center"><strong>comments</strong></td>
<td width="161" align="center"><strong>Sound</strong></td>
<td width="66" align="center"><strong>Graphics</strong></td>
<td width="90" align="center"><strong>Recovery</strong></td>
<td width="169" align="center"><strong>Date</strong></td>
<td width="58" align="center"><strong>Validated By</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr bgcolor= <?php "$bgc"; ?>>
<td> <?php echo $rows['sku'] ; ?></td>
<td> <?php echo $rows['rsku']; ?></td>
<td> <?php echo $rows['make']; ?></td>
<td> <?php echo $rows['model']; ?></td>
<td> <?php echo $rows['comments']; ?></td>
<td> <?php echo $rows['sound']; ?></td>
<td> <?php echo $rows['gfx']; ?></td>
<td> <?php echo $rows['recovery']; ?></td>
<td> <?php echo $rows['date']; ?></td>
<td> <?php echo $rows['valby']; ?></td>

<td width="41" align="center"><a href="update.php?id=<?php echo $rows['id']; ?>">update</a></td>
<td width="36" align="center"><a href="delete_ac.php?id=<?php echo $rows['id']; ?>">delete</a></td>
</tr>

<?php

// table bg colour
$choice = strtoupper($rows['gfx']);
if($choice == "PASS"){
$bgc = "#7FFF00" ;
}else{
$bgc = "#8B8989" ; }

}

?>
</table>
<p> </p>
</body>
</html>

Change Row Color

Similar Tutorials

Hi, I'm having the following problem. I want to change the row color depending on the value of a record. i made three different td class in the style. Then i check the value of the record "TOEGEZEGD" and connect this to $NewClass, The i try to change the color of the background. $NewClass takes the value i want (check by display echo $NewClass) But the background of the row doesn't change, i tried different methodes: <td class = "$NewClass">'.$row['TOEGEZEGD'].'</td>
<td class = \"$New$Class\">'.$row['VORM'].'</td>
<td><DIV CLASS="$NewClass">'.$row['PAKKET'].'</DIV></td> But non of them work please help, it's driving my crazy

<?php

// checking for started session
function is_session_started()
{
    if ( php_sapi_name() !== 'cli' ) {
        if ( version_compare(phpversion(), '5.4.0', '>=') ) {
            return session_status() === PHP_SESSION_ACTIVE ? TRUE : FALSE;
        } else {
            return session_id() === '' ? FALSE : TRUE;
        }
    }
    return FALSE;
}

if ( is_session_started() === FALSE ) session_start();

if(isset($_SESSION ['ingelogd']) AND $_SESSION['ingelogd'] == 1)
{}
else
{
	header("location:index.php");
	exit;
}

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>**********</title>
<meta name="" content="">
</head>
<body>
	<style>
		textarea, input, button,
		a, td, span{
			font-family: "Trebuchet MS", Helvetica, sans-serif;
		}
		
		td{
			color: blue;
			width: 100px;
			background-color: #ceffce;
			height: 50px;
			text-align: center;
}

		td.JA{
            color: red;
            width: 100px;
            background-color: #00ee00;
            height: 50px;
            text-align: left;
        } 
		.JA{
            color: red;
            width: 100px;
            background-color: #00ee00;
            height: 50px;
            text-align: left;
        } 
		 td.NEE{
            color: green;
            width: 100px;
            background-color: #ff0000;
            height: 50px;
            text-align: left;
        }

        td.MISSCHIEN{
            color: orange;
            width: 100px;
            background-color: #f07700;
            height: 50px;
            text-align: left;
        } 
		
		td.op{
			color: black;
			width: 450px;
			background-color: #ceDDce!important;
			height: 50px;
			text-align: left; 
		}
		
		th{
			color: black;
			width: 40px;
			background-color: #cecece;
			height: 50px;
			text-align: center;
		}
		th.op{
			color: black;
			width: 450px;
			background-color: #cecece;
			height: 50px;
			text-align: center;
		}
		
		.a{
			height: 25%;
			cursor: pointer;
		}
		
		 
		button{
			width: 100%;
			height: 100%;
			margin: -5 auto -5 auto;
			
		}
		
		textarea {
			height: 100%;
			width: 100%;
		}
		
		.verwijder{
			width: 10px;
			height: auto;
			background-color: #ffa8a8;
		}
		
		.space{
			width: 20px;
			height: auto;
		}
		
		.invoegen{
			background-color: #6dbbdc;
			width: 1434px;
			padding: 5px;
			margin: 5px;
		}
		
		.content{
			background-color: #FFDD67;
			width: 1500px; ;
			padding: 0 5 0 5;
			margin: 0 5 0 5;
		}
			.content table{
				margin-bottom: 100px;
			}
		
		span{
			text-decoration: underline;
		}
		
		select{
			height: 90%;
		}
		
	</style>
		
		
	
	
<div class="content">
<?php

	
	mysql_connect("localhost", "************", "*********") or die(mysql_error());
mysql_select_db("*********");






$sql = "SELECT  ID, NAAM, CONTACT, TOEGEZEGD, bestuur1, bestuur2, bestuur3, bestuur4, bestuur5, VORM, PAKKET, KANGEFACTUREERD, GEFACTUREERD, AANTAL, POST, OPMERKING FROM `sponsoren` ORDER BY $field $sort";


$result = mysql_query($sql) or die(mysql_error());



echo'<table>';


while($row = mysql_fetch_array($result))
{
	$BESTUUR1 = $row['bestuur1'];
	$BESTUUR2 = $row['bestuur2'];
	$BESTUUR3 = $row['bestuur3'];
	$BESTUUR4 = $row['bestuur4'];
	$BESTUUR5 = $row['bestuur5'];
	
if ($row['TOEGEZEGD'] == 'ja') {
  $NewClass = "JA" ;
} elseif ($row['TOEGEZEGD'] == 'nee') {
  $NewClass = "NEE";
} elseif ($row['TOEGEZEGD'] == 'misschien') {
  $NewClass = "MISSCHIEN";
}

echo $NewClass;
echo'<tr>		
		<td><a href="full_table_row_results.php?ID='.$row['ID'].'">'.$row['ID'].'</a></td>
		<td>'.$row['NAAM'].'</td>
		<td>'.$row['CONTACT'].'</td>
		<td >';
			    if($BESTUUR1 == 1){
				echo "<div class='item'><label>Kk</label></div>";
			    };
				if($BESTUUR2 == 1){
				echo "<div class='item'><label>Rutger</label></div>";
			    }; 
			    if($BESTUUR3 == 1){
				echo "<div class='item'><label>Toby</label></div>";
			    }; 
				if($BESTUUR4 == 1){
				echo "<div class='item'><label>Meijke</label></div>";
			    }; 
			    if($BESTUUR5 == 1){
				echo "<div class='item'><label>Boele</label></div>";
			    }"</td>"; 	
echo'<td class = "$NewClass">'.$row['TOEGEZEGD'].'</td>
	 <td class = \"$New$Class\">'.$row['VORM'].'</td>
	 <td><DIV CLASS="$NewClass">'.$row['PAKKET'].'</DIV></td>
	 <td>'.$row['KANGEFACTUREERD'].'</td>
	 <td>'.$row['GEFACTUREERD'].'</td>
	 <td>'.$row['AANTAL'].'</td>
	 <td>'.$row['POST'].'</td>
	 <td class = "op">'.$row['OPMERKING'].'</td>';
echo'</tr>';
}
echo'</table>';

?>
    </div>
  </body>
</html>

Color Fade

Similar Tutorials

I have a navigation bar that allows the user to change its color. When the color is changed it fades from one color to another. I am trying to make the background do the same. It currently changes color but doesn't have the same fade effect. Navigation Bar:

	var value = $(this).attr('data-color');
		$('.navbar').removeClass().addClass('navbar '+ value);
		
		return false;

Page Background:

function colorPink() {
 document.body.style.backgroundColor = "#FF47D1";
}

What can I do to make them both fade?

Thanks,

Watermark Border Color

Similar Tutorials

I've got a script that auto-puts watermark on images

code:
Code: [Select]
<?php

//get stuff
$src = $_SERVER['DOCUMENT_ROOT'].'/'.$_GET['src'];
$watermarkSRC = 'img/wm.png';

header('Content-type: image/jpeg');

//create watermark
$watermark = imagecreatefrompng($watermarkSRC);

//wm dimensions
$watermark_width = imagesx($watermark);
$watermark_height = imagesy($watermark);
$image = imagecreatetruecolor($watermark_width, $watermark_height);

//border
$border=25;

//some crappy logic

if(strpos($src,'.gif') !== false) {
$image = imagecreatefromgif($src);
}
elseif(strpos($src,'.jpeg') !== false || strpos($src,'.jpg') !== false) {
$image = imagecreatefromjpeg($src);
}
elseif(strpos($src,'.png') !== false) {
$image = imagecreatefrompng($src);
}
else {
exit("Your image is not a gif, jpeg or png image. Sorry.");
}

//image dimensions
$width=ImageSx($image);
$height=ImageSy($image);

//lets make a border
$img_adj_height=$height+$border;
$square=imagecreatetruecolor($width,$img_adj_height);

//border + image
imagecopyresampled($square, $image, 0, 0, 0, 0, $width, $img_adj_height, $width, $img_adj_height);

//watermark placement
$dest_x = $width - $watermark_width - 5;
$dest_y = $img_adj_height - $watermark_height - 5;

//border + watermark
imagecolortransparent($watermark,imagecolorat($watermark,0,0));
imagecopyresampled($square, $watermark, $dest_x, $dest_y, 0, 0, $watermark_width, $watermark_height, $watermark_width, $watermark_height);

//wrap up
imagejpeg($square, "", 100);
imagedestroy($image);
imagedestroy($watermark);
?>
and I want to change it so the watermark will be in a border with the transparent or white background instead of black
how can I do that?

Mixing Rgb Color Values

Similar Tutorials

Hi, Assume that I have 50 RGB color values and I want to mix all of them and reach to a final single value which is mixture of all. how can I do that in PHP. Thanks.

Datatable In Different Color Rows.

Similar Tutorials

hey guys! i'm back again with another question I've been messing with the piece of code for a few days now and can't get it to function properly. i'm trying to make each row a different color which works... BUT it leaves out some data and prints it double... This is the piece of code that will help you find what i've been doing wrong...

    $color="1";
    while($row = mysqli_fetch_array($retval,  MYSQLI_ASSOC)) { 
        if($color==1){
    $cardname = $row['Name']; 
    $encodedcardname = str_replace(" ","%20",trim($cardname)); 
    $url = "http://mtgimage.com/card/$encodedcardname.jpg";
     
            echo "<tr bgcolor=''><td>"; 
            echo "<a href=$url>$cardname</a>"; 
            echo "</td><td>"; 
            echo $row['Color']; 
            echo "</td><td>"; 
            echo $row['Type']; 
            echo "</td><td>"; 
            echo $row['Subtype']; 
            echo "</td><td>"; 
            echo $row['Power']; 
            echo "</td><td>"; 
            echo $row['Toughness']; 
            echo "</td><td>"; 
            echo $row['Manacost']; 
            echo "</td><td>"; 
            echo $row['Rarity']; 
            echo "</td><td>"; 
            echo $row['Expansion']; 
            echo "</td><td>"; 
            echo $row['Foil']; 
            echo "</td><td>"; 
            echo $row['Stock']; 
            echo "</td></tr>";

            $color="2";
            }
            else {
                echo "<tr bgcolor='#F8F8F8'><td>"; 
                echo "<a href=$url>$cardname</a>"; 
                echo "</td><td>"; 
                echo $row['Color']; 
                echo "</td><td>"; 
                echo $row['Type']; 
                echo "</td><td>"; 
                echo $row['Subtype']; 
                echo "</td><td>"; 
                echo $row['Power']; 
                echo "</td><td>"; 
                echo $row['Toughness']; 
                echo "</td><td>"; 
                echo $row['Manacost']; 
                echo "</td><td>"; 
                echo $row['Rarity']; 
                echo "</td><td>"; 
                echo $row['Expansion']; 
                echo "</td><td>"; 
                echo $row['Foil']; 
                echo "</td><td>"; 
                echo $row['Stock']; 
                echo "</td></tr>";

            $color="1";
            }

        } 
        echo "</table>";

A picture of the result of whats it outputting right now is attached to this thread. Thanks in advance! Attached Files Naamloos.png 322.6KB 0 downloads

Let Certain Usernames And Messages Appear In Its Own Color

Similar Tutorials

Hi I'm trying to make use of an array with usernames in it and want to make use of it to display users with those usernames in a certain color in this case Im trying red. I've made an array with username in it

$admin = array("SYSOP","~cobusbo~");

and I've tried to print these messages with color with the If function without luck

if ($name == $admin) {
$name = print '<span style="color:red">' . $_SERVER["HTTP_X_MXIT_NICK"] . '</span>';
}
else
{
$name = print $_SERVER["HTTP_X_MXIT_NICK"];
}

Here is my full code

<?php
        /*** begin the session ***/
        session_start();

        /*** create the form token ***/
        $form_token = uniqid();

        /*** add the form token to the session ***/
        $_SESSION['form_token'] = $form_token;



define('TIMEZONE', 'Africa/Harare');
date_default_timezone_set(TIMEZONE);



// database connection info
$conn = mysql_connect('**********','********','**********') or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('u506124311_cobus',$conn) or trigger_error("SQL", E_USER_ERROR);


// find out how many rows are in the table 
$sql = "SELECT COUNT(*) FROM StringyChat";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];

// number of rows to show per page
$rowsperpage = 20;
// find out total pages
$totalpages = ceil($numrows / $rowsperpage);

// get the current page or set a default
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
   // cast var as int
   $currentpage = (int) $_GET['currentpage'];
} else {
   // default page num
   $currentpage = 1;
} // end if

// if current page is greater than total pages...
if ($currentpage > $totalpages) {
   // set current page to last page
   $currentpage = $totalpages;
} // end if
// if current page is less than first page...
if ($currentpage < 1) {
   // set current page to first page
   $currentpage = 1;
} // end if

// the offset of the list, based on current page 
$offset = ($currentpage - 1) * $rowsperpage;




    /*
     * StringyChat
     *
	 * Please refer to readme.txt supplied with the StringyChat distribution for information on
	 * installing and configuring. 
	 *
     */








define('TIMEZONE', 'Africa/Harare');
date_default_timezone_set(TIMEZONE);

    include("chat_code_header.php");

    $result = mysql_query("SELECT * FROM ".$ConfigTable, $db); 
    $myrow = mysql_fetch_array($result); 

    $domain_installed = $myrow["domain_installed"]; // The domain StringyChat is installed on
	$install_url = $myrow["install_url"]; // URL to install dir of StringyChat
    $name_size = $myrow["name_size"]; // Maximum size of the name
    $message_size = $myrow["message_size"]; // Maximum message size. Do not exceed 250 as this is the database limit.
    $line_length = $myrow["line_length"]; // Maximum length of words in a line. Anything above this value will be split.
    $ShowPostNum = $myrow["show_posts"]; // The number of historic posts to load and display.
    $email_notification = $myrow["email_notification"]; // Send email to administrator when new posts are made. 0 = No, 1 = Yes
	$email_notification_to = $myrow["email_notification_to"]; // The email address to send notifications to

    
	if ($_SERVER['REQUEST_METHOD'] == "POST" && !empty($_POST['StringyChat_name'])) 
    { 
    $StringyChat_name = $_POST['StringyChat_name'];
    $StringyChat_message = $_POST['StringyChat_message'];
    }
	
?>

<div id="StringyChat">

<?
    // Check if visitor's IP is banned.  If so, do not display the form,
    // show a banned IP message instead.


    $ip = $_SERVER["REMOTE_ADDR"];
    $sql = "SELECT * FROM StringyChat_IPBan WHERE ip=\"$ip\"";
    $result = mysql_query($sql);
    $myrow = mysql_fetch_array($result);
    if($myrow["ip"] == "") {	// Checks if IP not found in banned list




?>
<html><form name="StringyChat_form" method="POST" action="<? echo $_SERVER['REQUEST_URI']; ?>">
      <br>
      <input type="hidden" name="StringyChat_name" class="StringyChatFrm" value="<?php $name ?>1" size="20">
      <br>
      <textarea name="StringyChat_message" class="StringyChatFrm" cols="20" rows="4"></textarea>
      <br>
      <input name="StringyChat_submit" class="StringyChatFrm" type="submit" value="Post Message">
    </form>
</html>

<?

    } else {
      echo "Posting disabled - Your IP has been banned.";
    }
    
    // Should we try to create a post?
    if (isset($StringyChat_name) && isset($StringyChat_message)) {

        // Remove whitespaces and slashes.
        $name = trim(stripslashes($StringyChat_name));
        $message = trim(stripslashes($StringyChat_message));

        
            // Check name and message have been entered.
            if (strlen($name) > 0 && strlen($message) > 0) {
                
                // Limit the size of the fields as per variable defnitions.
                if (strlen($name) > $name_size) {
                    $name = substr($name, 0, $name_size);
                }
                if (strlen($message) > $message_size) {
                    $message = substr($message, 0, $message_size);
                }
                
                // Remove new lines from name.
                $name = str_replace("\n", " ", $name);
                
				// Stripping out \r's so email formattnig appears correctly.
				$message = str_replace("\r", "", $message);
				
				// Create an email-friendly version of the message.
				$message_emailable = str_replace("<br>", "\n", $message);
				$result_wordswap = mysql_query("SELECT * FROM ".$WordBanTable,$db);
                while ($myrow_wordswap = mysql_fetch_array($result_wordswap)) {
	              $the_word = $myrow_wordswap["word"];
                  $message_emailable = ereg_replace($the_word, "!*#$%",$message_emailable);
                }

                // Replace the new lines with encoded line breaks for HTML (thanks milahu).
                $message = str_replace("\n", "c#lb", $message);

                // Use HTML encoding on ame and message so database doesn't misinterpret data.
	            $name = htmlentities($name);
                $message = htmlentities($message, ENT_COMPAT);
				
                
                
                // IP address of submitter and time of post.
$ip = $_SERVER["REMOTE_ADDR"];
$name = $_SERVER["HTTP_X_MXIT_NICK"];
$msg = $_POST['StringyChat_message'];
$post_time = date("U");
$admin = array("SYSOP","~cobusbo~");
$mxitid = $_SERVER["HTTP_X_MXIT_USERID_R"];



if ($name == $admin) {
$name = print '<span style="color:red">' . $_SERVER["HTTP_X_MXIT_NICK"] . '</span>';
}
else
{
$name = print $_SERVER["HTTP_X_MXIT_NICK"];
}

if(!isset($mxitid, $name ))
{
	$mxitid = "DEFAULT";
	$name = "SYSOP";

}

                // check to see if a duplicate exists
                $sql = "SELECT * FROM StringyChat WHERE StringyChat_ip=\"$ip\" AND StringyChat_message=\"$msg\" AND StringyChat_time>($post_time - 3600 )";
                $result = mysql_query($sql);
                $myrow = mysql_fetch_array($result);

                if($myrow["StringyChat_message"] == "") {	// Checks if record not matching in db
                  // Save the record
                  $sql = "INSERT INTO StringyChat (StringyChat_ip,StringyChat_name,StringyChat_message,StringyChat_time,mxit_id) VALUES (\"$ip\",\"$name\",\"$msg\",$post_time,$mxitid)";
                  $result = mysql_query($sql);
				  
				  $theTo = $email_notification_to;
				  $theSubject = "New StringyChat post at ".$domain_installed;
				  $theMessage = "A new StringyChat post has been made.\n\n";
				  $theMessage .= $name . "\n";
				  $theMessage .= date("H:i - d/m/y", $post_time) . "\n";
				  $theMessage .= $message_emailable . "\n\n";
  				  $theMessage .= "Visit ".$domain_installed." to view StringyChat and much more!";
				  $theHeaders = "From: StringyChat at ".$domain_installed." <".$email_notification_to.">\r\n";
				  
				  mail($theTo,$theSubject,$theMessage,$theHeaders);

                } else {
                  echo "Duplicate post detected<br>";
                }                
            }
            else {
                echo "<font color=\"red\">You must Type a message</font><br><br>";
            }

      unset($_POST["StringyChat_name"]);
      unset($_POST["StringyChat_message"]);
      unset($StringyChat_ip);
      unset($StringyChat_name);
      unset($StringyChat_message);
      unset($StringyChat_time);
    }
    
// get the info from the db 
$sql = "SELECT StringyChat_time, StringyChat_name, StringyChat_message FROM StringyChat ORDER BY id DESC LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);



function filterBadWords($str)
{
	
	
    $result1 = mysql_query("SELECT word FROM StringyChat_WordBan") or die(mysql_error()); 
    $replacements = ":-x";
    
    while($row = mysql_fetch_assoc($result1))
    {
          $str = eregi_replace($row['word'], str_repeat(':-x', strlen($row['word'])), $str);
    }  
    
    return $str;
}



// while there are rows to be fetched...
while ($list = mysql_fetch_assoc($result)) 
//while (($pmsg = $list['StringyChat_message'] == $bwords) ? ":-x" : $list['StringyChat_message'])
 {
   // echo data
   //echo ($pmsg = ($list['StringyChat_message'] == $bwords) ? ":-x" : $list['StringyChat_message'])


   print '<span style="color:#828282">' . '(' . date( 'D H:i:s', $list['StringyChat_time'] )  . ') ' . '</span>' . '<b>' . $list['StringyChat_name'] . '</b>' . ' : ' . filterBadWords($list['StringyChat_message']) . '<br />';


}






    // Load up the last few posts.  The number to load is defined by the "ShowPostNum" variable.
    $result = mysql_query("SELECT * FROM ".$dbTable." ORDER BY StringyChat_time DESC LIMIT " . $ShowPostNum,$db);

    include("sort_widths.php");

    while ($myrow = mysql_fetch_array($result)) {
      $msg = $myrow["StringyChat_message"];
	  
	  // Convert the encoded line break into an actual <br> tag (thanks milahu)
      $msg = str_replace("c#lb", "<br>", $msg);

      // Convert the encoded image tag into a html tag
      $msg = eregi_replace("im#([a-z]{3})", "<img src=\"http://".$install_url."images/\\1.gif\" alt=\"emoticon\">",$msg);
	  
	  // split the lines
      $msg = htmlwrap($msg, $line_length);

      $result_wordswap = mysql_query("SELECT * FROM ".$WordBanTable,$db);
      while ($myrow_wordswap = mysql_fetch_array($result_wordswap)) {
	    $the_word = $myrow_wordswap["word"];
        $msg = ereg_replace($the_word, ":-x",$msg);
      }

   
    }
   ?>     
<?









// end while

/******  build the pagination links ******/
// range of num links to show
$range = 3;

// if not on page 1, don't show back links
if ($currentpage > 1) {
   // show << link to go back to page 1
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";
   // get previous page num
   $prevpage = $currentpage - 1;
   // show < link to go back to 1 page
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
} // end if 

// loop to show links to range of pages around current page
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
   // if it's a valid page number...
   if (($x > 0) && ($x <= $totalpages)) {
      // if we're on current page...
      if ($x == $currentpage) {
         // 'highlight' it but don't make a link
         echo " [<b>$x</b>] ";
      // if not current page...
      } else {
         // make it a link
         echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
      } // end else
   } // end if 
} // end for

// if not on last page, show forward and last page links        
if ($currentpage != $totalpages) {
   // get next page
   $nextpage = $currentpage + 1;
    // echo forward link for next page 
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";
   // echo forward link for lastpage
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";
} // end if
/****** end build pagination links ******/
?><br>
    <html>  <i>Type your Message here...</i>:<br></html>

How To Color Label When Passing Value "0"

Similar Tutorials

Hi, in my code radio button disable when passing value is "0"

<script type="text/javascript">
$('input[type="radio"]').prop('disable', function() {
   return $(this).next().text().match(/\((\d+)\)/)[1] == 0;
 
  

});
</script>

it's ok.what i want to do is,color a label or label text when this function true.

 <label >
  <input type="radio" name="radio" id="rd" value="" />
  Click </label>

please help me

Add Background Color If Value Is An Odd Number

Similar Tutorials

I want to change the background to a light gray if the value of the $UOMPDROPSEQUENCE field is an odd number. What would be the best way to do this please keep in mind I am very new to programming and PHP Thanks Below is a snippet of my code.

$result =odbc_exec($connect,$sql);
if(!$result){
exit("Error in SQL");
}

echo "<table><tr>";
echo "<th>Drop</th>";
	echo "<th>Name</th>";
	echo "<th>Note</th>";
	echo "<th>PO</th>";
	echo "<th>Box_count</th>";
	echo "<th>Cubes</th>";
	echo "<th>ADDRESSLINE</th>";
	echo "<th>ADDRESS2</th>";
	echo "<th>CITY</th>";
	echo "<th>STATE</th>";
	echo "<th>ZIP</th>";
	echo "<th>Order_ID</th>";
	echo "<th> Phone </th>";
	

while (odbc_fetch_row($result)) {
	$UOMPDROPSEQUENCE=odbc_result($result,"UOMPDROPSEQUENCE");
	$cmlName=odbc_result($result,"cmlName");
	$UCMLSTOREHOURSTXT=odbc_result($result,"UCMLSTOREHOURSTXT");
	$ompCustomerPO=odbc_result($result,"ompCustomerPO");
	$UOMPTOTALBOXCOUNT=odbc_result($result,"UOMPTOTALBOXCOUNT");
	$UOMPVOLUMETOTAL=odbc_result($result,"UOMPVOLUMETOTAL");
	$CMLADDRESSLINE1=odbc_result($result,"CMLADDRESSLINE1");
	$CMLADDRESSLINE2=odbc_result($result,"CMLADDRESSLINE2");
	$CMLCITY=odbc_result($result,"CMLCITY");
	$CMLSTATE=odbc_result($result,"CMLSTATE");
	$CMLPOSTCODE=odbc_result($result,"CMLPOSTCODE");
	$ompSalesOrderID=odbc_result($result,"ompSalesOrderID");
	$cmlPhoneNumber=odbc_result($result,"cmlPhoneNumber");

  echo "<tr><td>$UOMPDROPSEQUENCE </td>";
  echo "<td align='center'>$cmlPhoneNumber</td>";
   echo "<td align='center'>$UCMLSTOREHOURSTXT</td>";
  echo "<td align='center'>$ompCustomerPO</td>";
  echo "<td align='center'>$UOMPTOTALBOXCOUNT</td>";
  echo "<td align='center'>$UOMPVOLUMETOTAL</td>";
  echo "<td align='center'>$CMLADDRESSLINE1</td>";
  echo "<td align='center'>$CMLADDRESSLINE2</td>";
  echo "<td align='center'>$CMLCITY</td>";
  echo "<td align='center'>$CMLSTATE</td>";
  echo "<td align='center'>$CMLPOSTCODE</td>";
  echo "<td align='center'>$ompSalesOrderID</td>";
echo "<td align='center'> $cmlPhoneNumber</td></tr>";
  }

odbc_close($connect);

Color Mixer Script

Similar Tutorials

I would like to add a color mixer (not a color selector) on a client's site. It would be like this one: http://www.dur-a-flex.com/Home/ColorPicker

Does anyone know where to find a script like this, or if they know a developer who could build it?

Imageconvolution: Auto Color

Similar Tutorials

I wrote a script in ActionScript that takes an image and does color correction, giving me the same results as photoshop's "Auto Color" feature.

The actionscript uses an image matrix that looks like this:
Code: [Select]
var cmf:ColorMatrixFilter = new ColorMatrixFilter(new Array(
R, 0, 0, 0, 0,
0, G, 0, 0, 0,
0, 0, B, 0, 0,
0, 0, 0, 1, 0
));
This is different from the php GD's matrix imageconvolution(), which is only 3x3 where the actionscript one is 5x4. I think this is why I am getting different image results.

Any suggestions to get the two to act the same? I am stumped...

How To Give Certain Numbers Color In Php

Similar Tutorials

I am trying to learn PHP basics, and I just cant figure out a way to insert color when certain conditions are met. In my code below, I want to print out red color on lets say, odd numbers from 20-49.

Appreciate your help big time!

<?php

    for ($i=20; $i<=49; $i++){        
        echo "$i<br>";  
    } 

?>

Php Security For Hex Color Codes

Similar Tutorials

I am letting users select there color code option for text-shadow for there username
I am storing them into a field called "color"

HEX exaMPLE:

FF6633,AA3633

First is the background color, 2nd is the foreground. (then i'll explode them)

Is there a PHP function that let's me validate the input so it's HEX ONLY?

I will be db escaping it and intval it too.

Moved: Scrollbar Color....

Similar Tutorials

This topic has been moved to HTML Help.

http://www.phpfreaks.com/forums/index.php?topic=347871.0

Coding Help, Changing Color!

Similar Tutorials

Hey Guys!

First off, great looking resource, looks like tons of helpful people here.

Secondly, I'll upload the file I need help with. Basically I'm looking to change the color of certain words that don't show up well now that I changed the background color.. but there are so many things in this script I can't figure out which one to change. I'm trying to change the words across the top that are in grey, to a lighter color. The site is laughing2myself.com if you need to have a look THANKS!

Any help would be greatly appreciated!