Learn VBA & Macros in 1 Week!

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

Full Excel VBA Course - Beginner to Expert

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

Full Excel VBA Course - Beginner to Expert

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

I Need A Php Button To Change Background Color

Similar Tutorials

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>

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

?>

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.

Change Div Background Colour Dependent On Php Variable

Similar Tutorials

View Content

Hi,

I have looked everywhere for a way to do this and would be grateful for a pointer in the right direction.

I want to change the background color of the div with the id of "loggedin", depending on the status. The status currently echos text depending on the value.

Code: [Select]
<div class="grid_12" id="loggedin">

<div>
<ul id="loggedin">
<li><?php global $current_user; get_currentuserinfo(); echo 'Status : ' . $current_user->status . "\n";?></li>

<li>
<?php if ($current_user->status=="RED") echo "Red info"; ?>
<?php if ($current_user->status=="GREEN") echo "Green info"; ?>
<?php if ($current_user->status=="BLUE") echo "Blue info"; ?>
<?php if ($current_user->status=="YELLOW") echo "Yellow info"; ?>

</li>

</div>

</div>
Thanks

Allowing User To Change (variable) Mysql Variable By A Radio Button

Similar Tutorials

View Content

I am trying to allow the user to update a variable he chooses by radio buttons, which they will then input text into a box, and submit, to change some attributes. I really need some help here. It works just fine until I add the second layer of variables on top of it, and I can't find the answer to this question anywhere.

<?PHP require('connect.php'); ?>

<form action ='' method='post'> <select name="id">

<?php
$extract = mysql_query("SELECT * FROM cars");

   while($row=mysql_fetch_assoc($extract)){
   $id = $row['id'];
   $make= $row['make'];
   $model= $row['model'];
   $year= $row['year'];
   $color= $row['color'];

echo "<option value=$id>$color $year $make $model</option>
";}?>

</select>

Which attribute would you like to change?<br />
<input type="radio" name="getchanged" value="make"/>Make<br />
<input type="radio" name="getchanged" value="model"/>Model<br />
<input type="radio" name="getchanged" value="year" />Year<br />
<input type="radio" name="getchanged" value="color"   />Color<br /><br />

   <br /><input type='text' value='' name='tochange'>
   <input type='submit' value='Change' name='submit'>

</form>

//This is where I need help...

<?PHP
if(isset($_POST['submit'])&&($_POST['tochange'])){
mysql_query("
   UPDATE cars
   SET '$_POST[getchanged]'='$_POST[tochange]'
   where id = '$_POST[id]'
         ");}?>

If Statement To Call Custom Field In Wordpress

Similar Tutorials

View Content

Hi all,

I've been struggling to get an if statement to work. I'm new to PHP so bear with me!

I have an events listing page where I pull a value from a custom field to display a 'buy tickets' button. I can get the button to display and it works well but what I need to do is customise the code so if there is no ID present, then a piece of text displays. Any pointers appreciated.

This is one method Im using for custom fields which works well - the if statement works here also.
Code: [Select]
<div>
<p><strong>Location:</strong>
<?php $event_location = get_post_meta($post->ID, 'Event_Location', true);
if ($event_location) {
?>
<?php echo $event_location; ?>
<?php } else { ?>
<p>No Location Available.</p>
<?php } ?>
</p>
</div>
This code pulls in the buy tickets button but I cant figure out how to create an if statement with it! grrrr...

Code: [Select]
<div>
<p>
<?php
$values = get_post_custom_values('Product_ID');
echo get_button_code_for_product($values[0]);
?>
</p>
</div>
I would like it to look for the ID and if it can't find it then displays ' No Product ID' or some such text.

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>

Change Bgcolor On Variable Change.

Similar Tutorials

View Content

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?

How Do I Change This Select Statement To $pdo->query

Similar Tutorials

View Content

I need to convert the following select statement to a pdo->query but have no idea how to get it working:

SELECT t.id FROM 
  ( SELECT g.* 
    FROM location AS g
    WHERE g.start <=  16785408
    ORDER BY g.start DESC, g.end DESC
    LIMIT 1
  ) AS t
WHERE t.end >= 16785408;

Here's the code I'm trying:

<?php

$php_scripts = '../../php/';
require $php_scripts . 'PDO_Connection_Select.php';
require $php_scripts . 'GetUserIpAddr.php';
function mydloader($l_filename=NULL)

{
$ip = GetUserIpAddr();
if (!$pdo = PDOConnect("foxclone_data"))
{    
    exit;
}
    if( isset( $l_filename ) ) {  
        $ext = pathinfo($l_filename, PATHINFO_EXTENSION);
        $stmt = $pdo->prepare("INSERT INTO download (address, filename,ip_address) VALUES (?, ?, inet_aton('$ip'))");
        $stmt->execute([$ip, $ext]) ; 

        $test = $pdo->prepare("SELECT t.id FROM ( SELECT g.id FROM lookup AS g WHERE g.start <= inet_aton($ip) ORDER BY g.start DESC, g.end DESC ) AS  t  WHERE t.end >=inet_aton($ip)");
        $test ->execute() ; 
        $ref = $test->fetchColumn();
        $ref = intval($ref);

        $stmt = $pdo->prepare("UPDATE download SET ref = '$ref' WHERE address = '$ip'");
        $stmt->execute() ;         

        header('Content-Type: octet-stream');
        header("Content-Disposition: attachment; filename={$l_filename}");
        header('Pragma: no-cache');
        header('Expires: 0');        
        readfile($l_filename);
       }
        
    else {
        echo "isset failed";
        }  
}
mydloader($_GET["f"]);
exit;

It gives the following error:

Quote

Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.144.181) ORDER BY g.start DESC, g.end DESC ) AS t WHERE t.end >=inet_aton(7' at line 1 in /home/foxclone/test.foxclone.com/download/mydloader.php:19 Stack trace: #0 /home/foxclone/test.foxclone.com/download/mydloader.php(19): PDO->prepare('SELECT t.id FRO...') #1 /home/foxclone/test.foxclone.com/download/mydloader.php(38): mydloader('foxclone40a_amd...') #2 {main} thrown in /home/foxclone/test.foxclone.com/download/mydloader.php on line 19

How do I fix this?

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

Update Statement, How Would I Select And Change 100 Random From Selection

Similar Tutorials

View Content

There are about 400 records in a database with a field zabp_package = T_SIMT.
They were uploaded in an order where specific category lists were uploaded together. For example, first 100 dining, then 75 insurance, then 150 health, then 75 cars. So from an auto increment standpoint they were inserted in that order.
I want to select at random 100 of these 400 and update two fields. My update statement is:
update `usersOld` SET `m_org` = 'ZABP.org Corporate HQ' , `m_orgID` = 'PFL2a96bW' WHERE `zabp_package` = 'T_SIMT'
This works for all, I just need to limit a random selection to 100.
Any Help on this, thanks in advance.

Variable Not Forcing Else Statement

Similar Tutorials

View Content

Okay so after echoing awardType it says Match which would mean it would go to the else part of the statement but it doesn't. It still shows the dropdown for the characters and don't know why?

Code: [Select]
<?php require ('php/awardsshowNom.php'); ?>

<script type="text/javascript" src="forms/edit/js/awardsshowNom.js"></script>


<form action="#" id="awardsshowNomForm" >
<fieldset>
<legend>Edit Award Nominations</legend>
<?php echo $awardType; ?>
<?php if ($awardType = 'Singular') { ?>
<div class="field required">
<label for="nominees">Nominees</label>
<select class="dropdown" name="charactersDrop" id="charactersDrop" title="Characters Drop">
<option value="">- Select -</option>
<?php
                    while ( $row = mysqli_fetch_array ( $charactersResult, MYSQL_ASSOC ) ) {
                        print "<option value=\"".$row['ID']."\">".$row['characterName']."</option>\r";
                    }
                ?>
</select>
<input type="button" value="Add Character" class="" onclick="HandlerCharacters()"/>
<ul id="characterList">
</ul>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
<? } else { ?>
<div class="field required">
<label for="nominees">Nominees</label>
<select class="dropdown" name="events" id="events" title="Events for <?php echo date("Y") ?>">
<option value="">- Select -</option>
<?php
                    while ( $row = mysqli_fetch_array ( $matchResult, MYSQL_ASSOC ) ) {
                        print "<option value=\"".$row['ID']."\">".$row['segmentTitle']."</option>\r";
                    }
                ?>
</select>
<input type="button" value="Add Match" class="" onclick="AddMatch()"/>
<ul id="matchList">
</ul>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
<?php } ?>
<input type="hidden" name="awardID" id="awardID" value="<?php echo $awardID; ?>" />
<input type="hidden" name="awardShowID" id="awardShowID" value="<?php echo $awardShowID; ?>" />
<input type="hidden" name="awardName" id="awardName" value="<?php echo $awardName; ?>" />
<input type="submit" class="submit" name="editAwardNom" id="editAwardNom" title="Edit Award Nominees" value="Edit Awards Nominees"/>
</fieldset>
</form>



<div class="message message-error">
<h6>Required field missing</h6>
<p>Please fill in all required fields. </p>
</div>
<div class="message message-success">
<h6>Operation succesful</h6>
<p>Arena was added to the database.</p>
</div>

Variable Not Affected Outside If Statement

Similar Tutorials

View Content

Hi guys, I have an interesting situation and I was hoping someone could explain what is going on to me.

I have an enquiry form on a site that sends an e-mail. All the code is on one page with the form submitting back to the same page. I have a variable, msg, which at the top of the page is set to nothing and then an if statement to see if the form was submitted. If the form was submitted then msg will have one of three messages in it by the end (regardless of anything else). However when I check the msg variable after the if statement it is empty.

To test if it was being affected I changed the initial value from nothing to TEST. After the IF statement the variable still held the value TEST, thus confirming it wasn't being affected by the IF statement. Now onto my code (the whole page is over 600 lines long so I'm only posting the relevant code):

Code: [Select]
<?php
session_start();
$msg = '';
$input = array(
24 variables from form here...
);
if(isset($_POST['form-submitted'])) {
$missing_info = FALSE;
$array = array(
variables along with their filter validation/sanitize types...
);
$input = filter_input_array(INPUT_POST, $array);
/* PHP validation code checking appropriate fields were not empty. If they were set $missing_info = TRUE */

if(!$missing_info) {
/* Construct e-mail, this sends successfully. */
if(mail($to, $subject, $content, $headers)) {
$msg = '<div class="message"><h1>Form Sent</h1><br />Your form has been sent to us. We endevour to respond to all booking requests with 2 working days. If you have not heard from us in that time please contact us on 01462 893620. If you chose to confirm by post please allow 5 working days before contacting us.</div>';
$_SESSION['msg'] = $msg;
} else {
$msg = '<div class="message"><h1>Technical Issues</h1><br />We appologise but the website is currently experiencing technical difficulties. Please try again later or print this form out and post / fax it to us. Alternatively you can call us on 01462 893620.</div>';
$_SESSION['msg'] = $msg;
}
} else {
$msg = '<div class="message"><h1>Incomplete Form<h1><br />Please make sure to complete all fields of the form before submitting your booking request.</div>';
$_SESSION['msg'] = $msg;
}
}
if(isset($_SESSION['msg'])) {
$msg = $_SESSION['msg'];
unset($_SESSION['msg']);
}
?>

If I don't load the message into session and then back out of session after the if statement then $msg will still hold whatever it was initially set to (in this case an empty string). Why isn't it set in the if statement?

Duplicate Every Row Of Table And Also Change One Field?

Similar Tutorials

View Content

Is there a way to duplicate all rows in a table AND change one field's value for each new row? For example... TABLE: comments FIELDS: commentid userid comment weeknumber Say there are only 5 comments in there like this (I have MANY rows, but keeping sample size small for example's sake)... 1-17-hello-3 2-41-hey-3 3-18-yo-3 4-67-sup-3 5-12-hola-3 I would like to duplicate them AND make the "weeknumber" = 4, so the table ultimately has 10 rows like this... 1-17-hello-3 2-41-hey-3 3-18-yo-3 4-67-sup-3 5-12-hola-3 1-17-hello-4 2-41-hey-4 3-18-yo-4 4-67-sup-4 5-12-hola-4 Is this doable? Thanks...

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

Session Variable Losing Value In If Else Statement

Similar Tutorials

View Content

I'm having an issue with holding a session variable in the statement below $Color is losing its value in the if statement. For example int the ( ) $Color is a zero while in the echo part $Color is being displayed correctly as Blue.

How To Assign A Variable The Value Of A Mathematical If Statement?

Similar Tutorials

View Content

basically, I have one calculation that relies on the value returned by an if statement, but i can;t for the life of me figure it out correctly... Here is what i am trying to accomplish:

Here is the code for the IF i need to get the value of

if ($loadedMiles < 500) {
(500 - $loadedMiles) * .25 * $mainRate;
}

And here is the reason why i need it:

if ($loadSize == "Full") {
$loadedmiles + thevalueoftheif;
}

basically i will need to have a way to get the values of the functions in the IF statements if that makes any sense...

thanks in advance!

If Statement With Session Variable Problem

Similar Tutorials

View Content

OK, I think I have confused this code and it is not calculating correctly.
$ckifdue = mysql_query("SELECT * FROM accounting WHERE ClientID = '$clientid'") or die(mysql_error());
while($ckdue =mysql_fetch_array($ckifdue)){
    if($ckdue['AmountDue'] == "0"){
        $_SESSION['MONEYOWED'] = "0.00";
    }
    else
    {
       $_SESSION['MONEYOWED'] = $_SESSION['MONEYOWED'] + $ckdue['AmountDue'];
    }
    if($ckdue['Amount1RS'] == "Balance Due"){
        $totcol = $ckdue['TotalCollected'];
        echo " total collected:" . $totcol;
        $monpaid = $_SESSION['MONEYPAID'];
        echo "money paid in:" . $monpaid;
        $_SESSION['MONEYPAID'] =  $totcol + $monpaid;
        echo "session money paid:" . $_SESSION['MONEYPAID'];
    }
}
$moneypaid  = $_SESSION['MONEYPAID'];
$moneyowed = $_SESSION['MONEYOWED'];
echo "money paid:" . $moneypaid;
echo " money owed:" . $moneyowed;
$moneyowed = $moneyowed - $moneypaid;
unset($_SESSION['MONEYOWED']);
unset($_SESSION['MONEYPAID']);
The echos look like:

total collected:100.00money paid in:200session money paid:300 total collected:100.00money paid in:300session money paid:400money paid:400 money owed:0.00

There should be $100 due, $200 paid, so a balance of -100. There is 2 balance due reciepts, this is just not calclating right in the sessions.