Simple PHP approve/deny

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Igoogler
    #1

    Simple PHP approve/deny

    Here's what I want to do
    I have a form on my site that lets people add a word and then submit
    it. It gets submitted to a secondary database. I would then go to the
    script and it would show all the words that were added and I could
    approve or deny. By approving it would copy that specific row in the
    secondary db to the primary which shows on the site live and by
    denying it would keep it in the secondary (to prevent duplicates) and
    remove it from the script approve/deny page.

    I hope this all makes sense.

    Thanks in advance,
    Bryan
    Tags: None
    • Captain Paralytic
      #2
      Re: Simple PHP approve/deny

      On 20 Sep, 21:20, Igoogler <Galat...@gmail .comwrote:
      Here's what I want to do
      I have a form on my site that lets people add a word and then submit
      it. It gets submitted to a secondary database. I would then go to the
      script and it would show all the words that were added and I could
      approve or deny. By approving it would copy that specific row in the
      secondary db to the primary which shows on the site live and by
      denying it would keep it in the secondary (to prevent duplicates) and
      remove it from the script approve/deny page.
      >
      I hope this all makes sense.
      >
      Thanks in advance,
      Bryan
      Why not just have one table with an "approved" column. When the word
      gets written to the table, the approved column is blank, when you
      approve it, put a 1 in.

      The query to display words will only display those with a 1 in the
      approved column.

        Comment

        • Igoogler
          #3
          Re: Simple PHP approve/deny

          On Sep 20, 1:24 pm, Captain Paralytic <paul_laut...@y ahoo.comwrote:
          On 20 Sep, 21:20, Igoogler <Galat...@gmail .comwrote:
          >
          Here's what I want to do
          I have a form on my site that lets people add a word and then submit
          it. It gets submitted to a secondary database. I would then go to the
          script and it would show all the words that were added and I could
          approve or deny. By approving it would copy that specific row in the
          secondary db to the primary which shows on the site live and by
          denying it would keep it in the secondary (to prevent duplicates) and
          remove it from the script approve/deny page.
          >
          I hope this all makes sense.
          >
          Thanks in advance,
          Bryan
          >
          Why not just have one table with an "approved" column. When the word
          gets written to the table, the approved column is blank, when you
          approve it, put a 1 in.
          >
          The query to display words will only display those with a 1 in the
          approved column.
          You know, that really isn't a bad idea. I think I might try that
          instead. Thanks!

            Comment

            • sheldonlg
              #4
              Re: Simple PHP approve/deny

              Igoogler wrote:
              On Sep 20, 1:24 pm, Captain Paralytic <paul_laut...@y ahoo.comwrote:
              >On 20 Sep, 21:20, Igoogler <Galat...@gmail .comwrote:
              >>
              >>Here's what I want to do
              >>I have a form on my site that lets people add a word and then submit
              >>it. It gets submitted to a secondary database. I would then go to the
              >>script and it would show all the words that were added and I could
              >>approve or deny. By approving it would copy that specific row in the
              >>secondary db to the primary which shows on the site live and by
              >>denying it would keep it in the secondary (to prevent duplicates) and
              >>remove it from the script approve/deny page.
              >>I hope this all makes sense.
              >>Thanks in advance,
              >>Bryan
              >Why not just have one table with an "approved" column. When the word
              >gets written to the table, the approved column is blank, when you
              >approve it, put a 1 in.
              >>
              >The query to display words will only display those with a 1 in the
              >approved column.
              >
              You know, that really isn't a bad idea. I think I might try that
              instead. Thanks!
              Also, make the words column unique. That way no duplicate can be added.

                Comment

                • Captain Paralytic
                  #5
                  Re: Simple PHP approve/deny

                  On 20 Sep, 21:26, Igoogler <Galat...@gmail .comwrote:
                  On Sep 20, 1:24 pm, Captain Paralytic <paul_laut...@y ahoo.comwrote:
                  >
                  >
                  >
                  >
                  >
                  On 20 Sep, 21:20, Igoogler <Galat...@gmail .comwrote:
                  >
                  Here's what I want to do
                  I have a form on my site that lets people add a word and then submit
                  it. It gets submitted to a secondary database. I would then go to the
                  script and it would show all the words that were added and I could
                  approve or deny. By approving it would copy that specific row in the
                  secondary db to the primary which shows on the site live and by
                  denying it would keep it in the secondary (to prevent duplicates) and
                  remove it from the script approve/deny page.
                  >
                  I hope this all makes sense.
                  >
                  Thanks in advance,
                  Bryan
                  >
                  Why not just have one table with an "approved" column. When the word
                  gets written to the table, the approved column is blank, when you
                  approve it, put a 1 in.
                  >
                  The query to display words will only display those with a 1 in the
                  approved column.
                  >
                  You know, that really isn't a bad idea.
                  I'm glad I've learnt something useful in all my years as an analyst/
                  programmer!

                    Comment

                    Previous template Next
                    Working...