Learn VBA & Macros in 1 Week!

PHP - I Need A Php Button To Change Background Color

Full Excel VBA Course - Beginner to Expert

I Need A Php Button To Change Background Color	View Content

I need a button in php to change my background color every 5 presses with a random one, every five presses the color have to change once and need to stay for the next 5 presses. here is my code <head> <title>click 5 times</title>

Full Excel VBA Course - Beginner to Expert

Change Color To Table Background After Certain Time

Similar Tutorials

View Content

Hi,

I've making a script that's almost a todo list, and i want to have 3 colors to the posts.

Post under 7 days old should be green, and thoose older then 7 days yellow and over 14 days should be red.
How could i do that? Every post i timestamp when stored in my MYSQL table.

Here is my code:
Code: [Select]

<?php
$servername='localhost';

$dbusername='root';
$dbpassword='';

$dbname='store';

connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
$link=mysql_connect ("$servername","$dbuser","$dbpassword");
if(!$link){die("Could not connect to MySQL");}
mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());
}

$result = mysql_query("SELECT * FROM henvendelser ORDER by id desc ")
or die(mysql_error());

echo "<table cellspacing='12px' cellpaddomg='5px' align='center'>";
echo "<tr> <th>ID</th> <th> Opprettet </th> <th>Navn</th> <th>Telefon</th>  <th>Emne</th> </tr>";

while($row = mysql_fetch_array( $result )) {

echo "<tr>

<td>";
echo $row['id'];
echo "</td>

<td>";
echo date("d.m.y", strtotime($row["date"]));
echo "</td>

<td>";
echo "<a href=\"detaljer.php?view=$row[id]\">$row[Navn]</a>";
echo "</td>

<td>";
echo $row['Telefon'];
echo "</td>

<td>";
echo $row['Emne'];
echo "</td>

</tr>";
}

echo "</table>";

?>

Change Background Color Of A Field With Mssql An If Statement And Variable

Similar Tutorials

View Content

Change Background And Other Images Depending On What Radio Button Is Checked

Similar Tutorials

View Content

I have to radio buttons at the login page. Both of them are in group1. The value of the first is 'fancy', the value of the second is 'fast'.
Also note that the buttons are on the login page, and i want to change the bg on the main page.

Change Row Color

Similar Tutorials

View Content

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>

Using Php To Set The Li Class, To Change Color Using Css...

Similar Tutorials

View Content

Hey,

I'm trying to add an class so I can have different background colors on my tabs.

This is the nav code for my site
Code: [Select]
<?php

function art_get_menu_auto($theme_location = 'primary-menu', $source='Pages', $Subitems = 'true', $menu = null)
{
    $depth = (!$Subitems ? 1 : 0);
    if (($source != 'Custom Menu') && function_exists('wp_nav_menu')) {
        $locations = get_nav_menu_locations();
        if ($locations && isset( $locations[ $theme_location ] ) ) {
            $nav = wp_get_nav_menu_object($locations[$theme_location]);
            if($nav){
                $source = 'Custom Menu';
                $menu = $nav;
            }
    }
    }
return art_get_menu($source, $depth, $menu);
}

function art_get_menu($source='Pages', $depth = 0, $menu = null)
{

if ($source == 'Custom Menu' && function_exists('wp_nav_menu')  && $menu) {
        return art_get_list_menu( array( 'menu' => $menu, 'depth' => $depth));
    }

if ($source == 'Pages') {
        return art_get_list_pages(array('depth' => $depth, 'sort_column' => 'menu_order, post_title'));
    }

    if ($source == 'Categories') {
        return art_get_list_categories(array('title_li'=> false, 'depth' => $depth));
    }
return "Error in menu source ".$source. ".";
}

/* menus */
function art_get_list_menu($args = array()) {
  $menu = $args['menu'];

  $menu_items = wp_get_nav_menu_items($menu->term_id);

  if(empty($menu_items)) {
      return sprintf(
        '<li><a>'
        .art_option('menu.topItemBegin')
        .__("Empty menu (%s)", THEME_NS)
        .art_option('menu.topItemEnd')
        .'</a></li>', $menu->slug);
  }
  $nav_menu = '';
  $items = '';
  _art_menu_item_classes_by_context($menu_items);
  $sorted_menu_items = array();
  foreach ((array) $menu_items as $key => $menu_item) $sorted_menu_items[$menu_item->menu_order] = wp_setup_nav_menu_item($menu_item);

  $walker = new art_MenuWalker();
  $items .= $walker->walk($sorted_menu_items, 0, array());

  $items = apply_filters('wp_nav_menu_items', $items, $args);
  $items = apply_filters("wp_nav_menu_{$menu->slug}_items", $items, $args);
  $nav_menu .= $items;

  $nav_menu = apply_filters('wp_nav_menu', $nav_menu, $args);
  return $nav_menu;
}

function _art_menu_item_classes_by_context( &$menu_items ) {
global $wp_query;
  $home_page_id = (int) get_option( 'page_for_posts' );
$queried_object = $wp_query->get_queried_object();
$queried_object_id = (int) $wp_query->queried_object_id;
    $active_ID  = null;
    $IdToKey = array();

    foreach ( (array) $menu_items as $key => $menu_item ) {

        $IdToKey[$menu_item->ID] = $key;
        if (
$menu_item->object_id == $queried_object_id &&
(
( ! empty( $home_page_id ) && 'post_type' == $menu_item->type && $wp_query->is_home && $home_page_id == $menu_item->object_id ) ||
( 'post_type' == $menu_item->type && $wp_query->is_singular ) ||
( 'taxonomy' == $menu_item->type && ( $wp_query->is_category || $wp_query->is_tag || $wp_query->is_tax ) )
)
) {

$active_ID = $menu_item->ID;

} elseif ( 'custom' == $menu_item->object ) {

$current_url = ( is_ssl() ? 'https://' : 'http://' ) . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
$item_url = strpos( $menu_item->url, '#' ) ? substr( $menu_item->url, 0, strpos( $menu_item->url, '#' ) ) : $menu_item->url;

if ( $item_url == $current_url ) {
$active_ID = $menu_item->ID;
}
}
}


    $currentID = $active_ID;
    while ($currentID !== null && isset($IdToKey[$currentID])) {
        $current_item = $menu_items[$IdToKey[$currentID]];
        $current_item->classes[] = 'active';
        $currentID = $current_item->menu_item_parent;

        if ($currentID === '0') break;

    }
}

class art_MenuWalker extends Walker {
  var $tree_type = array('post_type', 'taxonomy', 'custom');
  var $db_fields = array('parent' => 'menu_item_parent', 'id' => 'db_id');
  var $is_active = false;

  function start_lvl(&$output, $depth) {
    $indent = str_repeat("\t", $depth);
    $output .= "\n$indent<ul";
    if ($this->is_active){
        $output .= ' class="active" ';
    }
    $output .= ">\n";
    $this->is_active = false;
  }

  function end_lvl(&$output, $depth) {
   $indent = str_repeat("\t", $depth);
   $output .= "$indent</ul>\n";
  }

  function start_el(&$output, $item, $depth, $args) {
    global $wp_query;
    $indent = ($depth) ? str_repeat("\t", $depth) : '';


    $classes = empty( $item->classes ) ? array() : (array) $item->classes;
    $class_names = join( ' ', apply_filters( 'nav_menu_css_class', array_filter( $classes ), $item ) );

    $active = in_array('active', $classes);

    $output .= $indent . '<li';
    if ($active) {
      $this->is_active = true;
      $output .= ' class="active" ';
    } else {
$output .= ' class="1" '; // This line.....
}

    $output .= '>';

    $attributes  = ! empty($item->attr_title) ? ' title="'  . attribute_escape($item->attr_title) .'"' : '';
    $attributes .= ! empty($item->target)     ? ' target="' . attribute_escape($item->target)     .'"' : '';
    $attributes .= ! empty($item->xfn)        ? ' rel="'    . attribute_escape($item->xfn)        .'"' : '';
    $attributes .= ! empty($item->url)        ? ' href="'   . attribute_escape($item->url)        .'"' : '';
    $attributes .= ! empty($class_names)      ? ' class="'  . attribute_escape($class_names)      .'"' : '';

    $item_output .= '<a'. $attributes .'>';
    if ($depth == 0) $item_output .= art_option('menu.topItemBegin');
    $item_output .= apply_filters('the_title', $item->title, $item->ID);
    if ($depth == 0) $item_output .= art_option('menu.topItemEnd');
    $item_output .= '</a>';

    $output .= apply_filters( 'walker_nav_menu_start_el', $item_output, $item, $depth, $args );
  }

  function end_el(&$output, $item, $depth) {
    $output .= "</li>\n";
    $this->is_active = false;
  }
}

/* pages */
function art_get_list_pages($args = array()) {
  global $wp_query;
  $pages = &get_pages($args);

  $IdToKey = array();
  $currentID = null;

  foreach ($pages as $key => $page)
  {
    $IdToKey[$page->ID] = $key;
  }

  if ($wp_query->is_page) {
    $currentID = $wp_query->get_queried_object_id();
  }

  $frontID = null;
  $blogID = null;
  if ('page' == get_option('show_on_front')) {

    $frontID = get_option('page_on_front');
    if ($frontID && isset($IdToKey[$frontID])) {
      $frontKey = $IdToKey[$frontID];
      $frontPage = $pages[$frontKey];
      unset($pages[$frontKey]);
      $frontPage->post_parent = '0';
      $frontPage->menu_order = '0';
      array_unshift($pages, $frontPage);
      $IdToKey = array();
      foreach ($pages as $key => $page)
      {
        $IdToKey[$page->ID] = $key;
      }
    }

    if (is_home()) {
      $blogID = get_option('page_for_posts');
      if ($blogID && isset($IdToKey[$blogID]))
      {
          $currentID = $blogID;
      }
    }
  }


$activeIDs = array();

  $activeID = $currentID;
while($activeID && isset($IdToKey[$activeID]))
{
$activeIDs[] = $activeID;
$activePage = $pages[$IdToKey[$activeID]];

if ($activePage && $activePage->post_status == 'private')
{
break;
}

$activeID = $activePage->post_parent;

}

  $result = '';
  if (art_option('menu.showHome') && ('page' != get_option('show_on_front') || (!get_option('page_on_front') && !get_option('page_for_posts'))))
  {
      $result = '<li><a'
          . (is_home() ? ' class="active"' : '')
          . ' href="'
          . get_option('home')
          . '">'
          .art_option('menu.topItemBegin')
          . art_option('menu.homeCaption')
          .art_option('menu.topItemEnd')
          . '</a></li>';
  }

  if (!empty($pages)) {
    $walker = new art_PageWalker('list', 'ul', $activeIDs, $frontID);
    $result .= $walker->walk($pages,$args['depth'], array(), $currentID);
  }

  return $result;
}

class art_PageWalker extends Walker {
  var $db_fields = array('parent' => 'post_parent', 'id' => 'ID');
  var $activeIDs = array();
  var $frontID = array();
  var $is_active = false;

  function art_PageWalker($type='list', $tag='ul', $activeIDs=array(), $frontID=null){
    $this->tag = $tag;
    $this->activeIDs = $activeIDs;
    $this->frontID = $frontID;
    $this->type = $type;
  }

  function start_lvl(&$output) {
    $output .= "\n<".$this->tag;
    if($this->is_active){
      $output .= ' class="active" ';
    }
    $output .= ">\n";
    $this->is_active = false;
  }

  function end_lvl(&$output) {
    $output .= "</".$this->tag.">\n";
  }

  function start_el(&$output, $page, $depth, $args, $current_page) {
    $active = in_array($page->ID, $this->activeIDs);
    $output .= '<li';
    if ($active) {
      $this->is_active = true;
      $output .= ' class="active" ';
    }
    $output .= '><a';
    if ($active) {
      $output .= ' class="active"';
    }

    $href = get_page_link($page->ID);
    if ($this->frontID && $this->frontID == $page->ID) {
      $href = get_option('home');
    }
    $title = apply_filters( 'the_title', $page->post_title, $page->ID );
    $output .= ' href="'.$href.'" title="'.attribute_escape($title).'">';
    if ($depth == 0) $output .= art_option('menu.topItemBegin');
    $output .= $title;
    if ($depth == 0) $output .= art_option('menu.topItemEnd');
    $output .= '</a>';
  }

  function end_el(&$output, $page) {
    $output .= "</li>\n";
    $this->is_active = false;
  }
}

/* categories */
function art_get_list_categories($args = array()) {
  global $wp_query;
  $categories = &get_categories($args);

  $IdToKey = array();
  foreach ($categories as $key => $category){
    $IdToKey[$category->term_id] = $key;
  }

  $currentID = null;
if ($wp_query->is_category)
{
    $currentID = $wp_query->get_queried_object_id();
  }

$activeID = $currentID;
$activeIDs = array();
while ($activeID && isset($IdToKey[$activeID])) {
      $activeIDs[] = $activeID;
      $activeCategory = $categories[$IdToKey[$activeID]];
      $activeID = $activeCategory->parent;
  }

  $result = '';
  if (!empty($categories)) {
    $walker = new art_CategoryWalker('list','ul', $activeIDs);
    $result .= $walker->walk($categories, $args['depth'], array('count' => false, 'current_category' =>$currentID));
  }
  return $result;
}

class art_CategoryWalker extends Walker {
  var $db_fields = array ('parent' => 'parent', 'id' => 'term_id');
  var $activeIDs = array();
  var $is_active = false;

  function art_CategoryWalker($type='list', $tag='ul', $activeIDs=array()){
    $this->tag = $tag;
    $this->activeIDs = $activeIDs;
    $this->type = $type;
  }

  function start_lvl(&$output){
    $output .= "\n<".$this->tag;
    if ($this->is_active) {
      $output .= ' class="active" ';
    }
    $output .= ">\n";
    $this->is_active = false;
  }

  function end_lvl(&$output) {
    $output .= "</".$this->tag.">\n";
  }

  function start_el(&$output, $category, $depth, $args) {
    $count = intval($category->count);
    $count_text = sprintf(__('%s posts', THEME_NS), $count);

    $active = in_array($category->term_id, $this->activeIDs);

    $output .= '<li';
    if ($active) {
      $this->is_active = true;
      $output .= ' class="active" ';
    }
    $output .= '>';

    if ($category->description) {
      $title = $category->description;
    } else {
     $title = $count_text;
    }

    $output .= '<a';
    if ($active) {
      $output .= ' class="active"';
    }
    $output .= ' href="'.get_category_link($category->term_id).'" title="'.$title.'">';
    if ($depth == 0) $output .= art_option('menu.topItemBegin');
$output .= attribute_escape($category->name);
    if ($depth == 0) $output .= art_option('menu.topItemEnd');
    $output .= '</a>';

  }

  function end_el(&$output, $page) {
    $output .= "</li>\n";
    $this->is_active = false;
  }
}
This the line...

Code: [Select]
$output .= ' class="1" '; // This line.....
How could I set the class to the page number - So for example if page 1 then background is blue, if its 5 then its green etc...

I want to set up the css but I need to assign the class to the page number.... (Or parent page number if the page number is not top level..)

Any ideas?

Change Post Author Color

Similar Tutorials

View Content

hi all, in my blog (made by me, no wordpress or similar) i would want to change the color of comments written by author of article
My code is:

$sql = "SELECT author WHERE art_id=...";

//print all comments...
while ($row = mysql_fetch_array($result)) {
if ($_SESSION['ID_user'] == $sql['ID_user'] ) {
$color = "#FFFFFF";
} else {
$color = "#FF0000";
}

echo '<div id="comment" style="background-color: ' . $color . '">post</div>';
}

but the code above print all FFFFFF or all FF0000

Where it is wrong? thanks

Change Font Color In If Statement

Similar Tutorials

View Content

Hi,
I have the following code to change font color from within an IF staement but I can't seem to sort it out.

//code
if ($server['b']['ip'] == $adminarray1[6] && $server['b']['c_port'] == $adminarray2[6] && $player['name'] == $adminarray3[6])
   {
   $player['name'] = "<font color='blue'>{$server['p'][$key]['name']}</font>";
   }
//code

any help would be greatly appreciated.
-Dodge

Help Needed To Change Font Color Based On The Value From The Database In Php

Similar Tutorials

View Content

Hi php freaks i am new to php im doin a small project to handle tickets created by customers now i want to change the font color based on the status for

example:

ID + Name + Product + Status
------------------------------------------------------------------------------------------------------------------------------------
1111 + abcdef + bat + processing
----------------+--------------------------------------+------------------------------------------+------------------------------

i can connect to database and fetch it the only place i need help is changing the any help would be very helpful
thanks in advance

Add Background Color If Value Is An Odd Number

Similar Tutorials

View Content

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);

Background Color Depending On Variable

Similar Tutorials

View Content

how can i set the color of a table background depending on what a variable is in my database?

I currently have a table which echos data from my database, but i want the background too be a color depending on the value of a variable called 'status' (there are 3 variations)

the variations are; order placed, processing and complete

so for example:

Code: [Select]
if (status == placed)
{
background would be red
}
Code: [Select]
if (status == processing)
{
background would be orange
}
Code: [Select]
if (status == complete)
{
background would be green
}
appreciate any help. thank you.

Moved: Adding Background Color To A Include File?

Similar Tutorials

View Content

This topic has been moved to HTML Help.

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

Group, Alternating Background Color Based On Category

Similar Tutorials

View Content

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>

Changing Background Color In Lists Using Hex Codes Array In For Loop

Similar Tutorials

View Content

I was trying to show different hex codes as background in a loop for each section of a list.

Here's what I done
Code: [Select]

$rgb;
$rgb["c1"] = "ff4c54";
$rgb["c2"] = "ff764c";
$rgb["c3"] = "ffde4c";
$rgb["c3"] = "c7f25f";
$rgb["c4"] = "33c9f7";
$i=0;
$pargs = array( 'numberposts' => 10,'orderby'=> 'comment_count', );
$myposts = get_posts( $pargs );$max_count=0;
<ul>
foreach( $myposts as $post ) : setup_postdata($post);

<li style="width:300px;background-color:#<?php foreach($rgb as $color => $hex) {
    echo $hex[i];
    $i++;
}  ?>">
<a href="<?php the_permalink(); ?>"><?php the_title(); ?></a> - </li>
<?php endforeach; ?>
</ul>

Ending up with just the white background.. and no change in the background colors.

Kindly help

I Need A Button To Change Value In Mysql From 0 To 1

Similar Tutorials

View Content

I don't know many things in php yet so i need help to find out how to set a button to change value of "Confirmed" row from 0 to 1 in table "sales". I commented "This Button" at the beginning of the button i want to do the process.

<?php
                    $conn = $pdo->open();

                    try{
                      $stmt = $conn->prepare("SELECT *, sales.id AS salesid FROM sales LEFT JOIN users ON users.id=sales.user_id ORDER BY sales_date DESC");
                      $stmt->execute();
                      foreach($stmt as $row){
                        $stmt = $conn->prepare("SELECT * FROM details LEFT JOIN products ON products.id=details.product_id WHERE details.sales_id=:id");
                        $stmt->execute(['id'=>$row['salesid']]);
                        $total = 0;
                        foreach($stmt as $details){
                          $subtotal = $details['price']*$details['quantity'];
                          $total += $subtotal;
                        }
                        if($row['Confirmed'] == 0){
                        echo "
                          <tr>
                            <td class='hidden'></td>
                            <td>".date('M d, Y', strtotime($row['sales_date']))."</td>
                            <td>".$row['firstname'].' '.$row['lastname']."</td>
                            <td>".$row['country'].' , '.$row['city']." , ".$row['address']."</td>
                            <td width='25px;'>&#8378; ".number_format($total, 2)."</td>
                            <td width='18px;'><button type='button' class='btn btn-info btn-sm btn-flat transact' data-id='".$row['salesid']."'><i class='fa fa-search'></i> View</button></td>
                            <td width='18px;'>
                            <!-- This Button --> <button type='button' class='btn btn-success btn-sm btn-flat confirm' data-id='".$row['salesid']."'><i class='fa fa-check'></i> Confirm</button></td>
                          </tr>
                         
                        ";
                        }
                      }
                    }
                    catch(PDOException $e){
                      echo $e->getMessage();
                    }

                    $pdo->close();
                  ?>

Moved: Opening A Popup Window Making The Background Grey Color

Similar Tutorials

View Content

This topic has been moved to JavaScript Help.

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

Change Button Disabled Through Function

Similar Tutorials

View Content

Hi all , here is a question about a disabled button .

If I have a button:
Code: [Select]
<input id='submit' type='submit' disabled='disabled' value='submit'>
Is it possible to change the "disabled=true" through php function ? such as

Code: [Select]
function change_button(){

echo "<script language=\"javascript\">";

echo "document.getElementById('submit').disabled=true;";

echo "</script>";

}

I tried it , not working...is this function possible or have I make any mistake ?
Thanks for every reply .

Moved: Change The Functuion Of A Button

Similar Tutorials

View Content

This topic has been moved to PHP Applications.

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

Change Image Background

Similar Tutorials

View Content

This creates an image 1500x1500 pixels. But it creates it in black... how can i make it white.
And i have to use imagecreatetruecolor() not imagecreate().

<?php

$im = imagecreatetruecolor(1500,1500);

// Output the image to the browser
header('Content-type: image/jpg');

imagejpeg($im);
imagedestroy($im);
?>

Thanks!

Moved: How To Change A Form Button Url Using A Js Variable?

Similar Tutorials

View Content

This topic has been moved to JavaScript Help.

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

How To Change Black Background Of Thumbnail???

Similar Tutorials

View Content

hi, i am trying to generate image gallery. but the problem is that when i upload the png files
its thumbnail is generated with black background. JPEG an GIF thumbnail are generated successfully. i want to make background transparent. is there any solution that how i can get rid of it.

i am using imagecreatetruecolor($thumbwidth, $thumbheight ); to generate thumbnail