Webwereld

Radio Aanvraag script?

Gestart doorKlaasie8 reacties44 weergaven
Log in om mee te praten

9 berichten · pagina 1 van 1

Klaasie

Lid · Topicstarter

Berichten
5.498
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ik zoek een aanvraag script voor mijn radio site.
Kan iemand een link geven waar ik dit kan downloaden.
Of kan iemand dit voor mij maken?
0
Danderend

Lid

Berichten
474
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
gwn een contact formuliertje!
0
Klaasie

Lid · Topicstarter

Berichten
5.498
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Danderend schreef:
gwn een contact formuliertje!
Kan jij dat voor me maken?
0
Wouterr

Lid

Berichten
5.274
Reputatie
1
Punten
0,01
Lid sinds
Laatst gezien

Eindhoven, Nederland

Inset into ...
Select from ...
Formpje erbij klaar smile
0
Klaasie

Lid · Topicstarter

Berichten
5.498
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Snabbotube schreef:
Inset into ...
Select from ...
Formpje erbij klaar smile
Ik ben niet zo handig bloos
0
Lamos

Lid

Berichten
79
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
ik heb eventueel een dj paneel te koop. Dit verkoop ik alleen niet voor punten op one2xs.
0
Justafool

Lid

Berichten
515
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
request.php

[COLOR= #0000BB]<?php
$server[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$gebruiker[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$wachtwoord[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$db[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]

[COLOR= #0000BB]$connectie[/COLOR] [COLOR= #007700]= @[/COLOR][URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$server[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$gebruiker[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$wachtwoord[/COLOR][COLOR= #007700]);[/COLOR]

[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$connectie[/COLOR][COLOR= #007700]) {[/COLOR]
    [URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$db[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$connectie[/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]Er is iets fout gegaan met de verbinding met de database dit word zo snel mogelijk verholpen[/COLOR][COLOR= #007700];
}[/COLOR]


[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REQUEST_METHOD[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]POST[/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]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]request[/COLOR][COLOR= #007700]])) {[/COLOR]
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]])) {[/COLOR]
            [COLOR= #0000BB]$name[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]);[/COLOR]
            
            [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO `requests` (name, tijd) VALUES ($name, NOW())"[/COLOR][COLOR= #007700]);[/COLOR]
            
            [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]) {[/COLOR]
                [COLOR= #0000BB]$melding[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]aanvraag succesvol ingevoerd[/COLOR][COLOR= #007700];
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
                [COLOR= #0000BB]$melding[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]Er is iets mis gegaan neem contact op met de webmaster[/COLOR][COLOR= #007700];
            }
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$melding[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]Er is geen naam ingevuld![/COLOR][COLOR= #007700];
        }
    }
}[/COLOR]
?>
<html>
    <head>
        <title>Request a song!</title>
    </head>
    <body>
        <form action="request.php" method="post">
            <table>
                [COLOR= #0000BB]<?php[/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]$melding[/COLOR][COLOR= #007700])) {[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
                <tr>
                    <td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$melding[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</td>
                </tr>
                    [/COLOR][COLOR= #007700];
                }[/COLOR]
                ?>
                <tr>
                    <td>Naam van nummer:</td>
                    <td><input type="text" name="name" /></td>
                    <td><input type="submit" value="Request" name="request" /></td>
                    <td>
                </tr>
            </table>
        </form>
    </body>
</html>


request_list.php

[COLOR= #0000BB]<?php
$server[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$gebruiker[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$wachtwoord[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$db[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]

[COLOR= #0000BB]$connectie[/COLOR] [COLOR= #007700]= @[/COLOR][URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$server[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$gebruiker[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$wachtwoord[/COLOR][COLOR= #007700]);[/COLOR]

[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$connectie[/COLOR][COLOR= #007700]) {[/COLOR]
    [URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$db[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$connectie[/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]Er is iets fout gegaan met de verbinding met de database dit word zo snel mogelijk verholpen[/COLOR][COLOR= #007700];
}[/COLOR]

[COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM `requests` ORDER BY `tijd` DESC"[/COLOR][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]$sql[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]1[/COLOR] [COLOR= #007700]) {[/COLOR]
    
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Geen aanvragen gevonden[/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]
        <table width="30%">
            <tr>
                <td><b>Naam</b></td>
                <td><b>Tijd/datum</b></td>
            </tr>
    [/COLOR][COLOR= #007700];[/COLOR]
    
    [URL="http://www.php.net/while"]while[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$qres[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700])) {[/COLOR]
        [COLOR= #0000BB]$name[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$qres[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]];[/COLOR]
        [COLOR= #0000BB]$datetime[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/explode"]explode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000] [/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$qres[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]tijd[/COLOR][COLOR= #007700]]);[/COLOR]
        [COLOR= #0000BB]$date[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/explode"]explode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]-[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$datetime[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]]);[/COLOR]
        [COLOR= #0000BB]$date[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$date[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]-[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$date[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]-[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$date[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]];[/COLOR]
        [COLOR= #0000BB]$tijd[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$datetime[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
            <tr>
                <td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</td>
                <td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$date[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$tijd[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]</td>
            </tr>
        [/COLOR][COLOR= #007700];
    }[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
        </table>
    [/COLOR][COLOR= #007700];
}[/COLOR]
?>


database structuur

CREATE TABLE IF NOT EXISTS `requests` (
  `ID` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `tijd` datetime NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


Ff snel in elkaar geflanst..
0
One2xs

Bot

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
Contact formulier is súper simpel! confused emo
0
Klaasie

Lid · Topicstarter

Berichten
5.498
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
@Justafool, Dankje
Kan je ook een functie maken dat je je naam moet invoeren?
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