Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You could use: <a href="http://php.net/manual/en/mysqli.insert-id.php" rel="nofollow">http://php.net/manual/en/mysqli.insert-id.php</a></p> <p>mysql_insert_id</p> <p>Finds the last id updated or set and stores it. We then check to make sure the last id does not exist.</p> <p>so...</p> <pre><code>//last id being the id of the last query set or updated $last_id = $mysql-&gt;insert_id; if($last_id != $id) { //execute code { else { echo "last id already in database!"; } </code></pre> <p>If I misinterpreted the question you should still be able to see how to use that last id to do what you want.</p> <p>Here is an example of it being used. First we update the table with the form data which created our ID. Then we add the input check boxes array to the last id updated.</p> <pre><code>//define input variables $lesson_id = $_POST['lesson_id']; $user_id = $_POST['user_id']; $instructor_id = $_POST['instructor_id']; $lesson_comments = $_POST['lesson_comments']; $lesson_date = date("Y-m-d"); $video_ids = isset($_POST['checkbox']) ? $_POST['checkbox'] : array(); # this is called a ternary operator //insert lesson information first $query ="INSERT INTO swing_viewer_lessons (lesson_id, user_id, instructor_id, lesson_comments, lesson_date) VALUES (?, ?, ?, ?, ?)"; if ($stmt = $mysqli-&gt;prepare($query)) { $stmt-&gt;bind_param("iiiss", $lesson_id, $user_id, $instructor_id, $lesson_comments, $lesson_date); $stmt-&gt;execute(); //printf($stmt-&gt;error); echo "successful"; //echo "$last_id"; } //insert lesson information if (is_array($video_ids) &amp;&amp; count($video_ids) &gt; 0) { foreach($video_ids as $list); } // Make it into a comma separated list $rec_ids = implode(',', $video_ids); //get last inserted id from above $last_id= $mysqli-&gt;insert_id; //finally query and update lesson information based on the last id added from above $query ="UPDATE swing_viewer_lessons SET video_ids=? WHERE id=?"; if ($stmt = $mysqli-&gt;prepare($query)) { $stmt-&gt;bind_param("si", $rec_ids, $last_id); $stmt-&gt;execute(); } </code></pre> <p>Hopefully this helps you or anyone else for that matter, as at one point I was pulling hair at this.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to SELECT a record, UPDATE it and be sure it hasn't been updated in the mean?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USNick N
    1. USNick N
    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. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    1. COYou seem to be solving for the opposite case (`update` *then* `select`)
      singulars
      1. PO
      1. USHamish
    2. CODid you not read what I wrote? It is an example of work which you could use to reference. I won't do work for you. I will help you. Is that not the motto around here? Down vote for what?
      singulars
      1. PO
      1. USNick N
    3. COI didn't ask the question.
      singulars
      1. PO
      1. USHamish
 

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