|
Software- und Webentwicklung Planung, Programmierung und Administration
UML, JavaScript/DOM, ASP, JSP, PHP, Apache, MySQL, Python, Perl (...) |
|
Themen-Optionen | Ansicht |
03.11.2003, 15:01 | #1 (permalink) |
Code:
Ich brauch ein srrcipt der mir den aus der db aus gelesenen text von mir aus >>hallo :-)<< und das er mir dann den :-) in ein Code:
<? $link = mysql_connect('localhost','web14','123456'); $db = mysql_select_db('usr_web14_1') or die (mysql_error() ); $sql = "SELECT * from News ORDER BY ts DESC LIMIT 0,4"; $res = mysql_query($sql); ?> <img src='_images/smilies/grenade.gif'> <html> <head> <title>Farcry-Mod</title> </head> <script language="JavaScript" type="text/JavaScript"> <!-- function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } //--> </script> <style type="text/css"> <!-- frame, select, textarea { color:#000000; } .Bereich, .Feld { background-color:#DCE3FF;} --> </style> <style type="text/css"> <!-- .textnormal2 { font-family: Arial; font-size: 11px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; color: #FFFFFF; text-decoration: none; } .textnormal { font-family: Arial; font-size: 11px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; color: #FFFFFF; text-decoration: none; } .menuetext { font-family: arial; font-size: 12px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; color: #FFFFFF; } .menuetext:hover { color: #548B69; } .test { background-color: #3C5C48; background-image: url(_images/backgraund.jpg); background-position: 0 0; background-repeat: no-repeat; } .bild { border:1px solid #333333; } .loginfield2 { background-color:#3C5C48; font-family: Arial; font-size: 10px; color: #FFFFFF; border:0px solid #333333; height: 15px; width: 50px; } .loginfield { background-color:#548B69; font-family: Arial; font-size: 10px; color: #FFFFFF; border:1px solid #333333; height: 15px; width: 50px; } --> </style> <body class="test" bgcolor="#3C5C48" LEFTMARGIN=0 topMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0 > <div style="position:absolute; top:160px; left:175px; "> <? while ($row = mysql_fetch_assoc($res)) { ?> <table width="650" border="0" cellpadding="0" cellspacing="0" bgcolor="548B69" width="560" border="0" cellspacing="0" cellpadding="2" style="border-style:solid; border-width:1px; border-color:#000000;"> <img class="bild" src="<?=$row["symbol"];?>"> <tr bgcolor="3C5C48"> <td class="menuetext"><?=$row["title"];?><img src="spacer.gif" height="1" width="450" ><a class="menuetext" href="mailto:<?=$row["email"];?>">von: <?=$row["autor"];?></a></td><td class="menuetext"><?=$row["datum"];?></td> </tr> <tr> <td class="textnormal"><?=$row["text"];?></td><td></td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> </table> <table width="650" border="0" cellpadding="0" cellspacing="0" width="560" border="0" cellspacing="0" cellpadding="2" > <tr> <td colspan="3"><img width="560" height="1" src="spacer.gif"</td><td><a href="#" class="menuetext">Bemerkungen</a></td> </tr> </table> <? } ?> </div> <div style="position:absolute; top:409px; left:0px; "> <table width="119 border="0" cellpadding="0" cellspacing="0" bgcolor="3C5C48" border="0" cellspacing="0" cellpadding="0" style="border-style:solid; border-width:1px; border-color:#000000;"> <tr> <td class="menuetext">Userlogin</td> </tr> <tr> <td class="textnormal"> Username: </td><td><input name="title" class="loginfield" type="text"></td> </tr> <tr> <td class="textnormal"> Passwort: </td><td><input name="name" class="loginfield" type="password"></td> </tr> <tr> <tr> <td><a class="textnormal2" href="reg.php"> Rregistrieren</a> </td><td><input frameborder="0" class="loginfield2" name="login" value="Login" type="submit"</td> </tr> </table> </div> <table style="position:absolute; top:104px; left:17px; "> <tr> <td><a href="index.php" onMouseOver="MM_swapImage('Image1','','_images/menu1_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu1.gif" name="Image1" border="0" id="Image1"></a></td> </tr> </table> <table style="position:absolute; top:125px; left:17px; "> <tr> <td><a href="javascript:;" onMouseOver="MM_swapImage('Image2','','_images/menu2_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu2.gif" name="Image2" border="0" id="Image2"></a></td> </tr> </table> <table style="position:absolute; top:146px; left:17px; "> <tr> <td><a href="javascript:;" onMouseOver="MM_swapImage('Image3','','_images/menu3_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu3.gif" name="Image3" border="0" id="Image3"></a></td> </tr> </table> <table style="position:absolute; top:167px; left:16px; "> <tr> <td><a href="javascript:;" onMouseOver="MM_swapImage('Image4','','_images/menu4_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu4.gif" name="Image4" border="0" id="Image4"></a></td> </tr> </table> <table style="position:absolute; top:188px; left:17px; "> <tr> <td><a href="javascript:;" onMouseOver="MM_swapImage('Image5','','_images/menu5_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu5.gif" name="Image5" border="0" id="Image5"></a></td> </tr> </table> <table style="position:absolute; top:209px; left:17px; "> <tr> <td><a href="javascript:;" onMouseOver="MM_swapImage('Image6','','_images/menu6_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu6.gif" name="Image6" border="0" id="Image6"></a></td> </tr> </table> <table style="position:absolute; top:92px; left:0px; "> <tr> <img src="_images/menu_left.gif" name="menu_left" border="0" ></a></td> </tr> </table> <table style="position:absolute; top:230px; left:16px; "> <tr> <td><a href="javascript:;" onMouseOver="MM_swapImage('Image7','','_images/menu7_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu7.gif" name="Image7" border="0" id="Image7"></a></td> </tr> </table> <table style="position:absolute; top:251px; left:16px; "> <tr> <td><a href="javascript:;" onMouseOver="MM_swapImage('Image8','','_images/menu8_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu8.gif" name="Image8" border="0" id="Image8"></a></td> </tr> </table> <table style="position:absolute; top:272px; left:16px; "> <tr> <td><a href="javascript:;" onMouseOver="MM_swapImage('Image9','','_images/menu9_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu9.gif" name="Image9" border="0" id="Image9"></a></td> </tr> </table> <table style="position:absolute; top:293px; left:16px; "> <tr> <td><a href="admin_login.html" onMouseOver="MM_swapImage('Image10','','_images/menu10_contra.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="_images/menu10.gif" name="Image10" border="0" id="Image10"></a></td> </tr> </table> </body> </html>
__________________
OFP 4ever. |
|
04.11.2003, 06:45 | #2 (permalink) |
Mit dem Text aus der Datenbank, wird das wohl nichts werden, dass muss schon Clientseitig passieren, zumindest, das umwandeln, von :-) in [img]smileys/smiley.gif[/img] würde ich sagen, sollen das nur bestimmte Smileys sein oder willst du die auch updaten können?
__________________
http://riedel-st.de |
|
06.11.2003, 21:56 | #7 (permalink) |
@ Rambow du musst via preg_replace(), den String ":) oder :( usw." in [img]smileys/smiley.gif[/img] umwandeln.
Wenn ich es schaffe schreibe ich dir mal morgen ne Funktion, aber verlasse dich net drauf und versuche es selber. Lese dir mal das Tutorial über BBCodes durch, da wird genau das beschrieben, wie du dein Problem löst. P.S. Poste bitte das nächste mal nur den teil des Codes, der deiner Meinung nach relevant ist, mit Html, können wir hier meist nichts anfangen oder brauchen es nicht, wenn es um PHP-Sachen geht ;) Gruß Stefan
__________________
http://riedel-st.de |
|
Aktive Benutzer in diesem Thema: 1 (Registrierte Benutzer: 0, Gäste: 1) | |
Themen-Optionen | |
Ansicht | |
|
|