Databases
StackOverflow2013
Postsdbo
POpost not completely posted PHP
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POpost not completely posted PHP
    primarykey
    data
    text
    <p>I have a select value 'post', when someone wants to change the status of the post from unsolved to solved they have to choose a post en than click 'change to solved'</p> <p>The problem is when I click on the button, it doesn't change because PHP takes not the whole title of the post. So when my post is called 'Photoshop crashes', it only sends 'Photoshop'. That's why it doesn't update in my database, the query can't find the right post, when the title of the post is only 1 word, my table gets updated.</p> <pre><code>&lt;?php if (isset($_POST['btnSolved'])) { // wanneer er op de knop geklikt is proberen we user te saven in de databank if (!empty($_POST['btnSolved'])) { $solved = $_POST['unsolved']; $conn = new mysqli("localhost","root","root","PhpProject"); if ($conn -&gt; connect_errno) { throw new Exception("No connection with database!"); } else { $sql = "UPDATE Posts SET status = 'Solved' WHERE post='".$solved."'"; } } $conn-&gt;query($sql); } ?&gt; </code></pre> <p>In my body:</p> <pre><code>&lt;h3&gt;Change status&lt;/h3&gt; &lt;form action="&lt;?php echo $_SERVER['PHP_SELF'];?&gt;" method="post"&gt; &lt;?php if(mysqli_num_rows($showBugs) &gt; 0) { echo "&lt;select name= unsolved&gt;"; while ($row = mysqli_fetch_assoc($showBugs)) { echo "&lt;option value=" . $row['subject'] . "&gt;" . $row['subject'] . "&lt;/option&gt;"; } echo "&lt;/select&gt;"; } ?&gt; &lt;br /&gt; &lt;input class="btn btn-info dropdown-toggle" type="submit" name="btnSolved" value="Change to solved" /&gt; &lt;/form&gt; </code></pre> <p>This is what I get when I do a print of the $sql</p> <pre><code>UPDATE Posts SET status = 'Solved' WHERE post='Photoshop' </code></pre> <p>Does someone know why PHP can post 1 word, but not the whole title? It might be something stupid, but I don't know how to fix this.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USLupicora
    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
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYour browser has a "View source" feature (typically reached by hitting Ctrl+U). Use it to find out how your `<option>` elements look like.
      singulars
      1. POpost not completely posted PHP
      1. USÁlvaro González
    2. COIt's the same as the print. <option value="Photoshop" crasht="">Photoshop crasht</option> How can I change that? Putting the id instead of the subject?
      singulars
      1. POpost not completely posted PHP
      1. USLupicora
    3. CO@Lupicora - you need to enclose your value in the single quotes. Check my answer.
      singulars
      1. POpost not completely posted PHP
      1. USRikesh
 

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