Professional Web Applications Themes

Reuse value in another file? - MySQL

When processing a form I am reading in a value to a mysql database. I then redirect the user to a "thank you" page with Header. What I would like is to remind the user the value he has keyed in. In the following can I store $inx01 and echo its value in thankyou.php? <?php mysql_connect(" Codes Removed ") or die(mysql_error()); mysql_select_db(" Database Name removed ") or die(mysql_error()); $inx01=$_POST['fardvagonf']; mysql_query("INSERT INTO table1 VALUES ('$inx01')"); echo mysql_error(); mysql_close(); Header("Location: http://www.mydomain.com/thankyou.php"); exit; ?> Garry Jones Sweden...

  1. #1

    Default Reuse value in another file?

    When processing a form I am reading in a value to a mysql database. I then
    redirect the user to a "thank you" page with Header. What I would like is to
    remind the user the value he has keyed in.

    In the following can I store $inx01 and echo its value in thankyou.php?

    <?php
    mysql_connect(" Codes Removed ") or die(mysql_error());
    mysql_select_db(" Database Name removed ") or die(mysql_error());

    $inx01=$_POST['fardvagonf'];

    mysql_query("INSERT INTO table1 VALUES ('$inx01')");
    echo mysql_error();

    mysql_close();

    Header("Location: http://www.mydomain.com/thankyou.php");
    exit;

    ?>

    Garry Jones
    Sweden


    Garry Jones Guest

  2. #2

    Default Re: Reuse value in another file?

    Garry Jones wrote:
    > When processing a form I am reading in a value to a mysql database. I then
    > redirect the user to a "thank you" page with Header. What I would like is to
    > remind the user the value he has keyed in.
    >
    > In the following can I store $inx01 and echo its value in thankyou.php?
    >
    > <?php
    > mysql_connect(" Codes Removed ") or die(mysql_error());
    > mysql_select_db(" Database Name removed ") or die(mysql_error());
    >
    > $inx01=$_POST['fardvagonf'];
    >
    > mysql_query("INSERT INTO table1 VALUES ('$inx01')");
    > echo mysql_error();
    >
    > mysql_close();
    >
    > Header("Location: http://www.mydomain.com/thankyou.php");
    > exit;
    >
    > ?>
    >
    > Garry Jones
    > Sweden
    >
    >
    Garry,

    You can, but you'll have problems. First of all, you are inserting values into
    the table, but not deleting them. Which will be the correct value (remember -
    database entries are not ordered).

    Even if you delete the entry from the table in your second page, what happens
    when two people hit the submit button at the same time? Requests are not
    necessarily processed in order - in fact one request isn't necessarily completed
    before the next one starts. One user could get the other user's value, and if
    you delete the value in your second page, one user may get an error because the
    value isn't there.

    A better way to store it would be to use sessions.


    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    [email]jstucklexattglobal.net[/email]
    ==================
    Jerry Stuckle Guest

Similar Threads

  1. Reuse of Model in Front End
    By Brian Smith in forum ASP.NET Web Services
    Replies: 3
    Last Post: March 3rd, 07:57 AM
  2. Replies: 0
    Last Post: November 12th, 11:03 PM
  3. how to reuse sub
    By perl@swanmail.com in forum PERL Beginners
    Replies: 9
    Last Post: October 8th, 01:44 PM
  4. DataGrid Reuse
    By Merex in forum ASP.NET General
    Replies: 0
    Last Post: August 11th, 06:35 PM
  5. reuse repeater with new recordset
    By Bob in forum ASP.NET General
    Replies: 0
    Last Post: July 7th, 07:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139