Hilfe bei meinen forum

  • so soweit binn ich jetzte aba ich versteh nich warum du bei topic created by einen integer genommen hast ???


    und dann weiter ich bin nun soweit:


    PHP
    <span class="syntaxhtml"><br /><span class="syntaxdefault"><?php<br />session_start</span><span class="syntaxkeyword">();<br /></span><span class="syntaxdefault">?><br /></span><h3>Themen:</h3><br /><span class="syntaxdefault"><?php<br />    $sql </span><span class="syntaxkeyword">= </span><span class="syntaxstring">"SELECT * FROM topic"</span><span class="syntaxkeyword">;<br />    </span><span class="syntaxdefault">mysql_connect</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"localhost"</span><span class="syntaxkeyword">, </span><span class="syntaxstring">"truck0_769425"</span><span class="syntaxkeyword">, </span><span class="syntaxstring">"123456789"</span><span class="syntaxkeyword">);<br />    </span><span class="syntaxdefault">mysql_select_db</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"truck0_769425"</span><span class="syntaxkeyword">);<br />    </span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$sql</span><span class="syntaxkeyword">);<br />    while ( </span><span class="syntaxdefault">$inhalt </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_fetch_array</span><span class="syntaxkeyword">( </span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">MYSQL_ASSOC </span><span class="syntaxkeyword">) )<br />    {<br />        </span><span class="syntaxdefault">?><br /></span>        <fieldset><br />        <legend><span class="syntaxdefault"><?php </span><span class="syntaxkeyword">echo </span><span class="syntaxdefault">$inhalt</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'title'</span><span class="syntaxkeyword">]; </span><span class="syntaxdefault">?></span></legend><br />        Dieses Thema Wurde von <span class="syntaxdefault"><?php </span><span class="syntaxkeyword">echo </span><span class="syntaxdefault">$inhalt</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'createdBy'</span><span class="syntaxkeyword">]; </span><span class="syntaxdefault">?></span> erstellt.<br />        <a href="">Zu diesen Thema</a><br />        </fieldset><br />        <span class="syntaxdefault"><?php<br />    </span><span class="syntaxkeyword">}<br /><br /><br />if( isset(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'savetopic'</span><span class="syntaxkeyword">]) )<br />   {<br /></span><span class="syntaxdefault">$title </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'title'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">$createtBy </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">$_SESSION</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'Name'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">date_default_timezone_set</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Europe/Berlin'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">$createddate </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">date</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"d.m.Y"</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">= </span><span class="syntaxstring">"INSERT INTO `truck0_769425`.`topic` (<br />`idtopic` ,<br />`title` ,<br />`createdBy` ,<br />`createDate`<br />)<br />VALUES (<br />NULL , '" </span><span class="syntaxkeyword">. </span><span class="syntaxdefault">$title </span><span class="syntaxkeyword">. </span><span class="syntaxstring">"' , '" </span><span class="syntaxkeyword">. </span><span class="syntaxdefault">$createtBy </span><span class="syntaxkeyword">. </span><span class="syntaxstring">"' , '" </span><span class="syntaxkeyword">. </span><span class="syntaxdefault">$createddate </span><span class="syntaxkeyword">. </span><span class="syntaxstring">"'<br />);<br />"</span><span class="syntaxkeyword">;<br />    </span><span class="syntaxdefault">mysql_connect</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"localhost"</span><span class="syntaxkeyword">, </span><span class="syntaxstring">"truck0_769425"</span><span class="syntaxkeyword">, </span><span class="syntaxstring">"123456789"</span><span class="syntaxkeyword">);<br />    </span><span class="syntaxdefault">mysql_select_db</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"truck0_769425"</span><span class="syntaxkeyword">);<br />    </span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$sql</span><span class="syntaxkeyword">);<br />    if( </span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">)<br />    {<br />        echo </span><span class="syntaxstring">"Dieses Thema wurde erfolgreich Erstellt."</span><span class="syntaxkeyword">;<br />    }else{<br />        echo </span><span class="syntaxstring">"Dieses Thema konnte nicht erstellt werden."</span><span class="syntaxkeyword">;<br />    }<br /><br />}<br />if( </span><span class="syntaxdefault">$_SESSION</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'Moderator'</span><span class="syntaxkeyword">] == </span><span class="syntaxdefault">True </span><span class="syntaxkeyword">OR </span><span class="syntaxdefault">$_SESSION</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'Admin'</span><span class="syntaxkeyword">] == </span><span class="syntaxdefault">True </span><span class="syntaxkeyword">)<br />    {<br /> </span><span class="syntaxdefault">?><br /></span> <h4>Neues Thema Erstellen:</h4><br /> <form name="Thema" action="" method="post" enctype="text/html"><br /><input type="text" name="title" value="" size="20" maxlength="50" /><br /><input type="submit" name="savetopic" value="Save" /><br /></form><br /><span class="syntaxdefault"><?php<br /></span><span class="syntaxkeyword">}<br /> </span><span class="syntaxdefault">?><br /></span></span>


    das is die Forum.inc.php datei die ich in index.php eingebunden habe.


    nun aba wie wird der href vom Link? wie die TopicID
    mfg Truck007

  • Weil jeder User eine Userid hat :)
    Und das ist eine Zahl :) Dann kannst du theoretisch sogar später einen Benutzer X in Y umbenennen und dennoch sind dann alle Einträge von Y :wink:


    Jupp :)
    der Link sollte irgendwie die ID beinhalten, damit wir über unsere Kreuztabelle die antworten bekommen^^

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!