Neue Db Felder Werden Nicht Bef?llt

AudiV8 · #1 (**permalink**) 19.04.2004, 20:52

Hallo,

Habe 7 neue db Felder angelegt, und die entsprechenden ?nderungen dazu durchgef?hrt,

In Datei: categories.php

Code:

$sql_data_array = array('products_name' => xtc_db_prepare_input($_POST['products_name'][$language_id]),
              'products_car_manu' => xtc_db_prepare_input($_POST['products_car_manu'.$language_id]),
    	'products_car_model' => xtc_db_prepare_input($_POST['products_car_model'.$language_id]),
    	'products_car_typ' => xtc_db_prepare_input($_POST['products_car_typ'.$language_id]),
    	'products_fw_tlrate' => xtc_db_prepare_input($_POST['products_fw_tlrate'.$language_id]),
    	'products_fw_comment' => xtc_db_prepare_input($_POST['products_fw_comment'.$language_id]),
    	'products_fw_abe' => xtc_db_prepare_input($_POST['products_fw_abe'.$language_id]),
    	'products_fw_notes' => xtc_db_prepare_input($_POST['products_fw_notes'.$language_id]),
                  'products_description' => xtc_db_prepare_input($_POST['products_description_'.$language_id]),
                  'products_short_description' => xtc_db_prepare_input($_POST['products_short_description_'.$language_id]),
                  'products_url' => xtc_db_prepare_input($_POST['products_url'][$language_id]),
                  'products_meta_title' => xtc_db_prepare_input($_POST['products_meta_title'][$language_id]),
                  'products_meta_description' => xtc_db_prepare_input($_POST['products_meta_description'][$language_id]),
                  'products_meta_keywords' => xtc_db_prepare_input($_POST['products_meta_keywords'][$language_id]));

und:

Code:

$description_query = xtc_db_query("select
                        language_id,
                        products_name,
       products_car_manu,
       products_car_model,
       products_car_typ,
       products_fw_tlrate,
       products_fw_comment,
       products_fw_abe,
       products_fw_notes,
                        products_description,
                        products_short_description,
                        products_meta_title,
                        products_meta_description,
                        products_meta_keywords,
                        products_url
                        from " . TABLE_PRODUCTS_DESCRIPTION . "
                        where products_id = '" . xtc_db_input($products_id) . "'");
      $old_products_id=xtc_db_input($products_id);
      while ($description = xtc_db_fetch_array($description_query)) {
       xtc_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . "
              (products_id,
              language_id,
              products_name,
   	products_car_manu,
   	products_car_model,
   	products_car_typ,
   	products_fw_tlrate,
   	products_fw_comment,
   	products_fw_abe,
   	products_fw_notes,
              products_description,
              products_short_description,
              products_meta_title,
              products_meta_description,
              products_meta_keywords,
              products_url,
              products_viewed)
              values (
              '" . $dup_products_id . "',
              '" . $description['language_id'] . "',
              '" . addslashes($description['products_name']) . "',
   	'" . addslashes($description['products_car_manu']) . "',
   	'" . addslashes($description['products_car_model']) . "',
   	'" . addslashes($description['products_car_typ']) . "',
   	'" . addslashes($description['products_fw_tlrate']) . "',
   	'" . addslashes($description['products_fw_comment']) . "',
   	'" . addslashes($description['products_fw_abe']) . "',
   	'" . addslashes($description['products_fw_notes']) . "',
              '" . addslashes($description['products_description']) . "',
              '" . addslashes($description['products_short_description']) . "',
              '" . addslashes($description['products_meta_title']) . "',
              '" . addslashes($description['products_meta_description']) . "',
              '" . addslashes($description['products_meta_keywords']) . "',
              '" . $description['products_url'] . "',
              '0')");
      }

und in der Datei new_product.php

Code:

if ( ($_GET['pID']) && (!$_POST) ) {
   $product_query = xtc_db_query("select p.products_fsk18,
                      p.product_template,
                      p.options_template,
                      pd.products_name,
     	pd.products_car_manu,
     	pd.products_car_model,
     	pd.products_car_typ,
     	pd.products_fw_tlrate,
     	pd.products_fw_comment,
     	pd.products_fw_abe,
     	pd.products_fw_notes,
                      pd.products_description,
                      pd.products_short_description,
                      pd.products_meta_title,
                      pd.products_meta_description,
                      pd.products_meta_keywords,
                      pd.products_url,
                      p.products_id,
                      p.group_ids,
                      p.products_sort,
                      p.products_shippingtime,
                      p.products_quantity,
                      p.products_model,
                      p.products_image,
                      p.products_price,
                      p.products_discount_allowed,
                      p.products_weight,
                      p.products_date_added,
                      p.products_last_modified,
                      date_format(p.products_date_available, '%Y-%m-%d') as products_date_available,
                      p.products_status,
                      p.products_tax_class_id,
                      p.manufacturers_id from " . TABLE_PRODUCTS . " p,
                      " . TABLE_PRODUCTS_DESCRIPTION . " pd
                      where p.products_id = '" . (int)$_GET['pID'] . "'
                      and p.products_id = pd.products_id
                      and pd.language_id = '" . $_SESSION['languages_id'] . "'");

   $product = xtc_db_fetch_array($product_query);
   $pInfo = new objectInfo($product);

  } elseif ($_POST) {
   $pInfo = new objectInfo($_POST);
   $products_name = $_POST['products_name'];
  $products_car_manu = $_POST['products_car_manu'];
  $products_car_model = $_POST['products_car_model'];
  $products_car_typ = $_POST['products_car_typ'];
  $products_fw_tlrate = $_POST['products_fw_tlrate'];
  $products_fw_comment = $_POST['products_fw_comment'];
  $products_fw_abe = $_POST['products_fw_abe'];
  $products_fw_notes = $_POST['products_fw_notes'];
   $products_description = $_POST['products_description'];
   $products_short_description = $_POST['products_short_description'];
   $products_meta_title = $_POST['products_meta_title'];
   $products_meta_description = $_POST['products_meta_description'];
   $products_meta_keywords = $_POST['products_meta_keywords'];
   $products_url = $_POST['products_url'];
  } else {
   $pInfo = new objectInfo(array());

und:

Code:

<table width="100%" border="0">
 <tr>
 <td bgcolor="000000" height="10"></td>
 </tr>
 <tr>
  <td bgcolor="#FFCC33" valign="top" class="main"><?php echo xtc_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] .'/'. $languages[$i]['image'], $languages[$i]['name']); ?><?php echo TEXT_PRODUCTS_CAR_MANU; ?><?php echo xtc_draw_input_field('products_car_manu[' . $languages[$i]['id'] . ']', (($products_car_manu[$languages[$i]['id']]) ? stripslashes($products_car_manu[$languages[$i]['id']]) : xtc_get_products_car_manu($pInfo->products_id, $languages[$i]['id'])),'size=60'); ?></td>
 </tr>
 <tr>
  <td bgcolor="#FFCC33" valign="top" class="main"><?php echo xtc_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] .'/'. $languages[$i]['image'], $languages[$i]['name']); ?><?php echo TEXT_PRODUCTS_CAR_MODEL; ?><?php echo xtc_draw_input_field('products_car_model[' . $languages[$i]['id'] . ']', (($products_car_model[$languages[$i]['id']]) ? stripslashes($products_car_model[$languages[$i]['id']]) : xtc_get_products_car_model($pInfo->products_id, $languages[$i]['id'])),'size=60'); ?></td>
 </tr>
 <tr>

  <td bgcolor="#FFCC33" valign="top" class="main"><?php echo xtc_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] .'/'. $languages[$i]['image'], $languages[$i]['name']); ?><?php echo TEXT_PRODUCTS_CAR_TYP; ?><?php echo xtc_draw_input_field('products_car_typ[' . $languages[$i]['id'] . ']', (($products_car_typ[$languages[$i]['id']]) ? stripslashes($products_car_typ[$languages[$i]['id']]) : xtc_get_products_car_typ($pInfo->products_id, $languages[$i]['id'])),'size=60'); ?></td>
 </tr>
 <tr>
  <td bgcolor="#FFCC33" valign="top" class="main"><?php echo xtc_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] .'/'. $languages[$i]['image'], $languages[$i]['name']); ?><?php echo TEXT_PRODUCTS_FW_TLRATE; ?><?php echo xtc_draw_input_field('products_fw_tlrate[' . $languages[$i]['id'] . ']', (($products_fw_tlrate[$languages[$i]['id']]) ? stripslashes($products_fw_tlrate[$languages[$i]['id']]) : xtc_get_products_fw_tlrate($pInfo->products_id, $languages[$i]['id'])),'size=60'); ?></td>
 </tr>
 <tr>
  <td bgcolor="#FFCC33" valign="top" class="main"><?php echo xtc_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] .'/'. $languages[$i]['image'], $languages[$i]['name']); ?><?php echo TEXT_PRODUCTS_FW_COMMENT; ?><?php echo xtc_draw_input_field('products_fw_comment[' . $languages[$i]['id'] . ']', (($products_fw_comment[$languages[$i]['id']]) ? stripslashes($products_fw_comment[$languages[$i]['id']]) : xtc_get_products_fw_comment($pInfo->products_id, $languages[$i]['id'])),'size=60'); ?></td>
 </tr>
 <tr>
  <td bgcolor="#FFCC33" valign="top" class="main"><?php echo xtc_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] .'/'. $languages[$i]['image'], $languages[$i]['name']); ?><?php echo TEXT_PRODUCTS_FW_ABE; ?><?php echo xtc_draw_input_field('products_fw_abe[' . $languages[$i]['id'] . ']', (($products_fw_abe[$languages[$i]['id']]) ? stripslashes($products_fw_abe[$languages[$i]['id']]) : xtc_get_products_fw_abe($pInfo->products_id, $languages[$i]['id'])),'size=60'); ?></td>
 </tr>
 <tr>
  <td bgcolor="#FFCC33" valign="top" class="main"><?php echo xtc_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] .'/'. $languages[$i]['image'], $languages[$i]['name']); ?><?php echo TEXT_PRODUCTS_FW_NOTES; ?><?php echo xtc_draw_input_field('products_fw_notes[' . $languages[$i]['id'] . ']', (($products_fw_notes[$languages[$i]['id']]) ? stripslashes($products_fw_notes[$languages[$i]['id']]) : xtc_get_products_fw_notes($pInfo->products_id, $languages[$i]['id'])),'size=60'); ?></td>
 </tr>
 <tr>
  <td bgcolor="#FFCC33" valign="top" class="main"><?php echo xtc_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] .'/'. $languages[$i]['image'], $languages[$i]['name']); ?><?php echo TEXT_PRODUCTS_NAME; ?><?php echo xtc_draw_input_field('products_name[' . $languages[$i]['id'] . ']', (($products_name[$languages[$i]['id']]) ? stripslashes($products_name[$languages[$i]['id']]) : xtc_get_products_name($pInfo->products_id, $languages[$i]['id'])),'size=60'); ?></td>
 </tr>
 <tr>
  <td class="main"><?php echo TEXT_PRODUCTS_URL . '<small>' . TEXT_PRODUCTS_URL_WITHOUT_HTTP . '</small>'; ?><?php echo xtc_draw_input_field('products_url[' . $languages[$i]['id'] . ']', (($products_url[$languages[$i]['id']]) ? stripslashes($products_url[$languages[$i]['id']]) : xtc_get_products_url($pInfo->products_id, $languages[$i]['id'])),'size=60'); ?></td>
 </tr>
</table>

Das Problem ist das die neuen Werte nicht in die Datenbank geschickt werden.

Hat jemand ne Idee? Mu? die ?bergabe eventuell noch in einer 3. Datei eingetragen und/oder ge?ndert werden?

:grml: :grml:

W?rde mich ?ber eine Antwort freuen...

Thanks & Greetz aus DD

Elanor · #2 (**permalink**) 19.04.2004, 20:59

auf die schnelle w?rd ich sagen das du eine SQL Anweisung vergessen hast zu ?ndern

xt:mzanier · #3 (**permalink**) 19.04.2004, 21:00

vermutung aus der h?fte.

products_car_manu[' . $languages[$i]['id'] . ']

$_POST['products_car_manu'.$language_id]

->

$_POST['products_car_manu['.$language_id].']']

AudiV8 · #4 (**permalink**) 20.04.2004, 15:48

Hallo,

mzanier, deine Vermutung war richtig, ich hatte das mit dem Befehl f?r die description gemacht, das war dann wohl verkehrt...

In die Datenbank schreibt er die Daten jetzt rein, ich kann die zus?tztlichen Eintr?ge auch in der Kategorie ?bersicht aufrufen, aber,

Sobald ich auf Bearbeiten gehe, werden die neuen Entr?ge nicht in dem dazugeh?rigen Formularfeld abgerufen, sindern diese bleiben leer...

Hast dazu noch ne Idee?

xt:mzanier · #5 (**permalink**) 20.04.2004, 15:55

xtc_get_products_car_model($pInfo->products_id, $languages[$i]['id']))

sind denn deine funktionen auch richtig ?

AudiV8 · #6 (**permalink**) 20.04.2004, 16:56

Hallo,

Das w?re der Aufruf der Funktion:

Code:

 <tr>
  <td bgcolor="#FFCC33" valign="top" class="main"><?php echo xtc_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] .'/'. $languages[$i]['image'], $languages[$i]['name']); ?><?php echo TEXT_PRODUCTS_CAR_MANU; ?><?php echo xtc_draw_input_field('products_car_manu[' . $languages[$i]['id'] . ']', (($products_car_manu[$languages[$i]['id']]) ? stripslashes($products_car_manu[$languages[$i]['id']]) : xtc_get_products_car_manu($pInfo->products_id, $languages[$i]['id'])),'size=60'); ?></td>
 </tr>

und das die Funktion aus admin/includes/function/genral.php

Code:

 function xtc_get_products_car_manu($product_id, $language_id = 0) {

  if ($language_id == 0) $language_id = $_SESSION['languages_id'];
  $product_query = xtc_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
  $product = xtc_db_fetch_array($product_query);

  return $product['products_car_manu'];
 }

, kann keinen Fehler entdecken, oder bin ich mal wieder blind?

...

xt:mzanier · #7 (**permalink**) 20.04.2004, 16:59

hehe =)

soll ichs dir gleich sagen ? ^^ oder noch schmollen ? :}

xt:mzanier · #8 (**permalink**) 20.04.2004, 17:01

Code:

$product_query = xtc_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
  $product = xtc_db_fetch_array($product_query);

  return $product['products_car_manu'];

.. select products_name where ....

return $product['products_car_manu'];

du musst nat?rlich auch den wert in der query haben welchen du zur?ckgibst

AudiV8 · #9 (**permalink**) 20.04.2004, 17:03

Autsch !!!! :wall: :wall: :wall: :wall:

Also doch blind.... grummel

...

AudiV8 · #10 (**permalink**) 20.04.2004, 17:06

Es geht , es geht, es geht....

Jippi... !

int:

Themen-Optionen
Druckbare Version zeigen Jemanden per E-Mail auf dieses Thema hinweisen
Ansicht
Linear-Darstellung Zur Hybrid-Darstellung wechseln Zur Baum-Darstellung wechseln