* database username */ define("user", "root"); //define ("user", "root"); /** * database password */ define("pass", ""); //define ("pass", ""); /** * database name */ define("db", "mebli"); //define ("db", "mebli"); function get_product_list() { $db_connect = mysqli_connect(host, user, pass, db); $query = "SELECT goods_article, goods_name FROM goods WHERE factory_id=34"; if ($res = mysqli_query($db_connect, $query)) { while ($row = mysqli_fetch_assoc($res)) { $arr[] = $row; } $len = count($arr); for ($i = 0; $i < $len; $i++) { $str = $arr[$i]['goods_article'] . ", " . $arr[$i]['goods_name'] . PHP_EOL; file_put_contents('amf_list.txt', $str, FILE_APPEND); } } } get_product_list();
function products_list($select = 0, $ignore = 0) { echo get_product_list($select, $ignore); }
?> /images/product_2.jpg" alt="Product"/><span>Product One</span></a></li> <li><a href="#"><img src="<?php bloginfo('template_url'); ?> /images/product_2.jpg" alt="Product"/><span>Product One</span></a></li> <li><a href="#"><img src="<?php bloginfo('template_url'); ?> /images/product_2.jpg" alt="Product"/><span>Product One</span></a></li> </ul> --> <ul class="list-unstyled"> <?php echo get_product_list($cat_id); ?> </ul> </div> </div> </div> </div> <!--/top content--> <?php
function add_book() { global $set, $db, $apx; $thistype = 'book'; if ($_POST['send'] == 2) { //Begriff bereits vorhanden? $duplicate = false; if ($_POST['send'] == 2 && !$_POST['ignore']) { list($duplicate) = $db->first("SELECT id FROM " . PRE . "_products WHERE title LIKE '" . addslashes($_POST['title']) . "' LIMIT 1"); } if (!checkToken()) { infoInvalidToken(); } elseif (!$_POST['title'] || !$_POST['text']) { infoNotComplete(); } elseif ($duplicate) { info($apx->lang->get('MSG_DUPLICATE')); echo '<script type="text/javascript"> parent.document.forms[0].ignore.value = 1; </script>'; } elseif (!$this->update_pic()) { /*DO NOTHING*/ } elseif (!$this->update_teaserpic()) { /*DO NOTHING*/ } else { //Website-URLs clean if (substr($_POST['website'], 0, 4) == 'www.') { $_POST['website'] = 'http://' . $_POST['website']; } $_POST['type'] = $thistype; $_POST['addtime'] = time(); $_POST['picture'] = $this->picpath; $_POST['teaserpic'] = $this->teaserpicpath; $_POST['media'] = dash_serialize(array_map('intval', $_POST['media'])); //Freischalten if ($apx->user->has_right('products.enable') && $_POST['pubnow']) { $_POST['active'] = 1; } else { $_POST['active'] = 0; } $db->dinsert(PRE . '_products', 'prodid,type,title,text,meta_description,picture,teaserpic,website,manufacturer,publisher,isbn,genre,media,custom1,custom2,custom3,custom4,custom5,custom6,custom7,custom8,custom9,custom10,buylink,price,recprice,guarantee,recprice,guarantee,addtime,allowcoms,allowrating,restricted,top,searchable,active'); $nid = $db->insert_id(); logit('PRODUCTS_ADD', 'ID #' . $nid); //Inlinescreens mediamanager_setinline($nid); //Release eintragen for ($i = 1; $i <= 10; $i++) { if (!isset($_POST['release'][$i])) { continue; } $element = $_POST['release'][$i]; if ($element['year']) { list($reldata, $relstamp, $relsystem) = $this->generate_release($element); $db->query("INSERT INTO " . PRE . "_products_releases (prodid,system,data,stamp) VALUES ('" . $nid . "','" . $relsystem . "','" . addslashes(serialize($reldata)) . "','" . $relstamp . "')"); } } //Tags $tagids = produceTagIds($_POST['tags']); foreach ($tagids as $tagid) { $db->query("INSERT IGNORE INTO " . PRE . "_products_tags VALUES('" . $nid . "', '" . $tagid . "')"); } if ($_REQUEST['updateparent']) { printJSUpdateObject($_REQUEST['updateparent'], get_product_list($nid)); } else { printJSRedirect('action.php?action=products.show&what=' . $thistype); } } } else { $_POST['allowcoms'] = 1; $_POST['allowrating'] = 1; $_POST['searchable'] = 1; $_POST['pubnow'] = 1; $_POST['media'] = array(); //Benutzerdefinierte Felder for ($i = 1; $i <= 10; $i++) { $fieldname = $set['products']['custom_' . $thistype][$i - 1]; $apx->tmpl->assign('CUSFIELD' . $i . '_NAME', replace($fieldname)); $apx->tmpl->assign('CUSTOM' . $i, compatible_hsc($_POST['custom' . $i])); } $apx->tmpl->assign('ACTION', 'add'); $apx->tmpl->assign('PRODID', intval($_POST['prodid'])); $apx->tmpl->assign('TITLE', compatible_hsc($_POST['title'])); $apx->tmpl->assign('TEXT', compatible_hsc($_POST['text'])); $apx->tmpl->assign('META_DESCRIPTION', compatible_hsc($_POST['meta_description'])); $apx->tmpl->assign('PIC_COPY', compatible_hsc($_POST['pic_copy'])); $apx->tmpl->assign('TEASERPIC_COPY', compatible_hsc($_POST['teaserpic_copy'])); $apx->tmpl->assign('WEBSITE', compatible_hsc($_POST['website'])); $apx->tmpl->assign('TAGS', compatible_hsc($_POST['tags'])); $apx->tmpl->assign('MANUFACTURER', $this->get_units($_POST['manufacturer'], iif($set['products']['filtermanu'], 'person'))); $apx->tmpl->assign('PUBLISHER', $this->get_units($_POST['publisher'], iif($set['products']['filtermanu'], 'company'))); $apx->tmpl->assign('ISBN', compatible_hsc($_POST['isbn'])); $apx->tmpl->assign('GENRELIST', $this->get_genre($thistype, $_POST['genre'])); $apx->tmpl->assign('MEDIALIST', $this->get_media($thistype, $_POST['media'])); $apx->tmpl->assign('RELEASE', $this->get_release($thistype)); $apx->tmpl->assign('BUYLINK', compatible_hsc($_POST['buylink'])); $apx->tmpl->assign('PRICE', compatible_hsc($_POST['price'])); $apx->tmpl->assign('RECPRICE', compatible_hsc($_POST['recprice'])); $apx->tmpl->assign('GUARANTEE', compatible_hsc($_POST['guarantee'])); $apx->tmpl->assign('ALLOWCOMS', (int) $_POST['allowcoms']); $apx->tmpl->assign('ALLOWRATING', (int) $_POST['allowrating']); $apx->tmpl->assign('RESTRICTED', (int) $_POST['restricted']); $apx->tmpl->assign('TOP', (int) $_POST['top']); $apx->tmpl->assign('SEARCHABLE', (int) $_POST['searchable']); $apx->tmpl->assign('PUBNOW', (int) $_POST['pubnow']); $apx->tmpl->assign('UPDATEPARENT', (int) $_POST['updateparent']); $apx->tmpl->parse('add_edit_' . $thistype); } }
<a data-toggle="modal" href="#myModal" id="modal-product_list"></a> <!-- Modal --> <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog" style="width:800px;"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title"><?php lang('Account List'); ?> </h4> </div> <div class="modal-body"> <?php get_product_list(array('product_code' => 'code', 'product_sale_price' => 'quantity_price', 'product_tax_rate' => 'tax_rate', 'RUN' => 'calc();')); ?> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --> </div><!-- /.modal --> <?php if (isset($_POST['item']) and is_log()) { $continue = true; $this->form_validation->set_rules('code', get_lang('Barcode Code'), 'required'); $this->form_validation->set_rules('amount', get_lang('Amount'), 'required|digits'); $this->form_validation->set_rules('quantity_price', get_lang('Quantity Price'), 'number'); $this->form_validation->set_rules('tax_rate', get_lang('Tax Rate'), 'digits');