Databases
StackOverflow2013
Postsdbo
POPHP - Check if data is in a table if so pass it to $_SESSIONS array
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP - Check if data is in a table if so pass it to $_SESSIONS array
    primarykey
    data
    text
    <p>Hi guys this is my first post here, there have been similar questions on this forum but I couldn't find one which accurately answered my question or at least it wasn't relevant enough for me to workout an answer - this is my 3rd day using PHP so I am still getting used to it..</p> <p>I am making a small game for my site where by users can pay a small amount of money to win a prize, the prize is a code which will be emailed to them.</p> <p>Currently I have my database and script setup so that the same code cannot be issued twice using the boolean Available which is set to 1 if the code has not been issued and 0 if it has</p> <p>I have my code table setup like so</p> <pre><code>CodeID | ItemID | CodeType | Available | Code | 1 | 1 | xxxxxxx | 1 | QLLxbttKQcHv4e4k | 2 | 1 | xxxxxxx | 1 | 6JKMumiH35Dke4SS | 3 | 3 | xxxxxxx | 0 | mQ2WyUjqNy5fJiEr | </code></pre> <p>What I want to do is check each code to see if it is available, if it is I want to take the ItemID and put it in a $_SESSIONS array which I can use in another page to only return results for codes that I have stocked</p> <p>I am having some trouble checking if the code is available and if it is putting the ItemID in the $_SESSIONS array</p> <p>Currently I have this to query the database</p> <pre><code>$stock = $conn -&gt; query('SELECT * FROM codes WHERE Available = 1'); </code></pre> <p>This checks the database and out puts all codes which are currently available, including duplicate ItemIDs</p> <p>Can anyone help me so that I only take 1 of each ItemID and put that into the $_SESSIONS array which I can use on the next page to only show results with available codes?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCoderrrr
    1. USCoderrrr
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWhy don't you perform the query on the next page so that you don't need to use Session at all?
      singulars
      1. POPHP - Check if data is in a table if so pass it to $_SESSIONS array
      1. USmauris
    2. COIt seems to me you are doing a mess, perhaps if you make it clearer what you need we can give you a better solution.
      singulars
      1. POPHP - Check if data is in a table if so pass it to $_SESSIONS array
      1. USHavenard
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload