I am trying to create a method to display my events on http://www.sk8photos.com > events. I have created a database page http://www.sk8photos.com/show_records.php can I copy the code and paste it into a block to get it to work?

Short answer, ..yes.

See Can I include my own HTML pages in xoops? , which is for a html page, your php page is much the same ......



(I _think_ ??)

Quote:

I tryied that but however, I guess I forgot to tell you that I made my database page using Dreamweaver and as you see it works fins as a standalone but i can't get XOOPS to wrap around this database page.

=========================My code=========================


$maxRows_allevents = 5;
$pageNum_allevents = 0;
if (isset($_GET['pageNum_allevents'])) {
$pageNum_allevents = $_GET['pageNum_allevents'];
}
$startRow_allevents = $pageNum_allevents * $maxRows_allevents;

mysql_select_db($database_SkateEvents, $SkateEvents);
$query_allevents = "SELECT * FROM events ORDER BY `Date` ASC";
$query_limit_allevents = sprintf("%s LIMIT %d, %d", $query_allevents, $startRow_allevents, $maxRows_allevents);
$allevents = mysql_query($query_limit_allevents, $SkateEvents) or die(mysql_error());
$row_allevents = mysql_fetch_assoc($allevents);

if (isset($_GET['totalRows_allevents'])) {
$totalRows_allevents = $_GET['totalRows_allevents'];
} else {
$all_allevents = mysql_query($query_allevents);
$totalRows_allevents = mysql_num_rows($all_allevents);
}
$totalPages_allevents = ceil($totalRows_allevents/$maxRows_allevents)-1;
?>

Date	Events	Host	More info	Host id
			Click Here

mysql_free_result($allevents);
?>
=========================end code======================

From first looking at the code, the while staement should be up the top somewhere shouldn't it ? Also, there is no closing brace on the while statement ?

I wouldn't use Dreamweaver to create php code either, I've heard some horrar stories.

edit: .. oops, I didn't so the php 'do'. lol

When you try wrapping the XOOPS code around it, what does it do, any error messages ?

I get a blank page wraped in Xoops.

What does your php error log say ?

I am not sure what that means. However, This simple page works so why can't i just use the include statement?


$maxRows_allevents = 5;
$pageNum_allevents = 0;
if (isset($_GET['pageNum_allevents'])) {
$pageNum_allevents = $_GET['pageNum_allevents'];
}
$startRow_allevents = $pageNum_allevents * $maxRows_allevents;

mysql_select_db($database_SkateEvents, $SkateEvents);
$query_allevents = "SELECT * FROM events ORDER BY `Date` ASC";
$query_limit_allevents = sprintf("%s LIMIT %d, %d", $query_allevents, $startRow_allevents, $maxRows_allevents);
$allevents = mysql_query($query_limit_allevents, $SkateEvents) or die(mysql_error());
$row_allevents = mysql_fetch_assoc($allevents);

if (isset($_GET['totalRows_allevents'])) {
$totalRows_allevents = $_GET['totalRows_allevents'];
} else {
$all_allevents = mysql_query($query_allevents);
$totalRows_allevents = mysql_num_rows($all_allevents);
}
$totalPages_allevents = ceil($totalRows_allevents/$maxRows_allevents)-1;
?>

Ok guys and gals I have a code that works, and now I am looking for constructive comments.

++++++++++++++++here's the code++++++++++++++++++++++++++++

include("mainfile.php");
include(XOOPS_ROOT_PATH."/header.php");
?>

$maxRows_allevents = 5;
$pageNum_allevents = 0;
if (isset($_GET['pageNum_allevents'])) {
$pageNum_allevents = $_GET['pageNum_allevents'];
}
$startRow_allevents = $pageNum_allevents * $maxRows_allevents;

mysql_select_db($database_SkateEvents, $SkateEvents);
$query_allevents = "SELECT * FROM events ORDER BY `Date` ASC";
$query_limit_allevents = sprintf("%s LIMIT %d, %d", $query_allevents, $startRow_allevents, $maxRows_allevents);
$allevents = mysql_query($query_limit_allevents, $SkateEvents) or die(mysql_error());
$row_allevents = mysql_fetch_assoc($allevents);

if (isset($_GET['totalRows_allevents'])) {
$totalRows_allevents = $_GET['totalRows_allevents'];
} else {
$all_allevents = mysql_query($query_allevents);
$totalRows_allevents = mysql_num_rows($all_allevents);
}
$totalPages_allevents = ceil($totalRows_allevents/$maxRows_allevents)-1;
?>

Date	Events	Host	More info	Host id
			Click Here

mysql_free_result($allevents);
include(XOOPS_ROOT_PATH."/footer.php");

?>
+++++++++++++++++++++end code++++++++++++++++++++++++++++++

I had to load the page up in the directory xoops/html/show_records.php I will have to tweak the page and refer to the css file with in the theme but how will I like the page to the navigation to make it look all the same. I also need to fix the link so that each link will point to a flyer.

View results here

Thanks guys.

Quote:

Run a php script with the phpinfo() function in it, and you will see an entry "error_log", that is where your php error log is.

Quote:

1. There will be more load on the server 'turning php on and off' unecessarily. The first few lines of code need to be replaced by ...



2. Remove this code at the top ..



and this code at the bottom, ..



it's not needed.