public function insertItems(Items $items) { $con = self::openConnection(); $affected = 0; mysqli_begin_transaction($con); $stm = mysqli_stmt_init($con); $sql = "INSERT INTO category VALUES (?, ?, ?)"; mysqli_stmt_prepare($stm, $sql); foreach ($items->getItems() as $item) { $code = $item->getCode(); $name = $item->getName(); $parent = $item->getParent() == null ? null : $item->getParent()->getCode(); mysqli_stmt_bind_param($stm, 'sss', $code, $name, $parent); mysqli_stmt_execute($stm); if (mysqli_affected_rows($con) == 1) { $affected++; } } if ($affected > 0) { mysqli_commit($con); } else { mysqli_rollback($con); } return $affected; }
public function insertItems(Items $items) { $con = self::openConnection(); $affected = 0; mysqli_begin_transaction($con); $stm = mysqli_stmt_init($con); $sql = "INSERT INTO product VALUES (?, ?, ?, ?, ?, ?, ?, ?)"; mysqli_stmt_prepare($stm, $sql); foreach ($items->getItems() as $item) { $code = $item->getCode(); $articul = $item->getArticul(); $name = $item->getName(); $bmuID = $item->getBasicMeasurementUnit() == null ? null : $item->getBasicMeasurementUnit()->getId(); $price = $item->getPrice(); $curID = $item->getCurrency() == null ? null : $item->getCurrency()->getId(); $muID = $item->getMeasurementUnit() == null ? null : $item->getMeasurementUnit()->getId(); $parent = $item->getParent() == null ? null : $item->getParent()->getCode(); mysqli_stmt_bind_param($stm, 'sssdddds', $code, $articul, $name, $bmuID, $price, $curID, $muID, $parent); mysqli_stmt_execute($stm); if (mysqli_affected_rows($con) == 1) { $affected++; } } if ($affected > 0) { mysqli_commit($con); } else { mysqli_rollback($con); } return $affected; }
function paginated() { $items = Items::getItems(); $curPage = isset($this->params[0]) ? $this->params[0] : 0; $p = new Pagination($items, $curPage); $p->before(APP_URL . '/mymodule/paginated')->after('/anything/else/')->startAtOne(); $this->_view->pagination = $p; $this->_view->items = $items; $this->template('content', 'paginatedExemple.phtml'); $this->show('main.tpl'); }
set_time_limit(1800); //Time limit of half an hour! (Which is pretty high...) ini_set('memory_limit', '256M'); /* Activiteiten en excursies 2.11.* Eten en drinken 3.1.* en 3.2.* Uit in Amsterdam 2.1.3, 3.3.1, 3.3.2, 4.3.5 Musea en galleries 2.1.6 en 2.2.4 Tentoonstellingen 2.3.14 Attracties en bezienswaardigheden 2.1.* en 2.2.* Festivals 2.4 Theater 2.9.* Shoppen in Amsterdam 4.6.* Evenementen 2.3.* en 2.4.* */ $items = new Items(); $items->setDebug(false); $items->setOutput("Evenementen"); $items->setTypeStart("2.3."); $items->setAppend(false); $items->getItems(); $items->saveToCSV(); $items->saveToXML(false); $items = new Items(); $items->setDebug(false); $items->setOutput("Evenementen"); $items->setTypeStart("2.4."); $items->setAppend(true); $items->getItems(); $items->saveToCSV(); $items->saveToXML(true);
<?php $access_item["/"] = true; if (isset($read_access) && $read_access) { return; } include_once $_SERVER["FRAMEWORK_PATH"] . "/config/init.php"; $action = $page->actions(); $IC = new Items(); $qnas = $IC->getItems(array("itemtype" => "qna", "extend" => true)); $page->pageTitle("the Janitor @ " . SITE_URL); ?> <? $page->header(array("type" => "janitor")) ?> <div class="scene front"> <h1><?php echo SITE_NAME; ?> </h1> <h2>Janitor</h2> <p> Stopknappen er bygget på <a href="http://janitor.parentnode.dk" target="_blank">Janitor</a> - og Janitor er bygget til Stopknappen. </p> <?php echo $JML->listUserTodos(); ?>
<?php $IC = new Items(); $page_item = $IC->getItem(array("tags" => "page:front", "extend" => array("user" => true, "mediae" => true, "tags" => true))); if ($page_item) { $this->sharingMetaData($page_item); } $post_items = $IC->getItems(array("itemtype" => "post", "tags" => "on:frontpage", "status" => 1, "extend" => array("tags" => true, "readstate" => true, "user" => true, "mediae" => true))); ?> <div class="scene front i:front"> <div class="intro"> <!-- // ny dansk tekst jeg tror vi har sovet længe nok nu er det på tide at vågne og indse at midlet er blevet en tyran og målet er glemt i stakken af regninger vi har så travlt at stilstand er tryghed og tryghed er en luksus som koster os alt