fRAiLtY-
-
Posts
53 -
Joined
-
Last visited
fRAiLtY-'s Achievements
Member (2/5)
0
Reputation
-
Excuse my ignorance, and thanks for the response, however it's just a simple 1 page script. It's an internal project for our business that is never going to develop into a web app and isn't accessible to the world wide web. It's just a form, with 2 steps: Step 1, enter job number Step 2, enter consignment number and update onclick. An MVC approach for this seems a bit overkill, but please feel free to correct me. I just need to rework what I've done into a functioning 2 step form. There's no users or anything of the sort, it utilises a barcode scanner.
-
Hi, I have written the below code and am trying to figure out the best way of making it into a 2 step form as currently it doesn't work as one. The 2 steps are as follows: 1) 1 text input with "find job" button, indicated by lines. 2) Once find job has been clicked it takes you to the results set where you have 2 options, to enter a number or tick a box. The resulting actions from clicking "Update" is still to be coded, but I've got a bit stuck where it comes to putting it into steps. Any help is appreciated. <?php /** * Despatcher * * @file index.php * @package Despatcher v1.0 (despatcher) * @category Core */ ini_set('error_reporting', E_ALL); ?> <!DOCTYPE html> <!--[if lt IE 7]> <html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]--> <!--[if IE 7]> <html class="no-js lt-ie9 lt-ie8"> <![endif]--> <!--[if IE 8]> <html class="no-js lt-ie9"> <![endif]--> <!--[if gt IE 8]><!--> <html class="no-js"> <!--<![endif]--> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <title>Despatcher®</title> <meta name="description" content=""> <meta name="viewport" content="width=device-width"> <link rel="stylesheet" href="css/normalize.min.css"> <link rel="stylesheet" href="css/main.css"> <script src="js/vendor/modernizr-2.6.2.min.js"></script> </head> <body> <div id="page"> <?php // Check for post if($_SERVER['REQUEST_METHOD'] === 'POST'){ // Set some variables for the server $host = "xxxxxxx"; $port = 'xxxx'; $dbname = "xxxx"; $db_username = "xxxx"; $db_password = "xxxxx"; $dsn = "sqlsrv:Server=$host,$port;Database=$dbname;"; // Connect $db = new PDO($dsn, $db_username, $db_password); // Step 2 if(!isset($_POST['update'])) { // Query try { $sql = 'SELECT * FROM MainJobDetails WHERE JobNo = ?'; $q = $db->prepare($sql); $q->execute(array($_POST['jobnumber'])); // Return results while($row = $q->fetch(PDO::FETCH_ASSOC)) { echo '<h2>Scan the barcode on the label or click "Local Delivery"</h2>'; echo '<form id="update" action="" method="post">'; echo '<table class="results"><tr><th>'; echo 'Customer'; echo '</th><th>'; echo 'Description'; echo '</th><th>'; echo 'Consignment #'; echo '</th><th>'; echo 'Local Delivery'; echo '</th></tr><tr><td>'; echo $row['InvoiceCustomerName']; echo '</td><td>'; echo $row['JobDesc']; echo '</td><td>'; echo '<input type="text" name="consignment" id="consignment"/>'; echo '</td><td>'; echo '<input type="checkbox" name="local" id="local"/>'; echo '</td></tr></table><br />'; echo '<button type="submit" id="updatebutton" class="blue button"/>Update details</button></form>'; return; } } catch(PDOException $e) { echo $e->getMessage(); } } elseif(isset($_POST['update'])) { "Thanks"; } } ?> <!--[if lt IE 7]> <p class="chromeframe">You are using an <strong>outdated</strong> browser. Please <a href="http://browsehappy.com/">upgrade your browser</a> or <a href="http://www.google.com/chromeframe/?redirect=true">activate Google Chrome Frame</a> to improve your experience.</p> <![endif]--> <p>Scan the job bag</p> <form id="jobnumber" method="post" action=""> <input type="text" name="jobnumber" id="jobnumber"/><br /> <div id="go-button"> <button type="submit" class="blue button"/>Find Job</button> </div> </form> </div> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script> <script>window.jQuery || document.write('<script src="js/vendor/jquery-1.9.1.min.js"><\/script>')</script> <script src="js/plugins.js"></script> <script src="js/main.js"></script> </body> </html>
-
Currently I just pdo_mysql and the standard MSSQL modules installed. I can connect using mssql_* functions but it doesn't handle prepared statements I think. I tried PDO_DBLIB but this hasn't been developed since 2005 and doesn't work with my versions of software due to it's age.
-
Hi all, Got some code which works, it's been extended then extended again over the past few months, and I'm just wondering if there's a tidier or more efficient way of putting altogether perhaps in less functions maybe or anything really. If anyone can provide some advise or feel free to move it around that would be a massive help. I like things to be neat and tidy and this certainly isn't. public function getMatrixData($requiredAttributeIds = null, $product = null, $stock) { Varien_Profiler::start('CONFIGURABLE:' . __METHOD__); $this->_usedProducts = '_cache_instance_products'; if ($this->getProduct($product)->hasData($this->_usedProducts)) { if (is_null($requiredAttributeIds) and is_null($this->getProduct($product)->getData($this->_configurableAttributes))) { $this->getConfigurableAttributes($product); Varien_Profiler::stop('CONFIGURABLE:' . __METHOD__); return $this->getProduct($product)->getData($this->_usedProducts); } $usedProducts = array(); $collection = $this->getUsedProductCollection($product)->addAttributeToSelect('*')->addFieldToFilter('name', array( 'like' => '%' . $stock . '%' ))->addAttributetoSort('size', 'DESC'); if (is_array($requiredAttributeIds)) { foreach ($requiredAttributeIds as $attributeId) { $attribute = $this->getAttributeById($attributeId, $product); if (!is_null($attribute)) $collection->addAttributeToFilter($attribute->getAttributeCode(), array( 'notnull' => 1 )); } } foreach ($collection as $item) { $usedProducts[] = $item; } $this->getProduct($product)->setData($this->_usedProducts, $usedProducts); } Varien_Profiler::stop('CONFIGURABLE:' . __METHOD__); return $this->getProduct($product)->getData($this->_usedProducts); } public function getAltMatrixData($requiredAttributeIds = null, $product = null, $stock) { Varien_Profiler::start('CONFIGURABLE:' . __METHOD__); $this->_usedProducts = '_cache_instance_products'; if ($this->getProduct($product)->hasData($this->_usedProducts)) { if (is_null($requiredAttributeIds) and is_null($this->getProduct($product)->getData($this->_configurableAttributes))) { $this->getConfigurableAttributes($product); Varien_Profiler::stop('CONFIGURABLE:' . __METHOD__); return $this->getProduct($product)->getData($this->_usedProducts); } $usedProducts = array(); $collection = $this->getUsedProductCollection($product)->addAttributeToSelect('*')->addFieldToFilter('name', array( 'like' => '%' . $stock . '%' )); if (is_array($requiredAttributeIds)) { foreach ($requiredAttributeIds as $attributeId) { $attribute = $this->getAttributeById($attributeId, $product); if (!is_null($attribute)) $collection->addAttributeToFilter($attribute->getAttributeCode(), array( 'notnull' => 1 )); } } foreach ($collection as $item) { $usedProducts[] = $item; } $this->getProduct($product)->setData($this->_usedProducts, $usedProducts); } Varien_Profiler::stop('CONFIGURABLE:' . __METHOD__); return $this->getProduct($product)->getData($this->_usedProducts); } public function getTable($product = false, $stock) { if (!$product) return false; $childProducts = $this->getMatrixData(null, $product, $stock); $x = array(); $r = ''; $sizes = array(); foreach ($childProducts as $children) { $size = $children->getAttributeText('size'); $x[$children->getAttributeText('quantity')][$size] = array( 'id' => $children->getId(), 'price' => number_format($children->getPrice(), '2'), 'name' => $children->getName() ); if (!in_array($size, $sizes)) { $sizes[] = $size; } } ksort($x); $r .= '<table id="' . strtolower(str_replace(' ', '-', $stock)) . '" class="matrix"><tr><th></th>'; foreach ($sizes as $size) { $r .= '<th>' . $size . '</th>'; } $r .= '</tr>'; foreach ($x as $quantity => $data) { $i = 1; $r .= '<tr><th id=' . $quantity . '>' . $quantity . '</th>'; foreach ($sizes as $size) { if (isset($data[$size])) { $item = $data[$size]; $r .= '<td id=' . $quantity . ' class="col' . $i++ . '"><a href="/checkout/cart/add?product=' . $item['id'] . '" title="Add ' . $item['name'] . ' to basket">£' . $item['price'] . '</a></td>'; } else { $r .= '<td id=' . $quantity . ' class="col' . $i++ . '">-</td>'; } } $r .= '</tr>'; } $r .= '</table>'; $r .= '<p class="note"><strong>Note:</strong> Prices in this table do not include additional options as specified above!</p>'; return $r; } public function getAltTable($product = false, $stock) { if (!$product) return false; $childProducts = $this->getMatrixData(null, $product, $stock); $x = array(); $r = ''; $sizes = array(); foreach ($childProducts as $children) { $size = $children->getAttributeText('size'); $x[$children->getAttributeText('quantity')][$size] = array( 'id' => $children->getId(), 'price' => number_format($children->getPrice(), '2'), 'name' => $children->getName() ); if (!in_array($size, $sizes)) { $sizes[] = $size; } } function bannerSizeSort($a,$B) { $pattern = '/(\d+(\.\d+)?)ft x (\d+(\.\d+)?)ft/'; if (preg_match($pattern, $a, $n1) && preg_match($pattern, $b, $n2)) { if ($n1[1] == $n2[1] && $n1[3] == $n2[3]) return 0; else if ($n1[1] > $n2[1] || ($n1[1] == $n2[1] && $n1[3] > $n2[3])) return 1; else return -1; } return 0; } usort($sizes, 'bannerSizeSort'); $r .= '<table id="banner" class="matrix"><tr><th></th>'; foreach ($x as $quantity => $data) { $r .= '<th id=' . $quantity . '>Each</th>'; } $r .= '</tr>'; foreach ($sizes as $size) { $i = 1; $r .= '<tr><th>' . $size . '</th>'; if (isset($data[$size])) { $item = $data[$size]; $r .= '<td id=' . str_replace(array(".", ","," "), "", $size) . ' class="col' . $i++ . '"><a href="/checkout/cart/add?product=' . $item['id'] . '" title="Add ' . $item['name'] . ' to basket">£' . $item['price'] . '</a></td>'; } else { $r .= '<td id=' . str_replace(array(".", ","," "), "", $size) . ' class="col' . $i++ . '">-</td>'; } $r .= '</tr>'; } $r .= '</tr>'; $r .= '</table>'; $r .= '<p class="note"><strong>Note:</strong> Prices in this table do not include additional options as specified above!</p>'; return $r; } public function getAlt2Table($product = false, $stock) { if (!$product) return false; $childProducts = $this->getAltMatrixData(null, $product, $stock); $x = array(); $r = ''; $sizes = array(); foreach ($childProducts as $children) { $size = $children->getAttributeText('size'); $x[$children->getAttributeText('quantity')][$size] = array( 'id' => $children->getId(), 'price' => number_format($children->getPrice(), '2'), 'name' => $children->getName() ); if (!in_array($size, $sizes)) { $sizes[] = $size; } } natsort($sizes); $r .= '<table id="label" class="matrix"><tr><th></th>'; ksort($x); foreach ($x as $quantity => $data) { $r .= '<th id=' . $quantity . '>' . $quantity . '</th>'; } $r .= '</tr>'; foreach ($sizes as $size) { $i = 1; $r .= '<tr><th>' . $size . '</th>'; foreach ($x as $quantity => $data) { $item = $data[$size]; $r .= '<td id=' . str_replace(" ","",$size) . ' class="col' . $i++ . '"><a href="/checkout/cart/add?product=' . $item['id'] . '" title="Add ' . $item['name'] . ' to basket">£' . $item['price'] . '</a></td>'; } } $r .= '</tr>'; $r .= '</table>'; $r .= '<p class="note"><strong>Note:</strong> Prices in this table do not include additional options as specified above!</p>'; return $r; }
-
From what I can see, the only driver that works with PHP on Linux is this: http://www.microsoft.com/en-us/download/details.aspx?id=28160 Does that seem right? Then hopefully I can take advantage of PDO to better prepare the queries. I'll look at some of the other suggestions too. Cheers!
-
Hi all, Thanks for the responses, I should have provided more context. Ultimately, it's an imperfect solution to an unavoidable problem. Our Linux web server running Magento has to link to our in-house MIS server running MSSQL. There is nothing there that can change, hence the mssql_* usage. Initially the checkCustomer method was very small, now it's grown significantly. It hooks into standard Magento event observers and is triggered when the "Place Order" is pressed, it works in the following way: 1) Gets details about the current order, and the customer involved. 2) Connects to the external MSSQL database, uses the name and first line of the address to check for existance in the database. If a match is found, then fine. 3) If not, it takes the first letters of both the first and surname, adds 0's to make it up to 6 characters long and iterates over until no match is found in the database, then adds the customer with those details. Our customer naming convention is this way, i.e Joe Bloggs becomes JB00001 unless that exists, then increment up until it doesn't. If it adds a customer I log it and e-mail myself. 4) It then iterates over the custom options selected on the product, looks for additional days (Our options follow this convention: Selected option +1day) so it plucks the integer out for each instance of the option, adds them up, then adds them to a pre-determined number, then adds that to the days function ending up with a lead-time. As I write it, it sounds confusing, but it's actually quite simple! Cheers.
-
Hi guys, I've managed to cobble together a PHP script which works perfectly, there are no faults or errors and it does exactly as intended. However I asked for some code critique and was advised that I could chop it up into smaller methods rather than one monster method to make it better or more efficient, as it's been added to quite regularly over the last few weeks, now it's finished I want to tidy it up. Can anyone provide some amendments or advice on how to make it a bit more streamline or tidy by perhaps creating additional methods with what I have or similar. Many thanks <?php class Tharstern_TharCustomer_Model_Observer { protected function despatchDate($startdate, $businessdays, $dateformat = 'c') { //vars $i = 1; $holidays = array("02-01-2012", "06-04-2012", "09-04-2012", "07-05-2012", "04-06-2012", "05-06-2012", "28-06-2012", "27-08-2012", "25-12-2012", "26-12-2012"); //start date depends on time >11pm +1day if(date('H') >= 11) { $dayx = strtotime($startdate. '+1 day'); } else $dayx = strtotime($startdate); $businessdays = ceil($businessdays); //loop over get preliminary date while($i < $businessdays) { $day = date('N',$dayx); $date = date('d-m-Y',$dayx); if($day < 6 && !in_array($date,$holidays)) $i++; $dayx = strtotime($date.' +1 day'); } //if preliminary date is weekend/bank holiday iterate over until neither $day = date('N',$dayx); $date = date('d-m-Y',$dayx); while($day >= 6 || in_array($date,$holidays)) { $dayx = strtotime($date.' +1 day'); $day = date('N',$dayx); $date = date('d-m-Y',$dayx); } //return final date for despatch return date($dateformat, $dayx); } public function checkCustomer($observer) { // connect to Tharstern $cnx = mssql_connect('xxxxxxx'); mssql_select_db('TharData'); // get customers billing name and email address $session = Mage::getSingleton('customer/session'); $customer = $session->getCustomer(); // get details $order = $observer->getEvent()->getOrder(); $orderId = $observer->getEvent()->getOrder()->getIncrementId(); $invAdd = $observer->getEvent()->getOrder()->getBillingAddress(); $productsCollection = $observer->getEvent()->getOrder()->getItemsCollection(); foreach($productsCollection as $_products) { if ($allOptions = $_products->getData('product_options')) { $options = unserialize($allOptions); if (isset($options['options'])) { $optionDays = 0; foreach ($options['options'] as $optionValues) { if ($optionValues['value']) { $_printValue = isset($optionValues['print_value']) ? $optionValues['print_value'] : strip_tags($optionValues['value']); $values = explode(', ', $_printValue); foreach ($values as $value) { preg_match('/(\d+)/', $value, $option); if(!isset($option[0]) || $option[0] == 24) { $extraDays = 0; } else $extraDays = $option[0]; $optionDays += $extraDays; } } } } } } $items = $order->getAllVisibleItems(); foreach ($items as $item) { $product = Mage::getModel('catalog/product')->load($item->getProductId()); $turnaround = $product->getAttributeText('turnaround'); preg_match('/(\d+)/', $turnaround, $base); if(!isset($base[0]) || $base[0] == 24) { $baseDays = 0; } else $baseDays = $base[0]; $finalDespatchDate = $this->despatchDate(date('d-m-Y'), $optionDays + $baseDays); } // check if a company is specified otherwise use the billing name $identifier = $customer->getName(); //if(isset($customer->getCompany())){ //$identifier = $customer->getCompany(); //} // query database and check for customers existence $check = mssql_query("SELECT Customers.Code, Customers.Name, Customers.Address, Customers.Town, Customers.County, Customers.Postcode, CustomerContacts.Email, Customers.Ref3 FROM Customers INNER JOIN CustomerContacts ON Customers.Name=CustomerContacts.Name WHERE Customers.Name ='".$identifier."' AND CustomerContacts.Email ='".$customer->getEmail()."' AND Ref3 = 'Advantage' AND Address = '".$invAdd->getStreet(1)."' AND Postcode = '".$invAdd->getPostcode()."' GROUP BY Customers.Code, Customers.Name, Customers.Address, Customers.Town, Customers.County, Customers.Postcode, CustomerContacts.Email, Customers.Ref3"); // check results if(mssql_num_rows($check) == 1) { // echo customer code $row = mssql_fetch_array($check); $tharCode = $row['Code']; // Mage_Core db connection to update order column if applicable $write = Mage::getSingleton('core/resource')->getConnection('core_write'); $write->query("UPDATE sales_order SET customer_tharstern_code = '".$tharCode."', final_despatch_date = '".$finalDespatchDate."' WHERE increment_id = '".$orderId."' LIMIT 1"); if(!$check) { error_log("Error checking Tharstern for customer",1,"xxxxxxx"); } } elseif(mssql_num_rows($check) == 0) { // get initials and uppercase them if necessary $initials = ''; foreach(explode(' ', $customer->getName()) as $word) { $initials .= strtoupper($word[0]); } // set integer and string values to bendart 6-digit convention $codeNum = 0; $codeStr = $initials.'0001'; // iterate through results until no match is found do { $codeNum++; $codeStr = $initials . str_pad($codeNum, 4, '0', STR_PAD_LEFT); $query = mssql_query("SELECT * FROM Customers WHERE Code = '".$codeStr."'"); } while(mssql_num_rows($query) == 1); // Mage_Core db connection to update order column with new customers code $write = Mage::getSingleton('core/resource')->getConnection('core_write'); $write->query("UPDATE sales_order SET customer_tharstern_code = '".$tharCode."', final_despatch_date = '".$finalDespatchDate."' WHERE increment_id = '".$orderId."' LIMIT 1"); // add customer to Tharstern for processing $addCustomer = mssql_query("INSERT INTO Customers(Code,Name,Address,Town,County,Postcode,Ref1,Ref2,Ref3,PostingAccount) VALUES ('".$codeStr."','".$customer->getName()."','".$invAdd->getStreet(1)."','".$invAdd->getCity()."','".$invAdd->getRegion()."','".$invAdd->getPostcode()."','Web Sales','Retail','Advantage','CASHCU'); INSERT INTO CustomerContacts(ParentCustomer,Name,Email,EmailName,PrimaryContact,GMDisabled) VALUES ('".$codeStr."','".$customer->getName()."','".$customer->getEmail()."','".$customer->getName()." (".$customer->getEmail().")','1','1')"); // check result and e-mail if(!$addCustomer) { error_log("Error adding customer to Tharstern",1,"tom@bendart.co.uk"); } else { // write new customer details to csv for logging purposes. $csv = $_SERVER['DOCUMENT_ROOT']."/var/log/newcustomersadded.csv"; $handle = fopen($csv, 'a'); $data = "\n".date ('Y-m-d H:i:s').",".$orderId.",".$codeStr.",".$customer->getName(); fwrite($handle, $data); fclose($handle); mail('xxxx,'New Customer', 'New Customer Created: '.$codeStr); } } } }
-
Hi, I have x amount of tables, and a drop-down with x values in. The tables are auto-generated based on the values in the drop-downs, so if there's 4 drop-down selections there's 4 tables. What I want to do is show/hide each table depending on the selection, so if drop-down selection 1 is selected, show table 1 and so on. Here's an example page. There are 4 seperate drop-down entities but I'm only interested in the 3rd one, select paper. This is #attribute129. Once that drop-down is changed to another value I want my tables below to reflect that. Example: http://dev4.printpartnerships.com/flyer-printing Top table is 300gsm Gloss, bottom table is 400gsm Matt. When those options are selected in the drop-down I want the corresponding table only to show. Here's what I have so far but it just hides both of them <script type="text/javascript"> jQuery.noConflict(); jQuery(document).ready(function(){ jQuery('#attribute129').change(function(){ jQuery('#matrix-container').hide().eq($(this).val()).show() }); }); </script> Hopefully someone can figure it out? Cheers.
-
Hi guys, I've got a situation where, for example, file1.php contains a method call and the echo'ing of a table. file2.php contains the method and is what processes and ultimately produces the data and sends it back to file1.php for formatting. I need to mix this up a bit by adding the table echo's to file2.php but retain the "call" in file1.php. Here's my 2 files so to speak currently: File1.php - the table view and call <?php $childProducts = Mage::getModel('catalog/product_type_configurable')->getMatrix(null, $_product); $x = array(); foreach ($childProducts as $children) { $x[$children->getAttributeText('quantity')][$children->getAttributeText('size')] = array('id'=>$children->getId(), 'price'=>number_format($children->getPrice(),'2'), 'name'=>$children->getName()); } ksort( $x ); echo '<table class="matrix"><tr><th></th>'; foreach( array_keys(current($x)) as $size ) { echo '<th>'.$size.'</th>'; } echo '</tr>'; foreach( $x as $quantity => $data ) { echo '<tr><th>'.$quantity.'</th>'; foreach( $data as $item ) { echo '<td><a href="/checkout/cart/add?product='.$item[id].'" title="Add '.$item[name].' to basket">£'.$item[price].'</a></td>'; } echo '</tr>'; } echo '</table>'; ?> File2.php - the method that processes <?php class OrganicInternet_SimpleConfigurableProducts_Catalog_Model_Product_Type_Configurable extends Mage_Catalog_Model_Product_Type_Configurable { /** * Retrieve array of "subproducts" for 300gsm flyers based on standard getUsedProducts * * @param array * @param Mage_Catalog_Model_Product $product * @return array */ public function getMatrix($requiredAttributeIds = null, $product = null) { Varien_Profiler::start('CONFIGURABLE:'.__METHOD__); if ($this->getProduct($product)->hasData($this->_usedProducts)) { if (is_null($requiredAttributeIds) and is_null($this->getProduct($product)->getData($this->_configurableAttributes))) { // If used products load before attributes, we will load attributes. $this->getConfigurableAttributes($product); // After attributes loading products loaded too. Varien_Profiler::stop('CONFIGURABLE:'.__METHOD__); return $this->getProduct($product)->getData($this->_usedProducts); } $usedProducts = array(); $collection = $this->getUsedProductCollection($product) ->addAttributeToSelect('*') ->addFieldToFilter('name', array('like' => '%300gsm Flyers%')); //->groupByAttribute('size'); $x = $collection->getSize(); // ->addFilterByRequiredOptions(); if (is_array($requiredAttributeIds)) { foreach ($requiredAttributeIds as $attributeId) { $attribute = $this->getAttributeById($attributeId, $product); if (!is_null($attribute)) $collection->addAttributeToFilter($attribute->getAttributeCode(), array('notnull'=>1)); } } foreach ($collection as $item) { $usedProducts[] = $item; } $this->getProduct($product)->setData($this->_usedProducts, $usedProducts); } Varien_Profiler::stop('CONFIGURABLE:'.__METHOD__); return $this->getProduct($product)->getData($this->_usedProducts); } } ?> I need the tabular part, from x = array downwards from File1.php to be part of File2.php, however I need to retain the $childProducts = Mage.... part in File1.php and pass any necessary data through to the method, however which ever way I try it I end up with errors about undefined methods etc. Visually I will see no difference on screen as it should still create the same table in the same way, however I'm going to be using AJAX to produce a new table on select so need the table as part of the method. Any help is greatly appreciated as I keep breaking it! Cheers.
-
Ah OK gotcha. One last thing, I'm working on a Magento platform which uses prototype. Is prototype "just another" library like jQuery or mootools, and as such a good option to try and work within this or is it not the case? I've read that libraries can conflict with each other and have used jQuery noConflict in the past to great effect, but am wondering if I have the choice to start with it might be be an idea to try and avoid the conflicts? Cheers
-
So if I read what you're saying is right, and referring back to my original post, if I want to pass a different value to PHP for data retrieval it's AJAX I'll need, not jQuery? My table is prepoluated with "default" values, however on select of a drop-down will pass a value to a PHP to potentially change the data in that table. Cheers.
-
Hi thorpe, Thanks for the response. So just to confirm, going on my description jQuery is the solution, not AJAX? I find the 2 a bit confusing that's all as to their differences! Cheers.
-
Hi guys, Here's my dev page: http://dev4.printpartnerships.com/flyer-printing Thanks to the awesome help I got in the PHP part I've got that table displaying correctly underneath the drop-downs, it's dynamically created. As you can see, I have 4 drop-down boxes. The third one is where you choose the paper, although you can't operate it until you've filled the other 2 out. Once you select an option in there, for example 300gsm stock, I need the table to change. Now, currently I use a function called getFlyers300gsm in my PHP so rather than having a function for every paper stock I was hoping I could have a function called getMatrix() or similar in PHP that passes a variable to the function depending on the value of that dropdown, thus manipulating the table and reloading it. So to summarise, table loads a default set of figures on page load, drop-down box is changed, value is passed to PHP and table is reloaded. I'm not sure whether this is jQuery or Javascript or AJAX so forgive me if this post needs to be moved, I have little experience in JS. The PHP part of the equation I believe I can handle, it's just this part stumps me. If anyone can give me some help I'd greatly appreciate it. Cheers.
-
Thanks xyph all done and I understand how to feed more info into the array now for use later on. Between you and Russell you've saved me hours, so thanks very much! I'll mark this as solved now!
-
Hi xyph, If I do this: foreach ($childProducts as $children) { $size = $children->getAttributeText('size'); $quantity = $children->getAttributeText('quantity'); $price = "£".number_format($children->getPrice(),'2'); $x[$quantity][$size] = $price; echo $children->getId(); } It echo's all the ID's of the children as expected. How do I move this down into the lower foreach where the price is echo'd? Cheers.