Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

recordsets....

Guest
Jan 09, 2008 Jan 09, 2008
Hello. I know this may be simple to many but I am going to ask it anyways because I am stumped badly. Ok I need to be able to pull up info from a database with people and info from each county in each state, do I have to create a recordset for each county selected? Do you have to create one for each time you try to display the details page also? Is there another way to do this? Please help! Sorry if this seems stupid to some but I am trying here!

Thanks!!!!
TOPICS
Server side applications
2.0K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Feb 12, 2008 Feb 12, 2008
yeah after they pay, it goes to a page (still on securepay) that says it was approved, and below it has a link that takes them to the form... which all works fine, but if they were to pick up on the address up top, they can retype it in there next time and bypass the payment.

i can put in the page or url, that the go to after the payment, which is the form. its a written out code from secure pay with my id and etc. but do i need to write this in the url or the actual form page?
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 13, 2008 Feb 13, 2008
lilbodi wrote:
> yeah after they pay, it goes to a page (still on securepay) that says it was
> approved, and below it has a link that takes them to the form... which all
> works fine, but if they were to pick up on the address up top, they can retype
> it in there next time and bypass the payment.

I'm not an ecommerce expert, so am perhaps not the best person to
advise. However, I presume that the page the user is redirected to is
where the purchased product can be downloaded. I have purchased several
pieces of software and ebooks online, and the download page is always
password protected. When I log in, it shows me links to my products and
nothing else. If you ask users to create an account on the site before
sending them to the payment gateway, you should have a session variable
that indicates the user is logged in. You can protect the download page
with the same session variable. It will still be alive after the user is
returned from the payment gateway. If, by any chance, it isn't, the user
will be prompted to log in again.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Feb 18, 2008 Feb 18, 2008
yeah i see what youre saying. this is the example of the form that i use to go to from my pages, then redirects them to the payment form

<form method="POST" action="https://www.securepay.com/payment/index.asp" name="payment">
Amount: <input type="text" name="Amount" size="20">
<input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2">
<!-- Replace the value of Merch_id with your 5 digits SecurePay ID-->
<input type="hidden" name="Merch_id" value= "xxxxx">
<input type="hidden" name="ReturnURL" value="success.htm">
</form>


would it just be better to create a login and user access to sign in and then use the user restricted access option to add the page??
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 18, 2008 Feb 18, 2008
lilbodi wrote:
> yeah i see what youre saying. this is the example of the form that i use to go
> to from my pages, then redirects them to the payment form

You can create a unique token, store it as a session variable, and use
the session variable to control access to the success page (which would
need to be a PHP page, not a plain HTML one).

In the page that has the form, start a session by putting this at the
top of the script:

<?php
session_start();
$_SESSION['token'] = md5(uniqid(rand(), true));
?>

In the form itself:

<input type="hidden" name="ReturnURL" value="success.php?id=<?php echo
$_SESSION['token']; ?>">

In the top of success.php:

<?php
session_start();
if ($_GET['id'] != $_SESSION['token']) {
header('HTTP/1.1 403 Forbidden');
exit;
}

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Feb 18, 2008 Feb 18, 2008
SO THIS ONE WOULD GO ON THE TOP OF THE FORM WITH THE PAYMENT FORM BEFORE THE PAYMENT RIGHT??

In the page that has the form, start a session by putting this at the
top of the script:

<?php
session_start();
$_SESSION['token'] = md5(uniqid(rand(), true));
?>

THIS ONE WOULD GO ON THE PAYMENT FORM THEY PROVIDED FOR ME, AND THE "SUCCESS" IS THE ACTUAL PAGE THAT TAKES THEM TO MY FORM TO FILL OUT AFTER PAYMENT??

In the form itself:

<input type="hidden" name="ReturnURL" value="success.php?id=<?php echo
$_SESSION['token']; ?>">

In the top of success.php:

<?php
session_start();
if ($_GET['id'] != $_SESSION['token']) {
header('HTTP/1.1 403 Forbidden');
exit;
}

REASON I ASK, IS I TRIED IT AND WHEN I TESTED IT, IT GAVE ME A STRING ERROR
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 18, 2008 Feb 18, 2008
lilbodi wrote:
> REASON I ASK, IS I TRIED IT AND WHEN I TESTED IT, IT GAVE ME A STRING ERROR

Which page gave the error? What did the message actually say?

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Feb 19, 2008 Feb 19, 2008
Parse error: syntax error, unexpected '<' in /home/busine48/public_html/TMP3zpzwwibw8.php on line 8

that was the error i get when i add the top of "success.php"

the other page seems to work fine.
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Feb 23, 2008 Feb 23, 2008
Hey! Okay have a quick question for you... I was looking in your book, and what I have set up is a user registration page where it sends a welcome email and activation link, that all seems to work fine but when I test it, it keeps saying there is no date and header in the email. Do you recognize this or did I miss a step or something?
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 23, 2008 Feb 23, 2008
lilbodi wrote:
> it keeps
> saying there is no date and header in the email. Do you recognize this or did
> I miss a step or something?

What keeps saying there is no date and header in the email?

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Feb 23, 2008 Feb 23, 2008
Developer Details:
E-mail couldn't be sent. Error returned: Failed to send data [SMTP: Invalid response code received from server (code: 550, response: SITEGROUND: the message does not contain a header with the DATE)]. (EMAIL_FAILED)

AFTER.Trigger_ActivationEmail* (in the trace)

this is what i get everytime i test it, i cant figure out if it has something to do with the hosting/server or something i missed. i just used dreamweaver toolbox to create the login/register page. i didnt write any code addtional to what it created either...
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 24, 2008 Feb 24, 2008
lilbodi wrote:
> Developer Details:
> E-mail couldn't be sent. Error returned: Failed to send data [SMTP: Invalid
> response code received from server (code: 550, response: SITEGROUND: the
> message does not contain a header with the DATE)]. (EMAIL_FAILED)
>
> AFTER.Trigger_ActivationEmail* (in the trace)
>
> this is what i get everytime i test it, i cant figure out if it has something
> to do with the hosting/server or something i missed. i just used dreamweaver
> toolbox to create the login/register page.

If you're using ADDT, you need to ask questions about it in the ADDT
forum, or at least start a new thread here mentioning ADDT in the
subject line. I don't use ADDT, so I can't really help you. However, I
see that the response comes from the SMTP server. That suggests you
might be trying to send the mail from a local testing environment. The
PHP mail() function doesn't support SMTP authentication. It's designed
to hand mail directly to the server's mail transport agent (MTA). The
MTA should handle such issues as headers and dates.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 25, 2008 Feb 25, 2008
To: David Powers
Fr: Jim Puckett (636) 524-8273 work

Can't get Update record wizard to create a Filter (e.g. WHERE clause) that I can get to work. I have tried creating a Form Variable ("bonusnum") and binding it to my Form text field where I want to be able to type in the bonus_number I need to revise some information about, hit <Enter>, and have the record I want appear in the Update record wizard "created" table. Then make the desired changes and click on the Update record button.
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Feb 27, 2008 Feb 27, 2008
LATEST
hey again. okay i asked someone else this and they said to look under the "headers already sent" and i did that but did not find what i was looking for, that and it only brought up three things. so i am coming to you since you always seem to shoot me straight and it always works. i keep getting this error on my index page and all the includes are uploaded etc. the session start() and stuff is set right in the code part but i dont know why it says this....

Warning: session_start() [function.session-start]: Cannot send session
> cache
> limiter - headers already sent (output started at
> /home/gradsrus/public_html/index.php:2) in
> /home/gradsrus/public_html/index.php
> on line 6
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines