Learn VBA & Macros in 1 Week!

PHP - Exclude Items From Menu

Full Excel VBA Course - Beginner to Expert

Exclude Items From Menu	View Content

Hi,

I have this menu code which displays a drop down menu:

<ul>
<li><a href="<?php echo URL_PUBLIC; ?>">Home</a></li>
<?php
function submenu($list, $ul){
if($ul){
echo "
<ul>";}
foreach($list->children() as $newList){
echo '
<li>'.$newList->link($newList->title, (in_array($newList->slug, explode('/', $newList->url)) ? ' class="current"': null));
if ($newList->childrenCount() > 0) {
submenu($newList, true);
}else{echo "</li>";}
}
if($ul){echo "

</ul></li>";}
}

submenu($this->find('/'), false);
?>
<br style="clear: left" />
</ul>

I am trying to exclude certain menu items based on their slug.

I have this code, but can't work it into the above:

$omit_pages = array('page1', 'page2');
if (in_array($menu->slug, $omit_pages)) {
continue;
}

Does anyone have any ideas how I can work it in?

Thanks

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Sortable Menu - Get Only Menu 1 Items

Sort Menu Items In Array

Trying To Do A Drop Down Menu Of Items In The Database

Help With Adding Items From Select Menu Into Session

Need A Php Code To Delete Selected Items Of Database Items Using Checkbox

Trying To Exclude Something From Table

Exclude Empty Fields In Email

Null Fields And If/else On Join Won't Exclude

Truncate A Mysql Table But Exclude First Column

Moved: How Do You Exclude Data In A Mysql Query?

Moved: A Query To Exclude Certn Fields That Match

Save Items To Buy

Display Ads After Every 4 Items

Remove Selected Items

Two Similar Items In An Array

Grab All Items That Start With X

Display Table Items

You Viewed Items, Strategy?

Learn VBA & Macros for Excel in 1 Week!

Sortable Menu - Get Only Menu 1 Items

Similar Tutorials

Hi All, Am sure this is simple but can't work it out. I have the following which creates 3 menus:

<p>Drag items from one menu to another</p>
<table>
	<tr>
		<td valign="top">Menu 1</td>
		<td valign="top">Menu 2</td>
		<td valign="top">Menu 3</td>
	</tr>
	<tr>
		<td valign="top">
		<ul class="sortable" id="menu1">
			<li id="id_1">Item 1</li>
			<li id="id_2">Item 2</li>
		</ul>		
		</td>
		<td valign="top">
		<ul class="sortable" id="menu2">
			<li id="id_3">Item 3</li>
			<li id="id_4">Item 4</li>
		</ul>		
		</td>
		<td valign="top">
		<ul class="sortable" id="menu3">
			<li id="id_5">Item 5</li>
			<li id="id_6">Item 6</li>
		</ul>		
		</td>
	</tr>
</table>

This uses the following to show an array of each menu:

$(function() {
 $("ul.sortable").sortable({
    connectWith: '.sortable',
    update: function(event, ui) {
    $('#menu_choice').empty().html( $('.sortable').serial() );
    }
  });
});

(function($) {
$.fn.serial = function() {
 var array = [];
 var $elem = $(this); 
    $elem.each(function(i) {
      var menu = this.id;
        $('li', this).each(function(e) {
                array.push( menu + '['+e+']=' + this.id  );
        });
    });
    return array.join('&');      
    }
 
})(jQuery);

What I'd like is to simply grab the values of menu 1 only, as the array shows all menus. What am I doing wrong as can't seem to just return menu1. Going forward, I then want to store the returned array into a PHP cookie if this is possible? Many thanks

Sort Menu Items In Array

Similar Tutorials

Hi guys,
I'm just working on a script to get menu items from a database, sorted by a sort column. Each item needs to be checked to see if it has a parent, then paired with the parent.

Would it be best to get all of the items at once and pair them with PHP, or get the children of each item when as a separate array?

id label link parent sort 1 Home index.php 0 10 2 About about.php 0 20 3 Contact Us contact.php 2 10

Trying To Do A Drop Down Menu Of Items In The Database

Similar Tutorials

I'm trying to make it so that someone can add an item to the shop based upon the current items within the database.

How do I go about doing that? I know i have to change <input> to <select>, but beyond that, how do I code it so I can run an array to get all the current items from the table `items` and list them by their `name` field?

Thanks in advance!

Here is what I have so far:

function addshopinv($id) {
error_reporting(E_ALL);
ini_set('display_errors', 1);
   if (isset($_POST["submit"])) {
        extract($_POST);
        $errors = 0;
        $errorlist = "";
        if ($name == "") { $errors++; $errorlist .= "Name is required.<br />"; }
else if ($errors == 0) {
$dbh=dbconnect() or die ("Userlist read error: " . mysql_error()."<br>");
mysql_select_db("XXX");
$query = mysql_query("SELECT id FROM items WHERE name='$name'");
while ($result = mysql_fetch_array($query)){
$item_id = $result['id'];
$query1 = mysql_query("INSERT INTO sale SET shop_id='$id', item_id='$item_id'");
}
            admindisplay("Inventory Item Added.","Add New Inventory Item");
        } else {
            admindisplay("<b>Errors:</b><br /><div style=\"color:red;\">$errorlist</div><br />Please go back and try again.", "Add New Item to Shop");
        }
   }

   $page = <<<END
<b><u>Add New Inventory Item</u></b><br /><br />
<form action="admin_panel.php?do=addshopinv:$id" method="post">
<table width="90%">
<tr><td width="20%">Name:</td><td><input type="text" name="name" size="30" maxlength="255" value="" />*255 character max</td></tr>
</table>
<input type="submit" name="submit" value="Submit" /> <input type="reset" name="reset" value="Reset" />
</form>
END;
    $page = parsetemplate($page, $row);
    admindisplay($page, "Add New Inventory Item");
}

Help With Adding Items From Select Menu Into Session

Similar Tutorials

hello all, I was hoping someone could help me figure out how to add sizes to my shopping cart.
Right now the items add just fine. The site sells shirts and I'm having trouble displaying the sizes once selected and added to the cart. It will post the size selected, but if the customer tries to add another shirt the size will overwrite the last.

Any help is appreciated.

Heres how I add items to the cart...
Code: [Select]
session_start();
// Process actions
$cart = $_SESSION['cart'];
$action = $_GET['action'];
switch ($action) {
case 'empty':
if($cart) {
unset($cart);
}
break;
case 'add':
if ($cart) {
$cart .= ','.$_GET['product_id'];
} else {
$cart = $_GET['product_id'];
}
break;
The form with the size selection and add to cart button..
Code: [Select]
<form action="cart.php?action=add&product_id=<?php echo $row_rs_products['product_id'] ?>" method="POST" name="addcart" id="addcart">
<table width="300" border="0">
<tr>
<td><label for="sizes"></label>
<select name="product_size" id="product_size" title="<?php echo $row_rs_products['product_size']; ?>">
<?php
do {
?>
<?php
} while ($row_rs_sizes = mysql_fetch_assoc($rs_sizes));
  $rows = mysql_num_rows($rs_sizes);
  if($rows > 0) {
      mysql_data_seek($rs_sizes, 0);
  $row_rs_sizes = mysql_fetch_assoc($rs_sizes);
  }
?>
</select></td>
<td><input type="submit" name="submit" id="submit" value="add to cart">
function displaying the cart..
Code: [Select]
function showCart() {
global $db;
$cart = $_SESSION['cart'];
if ($cart) {
$items = explode(',',$cart);
$contents = array();
foreach ($items as $item) {
$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
}
$output[] = '<form action="cart.php?action=update" method="post" id="cart">';
$output[] = '<table>';
// start div
$output[] = '<div id="cart_table">';
//
$output[] = '<tr>';
$output[] = '<td><h4>Product</h4></td>';
$output[] = '<td><h4>Item No.</h4></td>';
$output[] = '<td><h4>Price</h4></td>';
$output[] = '<td><h4>Size</h4></td>';
$output[] = '<td><h4>Quantity</h4></td>';
$output[] = '<td><h4>Price Total</h4></td>';
$output[] = '<td><h4> </h4></td>';
$output[] = '</tr>';
//new row
foreach ($contents as $product_id=>$qty) {
$sql = 'SELECT * FROM products WHERE product_id = '.$product_id;
$result = $db->query($sql);
$row = $result->fetch();
extract($row);
//
$output[] = '<tr>';
$output[] = '<td><a href="product.php?product_id='.$product_id.'">'.$product_title.'</a></td>';
$output[] = '<td>'.$product_plu.'</td>';
$output[] = '<td>$'.$product_price.'</td>';
//
//$output[] = '<td>'.$product_size.'</td>';
$output[] = '<td>'.$_POST['product_size'].'</td>';
//
$output[] = '<td><input type="text" name="qty'.$product_id.'" value="'.$qty.'" size="3" maxlength="3" /></td>';
$output[] = '<td>X $'.($product_price * $qty).'</td>';
$total += $product_price * $qty;
$output[] = '<td><a href="cart.php?action=delete&product_id='.$product_id.'" class="r">Remove</a> </td>';
$output[] = '</tr>';
//end div
$output[] = '</div>';

}
$output[] = '</table>';
$output[] = '<p>Grand total: <strong>$'.$total.'</strong></p>';
$output[] = '<div class="float-right"><button type="submit">Update cart</button>';
$output[] = '</form>';

Need A Php Code To Delete Selected Items Of Database Items Using Checkbox

Similar Tutorials

I have a webpage where all the database items are displyes in a table format.The table also has a check box.Upon clicking the delete button i need to delete all the items whish has the checkbox checked.
How will i do that

Trying To Exclude Something From Table

Similar Tutorials

I want to run a query on table 1 but exclude records if the field v3 matches the field "mrn" in table 2:

I was told to use LEFT OUTER JOIN but this doens't work:

Code:
SELECT * FROM pts LEFT OUTER JOIN p_list ON pts.v3 = p_list.mrn WHERE pts.v3 IS NULL

When I do that nothing is displayed. I don't know if the "IS NULL" term is the problem. Can someone help me with what the php code is to make that query work?

Exclude Tags

Similar Tutorials

I made a script to grab the data between these tags on my page:
Code: [Select]
<td class="numbers">
</td>
It shows only the numbers and that's what I want (see Ex: ) but if I view the source code it shows this:
Code: [Select]
Andreea - <td class="numbers">111</td><br />
Claudia - <td class="numbers">30</td><br />
Daniel - <td class="numbers">37</td><br />
Adela - <td class="numbers">4</td><br />
Is there a way to display the result without those tags ?

Ex: Andreea - 111
Claudia - 30
............

As you can see, I only need the numbers, there's nothing else inside those tags.

Exclude Empty Fields In Email

Similar Tutorials

Hi,
I searched and couldn't find a previous solution..

I'm supposed to take this existing long form and tweak it so it excludes empty fields when emailed.. Can anyone show me what would work for this code below? Any help would be greatly appreciated..

Sorry for the long code, i didn't know where to cut it off..

Code: [Select]
<?php
$EmailTo = Trim(stripslashes($_POST['EmailTo']));
$EmailFrom = Trim(stripslashes($_POST['EmailFrom']));
$Subject = "";

// terms
$terms_conditions_details = Trim(stripslashes($_POST['terms_conditions_details']));

// contact information
$full_name = Trim(stripslashes($_POST['full_name']));
$title = Trim(stripslashes($_POST['title']));
$company = Trim(stripslashes($_POST['company']));
$billing_address = Trim(stripslashes($_POST['billing_address']));
$billing_city = Trim(stripslashes($_POST['billing_city']));
$billing_state = Trim(stripslashes($_POST['billing_state']));
$billing_zip = Trim(stripslashes($_POST['billing_zip']));
$phone = Trim(stripslashes($_POST['phone']));
$alt_phone = Trim(stripslashes($_POST['alt_phone']));
$how_did_you_hear = Trim(stripslashes($_POST['how_did_you_hear']));

// event information
$event_date = Trim(stripslashes($_POST['event_date']));
$guests = Trim(stripslashes($_POST['guests']));
$event_start_time = Trim(stripslashes($_POST['event_start_time']));
$event_end_time = Trim(stripslashes($_POST['event_end_time']));
$event_address = Trim(stripslashes($_POST['event_address']));
$event_city = Trim(stripslashes($_POST['event_city']));
$event_state = Trim(stripslashes($_POST['event_state']));
$event_zip = Trim(stripslashes($_POST['event_zip']));
$event_type = Trim(stripslashes($_POST['event_type']));
$event_type_other = Trim(stripslashes($_POST['event_type_other']));
$event_theme = Trim(stripslashes($_POST['event_theme']));
$special_requests = Trim(stripslashes($_POST['special_requests']));
$budget = Trim(stripslashes($_POST['budget']));
$service_type = Trim(stripslashes($_POST['service_type']));

// wings & wingers
$grilled_wings = Trim(stripslashes($_POST['grilled_wings']));
$buffalo_wings = Trim(stripslashes($_POST['buffalo_wings']));
$wingers = Trim(stripslashes($_POST['wingers']));
$wing_sauces1 = Trim(stripslashes($_POST['wing_sauces1']));
$wing_sauces2 = Trim(stripslashes($_POST['wing_sauces2']));
$wing_sauces3 = Trim(stripslashes($_POST['wing_sauces3']));
$wing_sauces4 = Trim(stripslashes($_POST['wing_sauces4']));
$wing_sauces5 = Trim(stripslashes($_POST['wing_sauces5']));
$wing_sauces6 = Trim(stripslashes($_POST['wing_sauces6']));
$wing_sauces7 = Trim(stripslashes($_POST['wing_sauces7']));
$wing_sauces8 = Trim(stripslashes($_POST['wing_sauces8']));
$wing_sauces9 = Trim(stripslashes($_POST['wing_sauces9']));
$wing_sauces10 = Trim(stripslashes($_POST['wing_sauces10']));
$wing_sauces11 = Trim(stripslashes($_POST['wing_sauces11']));
$wing_sauces12 = Trim(stripslashes($_POST['wing_sauces12']));
$wing_sauces13 = Trim(stripslashes($_POST['wing_sauces13']));
$wing_sauces14 = Trim(stripslashes($_POST['wing_sauces14']));

// party platters
$chicken_finger_platter = Trim(stripslashes($_POST['chicken_finger_platter']));
$chicken_nugget_platter = Trim(stripslashes($_POST['chicken_nugget_platter']));
$chicken_wing_platter = Trim(stripslashes($_POST['chicken_wing_platter']));

// salads
$caesar_salad = Trim(stripslashes($_POST['caesar_salad']));
$house_salad = Trim(stripslashes($_POST['house_salad']));
$cobb_salad = Trim(stripslashes($_POST['cobb_salad']));
$sea_breeze_salad = Trim(stripslashes($_POST['sea_breeze_salad']));

// appetizers
$fresh_fruit_platter = Trim(stripslashes($_POST['fresh_fruit_platter']));
$chilled_vegetable_platter = Trim(stripslashes($_POST['chilled_vegetable_platter']));
$cocktail_shrimp = Trim(stripslashes($_POST['cocktail_shrimp']));
$tailgate_chips_platter = Trim(stripslashes($_POST['tailgate_chips_platter']));
$chips_and_salsa = Trim(stripslashes($_POST['chips_and_salsa']));
$spinach_artichoke_dip_platter = Trim(stripslashes($_POST['spinach_artichoke_dip_platter']));
$quesadilla_platter = Trim(stripslashes($_POST['quesadilla_platter']));

// entrees
$bbq_ribs_platter = Trim(stripslashes($_POST['bbq_ribs_platter']));
$hawaiian_chicken = Trim(stripslashes($_POST['hawaiian_chicken']));
$mahi_over_rice = Trim(stripslashes($_POST['mahi_over_rice']));

// sandwiches
$gourmet_slider_platter = Trim(stripslashes($_POST['gourmet_slider_platter']));
$mini_cheeseburger_platter = Trim(stripslashes($_POST['mini_cheeseburger_platter']));
$club_sandwich_platter = Trim(stripslashes($_POST['club_sandwich_platter']));
$turkey_wrap_platter = Trim(stripslashes($_POST['turkey_wrap_platter']));
$philly_cheese_platter = Trim(stripslashes($_POST['philly_cheese_platter']));

// dessert
$chocolate_brownie_platter = Trim(stripslashes($_POST['chocolate_brownie_platter']));
$apple_crisp = Trim(stripslashes($_POST['apple_crisp']));
$mini_gourmet_cheesecakes = Trim(stripslashes($_POST['mini_gourmet_cheesecakes']));

//$10 meal deal
$meal_deal_wings = Trim(stripslashes($_POST['meal_deal_wings']));
$meal_deal_grilled_chicken = Trim(stripslashes($_POST['meal_deal_grilled_chicken']));
$meal_deal_burger = Trim(stripslashes($_POST['meal_deal_burger']));
$meal_deal_lemonade = Trim(stripslashes($_POST['meal_deal_lemonade']));
$meal_deal_iced_tea = Trim(stripslashes($_POST['meal_deal_iced_tea']));
$meal_deal_sauces1 = Trim(stripslashes($_POST['meal_deal_sauces1']));
$meal_deal_sauces2 = Trim(stripslashes($_POST['meal_deal_sauces2']));
$meal_deal_sauces3 = Trim(stripslashes($_POST['meal_deal_sauces3']));
$meal_deal_sauces4 = Trim(stripslashes($_POST['meal_deal_sauces4']));
$meal_deal_sauces5 = Trim(stripslashes($_POST['meal_deal_sauces5']));
$meal_deal_sauces6 = Trim(stripslashes($_POST['meal_deal_sauces6']));
$meal_deal_sauces7 = Trim(stripslashes($_POST['meal_deal_sauces7']));
$meal_deal_sauces8 = Trim(stripslashes($_POST['meal_deal_sauces8']));
$meal_deal_sauces9 = Trim(stripslashes($_POST['meal_deal_sauces9']));
$meal_deal_sauces10 = Trim(stripslashes($_POST['meal_deal_sauces10']));
$meal_deal_sauces11 = Trim(stripslashes($_POST['meal_deal_sauces11']));
$meal_deal_sauces12 = Trim(stripslashes($_POST['meal_deal_sauces12']));
$meal_deal_sauces13 = Trim(stripslashes($_POST['meal_deal_sauces13']));
$meal_deal_sauces14 = Trim(stripslashes($_POST['meal_deal_sauces14']));

// box lunches
$box_turkey_ruben = Trim(stripslashes($_POST['box_turkey_ruben']));
$box_blt_on_ciabatta = Trim(stripslashes($_POST['box_blt_on_ciabatta']));
$box_club = Trim(stripslashes($_POST['box_club']));
$box_ham_and_cheese = Trim(stripslashes($_POST['box_ham_and_cheese']));
$box_chipolte_shrimp_blt = Trim(stripslashes($_POST['box_chipolte_shrimp_blt']));
$box_turkey_bacon_ranch = Trim(stripslashes($_POST['box_turkey_bacon_ranch']));
$box_buffalo_chicken = Trim(stripslashes($_POST['box_buffalo_chicken']));
$box_veggie = Trim(stripslashes($_POST['box_veggie']));
$box_caesar_salad = Trim(stripslashes($_POST['box_caesar_salad']));
$box_house_salad = Trim(stripslashes($_POST['box_house_salad']));
$box_cobb_salad = Trim(stripslashes($_POST['box_cobb_salad']));
$box_sea_breeze_salad = Trim(stripslashes($_POST['box_sea_breeze_salad']));

// full service catering
$theme_package = Trim(stripslashes($_POST['theme_package']));
$theme_package_information = Trim(stripslashes($_POST['theme_package_information']));
$reception = Trim(stripslashes($_POST['reception']));
$reception_information = Trim(stripslashes($_POST['reception_information']));
$specialty_stations = Trim(stripslashes($_POST['specialty_stations']));
$bar_beverage_service = Trim(stripslashes($_POST['bar_beverage_service']));
$bar_beverage_service_information = Trim(stripslashes($_POST['bar_beverage_service_information']));
$breakfast = Trim(stripslashes($_POST['breakfast']));
$breakfast_information = Trim(stripslashes($_POST['breakfast_information']));
$notes = Trim(stripslashes($_POST['notes']));

// payment
$payment1 = Trim(stripslashes($_POST['payment1']));
$payment2 = Trim(stripslashes($_POST['payment2']));
$payment3 = Trim(stripslashes($_POST['payment3']));
$payment4 = Trim(stripslashes($_POST['payment4']));
$payment5 = Trim(stripslashes($_POST['payment5']));
$payment6 = Trim(stripslashes($_POST['payment6']));

// confirmation email
$confirmation_subject = "";
$confirmation_body = "$full_name,\n\n
Thank you for emailing us. A catering manager from your location will get in touch with you shortly.\n\n
\n
\n";

$Body = "";

$Body .= "CONTACT INFORMATION\n";
$Body .= "\nFull Name: ";
$Body .= $full_name;
$Body .= "\nTitle: ";
$Body .= $title;
$Body .= "\nCompany: ";
$Body .= $company;
$Body .= "\nBilling Address: ";
$Body .= $billing_address;
$Body .= ", ";
$Body .= $billing_city;
$Body .= ", ";
$Body .= $billing_state;
$Body .= ", ";
$Body .= $billing_zip;
$Body .= "\nPhone: ";
$Body .= $phone;
$Body .= "\nAlternate Phone: ";
$Body .= $alt_phone;
$Body .= "\nHow did you hear about us?: ";
$Body .= $how_did_you_hear;
$Body .= "\n";
$Body .= $terms_conditions_details;

$Body .= "\n\nEVENT INFORMATION\n";
$Body .= "\nEvent Date: ";
$Body .= $event_date;
$Body .= "\nNumber of Guests: ";
$Body .= $guests;
$Body .= "\nEvent Start Time: ";
$Body .= $event_start_time;
$Body .= "\nEvent End Time: ";
$Body .= $event_end_time;
$Body .= "\nEvent Address: ";
$Body .= $event_address;
$Body .= ", ";
$Body .= $event_city;
$Body .= ", ";
$Body .= $event_state;
$Body .= ", ";
$Body .= $event_zip;
$Body .= "\nType of Event: ";
$Body .= $event_type;
$Body .= "\nType of Event: Other: ";
$Body .= $event_type_other;
$Body .= "\nEvent Theme: ";
$Body .= $event_theme;
$Body .= "\nSpecial Requests: ";
$Body .= $special_requests;
$Body .= "\nBudget: ";
$Body .= $budget;
$Body .= "\nType of Service: ";
$Body .= $service_type;

$Body .= "\n\nWINGS & WINGERS\n";
$Body .= "\nGrilled Wings: ";
$Body .= $grilled_wings;
$Body .= "\nBuffalo Wings: ";
$Body .= $buffalo_wings;
$Body .= "\nWingers: ";
$Body .= $wingers;
$Body .= "\nWing Sauces: ";
$Body .= "$wing_sauces1, $wing_sauces2, $wing_sauces3, $wing_sauces4, $wing_sauces5, $wing_sauces6, $wing_sauces7, $wing_sauces8, $wing_sauces9, $wing_sauces10, $wing_sauces11, $wing_sauces12, $wing_sauces13, $wing_sauces14";

$Body .= "\n\nPARTY PLATTERS\n";
$Body .= "\nChicken Finger Platter: ";
$Body .= $chicken_finger_platter;
$Body .= "\nChicken Nugget Platter: ";
$Body .= $chicken_nugget_platter;
$Body .= "\nChicken Wing Platter: ";
$Body .= $chicken_wing_platter;

$Body .= "\n\nSALADS\n";
$Body .= "\nCaesar Salad: ";
$Body .= $caesar_salad;
$Body .= "\nHouse Salad: ";
$Body .= $house_salad;
$Body .= "\nCobb Salad: ";
$Body .= $cobb_salad;
$Body .= "\nSea Breeze Salad: ";
$Body .= $sea_breeze_salad;

$Body .= "\n\nAPPETIZERS\n";
$Body .= "\nFresh Fruit Platter: ";
$Body .= $fresh_fruit_platter;
$Body .= "\nChilled Vegetable Platter: ";
$Body .= $chilled_vegetable_platter;
$Body .= "\nCocktail Shrimp: ";
$Body .= $cocktail_shrimp;
$Body .= "\nTailgate Chips Platter: ";
$Body .= $tailgate_chips_platter;
$Body .= "\nChips and Salsa: ";
$Body .= $chips_and_salsa;
$Body .= "\nSpinach Artichoke Dip Platter: ";
$Body .= $spinach_artichoke_dip_platter;
$Body .= "\nQuesadilla Platter: ";
$Body .= $quesadilla_platter;

$Body .= "\n\nENTREES\n";
$Body .= "\nBBQ Ribs Platter: ";
$Body .= $bbq_ribs_platter;
$Body .= "\nHawaiian Chicken: ";
$Body .= $hawaiian_chicken;
$Body .= "\nMahi Over Rice: ";
$Body .= $mahi_over_rice;

$Body .= "\n\nSANDWICHES\n";
$Body .= "\nGourmet Slider Platter: ";
$Body .= $gourmet_slider_platter;
$Body .= "\nMini Cheeseburger Platter: ";
$Body .= $mini_cheeseburger_platter;
$Body .= "\nClub Sandwich Platter: ";
$Body .= $club_sandwich_platter;
$Body .= "\nTurkey Wrap Platter: ";
$Body .= $turkey_wrap_platter;
$Body .= "\nPhilly Cheese Platter: ";
$Body .= $philly_cheese_platter;

$Body .= "\n\nDESSERT\n";
$Body .= "\nChocolate Brownie Platter: ";
$Body .= $chocolate_brownie_platter;
$Body .= "\nApple Crisp: ";
$Body .= $apple_crisp;
$Body .= "\nMini Gourmet Cheesecakes: ";
$Body .= $mini_gourmet_cheesecakes;

$Body .= "\n\n$10 MEAL DEAL\n";
$Body .= "\nWings: ";
$Body .= $meal_deal_wings;
$Body .= "\nGrilled Chicken Breast: ";
$Body .= $meal_deal_grilled_chicken;
$Body .= "\nBurger: ";
$Body .= $meal_deal_burger;
$Body .= "\nLemonade: ";
$Body .= $meal_deal_lemonade;
$Body .= "\nIced Tea: ";
$Body .= $meal_deal_iced_tea;
$Body .= "\nWing Sauces: ";
$Body .= "\n\nBOX LUNCHES\n";
$Body .= "\nSandwiches";
$Body .= "\nTurkey Ruben: ";
$Body .= $box_turkey_ruben;
$Body .= "\nBLT on Ciabatta Bread: ";
$Body .= $box_blt_on_ciabatta;
$Body .= "\nClub: ";
$Body .= $box_club;
$Body .= "\nHam and Cheese: ";
$Body .= $box_ham_and_cheese;
$Body .= "\n\nWraps";
$Body .= "\nChipolte Shrimp BLT: ";
$Body .= $box_chipolte_shrimp_blt;
$Body .= "\nTurkey Bacon Ranch: ";
$Body .= $box_turkey_bacon_ranch;
$Body .= "\nBuffalo Chicken: ";
$Body .= $box_buffalo_chicken;
$Body .= "\nVeggie: ";
$Body .= $box_veggie;
$Body .= "\n\nSalad";
$Body .= "\nCaesar Salad: ";
$Body .= $box_caesar_salad;
$Body .= "\nHouse Salad: ";
$Body .= $box_house_salad;
$Body .= "\nCobb Salad: ";
$Body .= $box_cobb_salad;
$Body .= "\nSea Breeze Salad: ";
$Body .= $box_sea_breeze_salad;

$Body .= "\n\nFULL SERVICE CATERING\n";
$Body .= "\nTheme Package: ";
$Body .= $theme_package;
$Body .= "\nInformation: ";
$Body .= $theme_package_information;
$Body .= "\nReception: ";
$Body .= $reception;
$Body .= "\nInformation: ";
$Body .= $reception_information;
$Body .= "\nSpecialty Stations: ";
$Body .= $specialty_stations;
$Body .= "\nBar/Beverage Service: ";
$Body .= $bar_beverage_service;
$Body .= "\nInformation: ";
$Body .= $bar_beverage_service_information;
$Body .= "\nBreakfast: ";
$Body .= $breakfast;
$Body .= "\nInformation: ";
$Body .= $breakfast_information;
$Body .= "\nNotes: ";
$Body .= $notes;

$Body .= "\n\nPAYMENT TYPE\n";
$Body .= "$payment1, $payment2, $payment3, $payment4, $payment5, $payment6";

$success = mail($EmailTo, $Subject, $Body, "From: <$EmailFrom>")
&& mail($EmailFrom, $confirmation_subject, $confirmation_body, "From: <$EmailTo>");

Null Fields And If/else On Join Won't Exclude

Similar Tutorials

A select query I've written joins three tables. The query works fine, pulling up a users table, a table for specials advertising that are entered by members, a and a third table the identivies members who have joined a customer application. A page displays listing all the entries who have joined the customer application, their names, address, etc display but if they have not set up their special advertising, then the fields for that table display NULL. I have tried an If and an ifelse to not display text (you can see in the code the HTML Hours of Operation: and Specials:). Thee field I am using to differentiate is "m_primeID", it is an intiger field. The if statement I've written is follows.

	if( $row["$m_primeID"] == 'NULL' )
	{
		$company .= "";
	}
	elseif( $row["$m_primeID"] <> 'NULL'  )
		{
	$company .= "<b>Hours of Operation:</b><br>" . ($row["m_coupon_title"]) . "<br /><br />\n";
	$company .= "<b>Special:</b><br>" .($row["m_coupon_desc"]) . "<br /><br />\n";
		}

Here is a screen shot of part of the joined tables. This screen shot show the Null on the joined tables that don't have customer advertising set up. Any Ideas Attached Files Screen-Shot-of-Join.jpg 108.65KB 0 downloads

Truncate A Mysql Table But Exclude First Column

Similar Tutorials

Hey guys, I'm a little confused to how I can do this. I am basically wanting to give my first column a 'NOT NULL AUTO_INCREMENT' and give each row it's own 'id'. The issue I am having is that the script I am using truncates the whole SQL table with a CSV file that is cron'd daily to update data. I am currently using this script:

<?php


$databasehost = "localhost";
$databasename = "";
$databasetable = "";
$databaseusername="";
$databasepassword = "";
$fieldseparator = ",";
$lineseparator = "\n";
$enclosedbyquote = '"';
$csvfile = "db-core/feed/csv/csv.csv";

if(!file_exists($csvfile)) {
die("File not found. Make sure you specified the correct path.");
}

try {
$pdo = new PDO("mysql:host=$databasehost;dbname=$databasename",
$databaseusername, $databasepassword,
array(
PDO::MYSQL_ATTR_LOCAL_INFILE => true,
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
)
);
} catch (PDOException $e) {
die("database connection failed: ".$e->getMessage());
}

$pdo->exec("TRUNCATE TABLE `$databasetable`");

$affectedRows = $pdo->exec("
LOAD DATA LOCAL INFILE ".$pdo->quote($csvfile)." REPLACE INTO TABLE `$databasetable`
FIELDS OPTIONALLY ENCLOSED BY ".$pdo->quote($enclosedbyquote)."
TERMINATED BY ".$pdo->quote($fieldseparator)." 
LINES TERMINATED BY ".$pdo->quote($lineseparator)." 
IGNORE 1 LINES");

echo "Loaded a total of $affectedRows records from this csv file.\n";

?>

Is it possible to amend this script to ignore my first column and truncate all of the data in the table apart from the first column? I could then give all of the rows in the first column their own ID's any idea how I could do this? I am still very nooby so please go easy on me

Moved: How Do You Exclude Data In A Mysql Query?

Similar Tutorials

This topic has been moved to MySQL Help.

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

Moved: A Query To Exclude Certn Fields That Match

Similar Tutorials

This topic has been moved to MySQL Help.

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

Last Db Items?

Similar Tutorials

How can I select the last 5 db items? I was thinking a timestamp or some thing.

Save Items To Buy

Similar Tutorials

What is the best way to capture items that someone wants to purchase when they don't have an account yet?

And I prefer not using cookies.

Display Ads After Every 4 Items

Similar Tutorials

Guys,
i want to display ads after 4 items to be displayed.

Iam fetching item using mysql database & iam showing 8 items per page.

I used below code but its not working because i used the item id to specify the first number but the items is not listed as correct order

Code: [Select]
<?php
// first number
$first = $row['id'];
// second number
$second = 4;

//checking if the first number is muliple of second. If true then display ads.
If($first % $second == "0") {
echo 'ads to display';
}

It will work if i list items in correct order. Please let me know correct solution.
Thanks in advance !

Remove Selected Items

Similar Tutorials

Hi guys!
I'm trying to make a <select> button for car positions which displays a set of numbers like 1-5 or 1-10 so on..
I need to remove the numbers that is already been selected.
Selected numbers are stored in the database and i fetch them in a simple query then compared it to the max number of cars.

I have this code, it kinda works but it shows the number 1 which is already been selected.
Selected numbers are 1 and 3, it successfully removes number 3 but not 1,
The output is 1,2,4,5,6,7,8,9,10
I added some comments for clarity..

Code: [Select]
function position_available($event_id, $number_of_cars) // receives id for ref. in the database
{
$selected_positions = check_selected_positions($event_id); // query to get selected positions
while($positions = mysql_fetch_array($selected_positions))
{
$position = array();
array_push($position, $positions['car_position']); // 'car position' is the name of the field

}

for($i = 1; $i <= $number_of_cars; $i++) // $number_of_cars is the total number of cars
{
if(! in_array($i, $position))
echo "<option value='{$i}'>" . $i . "</option>";

}

}

Did i miss something simple?
thanks for the help in advance!

Two Similar Items In An Array

Similar Tutorials

How can I check if an array contains two items that are the same?

For example ("apples", "bananas", "oranges") returns false
But ("apples", "bananas", "bananas") returns true

Grab All Items That Start With X

Similar Tutorials

Right now I have a link list a-z and 0-9.
you click one of those links and your taken to page listing all items that start with that character.
currently I'm using:
Code: [Select]
SELECT * FROM my_table where LEFT(`my_item`,1)='$show' ORDER BY my_title ASCall I do right now is just add a link like ?show=a and everything that starts with a is listed.

Now here is my problem. I want to listen all items that start with a numeric value listed all on one page instead of being spread across 0-9.

If another solution becomes available I'd be more then happy to hear you out. But does anyone know how I can change my query to only list items that start with numbers?

Display Table Items

Similar Tutorials

How to display items like bottom table? And here is the code

<?

print"
<table style=\"width:100%\" class=\"tableList\">
	<tr>
		<th style=\"width:35%\">Prize Name</th> 
		<th style=\"width:12%\">Amount</th>
		<th style=\"width:12%\">Points</th>
		<th style=\"width:12%\">Available</th>
		<th style=\"width:12%\">Redeemed</th>
		<th style=\"width:17%\">Action</th>
	</tr>";

	$giftCardQuery = 'SELECT currency, amount, pointsPrice, instant_gift_cards.id, instant_gift_cards.giftCardName, instant_gift_cards.giftCardImage FROM instant_gift_card_codes INNER JOIN instant_gift_cards ON (instant_gift_card_codes.giftCardId = instant_gift_cards.id) WHERE instant_gift_cards.status = :cardStatus ORDER BY instant_gift_cards.dateCreated DESC';
	$giftCard = $db->prepare($giftCardQuery);
	$giftCard->bindValue(':cardStatus', 'Enabled', PDO::PARAM_STR);
	$giftCard->execute();
	
	if($giftCard->rowCount() > '0'){
	
		while($giftCardRow = $giftCard->fetch(PDO::FETCH_ASSOC)){
			
			$giftCardsAvailableQuery = 'SELECT count(*) FROM instant_gift_card_codes WHERE currency = :currency AND amount = :amount AND pointsPrice = :pointsPrice AND giftCardId = :id AND status = :status';
			$giftCardsAvailable = $db->prepare($giftCardsAvailableQuery);
			$giftCardsAvailable->bindParam(':currency', $giftCardRow['currency'], PDO::PARAM_STR);
			$giftCardsAvailable->bindParam(':amount', $giftCardRow['amount'], PDO::PARAM_STR);
			$giftCardsAvailable->bindParam(':pointsPrice', $giftCardRow['pointsPrice'], PDO::PARAM_STR);
			$giftCardsAvailable->bindParam(':id', $giftCardRow['id'], PDO::PARAM_INT);
			$giftCardsAvailable->bindValue(':status', 'Available', PDO::PARAM_STR);
			$giftCardsAvailable->execute();
			$gCardsAvailable = $giftCardsAvailable->fetch(PDO::FETCH_COLUMN);
			
			$giftCardsRedeemedQuery = 'SELECT count(*) FROM instant_gift_card_codes WHERE currency = :currency AND amount = :amount AND pointsPrice = :pointsPrice AND giftCardId = :id AND status = :status';
			$giftCardsRedeemed = $db->prepare($giftCardsRedeemedQuery);
			$giftCardsRedeemed->bindParam(':currency', $giftCardRow['currency'], PDO::PARAM_STR);
			$giftCardsRedeemed->bindParam(':amount', $giftCardRow['amount'], PDO::PARAM_STR);
			$giftCardsRedeemed->bindParam(':pointsPrice', $giftCardRow['pointsPrice'], PDO::PARAM_STR);
			$giftCardsRedeemed->bindParam(':id', $giftCardRow['id'], PDO::PARAM_INT);
			$giftCardsRedeemed->bindValue(':status', 'Redeemed', PDO::PARAM_STR);
			$giftCardsRedeemed->execute();
			$gCardsRedeemed = $giftCardsRedeemed->fetch(PDO::FETCH_COLUMN);
			
			if($giftCardRow['giftCardImage']){
				$nameOrImage = '<img src="./images/giftcardrewards/'.$giftCardRow['giftCardImage'].'" alt="'.$giftCardRow['giftCardName'].'" title="'.$giftCardRow['giftCardName'].'">';
			}else{
				$nameOrImage = $giftCardRow['giftCardName'];
			}
			
			if($gCardsAvailable == '0'){
				$redeemAction = 'Out of Stock';
			}
			elseif($userInfo['currentPoints'] < $giftCardRow['pointsPrice']){
				$needed = $giftCardRow['pointsPrice'] - $userInfo['currentPoints'];
				$redeemAction = 'You need '.$needed.' point(s)';
			}
			elseif($userInfo['currentPoints'] >= $giftCardRow['pointsPrice']){
				$redeemAction = '<input type="button" value="Redeem" onclick="if(confirm(\'Are you sure to redeem this prize?\')){location.href=\'index.php?do=instantGiftCards&action=redeem&cardId='.$giftCardRow['id'].'&amount='.$giftCardRow['amount'].'\';}">';
			}
			
			print"
	<tr>
		<td>".$nameOrImage."</td>
		<td style=\"text-align:center\">".$giftCardRow['currency'].$giftCardRow['amount']."</td>
		<td style=\"text-align:center\">".$giftCardRow['pointsPrice']."</td>
		<td style=\"text-align:center\">".$gCardsAvailable."</td>
		<td style=\"text-align:center\">".$gCardsRedeemed."</td>
		<td style=\"text-align:center\">".$redeemAction."</td>
	</tr>";
		
		}
		
	}else{
		
		print"
	<tr>
		<td colspan=\"4\" style=\"text-align:center;color:#2B1B17;padding:15px 0\">No prizes added.</td>
	</tr>";
		
	}
	
print"
</table>";
	
?>

You Viewed Items, Strategy?

Similar Tutorials

am currently building the cart system of a product, now there is this part wherein, the non-logged-in OR logged-in user should also be able to see the items that he/she viewed, how to do that?., am not asking for code snippets , just give me some ideas/hints/strategies/tips that may help me get the big picture on how to do this thing and proceed coding.