Guest User

Untitled

a guest
Mar 23rd, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.43 KB | None | 0 0
  1. function get_cat_options($parentID, $db) {
  2. $query = 'SELECT * FROM `cat` WHERE `parent` = '. intval($parentID) .';';
  3. $res = mysqli_query($db, $query);
  4. ob_start();
  5. if (mysqli_num_rows($res) > 0) {?>
  6. <select class="row-item-2 subcat">
  7. <option value=""><?= 'Категория'?></option>
  8. <? while ($row = mysqli_fetch_object($res)) {?>
  9. <option value="<? echo $row->id; ?>"><? echo $row->name; ?></option>
  10. <?}?>
  11. </select>
  12. <?} else {?>
  13. <span class="subcat" style="color:green">OK!</span>
  14. <?}
  15. return ob_get_clean();
  16. }
  17.  
  18. function get_last_cat($parentID, $db) {
  19. $query = 'SELECT * FROM `cat` WHERE `parent` = '. intval($parentID) .';';
  20. $res = mysqli_query($db, $query);
  21. ob_start();
  22. $rows = mysqli_num_rows($res);
  23. $i = 0;
  24. if ($rows > 0) {?>
  25. <select class="row-item-2 subcat">
  26. <option value=""><?= 'Категория'?></option>
  27. <? while ($row = mysqli_fetch_object($res)) {?>
  28. <option value="<? echo $row->id; ?>" <? echo $rows == ++$i ? 'selected' : ''; ?>><? echo $row->name; ?></option>
  29. <?}?>
  30. </select>
  31. <?} else {?>
  32. <span class="subcat" style="color:green">OK!</span>
  33. <?}
  34. return ob_get_clean();
  35. }
  36.  
  37. function get_last_cat($parentID, $db) {
  38. $query = 'SELECT * FROM `cat` WHERE `parent` = '. intval($parentID) .' order by id desc limit 1;';
  39. $res = mysqli_query($db, $query);
  40. $lastCat = mysqli_fetch_object($res);
  41. return $lastCat;
  42. }
Add Comment
Please, Sign In to add comment