SHARE
TWEET

Untitled

a guest Jan 28th, 2016 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <html>
  2.     <?php
  3.         $dbhost = 'localhost';
  4.         $dbuser = 'ktce8911_ktcDB';
  5.         $dbpass = '3Pl6t[(gS5';
  6.         $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  7.         if(! $conn )
  8.         {
  9.           die('Could not connect: ' . mysql_error());
  10.         }  ?>
  11.        
  12.         <div class="pc8-catalog-container">
  13.             <div class="pc8-category">
  14.                 <h2 class="pc8-catmarg">Accessories</h2>
  15.             </div> 
  16.             <div class="pc8-category-description"></div>
  17.            
  18.             <div class="pc8-subcategory">
  19.                 <h3 class="pc8-indent pc8-catmarg">Bar End</h3>
  20.             </div>
  21.             <div class="pc8-subcategory-description pc8-indent"></div>
  22.        
  23.         <?php
  24.             $sql = "SELECT product_name, product_image, product_description, product_link
  25.             FROM ktc_pc8_products WHERE Category = 'Accessories' AND Subcategory = 'Bar End'
  26.             ORDER BY product_name ASC";
  27.  
  28.             mysql_select_db('ktce8911_ktcdb');
  29.             $retval = mysql_query( $sql, $conn );
  30.             if(! $retval )
  31.             {
  32.               die('Could not get data: ' . mysql_error());
  33.             }
  34.  
  35.             while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
  36.             {      
  37.         ?> 
  38.             <div class="pc8-product">
  39.                 <div class="pc8-product-image" style="width:25%">
  40.                     <img class="pc8-resize" src="<?php echo $row['product_image']; ?>">
  41.                 </div>
  42.                 <div class="pc8-product-text" style="width:70%">
  43.                     <h3 class="pc8-nospace pc8-product-title"><?php echo "{$row['product_name']}"; ?></h3>
  44.                 <p class="pc8-nospace"></p>
  45.                 <p class="pc8-margtop"></p>
  46.                 <?php echo stripslashes("{$row['product_description']}"); ?>
  47.                 <p></p>
  48.             </div>
  49.         </div>
  50.     <?php } ?>
  51.    
  52.     <div class="pc8-subcategory">
  53.         <h3 class="pc8-indent pc8-catmarg">Throttle Gas</h3>
  54.     </div>
  55.     <div class="pc8-subcategory-description pc8-indent"></div>
  56.    
  57.     <?php
  58.             $sql = "SELECT product_name, product_image, product_description, product_link
  59.             FROM ktc_pc8_products WHERE Category = 'Accessories' AND Subcategory = 'Throttle Gas'
  60.             ORDER BY product_name ASC";
  61.  
  62.             mysql_select_db('ktce8911_ktcdb');
  63.             $retval = mysql_query( $sql, $conn );
  64.             if(! $retval )
  65.             {
  66.               die('Could not get data: ' . mysql_error());
  67.             }
  68.  
  69.             while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
  70.             {      
  71.         ?> 
  72.             <div class="pc8-product">
  73.                 <div class="pc8-product-image" style="width:25%">
  74.                     <img class="pc8-resize" src="<?php echo $row['product_image']; ?>">
  75.                 </div>
  76.                 <div class="pc8-product-text" style="width:70%">
  77.                     <h3 class="pc8-nospace pc8-product-title"><?php echo "{$row['product_name']}"; ?></h3>
  78.                 <p class="pc8-nospace"></p>
  79.                 <p class="pc8-margtop"></p>
  80.                 <?php echo stripslashes("{$row['product_description']}"); ?>
  81.                 <p></p>
  82.             </div>                 
  83.         </div>
  84.     <?php } ?> 
  85.            
  86.     <div class="pc8-subcategory">
  87.         <h3 class="pc8-indent pc8-catmarg">Suspension</h3>
  88.     </div>
  89.     <div class="pc8-subcategory-description pc8-indent"></div>
  90.    
  91.     <?php
  92.             $sql = "SELECT product_name, product_image, product_description, product_link
  93.             FROM ktc_pc8_products WHERE Category = 'Accessories' AND Subcategory = 'Suspension'
  94.             ORDER BY product_name ASC LIMIT 0,1";
  95.  
  96.             mysql_select_db('ktce8911_ktcdb');
  97.             $retval = mysql_query( $sql, $conn );
  98.             if(! $retval )
  99.             {
  100.               die('Could not get data: ' . mysql_error());
  101.             }
  102.  
  103.             while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
  104.             {      
  105.         ?> 
  106.             <div class="pc8-product">
  107.                 <div class="pc8-product-image" style="width:25%">
  108.                     <img class="pc8-resize" src="<?php echo $row['product_image']; ?>">
  109.                 </div>
  110.                 <div class="pc8-product-text" style="width:70%">
  111.                     <h3 class="pc8-nospace pc8-product-title"><?php echo "{$row['product_name']}"; ?></h3>
  112.                 <p class="pc8-nospace"></p>
  113.                 <p class="pc8-margtop"></p>
  114.                 <?php echo stripslashes("{$row['product_description']}"); ?>
  115.                 <p></p>
  116.             </div>                 
  117.         </div>
  118.     <?php } ?>     
  119.            
  120.     </div>     
  121.  
  122. <?php if (function_exists("pagination")) {
  123.     pagination($additional_loop->max_num_pages);
  124. } ?>   
  125.    
  126. <div class="main_paging">
  127.     <div class="number">Page</div>
  128.     <div class="number">1</div>
  129.     <div class="number"><a href="http://ktcracing.com/products-2/">2 </a></div>
  130.     <div class="number"><a href="http://ktcracing.com/products-3/">3 </a></div>
  131.     <div class="number"><a href="http://ktcracing.com/products-4/">4 </a></div>
  132.     <div class="number"><a href="http://ktcracing.com/products-5/">5 </a></div>
  133.     <div class="number"><a href="http://ktcracing.com/products-6/">6 </a></div>
  134.     <div class="number"><a href="http://ktcracing.com/products-7/">7 </a></div>
  135.     <div class="number"><a href="http://ktcracing.com/products-8/">8 </a></div>
  136.     <div class="number"><a href="http://ktcracing.com/products-9/">9 </a></div>
  137.     <div class="number"><a href="http://ktcracing.com/products-10/">10 </a></div>
  138.     <div class="number"><a href="http://ktcracing.com/products-11/">11 </a></div>
  139.     <div class="number"><a href="http://ktcracing.com/products-12/">12 </a></div>
  140.     <div class="number"><a href="http://ktcracing.com/products-13/">13 </a></div>
  141.     <div class="number"><a href="http://ktcracing.com/products-14/">14 </a></div>
  142.     <div class="number"><a href="http://ktcracing.com/products-15/">15 </a></div>
  143.     <div class="number"><a href="http://ktcracing.com/products-16/">16 </a></div>
  144.     <div class="number"><a href="http://ktcracing.com/products-17/">17 </a></div>
  145.     <div class="number"><a href="http://ktcracing.com/products-18/">18 </a></div>
  146.     <div class="number"><a href="http://ktcracing.com/products-19/">19 </a></div>
  147.     <div class="number"><a href="http://ktcracing.com/products-20/">20 </a></div>
  148.     <div class="number"><a href="http://ktcracing.com/products-21/">21 </a></div>
  149.     <div class="number"><a href="http://ktcracing.com/products-22/">22 </a></div>
  150.     <div class="number"><a href="http://ktcracing.com/products-23/">23 </a></div>
  151.     <div class="number"><a href="http://ktcracing.com/products-24/">24 </a></div>
  152.     <div class="number"><a href="http://ktcracing.com/products-25/">25 </a></div>
  153.     <div class="number"><a href="http://ktcracing.com/products-26/">26 </a></div>
  154. </div> 
  155.                            
  156.         <?php
  157.             mysql_close($conn);
  158.         ?>
  159. </html>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top