Advertisement
Advertisement
| 03.11.2008 at 07:45PM PDT, ID: 23233917 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: 370: 371: 372: 373: 374: 375: 376: 377: 378: 379: 380: 381: 382: 383: 384: 385: 386: 387: 388: 389: 390: 391: 392: 393: 394: 395: 396: 397: 398: 399: 400: 401: 402: 403: 404: 405: 406: 407: 408: 409: 410: 411: 412: 413: 414: 415: 416: 417: 418: 419: 420: 421: 422: 423: 424: 425: 426: 427: 428: 429: 430: 431: 432: 433: 434: 435: 436: 437: 438: 439: 440: 441: 442: 443: 444: 445: 446: 447: 448: 449: 450: 451: 452: 453: 454: 455: 456: 457: 458: 459: 460: 461: 462: 463: 464: 465: 466: 467: 468: 469: 470: 471: 472: 473: 474: 475: 476: 477: 478: 479: 480: 481: 482: 483: 484: 485: 486: 487: 488: 489: 490: 491: 492: 493: 494: 495: 496: 497: 498: 499: 500: 501: 502: 503: 504: 505: 506: 507: 508: 509: 510: 511: 512: 513: 514: 515: 516: 517: 518: 519: 520: 521: 522: 523: 524: 525: 526: 527: 528: 529: 530: 531: 532: 533: |
<?php
include('includeme.php');
$errors=array();
if (array_key_exists("size1", $_POST) || array_key_exists("style1", $_POST) || array_key_exists("frame1", $_POST) || array_key_exists("size3", $_POST) || array_key_exists("style3", $_POST) || array_key_exists("frame3", $_POST))
{
$query13 = "SELECT * FROM store WHERE id='" . mysql_real_escape_string(trim($_GET['item'])) . "'";
$result13 = mysql_query ($query13);
$row13 = mysql_fetch_array($result13);
$query17="DELETE FROM items";
$result17=mysql_query($query17);
$query18="insert into items (title) values ( '" . mysql_real_escape_string(trim($row13['title'])) . "')";
$result18=mysql_query($query18);
if($row13['isdropdown']=="square")
{
$array = explode("-", $_POST['size1']);
$_SESSION['addsize'] = $array[0];
$_SESSION['descript1']= $array[1];
$array = explode("-", $_POST['style1']);
$_SESSION['addstyle'] = $array[0];
$_SESSION['descript2']= $array[1];
$array = explode("-", $_POST['frame1']);
$_SESSION['addframe'] = $array[0];
$_SESSION['descript3']= $array[1];
$query12 = "UPDATE items set
alterprice1='" . mysql_real_escape_string(trim($_SESSION['addsize'])) . "',
alterprice2='" . mysql_real_escape_string(trim($_SESSION['addstyle'])) . "',
alterprice3='" . mysql_real_escape_string(trim($_SESSION['addframe'])) . "',
desc1='" . mysql_real_escape_string(trim($_SESSION['descript1'])) . "',
desc2='" . mysql_real_escape_string(trim($_SESSION['descript2'])) . "',
desc3='" . mysql_real_escape_string(trim($_SESSION['descript3'])) . "' where title= '" . mysql_real_escape_string(trim($row13['title'])) . "'";
$result12 = mysql_query ($query12);
$query12 = "UPDATE cart set
addprice1='" . mysql_real_escape_string(trim($_SESSION['addsize'])) . "',
addprice2='" . mysql_real_escape_string(trim($_SESSION['addstyle'])) . "',
addprice3='" . mysql_real_escape_string(trim($_SESSION['addframe'])) . "',
desc1='" . mysql_real_escape_string(trim($_SESSION['descript1'])) . "',
desc2='" . mysql_real_escape_string(trim($_SESSION['descript2'])) . "',
desc3='" . mysql_real_escape_string(trim($_SESSION['descript3'])) . "' where title= '" . mysql_real_escape_string(trim($row13['title'])) . "'";
$result12 = mysql_query ($query12);
$_SESSION['addsize']="";
$_SESSION['addstyle']="";
$_SESSION['addframe']="";
$_SESSION['descript1']="";
$_SESSION['descript2']="";
$_SESSION['descript3']="";
}
if($row13['isdropdown']=="oval")
{
$array = explode("-", $_POST['size3']);
$_SESSION['addsize2'] = $array[0];
$_SESSION['descript4']= $array[1];
$array = explode("-", $_POST['style3']);
$_SESSION['addstyle2'] = $array[0];
$_SESSION['descript5']= $array[1];
$array = explode("-", $_POST['frame3']);
$_SESSION['addframe2'] = $array[0];
$_SESSION['descript6']= $array[1];
$query12 = "UPDATE items set
alterprice1='" . mysql_real_escape_string(trim($_SESSION['addsize2'])) . "',
alterprice2='" . mysql_real_escape_string(trim($_SESSION['addstyle2'])) . "',
alterprice3='" . mysql_real_escape_string(trim($_SESSION['addframe2'])) . "',
desc1='" . mysql_real_escape_string(trim($_SESSION['descript4'])) . "',
desc2='" . mysql_real_escape_string(trim($_SESSION['descript5'])) . "',
desc3='" . mysql_real_escape_string(trim($_SESSION['descript6'])) . "' where title= '" . mysql_real_escape_string(trim($row13['title'])) . "'";
$result12 = mysql_query ($query12);
$query12 = "UPDATE cart set
addprice1='" . mysql_real_escape_string(trim($_SESSION['addsize2'])) . "',
addprice2='" . mysql_real_escape_string(trim($_SESSION['addstyle2'])) . "',
addprice3='" . mysql_real_escape_string(trim($_SESSION['addframe2'])) . "',
desc1='" . mysql_real_escape_string(trim($_SESSION['descript4'])) . "',
desc2='" . mysql_real_escape_string(trim($_SESSION['descript5'])) . "',
desc3='" . mysql_real_escape_string(trim($_SESSION['descript6'])) . "' where title= '" . mysql_real_escape_string(trim($row13['title'])) . "'";
$result12 = mysql_query ($query12);
$_SESSION['addsize2']="";
$_SESSION['addstyle2']="";
$_SESSION['addframe2']="";
$_SESSION['descript4']="";
$_SESSION['descript5']="";
$_SESSION['descript6']="";
}
$query14 = "SELECT * FROM items WHERE title='" . mysql_real_escape_string(trim($row13['title'])) . "'";
$result14 = mysql_query ($query14);
$row14 = mysql_fetch_array($result14);
$_SESSION['add7']="0";
$_SESSION['add7']=$row14['price'] + $row14['alterprice1'] + $row14['alterprice2'] + $row14['alterprice3'];
?> <!--
$query15="UPDATE items set price= '" . mysql_real_escape_string(trim($_SESSION['add7'])) . "' where title= '" . mysql_real_escape_string(trim($row13['title'])) . "'";
$result15 = mysql_query ($query15);
-->
<?php
}
if(isset($_POST['submit1']))
{
if(isset($_POST['quantity']) && $_POST['quantity'] != "")
{
$query = "SELECT * FROM store WHERE id='" . mysql_real_escape_string(trim($_GET['item'])) . "'";
$result = mysql_query ($query);
$row = mysql_fetch_array($result);
$query2 = "SELECT * FROM items WHERE title='" . mysql_real_escape_string(trim($row['title'])) . "'";
$result2 = mysql_query ($query2);
$row2 = mysql_fetch_array($result2);
if($row['category5']!="")
{
$categorycart=$row['category5'];
}
if($row['category4']!="")
{
$categorycart=$row['category4'];
}
if($row['category3']!="")
{
$categorycart=$row['category3'];
}
if($row['category2']!="")
{
$categorycart=$row['category2'];
}
if($row['category1']!="")
{
$categorycart=$row['category1'];
}
$query2 = "INSERT INTO cart (id1,skew,category,baseprice,addprice1,addprice2,addprice3,desc1,desc2,desc3,title,quantity,shipping) VALUES ('"
. mysql_real_escape_string(trim($row['id'])) . "', '"
. mysql_real_escape_string(trim($row['skew'])) . "', '"
. mysql_real_escape_string(trim($categorycart)) . "', '"
. mysql_real_escape_string(trim($row['price'])) . "', '"
. mysql_real_escape_string(trim($row2['alterprice1'])) . "', '"
. mysql_real_escape_string(trim($row2['alterprice2'])) . "', '"
. mysql_real_escape_string(trim($row2['alterprice3'])) . "', '"
. mysql_real_escape_string(trim($row2['desc1'])) . "', '"
. mysql_real_escape_string(trim($row2['desc2'])) . "', '"
. mysql_real_escape_string(trim($row2['desc3'])) . "', '"
. mysql_real_escape_string(trim($row['title'])) . "', '"
. mysql_real_escape_string(trim($_POST['quantity'])) . "', '"
. mysql_real_escape_string(trim($row['shipping'])) . "')";
$result2 = mysql_query ($query2);
header("Location:add-to-cart-confirmation.php?item=" . $row['id'] . "&quantity=" . $_POST['quantity']);
exit();
}
else if(isset($_POST['quantity']) && $_POST['quantity'] == "")
{
$errors[]=" You must enter a quantity when adding to your cart.";
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>Wall Mirrors</title>
<meta name="description" content="We offer newly built resorts and exotic townhouses">
<meta name="keywords" content="resorts, Exotic Townhouses, Undeveloped Land">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="robots" content="index,follow">
<link rel="stylesheet" type="text/css" href="style.css">
<style type="text/css">
#container
{
min-height:850px;
height:850px;
}
#wrap2
{
min-height:850px;
height:850px;
}
#wrap
{
min-height:850px;
height:850px;
}
</style>
</head>
<body>
<div id="wrap2">
<div id="wrap">
<div id="container">
<div id="maintop">
<img src="images/header.gif">
</div>
<div id="leftmenu2">
<?php include('menu.php'); ?>
</div>
<div id="middle2">
<?php
$query9 = "SELECT * FROM store WHERE id='" . mysql_real_escape_string(trim($_GET['item'])) . "'";
$result9 = mysql_query ($query9);
$row9 = mysql_fetch_array($result9);
$query16 = "SELECT * FROM items WHERE title='" . mysql_real_escape_string(trim($row9['title'])) . "'";
$result16 = mysql_query ($query16);
$row16 = mysql_fetch_array($result16);
?>
<br>
<div id="main">
<?php
if (count($errors)>0)
{
$error = implode("<br />", $errors);
$error = "<span style=\"color:red;font-weight:bold;\">" . $error . "</span>";
echo $error;
}
?>
<br>
<form name="myForm" style="margin-left:10px" action="cart.php?item=<?php echo $_GET['item'];?>&category=<?php echo (isset($_GET['category']) ? $_GET['category'] : ''); ?>" method="post">
<table width="600px" border="0" cellspacing="5" cellpadding="5" style="overflow:hidden">
<tr>
<td style="text-align:center"><a href="category-auto.php?category=<?php echo (isset($_GET['category']) ? $_GET['category'] : ''); ?>"><img style="border:0px" src="images/back.gif"></a></td>
<td style="text-align:center"></td>
<td></td>
</tr>
<tr>
<td style="text-align:center;width:310px" valign="top" rowspan="3"><img style="border:0px" src="thumbnailer.php?i=<?php echo "upload/" . $row9['imagefilename']; ?>&x=300&y=300&bg=255255255;" /></td>
<td style="text-align:center" valign="bottom">Enter Quantity: <input type="text" size="2" name="quantity"><br><br><input name="submit1" type="submit" value="Add to Cart"></td>
<td></td>
</tr>
<tr>
<td style="text-align:center">
<?php
$query17 = "SELECT * FROM cart WHERE title='" . mysql_real_escape_string(trim($row9['title'])) . "'";
$result17 = mysql_query ($query17);
$row17 = mysql_fetch_array($result17);
if($row17['baseprice']=="")
{
if($row16['alterprice1']=="" && $row16['alterprice2']=="" && $row16['alterprice3']=="")
{
echo "*1" . "Base Price:<br>$" . $row9['price'];
}
else
{
?>
Selections Chosen are <?php echo $row16['desc1']?>,<?php echo $row16['desc2']?>,<?php echo $row16['desc3']?>, Price With these Selections:<br><strong>$<?php
echo $row9['price'] + $row16['alterprice1'] + $row16['alterprice2'] + $row16['alterprice3'] . '</strong>';
}
}
else if($row17['addprice1']=="" && $row17['addprice2']=="" && $row17['addprice3']=="")
{
echo "*2" . "Base Price:<br>$" . $row9['price'];
}
else
{
?>
* Selections Chosen are <?php echo $row17['desc1']?>,<?php echo $row17['desc2']?>,<?php echo $row17['desc3']?>, Price With these Selections:<br>$<?php
echo $row17['baseprice'] + $row17['addprice1'] + $row17['addprice2'] + $row17['addprice3'];
}
?>
</strong></td>
<td></td>
<td></td>
</tr>
<tr>
<td style="text-align:center"><a href="category-auto.php?category=<?php echo (isset($_GET['category']) ? $_GET['category'] : ''); ?>"><img style="border:0px" src="images/back.gif"></a></td>
<td></td>
</tr>
<tr>
<td colspan="3" style="text-align:left"><strong><?php echo $row9['title'] ?></strong><br><br><?php echo stripslashes($row9['description']) ?>
<?php if($row9['isdropdown']=="square")
{
unset($_SESSION['size2']);
unset($_SESSION['style2']);
unset($_SESSION['frame2']);
if (array_key_exists("size1", $_POST))
{ $_SESSION["size2"] = $_POST["size1"];
}
//make an associative array where the array key option value,
//and the array value is the option text
$size = array("0-8x8"=>"8x8 (add $0.00)",
"20-10x10"=>"10x10 (add $20.00)",
"70-14x14"=>"14x14 (add $70.00)",
"110-16x16"=>"16x16 (add $110.00)",
"140-18x18"=>"18x18 (add $140.00)",
"170-20x20"=>"20x20 (add $170.00)",
"210-22x22"=>"22x22 (add $210.00)",
"230-24x24"=>"24x24 (add $230.00)",
"250-26x26"=>"26x26 (add $250.00)",
"280-28x28"=>"28x28 (add $280.00)",
"310-30x30"=>"30x30 (add $310.00)",
"360-34x34"=>"34x34 (add $360.00)",
"400-36x36"=>"36x36 (add $400.00)",
"420-38x38"=>"38x38 (add $420.00)",
"450-40x40"=>"40x40 (add $450.00)",
"480-44x44"=>"44x44 (add $480.00)",
"530-46x46"=>"46x46 (add $530.00)",
"560-48x48"=>"48x48 (add $560.00)",
"610-50x50"=>"50x50 (add $610.00)",
"660-54x54"=>"54x54 (add $660.00)");
?>
<b>Mirror Size: </b>
<select name="size1" onchange="document.myForm.submit()">
<?php
//iterate through each element in the array, check each to see
//if it's key was selected and print an option
foreach ($size as $value => $text) {
$selected = "";
if ($value == $_SESSION["size2"]) {
$selected = "selected=\"selected\"";
}
echo "<option value=\"$value\" " . $selected . ">$text</option>";
}
?>
</select>
<?php
if (array_key_exists("style1", $_POST))
$_SESSION["style2"] = $_POST["style1"];
$style = array("0-Flat"=>"Flat (Add $0.00)",
"15-1 Inch Bevel"=>"1 Inch Bevel (Add $15.00)",
"25-1.5 Inch Bevel"=>"1.5 Inch Bevel (Add $25.00)",
"25-Smoked"=>"Smoked (Add $25.00)",
"25-Convex"=>"Convex (Add $25.00)");
?>
<br><b>Mirror Style: </b>
<select name="style1" onchange="document.myForm.submit()">
<?php
//iterate through each element in the array, check each to see
//if it's key was selected and print an option
foreach ($style as $value => $text) {
$selected = "";
if ($value == $_SESSION["style2"])
$selected = "selected=\"selected\"";
echo "<option value=\"$value\" $selected>$text</option>";
}
?>
</select>
<?php
if (array_key_exists("frame1", $_POST))
$_SESSION["frame2"] = $_POST["frame1"];
$frame = array("0-0 to 2 inch Frame Width"=>"0 to 2 Inch (Add $0.00)",
"0-3 Inch Frame Width"=>"3 Inch (Add $0.00)",
"25-4 Inch Frame Width"=>"4 Inch (Add 25.00)",
"35-5 Inch Frame Width"=>"5 Inch (Add $35.00)");
?>
<br><b>Mirror Frame Width: </b>
<select name="frame1" onchange="document.myForm.submit()">
<?php
//iterate through each element in the array, check each to see
//if it's key was selected and print an option
foreach ($frame as $value => $text) {
$selected = "";
if ($value == $_SESSION["frame2"])
$selected = "selected=\"selected\"";
echo "<option value=\"$value\" $selected>$text</option>";
}
?>
</select>
<?php
}
if($row9['isdropdown']=="oval")
{
unset($_SESSION['size4']);
unset($_SESSION['style4']);
unset($_SESSION['frame4']);
if (array_key_exists("size3", $_POST))
$_SESSION["size4"] = $_POST["size3"];
//make an associative array where the array key option value,
//and the array value is the option text
$size = array("0-8X10"=>"8X10 (Add $0.00)",
"30-10X13"=>"10X13 (Add $30.00)",
"50-11X14"=>"11X14 (Add $50.00)",
"70-12X16"=>"12X16 (Add $70.00)",
"100-14X18"=>"14X18 (Add $100.00)",
"120-12X24"=>"12X24 (Add $120.00)",
"140-16X20"=>"16X20 (Add $140.00)",
"170-18X24"=>"18X24 (Add $170.00)",
"190-20X24"=>"20X24 (Add $190.00)",
"210-20X30"=>"20X20 (Add $210.00)",
"230-22X28"=>"22X28 (Add $230.00)",
"250-24X30"=>"24X30 (Add $250.00)",
"300-24X36"=>"24X36 (Add $300.00)",
"350-24X48"=>"24X48 (Add $350.00)",
"370-30X40"=>"30X40 (Add $370.00)",
"470-36X48"=>"36X48 (Add $470.00)",
"570-36X60"=>"36X60 (Add $570.00)",
"670-48X60"=>"48X60 (Add $670.00)",
"660-48X72"=>"48X72 (Add $770.00)");
?>
<b>Mirror Size: </b>
<select name="size3" onchange="document.myForm.submit()">
<?php
//iterate through each element in the array, check each to see
//if it's key was selected and print an option
foreach ($size as $value => $text) {
$selected = "";
if ($value == $_SESSION["size4"])
$selected = "selected=\"selected\"";
echo "<option value=\"$value\" $selected>$text</option>";
}
?>
</select>
<?php
if (array_key_exists("style3", $_POST))
$_SESSION["style4"] = $_POST["style3"];
$style = array("0-Flat"=>"Flat (Add $0.00)",
"15-1 Inch Bevel"=>"1 Inch Bevel (Add $15.00)",
"25-1.5 Inch Bevel"=>"1.5 Inch Bevel (Add $25.00)",
"25-Smoked"=>"Smoked (Add $25.00)",
"25-Convex"=>"Convex (Add $25.00)");
?>
<br><b>Mirror Style: </b>
<select name="style3" onchange="document.myForm.submit()">
<?php
//iterate through each element in the array, check each to see
//if it's key was selected and print an option
foreach ($style as $value => $text) {
$selected = "";
if ($value == $_SESSION["style4"])
$selected = "selected=\"selected\"";
echo "<option value=\"$value\" $selected>$text</option>";
}
?>
</select>
<?php
if (array_key_exists("frame3", $_POST))
$_SESSION["frame4"] = $_POST["frame3"];
$frame = array("0-0 to 2 inch Frame Width"=>"0 to 2 Inch (Add $0.00)",
"0-3 Inch Frame Width"=>"3 Inch (Add $0.00)",
"25-4 Inch Frame Width"=>"4 Inch (Add 25.00)",
"35-5 Inch Frame Width"=>"5 Inch (Add $35.00)");
?>
<br><b>Mirror Frame Width: </b>
<select name="frame3" onchange="document.myForm.submit()">
<?php
//iterate through each element in the array, check each to see
//if it's key was selected and print an option
foreach ($frame as $value => $text) {
$selected = "";
if ($value == $_SESSION["frame4"])
$selected = "selected=\"selected\"";
echo "<option value=\"$value\" $selected>$text</option>";
}
?>
</select>
<?php
unset($_SESSION['size2']);
unset($_SESSION['style2']);
unset($_SESSION['frame2']);
unset($_SESSION['size4']);
unset($_SESSION['style4']);
unset($_SESSION['frame4']);
}
?>
</td>
</tr>
<tr>
</td>
</tr>
</table>
</form>
</p>
</div>
</div>
<?php include('footer.php'); ?>
<div id="clear1"> </div>
</div>
</div>
</div>
</body>
</html>
|