Thread Frage zum Schreiben in die Datenbank
(24 answers)
Opened by Kuerbis at 2011-08-14 09:13
Ich habe eine javascriptfreie Lösung gefunden:
Code (perl): (dl
)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 use Mojolicious::Lite; use DBI qw(:sql_types); # ... get '/eingabe' => sub { my $self = shift; $self->render( 'eingabe' ); }; get '/insert_database' => sub { my $self = shift; my $vorname = $self->param('vorname'); my $nachname = $self->param('nachname'); my $steuernummer = $self->param('steuernummer'); my $ort = $self->param('ort'); my $sth = $dbh->prepare( "INSERT INTO $table ( vorname, nachname, steuernummer, ort ) VALUES ( ?, ?, ?, ? )" ); $sth->execute( $vorname, $nachname, $steuernummer, $ort ); $self->redirect_to( 'index' ); }; app->start; __DATA__ @@ eingabe.html.ep % title 'eingabe'; % layout 'green'; <br /><br /> <form action="insert_database"> <table> <tr><td>Vorname:</td><td><input type="text" name="vorname" /></td></tr> <tr><td>Nachname:</td><td><input type="text" name="nachname" /></td></tr> <tr><td>Steuernummer:</td><td><input type="text" name="steuernummer" /></td></tr> <tr><td>Ort:</td><td><input type="text" name="ort" /></td></tr> </table> <br /><input type="submit" value="OK"/> </form> <!-- ... -- |