API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 10th, 2016
70
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.39 KB | None | 0 0
raw download clone embed print report
  1. `
  2. <?php
  3.  
  4. //Getting variables
  5. $sgender=$_GET['gender'];
  6. $sdutycategory=$_GET['dutycategory'];
  7. $ssubcategory=$_GET['subcategory'];
  8.  
  9.  
  10. include("topp.inc");
  11. // include("chapmenu.inc");
  12. ?>
  13. <?php
  14.  
  15.  
  16. print(" $sgender");print(" $sdutycategory");print(" $ssubcategory");
  17.  
  18. // Connetction details
  19. $hostname = "localhost";
  20. $username = "Myname";
  21. $password = "myPass";
  22. $userstable = "varer";
  23. $dbName = "taric";
  24.  
  25. $result;
  26.  
  27. error_reporting (E_ALL ^ E_NOTICE );
  28. //Connecting to database
  29. ($GLOBALS["___mysqli_ston"] = mysqli_connect($hostname, $username, $password))
  30. || die(((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false)));
  31. @((bool)mysqli_query($GLOBALS["___mysqli_ston"], "USE $dbName"))
  32. || die("Unable to select database");
  33.  
  34. // Setting up the query
  35. $sql_result=mysqli_query($GLOBALS["___mysqli_ston"], "SELECT * FROM `varer`
  36. WHERE 1
  37. AND `id` LIKE '%'
  38. AND `gender` = ".$sgender."
  39. AND `dutycategory` LIKE '%'
  40. AND `category` LIKE '%'
  41. AND `subcategory`LIKE 'BAG'
  42. AND `taxgroup` LIKE '%'
  43. AND `styleno` LIKE '%'
  44. AND `picture` LIKE '%'
  45. AND `stylename` LIKE '%'
  46. AND `comment` LIKE '%'
  47. AND `sizegroup` LIKE '%'
  48. AND `composition` LIKE '%'
  49. AND `netwt` LIKE '%'
  50. AND `co` LIKE '%'
  51. AND `ustaric` LIKE '%'
  52. AND `ustaricmain` LIKE '%'
  53. AND `ustaricsub1` LIKE '%'
  54. AND `ustaricsub2` LIKE '%'
  55. AND `ustaricdots` LIKE '%'
  56. AND `cataric` LIKE '%'
  57. AND `cataricmain` LIKE '%'
  58. AND `cataricsub1` LIKE '%'
  59. AND `cataricsub2` LIKE '%'
  60. AND `cataricdots` LIKE '%'
  61. AND `eutaric` LIKE '%'
  62. AND `eutaricmain` LIKE '%'
  63. AND `eutaricsub1` LIKE '%'
  64. AND `eutaricsub2` LIKE '%'
  65. AND `eutaricdots` LIKE '%'
  66.  
  67. ORDER BY `id`");
  68.  
  69.  
  70.  
  71. //Declare the loop to run as long as there is posts found
  72. $num_links=mysqli_num_rows($sql_result);
  73.  
  74.  
  75.  
  76.  
  77.  
  78.  
  79.  
  80.  
  81.  
  82. //Printer Headernames
  83. print("<table border="0" bgcolor="#FFFFFF" align="center">");
  84. print("<tr>");
  85. print("<td>");
  86. //declare varaible to change line colors
  87. $teller=0;
  88. print("<table border="0" align="center">");
  89. print("<tr>");
  90. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Id<br></strong></font></div></td>");
  91. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Gender<br></strong></font></div></td>");
  92. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Duty<br> category</strong></font></div></td>");
  93. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Category<br></strong></font></div></td>");
  94. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Sub<br>category</strong></font></div></td>");
  95. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Tax<br>group</strong></font></div></td>");
  96. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Style<br>Number</strong></font></div></td>");
  97. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Picture<br></strong></font></div></td>");
  98. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Stylename<br></strong></font></div></td>");
  99. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Comment<br></strong></font></div></td>");
  100. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Composition<br></strong></font></div></td>");
  101. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Co<br></strong></font></div></td>");
  102. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>UStaric<br>Dots</strong></font></div></td>");
  103. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>CAtaric<br>Dots</strong></font></div></td>");
  104. print("<td bgcolor="#BDBDBD"><div align="center"><font color="white" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>EUtaric<br>Dots</strong></font></div></td>");
  105. print("</tr>");
  106. print("<font face="Verdana, Arial, Helvetica, sans-serif"size="2">");
  107. print("<tr>");
  108.  
  109.  
  110. // resultarray variables
  111. for ($i=0; $i<$num_links; $i++){$myrow=mysqli_fetch_array($sql_result);
  112. $id=$myrow["id"];
  113. $gender=$myrow["gender"];
  114. $dutycategory=$myrow["dutycategory"];
  115. $category=$myrow["category"];
  116. $subcategory=$myrow["subcategory"];
  117. $taxgroup=$myrow["taxgroup"];
  118. $styleno=$myrow["styleno"];
  119. $picture=$myrow["picture"];
  120. $stylename=$myrow["stylename"];
  121. $comment=$myrow["comment"];
  122. $sizegroup=$myrow["sizegroup"];
  123. $composition=$myrow["composition"];
  124. $netwt=$myrow["netwt"];
  125. $co=$myrow["co"];
  126. $ustaric=$myrow["ustaric"];
  127. $ustaricmain=$myrow["ustaricmain"];
  128. $ustaricsub1=$myrow["ustaricsub1"];
  129. $ustaricsub2=$myrow["ustaricsub2"];
  130. $ustaricdots=$myrow["ustaricdots"];
  131. $cataric=$myrow["cataric"];
  132. $cataricmain=$myrow["cataricmain"];
  133. $cataricsub1=$myrow["cataricsub1"];
  134. $cataricsub2=$myrow["cataricsub2"];
  135. $cataricdots=$myrow["cataricdots"];
  136. $eutaric=$myrow["eutaric"];
  137. $eutaricmain=$myrow["eutaricmain"];
  138. $eutaricsub1=$myrow["eutaricsub1"];
  139. $eutaricsub2=$myrow["eutaricsub2"];
  140. $eutaricdots=$myrow["eutaricdots"];
  141.  
  142.  
  143.  
  144. //alternatic background colors for each line
  145. if($teller%2)
  146. {
  147. $bgcolor="#E5E5E5";
  148. }
  149. else
  150. {
  151. $bgcolor="#FFFFFF";
  152. }
  153.  
  154. PRINT "<tr bgcolor=$bgcolor>";
  155. $teller++;
  156. print("<TD>");
  157.  
  158. //Prints id
  159. print("<DIV ALIGN="CENTER">");
  160. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  161. print(" $id");
  162. print("</font>");
  163. print("</DIV>");
  164. print("</TD>");
  165. print("<TD>");
  166. //Prints gender
  167. print("<DIV ALIGN="LEFT">");
  168. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  169. print(" $gender");
  170. print("</font>");
  171. print("</DIV>");
  172. print("</TD>");
  173. print("<TD>");
  174. //Prints dutycategory
  175. print("<DIV ALIGN="LEFT">");
  176. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  177. print(" $dutycategory");
  178. print("</font>");
  179. print("</DIV>");
  180. print("</TD>");
  181. print("<TD>");
  182. //Prints category
  183. print("<DIV ALIGN="LEFT">");
  184. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  185. print(" $category");
  186. print("</font>");
  187. print("</DIV>");
  188. print("</TD>");
  189. print("<TD>");
  190. //Prints subcategory
  191. print("<DIV ALIGN="LEFT">");
  192. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  193. print(" $subcategory");
  194. print("</font>");
  195. print("</DIV>");
  196. print("</TD>");
  197. print("<TD>");
  198. //Prints taxgroup
  199. print("<DIV ALIGN="LEFT">");
  200. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  201. print(" $taxgroup");
  202. print("</font>");
  203. print("</DIV>");
  204. print("</TD>");
  205. print("<TD>");
  206. //Prints styleno
  207. print("<DIV ALIGN="LEFT">");
  208. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  209. print(" $styleno");
  210. print("</font>");
  211. print("</DIV>");
  212. print("</TD>");
  213. print("<TD>");
  214. //Prints picture
  215. print("<DIV ALIGN="LEFT">");
  216. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  217. print(" $picture");
  218. print("</font>");
  219. print("</DIV>");
  220. print("</TD>");
  221. print("<TD>");
  222. //Print stylename
  223. print("<DIV ALIGN="LEFT">");
  224. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  225. print(" $stylename");
  226. print("</font>");
  227. print("</DIV>");
  228. print("</TD>");
  229. print("<TD>");
  230. //Prints comment
  231. print("<DIV ALIGN="LEFT">");
  232. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  233. print(" $comment");
  234. print("</font>");
  235. print("</DIV>");
  236. print("</TD>");
  237. print("<TD>");
  238. //Prints composition
  239. print("<DIV ALIGN="LEFT">");
  240. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  241. print(" $composition");
  242. print("</font>");
  243. print("</DIV>");
  244. print("</TD>");
  245. print("<TD>");
  246. //skriver ut Co
  247. print("<DIV ALIGN="LEFT">");
  248. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  249. print(" $co");
  250. print("</font>");
  251. print("</DIV>");
  252. print("</TD>");
  253. print("<TD>");
  254. //skriver ut Ustaricdots
  255. print("<DIV ALIGN="LEFT">");
  256. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  257. print(" $ustaricdots");
  258. print("</font>");
  259. print("</DIV>");
  260. print("</TD>");
  261. print("<TD>");
  262. //skriver ut Cataricdots
  263. print("<DIV ALIGN="LEFT">");
  264. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  265. print(" $cataricdots");
  266. print("</font>");
  267. print("</DIV>");
  268. print("</TD>");
  269. print("<TD>");
  270. //skriver ut Eutaricdots
  271. print("<DIV ALIGN="LEFT">");
  272. print("<font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">");
  273. print(" $dutycategory");
  274. print("</font>");
  275. print("</DIV>");
  276. print("</TD>");
  277. print("<TD>");
  278. }
  279. print("</font>");
  280. print("</table>");
  281. print("<p align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Dette ");
  282. print("er slutten pƄ tabellen</font></p>");
  283. print("</td>");
  284. print("</tr>");
  285. print("</table>");
  286.  
  287.  
  288.  
  289.  
  290. // include("footer.inc");
  291. ?>
  292. </body>
  293. </html>`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!