Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Checkboxes are only posted when they are ticked. So if the checkbox is not ticked, is will not appear in <code>$_POST</code>. Also you should generally not give any values to checkboxes. Instead use names to distinguish between them.</p> <p>In the database I usually represent checkboxes with tinyints and store 1 for checked and 0 for unchecked.</p> <pre><code>// If your checkbox name is foo, this will convert it // into a value that can be stored in the database $foo = isset($_POST['foo']) ? 1 : 0; </code></pre> <p>Also note that html requires ids to be unique. So you can't have multiple elements with the same id. And you should sanitize your inputs to prevent sql injection. Use <code>mysql_real_escape_string()</code> on user inputs that go in the database.</p> <p><strong>Update</strong></p> <p>The main issue is that the query is missing a '<code>)</code>' at the last line. The query should look like</p> <pre><code>$query = "INSERT INTO markers (ciudad, zona,address,name, telefono,email,piso, tipo,erasmus,nhabitaciones, plazas,equipHabita,nbanos, salon,cocina,electrodomesticos, garaje,internet,calefaccion, sexo,precio,superficie,otros, fecha,lat,lng) VALUES ('{$_POST['ciudad']}','{$_POST['zona']}', '{$_POST['address']}','{$_POST['name']}','{$_POST['telefono']}', '{$_POST['email']}','{$_POST['piso']}','{$_POST['tipo']}', '{$_POST['erasmus']}','{$_POST['nhabitaciones']}', '{$_POST['plazas']}','{$equipHabitaF}', '{$_POST['nbanos']}','{$equipSalonF}', '{$equipCocinaF}','{$equipElectroF}','{$_POST['garaje']}', '{$_POST['internet']}','{$_POST['calefaccion']}', '{$_POST['sexo']}','{$_POST['precio']}', '{$_POST['superficie']}','{$_POST['otrosF']}', '{$_POST['fecha']}','{$_POST['lat']}', '{$_POST['lng']}')"; mysql_query($query, $link); </code></pre> <p>Note the closing '<code>)</code>' on the last line of the query. Also note that creating the query like this, in a variable, allows you to output the created query so you can see what exactly is sent to MySQL and you also can test your query in a different environment (ie in phpmyadmin or any other database administration tool).</p>
    singulars
    1. This table or related slice is empty.
    1. POInserting checkbox values into MySQL Database with PHP
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USThisBoyPerforms
    1. USArjan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POInserting checkbox values into MySQL Database with PHP
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    1. COThanks for the answer, but I'm trying to store the values of the checkboxes, not if they're checked or not. I want to make a string with the values of the checkboxes and store them into de MySQL DB. ¿Is this possible?
      singulars
      1. PO
      1. USdanielrozo
    2. COYou may be able to get a proper value in your `$_POST` for a checked checkbox, but if the checkbox is not checked then it will never be posted. So you have to implement logic to see which values have been posted and use that to determine which values have not been posted.
      singulars
      1. PO
      1. USArjan
    3. COYou should more carefully look the code he's posting. He's quoting the $_POST values, so there shouldn't be any problems, no matter whether the checkboxes are checked or not.
      singulars
      1. PO
      1. USperiklis
 

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