PHP mysql fatal error Call to a member function fetch_assoc()

Asked Mar 13 '16 at 02:53

Active Mar 13 '16 at 03:01

Viewed 20 times

$szukaj_slowo = 'SELECT * FROM slowa WHERE slowo='.$slowo.'';
$wyslij_zapytanie = $connect->query($szukaj_slowo);
$pobierz_wartosc = $wyslij_zapytanie->fetch_assoc();
$szukaj_slowo_wynik = $pobierz_wartosc['slowo'];
    $connect->close(); 
    if( $szukaj_slowo_wynik == NULL || $szukaj_slowo_wynik == "" )
    {
        Header('Location: index.php');
    }

I take $slowo from form, but if $slowo is empty then i got a fatal error

Fatal error: Call to a member function fetch_assoc() on boolean in C:\xampp\htdocs\error_spr\wyszukaj.php on line 16

asked Mar 13 '16 at 02:53

Vento

can you show what link is line 16? – The Beast Mar 13 '16 at 02:53
$pobierz_wartosc = $wyslij_zapytanie->fetch_assoc(); – Vento Mar 13 '16 at 02:54
you could use a while loop that would be better – The Beast Mar 13 '16 at 02:55
Can you give me example? – Vento Mar 13 '16 at 02:56
@Vento i have posted a answer look at it and try that exact code – The Beast Mar 13 '16 at 02:57
Ahh, the most asked PHP question ever. See the little white box at the top of the website? Use it. – Sverri M. Olsen Mar 13 '16 at 02:57
@SverriM.Olsen hahahaha :) – The Beast Mar 13 '16 at 02:57

PHP mysql fatal error Call to a member function fetch_assoc()

0 Answers0