Re: Where should I put this +- Quantity code?
Posted: Sun Feb 08, 2015 4:44 pm
So the bit that isn't working is also not included in that code you just posted?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<div class='product_dimension_inner'><select name='length' onChange=\"prechecklength(this.value)\" class='selectpremier'>
<option value='0'>Choose</option>";
$resultlength = mysql_query ("SELECT DISTINCT length FROM products WHERE sku = '$sku' AND length <> '0' ORDER by length");
$num_rows = mysql_num_rows($resultlength);
if ($num_rows != 0)
{
while ($rowlength = mysql_fetch_object($resultlength))
{
echo "<option value='$rowlength->length'>$rowlength->length\"</option>";
}
echo "</select></div></div>";
}
echo "<div class='product_dimension'><div class='product_dimension_inner'>Thickness</div>
<div class='product_dimension_inner'><select name='thickness' onChange=\"precheckthickness(this.value)\" class='selectpremier'>
<option value='0'>Choose</option>";
$resultthickness = mysql_query ("SELECT DISTINCT thickness FROM products WHERE sku = '$sku' AND thickness <> '0' ORDER by thickness");
$num_rows = mysql_num_rows($resultthickness);
if ($num_rows != 0)
{
while ($rowthickness = mysql_fetch_object($resultthickness))
{
echo "<option value='$rowthickness->thickness'>$rowthickness->thickness\"</option>";
}
echo "</select></div></div>";
}
echo "
<div id='srcHint' class='hintbox'>
</div>Code: Select all
function precheckdepth(str)
{
if (str=="")
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("srcHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","/ajax_premier.php?depth="+str,true);
xmlhttp.send();
}
function prechecklength(str)
{
if (str=="")
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("srcHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","/ajax_premier.php?length="+str,true);
xmlhttp.send();
}
function precheckthickness(str)
{
if (str=="")
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("srcHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","/ajax_premier.php?thickness="+str,true);
xmlhttp.send();
}
</script>Code: Select all
<Script>$(window).load(function(){
jQuery(document).ready(function(){
// This button will increment the value
$('.qtyplus').click(function(e){
// Stop acting like a button
e.preventDefault();
// Get the field name
fieldName = $(this).attr('field');
// Get its current value
var currentVal = parseInt($('input[name='+fieldName+']').val());
// If is not undefined
if (!isNaN(currentVal)) {
// Increment
$('input[name='+fieldName+']').val(currentVal + 1);
} else {
// Otherwise put a 0 there
$('input[name='+fieldName+']').val(0);
}
});
// This button will decrement the value till 0
$(".qtyminus").click(function(e) {
// Stop acting like a button
e.preventDefault();
// Get the field name
fieldName = $(this).attr('field');
// Get its current value
var currentVal = parseInt($('input[name='+fieldName+']').val());
// If it isn't undefined or its greater than 0
if (!isNaN(currentVal) && currentVal > 0) {
// Decrement one
$('input[name='+fieldName+']').val(currentVal - 1);
} else {
// Otherwise put a 0 there
$('input[name='+fieldName+']').val(0);
}
});
});
});//]]>
</script>
<script type='text/javascript' src='//code.jquery.com/jquery-1.9.1.js'></script>
<?php
session_start();
include "dbconn.php";
?>
<?php
$sku = isset($_SESSION['sku']) ? $_SESSION['sku'] : null;
echo "
<form id='myform' action='/cart.asp' method='post'>
<input type='hidden' name='itemcode' value='$sku'>";
$query = mysql_query("SELECT depth FROM products WHERE depth <> '0' AND sku = '$sku'");
$num_rows = mysql_num_rows($query);
if ($num_rows == 0) { $depth = "0"; }
if ($num_rows != 0)
{
$depth = "0";
if(isset($_GET['depth']))
{
$depth = $_GET['depth'];
$_SESSION['depth']=$depth;
echo "<input type='hidden' name='itemname3' value='$depth'>";
}
else if (isset($_SESSION['depth']))
{
$depth=$_SESSION['depth'];
echo "<input type='hidden' name='itemname3' value='$depth'>";
}
}
$query = mysql_query("SELECT length FROM products WHERE length <> '0' AND sku = '$sku'");
$num_rows = mysql_num_rows($query);
if ($num_rows == 0) { $length = "0"; }
if ($num_rows != 0)
{
$length = "0";
if(isset($_GET['length']))
{
$length = $_GET['length'];
$_SESSION['length']=$length;
echo "<input type='hidden' name='itemname2' value='$length'>";
}
else if (isset($_SESSION['length']))
{
$length=$_SESSION['length'];
echo "<input type='hidden' name='itemname2' value='$length'>";
}
}
$query = mysql_query("SELECT thickness FROM products WHERE thickness <> '0' AND sku = '$sku'");
$num_rows = mysql_num_rows($query);
if ($num_rows == 0) { $thickness = "0"; }
if ($num_rows != 0)
{
$thickness = "0";
if(isset($_GET['thickness']))
{
$thickness = $_GET['thickness'];
$_SESSION['thickness']=$thickness;
echo "<input type='hidden' name='itemname4' value='$thickness'>";
}
else if (isset($_SESSION['thickness']))
{
$thickness=$_SESSION['thickness'];
echo "<input type='hidden' name='itemname4' value='$thickness'>";
}
}
$query = mysql_query("SELECT price, productid, sku FROM products WHERE depth = '$depth' AND length = '$length' AND thickness = '$thickness' AND sku ='$sku'");
$num_rows = mysql_num_rows($query);
if ($num_rows == 0 )
{
}
else
{
echo "<div class='ajax_buynowbox' >";
while ($row = mysql_fetch_object($query))
{
echo "<div class='product_price'>£$row->price</div>
<input type='submit' value='Add to Cart' class='submit_buynow'>";
// <input type='button' value='-' class='qtyminus' field='quantity' />
// <input type='text' name='quantity' value='5' class='qty' />
// <input type='button' value='+' class='qtyplus' field='quantity' />
echo "<select name='quantity' class='qty'>
<option value='1'>1</option>
<option value='2'>2</option>
<option value='3'>3</option>
<option value='4'>4</option>
<option value='5'>5</option>
</select>
";
}
echo "</div>";
}
mysql_close($sqlconn);
echo "</form>";
?>
Code: Select all
<select name='depth' onChange=\"precheckdepth(this.value); checklength(this.value); \" class='selectpremier'>Code: Select all
$('select[name="depth"]').change(function() {
// do stuff
});
Code: Select all
<div id='dimension_thickness' class='product_dimension'></div>