How to insert textbox value & dxDatagrid all selected value in database on one single button click?

Question

I am having input tag(textbox) and dxDatagrid. I am able to pass all selected value from dxDatagrid to database, but i also want to pass text box(which is outside of grid) value along with it on one button click.

$("#myButton").dxButton({
    text: "Test",
    onClick: function () {
        var stones = (JSON.stringify(dataGrid.getSelectedRowsData()));
        console.log(stones);
        updatedetgridReturnShip(stones);
    }
});



function updatedetgridReturnShip(stonedetailsarr){
    $('#sloader').show();
    $.ajax({
        url: 'php/insertGridReturnShipment.php',
        dataType: 'json',
        type: "POST",
        data: {
            returnstonedetails: stonedetailsarr,
            txtRefnoval : txtRefnoval
        },
        success: function (result) {
            alert(result);
            $('#sloader').hide();
            $("#myImportModal").modal("hide");
        }
    });
}

PHP Server side code:

$StoneArr = json_decode($returnstonedetails, true);

$updstmt = '';

foreach ($StoneArr as $Stone){
  $textboxval = $_POST['textboxval'];

  $refVal = json_decode($textboxval, true);

  $updstmt .= 'CALL return_ship_stones('.'"'.$Stone["carat"].'"'.',
  '.'"'.$Stone["clarity"].'"'.','.'"'.$Stone["color"].'"'.','.'"'.$Stone["invcno"].'"'.','.'"'.$Stone["invoicedate"].'"'.', '.'"'.$Stone["lab"].'"'.', 
  '.'"'.$Stone["measurement"].'"'.' , '.'"'.$Stone["ppt"].'"'.' , '.'"'.$Stone["qstonesid"].'"'.' , '.'"'.$Stone["qty"].'"'.' ,
  '.'"'.$Stone["reportno"].'"'.' , '.'"'.$Stone["shape"].'"'.' , '.'"'.$Stone["totalvalue"].'"'.', '.'"'.$refVal["referenceid"].'"'.');';
}

on one single click how to pass both textbox, and dxDatagrid value in database

i am new to a PHP and JS, any help will be appreciated. I want to pass textbox and gridvalue combine in database. — convicted, Oct 22 '19 at 07:32
Where is your html code for textbox, are you using any id for textbox — Rishab, Oct 22 '19 at 07:34
when you are passing the textbox value it is not any array. so no need to do json_decode() — Rishab, Oct 22 '19 at 08:43

score 0 · Accepted Answer · edited Oct 22 '19 at 11:29

0

You can use the jquery method to get the value from the text input by id and pass it to ajax data parameter:

$('#refno').val().trim()

Code Below:

function updatedetgridReturnShip(stonedetailsarr){
    $('#sloader').show();

      $.ajax({
          url: 'php/insertGridReturnShipment.php',
          dataType: 'json',
          type: "POST",
          data: {
              returnstonedetails: stonedetailsarr,
              txtRefnoval : txtRefnoval,
              textboxval: $('#refno').val().trim()
          },
          success: function (result) {
              alert(result);
              $('#sloader').hide();
              $("#myImportModal").modal("hide");
          }
      });
  }

PHP code:

<?
$returnstonedetails = $_REQUEST['returnstonedetails'];

$StoneArr = json_decode($returnstonedetails, true);

$updstmt = '';

foreach ($StoneArr as $Stone){
  $textboxval = $_REQUEST['textboxval'];
  $refVal = $textboxval;

  $updstmt .= 'CALL return_ship_stones('.'"'.$Stone["carat"].'"'.',
  '.'"'.$Stone["clarity"].'"'.','.'"'.$Stone["color"].'"'.','.'"'.$Stone["invcno"].'"'.','.'"'.$Stone["invoicedate"].'"'.', '.'"'.$Stone["lab"].'"'.', 
  '.'"'.$Stone["measurement"].'"'.' , '.'"'.$Stone["ppt"].'"'.' , '.'"'.$Stone["qstonesid"].'"'.' , '.'"'.$Stone["qty"].'"'.' ,
  '.'"'.$Stone["reportno"].'"'.' , '.'"'.$Stone["shape"].'"'.' , '.'"'.$Stone["totalvalue"].'"'.', '.'"'.$refVal.'"'.');';
}

edited Oct 22 '19 at 11:29

Jordan Lipana

437
2
4
18

answered Oct 22 '19 at 07:38

Rishab

1,484
2
11
22

hi @Rishab,thanks for quick reply, how can i pass to PHP server side combine in foreach loop. – convicted Oct 22 '19 at 07:49
Can you add your server side code will help you out – Rishab Oct 22 '19 at 08:21
Hi @rishab, i shared please check, i want to pass that #refno with each n every row of grid. – convicted Oct 22 '19 at 08:39
Hi @Rishab, Thank you, for your support. – convicted Oct 22 '19 at 09:21
Hi @Rishab, one problem here, if you can help, getting this error while inserting using stored procedure, Error
Incorrect date value: '' for column ``.``.`_invoicedate` at row 1
1292 – convicted Oct 23 '19 at 12:14
Hi what is database structure type for that column? – Rishab Oct 23 '19 at 12:19
it is "DATE" for table and "DATETIME"in procedure @Rishab – convicted Oct 23 '19 at 12:28
if data type is DATE then you can't add DATETIME value in it .. try to add date only – Rishab Oct 23 '19 at 12:31
hi @Rishab, i am passing only date but not working. – convicted Oct 23 '19 at 12:39
I am getting error at database level, and i am passing date only not datetime – convicted Oct 23 '19 at 13:15

How to insert textbox value & dxDatagrid all selected value in database on one single button click?

1 Answers1