Help to add php code to additional VB4 page

[simon157]

Hi, I've been advised to post here. I am desperately trying to add additional pages to my vb4 forum which contain a mix of php and html. I have no programming experience so am looking for someone to help me with the first page I have - I can then go off and do the rest of my pages on my own. The code I am trying to include is below. Could someone please help me??

<?php require_once('Connections2/databasecon.php'); ?>
<?php
$maxRows_usersightings = 15;
$pageNum_usersightings = 0;
if (isset($_GET['pageNum_usersightings'])) {
$pageNum_usersightings = $_GET['pageNum_usersightings'];
}
$startRow_usersightings = $pageNum_usersightings * $maxRows_usersightings;

mysql_select_db($database_databasecon, $databasecon);
$query_usersightings = "SELECT * FROM sightings ORDER BY id DESC";
$query_limit_usersightings = sprintf("%s LIMIT %d, %d", $query_usersightings, $startRow_usersightings, $maxRows_usersightings);
$usersightings = mysql_query($query_limit_usersightings, $databasecon) or die(mysql_error());
$row_usersightings = mysql_fetch_assoc($usersightings);

if (isset($_GET['totalRows_usersightings'])) {
$totalRows_usersightings = $_GET['totalRows_usersightings'];
} else {
$all_usersightings = mysql_query($query_usersightings);
$totalRows_usersightings = mysql_num_rows($all_usersightings);
}
$totalPages_usersightings = ceil($totalRows_usersightings/$maxRows_usersightings)-1;
?>
<div id="container">
<div style="padding-left: 10px; padding-top:5px;">
<a href="index.php?pageid=sightingssubmit.php"><strong>Submit a sighting </strong></a> | <a href="index.php?pageid=Sightings.php"><strong>Show all sightings </strong></a>| <a href="index.php?pageid=Sightings.php&<?php printf("%spageNum_usersightings=%d%s", $currentPage, max(0, $pageNum_usersightings - 1), $queryString_usersightings); ?>">Previous</a> | <span class="style55"><a href="index.php?pageid=Sightings.php&<?php printf("%spageNum_usersightings=%d%s", $currentPage, min($totalPages_usersightings, $pageNum_usersightings + 1), $queryString_usersightings); ?>">Next</a>

<span class="style55"> </div>
<br />
<table width="95%" border="0" align="center" bgcolor="#FCFCFC">
<tr>
<td bgcolor="#848E7B"><div align="left" class="style1">No.</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Species</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Date</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Location</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Recorder</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Details</div></td>
</tr>
<?php do { ?>
<tr>
<td width="30" valign="top" bgcolor="#FFFff4"><div align="left" class="style131 "> <?php echo $row_usersightings['id']; ?></div></td>
<td width="150" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"><?php echo $row_usersightings['species']; ?></div></td>
<td width="50" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"><?php echo $row_usersightings['date']; ?></div></td>
<td width="120" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"><?php echo $row_usersightings['location']; ?></div></td>
<td width="100" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"><?php echo $row_usersightings['recorder']; ?></div></td>
<td width="350" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"><?php echo $row_usersightings['Notes']; ?></div></td>
</tr>
<?php } while ($row_usersightings = mysql_fetch_assoc($usersightings)); ?>
</table>
</div>

This link shows the output from the code which I want to integrate into my forum layout.

http://back-garden-moths.co.uk/Sightings.php

Thanks very much.

Simon

--------------- Added 1262417777 at 1262417777 ---------------

Can nobody help me with this please. I'd really like to get a handle on this so I can proceed with my site. Thanks very much..

[Lynne]

Basically, you want to put this in your page:
require_once('Connections2/databasecon.php');
$maxRows_usersightings = 15;
$pageNum_usersightings = 0;
if (isset($_GET['pageNum_usersightings'])) {
$pageNum_usersightings = $_GET['pageNum_usersightings'];
}
$startRow_usersightings = $pageNum_usersightings * $maxRows_usersightings;

mysql_select_db($database_databasecon, $databasecon);
$query_usersightings = "SELECT * FROM sightings ORDER BY id DESC";
$query_limit_usersightings = sprintf("%s LIMIT %d, %d", $query_usersightings, $startRow_usersightings, $maxRows_usersightings);
$usersightings = mysql_query($query_limit_usersightings, $databasecon) or die(mysql_error());
$row_usersightings = mysql_fetch_assoc($usersightings);

if (isset($_GET['totalRows_usersightings'])) {
$totalRows_usersightings = $_GET['totalRows_usersightings'];
} else {
$all_usersightings = mysql_query($query_usersightings);
$totalRows_usersightings = mysql_num_rows($all_usersightings);
}
$totalPages_usersightings = ceil($totalRows_usersightings/$maxRows_usersightings)-1;

$newTemplate = vB_Template::create('your_template');
$newTemplate->register('row_usersightings', $row_usersightings);
$newTemplate->render();

And this in your template your_template:
<div id="container">
<div style="padding-left: 10px; padding-top:5px;">
<a href="index.php?pageid=sightingssubmit.php"><strong>Submit a sighting </strong></a> | <a href="index.php?pageid=Sightings.php"><strong>Show all sightings </strong></a>| <a href="index.php?pageid=Sightings.php&*something_here*">Previous</a> | <span class="style55"><a href="index.php?pageid=Sightings.php&*something_here*">Next</a>

<span class="style55"> </div>
<br />
<table width="95%" border="0" align="center" bgcolor="#FCFCFC">
<tr>
<td bgcolor="#848E7B"><div align="left" class="style1">No.</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Species</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Date</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Location</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Recorder</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Details</div></td>
</tr>
<?php do { ?>
<tr>
<td width="30" valign="top" bgcolor="#FFFff4"><div align="left" class="style131 "> {vb:raw row_usersightings.id}</div></td>
<td width="150" valign="top" bgcolor="#FFFff4"><div align="left" class="style131">{vb:raw row_usersightings.species}</div></td>
<td width="50" valign="top" bgcolor="#FFFff4"><div align="left" class="style131">{vb:raw row_usersightings.date}</div></td>
<td width="120" valign="top" bgcolor="#FFFff4"><div align="left" class="style131">{vb:raw row_usersightings.location}</div></td>
<td width="100" valign="top" bgcolor="#FFFff4"><div align="left" class="style131">{vb:raw row_usersightings.recorder}</div></td>
<td width="350" valign="top" bgcolor="#FFFff4"><div align="left" class="style131">{vb:raw row_usersightings.Notes}</div></td>
</tr>
*something here*
</table>
</div>That is just some of the basics. I didn't do anything with the other php code you had in the middle of your html - you'll need to put that in the php page like all the other stuff, but this is the basics of what to put into the other page you started with the article. If you need someone to do the whole thing for you, you may want to post in Paid Services.