Webwereld

Data van database samenvoegen

Gestart doorBartv2 reacties51 weergaven
Log in om mee te praten

3 berichten · pagina 1 van 1

Bartv

Lid · Topicstarter

Berichten
4.451
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hallo,

Ik ben bezig met een website en push notificaties.
Nu wil ik als er meerdere resultaten zijn, dingen gaan samenvoegen, anders werken de push notificaties niet goed of krijg je misschien 5 push notificaties tegelijk.

Hoe doe ik dit?
0
Eleky

Lid

Berichten
3.788
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Controleren of een notificatie al bestaat, zo ja zet je er meerdere in 1 row
0
Bartv

Lid · Topicstarter

Berichten
4.451
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ik heb dit:

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]../inc/func.php[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM medicijnen WHERE actief = 1"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]) >[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
{[/COLOR]
    [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]))
    {[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]tijd[/COLOR][COLOR= #007700]] ==[/COLOR] [URL="http://www.php.net/date"]date[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"H:i"[/COLOR][COLOR= #007700]))
        {[/COLOR]
            [COLOR= #0000BB]$uQ[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE id = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]vId[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
            [COLOR= #0000BB]$uF[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQ[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$checkP[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM medicijnen WHERE actief = 1 AND vId = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$uF[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
            [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$checkF[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$checkP[/COLOR][COLOR= #007700]))
            {[/COLOR]
                [COLOR= #0000BB]$newD[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/date"]date[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"H:i"[/COLOR][COLOR= #007700],[/COLOR] [URL="http://www.php.net/strtotime"]strtotime[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]+[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]OmUur[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000] hour[/COLOR][COLOR= #007700]));[/COLOR]
                [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE medicijnen SET tijd = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$newD[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]" WHERE id = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uF[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]vPush[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]1[/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$uF[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]devicetoken[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700])
                {[/COLOR]
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hoevM[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]6[/COLOR][COLOR= #007700])
                    {[/COLOR]
                        [COLOR= #0000BB]$alertT[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]U moet uw [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mednaam[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000] innemen. Medicijn soort: [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]soortM[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]. Groeten, Mediklok.[/COLOR][COLOR= #007700];
                    }[/COLOR]
                    [URL="http://www.php.net/else"]else[/URL]
                    [COLOR= #007700]{[/COLOR]
                        [COLOR= #0000BB]$alertT[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]U moet [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hoevM[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]x uw [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mednaam[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000] innemen. Medicijn soort: [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]soortM[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]. Groeten, Mediklok.[/COLOR][COLOR= #007700];
                    }[/COLOR]
                    [COLOR= #0000BB]$payload[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aps[/COLOR][COLOR= #007700]] =[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]alert[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]$alertT[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]badge[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #DD0000]1[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]sound[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #DD0000]default[/COLOR][COLOR= #007700]);[/COLOR]
                    [COLOR= #0000BB]$payload[/COLOR] [COLOR= #007700]=[/COLOR] json_encode[COLOR= #007700]([/COLOR][COLOR= #0000BB]$payload[/COLOR][COLOR= #007700]);[/COLOR]
        
                    [COLOR= #0000BB]$apnsHost[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]gateway.sandbox.push.apple.com[/COLOR][COLOR= #007700];[/COLOR]
                    [COLOR= #0000BB]$apnsPort[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]2195[/COLOR][COLOR= #007700];[/COLOR]
                    [COLOR= #0000BB]$apnsCert[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]cert.pem[/COLOR][COLOR= #007700];[/COLOR]
    
                    [COLOR= #0000BB]$streamContext[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/stream_context_create"]stream_context_create[/URL][COLOR= #007700]();[/COLOR]
                    [URL="http://www.php.net/stream_context_set_option"]stream_context_set_option[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$streamContext[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]ssl[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]local_cert[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$apnsCert[/COLOR][COLOR= #007700]);[/COLOR]
                
                    [COLOR= #0000BB]$apns[/COLOR] [COLOR= #007700]=[/COLOR] stream_socket_client[COLOR= #007700]([/COLOR][COLOR= #DD0000]ssl://[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$apnsHost[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]:[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$apnsPort[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$error[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$errorString[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700],[/COLOR] STREAM_CLIENT_CONNECT[COLOR= #007700],[/COLOR] [COLOR= #0000BB]$streamContext[/COLOR][COLOR= #007700]);[/COLOR]
                    [COLOR= #0000BB]$apnsMessage[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/chr"]chr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]) .[/COLOR] [URL="http://www.php.net/chr"]chr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]) .[/COLOR] [URL="http://www.php.net/chr"]chr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]32[/COLOR][COLOR= #007700]) .[/COLOR] [URL="http://www.php.net/pack"]pack[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]H*[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$uF[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]devicetoken[/COLOR][COLOR= #007700]]) .[/COLOR] [URL="http://www.php.net/chr"]chr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]) .[/COLOR] [URL="http://www.php.net/chr"]chr[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/strlen"]strlen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$payload[/COLOR][COLOR= #007700])) .[/COLOR] [COLOR= #0000BB]$payload[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/fwrite"]fwrite[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$apns[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$apnsMessage[/COLOR][COLOR= #007700]);
    
                    @[/COLOR][URL="http://www.php.net/socket_close"]socket_close[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$apns[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/fclose"]fclose[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$apns[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Push bericht verstuurd aan id [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$uF[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];
                }
                
            }
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL]
        [COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Nu nog geen tijd.[/COLOR][COLOR= #007700];
        }
    }
}[/COLOR]
[URL="http://www.php.net/else"]else[/URL]
[COLOR= #007700]{[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Niks gevonden.[/COLOR][COLOR= #007700];
}[/COLOR]
?>


Ik moet nu 1x verbinden met de push notificatie server van apple, en dan alle notificaties versturen en dan pas sluiten, alleen hoe doe ik dit?
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