API tools faq
paste
Guest User

Untitled

a guest
Feb 10th, 2012
21
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.06 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. // Make a MySQL Connection
  3. mysql_connect("localhost", "", "") or die(mysql_error());
  4. mysql_select_db("opencart") or die(mysql_error());
  5.  
  6. // Retrieve all the data from the "example" table
  7. $result = mysql_query('SELECT `order`.*, `order_product`.`name`, `order_product`.`model`, `order_product`.`price`, `order_product`.`quantity`,`order_product`.`total`, `order_option`.`name` as option_name, `order_option`.`value` as option_value
  8. FROM `order_product`, `order`, `order_option`
  9. WHERE `order`.`order_id` = "2"')
  10. or die(mysql_error());
  11.  
  12. // store the record of the "example" table into $row
  13. $row = mysql_fetch_array( $result );
  14. // Print out the contents of the entry
  15.  
  16. ?>
  17.  
  18. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  19. <html xmlns="http://www.w3.org/1999/xhtml">
  20. <style type="text/css">
  21. .topbar {
  22. text-align: center;
  23. }
  24. .topbar {
  25. text-align: center;
  26. }
  27. </style>
  28. <style type="text/css">
  29. .ui-state-hover { background-color: #ffC }
  30. .inlineEdit-placeholder { font-style: italic; color: #555; }
  31. .style1 {
  32. color: #FFFFFF;
  33. font-weight: bold;
  34. font-family: Arial, Helvetica, sans-serif;
  35. }
  36. </style>
  37. <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js"></script>
  38. <script type="text/javascript" src="jquery.inlineedit.js"></script>
  39. <script type="text/javascript">
  40.  
  41. $(function() {
  42. $('.editable').inlineEdit();
  43. });
  44.  
  45. </script>
  46. <head>
  47. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
  48. <title>Untitled Document</title>
  49.  
  50. </head>
  51.  
  52. <script>
  53. function coderHakan()
  54. {
  55. var sayfa = window.open();
  56. sayfa.document.open("text/html");
  57. sayfa.document.write(document.getElementById('printArea').innerHTML);
  58. sayfa.document.close();
  59. sayfa.print();
  60. }
  61. </script>
  62.  
  63. <script type="text/javascript">
  64. function displayResult()
  65. {
  66. var table=document.getElementById("products");
  67. var row=table.insertRow(1);
  68. var cell1=row.insertCell(0);
  69. cell1.align = "left" ;
  70.  
  71. var cell2=row.insertCell(1);
  72. cell2.align = "left" ;
  73.  
  74. var cell3=row.insertCell(2);
  75. cell3.align = "right" ;
  76.  
  77. var cell4=row.insertCell(3);
  78. cell4.align = "right" ;
  79.  
  80. var cell5=row.insertCell(4);
  81. cell5.align = "right" ;
  82.  
  83. cell1.innerHTML='<span class="editable">Insert Product Description</span>';
  84. cell2.innerHTML='<span class="editable">XXXXXX</span>';
  85. cell3.innerHTML='<span class="editable">1</span>';
  86. cell4.innerHTML='<span class="editable">£00.00</span>';
  87. cell5.innerHTML='<span class="editable">£00.00</span>';
  88. }
  89. </script>
  90.  
  91.  
  92.  
  93.  
  94.  
  95.  
  96.  
  97.  
  98.  
  99.  
  100.  
  101.  
  102.  
  103.  
  104.  
  105.  
  106.  
  107.  
  108. <body>
  109. <hr size="10px" noshade="noshade" class="topbar" background-color="000000" />
  110. <table width="100%" border="0" cellpadding="10" height="50" bgcolor="#000000">
  111. <tr>
  112. <td width="50%" align="left" valign="middle" class="style1">Insert Order ID: </td>
  113. <td width="50%" align="right" valign="middle"><input type="button" style="height: 25px; width: 150px" class="topbar" onclick="coderHakan()" value="Print" />
  114. <input type="button" style="height: 25px; width: 150px" class="topbar" onclick="displayResult()" value="Add Product Row" /></td>
  115. </tr>
  116. </table>
  117. <hr size="10px" noshade="noshade" class="topbar" background-color="000000" />
  118.  
  119.  
  120.  
  121.  
  122.  
  123.  
  124. <div id="printArea">
  125. <link rel="stylesheet" type="text/css" href="invoice.css" />
  126. <div style="page-break-after: always;">
  127. <h1>
  128. Invoice</h1>
  129. <div class="div1">
  130. <table width="100%">
  131. <tr>
  132. <td>
  133.  
  134. <span class="editable">Room31 Wholesale</span>
  135. <br />
  136. <span class="editable">Unit D2,</span>
  137. <br />
  138. <span class="editable">Taylor Business Park</span>
  139. <br />
  140. <span class="editable">Risley</span>
  141. <br />
  142. <span class="editable">Warrington</span>
  143. <br />
  144. <span class="editable">Cheshire</span>
  145. <br />
  146. <span class="editable">WA3 6BL</span>
  147. <br />
  148.  
  149. <!-- EU-VAT - TAG -->
  150. <span class="editable">VAT Number: GB106004279</span>
  151. <br />
  152. <!-- END EU-VAT - TAG -->
  153. <span class="editable">Telephone 01925766340</span>
  154. <br />
  155. <span class="editable">[email protected]</span>
  156. <br />
  157. <span class="editable">http://www.room31wholesale.co.uk</span>
  158. </td>
  159.  
  160. <td align="right" valign="top"><table>
  161. <tr>
  162. <td><b>Order Date:</b></td>
  163. <td><span class="editable">21/12/2011</span></td>
  164. </tr>
  165. <tr>
  166. <td><b>Invoice No.:</b></td>
  167. <td><span class="editable">RWH20607</span></td>
  168. </tr>
  169. <tr>
  170. <td><b>Order ID:</b></td>
  171. <td><span class="editable"><?php echo $row['order_id']; ?></span></td>
  172. </tr>
  173. </table></td>
  174. </tr>
  175. </table>
  176. </div>
  177.  
  178. <table class="address">
  179. <tr class="heading">
  180. <td width="50%"><b>To</b></td>
  181. <td width="50%"><b>Ship To (if different address)</b></td>
  182. </tr>
  183. <tr>
  184. <td>
  185. <span class="editable"><?php echo $row['payment_firstname']; ?> <?php echo $row['payment_lastname']; ?></span>
  186. <br />
  187. <span class="editable"><?php echo $row['payment_company']; ?></span>
  188. <br />
  189. <span class="editable"><?php echo $row['payment_address_1']; ?></span>
  190. <br />
  191. <span class="editable"><?php echo $row['payment_address_2']; ?></span>
  192. <br />
  193. <span class="editable"><?php echo $row['payment_city']; ?></span>
  194. <br />
  195. <span class="editable"><?php echo $row['payment_postcode']; ?></span>
  196. <br />
  197. <span class="editable"><?php echo $row['payment_zone']; ?></span>
  198. <br />
  199. <span class="editable"><?php echo $row['payment_country']; ?></span>
  200. <!-- EU-VAT - TAG -->
  201. <br/>
  202. <!-- END EU-VAT - TAG -->
  203. <span class="editable"><?php echo $row['email']; ?></span>
  204. <br/>
  205. <span class="editable"><?php echo $row['telephone']; ?></span></td>
  206. <td valign="top">
  207. <span class="editable"><?php echo $row['shipping_firstname']; ?> <?php echo $row['shipping_lastname']; ?></span>
  208. <br />
  209. <span class="editable"><?php echo $row['shipping_company']; ?></span>
  210. <br />
  211. <span class="editable"><?php echo $row['shipping_address_1']; ?></span>
  212. <br />
  213. <span class="editable"><?php echo $row['shipping_address_2']; ?></span>
  214. <br />
  215. <span class="editable"><?php echo $row['shipping_city']; ?></span>
  216. <br />
  217. <span class="editable"><?php echo $row['shipping_postcode']; ?></span>
  218. <br />
  219. <span class="editable"><?php echo $row['shipping_zone']; ?></span>
  220. <br />
  221. <span class="editable"><?php echo $row['shipping_country']; ?></span>
  222. </tr>
  223. </table>
  224. <table class="product" id="products">
  225. <tr class="heading">
  226. <td><b>Product</b></td>
  227. <td><b>Model</b></td>
  228. <td align="right"><b>Quantity</b></td>
  229. <td align="right"><b>Unit Price</b></td>
  230. <td align="right"><b>Total</b></td>
  231. </tr>
  232. <tr>
  233. <td>
  234. <span class="editable"><span class="editable"><?php echo $row['name']; ?></span></span>
  235. <br />
  236. <span class="editable"><small><?php echo $row['option_name']; ?> - <?php echo $row['option_value']; ?></small></span>
  237. </td>
  238. <td><span class="editable"><?php echo $row['model']; ?></span></td>
  239. <td align="right"><span class="editable"><?php echo $row['quantity']; ?></span></td>
  240. <td align="right"><span class="editable"><?php echo $row['price']; ?></span></td>
  241. <td align="right"><span class="editable"><?php echo $row['total']; ?></span></td>
  242. </tr>
  243.  
  244.  
  245. <?php $result2 = mysql_query('
  246. SELECT `order_total` . *, `order_total`.`title` as order_title
  247. FROM `order_total`
  248. WHERE `order_total`.`order_id` = "1"
  249. ')
  250. or die(mysql_error());
  251.  
  252. // store the record of the "example" table into $row
  253. $row = mysql_fetch_array( $result2 );
  254. // Print out the contents of the entry
  255.  
  256. ?>
  257.  
  258. <?php
  259. for($i = $row; $i < 4; $i++) {
  260. echo $row['order_title'];
  261. }
  262.  
  263. ?>
  264.  
  265. <tr>
  266. <td align="right" colspan="4"><b><?php echo $row['order_title'];?></span></b></td>
  267. <td align="right"><span class="editable"><?php echo $row['value']; ?></span></td>
  268. </tr>
  269. <tr>
  270. <td align="right" colspan="4"><b><?php echo $row['order_title']; ?></b></td>
  271. <td align="right"><span class="editable"><?php echo $row['value']; ?></span></td>
  272. </tr>
  273. <tr>
  274. <td align="right" colspan="4"><b><?php echo $row['order_title']; ?></b></td>
  275. <td align="right"><span class="editable"><?php echo $row['value']; ?></span></td>
  276. </tr>
  277. <tr>
  278. <td align="right" colspan="4"><b><?php echo $row['order_title']; ?></b></td>
  279. <td align="right"><span class="editable"><?php echo $row['value']; ?></span></td>
  280. </tr>
  281. </table>
  282. <table class="product">
  283. <tr class="heading">
  284. <td><b>Comment</b></td>
  285. </tr>
  286. <tr>
  287. <td></td>
  288. </tr>
  289. </table>
  290. </div>
  291.  
  292. </div>
  293.  
  294. <p>&nbsp;</p>
  295. <p>&nbsp;</p>
  296. </body>
  297. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!