Witaj Gościu! ( Zaloguj | Rejestruj )

Forum PHP.pl

> [php] [mysql] Pobieranie kolumny z mysql i zapisanie każdej wartości w odrębnej zmiennej
Detro
post
Post #1





Grupa: Zarejestrowani
Postów: 9
Pomógł: 0
Dołączył: 24.02.2015

Ostrzeżenie: (0%)
-----


Witam wszystkich forumowiczów.

Mój kod PHP wygląda następująco:
  1. <?php
  2.  
  3. include 'connect.php';
  4.  
  5.  
  6. if($formula == ''){
  7. $query = "SELECT * FROM products WHERE ink = '$ink' AND width = $width AND length = $length";
  8. if($ink == '') {
  9. $query = "SELECT * FROM products WHERE width = $width AND length = $length";
  10. if($width == 0){
  11. $query = "SELECT * FROM products WHERE length = $length";
  12. }
  13. }
  14. if($width == 0){
  15. $query = "SELECT * FROM products WHERE ink = '$ink' AND length = $length";
  16. }
  17. if($length == 0){
  18. $query = "SELECT * FROM products WHERE ink = '$ink' AND width = $width";
  19. }
  20. }
  21.  
  22. elseif($ink == ''){
  23. $query = "SELECT * FROM products WHERE formula = '$formula' AND width = $width AND length = $length";
  24. if($formula == ''){
  25. $query = "SELECT * FROM products WHERE width = $width AND length = $length";
  26. }
  27. if($width == 0){
  28. $query = "SELECT * FROM products WHERE formula = '$formula' AND length = $length";
  29. }
  30. if($length == 0){
  31. $query = "SELECT * FROM products WHERE formula = '$formula' AND width = $width";
  32. }
  33. }
  34.  
  35. elseif($width == 0){
  36. $query = "SELECT * FROM products WHERE formula = '$formula' AND ink = '$ink' AND length = $length";
  37. if($length == 0){
  38. $query = "SELECT * FROM products WHERE formula = '$formula' AND ink = '$ink'";
  39. }
  40. }
  41.  
  42. elseif($length == 0){
  43. $query = "SELECT * FROM products WHERE formula = '$formula' AND ink = '$ink' AND width = $width";
  44. }
  45.  
  46. else{
  47. $query = "SELECT * FROM products WHERE formula = '$formula' AND ink = '$ink' AND width = $width AND length = $length";
  48. }
  49.  
  50.  
  51. $result = mysql_query($query) or die ("0");
  52. if (!mysql_num_rows($result)) die("0");
  53.  
  54. while($row = mysql_fetch_array($result))
  55. {
  56. echo "{$row['symbol']} ";
  57. }
  58.  
  59. ?>


Otrzymuję taki wynik:
  1. B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B121 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B128 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120 B120R B120R B112 B112 B112 B112 B112 B112 B112 B112 B112 B112 B112 B112 B112 B112 B112 B112 B112 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110 P110W P110W P110W P110W P110W


Potrzebuję zaimportować każdą powyższą wartość jako osobna zmienną (opcja jest dowolna). Chcę się odwołać do każdej z tych wartości finalnie funkcją "GET" w C#.

Bardzo proszę o pomoc.
Go to the top of the page
+Quote Post

Posty w temacie


Reply to this topicStart new topic
2 Użytkowników czyta ten temat (2 Gości i 0 Anonimowych użytkowników)
0 Zarejestrowanych:

 



RSS Aktualny czas: 12.03.2026 - 16:38