PHP - Create Html Link That Expires After A Paypal Payment

Hey Everyone,

I'm currently implementing a very simple advert posting site (like a classifieds but its more like a forum atm). I've got advert posting working okay and the next step I'm thinking about is interacting with paypal to handle payments. My know of the Paypal IPN is VERY limited so I'm looking for some pointers really.

- Once an item has been paid for how would I go out about removing the post from my website (Payment = true, advert = delete kinda thing..)
     
   The way I was thinking was something to do with the advert ID perhaps? I'm really not sure though so ideas would be very helpful!

- How exactly would I go about implementing the PayPal IPN, very broad question I know but I'm not overly sure..

Sorry for sounding like a bit of a noob (I guess I am really!)

The website is located here (http://is.gd/04qcz5)

and the database setup is like so (Just in case that's helpful at all?)

Database stores Advert ID, Category ID and User ID in a table along with the advert details.

Any help is greatly appreciated, I look forward to hearing from you all!

Cheers

Hi there.

This forum has been great so far. I got couple of questions answered here.

Now I am working on a PHP web form where Suppliers list their products for customers to buy.

A customer can buy Product 1 from Supplier A and Product 2 from Supplier B and when the customer checks out through Paypal, the payment for Product 1 should go to Suppplier A and similarly the payment for Product 2 should go the Supplier B's email ID.

I thinks its straight forward and How can we do that? Can you please guide me in the right direction.

Thank you!

I have a payment button for PayPal which securely stores the amount, but when the payment is made how do i know if it was paid or not so i can get the page to store this in the mysql database?

Hi all

 

This part is integral to my site and im panicking as i cant seem to find an answer...

 

When someone clicks a link on my page with the below code it only does it as services... how can i create a paypal link to charge as friends and family PLEASE PLEASE PLEASE HELP

<form id="payid" name="_xclick" action="https://www.paypal.com/cgi-bin/webscr" method="post"> 
<input type="hidden" name="cmd" value="_xclick"> 
<input type="hidden" name="business" value="<?php echo $row1['EMAIL']; ?>"> 
<input type="hidden" name="currency_code" value="GBP">
<input type="hidden" name="item_name" value="BALL"> 
<input type="hidden" name="amount" value="<?php echo preg_replace( '/[^0-9,"."]/', '',  $row['PRICE'] ); ?>">
<!--<input type="hidden" name="return" value="http://www.theeasypc.co.uk/lottery/heandal.php">-->
<input type="hidden" name="return" value="http://www.theeasypc.co.uk/lottery/heandal.php?success=1">
    <input type="hidden" name="cancel_return" value="http://www.theeasypc.co.uk/lottery/heandal.php?error=1">

    <!-- Where to send the PayPal IPN to. -->
    <input type="hidden" name="notify_url" value="http://www.theeasypc.co.uk/lottery/heandal.php" />
<input type="image" src="http://www.paypal.com/en_US/i/btn/btn_buynow_LG.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
</form>

I can see the  its set to business in one flag but ive tried to change thie to f&f, personal, friends, family, nothing works also tried "_donations"

 

 

Hi

I've got this database I created with fields

ProductId   ProductName  Image

I've managed to get it to list the ID,productname, and Image urls
in a list.

My next step is to have the image field actually display
an image and make it clickable:

heres what I've done so far:

Code: [Select]
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("productfeed", $con);

$result = mysql_query("SELECT * FROM productfeeds");

echo 
"<table border='0'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>Image</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['ProductID'] . "</td>";
  echo "<td>" . $row['ProductName'] . "</td>";
  echo "<td>" . $row['ImageURL'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>
Heres what I want to do:

Code: [Select]
while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['ProductID'] . "</td>";
  echo "<td>" . $row['ProductName'] . "</td>";

 // my changes beneath
  echo "<td>" . <a href="<?php echo $row['ImageURL'];?>"> <img src="<?php echo $row['LinkURL']; ?>"> </a>. "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>
Can you guys point me in the right direction?

Many thanks

Hello everyone, I am working on a form that is similar to a shopping cart system and I am thinking of creating a button that submits the checked value and saves them to a $_SESSION variable. And also a link that links to a cart.html that takes the values of a $_SESSION variable. I am have trouble figuring what tag/attribute should I use in order to achieve that.   Right now my code attached below submits the checked values to cart.html directly. However I want my submit button to save the checked box to a $_SESSION variable and STAY on the same page. And then I will implement a <a> to link to the cart.php.   I researched a little bit about this subject and I know it's somewhat related to ajax/jquery. I just wanted to know more about it from you guys. I appreciate your attention for reading the post and Thanks!   Below is the form that I currently have:

<form name= "finalForm" method="POST" action="cart.php">
<input type="Submit" name="finalSelected"/>

<?php foreach($FinalName as $key => $item) {?>
<tr>
<td><input type="checkbox" name="fSelected[]" value="<?php echo htmlspecialchars($FinalID[$key])?>" />
<?php echo "$FinalID[$key] & $item";?>
</td>
</tr>
<?php } ;?>

Below is the code for cart.php

<?php
require ('connect_db.php');
if(isset($_POST['finalSelected']))
{
	if(!empty($_POST['fSelected']))
	{
		$chosen = $_POST['fSelected'];
		foreach ($chosen as $item)
			echo "aID selected: $item </br>";
		$delimit = implode(", ", $chosen);
		print_r($delimit);
	}

}
if(isset($delimit))
{
$cartSQL = "SELECT * from article where aID in ($delimit)";
$cartQuery = mysqli_query($dbc, $cartSQL) or die (mysqli_error($dbc));
while($row = mysqli_fetch_array($cartQuery, MYSQLI_BOTH))
{
	$aTitle[] = $row[ 'name' ];
}
}
?>

<table>
	
		<?php if(isset($delimit)) { 
		$c=0; foreach($aTitle as $item) {?>
		<tr>
		<td>
			<?php echo $aTitle[$c]; $c++;?>
		</td>
		</tr>
		<?php }}?>
</table>

This topic has been moved to Apache HTTP Server.

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

My intended goal is to have it see if the post allows comments and if it does then check to make sure the date_comments_expires is NOT before the passed day. I'm not quite sure how to finish this if statement. Any help?

Code: [Select]
if ($mainNews[0]['allow_comments'] == 'Yes' AND $mainNews[0]['date_comments_expire'] == ) {

I'm not sure I'm in the right place, but I'm looking to create a unique URL that links to the same page every time I send an email after a form is submitted on my website and have it expire after 15 days.  After expiring, the link would redirect to a default page.  I'm still a beginner and realize this is probably going to be a tough task, but any resources or direction provided would be much appreciated.

Thanks for the help in advance!

Hi all

I haven't used PHP for a while so I'm stuck on something that seems simple.

I have a list of nav links created in a while loop, I want to add an id="selected" to the <a> link that is selected.

I can check that it's selected with

Code: [Select]
if( $row[1] == $pageName['words']){
     id=''selected"
}

How can I use this to set the id

[code]
<ul>
         <?php
             while($row = mysql_fetch_array($result1)){ 
                //if($row[1] != $pageName['words']){// this will take out the gallery that is showing form the list
                   ?>
                  <li><a href="gallery.php?photo_id=<?php echo $row[0]?>" id=""><?php echo $row[1];?></a></li>
            <?php            
                //}
             }
          ?>
       </ul>
[/code]

Hi,

Just looking how to create a link to download a file located on the server, it will be files like .doc etc.

Cant seem to find anything on the net so i think i need php but may be html.

Can anyone point me in the right direction?

Thanks

p.s. it will be used for more than one file so im looking for a small ish amount of code.

Hey guys,

Currently Im using the code:

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

echo"
$row[user_login],$row[user_email],$row[CallHistoryTimes],$row[CallHistoryInfo],$row[CallHistoryLastOp]$row[CallHistoryLastDate],<br>";
}

To list a mysql array; what I am trying to do is to use the mysql row ID and turn the entire string above into a list.

So for example, the database would get the ID information & create a link of edit.php/?id=3

If someone could help me on this it would be mega appreciated.

Thanks

In this output table, I would like to be able to click on any number in the ama row, add .html to that value and then execute the link.

Example: If the ama number in row 3 is 890543, add .html to the number = 890543.html, then click on it to link to that web page.


<?php // Connect to database =========================================

include("connect_db.php");
$table1='passwords';
$table2='airplanes';

// send query ===================================================

$result = mysql_query("SELECT * FROM $table2") or die(mysql_error());  

if (!$result) {
    die("Query to show fields from table failed");
}

echo "<table border='10' cellpadding='3' cellspacing='2'>";
echo "<p>View All Airplanes</p>";

echo "<tr> <th>ID</th> <th>AMA #</th> <th>Model Name</th> <th>Model MFG</th><th>Wingspan</th><th>Engine</th><th>Decibels</th></tr>";

// keeps getting the next row until there are no more to get ================

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

// Print out the contents of each row into a table ==========================

echo "<tr><td>";

echo $row['id'];

echo "</td><td>"; 

echo $row['ama']; // Append .html to this number

echo "</td><td>"; 

echo $row['model_name'];

echo "</td><td>"; 

echo $row['model_mfg'];

echo "</td><td>"; 

echo $row['wingspan'];

echo "</td><td>"; 

echo $row['engine'];

echo "</td><td>"; 

echo $row['decibels'];

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

echo "</table>";

?>

I know with a submit button I can have a new record created when clicking it, but is it possible to do with a text link?