Announcement

**Psionicsin** · Aug 17, 2011, 12:37 PM

We currently have a page that takes the information of a person fed into it and displays:

1. The name of the individual.
2. How many votes they have.

Here's the coding:

PHP Code:


<!DOCTYPE html>
<html lang="en">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width; initial-scale=1.0;" />
<meta name="author" content="Brandon Moner" />
<script type="text/javascript" type="text/javascript" src="js/jquery-1.6.1.min.js"></script>
<link rel="stylesheet" type="text/css" href="css/style.css" />

<title>Ruth Olson Photography</title>
</head>

<body>

<header>
    <div class="top">
        <div class="contents">
            <h1><a href="index.php">Ruth Olson Photography</a></h1>
        </div>
    </div>
</header>

<?php
require_once('templates/mysql_connect.php');

/////////////
function escape_data ($data)
{
    global $dbc;
    
    if(ini_get('magic_quotes_gpc'))
    $data = stripslashes($data);
    
    return mysql_real_escape_string($data, $dbc);    
}
////////////

$ip=$_SERVER['REMOTE_ADDR'];

$queryIP = "SELECT INET_NTOA('ip') FROM ips WHERE ip=INET_ATON('$ip')";
$resultIP = mysql_query ($queryIP);
$existIP = mysql_num_rows($resultIP);


if (isset($_COOKIE['vote']) || $existIP > 0)
{
    $message = "<b>You have already voted in this year's Senior Challenge!</b> <p>To view the rankings of the current Senior Challenge contestants, <a href=\"/voteresults.php\">click here</a></p>";
}
else
{
    //Get Senior info
    $query = "SELECT * FROM seniors WHERE sen_id=$_GET[sen_id]";
    $result = mysql_query ($query);
    $row = mysql_fetch_array ($result);

    //Tally vote
    $votes = $row['votes'] + 1;
    $queryTally = "UPDATE seniors SET votes='$votes' WHERE sen_id=$_GET[sen_id] LIMIT 1";
    $resultTally = mysql_query ($queryTally);
    
    if(isset($resultTally))
    {
        $message = "<b>Your vote has been registered!</b>  <p>Thank you for participating in the 2012 Senior Challenge.  To view the rankings of the current Senior Challenge contestants, <a href=\"/top10.php\">click here</a></p>";
        
        //Set cookie + ip
    setcookie ("vote", "yes", time()+15552000);
    $queryInsertIP = "INSERT INTO ips (ip, person) VALUES(INET_ATON('$ip'), '$row[last_name]')";
    $resultInsertIP = mysql_query ($queryInsertIP);

    }
    else
    {
        $message = "<b>Error:  Vote was not counted!</b>  <p>You have encountered an error, and your vote was NOT tallied.  Please, <a href=\"/contact.html\">contact us</a> to tally your vote.</p>";
    }
}

?>

<?php 
$page_title = 'Ruth Olson Photography - Vote Result';
$query = "SELECT * FROM seniors WHERE sen_id=$_GET[sen_id]";
$result = mysql_query ($query);
$row = mysql_fetch_array ($result);

?>

<h3><?php echo $row['first_name'], " ", $row['last_name'], " has <font style=\"color:#FF0000\">
$row[votes]</font> votes";?></h3>

<?php echo "<p>", $message. "</p>"?>

<br />

<footer class="contents">
    <p>&copy; Copyright 2003 - <?php echo date("Y") ?> Ruth Olson Photography</p>
</footer>

</body>

</html>

How can I duplicate and restructure this file in order to suit my needs for displaying the individuals name, school, photo and a voting button?

**Psionicsin** · Aug 17, 2011, 01:02 PM

So, first things first, I need to create 5 pages (A-F, G-L, M-R, S-X, Y-Z) that query last names falling within a specific range...any ideas?

**Psionicsin** · Aug 17, 2011, 01:23 PM

I was able to transform...

PHP Code:


$query = "SELECT * FROM seniors WHERE last_name LIKE 'A%' ORDER BY last_name ASC";

...into this...

PHP Code:


$query = "SELECT * FROM seniors WHERE last_name BETWEEN 'A%' and 'FZ%' ORDER BY last_name ASC";

Adding a Z after the ending letter seems to have helped include everything inbetween up until results FZ.

_________________________________________________________________________

Now, onto the hard stuff...

How can I make it so that once a name is clicked, an automatically generated page (based on a template page) will appear with the person's photo, school info and vote button? THIS is something that I'm not totally sure of and need EXTREME help with.

**Psionicsin** · Aug 17, 2011, 04:30 PM

Hmm...am I not asking a question right, or did I do something wrong? Or is this just really a stumper lol?

Announcement

Help w/ Auto-Generated Queried Voting Page

Help w/ Auto-Generated Queried Voting Page

Comment

Comment

Comment

Comment