Professional Web Applications Themes

Need advice on extracting database entries - MySQL

I'm not sure how I need to proceed on this and can use a bit of advice. I have a non-profit's web site that wishes to allow their members to fill out information regarding summer camp information (name, contact info, mailing info, physician's name, etc) online and submit it. I can handle taking the info with PHP and putting it into a mySQL database easily. But what has me stuck is that they want the ability to print out hard copies of selected submissions (their choice) if they need to. Would I have to display all the database entries in ...

  1. #1

    Default Need advice on extracting database entries

    I'm not sure how I need to proceed on this and can use a bit of advice.

    I have a non-profit's web site that wishes to allow their members to
    fill out information regarding summer camp information (name, contact
    info, mailing info, physician's name, etc) online and submit it. I can
    handle taking the info with PHP and putting it into a mySQL database easily.

    But what has me stuck is that they want the ability to print out hard
    copies of selected submissions (their choice) if they need to.

    Would I have to display all the database entries in a form on a new page
    with a select box next to each entry and have them pick that way, then
    loop through and print out the selected ones or is there a better, more
    direct (read: easier) way to accomplish this?

    Does this sound like something for which there may be a pre-written PHP
    script that can be altered?
    JackM Guest

  2. #2

    Default Re: Need advice on extracting database entries

    You list the entries and add sth. like
    <input type="select" name="subm[]" value="$ID" />
    after each one where $ID is the submission's id.

    Now you can simply evaluate the form data:
    foreach ($_POST['subm'] as $id) {
    // print submission no. $id here
    }

    milahu Guest

Similar Threads

  1. Replies: 1
    Last Post: July 10th, 11:08 AM
  2. How to group Typo entries in a database
    By premgrps@gmail.com in forum MySQL
    Replies: 2
    Last Post: June 30th, 06:58 AM
  3. BLANK ENTRIES IN ACCESS DATABASE
    By Black People Online in forum Coldfusion Database Access
    Replies: 1
    Last Post: May 30th, 06:21 AM
  4. Flash forms and blank database entries
    By Black People Online in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: May 25th, 10:41 PM
  5. Duplicate Database Entries
    By kabalah in forum Dreamweaver AppDev
    Replies: 1
    Last Post: April 7th, 01:28 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