Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>after reading your comment. it seems you are trying to send a rows of data. insted of putting for element name and id like the following </p> <pre><code>name="asignatura_lun_'+cuentaInputs+'" </code></pre> <p>use array indexing </p> <pre><code>name="asignatura_lun['+cuentaInputs+']" </code></pre> <p>this way you'll get following arrays in php</p> <pre><code>$_POST['hora'] $_POST['asignatura_lun'] $_POST['id_usuario_lun'] //likewise for mar, mie, jue and vie </code></pre> <p>at the php side loop for hora array using foreach</p> <pre><code>foreach($_POST['hora'] as $key =&gt; $value) //use $key for referencing other arrays. { for($j=1; $j&lt;6; $j++) { if($j==1) { //use $key for referencing other arrays. $asignatura=$_POST["asignatura_lun"][$key]; $id_usuario=$_POST["id_usuario_lun"][$key]; $hora=$value; //$value is current horra $consulta = "INSERT INTO horarios (asignatura, curso, clase, fecha, hora, id_usuario) VALUES ('$asignatura', '$curso','$clase','lunes','$hora','$id_usuario')"; echo $consulta; } //same for other weekdays } } </code></pre> <p><strong>Reference</strong>: Read this <a href="https://stackoverflow.com/q/18723457/656539">question and answer</a>.</p> <hr> <p>Before Edit :</p> <p>I really cant understand most of your code. Please try to use english identifiers. but on a brief look, using a hidden input element should solve your problem. add this in your form which submits to procesar_horario.php</p> <pre><code>&lt;input type='hidden' name='cuentaInputs' id='cuentaInputs'/&gt; </code></pre> <p>you can update its value whenever you update cuentaInputs.</p> <pre><code>$('#cuentaInputs').val(cuentaInputs); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POPassing a variable from Jquery to PHP ($_POST)
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USMohit
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPassing a variable from Jquery to PHP ($_POST)
      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. VTAcceptedByOriginator
    1. COAlthough a more appropriate way will be to have a method submit the form and let that method prepare the values which needs to be sent to the server. check http://api.jquery.com/submit . If you need help with that. please modify and minimise your code a bit considering english only folks.
      singulars
      1. PO
      1. USMohit
    2. COIt doesn´t work. I explain to you. I need this variable to count the number of rows has the table created dynamically while Jquery. I want the "cuentaInputs" variable for using it in the "for" to insert data in MYSQL.
      singulars
      1. PO
      1. USAlonso González Nestal
    3. COi have updated the answer. and please Do go through [Loenix's](http://stackoverflow.com/a/19369424/656539) answer. Writing hora and profesor is good from user's point of view. But keep spanish or any other language only in UI. in the code/variable names, use english. It helps other english speakers working with you.
      singulars
      1. PO
      1. USMohit
 

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