PHP - Moved: Wordpress Page Template Not Making Much Sense To Me :/

Hey guys,   Wordpress has the ability to recognize a custom page and make it available to select it and use when you are logged in in the pages section of the admin ui. To make it work you add this:

<?php
/*
 * Template Name: My Custom Page
 * Description: A Page Template with a darker design.
 */

// Code to display Page goes here...

My question is how does wordpress scan and find these files and then show them in a drop down menu on the pages tab of the admin? Is it done with regular expressions?   Many thanks for any help!

People upload photos to my site. They go into a gallery. They are all linked. Right now when you click one they go nowhere. I want to be each photo to open in its own page with my comment system already on it. Should I be using templates? If so how? Heres code to the gallery page if needed.

And I'm using dreamweavers server behaviors. If that will cause a problem let me know. Still new to PHP but getting better...maybe.

Sorry to keep asking noob questions.

Code: [Select]
<?php require_once('myconn.php'); 

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$maxRows_Recordset1 = 40;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_myconn, $myconn);
$query_Recordset1 = "SELECT name, photopath, `state` FROM photo";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $myconn) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>

<div id="photos">
  <table border="">
  <?php $i=0; $numperpage=8; ?>
    <?php do { ?>
    <?php if ($i%$numperpage==0) echo "<tr>"; ?>
        <td align="center">
        <a href=<?php echo $row_Recordset1['photopath']; ?>/>
        <img src=<?php echo $row_Recordset1['photopath']; ?> height="200" width="200"/>

<br/>

<?php echo $row_Recordset1['name']; ?><br/> <?php echo $row_Recordset1['state']; ?></td>
<?php $i++; if ($i%$numperpage==0) echo "</tr>"; ?>

       
     
      <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
  </table>
</div>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

I am doing more practice, and I am trying to interpret the WHY on some certain aspects of this script. I can get it to work and it works as expected, but I am not sure what it works (got most of it sorted it).. Here is my first question:

Question 0. About 3/4 down the script: ($i = 0; $i < $cols; $i++) - cannot understand why $i < $cols is less operator? Shouldn't it be >= cause if it's less won't it miss a record?

Question 1. About 3/4 down the script: echo $x = ($i * $rows) + $j;
I do not understand what purpose this serves. I echoed the results and it's just scattered multiplication large numbers!

You'll see that im echoing out all kinds of data, just so I can see what's going on.

<?php
  $host = "localhost";
  $user = "root";
  $pass = "";
  $db = "simple_mysql";
  $cxn = mysqli_connect($host, $user, $pass, $db) or die("Could not connect to the server.");
  $query = "SELECT * FROM all_illinois";
  $result = mysqli_query($cxn, $query) or die(mysqli_error());
  $results = array();
  while ($row = mysqli_fetch_assoc($result))
      $results[] = $row;
  // output: Array
  echo $results . "<br />";
  $cols = 3;
  // output: 3  
  echo $cols . "<br />";
  $rows = ceil(count($results) / $cols);
  // output: 1300
  echo(count($results)) . "<br />";
  // output: 3
  echo $cols . "<br />";
  // output: 434
  echo $rows . "<br />";
  echo '<table style="text-align:left;margin-left:0px;width:500px;">' . "\n";
  for ($j = 0; $j < $rows; $j++) {
      echo "  <tr>\n";
      for ($i = 0; $i < $cols; $i++) {
          echo $x = ($i * $rows) + $j;
          echo $i . "<br />";
          if (isset($results[$x])) {
              $row = $results[$x];
              echo $row . "<br />";
              echo '    <td><a href="' . $row['state_id'] . '/' . $row['city_name'] . '">' . $row['city_name'] . "</a></td>\n";
          } else {
              echo "    <td></td>\n";
          }
      }
      echo " </tr>\n";
  }
  echo '</table>';
?>

Here is a smaller portion of table dump if it helps at all:

--
-- Table structure for table `all_illinois`
--

CREATE TABLE IF NOT EXISTS `all_illinois` (
  `state_id` varchar(255) NOT NULL,
  `city_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `all_illinois`
--

INSERT INTO `all_illinois` (`state_id`, `city_name`) VALUES
('135', 'Abingdon'),
('135', 'Adair'),
('135', 'Addieville'),
('135', 'Addison'),
('135', 'Adrian'),
('135', 'Akin'),
('135', 'Albany'),
('135', 'Albers'),
('135', 'Albion'),
('135', 'Alden'),
('135', 'Aledo'),
('135', 'Alexander'),
('135', 'Alexis'),
('135', 'Algonquin'),
('135', 'Alhambra'),
('135', 'Allendale'),
('135', 'Allerton'),
('135', 'Alma'),
('135', 'Alpha'),
('135', 'Alsey'),
('135', 'Alsip'),
('135', 'Altamont'),
('135', 'Alto Pass'),
('135', 'Alton'),
('135', 'Altona'),
('135', 'Alvin'),
('135', 'Amboy'),
('135', 'Anchor'),
('135', 'Ancona'),
('135', 'Andalusia'),
('135', 'Andover'),
('135', 'Anna'),
('135', 'Annapolis'),
('135', 'Annawan'),
('135', 'Antioch'),
('135', 'Apple River'),
('135', 'Arcola'),
('135', 'Arenzville'),
('135', 'Argenta'),
('135', 'Arlington'),
('135', 'Arlington Heights'),
('135', 'Armington'),
('135', 'Armstrong'),
('135', 'Aroma Park'),
('135', 'Arrowsmith'),
('135', 'Arthur'),
('135', 'Ashkum'),
('135', 'Ashland'),
('135', 'Ashley'),
('135', 'Ashmore'),
('135', 'Ashton'),
('135', 'Assumption'),
('135', 'Astoria'),
('135', 'Athens'),
('135', 'Atkinson'),
('135', 'Atlanta'),
('135', 'Atwater'),
('135', 'Atwood'),
('135', 'Auburn'),
('135', 'Augusta'),
('135', 'Aurora'),
('135', 'Ava'),
('135', 'Aviston'),
('135', 'Avon'),
('135', 'Baileyville'),
('135', 'Baldwin'),
('135', 'Bardolph'),
('135', 'Barnhill'),
('135', 'Barrington'),
('135', 'Barry'),
('135', 'Barstow'),
('135', 'Bartelso'),
('135', 'Bartlett'),
('135', 'Basco'),
('135', 'Batavia'),
('135', 'Batchtown'),
('135', 'Bath'),
('135', 'Baylis'),
('135', 'Beardstown'),
('135', 'Beason'),
('135', 'Beaverville'),
('135', 'Beckemeyer'),
('135', 'Bedford Park'),
('135', 'Beecher'),
('135', 'Beecher City'),
('135', 'Belknap'),
('135', 'Belle Rive'),
('135', 'Belleview'),
('135', 'Belleville'),
('135', 'Bellflower'),
('135', 'Bellmont'),
('135', 'Bellwood'),
('135', 'Belvidere'),
('135', 'Bement'),
('135', 'Benld'),
('135', 'Bensenville'),
('135', 'Benson'),
('135', 'Benton'),
('135', 'Berkeley'),
('135', 'Berwick');

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=356195.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=349030.0