Also ich habe in der Datenbank eine Tabelle angelegt Namens Test und dann darin eine Struktur Bild.
Jetzt hatte ich folgendes versucht
php
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 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 | <?php defined ( 'main' ) or die ( 'no direct access' ); defined ( 'admin' ) or die ( 'only admin access' ); $design = new design ( 'Admins Area' , 'Admins Area' , 2); $design ->header(); $tpl = new tpl ( 'testup' , 1); if ( empty ( $_POST [ 'submit' ]) ) { $abf = 'SELECT bild FROM `prefix_test`' ; $erg = db_query( $abf ); if ( db_num_rows( $erg ) > 0 ) { $row = db_fetch_assoc( $erg ); $row [ 'avatarbild' ] = ( file_exists ( $row [ 'bild' ] ) ? '<img src="' . $row [ 'bild' ]. '" alt=""><br />' : '' ); $row [ 'Fabreite' ] = $allgAr [ 'Fabreite' ]; $row [ 'Fahohe' ] = $allgAr [ 'Fahohe' ]; $row [ 'Fasize' ] = $allgAr [ 'Fasize' ]; $row [ 'ppicbreite' ] = $allgAr [ 'ppicbreite' ]; $row [ 'ppichohe' ] = $allgAr [ 'ppichohe' ]; $row [ 'ppicsize' ] = $allgAr [ 'ppicsize' ]; $row [ 'forum_max_sig' ] = $allgAr [ 'forum_max_sig' ]; $row [ 'uid' ] = $_SESSION [ 'authid' ]; $row [ 'forum_usergallery' ] = $allgAr [ 'forum_usergallery' ]; $tpl ->set_ar_out( $row ,0); if ( $allgAr [ 'forum_avatar_upload' ]) $tpl ->out(1); $tpl ->set_ar_out( $row ,2); profilefields_change ( $_SESSION [ 'authid' ] ); $tpl ->out(3); # avatar speichern START $avatar_sql_update = '' ; if ( ! empty ( $_FILES [ 'bildfile' ][ 'name' ] ) AND $allgAr [ 'forum_avatar_upload' ] ) { $file_tmpe = $_FILES [ 'bildfile' ][ 'tmp_name' ]; $rile_type = ic_mime_type ( $_FILES [ 'bildfile' ][ 'tmp_name' ]); $file_type = $_FILES [ 'bildfile' ][ 'type' ]; $file_size = $_FILES [ 'bildfile' ][ 'size' ]; $fmsg = $lang [ 'avatarisnopicture' ]; $size = @ getimagesize ( $file_tmpe ); $endar = array (1 => 'gif' , 2 => 'jpg' , 3 => 'png' ); if ( ( $size [2] == 1 OR $size [2] == 2 OR $size [2] == 3) AND $size [0] > 10 AND $size [1] > 10 AND substr ( $file_type , 0 , 6 ) == 'image/' AND substr ( $rile_type , 0 , 6 ) == 'image/' ) { $endung = $endar [ $size [2]]; $breite = $size [0]; $hoehe = $size [1]; $fmsg = $lang [ 'avatarcannotupload' ]; if ( $file_size <= $allgAr [ 'Fasize' ] AND $breite <= $allgAr [ 'Fabreite' ] AND $hoehe <= $allgAr [ 'Fahohe' ] ) { $neuer_name = 'include/images/avatars/' . $_SESSION [ 'authid' ]. '.' . $endung ; @unlink (db_result(db_query( "SELECT bild FROM prefix_test WHERE id = " . $_SESSION [ 'authid' ]),0)); move_uploaded_file ( $file_tmpe , $neuer_name ); @ chmod ( $neuer_name , 0777); $avatar_sql_update = "bild = '" . $neuer_name . "'," ; $fmsg = $lang [ 'pictureuploaded' ]; } } } elseif ( isset( $_POST [ 'bildloeschen' ]) ) { $fmsg = $lang [ 'picturedelete' ]; @unlink (db_result(db_query( "SELECT bild FROM prefix_test WHERE id = " . $_SESSION [ 'authid' ]),0)); $avatar_sql_update = "bild = ''," ; } } # avatar speichern ENDE $design ->footer(); } ?> |
html
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | <tr> <td class="Cmite">Bild</td> <td class="Cnorm"><input type="checkbox" name="bilddel" value="1">Löschen ?<br /> {bild} <input type="file" name="bildfile" /></td> </tr> </td></tr> <tr> <td class="Cdark"></td> <td class="Cdark"> <input type="submit" value="Ändern" name="submit"> </td> </tr> </table> </form> |
Aber leider Funktioniert der Ändern Button nicht.
Könnte mir da jemand behilflich sein?
Mit Freundlichen Grüßen
Lisa
betroffene Homepage: localhost