update Display in SQL..need session for ID

[PimMC]

I made a code to complete the status of a listing.

CODE:

<?php
//je require statement
// Make a MySQL Connection
mysql_connect("localhost", "(username)", "(your password)") or die(mysql_error());
mysql_select_db("(your databasename)") or die(mysql_error());


function mysqlOne($query)
{
$result = mysql_query($query);
$row = mysql_fetch_row($result);
return $row[0];
}
if($_POST['display'] != ""){
mysql_query("UPDATE class_listings SET display='".$_POST['display']."' WHERE display='N'") or die(mysql_error());
$_POST['display'] = "";
}
?>
<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST"><br>
<input name="display" value="Y" size="10" maxlength="1" type="hidden"/>
<br><br>
<input type="submit" value="SET LISTING STATUS: ONLINE">
</form>


If the connection to your database is successfull, and you click on the button that shows on this page (if you use this code in an php file and upload it).
The DISPLAY field in SQL database will set to "Y", so ALL the listings wil be online. (status: Completed)

But the scripts looks now for 'display'-field setting "N".

What I want:

A cookie session from the checkout page where I get an listingid so I will tell the database, that he just only set the 'display'-field from that listing ($listingid) to "Y".

Can anybody help me?

[Lhotch +]

And what if the user does not accept cookies from your site?

[PimMC]

If I post a new listing, when generates the listingid??? At step7 ? or in Thanks.php?gateway=....?

[Lhotch +]

There are listings and orders generated long before step 7. whan an listing becomes visible depends on the type of listing (ie free or paid etc).

I am not sure what you are trying to accomplish here BUT I highly recommend you have a very thorough understanding of the checkout process and what takes place WHEN, WHERE and HOW before you start overriding stuff or you likely will expose yourself to all sorts of abuse or pissibly mess up your database horribly.

[PimMC]

Ok, i understand.
But what I'll try to do with this script is to get a listingstatus "COMPLETED".
Because, i'm running a sms / telephone payment script, but it needs a fallback link when the payment is done.

But the payment system is stand alone, so i just want to get de 'display' of the listing which is payed, to "Y" (completed).

I'm not an expert in scripting (english language neather), so that's why i'm asking it here

[Mike-N-Tosh +]

I think you should visit the payment API documentation. You should use the built in scripting and variables as defined in the payment gateways. If your payment gateway is standalone, then call it from your custom sr.php file for your custom gateway. You'll probably need to do some variable conversions from your stand alone system to match the expected variables for the script.

[PimMC]

I've read that documentation about API to integrate the gateway.
But I don't know where to start with.
The new payment gateway has different files and one class file.

I just need some help with that script. I tought just to set up a script to change 'display' in the database.


Can I send somebody my code, and have a quick look.
I just wanna know where I must start integrate in the php files.