Jump to content

what is wrong with this code?

searls03

By searls03
in PHP Coding Help

 Share

Recommended Posts

searls03 Advanced Member

searls03

Posted
Posted

here is code:

<?php
session_start(); // Must start session first thing
/* 
Created By Adam Khoury @ www.flashbuilding.com 
-----------------------June 20, 2008----------------------- 
*/
// Here we run a login check
if (!isset($_SESSION['id'])) { 
   echo 'Please <a href="login.php">log in</a> to access your account';
   exit(); 
}
//Connect to the database through our include 
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$userid = $_SESSION['id'];
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$name = $row["name"];
$phone = $row["phone"];
$username = $row["username"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
$accounttype = $row["accounttype"];
$rank = $row["rank"];
$badges = $row["badges"];
}
// Set error message as blank upon arrival to page
$errorMsg = "";
// First we check to see if the form has been submitted 
if (isset($_POST['username'])){
$name = ereg_replace("[^A-Z a-z0-9]", "", $_POST['name']); // filter everything but numbers and letters
$phone = ereg_replace("[^A-Z a-z0-9]", "", $_POST['phone']); // filter everything but spaces, numbers, and letters
$username = ereg_replace("[^A-Z a-z0-9]", "", $_POST['username']); // filter everything but spaces, numbers, and letters
$address = ereg_replace("[^A-Z a-z0-9]", "", $_POST['address']); // filter everything but spaces, numbers, and letters
$city = ereg_replace("[^A-Za-z0-9]", "", $_POST['city']); // filter everything but lowercase letters
$state = ereg_replace("[^A-Za-z0-9]", "", $_POST['state']); // filter everything but lowercase letters
$zip = ereg_replace("[^A-Za-z0-9]", "", $_POST['zip']); // filter everything but lowercase letters
$cell = ereg_replace("[^A-Za-z0-9]", "", $_POST['cell']); // filter everything but lowercase letters
$email = stripslashes($_POST['email']);
$email = strip_tags($email);
$email = mysql_real_escape_string($email);

if((!$email)){

	$errorMsg = "You did not submit the following required information!<br /><br />";

    if(!$email){ 
       $errorMsg .= "--- Email Address"; 
    
   }
} else {		$sql = mysql_query("INSERT INTO events (name, phone, username, address, city, state, zip, cell, email) 

	VALUES('$name','$phone','$username','$address','$city','$state','$zip','$cell','$email") or die (mysql_error());

	$to = "$email";
	// Change this to your site admin email
	$from = "events@final.net46.net";
	$subject = "Complete your registration";
	//Begin HTML Email Message where you need to change the activation URL inside
	$message = '<html>
	<body bgcolor="#FFFFFF">
	Hi ' . $username . ',
	<br /><br />
	You must complete this step to activate your account with us.
	<br /><br />
	Please click here to activate now >>
	<a href="http://www.somewebsite.com/activation.php?id=' . $id . '">
	ACTIVATE NOW</a>
	<br /><br />
	Your Login Data is as follows: 
	<br /><br />
	E-mail Address: ' . $email . ' <br />
	Password: ' . $password . ' 
	<br /><br /> 
	Thanks! 
	</body>
	</html>';
	// end of message
	$headers = "From: $from\r\n";
	$headers .= "Content-type: text/html\r\n";
	$to = "$to";
	// Finally send the activation email to the member
	mail($to, $subject, $message, $headers);
	// Then print a message to the browser for the joiner 
	print "<br /><br /><br /><h4>OK $firstname, one last step to verify your email identity:</h4><br />
	We just sent an Activation link to: $email<br /><br />
	<strong><font color=\"#990000\">Please check your email inbox in a moment</font></strong> to click on the Activation <br />
	Link inside the message. After email activation you can log in.";


	exit(); // Exit so the form and page does not display, just this success message
} // Close else after database duplicate field value checks
  } // Close else after missing vars check
//Close if $_POST


?>
<?php


// if no id is specified, list the available articles
if(!isset($_GET['eventid']))
{
   $self = $_SERVER['PHP_SELF'];

   $query = "SELECT eventid, event FROM Registration ORDER BY eventid";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list
   $description = '<ol>';
   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($eventid, $event, $date) = $row;
      $description .= "<li><a href=\"$self?eventid=$eventid\">$event</a></li>\r\n";
   }

   $description .= '</ol>';

   $Events = 'Events';
} else {
   // get the article info from database
     $query = "SELECT event, description, startdate, enddate location, subevent1, subevent2, subevent3, subevent4, subevent5, subevent6, subevent7, subevent8, price1, price2, price3, price4, price5, price6, price7, price8 FROM Registration WHERE eventid=".$_GET['eventid'];
   $result = mysql_query($query) or die('Error : ' . mysql_error());
   $row = mysql_fetch_array($result, MYSQL_ASSOC);

  $event = $row['event'];
   $description = $row['description'];
   $startdate = $row['startdate'];
     $enddate = $row['enddate'];

     $location = $row['location'];
 $subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];

$price1 = $row['price1'];
$price2 = $row['price2'];
$price3 = $row['price3'];
$price4 = $row['price4'];
$price5 = $row['price5'];
$price6 = $row['price6'];
$price7 = $row['price7'];
$price8 = $row['price8'];
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Register</title>
<style type="text/css">
#apDiv1 {
position:absolute;
left:33px;
top:320px;
width:252px;
height:48px;
z-index:1;
}
#apDiv2 {
position:absolute;
left:33px;
top:361px;
width:254px;
height:46px;
z-index:2;
}
#apDiv3 {
position:absolute;
left:33px;
top:525px;
width:256px;
height:43px;
z-index:3;
}
#apDiv4 {
position:absolute;
left:33px;
top:402px;
width:250px;
height:48px;
z-index:4;
}
#apDiv5 {
position:absolute;
left:106px;
top:616px;
width:263px;
height:255px;
z-index:5;
}
#apDiv6 {
position:absolute;
left:323px;
top:200px;
width:898px;
height:530px;
z-index:5;
}
#apDiv7 {
position:absolute;
left:33px;
top:443px;
width:266px;
height:42px;
z-index:6;
}
#apDiv8 {
position:absolute;
left:111px;
top:500px;
width:125px;
height:37px;
z-index:7;
}
#apDiv8 strong {
font-size: 24px;
}
#apDiv9 {
position:absolute;
left:33px;
top:408px;
width:267px;
height:49px;
z-index:8;
}
#apDiv10 {
position:absolute;
left:33px;
top:449px;
width:242px;
height:23px;
z-index:9;
}
#apDiv8 a {
color: #000;
}
#apDiv11 {
position:absolute;
left:101px;
top:490px;
width:168px;
height:42px;
z-index:10;
font-size: 24px;
font-weight: bold;
}
#apDiv11 a {
color: #000;
}
#apDiv12 {
position:absolute;
left:33px;
top:210px;
width:205px;
height:107px;
z-index:11;
}
#apDiv12 {
text-align: center;
}
#apDiv13 {
position:absolute;
left:33px;
top:320px;
width:248px;
height:47px;
z-index:12;
}
#apDiv {
position:absolute;
left:33px;
top:484px;
width:225px;
height:35px;
z-index:11;
}
#apDiv14 {
position:absolute;
left:33px;
top:566px;
width:298px;
height:51px;
z-index:12;
}
#apDiv15 {	position:absolute;
left:101px;
top:611px;
width:168px;
height:42px;
z-index:10;
font-size: 24px;
font-weight: bold;
}
#apDiv5 a {
font-size: 24px;
color: #000;
font-weight: bold;
}
#apDiv23 table tr td1 {
font-size: 14px;
}
</style>
<script type="text/javascript">
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
</script>

<style type="text/css">
#apDiv6 #form1 table tr th {
text-align: center;
}
#apDiv6 table tr td table tr td {
text-align: center;
}
#apDiv16 {
position:absolute;
left:330px;
top:45px;
width:208px;
height:100px;
z-index:13;
}
#apDiv6 table tr td #apDiv16 table tr th {
font-size: 36px;
}
#apDiv17 {
position:absolute;
left:183px;
top:342px;
width:427px;
height:65px;
z-index:13;
}
#apDiv6 table tr td #Accordion1 .AccordionPanel.AccordionPanelOpen .AccordionPanelContent #apDiv17 table tr th {
color: #999;
}
</style>

<style type="text/css">

#apDiv19 {
position:absolute;
left:33px;
top:320px;
width:271px;
height:33px;
z-index:13;
}
#apDiv20 {
position:absolute;
left:578px;
top:368px;
width:157px;
height:87px;
z-index:14;
}
#apDiv21 {
position:absolute;
left:8px;
top:705px;
width:270px;
height:683px;
z-index:15;
}
#apDiv22 {
position:absolute;
left:476px;
top:313px;
width:596px;
height:124px;
z-index:16;
}
#apDiv6 table tr td table tr th {
text-align: left;
}
#apDiv23 {
position:absolute;
left:626px;
top:250px;
width:247px;
height:85px;
z-index:16;
text-align: center;
font-size: 36px;
}
#apDiv23 table tr td {
text-align: center;
font-size: 24px;
}
#apDiv24 {
position:absolute;
left:626px;
top:295px;
width:247px;
height:63px;
z-index:17;
text-align: center;
font-size: 20px;
}
.klgjsa {
font-size: 18px;
}
#apDiv24 {
font-size: 16px;
}
#apDiv24 {
font-size: 18px;
}
#apDiv24 {
color: #C90;
}
</style>


</head>
<body onload="MM_preloadImages('button/pictures2.png','button/projects1.png','button/news2.png','button/eventmanager2.png','button/membermanager2.png','button/newsmanager2.png','button/myprofile2.png')">
<div id="apDiv6">
<table width="600" border="0" align="center" cellpadding="10" cellspacing="1" bgcolor="#336699">
  <tr>
  <td bgcolor="#FFFFFF"><h1 align="center"><?php echo $Events; ?></h1>
  <p> </p>
  <p> </p>
  <p><?php echo $description; ?></p>
    
  <p> </p>
    
  <p> </p>
  <?php
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$name = $row["name"];
$phone = $row["phone"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
}
$sql = mysql_query("SELECT * FROM Registration WHERE eventid=".$_GET['eventid']." LIMIT 1");
while($row = mysql_fetch_array($sql)){
$event= $row["event"];
$subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];

$price1 = $row['price1'];
$price2 = $row['price2'];
$price3 = $row['price3'];
$price4 = $row['price4'];
$price5 = $row['price5'];
$price6 = $row['price6'];
$price7 = $row['price7'];
$price8 = $row['price8'];
}
?>
  <?php
// when displaying an article show a link
// to see the article list
if(isset($_GET['eventid']))
{
?>
  <div id="jQueryUIAccordion">
<h3> </h3>
<div>
	<p>

    
    <table width="575" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th width="563" bgcolor="#999999" scope="col">Location</th>
        </tr>
      </table>
    <table width="574" height="16" border="0" cellpadding="2" cellspacing="2">
      <tr>
        <th height="12" scope="col"><?php echo $location; ?></th>
        </tr>
      </table>
    <table width="573" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th width="561" bgcolor="#999999" scope="col">Description</th>
        </tr>
      </table>
    <table width="576" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th width="564" height="11" scope="col"><?php echo $title1; ?><br /><?php echo $price1; ?></th>
        <th width="564" scope="col"><?php echo $subevent1; ?></th>
        

        </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title2; ?><br /><?php echo $price2; ?></th>
        <th scope="col"><?php echo $subevent2; ?> </th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title3; ?><br /><?php echo $price3; ?></th>
        <th scope="col"><?php echo $subevent3; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title4; ?><br /><?php echo $price4; ?></th>
        <th scope="col"><?php echo $subevent4; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title5; ?><br /><?php echo $price5; ?></th>
        <th scope="col"><?php echo $subevent5; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title6; ?><br /><?php echo $price6; ?></th>
        <th scope="col"><?php echo $subevent6; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title7; ?><br /><?php echo $price7; ?></th>
        <th scope="col"><?php echo $subevent7; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title8; ?><br /><?php echo $price8; ?></th>
        <th scope="col"><?php echo $subevent8; ?></th>
      </tr>
      </table>
    <hr />
    <table width="200" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th scope="col">Price:</th>
        </tr>
      </table>
    <table width="200" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th scope="col">$<?php echo  $price; ?></th>
        </tr>
      </table>
	</p>
	<?php
if (isset($_GET['eventid'])) {
include('connect1.php');
$sql = mysql_query("SELECT * FROM Registration WHERE eventid='$eventid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$eventid = $row["eventid"];
$event = $row["event"];
$date = $row["date"];
$description = $row["description"];
$location = $row["location"];
}
$result = mysqli_query($dbcon, $query) or die('error getting data');

echo "<table>";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
echo "<tr><td>";
echo "<a href=\"registration.php?eventid=".$_GET['eventid']."\"><ul>Register Now!</ul></a>";
echo "</td></tr>";
}
echo "</table>";

}
?>

    
    
    
    
    


  
    
    
  <div id="apDiv18"></div>
  <p align="center"><a href="<?php echo $_SERVER['PHP_SELF']; ?>">Back to Events</a></p>
    
    
    
  <?php
}
?></td></tr>
</table>


</div><div id="apDiv2"><a href="register.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image3','','button/register2.png',1)"><img src="button/register1.png" name="Image3" width="235" height="50" border="0" id="Image3" /></a></div>
<div id="apDiv4"><a href="projects.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image4','','button/projects2.png',1)"><img src="button/projects1.png" name="Image4" width="235" height="50" border="0" id="Image4" /></a></div>

<div id="apDiv11"><?php if ($accounttype == "Scout") {
echo '<a href="../logout.php">Logout</a>';} ?></div>
<div id="apDiv12"><?php echo "$accounttype"; ?>
  <p><?php echo "$name"; ?></p>
  <p>Troop 78</p>
</div>

<div id="apDiv5"><?php if ($accounttype == "Admin") {
echo "<a href=\"../logout.php\">Logout</a>";
}
?></div>


<div id="apDiv7"><a href="news.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image6','','button/news2.png',1)"><img src="button/news1.png" name="Image6" width="235" height="50" border="0" id="Image6" /></a></div>
<div id="apDiv"> <?php if ($accounttype == "Admin") {
echo "<a href=\"../search1.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image7','','../button/membermanager2.png',1)\"><img src=\"../button/membermanager1.png\" name=\"Image7\" width=\"235\" height=\"50\" border=\"0\" id=\"Image7\" /></a>";
} 
?></div>
<div id="apDiv3"><?php if ($accounttype == "Admin") {
echo "<a href=\"../eventmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image8','','../button/eventmanager2.png',1)\"><img src=\"../button/eventmanager1.png\"  name=\"Image8\" width=\"235\" height=\"50\" border=\"0\" id=\"Image8\" /></a>";
}
?>
</div>
<div id="apDiv14"><?php if ($accounttype == "Admin") {
echo "<a href=\"../newsmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image9','','../button/newsmanager2.png',1)\"><img src=\"../button/newsmanager1.png\"  name=\"Image9\" width=\"235\" height=\"50\" border=\"0\" id=\"Image9\" /></a>";
}
?>
</div>

<div id="apDiv19"><a href="myprofile.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image5','','button/myprofile2.png',1)"><img src="button/myprofile1.png" name="Image5" width="235" height="50" border="0" id="Image5" /></a></div>
<div id="apDiv21"><img src="button/red.png" width="282" height="687" /></div>
<div id="apDiv23"><?php echo $event; ?> <br /> 
</div>
<div id="apDiv24"><?php echo $startdate;?> <span class="klgjsa">-</span> <?php echo $enddate; ?></div>
<img name="boyscout" src="buttons/boyscout.jpg" width="1180" height="700" border="0" id="boyscout" alt="" />
</body>
</html>

 

here is error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a6254834/public_html/register.php on line 469

 

help?

Link to comment
Share on other sites
searls03 Advanced Member

searls03

Posted
  • Author
Posted

ok got it working......now some of my echo's don't show up.............this is a pain................................... I will turn the problem purple, sorry this isn't in code tags.  If this doesn't make sense, let me know and i will try to explain it better......:

 

 

<?php

session_start(); // Must start session first thing

/*

Created By Adam Khoury @ www.flashbuilding.com

-----------------------June 20, 2008-----------------------

*/

// Here we run a login check

if (!isset($_SESSION['id'])) {

  echo 'Please <a href="login.php">log in</a> to access your account';

  exit();

}

//Connect to the database through our include

include_once "connect_to_mysql.php";

// Place Session variable 'id' into local variable

$userid = $_SESSION['id'];

// Query member data from the database and ready it for display

$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");

while($row = mysql_fetch_array($sql)){

$name = $row["name"];

$phone = $row["phone"];

$username = $row["username"];

$address = $row["address"];

$city = $row["city"];

$state = $row["state"];

$zip = $row["zip"];

$cell = $row["cell"];

$email = $row["email"];

$accounttype = $row["accounttype"];

$rank = $row["rank"];

$badges = $row["badges"];

}

// Set error message as blank upon arrival to page

$errorMsg = "";

// First we check to see if the form has been submitted

if (isset($_POST['username'])){

$name = ereg_replace("[^A-Z a-z0-9]", "", $_POST['name']); // filter everything but numbers and letters

$phone = ereg_replace("[^A-Z a-z0-9]", "", $_POST['phone']); // filter everything but spaces, numbers, and letters

$username = ereg_replace("[^A-Z a-z0-9]", "", $_POST['username']); // filter everything but spaces, numbers, and letters

$address = ereg_replace("[^A-Z a-z0-9]", "", $_POST['address']); // filter everything but spaces, numbers, and letters

$city = ereg_replace("[^A-Za-z0-9]", "", $_POST['city']); // filter everything but lowercase letters

$state = ereg_replace("[^A-Za-z0-9]", "", $_POST['state']); // filter everything but lowercase letters

$zip = ereg_replace("[^A-Za-z0-9]", "", $_POST['zip']); // filter everything but lowercase letters

$cell = ereg_replace("[^A-Za-z0-9]", "", $_POST['cell']); // filter everything but lowercase letters

$email = stripslashes($_POST['email']);

$email = strip_tags($email);

$email = mysql_real_escape_string($email);

 

if((!$email)){

 

$errorMsg = "You did not submit the following required information!<br /><br />";

 

    if(!$email){

      $errorMsg .= "--- Email Address";

   

  }

} else { $sql = mysql_query("INSERT INTO events (name, phone, username, address, city, state, zip, cell, email)

 

VALUES('$name','$phone','$username','$address','$city','$state','$zip','$cell','$email") or die (mysql_error());

 

$to = "$email";

// Change this to your site admin email

$from = "events@final.net46.net";

$subject = "Complete your registration";

//Begin HTML Email Message where you need to change the activation URL inside

$message = '<html>

<body bgcolor="#FFFFFF">

Hi ' . $username . ',

<br /><br />

You must complete this step to activate your account with us.

<br /><br />

Please click here to activate now >>

<a href="http://www.somewebsite.com/activation.php?id=' . $id . '">

ACTIVATE NOW</a>

<br /><br />

Your Login Data is as follows:

<br /><br />

E-mail Address: ' . $email . ' <br />

Password: ' . $password . '

<br /><br />

Thanks!

</body>

</html>';

// end of message

$headers = "From: $from\r\n";

$headers .= "Content-type: text/html\r\n";

$to = "$to";

// Finally send the activation email to the member

mail($to, $subject, $message, $headers);

// Then print a message to the browser for the joiner

print "<br /><br /><br /><h4>OK $firstname, one last step to verify your email identity:</h4><br />

We just sent an Activation link to: $email<br /><br />

<strong><font color=\"#990000\">Please check your email inbox in a moment</font></strong> to click on the Activation <br />

Link inside the message. After email activation you can log in.";

 

 

exit(); // Exit so the form and page does not display, just this success message

} // Close else after database duplicate field value checks

  } // Close else after missing vars check

//Close if $_POST

 

 

?>

<?php

 

 

// if no id is specified, list the available articles

if(!isset($_GET['eventid']))

{

  $self = $_SERVER['PHP_SELF'];

 

  $query = "SELECT eventid, event, startdate, enddate FROM Registration ORDER BY eventid";

  $result = mysql_query($query) or die('Error : ' . mysql_error());

 

  // create the article list

 

  while($row = mysql_fetch_array($result, MYSQL_NUM))

  {

      list($eventid, $event, $startdate, $enddate) = $row;

 

      $as = "<a href=\"$self?eventid=$eventid\">$startdate - $enddate --- $event</a>\r\n";

  }

 

 

  $Events = 'Events';

} else {

  // get the article info from database

    $query = "SELECT event, description, startdate, enddate, location, subevent1, subevent2, subevent3, subevent4, subevent5, subevent6, subevent7, subevent8, price1, price2, price3, price4, price5, price6, price7, price8 FROM Registration WHERE eventid=".$_GET['eventid'];

  $result = mysql_query($query) or die('Error : ' . mysql_error());

  $row = mysql_fetch_array($result, MYSQL_ASSOC);

$event= $row["event"];

$subevent1 = $row['subevent1'];

$subevent2 = $row['subevent2'];

$subevent3 = $row['subevent3'];

$subevent4 = $row['subevent4'];

$subevent5 = $row['subevent5'];

$subevent6 = $row['subevent6'];

$subevent7 = $row['subevent7'];

$subevent8 = $row['subevent8'];

$title1 = $row['title1'];

$title2 = $row['title2'];

$title3 = $row['title3'];

$title4 = $row['title4'];

$title5 = $row['title5'];

$title6 = $row['title6'];

$title7 = $row['title7'];

$title8 = $row['title8'];

$price1 = $row['price1'];

$price2 = $row['price2'];

$price3 = $row['price3'];

$price4 = $row['price4'];

$price5 = $row['price5'];

$price6 = $row['price6'];

$price7 = $row['price7'];

$price8 = $row['price8'];

$date1 = $row['date1'];

$date2 = $row['date2'];

$date3 = $row['date3'];

$date4 = $row['date4'];

$date5 = $row['date5'];

$date6 = $row['date6'];

$date7 = $row['date7'];

$date8 = $row['date8'];

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

<title>Register</title>

<style type="text/css">

#apDiv1 {

position:absolute;

left:33px;

top:320px;

width:252px;

height:48px;

z-index:1;

}

#apDiv2 {

position:absolute;

left:33px;

top:361px;

width:254px;

height:46px;

z-index:2;

}

#apDiv3 {

position:absolute;

left:33px;

top:525px;

width:256px;

height:43px;

z-index:3;

}

#apDiv4 {

position:absolute;

left:33px;

top:402px;

width:250px;

height:48px;

z-index:4;

}

#apDiv5 {

position:absolute;

left:106px;

top:616px;

width:263px;

height:255px;

z-index:5;

}

#apDiv6 {

position:absolute;

left:327px;

top:277px;

width:898px;

height:1097px;

z-index:5;

}

#apDiv7 {

position:absolute;

left:33px;

top:443px;

width:266px;

height:42px;

z-index:6;

}

#apDiv8 {

position:absolute;

left:111px;

top:500px;

width:125px;

height:37px;

z-index:7;

}

#apDiv8 strong {

font-size: 24px;

}

#apDiv9 {

position:absolute;

left:33px;

top:408px;

width:267px;

height:49px;

z-index:8;

}

#apDiv10 {

position:absolute;

left:33px;

top:449px;

width:242px;

height:23px;

z-index:9;

}

#apDiv8 a {

color: #000;

}

#apDiv11 {

position:absolute;

left:101px;

top:490px;

width:168px;

height:42px;

z-index:10;

font-size: 24px;

font-weight: bold;

}

#apDiv11 a {

color: #000;

}

#apDiv12 {

position:absolute;

left:33px;

top:210px;

width:205px;

height:107px;

z-index:11;

}

#apDiv12 {

text-align: center;

}

#apDiv13 {

position:absolute;

left:33px;

top:320px;

width:248px;

height:47px;

z-index:12;

}

#apDiv {

position:absolute;

left:33px;

top:484px;

width:225px;

height:35px;

z-index:11;

}

#apDiv14 {

position:absolute;

left:33px;

top:566px;

width:298px;

height:51px;

z-index:12;

}

#apDiv15 { position:absolute;

left:101px;

top:611px;

width:168px;

height:42px;

z-index:10;

font-size: 24px;

font-weight: bold;

}

#apDiv5 a {

font-size: 24px;

color: #000;

font-weight: bold;

}

#apDiv23 table tr td1 {

font-size: 14px;

}

</style>

<script type="text/javascript">

function MM_swapImgRestore() { //v3.0

  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;

}

function MM_preloadImages() { //v3.0

  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();

    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)

    if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}

}

function MM_findObj(n, d) { //v4.01

  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {

    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}

  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];

  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);

  if(!x && d.getElementById) x=d.getElementById(n); return x;

}

function MM_swapImage() { //v3.0

  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)

  if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}

}

</script>

 

<style type="text/css">

#apDiv6 #form1 table tr th {

text-align: center;

}

#apDiv6 table tr td table tr td {

text-align: center;

}

#apDiv16 {

position:absolute;

left:330px;

top:45px;

width:208px;

height:100px;

z-index:13;

}

#apDiv6 table tr td #apDiv16 table tr th {

font-size: 36px;

}

#apDiv17 {

position:absolute;

left:183px;

top:342px;

width:427px;

height:65px;

z-index:13;

}

#apDiv6 table tr td #Accordion1 .AccordionPanel.AccordionPanelOpen .AccordionPanelContent #apDiv17 table tr th {

color: #999;

}

</style>

 

<style type="text/css">

 

#apDiv19 {

position:absolute;

left:33px;

top:320px;

width:271px;

height:33px;

z-index:13;

}

#apDiv20 {

position:absolute;

left:578px;

top:368px;

width:157px;

height:87px;

z-index:14;

}

#apDiv21 {

position:absolute;

left:8px;

top:705px;

width:270px;

height:683px;

z-index:15;

}

#apDiv22 {

position:absolute;

left:476px;

top:313px;

width:596px;

height:124px;

z-index:16;

}

#apDiv6 table tr td table tr th {

text-align: left;

}

#apDiv23 {

position:absolute;

left:151px;

top:30px;

width:247px;

height:85px;

z-index:16;

text-align: center;

font-size: 36px;

}

#apDiv23 table tr td {

text-align: center;

font-size: 24px;

}

#apDiv24 {

position:absolute;

left:151px;

top:71px;

width:479px;

height:63px;

z-index:17;

text-align: center;

font-size: 20px;

}

.klgjsa {

font-size: 18px;

color: #000;

}

#apDiv24 {

font-size: 16px;

}

#apDiv24 {

font-size: 18px;

}

#apDiv24 {

color: #C90;

}

#apDiv23 {

color: #F00;

text-align: left;

}

#apDiv24 {

color: #000;

font-size: 18px;

text-align: left;

}

a:link {

color: #C90;

}

a:visited {

color: #C90;

}

a:hover {

color: #00F;

}

#apDiv6 table tr td p a {

color: #00F;

}

#apDiv25 {

position:absolute;

left:184px;

top:139px;

width:316px;

height:65px;

z-index:16;

}

.asdfsad {

color: #000;

font-size: 18px;

}

.fgsdfg {

color: #000;

font-size: 18px;

}

.adfasdf {

color: #000;

font-size: 18px;

}

.adfdas {

color: #000;

font-size: 18px;

}

afgafgd {

color: #000;

}

</style>

 

 

</head>

<body onload="MM_preloadImages('button/pictures2.png','button/projects1.png','button/news2.png','button/eventmanager2.png','button/membermanager2.png','button/newsmanager2.png','button/myprofile2.png')">

<div id="apDiv6">

<table width="600" border="0" align="center" cellpadding="10" cellspacing="1" bgcolor="#336699">

  <tr>

  <td height="1093" bgcolor="#FFFFFF"><h1 align="center"><?php echo $Events; ?></h1>

  <p> </p>

  <p> </p>

  <p><strong><?php echo $as; ?></strong> </p>

   

  <p> </p>

   

  <p> </p>

 

  <?php

// when displaying an article show a link

// to see the article list

if(isset($_GET['eventid']))

{

?>

 

  <div id="jQueryUIAccordion">

<h3> </h3>

<div>

<p>

 

    <div id="apDiv23"><?php echo $event; ?> <br />

      <span class="asdfsad">Date(s):</span> <?php echo $startdate; ?> <span class="klgjsa">-</span> <?php echo $enddate; ?><br />

      <span class="fgsdfg">Location:</span> <?php echo $location; ?><br />

      <span class="adfasdf">Description</span><span class="adfdas">:</span> <?php echo $description; ?>

</div>

    <div id="apDiv25"><?php

 

$sql = mysql_query("SELECT * FROM Registration WHERE eventid=".$_GET['eventid']." LIMIT 1");

while($row = mysql_fetch_array($sql)){

$event= $row["event"];

$subevent1 = $row['subevent1'];

$subevent2 = $row['subevent2'];

$subevent3 = $row['subevent3'];

$subevent4 = $row['subevent4'];

$subevent5 = $row['subevent5'];

$subevent6 = $row['subevent6'];

$subevent7 = $row['subevent7'];

$subevent8 = $row['subevent8'];

$title1 = $row['title1'];

$title2 = $row['title2'];

$title3 = $row['title3'];

$title4 = $row['title4'];

$title5 = $row['title5'];

$title6 = $row['title6'];

$title7 = $row['title7'];

$title8 = $row['title8'];

$price1 = $row['price1'];

$price2 = $row['price2'];

$price3 = $row['price3'];

$price4 = $row['price4'];

$price5 = $row['price5'];

$price6 = $row['price6'];

$price7 = $row['price7'];

$price8 = $row['price8'];

$date1 = $row['date1'];

$date2 = $row['date2'];

$date3 = $row['date3'];

$date4 = $row['date4'];

$date5 = $row['date5'];

$date6 = $row['date6'];

$date7 = $row['date7'];

$date8 = $row['date8'];

 

 

//this will echo the contents of each db row as they are iterated in the loop

 

#############################

if (!empty($subevent1)) { echo "<br/><strong>$title1</strong><br />$date1<br />$ $price1<br /><br />"; }

if (!empty($subevent2)) { echo "<br/><strong>$title2</strong><br />$date2<br />$ $price2<br /><br />"; }

if (!empty($subevent3)) { echo "<br/><strong>$title3</strong><br />$date3<br />$ $price3<br /><br />"; }

if (!empty($subevent4)) { echo "<br/><strong>$title4</strong><br />$date4<br />$ $price4<br /><br />"; }

if (!empty($subevent5)) { echo "<br/><strong>$title5</strong><br />$date5<br />$ $price5<br /><br />"; }

if (!empty($subevent6)) { echo "<br/><strong>$title6</strong><br />$date6<br />$ $price6<br /><br />"; }

if (!empty($subevent7)) { echo "<br/><strong>$title7</strong><br />$date7<br />$ $price7<br /><br />"; }

if (!empty($subevent8)) { echo "<br/><strong>$title8</strong><br />$date8<br />$ $price8"; }

}

//etc etc

 

?></div>

<p> </p>

<p> </p>

<p> </p>

<p> </p>

<p> </p>

<p> </p>

<p> </p>

<p> </p>

<p> </p>

<p> </p>

<p> </p>

<p> </p>

<p> </p>

<p> </p>

<p> </p>

<hr />

    </p>

<?php

if (isset($_GET['eventid'])) {

include('connect1.php');

$sql = mysql_query("SELECT * FROM Registration WHERE eventid='$eventid' LIMIT 1");

while($row = mysql_fetch_array($sql)){

$eventid = $row["eventid"];

$event = $row["event"];

$date = $row["date"];

$description = $row["description"];

$location = $row["location"];

}

$result = mysqli_query($dbcon, $query) or die('error getting data');

 

echo "<table>";

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {

echo "<tr><td>";

echo "<a href=\"registration.php?eventid=".$_GET['eventid']."\"><ul>Register Now!</ul></a>";

echo "</td></tr>";

}

echo "</table>";

 

}

?>

 

   

   

   

   

   

 

 

 

   

   

  <div id="apDiv18"></div>

  <p align="center"><a href="<?php echo $_SERVER['PHP_SELF']; ?>">Back to Events</a></p>

   

   

   

  <?php

}

?></td></tr>

</table>

 

 

</div><div id="apDiv2"><a href="register.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image3','','button/register2.png',1)"><img src="button/register1.png" name="Image3" width="235" height="50" border="0" id="Image3" /></a></div>

<div id="apDiv4"><a href="projects.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image4','','button/projects2.png',1)"><img src="button/projects1.png" name="Image4" width="235" height="50" border="0" id="Image4" /></a></div>

 

<div id="apDiv11"><?php if ($accounttype == "Scout") {

echo '<a href="../logout.php">Logout</a>';} ?></div>

<div id="apDiv12"><?php echo "$accounttype"; ?>

  <p><?php echo "$name"; ?></p>

  <p>Troop 78</p>

</div>

 

<div id="apDiv5"><?php if ($accounttype == "Admin") {

echo "<a href=\"../logout.php\">Logout</a>";

}

?></div>

 

 

<div id="apDiv7"><a href="news.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image6','','button/news2.png',1)"><img src="button/news1.png" name="Image6" width="235" height="50" border="0" id="Image6" /></a></div>

<div id="apDiv"> <?php if ($accounttype == "Admin") {

echo "<a href=\"../search1.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image7','','../button/membermanager2.png',1)\"><img src=\"../button/membermanager1.png\" name=\"Image7\" width=\"235\" height=\"50\" border=\"0\" id=\"Image7\" /></a>";

}

?></div>

<div id="apDiv3"><?php if ($accounttype == "Admin") {

echo "<a href=\"../eventmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image8','','../button/eventmanager2.png',1)\"><img src=\"../button/eventmanager1.png\"  name=\"Image8\" width=\"235\" height=\"50\" border=\"0\" id=\"Image8\" /></a>";

}

?>

</div>

<div id="apDiv14"><?php if ($accounttype == "Admin") {

echo "<a href=\"../newsmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image9','','../button/newsmanager2.png',1)\"><img src=\"../button/newsmanager1.png\"  name=\"Image9\" width=\"235\" height=\"50\" border=\"0\" id=\"Image9\" /></a>";

}

?>

</div>

 

<div id="apDiv19"><a href="myprofile.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image5','','button/myprofile2.png',1)"><img src="button/myprofile1.png" name="Image5" width="235" height="50" border="0" id="Image5" /></a></div>

<div id="apDiv21"><img src="button/red.png" width="282" height="687" /></div>

 

 

<img name="boyscout" src="buttons/boyscout.jpg" width="1180" height="700" border="0" id="boyscout" alt="" />

</body>

</html>

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.