Advertisement
szymcio93

sql name(age)...

Jun 9th, 2015
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. <form name = "zad" method = "POST">
  2. <select name = "wybor">
  3. <option value = "NAME">NAME</option>
  4. <option value = "AGE">AGE</option>
  5. <option value = "SALARY">SALARY</option>
  6. </select>
  7. <input type="submit" />
  8. </form>
  9.  
  10. <?php
  11. class MyDB extends SQLite3
  12. {
  13. function __construct()
  14. {
  15. $this->open('company.dat');
  16. }
  17. }
  18. $wybor = $_POST['wybor']; //kryterium sortowania wybrane w select
  19.  
  20. $db = new MyDB();//zakladam ze baza jest juz wypelniona danymi
  21.  
  22. $result = $db->query('SELECT * FROM COMPANY ORDER BY '.$wybor.';');
  23. while($row = $result->fetchArray()){
  24. echo $row['NAME']."(".$row['AGE']."),".$row['ADDRESS'].";".$row['SALARY']." $<br>";
  25. }
  26. $db->close();
  27.  
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement