Databases
StackOverflow2013
Postsdbo
POUsing Insert and Update in a single function
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUsing Insert and Update in a single function
    primarykey
    data
    text
    <p>I was wondering if someone would be able to shed some light on how I may overcome this problem. </p> <p>I'm trying to add and update information on a database, so when a user first enters completes the questionnaire its fine and it works, However when they go back to update the questionnaire <strong>it throws an error</strong>, "Please go back and try again". </p> <p>I have updated the PHP code with the recommendations given to me so far.</p> <p>Thank You. </p> <p>PHP code: </p> <pre><code>function updatePartCTQ_part1($questionAns, $memberid) { //First Insert MemberID $ctqmemberinsert = "INSERT INTO ctq_questionnaire (user_id) VALUES ('$memberid')"; $addresult = mysqli_query($ctqmemberinsert); if ($addresult) { $update = "UPDATE ctq_questionnaire SET Item1= '{$questionAns[0]}', Item2 = '{$questionAns[1]}' WHERE user_id = '$memberid'"; mysqli_query($conn, $update); } else { echo 'Please go back and try again'; } } </code></pre> <p>Any help will be greatly appreciated.</p> <p><strong>Finished Code</strong></p> <p>Thanks to Michael and the rest of the guys I was able to get the code working, so I thought I'd post an update, if anyone else gets stuck they'd be able to have a glance at the working version of the code: </p> <pre><code>function updatePartCTQ_part1($questionAns, $memberid) { //Check whether user exists $exists = mysql_query("SELECT * FROM ct1_questionnaire WHERE user_id = '$memberid'"); if (mysql_num_rows($exists) === 0) { // Doesn't exist. INSERT User into Table $ctqmemberinsert = "INSERT INTO ctq_questionnaire (user_id) VALUES ('$memberid')"; mysqli_query($ctqmemberinsert); } // UDPATE after INSERT $update = "UPDATE ctq_questionnaire SET Item1= '{$questionAns[0]}', Item2 = '{$questionAns[1]}, Item3 = '{$questionAns[2]}', Item4 = '{$questionAns[3]}',Item5 = '{$questionAns[4]}', Item6 = '{$questionAns[5]}', Item7 = '{$questionAns[6]}', Item8 = '{$questionAns[7]}', Item9 = '{$questionAns[8]}', Item10 = '{$questionAns[9]}', Item11 = '{$questionAns[10]}', Item12 = '{$questionAns[11]}', Item13 = '{$questionAns[12]}', Item14 = '{$questionAns[13]}', Item15 = '{$questionAns[14]}' WHERE user_id = '$memberid'"; mysql_query($update); } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UScasperOne
    1. USStrangeLondoner
    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
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUsing Insert and Update in a single function
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POUsing Insert and Update in a single function
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POUsing Insert and Update in a single function
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIf I remember correctly, you can't use array indices when using a variable in a string like that. Try concatenation instead.
      singulars
      1. POUsing Insert and Update in a single function
      1. USGigi
    2. CO@Gigi Well, then, you remember incorrectly. :)
      singulars
      1. POUsing Insert and Update in a single function
      1. UShjpotter92
    3. CO@Gigi It will work, though is preferred to enclose them in `{}` as `{$questionAns[0]}`
      singulars
      1. POUsing Insert and Update in a single function
      1. USMichael Berkowski
 

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