Jump to content

marcs910

Members
  • Posts

    24
  • Joined

  • Last visited

    Never

Everything posted by marcs910

  1. Geez. Sorry about all this. I do apologize. You can remove this topic to keep me from being bashed any more thanks.
  2. other files involved header.php <?php /* $Id: header.php,v 1.42 2003/06/10 18:20:38 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ // check if the 'install' directory exists, and warn of its existence if (WARN_INSTALL_EXISTENCE == 'true') { if (file_exists(dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/install')) { $messageStack->add('header', WARNING_INSTALL_DIRECTORY_EXISTS, 'warning'); } } // check if the configure.php file is writeable if (WARN_CONFIG_WRITEABLE == 'true') { if ( (file_exists(dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/includes/configure.php')) && (is_writeable(dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/includes/configure.php')) ) { $messageStack->add('header', WARNING_CONFIG_FILE_WRITEABLE, 'warning'); } } // check if the session folder is writeable if (WARN_SESSION_DIRECTORY_NOT_WRITEABLE == 'true') { if (STORE_SESSIONS == '') { if (!is_dir(tep_session_save_path())) { $messageStack->add('header', WARNING_SESSION_DIRECTORY_NON_EXISTENT, 'warning'); } elseif (!is_writeable(tep_session_save_path())) { $messageStack->add('header', WARNING_SESSION_DIRECTORY_NOT_WRITEABLE, 'warning'); } } } // check session.auto_start is disabled if ( (function_exists('ini_get')) && (WARN_SESSION_AUTO_START == 'true') ) { if (ini_get('session.auto_start') == '1') { $messageStack->add('header', WARNING_SESSION_AUTO_START, 'warning'); } } if ( (WARN_DOWNLOAD_DIRECTORY_NOT_READABLE == 'true') && (DOWNLOAD_ENABLED == 'true') ) { if (!is_dir(DIR_FS_DOWNLOAD)) { $messageStack->add('header', WARNING_DOWNLOAD_DIRECTORY_NON_EXISTENT, 'warning'); } } if ($messageStack->size('header') > 0) { echo $messageStack->output('header'); } ?> <table width="100%" style="height:100%; background:#252525;" cellspacing="0" cellpadding="0" border="0"> <tr> <td width="6" height="100%" valign="top"><?=tep_image(DIR_WS_IMAGES.'bg1.gif','','','','style="margin-top:72px"')?></td> <td width="100%" height="100%" valign="top"> <table width="100%" style="height:100%" cellspacing="0" cellpadding="0" border="0"> <tr> <td width="100%" height="800" valign="top"> <table width="100%" style="height:100%" cellspacing="0" cellpadding="0" border="0"> <tr> <td width="100%" height="11" valign="top"></td> </tr> <tr> <td width="100%" height="55" valign="top"> <table width="100%" style="height:100%" cellspacing="0" cellpadding="0" border="0"> <tr> <td width="25%" height="100%" valign="top"> <table class="black m1_l" width="100%" style="height:100%" cellspacing="0" cellpadding="0" border="0"> <tr> <td class="m1_r h_text" width="100%" height="100%" valign="top" style="padding-left:15px;"> <?php echo tep_draw_separator('spacer.gif', '1', '8'); ?><br> <?=BOX_HEADING_CURRENCIES?>:<br> <?php echo tep_draw_separator('spacer.gif', '1', '5'); ?><br> <? echo tep_draw_form('currencies', tep_href_link(basename($PHP_SELF), '', $request_type, false), 'get'); reset($currencies->currencies); $currencies_array = array(); while (list($key, $value) = each($currencies->currencies)) { $currencies_array[] = array('id' => $key, 'text' => $value['title']); } $hidden_get_variables = ''; reset($HTTP_GET_VARS); while (list($key, $value) = each($HTTP_GET_VARS)) { if ( ($key != 'currency') && ($key != tep_session_name()) && ($key != 'x') && ($key != 'y') ) { $hidden_get_variables .= tep_draw_hidden_field($key, $value); } } echo tep_draw_pull_down_menu('currency', $currencies_array, $currency, 'onChange="this.form.submit();" class="select"') . $hidden_get_variables . tep_hide_session_id(); echo '</form>'; ?> <br> </td> </tr> </table> </td> <td width="7" height="100%" valign="top"><?php echo tep_draw_separator('spacer.gif', '7', '1'); ?></td> <td width="25%" height="100%" valign="top"> <table class="black m1_l" width="100%" style="height:100%" cellspacing="0" cellpadding="0" border="0"> <tr> <td class="m1_r h_text" width="100%" height="100%" valign="top" style="padding-left:15px;"> <?php echo tep_draw_separator('spacer.gif', '1', '8'); ?><br> <?=BOX_HEADING_LANGUAGES?>:<br> <?php echo tep_draw_separator('spacer.gif', '1', '5'); ?><br> <? if (!isset($lng) || (isset($lng) && !is_object($lng))) { include(DIR_WS_CLASSES . 'language.php'); $lng = new language; } $languages_string = ''; reset($lng->catalog_languages); $rr=0; while (list($key, $value) = each($lng->catalog_languages)) { if ($rr!=0) $languages_string .=tep_draw_separator('spacer.gif', '10', '1'); $languages_string .= '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('language', 'currency')) . 'language=' . $key, $request_type) . '">' . tep_image(DIR_WS_LANGUAGES . $value['directory'] . '/images/' . $value['image'], $value['name']) . '</a>'; $rr++; } echo $languages_string; ?> <br> </td> </tr> </table> </td> <td width="6" height="100%" valign="top"><?php echo tep_draw_separator('spacer.gif', '6', '1'); ?></td> <td width="25%" height="100%" valign="top"> <table class="black m1_l" width="100%" style="height:100%" cellspacing="0" cellpadding="0" border="0"> <tr> <td class="m1_r h_text" width="100%" height="100%" valign="top" style="padding-left:15px;"> <br style="line-height:10px;"> <a href="<?php echo tep_href_link('wishlist.php')?>"><?php echo BOX_HEADING_CUSTOMER_WISHLIST; ?></a> </td> </tr> </table> </td> <td width="6" height="100%" valign="top"><?php echo tep_draw_separator('spacer.gif', '6', '1'); ?></td> <td width="25%" height="100%" valign="top"> <table class="black m1_l" width="100%" style="height:100%" cellspacing="0" cellpadding="0" border="0"> <tr> <td class="m1_r cart_text" width="100%" height="100%" valign="top" style="padding-left:43px;"> <br style="line-height:10px;"> <font><?=BOX_HEADING_SHOPPING_CART?>:</font><br> <br style="line-height:8px;"> now in your cart <a href="<?=tep_href_link('shopping_cart.php')?>"><strong><?=$cart->count_contents()?> <?=BOX_SHOPPING_CART_EMPTY?></strong></a><br> </td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <td width="100%" height="6" valign="top"></td> </tr> <tr> <td width="100%" height="210" valign="top"> <table width="100%" style="height:100%" cellspacing="0" cellpadding="0" border="0"> <tr> <td width="189" height="100%" valign="top"> <?=tep_image(DIR_WS_IMAGES.'logo.jpg')?><br> </td> <td width="100%" height="100%" valign="top"> <table width="100%" style="height:100%" cellspacing="0" cellpadding="0" border="0"> <tr> <td width="100%" height="53" valign="top" style="text-align:center"> <a href="<?=tep_href_link('index.php')?>"><?=tep_image_button('l1.jpg')?></a><a href="<?=tep_href_link('products_new.php')?>"><?=tep_image_button('l2.jpg')?></a><a href="<?=tep_href_link('specials.php')?>"><?=tep_image_button('l3.jpg')?></a><a href="<?=tep_href_link('account.php')?>"><?=tep_image_button('l4.jpg')?></a><a href="<?=tep_href_link('contact_us.php')?>"><?=tep_image_button('l5.jpg')?></a><br> </td> </tr> <tr> <td width="100%" height="157" valign="top" style=" background:url(images/t-dr.gif) repeat-x;"> <table width="100%" style="height:100%; background:url(images/t-l.jpg) no-repeat left;" cellspacing="0" cellpadding="0" border="0"> <tr> <td width="100%" height="100%" valign="top" style="background:url(images/t-r.jpg) no-repeat right;"> <div align="right" style="margin: 16px 66px 0px 0px;"> <?=tep_image(DIR_WS_IMAGES.'slogan.jpg')?><br> <br style="line-height:8px;"> <a href="<?=tep_href_link('specials.php')?>"><?=tep_image(DIR_WS_IMAGES.'click.gif')?></a> </div> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <td width="100%" height="5" valign="top"></td> </tr> column_left.php <?php /* $Id: column_left.php,v 1.15 2003/07/01 14:34:54 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <table class="black" width="185" style="height:273px; background-image:url(images/m2-t.gif); background-repeat: no-repeat; background-position: top;" cellspacing="0" cellpadding="0" border="0"> <tr> <td width="100%" height="100%" valign="top" style="background:url(images/m2-b.gif) no-repeat bottom;"> <div class="h_l_text" style="margin: 14px 0px 0px 10px;"><strong><?=BOX_HEADING_CATEGORIES?></strong></div> <?=tep_image(DIR_WS_IMAGES.'h-l.gif','','','','style="margin-left:10px; margin-top:9px"')?><br> <ul style="margin-left:16px; margin-top:10px;"> <? function tep_show_category($counter) { global $tree, $categories_string, $cPath_array, $ii; $ii++; if(!$tree[$counter]['level']){ $categories_string .= $categories_string ? '' : ''; $categories_string .= '<li><a href='; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $categories_string .= tep_href_link('index.php', $cPath_new) . '>'; // display categry name $categories_string .= $tree[$counter]['name']; $categories_string .= '</a></li>'; }else{ // SUBCATEGORY $categories_string .= ''; for($i=0;$i<$tree[$counter]['le vel'];$i++) $categories_string .= ''; $categories_string .= '<li><a href='; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $categories_string .= tep_href_link('index.php', $cPath_new) . '>-'; // display category name $categories_string .= $tree[$counter]['name']; $categories_string .= '</a></li>'; } if ($tree[$counter]['next_id'] != false && $ii < 20) { tep_show_category($tree[$counter]['next_id']); } } define(TABLE_CATEGORIES, "categories"); define(TABLE_CATEGORIES_DESCRIPTION, "categories_description"); $categories_string = ''; $tree = array(); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { $tree[$categories['categories_id']] = array('name' => $categories['categories_name'], 'parent' => $categories['parent_id'], 'level' => 0, 'path' => $categories['categories_id'], 'next_id' => false); if (isset($parent_id)) { $tree[$parent_id]['next_id'] = $categories['categories_id']; } $parent_id = $categories['categories_id']; if (!isset($first_element)) { $first_element = $categories['categories_id']; } } //------------------------ if ($cPath) { $new_path = ''; reset($cPath_array); while (list($key, $value) = each($cPath_array)) { unset($parent_id); unset($first_id); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$value . "' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); if (tep_db_num_rows($categories_query)) { $new_path .= $value; while ($row = tep_db_fetch_array($categories_query)) { $tree[$row['categories_id']] = array('name' => $row['categories_name'], 'parent' => $row['parent_id'], 'level' => $key+1, 'path' => $new_path . '_' . $row['categories_id'], 'next_id' => false); if (isset($parent_id)) { $tree[$parent_id]['next_id'] = $row['categories_id']; } $parent_id = $row['categories_id']; if (!isset($first_id)) { $first_id = $row['categories_id']; } $last_id = $row['categories_id']; } $tree[$last_id]['next_id'] = $tree[$value]['next_id']; $tree[$value]['next_id'] = $first_id; $new_path .= '_'; } else { break; } } } $categories_string .= ''; tep_show_category($first_element); $categories_string .= ''; echo $categories_string; ?> </ul> </td> </tr> </table> <br style="line-height:5px;"> <a href="<?=tep_href_link('specials.php')?>"><?=tep_image(DIR_WS_IMAGES.'b1.jpg')?></a><br> footer.php <?php /* $Id: column_left.php,v 1.15 2003/07/01 14:34:54 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <table class="black" width="185" style="height:273px; background-image:url(images/m2-t.gif); background-repeat: no-repeat; background-position: top;" cellspacing="0" cellpadding="0" border="0"> <tr> <td width="100%" height="100%" valign="top" style="background:url(images/m2-b.gif) no-repeat bottom;"> <div class="h_l_text" style="margin: 14px 0px 0px 10px;"><strong><?=BOX_HEADING_CATEGORIES?></strong></div> <?=tep_image(DIR_WS_IMAGES.'h-l.gif','','','','style="margin-left:10px; margin-top:9px"')?><br> <ul style="margin-left:16px; margin-top:10px;"> <? function tep_show_category($counter) { global $tree, $categories_string, $cPath_array, $ii; $ii++; if(!$tree[$counter]['level']){ $categories_string .= $categories_string ? '' : ''; $categories_string .= '<li><a href='; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $categories_string .= tep_href_link('index.php', $cPath_new) . '>'; // display categry name $categories_string .= $tree[$counter]['name']; $categories_string .= '</a></li>'; }else{ // SUBCATEGORY $categories_string .= ''; for($i=0;$i<$tree[$counter]['le vel'];$i++) $categories_string .= ''; $categories_string .= '<li><a href='; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $categories_string .= tep_href_link('index.php', $cPath_new) . '>-'; // display category name $categories_string .= $tree[$counter]['name']; $categories_string .= '</a></li>'; } if ($tree[$counter]['next_id'] != false && $ii < 20) { tep_show_category($tree[$counter]['next_id']); } } define(TABLE_CATEGORIES, "categories"); define(TABLE_CATEGORIES_DESCRIPTION, "categories_description"); $categories_string = ''; $tree = array(); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { $tree[$categories['categories_id']] = array('name' => $categories['categories_name'], 'parent' => $categories['parent_id'], 'level' => 0, 'path' => $categories['categories_id'], 'next_id' => false); if (isset($parent_id)) { $tree[$parent_id]['next_id'] = $categories['categories_id']; } $parent_id = $categories['categories_id']; if (!isset($first_element)) { $first_element = $categories['categories_id']; } } //------------------------ if ($cPath) { $new_path = ''; reset($cPath_array); while (list($key, $value) = each($cPath_array)) { unset($parent_id); unset($first_id); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$value . "' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); if (tep_db_num_rows($categories_query)) { $new_path .= $value; while ($row = tep_db_fetch_array($categories_query)) { $tree[$row['categories_id']] = array('name' => $row['categories_name'], 'parent' => $row['parent_id'], 'level' => $key+1, 'path' => $new_path . '_' . $row['categories_id'], 'next_id' => false); if (isset($parent_id)) { $tree[$parent_id]['next_id'] = $row['categories_id']; } $parent_id = $row['categories_id']; if (!isset($first_id)) { $first_id = $row['categories_id']; } $last_id = $row['categories_id']; } $tree[$last_id]['next_id'] = $tree[$value]['next_id']; $tree[$value]['next_id'] = $first_id; $new_path .= '_'; } else { break; } } } $categories_string .= ''; tep_show_category($first_element); $categories_string .= ''; echo $categories_string; ?> </ul> </td> </tr> </table> <br style="line-height:5px;"> <a href="<?=tep_href_link('specials.php')?>"><?=tep_image(DIR_WS_IMAGES.'b1.jpg')?></a><br>
  3. Hey guys. Im having problems with a table on my site. Using index.php, featured.php or any other file my tables line up correctly. When I use wishlist.php it seems to add an extra column on the left which shifts the whole page over to the far right. I'll paste all files involved and more if needed. If you need to see my site to understand what I am talking about please let me know. Thanks. wishlist.php <?php /* $Id: wishlist.php,v 3.0 2005/04/20 Dennis Blake osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_WISHLIST); /******************************************************************* ******* ADD PRODUCT TO WISHLIST IF PRODUCT ID IS REGISTERED ******** *******************************************************************/ if(tep_session_is_registered('wishlist_id')) { $wishList->add_wishlist($wishlist_id, $attributes_id); if(WISHLIST_REDIRECT == 'Yes') { tep_redirect(tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $wishlist_id)); } else { tep_session_unregister('wishlist_id'); } } /******************************************************************* ****************** ADD PRODUCT TO SHOPPING CART ******************** *******************************************************************/ if (isset($HTTP_POST_VARS['add_wishprod'])) { if(isset($HTTP_POST_VARS['add_prod_x'])) { foreach ($HTTP_POST_VARS['add_wishprod'] as $value) { $product_id = tep_get_prid($value); $cart->add_cart($product_id, $cart->get_quantity(tep_get_uprid($product_id, $HTTP_POST_VARS['id'][$value]))+1, $HTTP_POST_VARS['id'][$value]); } } } /******************************************************************* ****************** DELETE PRODUCT FROM WISHLIST ******************** *******************************************************************/ if (isset($HTTP_POST_VARS['add_wishprod'])) { if(isset($HTTP_POST_VARS['delete_prod_x'])) { foreach ($HTTP_POST_VARS['add_wishprod'] as $value) { $wishList->remove($value); } } } /******************************************************************* ************* EMAIL THE WISHLIST TO MULTIPLE FRIENDS *************** *******************************************************************/ if (isset($HTTP_POST_VARS['email_prod_x'])) { $errors = false; $guest_errors = ""; $email_errors = ""; $message_error = ""; if(strlen($HTTP_POST_VARS['message']) < '1') { $error = true; $message_error .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_MESSAGE . "</div>"; } if(tep_session_is_registered('customer_id')) { $customer_query = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'"); $customer = tep_db_fetch_array($customer_query); $from_name = $customer['customers_firstname'] . ' ' . $customer['customers_lastname']; $from_email = $customer['customers_email_address']; $subject = $customer['customers_firstname'] . ' ' . WISHLIST_EMAIL_SUBJECT; $link = HTTP_SERVER . DIR_WS_CATALOG . FILENAME_WISHLIST_PUBLIC . "?public_id=" . $customer_id; //REPLACE VARIABLES FROM DEFINE $arr1 = array('$from_name', '$link'); $arr2 = array($from_name, $link); $replace = str_replace($arr1, $arr2, WISHLIST_EMAIL_LINK); $message = tep_db_prepare_input($HTTP_POST_VARS['message']); $body = $message . $replace; } else { if(strlen($_POST['your_name']) < '1') { $error = true; $guest_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_YOUR_NAME . "</div>"; } if(strlen($_POST['your_email']) < '1') { $error = true; $guest_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " .ERROR_YOUR_EMAIL . "</div>"; } elseif(!tep_validate_email($_POST['your_email'])) { $error = true; $guest_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_VALID_EMAIL . "</div>"; } $from_name = stripslashes($_POST['your_name']); $from_email = $_POST['your_email']; $subject = $from_name . ' ' . WISHLIST_EMAIL_SUBJECT; $message = stripslashes($HTTP_POST_VARS['message']); $z = 0; $prods = ""; foreach($HTTP_POST_VARS['prod_name'] as $name) { $prods .= stripslashes($name) . " " . stripslashes($HTTP_POST_VARS['prod_att'][$z]) . "\n" . $HTTP_POST_VARS['prod_link'][$z] . "\n\n"; $z++; } $body = $message . "\n\n" . $prods . "\n\n" . WISHLIST_EMAIL_GUEST; } //Check each posted name => email for errors. $j = 0; foreach($HTTP_POST_VARS['friend'] as $friendx) { if($j == 0) { if($friend[0] == '' && $email[0] == '') { $error = true; $email_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_ONE_EMAIL . "</div>"; } } if(isset($friendx) && $friendx != '') { if(strlen($email[$j]) < '1') { $error = true; $email_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_ENTER_EMAIL . "</div>"; } elseif(!tep_validate_email($email[$j])) { $error = true; $email_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_VALID_EMAIL . "</div>"; } } if(isset($email[$j]) && $email[$j] != '') { if(strlen($friendx) < '1') { $error = true; $email_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_ENTER_NAME . "</div>"; } } $j++; } if($error == false) { $j = 0; foreach($HTTP_POST_VARS['friend'] as $friendx) { if($friendx != '') { tep_mail($friendx, $email[$j], $subject, $friendx . ",\n\n" . $body, $from_name, $from_email); } //Clear Values $friend[$j] = ""; $email[$j] = ""; $message = ""; $j++; } $messageStack->add('wishlist', WISHLIST_SENT, 'success'); } } $breadcrumb->add(NAVBAR_TITLE_WISHLIST, tep_href_link(FILENAME_WISHLIST, '', 'SSL')); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"> <table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <tr> <td width="185" height="100%" valign="top"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </td> <!-- body_text //--> <td width="100%" valign="top"><?php echo tep_draw_form('wishlist_form', tep_href_link(FILENAME_WISHLIST)); ?> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_wishlist.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php if ($messageStack->size('wishlist') > 0) { ?> <tr> <td><?php echo $messageStack->output('wishlist'); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if (is_array($wishList->wishID) && !empty($wishList->wishID)) { reset($wishList->wishID); ?> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="3" class="productListing"> <tr> <td class="productListing-heading"><?php echo BOX_TEXT_IMAGE; ?></td> <td class="productListing-heading"><?php echo BOX_TEXT_PRODUCT; ?></td> <td class="productListing-heading"><?php echo BOX_TEXT_PRICE; ?></td> <td class="productListing-heading" align="center"><?php echo BOX_TEXT_SELECT; ?></td> </tr> <?php $i = 0; while (list($wishlist_id, ) = each($wishList->wishID)) { $product_id = tep_get_prid($wishlist_id); $products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = '" . $product_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name"); $products = tep_db_fetch_array($products_query); if (($i/2) == floor($i/2)) { $class = "productListing-even"; } else { $class = "productListing-odd"; } ?> <tr class="<?php echo $class; ?>"> <td valign="top" class="productListing-data" align="left"><a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $wishlist_id, 'NONSSL'); ?>"><?php echo tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); ?></a></td> <td valign="top" class="productListing-data" align="left" class="main"><b><a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $wishlist_id, 'NONSSL'); ?>"><?php echo $products['products_name']; ?></a></b> <input type="hidden" name="prod_link[]" value="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $wishlist_id, 'NONSSL'); ?>" /> <input type="hidden" name="prod_name[]" value="<?php echo $products['products_name']; ?>" /> <?php /******************************************************************* ******** THIS IS THE WISHLIST CODE FOR PRODUCT ATTRIBUTES ********* *******************************************************************/ $attributes_addon_price = 0; // Now get and populate product attributes $att_name = ""; if (isset($wishList->wishID[$wishlist_id]['attributes'])) { while (list($option, $value) = each($wishList->wishID[$wishlist_id]['attributes'])) { echo tep_draw_hidden_field('id[' . $wishlist_id . '][' . $option . ']', $value); $attributes = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . $wishlist_id . "' and pa.options_id = '" . $option . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $value . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'"); $attributes_values = tep_db_fetch_array($attributes); if ($attributes_values['price_prefix'] == '+') { $attributes_addon_price += $attributes_values['options_values_price']; } else if($attributes_values['price_prefix'] == '-') { $attributes_addon_price -= $attributes_values['options_values_price']; } $att_name .= " (" . $attributes_values['products_options_name'] . ": " . $attributes_values['products_options_values_name'] . ") "; echo '<br /><small><i> ' . $attributes_values['products_options_name'] . ': ' . $attributes_values['products_options_values_name'] . '</i></small>'; } // end while attributes for product } echo '<input type="hidden" name="prod_att[]" value="' . $att_name . '" />'; if (tep_not_null($products['specials_new_products_price'])) { $products_price = '<s>' . $currencies->display_price($products['products_price']+$attributes_addon_price, tep_get_tax_rate($products['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($products['specials_new_products_price']+$attributes_addon_price, tep_get_tax_rate($products['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($products['products_price']+$attributes_addon_price, tep_get_tax_rate($products['products_tax_class_id'])); } /******************************************************************* ******* CHECK TO SEE IF PRODUCT HAS BEEN ADDED TO THEIR CART ******* *******************************************************************/ if($cart->in_cart($wishlist_id)) { echo '<br /><font color="#FF0000"><b>' . TEXT_ITEM_IN_CART . '</b></font>'; } /******************************************************************* ********** CHECK TO SEE IF PRODUCT IS NO LONGER AVAILABLE ********** *******************************************************************/ if($products['products_status'] == 0) { echo '<br /><font color="#FF0000"><b>' . TEXT_ITEM_NOT_AVAILABLE . '</b></font>'; } $i++; ?> </td> <td valign="top" class="productListing-data"><?php echo $products_price; ?></td> <td valign="top" class="productListing-data" align="center"> <?php /******************************************************************* * PREVENT THE ITEM FROM BEING ADDED TO CART IF NO LONGER AVAILABLE * *******************************************************************/ if($products['products_status'] != 0) { echo tep_draw_checkbox_field('add_wishprod[]',$wishlist_id); } ?> </td> </tr> <?php } ?> </table> </td> </tr> <tr> <td align="right"><br /><?php echo tep_image_submit('button_delete.gif', 'Delete From Wishlist', 'name="delete_prod" value="delete_prod"') . " " . tep_image_submit('button_in_cart.gif', 'Add to Cart', 'name="add_prod" value="add_prod"'); ?></td> </tr> </table> <?php /******************************************************************* *********** CODE TO SPECIFY HOW MANY EMAILS TO DISPLAY ************* *******************************************************************/ if(!tep_session_is_registered('customer_id')) { ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><?php echo WISHLIST_EMAIL_TEXT_GUEST; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td align="center"> <table border="0" width="400px" cellspacing="0" cellpadding="2"> <tr> <td class="main" colspan="2"><table cellpadding="2" cellspacing="0"> <tr> <td colspan="2"><?php echo $guest_errors; ?></td> </tr> <tr> <td class="main"><?php echo TEXT_YOUR_NAME; ?></td> <td class="main"><?php echo tep_draw_input_field('your_name', $your_name); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_YOUR_EMAIL; ?></td> <td class="main"><?php echo tep_draw_input_field('your_email', $your_email); ?></td> </tr> </table></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_black.gif', '100%', '1'); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } else { ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><?php echo WISHLIST_EMAIL_TEXT; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td align="center"> <table border="0" width="400px" cellspacing="0" cellpadding="2"> <?php } ?> <tr> <td colspan="2"><?php echo $email_errors; ?></td> </tr> <?php $email_counter = 0; while($email_counter < DISPLAY_WISHLIST_EMAILS) { ?> <tr> <td class="main"><?php echo TEXT_NAME; ?> <?php echo tep_draw_input_field('friend[]', $friend[$email_counter]); ?></td> <td class="main"><?php echo TEXT_EMAIL; ?> <?php echo tep_draw_input_field('email[]', $email[$email_counter]); ?></td> </tr> <?php $email_counter++; } ?> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td colspan="2"><?php echo $message_error; ?></td> </tr> <tr> <td colspan="2" class="main"><?php echo TEXT_MESSAGE . tep_draw_textarea_field('message', 'soft', 45, 5); ?></td> </tr> <tr> <td colspan="2" align="right"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE, 'name="email_prod" value="email_prod"'); ?></td> </tr> </table> </td> </tr> </table> </form> <?php } else { // Nothing in the customers wishlist ?> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="main"><?php echo BOX_TEXT_NO_ITEMS;?></td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </form> <?php } ?> <!-- customer_wishlist_eof //--> </td> <!-- body_text_eof //--> </tr> </table> </table> </td> </tr> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> a good page is: login.php <?php /* $Id: login.php,v 1.80 2003/06/05 23:28:24 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); //---PayPal WPP Modification START ---// //Assign a variable to cut down on database calls //Don't show checkout option if cart is empty. It does not satisfy the paypal if (tep_paypal_wpp_enabled() && $cart->count_contents() > 0) { $ec_enabled = true; } else { $ec_enabled = false; } if ($ec_enabled) { //If they're here, they're either about to go to paypal or were sent back by an error, so clear these session vars if (tep_session_is_registered('paypal_ec_temp')) tep_session_unregister('paypal_ec_temp'); if (tep_session_is_registered('paypal_ec_token')) tep_session_unregister('paypal_ec_token'); if (tep_session_is_registered('paypal_ec_payer_id')) tep_session_unregister('paypal_ec_payer_id'); if (tep_session_is_registered('paypal_ec_payer_info')) tep_session_unregister('paypal_ec_payer_info'); //Find out if the user is logging in to checkout so that we know to draw the EC box $checkout_login = false; if (sizeof($navigation->snapshot) > 0 || isset($HTTP_GET_VARS['payment_error'])) { if (strpos($navigation->snapshot['page'], 'checkout_') !== false || isset($HTTP_GET_VARS['payment_error'])) { $checkout_login = true; } } } //---PayPal WPP Modification END---// // redirect the customer to a friendly cookie-must-be-enabled page if cookies are disabled (or the session has not started) if ($session_started == false) { tep_redirect(tep_href_link(FILENAME_COOKIE_USAGE)); } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_LOGIN); $error = false; if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'process')) { $email_address = tep_db_prepare_input($HTTP_POST_VARS['email_address']); $password = tep_db_prepare_input($HTTP_POST_VARS['password']); // Check if email exists $check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'"); if (!tep_db_num_rows($check_customer_query)) { $error = true; } else { $check_customer = tep_db_fetch_array($check_customer_query); // Check that password is good if (!tep_validate_password($password, $check_customer['customers_password'])) { $error = true; } else { if (SESSION_RECREATE == 'True') { tep_session_recreate(); } $check_country_query = tep_db_query("select entry_country_id, entry_zone_id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$check_customer['customers_id'] . "' and address_book_id = '" . (int)$check_customer['customers_default_address_id'] . "'"); $check_country = tep_db_fetch_array($check_country_query); $customer_id = $check_customer['customers_id']; $customer_default_address_id = $check_customer['customers_default_address_id']; $customer_first_name = $check_customer['customers_firstname']; $customer_country_id = $check_country['entry_country_id']; $customer_zone_id = $check_country['entry_zone_id']; tep_session_register('customer_id'); tep_session_register('customer_default_address_id'); tep_session_register('customer_first_name'); tep_session_register('customer_country_id'); tep_session_register('customer_zone_id'); tep_db_query("update " . TABLE_CUSTOMERS_INFO . " set customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1 where customers_info_id = '" . (int)$customer_id . "'"); // restore cart contents $cart->restore_contents(); // restore wishlist to sesssion $wishList->restore_wishlist(); if (sizeof($navigation->snapshot) > 0) { $origin_href = tep_href_link($navigation->snapshot['page'], tep_array_to_string($navigation->snapshot['get'], array(tep_session_name())), $navigation->snapshot['mode']); $navigation->clear_snapshot(); tep_redirect($origin_href); } else { tep_redirect(tep_href_link(FILENAME_DEFAULT)); } } } } if ($error == true) { $messageStack->add('login', TEXT_LOGIN_ERROR); } $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_LOGIN, '', 'SSL')); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <script language="javascript"><!-- function session_win() { window.open("<?php echo tep_href_link(FILENAME_INFO_SHOPPING_CART); ?>","info_shopping_cart","height=460,width=500,toolbar=no,statusbar=no,scrollbars=yes").focus(); } //--></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <tr> <td width="100%" height="438" valign="top"> <table width="100%" style="height:100%" cellspacing="0" cellpadding="0" border="0"> <tr> <td width="185" height="100%" valign="top"><?php require(DIR_WS_INCLUDES . 'column_left.php'); ?></td> <td width="4" height="100%" valign="top"><?php echo tep_draw_separator('spacer.gif', '4', '1'); ?></td> <td width="100%" height="100%" valign="top"> <table width="100%" style="height:100%; background: #E8F7FD url(images/m3-l-t.gif) no-repeat left top;" cellspacing="0" cellpadding="0" border="0"> <tr> <td width="100%" height="100%" style="background:url(images/m3-r-t.gif) no-repeat right top;" valign="top"> <table width="100%" style="height:100%; background:url(images/m3-l-b.gif) no-repeat left bottom;" cellspacing="0" cellpadding="0" border="0"> <tr> <td width="100%" height="100%" style="background:url(images/m3-r-b.gif) no-repeat right bottom; padding: 15px 3px 3px 3px;" valign="top"> <div class="h1_text" style="margin: 0px 0px 0px 11px;"><strong><?=HEADING_TITLE?></strong></div> <br style="line-height:13px;"> <table width="100%" style="height:393px; background:#FFFFFF;" cellspacing="0" cellpadding="0" border="0"> <tr> <td width="4" height="100%" style="background:url(images/m4-l-b.gif) no-repeat bottom;" valign="top"><?=tep_image(DIR_WS_IMAGES.'m4-l-t.gif')?></td> <td width="100%" height="100%" style="padding: 14px 0px 14px 4px;" valign="top"> <table cellpadding="0" cellspacing="0" border="0" width="100%"> <?php if ($messageStack->size('login') > 0) { ?> <tr> <td><?php echo $messageStack->output('login'); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if ($cart->count_contents() > 0) { ?> <tr> <td class="smallText_1"><?php echo TEXT_VISITORS_CART; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?> </table> <?php echo tep_draw_form('login', tep_href_link(FILENAME_LOGIN, 'action=process', 'SSL')); ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main" width="50%" valign="top"><b><?php echo HEADING_NEW_CUSTOMER; ?></b></td> <td class="main" width="50%" valign="top"><b><?php echo HEADING_RETURNING_CUSTOMER; ?></b></td> </tr> <tr> <td width="50%" height="100%" valign="top"> <table border="0" width="100%" height="100%" cellspacing="1" cellpadding="2" style="border:1px solid #B6B7CB;"> <tr> <td> <table border="0" width="100%" height="100%" cellspacing="0" cellpadding="2"> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main" valign="top"><?php echo TEXT_NEW_CUSTOMER . '<br><br>' . TEXT_NEW_CUSTOMER_INTRODUCTION; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_CREATE_ACCOUNT, '', 'SSL') . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> </table></td> <td width="50%" height="100%" valign="top"><table border="0" width="100%" height="100%" cellspacing="1" cellpadding="2" style="border:1px solid #B6B7CB;"> <tr> <td><table border="0" width="100%" height="100%" cellspacing="0" cellpadding="2"> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main" colspan="2"><?php echo TEXT_RETURNING_CUSTOMER; ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td> <td class="main"><?php echo tep_draw_input_field('email_address'); ?></td> </tr> <tr> <td class="main"><b><?php echo ENTRY_PASSWORD; ?></b></td> <td class="main"><?php echo tep_draw_password_field('password'); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="smallText_1" colspan="2"><?php echo '<a href="' . tep_href_link(FILENAME_PASSWORD_FORGOTTEN, '', 'SSL') . '">' . TEXT_PASSWORD_FORGOTTEN . '</a>'; ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td align="right"><?php echo tep_image_submit('button_sign_in1.gif', IMAGE_BUTTON_LOGIN); ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> </table></td> </tr> </table> </form> <!-- body_eof //--> </td> <td width="4" height="100%" style="background:url(images/m4-r-b.gif) no-repeat bottom;" valign="top"><?=tep_image(DIR_WS_IMAGES.'m4-r-t.gif')?></td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  4. Thanks but I know basic conditional logic. Before I posted I had tried it with OR then AND with no luck on what I was looking for. I'll keep searching for the right answer here in the forums. I appreciate the words.
  5. But will this work if more than one condition is true?
  6. I have 5 fields in a form. I want to be able to search those fields in a db wheter I have a value in 1 field or if I have a value in 5 fields. The way i have it now I know it selects a row if all values are filled in. What I do want it to do is select if I have "stories = 2 and bedroom = 3" or whatever. I hope you halfway understand.
  7. Ok, i figured out it was the connection to a previous db. I did test it and pulls exactly what I wanted. But what I did do was add another field to search on. When I search on the stories it works. When I search on the bedrooms it pulls everything. What I do want it to do is have it search like all other search forms. if it has 2 stories, view it. If it has 3 bedrooms, view it. If it has 2 stories and 2 bedrooms, view it.
  8. Im trying to begin with a simple search form and build up to an advanced search form. When I run this code I get the same record back everytime no matter what I put in.
  9. Worked perfect. You guys rule.
  10. I'm looking to concat the first_name and last_name in the Name column in my table. Every way I've tried I have came up short. Any ideas?
  11. I got this one working just like I needed it by adding a $header with a value. Thanks guys
  12. Heh. It was in my spam mail folder in gmail. Thanks. Now how can I keep it from being seen as spam? This is the way it came in H-Sphere Httpd Daemon <httpd@mail.worldispnetwork.com> to me
  13. Yes. Thanks clown. The email is never being sent. I'm using my email in the form but I never recieve anything.
  14. No. There arent any errors. All required information from the form is placed in the table like it should and it redirects to the thanks.php.
  15. I'm working on this user registration. Everything works besides the emailing. Any clues?
  16. I figured it out. I hadnt changed my submit. It was still pointing to my old page.
  17. Mk. Can some please tell me why "$a = md5(uniqid(rand(),true))" is not inserting my code into my table?
  18. Still a newb as I have dropped off the hp wagon for a couple of months. Here's my question. Im looking to do one of the more advanced searches where you have a form you can narrow the search by username, user type, date entered, etc. Everywhere I've looked all I can find is the basic searches. Can someone point me in the right direction or show me some code please. Thanks
  19. Made that change and still does the same. THanks so much for the help so far.
  20. I've reviewed, added, deleted, reviewed and screamed until I'm on the verge of plucking ear hair. I've apparantly missed something or somethings in my code. When loading, it immediately goes to: "[b]Please upload a JPEG or GIF image smaller than 512KB. Data entered This entry is viewable by the public now[/b]" Without any of the image code it inserted all of the data fine. Could someone please tell me what it is I'm missing? I havent started the code to insert the temp name into the db yet or view the image. Im just trying to get to the upload file part. Thanks [code]<?php include ('admin_header.html');   require_once ('mysql_connect.php'); if (isset($_POST['submitted'])) { // Check for an uploaded file.     if (isset($_FILES['image'])) {                  // Validate the type. Should be jpeg, jpg, or gif.         $allowed = array ('image/gif', 'image/jpeg', 'image/jpg', 'image/pjpeg');         if (in_array($_FILES['upload']['type'], $allowed)) {                      // Move the file over.             if (move_uploaded_file($_FILES['image']['tmp_name'], "../uploads/{$_FILES['upload']['name']}"))                          echo '<p>The file has been uploaded!</p>';                          } else { // Couldn't move the file over.                              echo '<p><font color="red">The file could not be uploaded because: </b>';                          // Print a message based upon the error.                 switch ($_FILES['upload']['error']) {                     case 1:                         print 'The file exceeds the upload_max_filesize setting in php.ini.';                         break;                     case 2:                         print 'The file exceeds the MAX_FILE_SIZE setting in the HTML form.';                         break;                     case 3:                         print 'The file was only partially uploaded.';                         break;                     case 4:                         print 'No file was uploaded.';                         break;                     case 6:                         print 'No temporary folder was available.';                         break;                     default:                         print 'A system error occurred.';                         break;                 } // End of switch.                                  print '</b></font></p>';             } // End of move... IF.                      } else { // Invalid type.             echo '<p><font color="red">Please upload a JPEG or GIF image.</font></p>';             unlink ($_FILES['upload']['tmp_name']); // Delete the file.         }     } else { // No file uploaded.         echo '<p><font color="red">Please upload a JPEG or GIF image smaller than 512KB.</font></p>';      } //End of conditional                {       $query = "INSERT INTO homes (category, type, address, location, zip, year, bedroom, bathroom, garage, lotsize, stories, active, price, description, date_entered)    VALUES ('$category', '$type', '$address', '$location', '$zip', '$year', '$bedroom', '$bathroom', '$garage', '$lotsize', '$stories', '$active', '$price', '$description', NOW())";    $result = @mysql_query ($query);       if ($result) {       echo '<h1 id="mainhead">Data entered</h1>    <p>This entry is viewable by the public now.</p><p><b /></p>';       exit();       } else {         echo '<h1 id="mainhead">System Error</h1>         <p class="error">Your data could not be entered due to a system error.</p>';         echo '<p>' . mysql_error() . '<br /><br />Query: ' . $query . '</p>';                  exit();                }              mysql_close();            }          ?>          <h2>Enter your data</h2>     <form action="admin_new_home.php" method="post">          <p>Category:<input type="text" name="category" size "15" maxlength="15" value="<?php if     (isset($_POST['category'])) echo$_POST['category']; ?>" /></p>             <p>Type:<input type="text" name="type" size "15" maxlength="15" value="<?php if     (isset($_POST['type'])) echo$_POST['type']; ?>" /></p>     <p>Address:<input type="text" name="address" size "15" maxlength="30" value="<?php if     (isset($_POST['address'])) echo$_POST['address']; ?>" /></p>          <p>Location:<input type="text" name="location" size "15" maxlength="15" value="<?php if     (isset($_POST['location'])) echo$_POST['location']; ?>" /></p>          <p>Zip Code:<input type="text" name="zip" size "15" maxlength="15" value="<?php if     (isset($_POST['zip'])) echo$_POST['zip']; ?>" /></p>     <p>Year:<input type="text" name="year" size "15" maxlength="15" value="<?php if     (isset($_POST['year'])) echo$_POST['year']; ?>" /></p>          <p>Bedrooms:<input type="text" name="bedroom" size "15" maxlength="15" value="<?php if     (isset($_POST['bedroom'])) echo$_POST['bedroom']; ?>" /></p>          <p>Bathrooms:<input type="text" name="bathroom" size "15" maxlength="15" value="<?php if     (isset($_POST['bathroom'])) echo$_POST['bathroom']; ?>" /></p>     <p>Garage:<input type="text" name="garage" size "15" maxlength="15" value="<?php if     (isset($_POST['garage'])) echo$_POST['garage']; ?>" /></p>          <p>Lot Size:<input type="text" name="lotsize" size "15" maxlength="15" value="<?php if     (isset($_POST['lotsize'])) echo$_POST['lotsize']; ?>" /></p>          <p>Stories:<input type="text" name="stories" size "15" maxlength="15" value="<?php if     (isset($_POST['stories'])) echo$_POST['stories']; ?>" /></p>    <p>Active:<input type="text" name="active" size "15" maxlength="15" value="<?php if    (isset($_POST['active'])) echo$_POST['active']; ?>" /></p>       <p>Price:<input type="text" name="price" size "15" maxlength="15" value="<?php if      (isset($_POST['price'])) echo$_POST['price']; ?>" /></p>          <p>Description:<input type="text" name="description" size "25" maxlength="100" value="<?php if     (isset($_POST['description'])) echo$_POST['description']; ?>" /></p>         <input type="hidden" name="MAX_FILE_SIZE" value="524288">         <fieldset><legend>Select a JPEG or GIF image to be uploaded:</legend>         <p><b>File:</b> <input type="file" name="image" /></fieldset></p>          <p><input type="submit" name="submit" value="Submit" /></p>     <input type="hidden" name="submitted" value="TRUE" />     </form>          <?php          include ('footer.html');          ?>[/code]
  21. [!--quoteo(post=385779:date=Jun 19 2006, 03:45 PM:name=craygo)--][div class=\'quotetop\']QUOTE(craygo @ Jun 19 2006, 03:45 PM) [snapback]385779[/snapback][/div][div class=\'quotemain\'][!--quotec--] Your form looks fine. The problem I see is with the variable on the insert. You need to set $catagory, $type, and $active. I believe you rcode would only work of global variable are turned on, which they are not by default and should not be. [code]if(isset($_POST['category'])){ $category = $_POST['category'']; }else{ $category = ''; }[/code] Each one would have to be set Ray [/quote] Even if the rest of the fields are working fine?
  22. Ive searched and found a couple of ways this can be done but they arent matching up with what Ive used. Im currently reading "PHP and MySQL For Dynamic Web Sites" by Larry Ullman and this is where I am learning my code. What I'm trying to do is create a dropdown menu item to insert into a db. The codes I've tried from here isnt working with what I have. It creates the dropdown but never inserts the value. I'm including two textboxes that are working correctly, above and below in the form code. What will fix this or what am I doing wrong? Thanks [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /] The SQL code im using: [code]if (isset($_POST['submitted'])) {   require_once ('mysql_connect.php');       $query = "INSERT INTO homes (category, type, address, location, zip, year, bedroom, bathroom, garage, lotsize, stories, active, price, description, date_entered)    VALUES ('$category', '$type', '$address', '$location', '$zip', '$year', '$bedroom', '$bathroom', '$garage', '$lotsize', '$stories', '$active', '$price', '$description', NOW())";    $result = @mysql_query ($query);    [/code] The form code I'm using: [code]<p>Category:<input type="text" name="category" size "15" maxlength="15" value="<?php if     (isset($_POST['category'])) echo$_POST['category']; ?>" /></p>          <p>Active:<select size="1" name="active">     <option selected value="<?php if     (isset($_POST['active'])) echo$_POST['active']; ?>">Y</option>     <option value="<?php if     (isset($_POST['active'])) echo$_POST['active']; ?>">N</option>     </select></p>     <p>Type:<input type="text" name="type" size "15" maxlength="15" value="<?php if     (isset($_POST['type'])) echo$_POST['type']; ?>" /></p> [/code]
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.