Volver al Programación / Codificación foro

Agregar filas de una tabla en html y enviar a mysql [js, php, mysql, html]

  • dec
  • Born
  • Born
  • No Avatar
  • Registrado: Ene 02, 2012
  • Mensajes: 2
  • Status: Offline

Nota Enero 2nd, 2012, 3:54 am

Hola, quiero mi página para obtener información de usuario <input>, si el usuario prefiere, agregar más filas mismas y todos los discos enviar de smth a MYSQL.
Si quiero enviar 2 o más filas, PHP recoge y enviar sólo la última fila de información a MYSQL. Y me quiero quedar en la misma página (ahora redirige a send.php).

Aquí es lo que yo escribí:

índice.PHP
Código: [ Select ]
<style type="text/css">
table,tr,td{border:0px solid black;}
</style>

  <table id="titlebar" cellspacing="0px">
        <tr>
            <td style="width:20px;">&#10003;</td>
            <td style="width:160px;">Show</td>
            <td style="width:62px;">season</td>
            <td style="width:63px;">episode</td>
            <td style="width:100px;">language</td>
            <td style="width:190px;">Link 1</td>
            <td style="width:190px;">Link 2</td>
        </tr>
    </table>
    <form action="send.php" method="POST">
  <table id="dataTable" width="auto" style="margin:-4px 0 0 0;" cellspacing="0px">
    <tr>
      <td style="width:20px;"><INPUT type="checkbox" name="chk" /></td>
      <td><INPUT type="text" name="series" style="width:160px;" autocomplete="on" placeholder="Show" required/></td>
            <td><INPUT type="text" name="season" style="width:62px;" autocomplete="on" placeholder="season" required/></td>
            <td><INPUT type="text" name="episode" style="width:63px;" autocomplete="on" placeholder="episode" required/></td>
      <td>
        <SELECT name="language" style="width:100px;">
          <OPTION value="one">one</OPTION>
          <OPTION value="two">two</OPTION>
          <OPTION value="three">three</OPTION>
          <OPTION value="four">four</OPTION>
          <OPTION value="five">five</OPTION>
          <OPTION value="six">six</OPTION>
          <OPTION value="seven">seven</OPTION>
        </SELECT>
      </td>
            <td><INPUT type="text" name="link_1" style="width:190px;" autocomplete="on" placeholder="link 1" required/></td>
            <td><INPUT type="text" name="link_2" style="width:190px;" autocomplete="on" placeholder="link 2" required/></td>
    </tr>
  </table>
    <INPUT type="button" value="Add row" onclick="addRow('dataTable')" />
  <INPUT type="button" value="Delete row" onclick="deleteRow('dataTable')" />
    <INPUT type="submit" value="Send"/>
    </form>
  1. <style type="text/css">
  2. table,tr,td{border:0px solid black;}
  3. </style>
  5.   <table id="titlebar" cellspacing="0px">
  6.         <tr>
  7.             <td style="width:20px;">&#10003;</td>
  8.             <td style="width:160px;">Show</td>
  9.             <td style="width:62px;">season</td>
  10.             <td style="width:63px;">episode</td>
  11.             <td style="width:100px;">language</td>
  12.             <td style="width:190px;">Link 1</td>
  13.             <td style="width:190px;">Link 2</td>
  14.         </tr>
  15.     </table>
  16.     <form action="send.php" method="POST">
  17.   <table id="dataTable" width="auto" style="margin:-4px 0 0 0;" cellspacing="0px">
  18.     <tr>
  19.       <td style="width:20px;"><INPUT type="checkbox" name="chk" /></td>
  20.       <td><INPUT type="text" name="series" style="width:160px;" autocomplete="on" placeholder="Show" required/></td>
  21.             <td><INPUT type="text" name="season" style="width:62px;" autocomplete="on" placeholder="season" required/></td>
  22.             <td><INPUT type="text" name="episode" style="width:63px;" autocomplete="on" placeholder="episode" required/></td>
  23.       <td>
  24.         <SELECT name="language" style="width:100px;">
  25.           <OPTION value="one">one</OPTION>
  26.           <OPTION value="two">two</OPTION>
  27.           <OPTION value="three">three</OPTION>
  28.           <OPTION value="four">four</OPTION>
  29.           <OPTION value="five">five</OPTION>
  30.           <OPTION value="six">six</OPTION>
  31.           <OPTION value="seven">seven</OPTION>
  32.         </SELECT>
  33.       </td>
  34.             <td><INPUT type="text" name="link_1" style="width:190px;" autocomplete="on" placeholder="link 1" required/></td>
  35.             <td><INPUT type="text" name="link_2" style="width:190px;" autocomplete="on" placeholder="link 2" required/></td>
  36.     </tr>
  37.   </table>
  38.     <INPUT type="button" value="Add row" onclick="addRow('dataTable')" />
  39.   <INPUT type="button" value="Delete row" onclick="deleteRow('dataTable')" />
  40.     <INPUT type="submit" value="Send"/>
  41.     </form>


JavaScript (para agregar y eliminar filas)
Código: [ Select ]
function addRow(tableID) {

    var table = document.getElementById(tableID);

    var rowCount = table.rows.length;
    var row = table.insertRow(rowCount);

    var colCount = table.rows[0].cells.length;

    for(var i=0; i<colCount; i++) {

        var newcell = row.insertCell(i);

        newcell.innerHTML = table.rows[0].cells[i].innerHTML;
        //alert(newcell.childNodes);
        switch(newcell.childNodes[0].type) {
            case "text":
                newcell.childNodes[0].value = "";
                break;
            case "text":
                newcell.childNodes[0].value = "";
                break;
            case "text":
                newcell.childNodes[0].value = "";
                break;
            case "text":
                newcell.childNodes[0].value = "";
                break;
            case "text":
                newcell.childNodes[0].value = "";
                break;
            case "checkbox":
                newcell.childNodes[0].checked = false;
                break;
            case "select-one":
                newcell.childNodes[0].selectedIndex = 0;
                break;
        }
    }
}

function deleteRow(tableID) {
    try {
    var table = document.getElementById(tableID);
    var rowCount = table.rows.length;

    for(var i=0; i<rowCount; i++) {
        var row = table.rows[i];
        var chkbox = row.cells[0].childNodes[0];
        if(null != chkbox && true == chkbox.checked) {
            if(rowCount <= 1) {
                alert("Cant delete all rows");
                break;
            }
            table.deleteRow(i);
            rowCount--;
            i--;
        }

    }
    }catch(e) {
        alert(e);
    }
}
  1. function addRow(tableID) {
  3.     var table = document.getElementById(tableID);
  5.     var rowCount = table.rows.length;
  6.     var row = table.insertRow(rowCount);
  8.     var colCount = table.rows[0].cells.length;
  10.     for(var i=0; i<colCount; i++) {
  12.         var newcell = row.insertCell(i);
  14.         newcell.innerHTML = table.rows[0].cells[i].innerHTML;
  15.         //alert(newcell.childNodes);
  16.         switch(newcell.childNodes[0].type) {
  17.             case "text":
  18.                 newcell.childNodes[0].value = "";
  19.                 break;
  20.             case "text":
  21.                 newcell.childNodes[0].value = "";
  22.                 break;
  23.             case "text":
  24.                 newcell.childNodes[0].value = "";
  25.                 break;
  26.             case "text":
  27.                 newcell.childNodes[0].value = "";
  28.                 break;
  29.             case "text":
  30.                 newcell.childNodes[0].value = "";
  31.                 break;
  32.             case "checkbox":
  33.                 newcell.childNodes[0].checked = false;
  34.                 break;
  35.             case "select-one":
  36.                 newcell.childNodes[0].selectedIndex = 0;
  37.                 break;
  38.         }
  39.     }
  40. }
  42. function deleteRow(tableID) {
  43.     try {
  44.     var table = document.getElementById(tableID);
  45.     var rowCount = table.rows.length;
  47.     for(var i=0; i<rowCount; i++) {
  48.         var row = table.rows[i];
  49.         var chkbox = row.cells[0].childNodes[0];
  50.         if(null != chkbox && true == chkbox.checked) {
  51.             if(rowCount <= 1) {
  52.                 alert("Cant delete all rows");
  53.                 break;
  54.             }
  55.             table.deleteRow(i);
  56.             rowCount--;
  57.             i--;
  58.         }
  60.     }
  61.     }catch(e) {
  62.         alert(e);
  63.     }
  64. }


Send.php
Código: [ Select ]
<?php

include('mysql.php');

$seriesV = mysql_real_escape_string(stripslashes($_POST['series']));
$seasonV = mysql_real_escape_string(stripslashes($_POST['season']));
$episodeV = mysql_real_escape_string(stripslashes($_POST['episode']));
$languageV = mysql_real_escape_string(stripslashes($_POST['language']));
$link_1V = mysql_real_escape_string(stripslashes($_POST['link_1']));
$link_2V = mysql_real_escape_string(stripslashes($_POST['link_2']));

$sql="INSERT INTO episodes (seriesDB,seasonDB,episodeDB,langDB,link_1DB,link_2DB,dateDB)
 VALUES
 ('$seriesV','$seasonV','$episodeV','$languageV','$link_1V','$link_2V','".time()."')";


if (!mysql_query($sql,$con))
 {
 die('Error: ' . mysql_error());
 }
 echo "1 record added";

mysql_close($con);
?>
  1. <?php
  3. include('mysql.php');
  5. $seriesV = mysql_real_escape_string(stripslashes($_POST['series']));
  6. $seasonV = mysql_real_escape_string(stripslashes($_POST['season']));
  7. $episodeV = mysql_real_escape_string(stripslashes($_POST['episode']));
  8. $languageV = mysql_real_escape_string(stripslashes($_POST['language']));
  9. $link_1V = mysql_real_escape_string(stripslashes($_POST['link_1']));
  10. $link_2V = mysql_real_escape_string(stripslashes($_POST['link_2']));
  12. $sql="INSERT INTO episodes (seriesDB,seasonDB,episodeDB,langDB,link_1DB,link_2DB,dateDB)
  13.  VALUES
  14.  ('$seriesV','$seasonV','$episodeV','$languageV','$link_1V','$link_2V','".time()."')";
  17. if (!mysql_query($sql,$con))
  18.  {
  19.  die('Error: ' . mysql_error());
  20.  }
  21.  echo "1 record added";
  23. mysql_close($con);
  24. ?>


MySQL.php (se conecta a mysql)
Código: [ Select ]
<?php
$con = mysql_connect('localhost', 'user', 'pass') or die ('Error, cant login to DB');
mysql_select_db('tvseries') or die("Unable to select database");

?>
  1. <?php
  2. $con = mysql_connect('localhost', 'user', 'pass') or die ('Error, cant login to DB');
  3. mysql_select_db('tvseries') or die("Unable to select database");
  5. ?>


Attachments:
concept.png

the concept that is now created



lo siento mi inglés
  • Anonymous
  • Bot
  • No Avatar
  • Registrado: 25 Feb 2008
  • Mensajes: ?
  • Loc: Ozzuland
  • Status: Online

Nota Enero 2nd, 2012, 3:54 am

  • demonmaestro
  • Gold Member
  • Gold Member
  • Avatar de Usuario
  • Registrado: Jun 21, 2006
  • Mensajes: 485
  • Loc: Conroe, Texas
  • Status: Offline

Nota Enero 6th, 2012, 12:55 am

De lo que he entendido de lo está pidiendo es que una vez que el formulario sea enviado que quiere volver a la página index.php.
Buscar en línea 24 que había agregado. También Bienvenido a OZZU!

Código: [ Select ]
01.<?php
02.
03.include('mysql.php');
04.
05.$seriesV = mysql_real_escape_string(stripslashes($_POST['series']));
06.$seasonV = mysql_real_escape_string(stripslashes($_POST['season']));
07.$episodeV = mysql_real_escape_string(stripslashes($_POST['episode']));
08.$languageV = mysql_real_escape_string(stripslashes($_POST['language']));
09.$link_1V = mysql_real_escape_string(stripslashes($_POST['link_1']));
10.$link_2V = mysql_real_escape_string(stripslashes($_POST['link_2']));
11.
12.$sql="INSERT INTO episodes (seriesDB,seasonDB,episodeDB,langDB,link_1DB,link_2DB,dateDB)
13. VALUES
14. ('$seriesV','$seasonV','$episodeV','$languageV','$link_1V','$link_2V','".time()."')";
15.
16.
17.if (!mysql_query($sql,$con))
18. {
19. die('Error: ' . mysql_error());
20. }
21. echo "1 record added";
22.
23.mysql_close($con);
24.header('Location:index.php');
25.?>
  1. 01.<?php
  2. 02.
  3. 03.include('mysql.php');
  4. 04.
  5. 05.$seriesV = mysql_real_escape_string(stripslashes($_POST['series']));
  6. 06.$seasonV = mysql_real_escape_string(stripslashes($_POST['season']));
  7. 07.$episodeV = mysql_real_escape_string(stripslashes($_POST['episode']));
  8. 08.$languageV = mysql_real_escape_string(stripslashes($_POST['language']));
  9. 09.$link_1V = mysql_real_escape_string(stripslashes($_POST['link_1']));
  10. 10.$link_2V = mysql_real_escape_string(stripslashes($_POST['link_2']));
  11. 11.
  12. 12.$sql="INSERT INTO episodes (seriesDB,seasonDB,episodeDB,langDB,link_1DB,link_2DB,dateDB)
  13. 13. VALUES
  14. 14. ('$seriesV','$seasonV','$episodeV','$languageV','$link_1V','$link_2V','".time()."')";
  15. 15.
  16. 16.
  17. 17.if (!mysql_query($sql,$con))
  18. 18. {
  19. 19. die('Error: ' . mysql_error());
  20. 20. }
  21. 21. echo "1 record added";
  22. 22.
  23. 23.mysql_close($con);
  24. 24.header('Location:index.php');
  25. 25.?>
Thanks, Josh --DemonMaestro
www.LilNetwork.com
Fun Website www.ShoutsCloud.com
  • dec
  • Born
  • Born
  • No Avatar
  • Registrado: Ene 02, 2012
  • Mensajes: 2
  • Status: Offline

Nota Enero 7th, 2012, 2:54 am

Averiguado código yo, heres el código si alguien la necesita

Código: [ Select ]
<?php
if(isset($_REQUEST['submit'])) {
include('mysql.php');
$count = 0;
$count = count($_POST['lang']) - 1;
for($i = 0; $i <= $count; $i++){
  $seriesV = mysql_real_escape_string($_POST['series'][$i]);
  $seasonV = mysql_real_escape_string($_POST['season'][$i]);
  $episodeV = mysql_real_escape_string($_POST['episode'][$i]);
  $languageV = mysql_real_escape_string($_POST['language'][$i]);
  $link_1V = mysql_real_escape_string($_POST['link_1'][$i]);
  $link_2V = mysql_real_escape_string($_POST['link_2'][$i]);
  $sql=mysql_query("INSERT INTO episodes (seriesDB,seasonDB,episodeDB,langdb,link_1DB,link_2DB,dateDB)
   VALUES
   ('$seriesV','$seasonV','$episodeV','$languageV','$link_1V','$link_2V','".time()."')") or die(mysql_error());
};

mysql_close();
}

header('Location: index.php');
?>
  1. <?php
  2. if(isset($_REQUEST['submit'])) {
  3. include('mysql.php');
  4. $count = 0;
  5. $count = count($_POST['lang']) - 1;
  6. for($i = 0; $i <= $count; $i++){
  7.   $seriesV = mysql_real_escape_string($_POST['series'][$i]);
  8.   $seasonV = mysql_real_escape_string($_POST['season'][$i]);
  9.   $episodeV = mysql_real_escape_string($_POST['episode'][$i]);
  10.   $languageV = mysql_real_escape_string($_POST['language'][$i]);
  11.   $link_1V = mysql_real_escape_string($_POST['link_1'][$i]);
  12.   $link_2V = mysql_real_escape_string($_POST['link_2'][$i]);
  13.   $sql=mysql_query("INSERT INTO episodes (seriesDB,seasonDB,episodeDB,langdb,link_1DB,link_2DB,dateDB)
  14.    VALUES
  15.    ('$seriesV','$seasonV','$episodeV','$languageV','$link_1V','$link_2V','".time()."')") or die(mysql_error());
  16. };
  18. mysql_close();
  19. }
  21. header('Location: index.php');
  22. ?>


Y es necesario agregar corchetes para nombre de la matriz = "temporada []"

Página 1 de 1

Publicar Información

  • Total de mensajes en este tema: 3 mensajes
  • Usuarios navegando por este Foro: No hay usuarios registrados visitando el Foro y 231 invitados
  • No puede abrir nuevos temas en este Foro
  • No puede responder a temas en este Foro
  • No puede editar sus mensajes en este Foro
  • No puede borrar sus mensajes en este Foro
  • No puede enviar adjuntos en este Foro
 
 

© 2011 Unmelted, LLC. Ozzu® es una marca registrada de Unmelted, LLC