UBB parser invoegen in weblog
luchtpost (laatste wijziging 10/11/2007 20:16)
PHP interesse
Beste sitemasters,
<?php mysql_connect("localhost","","");
mysql_select_db("");
$query ="SELECT entrytitle, entrytext,";
$query.=" DATE_FORMAT(entrydate, '%M %d, %Y') AS date";
$query.=" FROM weblog ORDER BY entrydate DESC LIMIT 10";
$result=mysql_query($query);
while (list($entrytitle,$entrytext,$entrydate) = mysql_fetch_row($result)) {
echo "<dt>$entrytitle</b></dt>"; echo "<dt>$entrydate</b></dt>";
echo "<dd>$entrytext</dd><br>";
}
?>
$query = "SELECT entrytitle, entrytext," ;
$query .= " DATE_FORMAT(entrydate, '%M %d , %Y') AS date" ;
$query .= " FROM weblog ORDER BY entrydate DESC LIMIT 10" ;
echo "<dt>$entrytitle </b></dt>" ; echo "<dt>$entrydate </b></dt>" ; echo "<dd>$entrytext </dd><br>" ; }
?>
<?php function parseubb($bericht,$quote_color){
$bericht = str_replace ("[br]","\n",$bericht);
$bericht = str_replace ("\n","<br>",$bericht);
$bericht = str_replace ("","<b>Code:</b><br><table bgcolor=\"#000000\" cellspacing=\"1\" width=\"90%\"><tr><td><table cellpadding=2 cellspacing=\"0\" bgcolor=\"#FFFFFF\" width=\"100%\"><tr><td><font face=Courier size=\"1\" color=\"#000000\">", $bericht);
$bericht = str_replace ("", "</font></td></tr></table></td></tr></table>", $bericht);
$bericht = str_replace ("[b ]", "<b>", $bericht); // [b ] zonder spatie
$bericht = str_replace ("[i ]", "<i>", $bericht); // [i ] zonder spatie
$bericht = str_replace ("[u ]", "<u>", $bericht); // [u ] zonder spatie
$bericht = str_replace ("[s]", "<s>", $bericht);
$bericht = str_replace ("[/b ]", "</b>", $bericht); // [/b ] zonder spatie
$bericht = str_replace ("[/i ]", "</i>", $bericht); // [/i ] zonder spatie
$bericht = str_replace ("[/u ]", "</u>", $bericht); // [/u ] zonder spatie
$bericht = str_replace ("[/s]", "</s>", $bericht);
$bericht = str_replace ("[move]", "<div align=\"center\"><marquee width=\"90%\">", $bericht);
$bericht = str_replace ("[/move]", "</marquee></div>", $bericht);
$bericht = preg_replace ("#\[color=(\#[0-9A-F]{6}|[a-z\-]+)\](.*?)\[/color\]#si", "<font color=\"\\1\">\\2</font>", $bericht);
$bericht = preg_replace ("/\[font=(.*)\](.*)\[\/font\]/", "<font face=\"$1\">$2</font>", $bericht);
$bericht = preg_replace ("/\[size=(.*)\](.*)\[\/size\]/", "<font size=\"$1\">$2</font>", $bericht);
$bericht = preg_replace("/\[img\](.*?)\[\/img\]/si", "<img src=\"\\1\" border=\"0\">",$bericht);
$bericht = str_replace ("[tt]", "<tt>", $bericht);
$bericht = str_replace ("[/tt]", "</tt>", $bericht);
$bericht = str_replace ("[q]", "<q>", $bericht);
$bericht = str_replace ("[/q]", "</q>", $bericht);
$bericht = str_replace ("[p]", "<p>", $bericht);
$bericht = str_replace ("[/p]", "</p>", $bericht);
$bericht = str_replace ("[blockquote]", "<blockquote>", $bericht);
$bericht = str_replace ("[/blockquote]", "</blockquote>", $bericht);
$bericht = str_replace ("[h1]", "<h1>", $bericht);
$bericht = str_replace ("[/h1]", "</h1>", $bericht);
$bericht = str_replace ("[left]", "<div align=left>", $bericht);
$bericht = str_replace ("[/left]", "</div>", $bericht);
$bericht = str_replace ("[center]", "<div align=\"center\">", $bericht);
$bericht = str_replace ("[/center]", "</div>", $bericht);
$bericht = str_replace ("[right]", "<div align=\"right\">", $bericht);
$bericht = str_replace ("[/right]", "</div>", $bericht);
$bericht = str_replace ("[sub]", "<sub>", $bericht);
$bericht = str_replace ("[/sub]", "</sub>", $bericht);
$bericht = str_replace ("[sup]", "<sup>", $bericht);
$bericht = str_replace ("[/sup]", "</sup>", $bericht);
$bericht = str_replace ("[[","{",$bericht);
$bericht = str_replace ("]]","}",$bericht);
$bericht = str_replace ("|","|",$bericht);
$bericht = str_replace ("{{","[",$bericht);
$bericht = str_replace ("}}","]",$bericht);
$bericht = str_replace ("[hr]","<hr color=\"#FFFFFF\" noshade />",$bericht);
$bericht = eregi_replace("\\[email=([^\\[]*)\\]([^\\[]*)\\[/email\\]", "<a href=\"mailto:\\1\">\\2</a>",$bericht); $bericht = eregi_replace("\\[url=([^\\[]*)\\]([^\\[]*)\\[/url\\]","<a href=\"\\1\" target=_blank>\\2</a>",$bericht);
$bericht = preg_replace("/\[url\](.*?)\[\/url\]/si", "<a href=\"\\1\" target=_blank>\\1</a>",$bericht);
$bericht = preg_replace("/\[email\](.*?)\[\/email\]/si", "<a href=\"mailto:\\1\">\\1</a>",$bericht);
$bericht = preg_replace ("#\[ftp\]([a-z]+?://){1}([a-z0-9\-\.,\?!%\*_\#:;~\\&$@\/=\+\(\)]+)\[/ftp\]#", "<a href=\"ftp://\\1\\2\" target=\"_blank\">\\2</a>", $bericht);
$bericht = preg_replace ("#\[ftp\]([a-z0-9\-\.,\?!%\*_\#:;~\\&$@\/=\+\(\)]+)\[/ftp\]#", "<a href=\"ftp://\\1\" target=\"_blank\">\\1</a>", $bericht);
$bericht = preg_replace ("#\[ftp=([a-z]+?://){1}([a-z0-9\-\.,\?!%\*_\#:;~\\&$@\/=\+\(\)]+)\](.*?)\[/ftp\]#", "<a href=\"ftp://\\1\\2\" target=\"_blank\">\\2</a>", $bericht);
$bericht = preg_replace ("#\[ftp=([a-z0-9\-\.,\?!%\*_\#:;~\\&$@\/=\+\(\)]+)\](.*?)\[/ftp\]#", "<a href=\"ftp://\\1\" target=\"_blank\">\\2</a>", $bericht); $bericht = preg_replace("/\[quote=(.+?)\](.+?)\[\/quote\]/is", '<br><table width="100%" cellspacing="0" cellpadding="0"><tr><td width="5%"> </td><td>Quote:</td></tr><tr><td width="5%"> </td><td bgcolor=".$quote_color." class="border">$1<br>$2</td></tr></table><br>', $bericht); $bericht = str_replace ("[list]","<ul>",$bericht);
$bericht = str_replace ("[*]","<li>",$bericht);
$bericht = str_replace ("[/list]","</li></ul>",$bericht);
return $bericht;
}
?>
<?php function parseubb( $bericht , $quote_color ) {
$bericht = str_replace ( "" , "<b>Code:</b><br><table bgcolor=\" #000000\" cellspacing=\" 1\" width=\" 90%\" ><tr><td><table cellpadding=2 cellspacing=\" 0\" bgcolor=\" #FFFFFF\" width=\" 100%\" ><tr><td><font face=Courier size=\" 1\" color=\" #000000\" >" , $bericht ) ; $bericht = str_replace ( "" , "</font></td></tr></table></td></tr></table>" , $bericht ) ; $bericht = str_replace ( "[b ]" , "<b>" , $bericht ) ; // [b ] zonder spatie $bericht = str_replace ( "[i ]" , "<i>" , $bericht ) ; // [i ] zonder spatie $bericht = str_replace ( "[u ]" , "<u>" , $bericht ) ; // [u ] zonder spatie $bericht = str_replace ( "[/b ]" , "</b>" , $bericht ) ; // [/b ] zonder spatie $bericht = str_replace ( "[/i ]" , "</i>" , $bericht ) ; // [/i ] zonder spatie $bericht = str_replace ( "[/u ]" , "</u>" , $bericht ) ; // [/u ] zonder spatie $bericht = str_replace ( "[move]" , "<div align=\" center\" ><marquee width=\" 90%\" >" , $bericht ) ; $bericht = str_replace ( "[/move]" , "</marquee></div>" , $bericht ) ; $bericht = preg_replace ( "#\[color=(\#[0-9A-F]{6}|[a-z\-]+)\](.*?)\[/color\]#si" , "<font color=\" \\1 \" >\\2 </font>" , $bericht ) ; $bericht = preg_replace ( "/\[font=(.*)\](.*)\[\/font\]/" , "<font face=\" $1 \" >$2 </font>" , $bericht ) ; $bericht = preg_replace ( "/\[size=(.*)\](.*)\[\/size\]/" , "<font size=\" $1 \" >$2 </font>" , $bericht ) ; $bericht = preg_replace ( "/\[img\](.*?)\[\/img\]/si" , "<img src=\" \\1 \" border=\" 0\" >" , $bericht ) ; $bericht = str_replace ( "[blockquote]" , "<blockquote>" , $bericht ) ; $bericht = str_replace ( "[/blockquote]" , "</blockquote>" , $bericht ) ; $bericht = str_replace ( "[left]" , "<div align=left>" , $bericht ) ; $bericht = str_replace ( "[/left]" , "</div>" , $bericht ) ; $bericht = str_replace ( "[center]" , "<div align=\" center\" >" , $bericht ) ; $bericht = str_replace ( "[/center]" , "</div>" , $bericht ) ; $bericht = str_replace ( "[right]" , "<div align=\" right\" >" , $bericht ) ; $bericht = str_replace ( "[/right]" , "</div>" , $bericht ) ; $bericht = str_replace ( "[hr]" , "<hr color=\" #FFFFFF\" noshade />" , $bericht ) ; $bericht = eregi_replace ( "\\[email=([^\\[]*)\\]([^\\[]*)\\[/email\\]" , "<a href=\" mailto:\\1 \" >\\2 </a>" , $bericht ) ; $bericht = eregi_replace ( "\\[url=([^\\[]*)\\]([^\\[]*)\\[/url\\]" , "<a href=\" \\1 \" target=_blank>\\2 </a>" , $bericht ) ; $bericht = preg_replace ( "/\[url\](.*?)\[\/url\]/si" , "<a href=\" \\1 \" target=_blank>\\1 </a>" , $bericht ) ; $bericht = preg_replace ( "/\[email\](.*?)\[\/email\]/si" , "<a href=\" mailto:\\1 \" >\\1 </a>" , $bericht ) ; $bericht = preg_replace ( "#\[ftp\]([a-z]+?://){1}([a-z0-9\-\.,\?!%\*_\#:;~\\&$@\/=\+\(\)]+)\[/ftp\]#" , "<a href=\" ftp://\\1 \\2 \" target=\" _blank\" >\\2 </a>" , $bericht ) ; $bericht = preg_replace ( "#\[ftp\]([a-z0-9\-\.,\?!%\*_\#:;~\\&$@\/=\+\(\)]+)\[/ftp\]#" , "<a href=\" ftp://\\1 \" target=\" _blank\" >\\1 </a>" , $bericht ) ; $bericht = preg_replace ( "#\[ftp=([a-z]+?://){1}([a-z0-9\-\.,\?!%\*_\#:;~\\&$@\/=\+\(\)]+)\](.*?)\[/ftp\]#" , "<a href=\" ftp://\\1 \\2 \" target=\" _blank\" >\\2 </a>" , $bericht ) ; $bericht = preg_replace ( "#\[ftp=([a-z0-9\-\.,\?!%\*_\#:;~\\&$@\/=\+\(\)]+)\](.*?)\[/ftp\]#" , "<a href=\" ftp://\\1 \" target=\" _blank\" >\\2 </a>" , $bericht ) ; $bericht = preg_replace ( "/\[quote=(.+?)\](.+?)\[\/quote\]/is" , '<br><table width="100%" cellspacing="0" cellpadding="0"><tr><td width="5%"> </td><td>Quote:</td></tr><tr><td width="5%"> </td><td bgcolor=".$quote_color." class="border">$1<br>$2</td></tr></table><br>' , $bericht ) ; $bericht = str_replace ( "[list]" , "<ul>" , $bericht ) ; $bericht = str_replace ( "[/list]" , "</li></ul>" , $bericht ) ; return $bericht ;
}
?>
19 antwoorden
ranco (laatste wijziging 10/11/2007 19:33)
PHP gevorderde Alleen includen is niet genoeg. in ubb.php staat de functie die alles moet verwerken. Maar deze moet je in index.php wel aanroepen. Dit doet je door:
echo "<dd>parseubb($entrytext)</dd><br>";
echo "<dd>parseubb($entrytext )</dd><br>" ;
EDIT: GEK! haal je inlogcodes weg uit je code..... dit hoeft niemand te weten....
luchtpost
PHP interesse Oh, inlogcodes verwijderd!
ranco
PHP gevorderde Verander deze regel code:
while (list($entrytitle,$entrytext,$entrydate) = mysql_fetch_row($result)) {
While($arr = mysql_fetch_assoc($result)){
echo ($arr["entrytitle"]."<br />");
echo ($arr["entrydate"]. "</b>);
echo ($arr["entrytext"]);
}
echo ( $arr [ "entrytitle" ] . "<br />" ) ; echo ( $arr [ "entrydate" ] . "</b>); echo ($arr [" entrytext"]);
}
Giant
PHP beginner
While($arr = mysql_fetch_assoc($result)){
echo ($arr["entrytitle"]."<br />");
echo ($arr["entrydate"]. "</b>");
echo ($arr["entrytext"]);
}
echo ( $arr [ "entrytitle" ] . "<br />" ) ; echo ( $arr [ "entrydate" ] . "</b>" ) ; echo ( $arr [ "entrytext" ] ) ; }
ranco (laatste wijziging 11/11/2007 16:08)
PHP gevorderde Inderdaad, een aanhalingsteken vergeten.... schoonheidsfoutjes Edit:
While($arr = mysql_fetch_assoc($result)){
echo (parseubb($arr["entrytitle"])."<br />");
echo (parseubb($arr["entrydate"]). "</b>");
echo (parseubb($arr["entrytext"]));
}
echo ( parseubb
( $arr [ "entrytitle" ] ) . "<br />" ) ; echo ( parseubb
( $arr [ "entrydate" ] ) . "</b>" ) ; echo ( parseubb
( $arr [ "entrytext" ] ) ) ; }
luchtpost (laatste wijziging 28/06/2008 21:49)
PHP interesse Mmm, ik krijg deze error:
luchtpost (laatste wijziging 11/11/2007 18:49)
PHP interesse Dit is de code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="author" content="" />
<meta http-equiv="content-type"
content="text/html;charset=iso-8859-1" />
<link rel="stylesheet" href="style.css"
type="text/css" />
<title>luchtpost</title>
</head>
<body>
<div id="container"><?php include('ubb.php');?>
<?php mysql_connect("localhost","","");
mysql_select_db("");
$query ="SELECT entrytitle, entrytext,";
$query.=" DATE_FORMAT(entrydate, '%M %d, %Y') AS date";
$query.=" FROM weblog ORDER BY entrydate DESC LIMIT 10";
$result=mysql_query($query);
While($arr = mysql_fetch_assoc($result)){
echo ($arr["entrytitle"]."<br />");
echo ($arr["entrydate"]. "</b>");
echo ($arr["entrytext"]);
}
echo "<dt>$entrytitle</b></dt>";
echo "<dt>$entrydate</b></dt>";
echo "<dd>$entrytext</dd><br>";
}
?></div>
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="author" content="" />
<meta http-equiv="content-type"
content="text/html;charset=iso-8859-1" />
<link rel="stylesheet" href="style.css"
type="text/css" />
<title>luchtpost</title>
</head>
<body>
<div id="container"><?php include ( 'ubb.php' ) ; ?>
$query = "SELECT entrytitle, entrytext," ;
$query .= " DATE_FORMAT(entrydate, '%M %d , %Y') AS date" ;
$query .= " FROM weblog ORDER BY entrydate DESC LIMIT 10" ;
echo ( $arr [ "entrytitle" ] . "<br />" ) ; echo ( $arr [ "entrydate" ] . "</b>" ) ; echo ( $arr [ "entrytext" ] ) ; }
echo "<dt>$entrytitle </b></dt>" ; echo "<dt>$entrydate </b></dt>" ; echo "<dd>$entrytext </dd><br>" ; }
?> </div>
</body>
</html>
Godlord (laatste wijziging 11/11/2007 18:41)
PHP gevorderde Ik zie 2 maal } en maar 1 maal {. Dat klopt niet echt. Ik heb het over Lijn: 19, 23 en 27 als je de accolades zoekt.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="author" content="" />
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="style.css" type="text/css" />
<title>luchtpost</title>
</head>
<body>
<div id="container">
<?php
include('ubb.php');
mysql_connect("localhost","xxx","xxx");
mysql_select_db("luchtpost_be");
$query = "SELECT entrytitle, entrytext,";
$query .= " DATE_FORMAT(entrydate, '%M %d, %Y') AS date";
$query .= " FROM weblog ORDER BY entrydate DESC LIMIT 10";
$result = mysql_query($query);
while ($arr = mysql_fetch_assoc($result)) {
echo ($arr["entrytitle"]."<br />");
echo ($arr["entrydate"]. "</b>");
echo ($arr["entrytext"]);
}
/* echo "<dt>$entrytitle</b></dt>";
echo "<dt>$entrydate</b></dt>";
echo "<dd>$entrytext</dd><br>";
} */
?>
</div>
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="author" content="" />
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="style.css" type="text/css" />
<title>luchtpost</title>
</head>
<body>
<div id="container">
<?php
include ( 'ubb.php' ) ;
$query = "SELECT entrytitle, entrytext," ;
$query .= " DATE_FORMAT(entrydate, '%M %d , %Y') AS date" ;
$query .= " FROM weblog ORDER BY entrydate DESC LIMIT 10" ;
echo ( $arr [ "entrytitle" ] . "<br />" ) ; echo ( $arr [ "entrydate" ] . "</b>" ) ; echo ( $arr [ "entrytext" ] ) ; }
/* echo "<dt>$entrytitle</b></dt>";
echo "<dt>$entrydate</b></dt>";
echo "<dd>$entrytext</dd><br>";
} */
?>
</div>
</body>
</html>
luchtpost
PHP interesse De ubb parser doet nog steeds niets...
Godlord
PHP gevorderde Vind ik niet zo vreemd eigenlijk, er wordt nergens parseubb() gebruikt.
Gerard
Ouwe rakker Ik wil je nog even een paar kleine dingen als tip meegeven die wat off-topic zijn. Je maakt gebruik van de volgende constructie om de query op te bouwen:
<?php
$query ="SELECT entrytitle, entrytext,";
$query.=" DATE_FORMAT(entrydate, '%M %d, %Y') AS date";
$query.=" FROM weblog ORDER BY entrydate DESC LIMIT 10";
<?php
$query = "SELECT entrytitle, entrytext," ;
$query .= " DATE_FORMAT(entrydate, '%M %d , %Y') AS date" ;
$query .= " FROM weblog ORDER BY entrydate DESC LIMIT 10" ;
<?php
$query = "SELECT entrytitle, entrytext,
DATE_FORMAT(entrydate, '%M %d, %Y') AS date
FROM weblog
ORDER BY entrydate DESC
LIMIT 10";
<?php
$query = "SELECT entrytitle, entrytext,
DATE_FORMAT(entrydate, '%M %d , %Y') AS date
FROM weblog
ORDER BY entrydate DESC
LIMIT 10" ;
<?php
$query = "SELECT entrytitle, entrytext,"
. "DATE_FORMAT(entrydate, '%M %d, %Y') AS date"
. "FROM weblog"
. "ORDER BY entrydate DESC"
. "LIMIT 10";
<?php
$query = "SELECT entrytitle, entrytext,"
. "DATE_FORMAT(entrydate, '%M %d , %Y') AS date"
. "FROM weblog"
. "ORDER BY entrydate DESC"
. "LIMIT 10" ;
PHP.net: echo dien je géén gebruik te maken van de (). Dit heeft er mee te maken dat echo géén functie is maar een language construct.
<?php
echo "Dit is een {$variabele} binnen quotes";
<?php
echo "Dit is een {$variabele} binnen quotes" ;
PHP.net: stripslashes ) en daarnaast moet je het even beveiligen met PHP.net: htmlentities of PHP.net: htmlspecialchars om gekke dingen te voorkomen.
<?php
mysql_connect("localhost","luchtpost_be","HIERSTONDJEPASS");
mysql_select_db("luchtpost_be");
$query ="SELECT entrytitle, entrytext,";
$query.=" DATE_FORMAT(entrydate, '%M %d, %Y') AS date";
$query.=" FROM weblog ORDER BY entrydate DESC LIMIT 10";
$result=mysql_query($query);
While($arr = mysql_fetch_assoc($result)){
echo ($arr["entrytitle"]."<br />");
echo ($arr["entrydate"]. "</b>");
echo ($arr["entrytext"]);
}
?>
<?php
$query = "SELECT entrytitle, entrytext," ;
$query .= " DATE_FORMAT(entrydate, '%M %d , %Y') AS date" ;
$query .= " FROM weblog ORDER BY entrydate DESC LIMIT 10" ;
echo ( $arr [ "entrytitle" ] . "<br />" ) ; echo ( $arr [ "entrydate" ] . "</b>" ) ; echo ( $arr [ "entrytext" ] ) ; }
?>
<?php
$databaseConnection = mysql_connect('localhost', 'username', 'password');
$databaseSelect = mysql_select_db('database', $databaseConnection);
$weblogEntries = mysql_query("SELECT entrytitle, entrytext,
DATE_FORMAT(entrydate, '%M %d, %Y') AS date
FROM weblog
ORDER BY entrydate DESC
LIMIT 10");
while ($weblogEntry = mysql_fetch_assoc($weblogEntries)) {
echo htmlspecialchars(stripslashes($weblogEntry['entrytitle'])) . '<br />'
. htmlspecialchars(stripslashes($weblogEntry['entrydate'])) . '<br />'
. htmlspecialchars(stripslashes($weblogEntry['entrytext']));
}
?>
<?php
$databaseConnection = mysql_connect ( 'localhost' , 'username' , 'password' ) ;
$weblogEntries = mysql_query ( "SELECT entrytitle, entrytext, DATE_FORMAT(entrydate, '%M %d , %Y') AS date
FROM weblog
ORDER BY entrydate DESC
LIMIT 10" ) ;
}
?>
PHP.net: mysql_error . Maar dat kan je er zelf wel ingooien. Ik probeer je met dit bericht niet om te scholen naar 'mijn' systeem, maar wil je er gewoon op wijzen dat je het jezelf wat makkelijker kan maken. En wat veiliger.
Godlord
PHP gevorderde @Proximus: ik heb enkel de code aangepast om het duidelijk te maken qua lezen, zelf gebruik ik ook echo zonder de ().
ranco (laatste wijziging 11/11/2007 20:03)
PHP gevorderde Je bent de parseubb functie er weer vergeten in te zetten. Dit moet werken:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="author" content="" />
<meta http-equiv="content-type"
content="text/html;charset=iso-8859-1" />
<link rel="stylesheet" href="style.css"
type="text/css" />
<title>luchtpost</title>
</head>
<body>
<div id="container"><?php include('ubb.php');?>
<?php mysql_connect("localhost","","");
mysql_select_db("");
$query ="SELECT entrytitle, entrytext,";
$query.=" DATE_FORMAT(entrydate, '%M %d, %Y') AS date";
$query.=" FROM weblog ORDER BY entrydate DESC LIMIT 10";
$result=mysql_query($query);
While($arr = mysql_fetch_assoc($result)){
echo ($arr["entrytitle"]."<br />");
echo ($arr["entrydate"]. "</b>");
echo (parseubb($arr["entrytext"]));
}
?></div>
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="author" content="" />
<meta http-equiv="content-type"
content="text/html;charset=iso-8859-1" />
<link rel="stylesheet" href="style.css"
type="text/css" />
<title>luchtpost</title>
</head>
<body>
<div id="container"><?php include ( 'ubb.php' ) ; ?>
$query = "SELECT entrytitle, entrytext," ;
$query .= " DATE_FORMAT(entrydate, '%M %d , %Y') AS date" ;
$query .= " FROM weblog ORDER BY entrydate DESC LIMIT 10" ;
echo ( $arr [ "entrytitle" ] . "<br />" ) ; echo ( $arr [ "entrydate" ] . "</b>" ) ; echo ( parseubb
( $arr [ "entrytext" ] ) ) ; }
?> </div>
</body>
</html>
luchtpost (laatste wijziging 12/11/2007 19:38)
PHP interesse Dankuwel iedereen!
Godlord (laatste wijziging 12/11/2007 20:01)
PHP gevorderde
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="author" content="" />
<meta http-equiv="content-type"
content="text/html;charset=iso-8859-1" />
<link rel="stylesheet" href="style.css"
type="text/css" />
<title>luchtpost</title>
</head>
<body>
<div id="container">
<?php
include('ubb.php');
mysql_connect("localhost","","");
mysql_select_db("");
$query = "SELECT entrytitle, entrytext,";
$query .= "DATE_FORMAT(entrydate, '%M %d, %Y') AS date";
$query .= "FROM weblog";
$query .= "ORDER BY entrydate DESC";
$query .= "LIMIT 10";
$result = mysql_query($query);
while ($arr = mysql_fetch_assoc($result)){
echo $arr["entrytitle"]."<br />";
echo $arr["date"]. "</b>";
echo parseubb($arr["entrytext"]);
}
?>
</div>
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="author" content="" />
<meta http-equiv="content-type"
content="text/html;charset=iso-8859-1" />
<link rel="stylesheet" href="style.css"
type="text/css" />
<title>luchtpost</title>
</head>
<body>
<div id="container">
<?php
include ( 'ubb.php' ) ;
$query = "SELECT entrytitle, entrytext," ;
$query .= "DATE_FORMAT(entrydate, '%M %d , %Y') AS date" ;
$query .= "FROM weblog" ;
$query .= "ORDER BY entrydate DESC" ;
$query .= "LIMIT 10" ;
echo $arr [ "entrytitle" ] . "<br />" ; echo $arr [ "date" ] . "</b>" ; echo parseubb
( $arr [ "entrytext" ] ) ; }
?>
</div>
</body>
</html>
AS date in de MySQL query, dat betekent dat je "date" moet gebruiken i.p.v. entrydate.
TotempaaltJ (laatste wijziging 12/11/2007 21:23)
PHP interesse Waarom staat daar een </b>, ik zie nergens een <b> staan!
Gerard
Ouwe rakker Omdat dit script ondertussen door 4 verschillende personen onder de loep is genomen, veranderd is en ge-copy/paste is. Dat heeft ervoor gezorgd dat het niet echt meer werkt. PHP.net: var_export , PHP.net: var_dump of PHP.net: print_r had dit meer dan duidelijk gemaakt.
jc2 (laatste wijziging 29/06/2008 12:27)
PHP interesse Nog wat offtopic, maar wel iets om over na te denken:Citaat:
$bericht = str_replace ("[[","{",$bericht);
[[tekst]] vervangen door {tekst} {{tekst}} door [tekst] ?
$bericht = str_replace ("[[","[",$bericht);
$bericht = str_replace ("]]","]",$bericht);
$bericht = str_replace ("|","|",$bericht);
$bericht = str_replace ("{{","{",$bericht);
$bericht = str_replace ("}}","}",$bericht);
Dit onderwerp is gesloten .
Wat is jouw favoriete javascript framework? (S: 18, R: 2)
Gesponsorde links
Actiefste leden van de maand
