PHP - Adding Link To Phpmailer Email

I have an auctions website and I want to create a feature that is similar to ebay in which users will receive an email if one of the auctions they are watching will end in less than 3 hours. I will be using a cron job to call up this page every 15 minutes. When the cron job executes, I would like it to send 1 email per auction to every user that has that auction on their watchlist if the auction will be ending in 3 hours. I don't know whether it needs to be a separate email for each user or one mass email where their emails are hidden.

The 4 tables in my database we are concerned about are "auctions, "users, "watchlists" and "products."

I am trying to use the script phpMailer to execute the code because I heard it was the best one. Anways here is what I have so far. I am missing alot because I had no clue what to do.


<?php
require("class.phpmailer.php");


$holder = mysql_connect("localhost", "user", "password");
mysql_select_db("database", $holder);

// NEED TO FIX THIS // Need to get ALL of the auction id's where the end time is less than 3 hours and the notification hasn't already been sent //
$auctionid = mysql_query("SELECT id FROM auctions WHERE DATE_ADD(NOW(), INTERVAL 3 HOUR) <= end_time AND notification = 0", $holder);

// get the auction title of  EACH of the auctions selected above which is not stored in the auctions table but in the products table..will be used for body of email /// AGAIN, NEED THIS TO GET ME ALL OF THE NAMES OF AUCTIONS THAT ARE ENDING IN 3 HOURS//
$auctiontitle = mysql_query("SELECT name FROM products LEFT JOIN auctions ON auctions.product_id=products.id WHERE auctions.id = $auctionid", $holder);

// PROBABLY NEED TO FIX THIS // Need to get ALL of the email addresses  who have ANY of the above auction ids on their watchlist //
$email = mysql_query("SELECT email FROM users LEFT JOIN watchlists ON users.id=watchlists.user_id WHERE watchlists.auction_id = $auctionid", $holder);

// Update the auctions table. Turn notification to 1 so the notification for that auction can't be sent again // AGAIN NEED THIS FOR ALL OF THE AUCTIONS ENDING IN 3 HOURS //
$query1="UPDATE auctions SET notification = '1' WHERE id = '$auctionid'";
mysql_query($query1) or die(mysql_error());



$mail = new PHPMailer();

$mail->From = "no-reply@domain.com";
$mail->FromName = "Site Name";


// Getting and error message for the foreach but I saw a similar example and this is what I was told to do // NEED THIS TO ADD EACH OF THE EMAIL ADDRESSES INDIVIDUALLY //
foreach ( $email as $recipients ) {
$mail->AddAddress ($recipients);
}
$mail->WordWrap = 50;                                 // set word wrap to 50 characters
$mail->IsHTML(true);                                  // set email format to HTML

$mail->Subject = "Your Watched Auction is Ending Soon";

// Sample Body // WANT TO DISPLAY THE TITLE OF THE AUCTION (NAME OF PRODUCT) FOR THE AUCTION ID USING $auctiontile FROM ABOVE //
$mail->Body    = "Your auction titled $auctiontile is ending soon";

// Same as above //
$mail->AltBody = Your auction titled $auctiontile is ending soon";


if(!$mail->Send())
{
   echo "Message could not be sent.";
   echo "Mailer Error: " . $mail->ErrorInfo;
   exit;
}

echo "Message has been sent";


?>

Hi,

I'm new here and new to php.  My first attempt at a php project actually so I'm hoping to get some help.

I want people to register at my site but I don't want them to put false emails on it.

So I used the coding from this website http://www.phpeasystep.com/workshopview.php?id=24 to provide codings for forms and email confirmation links.

The process worked up to when I click on the confirmation link (at testing) from the email and the link returns to a blank webpage.  No data is transferred from "temp_members_db" table  to "registered_members" table at all.

I'll attach print screen of my tables.

Hoping that someone can point out to me where I'm going wrong as I can't seem to get myself out of this one.

Hi, n0obie here.  I'm trying to identify where my customers are coming from via emails I've sent/received. However, many email providers (namely Gmail) have circumvented this by disallowing IP address geolocation/image caching.

here's my code that i've used to send an email.

Code: [Select]
$link = "<a href=\"http://www.example.com/" . $num . "\">" . $num . "</a>";

$query = "SELECT content FROM emails";
$result = mysql_query($query) or die();
$email_content = mysql_result($result, 0);
$email = sprintf($email_content, $first, $name, $from, $link, $record, $rec, $inc, $max);
$email_body = stripslashes(htmlentities($email, ENT_QUOTES, 'UTF-8'));

// this is sent to another php script via post....

$subject = $_POST['subject'];
$message = nl2br(html_entity_decode($_POST['email_body']));
$to = "me@whatever.com";
$charset='UTF-8';
$encoded_subject="=?$charset?B?" . base64_encode($subject) . "?=\n";
$headers="From: " . $userEmail . "\n"
. "Content-Type: text/html; charset=$charset; format=flowed\n"
. "MIME-Version: 1.0\n"
. "Content-Transfer-Encoding: 8bit\n"
. "X-Mailer: PHP\n";
mail($to,$encoded_subject,$message,$headers);
   

in the db, emails.content is of the text type and contains several lines of text with %4$s which inserts the value of $link into the body.  when the email arrives, there is a link and it appears fine, with the value of $num hyperlinked.  however when you click on it it doesn't go anywhere.  when copying the link location from the email it gives me

x-msg://87/%22http://www.example.com/16

what is x-msg?  how can i get this to work properly?

I have a bit of php code that sends an email. I would like to add another email recipient to this code, so that the email is sent to BOTH the post author AND the following email address... help@dealfiles.com   Yes, this is part of a Wordpress plugin. It's a small part of a large plugin that I have a LOT of time investing in setting up, so I can't just look for an alternate plugin. I really need to get this one to work.   Thanks in advance for any and all help with this.

Here is the existing code:

<?php 
              if (get_post_meta( $post->ID, '_listing_contact_form', true) != '') {
  
                  echo do_shortcode(get_post_meta( $post->ID, '_listing_contact_form', true) );
  
              } else {
  
                  $nameError = '';
                  $emailError = '';
 
                 if(isset($_POST['submitted'])) {
 
                 $url = get_permalink();
                 $listing = get_the_title();
 
                 if(trim($_POST['contactName']) === '') {
                     $nameError = 'Please enter your name.';
                     $hasError = true;
                 } else {
                     $name = trim($_POST['contactName']);
                 }
 
                 if(trim($_POST['email']) === '')  {
                     $emailError = 'Please enter your email address.';
                     $hasError = true;
                 } else if (!preg_match("/^[[:alnum:]][a-z0-9_.-]*@[a-z0-9.-]+\.[a-z]{2,4}$/i", trim($_POST['email']))) {
                     $emailError = 'You entered an invalid email address.';
                     $hasError = true;
                 } else {
                     $email = trim($_POST['email']);
                 }
 
                 $phone = trim($_POST['phone']);
 
                 if(function_exists('stripslashes')) {
                     $comments = stripslashes(trim($_POST['comments']));
                 } else {
                     $comments = trim($_POST['comments']);
                 }
 
 
                 if(!isset($hasError)) {
                     $emailTo = get_the_author_meta( 'user_email', $post->post_author );
                     if (!isset($emailTo) || ($emailTo == '') ){
                         $emailTo = get_option('admin_email');
                     }
                     $subject = 'Listing Inquiry from '.$name;
                     $body = "Name: $name \n\nEmail: $email \n\nPhone: $phone \n\nListing: $listing \n\nURL: $url \n\nComments: $comments";
                     $headers = 'From: '.$name.' <'.$emailTo.'>' . "\r\n" . 'Reply-To: ' . $email;
 
                     wp_mail($emailTo, $subject, $body, $headers);
                     $emailSent = true;
                 }
 
             } ?>

Hi

I am gathering numbers in an array and then want to add together all the numbers attached to the same email so I end up with the Grand totals of each email address.

Below is the code I am using to pull out the email and attached values
Code: [Select]
$getcashdonationsdb = $wpdb->get_results("SELECT * FROM cashdepo WHERE cause='$causename' AND status='2' ORDER BY user DESC");
$i = 0;
while($i < $count2) {
foreach($getcashdonationsdb as $getcashdonationsdb){
$dataa[$i]['email'] = $getcashdonationsdb->email;
                $dataa[$i]['cost'] = $getcashdonationsdb->cost;
         }
}

Anyone have any suggestions how I can achieve this most efficiently.

i have the following problem i have a mail id displayed on the site. on clicking the link the email address should get saved to the outlook express contacts.

all i have been doing is reading through but did not find any revelance to implement any help of any sort will be appreciated
thanks

I am trying to add my email to a contact form to where a customer would fill in a few boxes and hit send and i would receive.  Where would i find the code to enter it?  thanks, w

Hi everyone, this is my first post. i am starting to learn flash and other programs and haven't started on PHP yet. I have purchased a template that i am modifying and the problem i am having is that my server is a windows one and doesn't like the code that i have attached. It is very simple and doesn't offer any protection with strip slashes etc but the real problem is that i need to add the smpt auth.

I have tried several lines of code but it doesnt seem to work. 

I cant change the headers so i am hoping i can get a little help from this community. It is greatly appreciated

Hey guys, Just lately I have been trying to start a specific project for myself. I started off by designing the pages etc on HTML, and then a friend of mine helped me convert them to PHP.   At the moment, when a user registers to the site, they only require to enter a Username and Password. I would like to add their email to it too, due to adding slightly extra security. It would also be used for future reasons such as sending emails out etc.   I'm not sure about adding this, I know that most likely it is going to be VERY similar to how it already is, but I couldn't seem to get it to work when I tried.   Ill give the coding which I am using for this below (the documents which I believe would need editing) :   Register.php

<?php

require($_SERVER['DOCUMENT_ROOT'] . '/TruckWorld/includes/config.php');

$sOutput .= '<div id="register-body">';

if (isset($_GET['action'])) {
	switch (strtolower($_GET['action'])) {
		case 'register':
			// If the form was submitted lets try to create the account.
			if (isset($_POST['username']) && isset($_POST['password'])) {
				if (createAccount($_POST['username'], $_POST['password'])) {
					$sOutput .= '<h1>Account Created</h1><br />Your account has been created. 
								You can now login <a href="login.php">here</a>.';
				}else {
					// unset the action to display the registration form.
					unset($_GET['action']);
				}				
			}else {
				$_SESSION['error'] = "Username and or Password was not supplied.";
				unset($_GET['action']);
			}
		break;
	}
}

// If the user is logged in display them a message.
if (loggedIn()) {
	$sOutput .= '<h2>Already Registered</h2>
				You have already registered and are currently logged in as: ' . $_SESSION['username'] . '.
				<h4>Would you like to <a href="login.php?action=logout">logout</a>?</h4>
				<h4>Would you like to go to <a href="index.php">site index</a>?</h4>';
				
// If the action is not set, we want to display the registration form
}elseif (!isset($_GET['action'])) {
	// incase there was an error 
	// see if we have a previous username
	$sUsername = "";
	if (isset($_POST['username'])) {
		$sUsername = $_POST['username'];
	}
	
	$sError = "";
	if (isset($_SESSION['error'])) {
		$sError = '<span id="error">' . $_SESSION['error'] . '</span><br />';
	}
	
	$sOutput .= '<!DOCTYPE html>
	<html>
	
	<head>
	
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
	
    <title>Truck World - Register</title>
	
    <!-- Core CSS - Include with every page -->
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <link href="font-awesome/css/font-awesome.css" rel="stylesheet">
	
    <!-- SB Admin CSS - Include with every page -->
    <link href="css/sb-admin.css" rel="stylesheet">
	
	
	</head>
	
	<body>
	
	<div align=center><img src="images/logintitle.png" alt="LoginTitle" /></div>
	
    <div class="container">
	<div class="row">
	<div class="col-md-4 col-md-offset-4">
	<div class="login-panel panel panel-default">
	<div class="panel-heading">
	<h3 class="panel-title">Register To Join Truck World!</h3>
	</div>
	<div class="panel-body">
		' . $sError . '
		<form name="register" method="post" action="' . $_SERVER['PHP_SELF'] . '?action=register">
			<fieldset>
			<div class="form-group">
				<input class="form-control" placeholder="Username" name="username" type="username" autofocus="">
			</div>
			<div class="form-group">
				<input class="form-control" placeholder="Password" name="password" type="password" value="">
			</div>
			<div class="form-group">
				<input class="form-control" placeholder="Email" name="email" type="email" value="">
			</div>
			<!-- Change this to a button or input when using this as a form -->
			<input type="submit" class="btn btn-lg btn-success btn-block" name="submit" value="Register" />
			<a href="login.php"class="btn btn-lg btn-success btn-block">Login</a>
		</fieldset>';
}

$sOutput .= '</div>
</div>
</div>
</div>
</div>

<div align=center><h5><small>Copyright - Lewis Pickles 2014 - All Rights Reserved</small></h5></div>

<!-- Core Scripts - Include with every page -->
<script src="js/jquery-1.10.2.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/plugins/metisMenu/jquery.metisMenu.js"></script>

<!-- SB Admin Scripts - Include with every page -->
<script src="js/sb-admin.js"></script>

</body>

</html>
';

// display our output.
echo $sOutput;
?>

Functions.php (Not sure if this would need editing, I think it might, Correct me if I'm wrong)

<?php

function createAccount($pUsername, $pPassword) {
	// First check we have data passed in.
	if (!empty($pUsername) && !empty($pPassword)) {
		$uLen = strlen($pUsername);
		$pLen = strlen($pPassword);
		
		// escape the $pUsername to avoid SQL Injections
		$eUsername = mysql_real_escape_string($pUsername);
		$sql = "SELECT username FROM users WHERE username = '" . $eUsername . "' LIMIT 1";

		// Note the use of trigger_error instead of or die.
		$query = mysql_query($sql) or trigger_error("Query Failed: " . mysql_error());

		// Error checks (Should be explained with the error)
		if ($uLen <= 4 || $uLen >= 11) {
			$_SESSION['error'] = "Username must be between 4 and 11 characters.";
		}elseif ($pLen < 6) {
			$_SESSION['error'] = "Password must be longer then 6 characters.";
		}elseif (mysql_num_rows($query) == 1) {
			$_SESSION['error'] = "Username already exists.";
		}else {
			// All errors passed lets
			// Create our insert SQL by hashing the password and using the escaped Username.
			$sql = "INSERT INTO users (`username`, `password`) VALUES ('" . $eUsername . "', '" . hashPassword($pPassword, SALT1, SALT2) . "');";
			
			$query = mysql_query($sql) or trigger_error("Query Failed: " . mysql_error());
			
			if ($query) {
				return true;
			}	
		}
	}
	
	return false;
}

/***********
	string hashPassword (string $pPassword, string $pSalt1, string $pSalt2)
		This will create a SHA1 hash of the password
		using 2 salts that the user specifies.
************/
function hashPassword($pPassword, $pSalt1="2345#$%@3e", $pSalt2="taesa%#@2%^#") {
	return sha1(md5($pSalt2 . $pPassword . $pSalt1));
}

/***********
	bool loggedIn
		verifies that session data is in tack
		and the user is valid for this session.
************/
function loggedIn() {
	// check both loggedin and username to verify user.
	if (isset($_SESSION['loggedin']) && isset($_SESSION['username'])) {
		return true;
	}
	
	return false;
}

/***********
	bool logoutUser 
		Log out a user by unsetting the session variable.
************/
function logoutUser() {
	// using unset will remove the variable
	// and thus logging off the user.
	unset($_SESSION['username']);
	unset($_SESSION['loggedin']);
	
	return true;
}

/***********
	bool validateUser
		Attempt to verify that a username / password
		combination are valid. If they are it will set
		cookies and session data then return true. 
		If they are not valid it simply returns false. 
************/
function validateUser($pUsername, $pPassword) {
	// See if the username and password are valid.
	$sql = "SELECT username FROM users 
		WHERE username = '" . mysql_real_escape_string($pUsername) . "' AND password = '" . hashPassword($pPassword, SALT1, SALT2) . "' LIMIT 1";
	$query = mysql_query($sql) or trigger_error("Query Failed: " . mysql_error());
	
	// If one row was returned, the user was logged in!
	if (mysql_num_rows($query) == 1) {
		$row = mysql_fetch_assoc($query);
		$_SESSION['username'] = $row['username'];
		$_SESSION['loggedin'] = true;
			
		return true;
	}
	
	
	return false;
}
?>

The Database for the email is as follows:  
Edited by Lewis2212, 06 August 2014 - 10:20 AM.

hope someone can help me out here, stuck on this page...
This page shows the details of the listing they had just clicked on on the previous page. this part works
If the person logged in is the person who is looking at the page, the email section does not show. this part works
However, the part I cannot get to work, is when the logged in user types their email message and clicks send email. at this point the details of listing stop showing
please SOMEONE HELP ME
thanks in advance, i hope
Code: [Select]
<?php
  // Start the session
  require_once('startsession.php');

  // Insert the page header
  $page_title = 'Listing Details';
  require_once('header.php');

  require_once('connectvars.php');

  // Show the navigation menu
  require_once('navmenu.php');
 

if(isset($_POST['submit'])){
 $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); 

  // Retrieve the user data from MySQL
  $query1 = 'SELECT email FROM ob_user WHERE username="' . $user_name . '"';
  $data1 = mysqli_query($dbc, $query1);
  $row1 = mysqli_fetch_array($data1);
  
  $email = $row1['email'];
  
 $to = $email;
 $subject = 'OurBazzar response to' . $subject . '';
 $body = $_POST['email'];
 $headers = 'From: caleb.jordan.flax@gmail.com';
 if (mail($to, $subject, $body, $headers)) {
   echo("<p>Message sent!</p>");
  } else {
   echo("<p>Message delivery failed...</p>");
  }
  end();
}



  if (isset($_GET['listing_id']) && isset($_GET['subject']) && isset($_GET['description']) && isset($_GET['price']) && isset($_GET['date']) && isset($_GET['city']) && isset($_GET['state']) && isset($_GET['user_id']) && isset($_GET['category_id'])) {
  
    // Grab the score data from the GET
    $listing_id = $_GET['listing_id'];
    $title = $_GET['subject'];
    $description = $_GET['description'];
    $price = $_GET['price'];
    $date = $_GET['date'];
$city = $_GET['city'];
    $state = $_GET['state'];
    $userid = $_GET['user_id'];
    $categoryid = $_GET['category_id'];

  }

// Connect to the database 
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); 

  // Retrieve the user data from MySQL
  $query = 'SELECT username FROM ob_user WHERE user_id="' . $userid . '"';
  $data = mysqli_query($dbc, $query);
  $row = mysqli_fetch_array($data);

  $query1 = 'SELECT name FROM ob_category WHERE category_id="' . $categoryid . '"';
  $data1 = mysqli_query($dbc, $query1);
  $row1 = mysqli_fetch_array($data1); 
  
$user_name = $row['username'];
$category_name = $row1['name']; 

echo '<table>';
echo '<tr><td colspan="2"><strong>' . $title . '</strong></td></tr>';
echo '<tr><td>Created by: </td><td>' . $user_name . '</td></tr>';
echo '<tr><td>Date created: </td><td>' . $date . '</td></tr>';
echo '<tr><td>Location: </td><td>' . $city . ', ' . $state . '</td></tr>';
echo '<tr><td>Category: </td><td>' . $category_name . '</td></tr>';
echo '<tr><td>Description: </td><td>' . $description . '</td></tr>';
echo '</table>'; 

if ((isset($_SESSION['username'])) && ($_SESSION['username'] != $user_name)) {

?>

<br />
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<fieldset>
<legend>Send Email to <?php echo $user_name; ?></legend>
<label for="email">Message: </label>
<input type="text" name="email" /><br />
<input type="submit" value="Send Email" name="submit">
</fieldset>

<?php

}
require_once('footer.php');
?>

Hey guys, Been working on a project but only recently started using php. 
What happens is....  I have a general quiz split accross a multipage form and then a results section.  The problem is, is that when it comes to if statements on the last page and deciding the difficulty level for the users quiz,  it wont let me add the 3rd and final link.
Here is the code to explain.  I have put bits in bold and a comment. (at the bottom section)

I've tried everything,  Thanks for any help in advance guys.
Code: [Select]
<?php
session_start();

$_SESSION['q11'] = $_POST['q11'];
$_SESSION['q12'] = $_POST['q12'];
$_SESSION['q13'] = $_POST['q13'];
$_SESSION['q14'] = $_POST['q14'];
$_SESSION['q15'] = $_POST['q15'];


$protectscore = 0; //initialize score to zero
$detectscore = 0;
$resolvescore = 0;
$overallScore = 0;

?>

<html>
<head>
   <title>Results</title>
<h1>Protection Section</h1>
<p><b>Question 1</b>
 
  <?php
if ($_SESSION['q1'] == "1"){
      echo("<b>Correct</b>");
      $protectscore = $protectscore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?><BR>
  <b>Question 2</b>
  <?php
if ($_SESSION['q2'] == "2")   {
      echo("<b>Correct</b>");
      $protectscore = $protectscore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?><BR>
  <b>Question 3</b>
  <?php
if ($_SESSION['q3'] == "3")   {
      echo("<b>Correct</b>");
      $protectscore = $protectscore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?><BR>
  <b>Question 4</b>
  <?php
if ($_SESSION['q4'] == "1")   {
      echo("<b>Correct</b>");
      $protectscore = $protectscore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?><BR>
  <b>Question 5</b>
  <?php
if ($_SESSION['q5'] == "2")   {
      echo("<b>Correct</b>");
      $protectscore = $protectscore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?>
<h1>Detection Section</h1>
<b>Question 1</b>
  <?php
if ($_SESSION['q6'] == "3")   {
      echo("<b>Correct</b>");
      $detectscore = $detectscore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?><BR>
<b>Question 2</b>
  <?php
if ($_SESSION['q7'] == "3")   {
      echo("<b>Correct</b>");
      $detectscore = $detectscore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?><BR>
<b>Question 3</b>
  <?php
if ($_SESSION['q8'] == "1")   {
      echo("<b>Correct</b>");
      $detectscore = $detectscore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?><BR><b>Question 4</b>
  <?php
if ($_SESSION['q9'] == "2")   {
      echo("<b>Correct</b>");
      $detectscore = $detectscore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?><BR><b>Question 5</b>
  <?php
if ($_SESSION['q10'] == "1")   {
      echo("<b>Correct</b>");
      $detectscore = $detectscore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?>
<h1>Resolve Section</h1>
<b>Question 1</b>
  <?php
if ($_SESSION['q11'] == "2")   {
      echo("<b>Correct</b>");
      $resolvescore = $resolvescore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?><BR>
  <b>Question 2</b>
  <?php
if ($_SESSION['q12'] == "1")   {
      echo("<b>Correct</b>");
      $resolvescore = $resolvescore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?><b><BR>Question 3</b>
  <?php
if ($_SESSION['q13'] == "3")   {
      echo("<b>Correct</b>");
      $resolvescore = $resolvescore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?><BR><b>Question 4</b>
  <?php
if ($_SESSION['q14'] == "3")   {
      echo("<b>Correct</b>");
      $resolvescore = $resolvescore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?><BR>
<b>Question 5</b>
  <?php
if ($_SESSION['q15'] == "1")   {
      echo("<b>Correct</b>");
      $resolvescore = $resolvescore +1;   
   }else{
      echo("<b>Incorrect</b>");
   }
?>
</p>
<hr>
<b>Total Sco </b>You answered <?php echo ($protectscore + $detectscore + $resolvescore); ?> question<?php
if ($overallScore != 1)
{
echo("s");
}
?> Correctly
<?php
$qs = '15';
$overallScore = $protectscore + $detectscore + $resolvescore;
$overallPercent = number_format(($overallScore * 100) / $qs);
$ProtectionPercent = number_format(($protectscore * 100) / 5);
$DetectionPercent = number_format(($detectscore * 100) / 5);
$ResolvingPercent = number_format(($resolvescore * 100) / 5);
?><BR>

<strong>Total Percentage is:</strong> <?php echo $overallPercent?> % <BR>
Your Percentage From Protection Section is: <?php echo $ProtectionPercent?> % <BR>
Your Percentage From Detection Section is: <?php echo $DetectionPercent?> %<BR>
Your Percentage From Resolving Section is: <?php echo $ResolvingPercent?> %<BR>

<HR>


This section adds the link perfectly fine
<?php
if ($ProtectionPercent <= 30){ // beg
      echo '<li><a href="http://www.google.com> View Personalised Protection Content</a>';
} elseif ($ProtectionPercent > 30 && $ProtectionPercent <= 60){ //int
      echo '<li><a href="http://www.youtube.com"> View Personalised Protection Content</a>';
   } 
else //exp
   {
      echo '<li><a href="http://www.facebook.com">View Personalised Protection Content</a>';
    }
?><BR>
<HR>
This link add fine, however when i add the resolving if statement. This link disappear here and the Resolving section just doesnt appear
<?php
if ($DetectionPercent <= 30){ // beg
      echo '<li><a href="http://www.google.com> View Personalised Detection Content</a>';
} elseif ($DetectionPercent > 30 && $DetectionPercent <= 60){ //int
      echo '<li><a href="http://www.youtube.com"> View Personalised Detection Content</a>';
   } 
else //exp
   {
      echo '<li><a href="http://www.facebook.com">View Personalised Detection Content</a>';
    }
When this part is added, this is when the error occurs
<?php
if ($ResolvingPercent <= 30){ // beg
      echo '<li><a href="http://www.google.com> View Personalised Resolving Content</a>';
} elseif ($ResolvingPercent > 30 && $ResolvingPercent <= 60){ //int
      echo '<li><a href="http://www.youtube.com"> View Personalised Resolving Content</a>';
   } 
else //exp
   {
      echo '<li><a href="http://www.facebook.com">View Personalised Resolving Content</a>';
    }
?>

?>

MOD EDIT: [code] . . . [/code] tags added.

Hey Guys,

I'm querying a database that is going to return a html page. In this page I'm going to define content areas with a class.

eg:
<div class="category"></div>

Anywhere I have this class in the html code, I want to dynamically insert a link into it. So when I retrieve the code from the database, I need the code to check for this tag (class="category") and add a standard link (<a href="..">Add new Category</a>) 

Not 100% sure whats the most efficient way to go about this.

i have a database field called photo. it is used to generate photo id in a software progam for our soccer league. I also want to be able to view the photo on our approval page. could someone help me with the coding of the http h-link? i am having issues with it.

the photo field has the following paramaters: images/picture.jpg

i want the link on the approval page to look like this: <a href="http://bccsl.org/managers/images/picture.jpg">"http://bccsl.org/managers/images/picture.jpg</a>


thanks


stefan
Code: [Select]
<?php

/* connection and protection */

include 'dbc.php';

page_protect();



    mysql_query( "SET NAMES utf8" );





if(isset($_POST["update"]) AND isset($_POST["hiddenid"]))

{

    $updated=false;



    $activateapproved=array();

    $deactivateapproved=array();

    

    foreach($_POST["hiddenid"] AS $value)

    {

        if(isset($_POST["checkboxapproved"][$value]))

        $activateapproved[]=intval($value);

        else

        $deactivateapproved[]=intval($value);

    }





    if(count($activateapproved)>0)  {

    $SQL=sprintf("UPDATE players SET approved=1 WHERE id in (%s)" , implode(",", $activateapproved));

    mysql_query($SQL) OR DIE(mysql_error());

    $updated=true;

    }



    if(count($deactivateapproved)>0) {

    $SQL=sprintf("UPDATE players SET approved=0  WHERE id in (%s)" , implode(",", $deactivateapproved));

    mysql_query($SQL) OR DIE(mysql_error());

    $updated=true;

    }

    

    if($updated==true) {

    header("Location: ".$_SERVER["PHP_SELF"]."");

    exit();

    }

}

?>

<!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>Player Approval</title>

<script type="text/javascript" src="public_smo_scripts.js"></script>

<link href="styles.css" rel="stylesheet" type="text/css">

</head>



<body>
<table width="100%" border="0" cellspacing="0" cellpadding="5" class="main">
  <tr>
    <td colspan="3">&nbsp;</td>
  </tr>
  <tr>
    <td width="160" valign="top">
<? include 'menu.php'; ?>
      <p>&nbsp; </p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p></td>
    <td width="732" valign="top"><p>&nbsp;</p>
<?php
if(isset($_GET["todo"]) AND $_GET["todo"]=="updated")

{

    echo "Updated succesfully";

}

?>

<form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post" name="Form">

<table border="1" cellpadding="2" cellspacing="2">

<tr>

<td><div align="center">First</div></td>
<td><div align="center">Last</div></td>
<td><div align="center">Address</div></td>
<td><div align="center">City</div></td>
<td><div align="center">Postal</div></td>
<td><div align="center">Phone #</div></td>
<td><div align="center">Feet</div></td>
<td><div align="center">Inches</div></td>
<td><div align="center">Weight</div></td>
<td><div align="center">Birthdate</div></td>
<td><div align="center">Team ID</div></td>
<td><div align="center">Type</div></td>
<td><div align="center">photo</div></td>
<td><div align="center">Date Added</div></td>
<td><div align="center">Approved</div></td>

</tr>

<?php

$sql="select * from players where teamid='$_POST[teamid]' order by status ASC";

$res=mysql_query($sql) or die(mysql_error());



while($r=mysql_fetch_assoc($res))

{

?>

<tr>

    <input type="hidden" name="hiddenid[]" value="<?php echo $r["id"]?>">

    <td>

      <div align="center"><?php echo empty($r["first"])?'&nbsp;':htmlspecialchars($r["first"]); ?>        </div></td>

    <td>

      <div align="center"><?php echo empty($r["last"])?'&nbsp;':htmlspecialchars($r["last"]); ?>        </div></td>

    <td>

      <div align="center"><?php echo empty($r["address"])?'&nbsp;':htmlspecialchars($r["address"]); ?>        </div></td>

    <td>

      <div align="center"><?php echo empty($r["city"])?'&nbsp;':htmlspecialchars($r["city"]); ?>        </div></td>

    <td>

      <div align="center"><?php echo empty($r["postal"])?'&nbsp;':htmlspecialchars($r["postal"]); ?>        </div></td>

    <td>

      <div align="center"><?php echo empty($r["phone"])?'&nbsp;':htmlspecialchars($r["phone"]); ?>        </div></td>

    <td>

      <div align="center"><?php echo empty($r["feet"])?'&nbsp;':htmlspecialchars($r["feet"]); ?>        </div></td>

    <td>

      <div align="center"><?php echo empty($r["inches"])?'&nbsp;':htmlspecialchars($r["inches"]); ?>        </div></td>

    <td>

      <div align="center"><?php echo empty($r["weight"])?'&nbsp;':htmlspecialchars($r["weight"]); ?>        </div></td>

    <td>

      <div align="center"><?php echo empty($r["birth"])?'&nbsp;':htmlspecialchars($r["birth"]); ?>        </div></td>

    <td>

      <div align="center"><?php echo empty($r["teamid"])?'&nbsp;':htmlspecialchars($r["teamid"]); ?>        </div></td>

    <td>

      <div align="center"><?php echo empty($r["status"])?'&nbsp;':htmlspecialchars($r["status"]); ?>        </div></td>

    <td>
   
      <div align="center"><?php echo empty($r["photo"])?'<a href="http://bccsl.org/managers/:htmlspecialchars($r["photo"])</a>'; ?>        </div></td>

    <td>
          <div align="center"><?php echo empty($r["dateadded"])?'&nbsp;':htmlspecialchars($r["dateadded"]); ?>        </div></td>

    <td>

        <div align="center">

          <input type="checkbox" name="checkboxapproved[<?php echo $r["id"]?>]" value="1"<?php echo empty($r["approved"])?'':' checked="checked"'; ?> />

          </div></td>

</tr>

<?php

}

?>

</table>

<p>

  <input type="checkbox" name="checkall" onclick="checkUncheckAll(this);"/>

  select/unselect

  <input type="submit" value="update" name="update">

</p>

</form>



<table width="178" border="1" cellpadding="0" cellspacing="1">

  <tr>

    <th colspan="2" scope="col">Type</th>

  </tr>

  <tr>

    <td width="113"><div align="center">Church Player</div></td>

    <td width="50"><div align="center">1</div></td>

  </tr>

  <tr>

    <td><div align="center">Import Player</div></td>

    <td><div align="center">2</div></td>

  </tr>

  <tr>

    <td><div align="center">Witness Player</div></td>

    <td><div align="center">3</div></td>

  </tr>

</table>
     </td>
    <td width="196" valign="top">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="3">&nbsp;</td>
  </tr>
</table>

</body>
</html>
<a href="http://bccsl.org/managers/">http://bccsl.org/managers/</a>

Is it possible to add more then one thing in a link? so i can $_GET more then one thing from a link

signup.php?state=1?name=sam

i tried that and a few other things and it didnt work.