Forum PHP.pl > pobranie wyniku na podstawie kolumny

Pomoc - Szukaj - Użytkownicy - Kalendarz

Pełna wersja: pobranie wyniku na podstawie kolumny

Forum PHP.pl > Forum > Bazy danych > MySQL

1992bartekk

30.07.2017, 17:27:41

[SQL] pobierz, plaintext 
Array ( [0] => stdClass Object ( [name] => _wpcf7_container_post [value] => 324 ) [1] => stdClass Object ( [name] => Imie [value] => Damian ) [2] => stdClass Object ( [name] => Nazwisko [value] => Kowalczyk ) [3] => stdClass Object ( [name] => telefon [value] => 343423232 ) [4] => stdClass Object ( [name] => email [value] => knkjnkn@wp.pl ) [5] => stdClass Object ( [name] => miasto [value] => sadasdsaddsa ) [6] => stdClass Object ( [name] => plec [value] => K ) [7] => stdClass Object ( [name] => rok [value] => 1990 ) [8] => stdClass Object ( [name] => klub [value] => ) [9] => stdClass Object ( [name] => Regulamin [value] => 1 ) [10] => stdClass Object ( [name] => submit_time [value] => 2017-07-30 15:39:25 ) [11] => stdClass Object ( [name] => submit_ip [value] => ::1 ) [12] => stdClass Object ( [name] => submit_user_id [value] => 0 ) ) Array ( [0] => stdClass Object ( [name] => _wpcf7_container_post [value] => 324 ) [1] => stdClass Object ( [name] => Imie [value] => hbhgvhgvhv ) [2] => stdClass Object ( [name] => Nazwisko [value] => vgvhvhh ) [3] => stdClass Object ( [name] => telefon [value] => 7656898 ) [4] => stdClass Object ( [name] => email [value] => 71772@w.pl ) [5] => stdClass Object ( [name] => miasto [value] => hhhghg ) [6] => stdClass Object ( [name] => plec [value] => K ) [7] => stdClass Object ( [name] => rok [value] => 1990 ) [8] => stdClass Object ( [name] => klub [value] => dasdasds ) [9] => stdClass Object ( [name] => Regulamin [value] => 1 ) [10] => stdClass Object ( [name] => submit_time [value] => 2017-07-30 15:40:10 ) [11] => stdClass Object ( [name] => submit_ip [value] => ::1 ) [12] => stdClass Object ( [name] => submit_user_id [value] => 0 ) ) Array ( [0] => stdClass Object ( [name] => _wpcf7_container_post [value] => 324 ) [1] => stdClass Object ( [name] => Imie [value] => jbjhbhv ) [2] => stdClass Object ( [name] => Nazwisko [value] => jhbhbhv ) [3] => stdClass Object ( [name] => telefon [value] => 6556 ) [4] => stdClass Object ( [name] => email [value] => bvhgvg@w.pl ) [5] => stdClass Object ( [name] => miasto [value] => bjkjb ) [6] => stdClass Object ( [name] => plec [value] => K ) [7] => stdClass Object ( [name] => rok [value] => 1990 ) [8] => stdClass Object ( [name] => klub [value] => ) [9] => stdClass Object ( [name] => Regulamin [value] => 1 ) [10] => stdClass Object ( [name] => submit_time [value] => 2017-07-30 15:43:45 ) [11] => stdClass Object ( [name] => submit_ip [value] => ::1 ) [12] => stdClass Object ( [name] => submit_user_id [value] => 0 ) ) Array ( [0] => stdClass Object ( [name] => _wpcf7_container_post [value] => 324 ) [1] => stdClass Object ( [name] => Imie [value] => jbhgvhvbj ) [2] => stdClass Object ( [name] => Nazwisko [value] => jjhvhgvh ) [3] => stdClass Object ( [name] => telefon [value] => 65577 ) [4] => stdClass Object ( [name] => email [value] => 1287@wp.pl ) [5] => stdClass Object ( [name] => miasto [value] => kjnjhg ) [6] => stdClass Object ( [name] => plec [value] => K ) [7] => stdClass Object ( [name] => rok [value] => 1990 ) [8] => stdClass Object ( [name] => klub [value] => jhbjb ) [9] => stdClass Object ( [name] => Regulamin [value] => 1 ) [10] => stdClass Object ( [name] => submit_time [value] => 2017-07-30 15:46:35 ) [11] => stdClass Object ( [name] => submit_ip [value] => ::1 ) [12] => stdClass Object ( [name] => submit_user_id [value] => 0 ) ) Array ( [0] => stdClass Object ( [name] => _wpcf7_container_post [value] => 324 ) [1] => stdClass Object ( [name] => Imie [value] => nhjbhjb ) [2] => stdClass Object ( [name] => Nazwisko [value] => hbhjbj ) [3] => stdClass Object ( [name] => telefon [value] => 7665 ) [4] => stdClass Object ( [name] => email [value] => jhbhjb@wp.pl ) [5] => stdClass Object ( [name] => miasto [value] => jhjbjh ) [6] => stdClass Object ( [name] => plec [value] => K ) [7] => stdClass Object ( [name] => login [value] => 1992bartekk ) [8] => stdClass Object ( [name] => rok [value] => 1990 ) [9] => stdClass Object ( [name] => klub [value] => ) [10] => stdClass Object ( [name] => Regulamin [value] => 1 ) [11] => stdClass Object ( [name] => submit_time [value] => 2017-07-30 16:59:30 ) [12] => stdClass Object ( [name] => submit_ip [value] => ::1 ) [13] => stdClass Object ( [name] => submit_user_id [value] => 0 ) )
[SQL] pobierz, plaintext

Moje pytanie jak wyjąć imię czy nazwisko jesli zapytanie odwołuje się do kolumny "data_id" . Odwołuje się dla tego kolumny data_id bo wcześniejsze zapytanie odwołuje się do konkretnego numeru kategorii.

viking

30.07.2017, 17:34:15

foreach (twojatablica as $x) {echo $x->name;}

1992bartekk

30.07.2017, 17:47:22

tak tak to wiem problem w tym że pobranie tabeli name nie stanowi problemu bo dostaję wynik przy zapytaniu:
echo $term2->name

imie, nazwisko

Poje pytanie jest jak pobrac
np.
imie => Kamil
nazwisko => Nowak

coś na zasadzie działania
echo $term2->name[imie]->value

viking

30.07.2017, 17:55:23

[1] => stdClass Object ( [name] => Imie [value] => Damian )
[2] => stdClass Object ( [name] => Nazwisko [value] => Kowalczyk )

Takie masz wartości pobrane w wyniku.

1992bartekk

30.07.2017, 17:59:29

no tak to osobne wiersze jednak data_id jest ta sama przy nich, nie wiem czy istnieje taka możliwość pobrania na podstawie wartości data_id i konkretnych wyników z tabeli name wartości zawartej w value... Tworzenie dodatkowej pętli jest bez sensu zwłaszcza ze muszę pobrać więcej niż 2 wyniki

viking

30.07.2017, 18:05:24

http://datainflow.com/group-array-key-value-php/
Aczkolwiek data_id to tutaj nie pobierasz

1992bartekk

30.07.2017, 18:19:37

kurde nie dogadaliśmy się

To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.