Hier ist meine customers_redmind.php Datei.
<?php/* --------------------------------------------------------------
$Id: advertising.php 1133 2005-08-07 07:47:07Z gwinger $
XT-Commerce - community made shopping
http://www.(( Wir dulden keine kommerziellen Werbelinks - Bitte <a href="index.php?topic=3013.0">Forenregeln</a> beachten! ))
Copyright (c) 2003 XT-Commerce
--------------------------------------------------------------
Released under the GNU General Public License
--------------------------------------------------------------*/ require('includes/application_top.php');if(isset($_POST['del_user'])){$usid = $_POST['del_user']; xtc_db_query
("DELETE FROM customers_remind WHERE remind_id ='".$usid."';");} if ($_GET['sorting']) { switch ($_GET['sorting']) {// EOF - Tomcraft - 2009-10-22 - fixed sorting, replaced ASC with DESC case 'customers_lastname' : $sort = 'order by customers_lastname'; break; case 'customers_lastname-desc' : $sort = 'order by customers_lastname DESC'; break; case 'customers_email' : $sort = 'order by customers_email'; break; case 'customers_email-desc' : $sort = 'order by customers_email DESC'; break; case 'products_name' : $sort = 'order by products_name'; break; case 'products_name-desc' : $sort = 'order by products_name DESC'; break; case 'products_model' : $sort = 'order by products_model'; break; case 'products_model-desc' : $sort = 'order by products_model DESC'; break; case 'remind_date_added' : $sort = 'order by remind_date_added'; break; case 'remind_date_added-desc' : $sort = 'order by remind_date_added DESC'; break; } }?><!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 $_SESSION['language_charset']; ?>">
<title>
<?php echo TITLE
; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
</head>
<!-- header //-->
<?php require(DIR_WS_INCLUDES
. 'header.php'); ?><!-- header_eof //-->
<!-- body //-->
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<table border="0" width="100%" cellspacing="2" cellpadding="2">
<tr>
<td class="columnLeft2" width="
<?php echo BOX_WIDTH
; ?>" valign="top"><table border="0" width="
<?php echo BOX_WIDTH
; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES
. 'column_left.php'); ?><!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td class="boxCenter" width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<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 xtc_draw_separator
('pixel_trans.gif', HEADING_IMAGE_WIDTH
, HEADING_IMAGE_HEIGHT
); ?></td>
</tr>
</table></td>
</tr>
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent">
<?php echo TABLE_HEADING_CUSTOMER
.xtc_sorting
(FILENAME_CUSTOMERS_REMIND
,'customers_lastname'); ?></td>
<td class="dataTableHeadingContent">
<?php echo TABLE_HEADING_CUSTOMER_MAIL
.xtc_sorting
(FILENAME_CUSTOMERS_REMIND
,'customers_email'); ?></td>
<td class="dataTableHeadingContent">
<?php echo TABLE_HEADING_PRODUCT
.xtc_sorting
(FILENAME_CUSTOMERS_REMIND
,'products_name'); ?></td>
<td class="dataTableHeadingContent">
<?php echo TABLE_HEADING_PRODUCT_MODEL
.xtc_sorting
(FILENAME_CUSTOMERS_REMIND
,'products_model'); ?></td>
<td class="dataTableHeadingContent" align="left">
<?php echo TABLE_HEADING_DATE_ADDED
.xtc_sorting
(FILENAME_CUSTOMERS_REMIND
,'remind_date_added') ?></td>
<td class="dataTableHeadingContent" style = "width:20px">
<?php echo TABLE_HEADING_REMOVE_REMINDER
; ?></td>
</tr>
<?php $customers_remind_query = xtc_db_query
("select * from ".TABLE_CUSTOMERS_REMIND
." ".$sort); while ($customers_remind = xtc_db_fetch_array
($customers_remind_query)) {?> <? echo (xtc_draw_form
('del_users', FILENAME_CUSTOMERS_REMIND
)); ?> <input type="hidden" name="del_user" value="
<?php echo $customers_remind["remind_id"]?> " />
<td class="dataTableContent">
<?php if($customers_remind['customers_id'] == '0') { ?> <font color="#000000">
<?php echo $customers_remind['customers_firstname']." ".$customers_remind['customers_lastname']; ?> </font>
<?php } else { ?> <font color="#000000">
<?php echo $customers_remind['customers_firstname']." ".$customers_remind['customers_lastname']." [".$customers_remind['customers_id']."]"; ?> </font>
<?php } ?> </td>
<td class="dataTableContent">
<?php echo $customers_remind['customers_email_address']; ?> </td>
<td class="dataTableContent">
<?php echo $customers_remind['products_name']; ?></td>
<td class="dataTableContent">
<?php echo $customers_remind['products_model']; ?></td>
<td class="dataTableContent" align="left">
<?php echo date('d.m.Y H:i:s', strtotime($customers_remind['remind_date_added'])); ?></td>
<td class="dataTableContent" align="center"><input style = "border:none" type="image" src="https://www.XXXXXXX.de/templates/XXXXXXXXXX/buttons/german/cart_del.gif" alt="Eintrag löschen?"></td>
</tr>
</form>
<?php } ?> </table></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" style="font-family: Verdana, Arial, sans-serif; font-size: 10px;"><font color="#000000">registrierter Kunde [Kundennummer]</font></td>
</tr>
<tr>
<td align="right"> </td>
</tr>
<tr>
<td align="left" style="font-family: Verdana, Arial, sans-serif; font-size: 10px;">Kunden, die sich für eine Produkterinnerung eingetragen haben<br>bekommen eine automatische eMail-Benachrichtigung,<br>sobald der gewünschte Artikel wieder auf Lager ist.</td>
</tr>
</table>
</td>
<!-- body_text_eof //-->
</tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<?php require(DIR_WS_INCLUDES
. 'footer.php'); ?><!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES
. 'application_bottom.php'); ?> Wir haben auch gleich eine Sortiermöglichkeit mit eingebaut. Das hat bei uns den Vorteil, dass wir bei Nachbestellungen die Anzahl der Bestellmengen nicht immer mühsam zusammensuchen müssen.
der nächstes Wochenende leider in Wien ist.