vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Help to add php code to additional VB4 page (https://vborg.vbsupport.ru/showthread.php?t=231825)

simon157 01-01-2010 03:25 PM
Help to add php code to additional VB4 page
 
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 Code:
<?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 [DATE]1262417777[/DATE] at [TIME]1262417777[/TIME] ---------------

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 01-02-2010 06:01 PM
Basically, you want to put this in your page:
PHP Code:
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:
HTML Code:
<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.


All times are GMT. The time now is 05:57 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01107 seconds
  • Memory Usage 1,785KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_html_printable
  • (2)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete