Databases
StackOverflow2013
Postsdbo
POIf input empty, no insert in mysql (pdo)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIf input empty, no insert in mysql (pdo)
    primarykey
    data
    text
    <p>If any of input fields is blank, then do not insert in mysql. It is possible (acceptable) that some of input fields are blank. In such case I need to insert non blank fields (values). But the script does not insert at all.</p> <p>I can write something like </p> <pre><code>if ( (strlen($date_day1) &lt; 1) ) { $date_day1 = 0; } </code></pre> <p>But may be better solution? If empty input field, insert all other fields. Empty field may not insert or inser 0.</p> <p>Input</p> <pre><code>&lt;input type="text" name="date_day1" id="date_day1"&lt;/td&gt; &lt;input type="text" name="amount1" id="amount1"&lt;/td&gt; &lt;input type="text" name="row_id1" id="row_id1"&lt;/td&gt; </code></pre> <p>Then ajax get input values</p> <pre><code>$(document).ready(function(){ autosave(); }); function autosave() { var t = setTimeout("autosave()", 5000); var date_day1 = $("#date_day1").val(); var amount1 = $("#amount1").val(); var row_id1 = $("#row_id1").val(); $.ajax( { type: "POST", url: "_autosave.php", data: "date_day1=" + date_day1 + "&amp;amount1=" + amount1+ "&amp;row_id1=" + row_id1, cache: false, } ); } </code></pre> <p>Then php get variables</p> <pre><code>$date_day1 = $_POST['date_day1']; $amount1 = $_POST['amount1']; $row_id1 = $_POST['row_id1']; </code></pre> <p>And then try to record in mysql</p> <pre><code>$stmt_insert = $db-&gt;prepare("INSERT INTO 2_1_journal(RecordDay, Amount, RowId) VALUES(:RecordDay,:Amount,:RowId)"); $stmt_insert-&gt;execute(array(':RecordDay' =&gt; $date_day1, ':Amount' =&gt; $amount1, ':RowId' =&gt; $row_id1, </code></pre> <p>));</p> <p><strong>Update</strong></p> <p>With such changed ajax insert works, but this does not work <code>success: function(){ document.getElementById('is_row_changed1').value = 0;}</code></p> <pre><code>$(document).ready(function(){ autosave(); }); function autosave() { var t = setTimeout("autosave()", 5000); var date_day1 = $("#date_day1").val(); var amount1 = $("#amount1").val(); var row_id1 = $("#row_id1").val(); if ($("#is_row_changed1").val() &gt; 0) { $.ajax( { type: "POST", url: "_autosave.php", dataType: "json", data: {"date_day1" : date_day1, "amount1" : amount1, "row_id1" : row_id1}, cache: false, success: function(){ document.getElementById('is_row_changed1').value = 0; } } ); } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser2232696
    1. USuser2232696
    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
    1. VO
      singulars
      1. POIf input empty, no insert in mysql (pdo)
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POIf input empty, no insert in mysql (pdo)
      1. USuser2360838
      1. VTFavorite
    3. VO
      singulars
      1. POIf input empty, no insert in mysql (pdo)
      1. This table or related slice is empty.
      1. VTDownMod
    1. COTypo: `$row_id_1` is not the same as `$row_id1`. That's probably why the database refuses to store the record...it has no ID.
      singulars
      1. POIf input empty, no insert in mysql (pdo)
      1. USTill Helge
    2. CONo, no row_id_1 is my mistyping here. Everywhere is row_id1
      singulars
      1. POIf input empty, no insert in mysql (pdo)
      1. USuser2232696
    3. COAdd `$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);` to your code to see whether there was an error executing your insert statement.
      singulars
      1. POIf input empty, no insert in mysql (pdo)
      1. USTill Helge
 

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