Webwereld

[PHP] mysql_fetch_assoc

Gestart doorJesper3 reacties32 weergaven
Log in om mee te praten

4 berichten · pagina 1 van 1

Jesper

Lid · Topicstarter

Berichten
3.532
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Heey,
Ik downloadde een script die ik wel kon gebruiken,
toen kreeg ik deze error:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:xampphtdocsapp plclass.forms.php on line 86

Code:

[COLOR= #0000BB]<?php[/COLOR]

namespace Revolution[COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/defined"]defined[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]IN_INDEX[/COLOR][COLOR= #007700])) {[/COLOR] [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]Sorry, you cannot access this file.[/COLOR][COLOR= #007700]); }[/COLOR]
[URL="http://www.php.net/class"]class[/URL] forms implements iForms
[COLOR= #007700]{[/COLOR]

    [URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$error[/COLOR][COLOR= #007700];[/COLOR]

    final [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] setData[COLOR= #007700]()
    {[/COLOR]
        [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$engine[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$key[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]$value[/COLOR][COLOR= #007700])
        {[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$value[/COLOR] [COLOR= #007700]!=[/COLOR] null[COLOR= #007700])
            {[/COLOR]
                [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR][COLOR= #0000BB]$key[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$engine[/COLOR][COLOR= #007700]->[/COLOR]secure[COLOR= #007700]([/COLOR][COLOR= #0000BB]$value[/COLOR][COLOR= #007700]);
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL]
            [COLOR= #007700]{[/COLOR]
                [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]error [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]Please fill in all fields[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/return"]return[/URL][COLOR= #007700];
            }
        }
    
    }[/COLOR]
    
    final [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] unsetData[COLOR= #007700]()
    {[/COLOR]
        [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$this[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$key[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]$value[/COLOR][COLOR= #007700])
        {[/COLOR]
            [URL="http://www.php.net/unset"]unset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR][COLOR= #0000BB]$key[/COLOR][COLOR= #007700]);    
        }    
    }[/COLOR]
    
    final [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] writeData[COLOR= #007700]([/COLOR][COLOR= #0000BB]$key[/COLOR][COLOR= #007700])
    {[/COLOR]
        [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR][COLOR= #0000BB]$key[/COLOR][COLOR= #007700];
    }[/COLOR]
    
    final [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] outputError[COLOR= #007700]()
    {[/COLOR]
        [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]error[COLOR= #007700]))
        {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<div id=message> "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]error [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" </div>"[/COLOR][COLOR= #007700];
        }
    }[/COLOR]
    
    [COLOR= #FF8000]/* Manage different pages */[/COLOR]
    
    final [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] getPageNews[COLOR= #007700]()
    {[/COLOR]
        [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$engine[/COLOR][COLOR= #007700];[/COLOR]
        
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]) || ![/COLOR][URL="http://www.php.net/is_numeric"]is_numeric[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]))
            {[/COLOR]
                [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];
            }[/COLOR]
                [COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT title, id FROM cms_news WHERE id != "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$engine[/COLOR][COLOR= #007700]->[/COLOR]secure[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]" ORDER BY id DESC"[/COLOR][COLOR= #007700]);[/COLOR]
                
                [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$news1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700]))
                {[/COLOR]
                    [COLOR= #0000BB]$template[/COLOR][COLOR= #007700]->[/COLOR]setParams[COLOR= #007700]([/COLOR][COLOR= #DD0000]newsList[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]&laquo; <a href="index.php?url=news&id=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$news1[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"id"[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$news1[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]title[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]</a><br/>[/COLOR][COLOR= #007700]);
                }[/COLOR]
                
                [COLOR= #0000BB]$news[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$engine[/COLOR][COLOR= #007700]->[/COLOR]fetch_assoc[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT title, longstory, author, published FROM cms_news WHERE id = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$engine[/COLOR][COLOR= #007700]->[/COLOR]secure[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]" LIMIT 1"[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #0000BB]$template[/COLOR][COLOR= #007700]->[/COLOR]setParams[COLOR= #007700]([/COLOR][COLOR= #DD0000]newsTitle[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$news[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]title[/COLOR][COLOR= #007700]]);[/COLOR]
                [COLOR= #0000BB]$template[/COLOR][COLOR= #007700]->[/COLOR]setParams[COLOR= #007700]([/COLOR][COLOR= #DD0000]newsContent[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$news[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]longstory[/COLOR][COLOR= #007700]]);[/COLOR]
                [COLOR= #0000BB]$template[/COLOR][COLOR= #007700]->[/COLOR]setParams[COLOR= #007700]([/COLOR][COLOR= #DD0000]newsAuthor[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$news[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]author[/COLOR][COLOR= #007700]]);[/COLOR]
                [COLOR= #0000BB]$template[/COLOR][COLOR= #007700]->[/COLOR]setParams[COLOR= #007700]([/COLOR][COLOR= #DD0000]newsDate[/COLOR][COLOR= #007700],[/COLOR] [URL="http://www.php.net/date"]date[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"d-m-y"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$news[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]published[/COLOR][COLOR= #007700]]));[/COLOR]
            
                [URL="http://www.php.net/unset"]unset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/unset"]unset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$news1[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/unset"]unset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$news[/COLOR][COLOR= #007700]);
    }[/COLOR]
    
    final [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] getPageHome[COLOR= #007700]()
    {[/COLOR]
        [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$engine[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$a[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$data[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT title, id, published, shortstory, image FROM cms_news ORDER BY id DESC LIMIT 5"[/COLOR][COLOR= #007700]);[/COLOR]
                
        [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$news[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700],[/COLOR] MYSQL_ASSOC[COLOR= #007700]))
           {[/COLOR]
            [COLOR= #0000BB]$template[/COLOR][COLOR= #007700]->[/COLOR]setParams[COLOR= #007700]([/COLOR][COLOR= #DD0000]newsTitle-[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$news[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]title[/COLOR][COLOR= #007700]]);[/COLOR]
            [COLOR= #0000BB]$template[/COLOR][COLOR= #007700]->[/COLOR]setParams[COLOR= #007700]([/COLOR][COLOR= #DD0000]newsID-[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$news[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]);[/COLOR]
            [COLOR= #0000BB]$template[/COLOR][COLOR= #007700]->[/COLOR]setParams[COLOR= #007700]([/COLOR][COLOR= #DD0000]newsDate-[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [URL="http://www.php.net/date"]date[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"d-m-y"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$news[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]published[/COLOR][COLOR= #007700]]));[/COLOR]
            [COLOR= #0000BB]$template[/COLOR][COLOR= #007700]->[/COLOR]setParams[COLOR= #007700]([/COLOR][COLOR= #DD0000]newsCaption-[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$news[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]shortstory[/COLOR][COLOR= #007700]]);[/COLOR]
            [COLOR= #0000BB]$template[/COLOR][COLOR= #007700]->[/COLOR]setParams[COLOR= #007700]([/COLOR][COLOR= #DD0000]newsIMG-[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$news[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]image[/COLOR][COLOR= #007700]]);[/COLOR]
            [COLOR= #0000BB]$a[/COLOR][COLOR= #007700]++;
        }[/COLOR]
        
        [URL="http://www.php.net/unset"]unset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$news[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/unset"]unset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700]);
    }
    
}[/COLOR]

?>
0
Antonn

Lid

Berichten
8.649
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Verander regel 86 eens van dit:

while($news = mysql_fetch_array($data, MYSQL_ASSOC))


naar dit?

while($news = mysql_fetch_array($data))


??

Ik krijg trouwens nog punten van je!
0
Sjoerd

Lid

Berichten
13.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Heb je de goede tabellen wel in je MySQL database staan?
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren