ik heb er 2
Code: Selecteer alles
<?php
/* user config variables */
$max_items = 5; /* max number of news items to show */
/* make database connection */
$db = mysql_connect ('','');
mysql_select_db ('',$db);
function displayNews($all = 0) {
/* bring in two variables
* $db is our database connection
* $max_items is the maximum number
* of news items we want to display */
global $db, $max_items;
/* query for news items */
if ($all == 0) {
/* this query is for up to $max_items */
$query = "SELECT id,title,newstext," .
"FROM news ORDER BY postdate DESC LIMIT $max_items";
} else {
/* this query will get all news */
$query = "SELECT id,title,newstext," .
"FROM news ORDER BY id DESC";
}
$result = mysql_query ($query);
while ($row = mysql_fetch_assoc ($result)) {
/* display news in a simple table */
echo "<TABLE border=\"1\" width=\"300\">\n";
/* place table row data in
* easier to use variables.
* Here we also make sure no
* HTML tags, other than the
* ones we want are displayed */
$title = htmlentities ($row['titel']);
$news = nl2br (strip_tags ($row['post'], '<a><b><i><u>'));
/* display the data */
echo "<TR><TD><b>$title</b> posted on $date</TD></TR>\n";
echo "<TR><TD>$news</TD></TR>\n";
/* get number of comments */
$comment_query = "SELECT count(*) FROM news_comments " .
"WHERE news_id={$row['id']}";
$comment_result = mysql_query ($comment_query);
$comment_row = mysql_fetch_row($comment_result);
/* display number of comments with link */
echo "<TR><TD><a href=\"{$_SERVER['PHP_SELF']}" .
"?action=show&id={$row['id']}\">Comments</a>" .
"($comment_row[0]}</TD></TR>\n";
/* finish up table*/
echo "</TABLE>\n";
echo "<BR>\n";
}
/* if we aren't displaying all news,
* then give a link to do so */
if ($all == 0) {
echo "<a href=\"{$_SERVER['PHP_SELF']}" .
"?action=all\">View all news</a>\n";
}
}
function displayOneItem($id) {
global $db;
/* query for item */
$query = "SELECT * FROM test WHERE id=$id";
$result = mysql_query ($query);
/* if we get no results back, error out */
if (mysql_num_rows ($result) == 0) {
echo "Bad news id\n";
return;
}
$row = mysql_fetch_assoc($result);
echo "<TABLE border=\"1\" width=\"300\">\n";
/* easier to read variables and
* striping out tags */
$title = htmlentities ($row['titel']);
$news = nl2br (strip_tags ($row['post'], '<a><b><i><u>'));
/* display the items */
echo "<TR><TD><b>$title</b></TD></TR>\n";
echo "<TR><TD>$news</TD></TR>\n";
echo "</TABLE>\n";
echo "<BR>\n";
/* now show the comments */
}
/* this is where the script decides what do do */
echo "<CENTER>\n";
switch($_GET['action']) {
case 'show':
displayOneItem($_GET['id']);
break;
case 'all':
displayNews(1);
break;
case 'addcomment':
addComment($_GET['id']);
break;
default:
displayNews();
}
echo "</CENTER>\n";
?>
// afgekeken van ander script
die zegt
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\gb\test2.php on line 27
en deze probeer ik werkent te maken (bovenste doet het trouwens ook niet...)
Code: Selecteer alles
<?php
require_once('config.php');
if (isset($_GET["page"])) {
$pageNum = $_GET["page"];
}
$offset = ($pageNum - 1) * $rowsPerPage;
$sql = "SELECT post";
$result = mysql_query($sql) or die("Error:<br />" .$_lang_guestbook["error"] ."<br />");
while($row = mysql_fetch_array($result)) {
echo adds('.html($row['post']).');
}
?>
edit*
Hee ik zie het geloof ik al ik heb het database script geinclude wrm doet ie dat niet????
en als ik dat niet doe zegt ie hetzelfde!!!!!
Parse error: parse error, unexpected T_STRING in C:\Program Files\xampp\htdocs\gb\test.php on line 11