Databases
StackOverflow2013
Postsdbo
POSome text boxes become blank when click on submit
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSome text boxes become blank when click on submit
    primarykey
    data
    text
    <p>On my webpage when you click on submit to submit the form several text boxes suddenly become blank after clicking submit and so the data fails to be inputted into the database. I get this error appearing:</p> <p>string(0) "" Incorrect integer value: '' for column 'TotalProfit' at row 1</p> <p>I know why it says "string(0) "" " and that is because it is dumping the variable $TruckDamagePost but because the text box goes blank it tries to submit it as blank.</p> <p>The textboxes that become blank are: total-profit late-fee fines-cost travel-expenses fuel-cost truck-damage cargo-damage</p> <p>Here is my <strong>HTML Code</strong> for the webpage:</p> <pre><code>&lt;head&gt; &lt;!-- Appears in the title bar in web browser --&gt; &lt;title&gt;JWT Haulage Group Drivers Area&lt;/title&gt; &lt;meta name="description" content="JWT Haulage Group Ltd is a virtual trucking company for Euro Truck Simulator 2, UK and German Truck Simulator. We have over 600 drivers registered already."&gt; &lt;!-- Meta Stuff Required --&gt; &lt;meta name="keywords" content="JWT, JWT Haulage, JWT Haulage Group, JWT Haulage Ltd, Euro Truck Simulator 2, ETS2, UK Truck Simulator, UKTS, German Truck Simulator, GTS, Virtual Trucking Company, VTC"&gt; &lt;meta http-equiv="content-type" content="text/html; charset=utf-8" /&gt; &lt;!-- Meta Stuff Required --&gt; &lt;link rel="stylesheet" type="text/css" href="styles.css" /&gt; &lt;!-- CSS --&gt; &lt;script src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"&gt;&lt;/script&gt; &lt;!-- JQuery --&gt; &lt;script type="text/javascript"&gt; var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-37114333-2']); _gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); })(); &lt;/script&gt; &lt;script&gt; $(function() { if(!$.support.placeholder) { var active = document.activeElement; $(':text').focus(function () { if ($(this).attr('placeholder') != '' &amp;&amp; $(this).val() == $(this).attr('placeholder')) { $(this).val('').removeClass('hasPlaceholder'); } }).blur(function () { if ($(this).attr('placeholder') != '' &amp;&amp; ($(this).val() == '' || $(this).val() == $(this).attr('placeholder'))) { $(this).val($(this).attr('placeholder')).addClass('hasPlaceholder'); } }); $(':text').blur(); $(active).focus(); $('form').submit(function () { $(this).find('.hasPlaceholder').each(function() { $(this).val(''); }); }); } }); &lt;/script&gt; &lt;script&gt; var error = ""; error = "&lt;?=$error?&gt;"; var spError = error.split("|"); for(var i=0; i&lt;spError.length;i++){ $('.jwtinternational-application').append("&lt;p class='error'&gt;"+spError[i]+"&lt;br/&gt;&lt;/p&gt;"); //alert(spError[i]); } &lt;/script&gt; &lt;SCRIPT language=Javascript&gt; &lt;!-- function isNumberKey(evt) { var charCode = (evt.which) ? evt.which : event.keyCode; if (charCode != 46 &amp;&amp; charCode &gt; 31 &amp;&amp; (charCode &lt; 48 || charCode &gt; 57)) return false; return true; } //--&gt; &lt;/SCRIPT&gt; &lt;/head&gt; &lt;h4&gt;JWT Log Form&lt;/h4&gt; &lt;h4&gt;WARNING: do not use the below form as it is currently being worked on&lt;/h4&gt; The following form can be used to log your loads for JWT in ETS2.&lt;br&gt; If one of the fields do not apply to your load just put £0 or N/A.&lt;br&gt; &lt;form name="jwtinternational-application-form" class='jwtinternational-application-form' action="drivers-log-send.php" method="post"&gt; &lt;div class='jwtinternational-application-left'&gt; &lt;input type="text" class="text-box" name="forum-name" placeholder="Registered Forum Name"/&gt;&lt;br&gt; &lt;input type="text" class="text-box" name="driver-number" placeholder="Driver Number"/&gt;&lt;br&gt; &lt;input type="text" class="text-box" name="email-address" placeholder="Email Address"/&gt;&lt;br&gt; &lt;div&gt; What division in ETS2 are you driving for?&lt;br&gt; &lt;select id="dropdown1" name="dropdown1" class="text-box"&gt; &lt;option value=""&gt;Please Select....&lt;/option&gt; &lt;option value="International"&gt;International&lt;/option&gt; &lt;option value="Samcro"&gt;Samcro Transport&lt;/option&gt; &lt;option value="Port"&gt;Port Logistics&lt;/option&gt; &lt;option value="Bio"&gt;Bio-Fuels&lt;/option&gt; &lt;option value="WnD"&gt;Wagon 'n' Drag&lt;/option&gt; &lt;/select&gt; &lt;br&gt; &lt;/div&gt; &lt;input type="text" class="text-box" name="truck-driving" placeholder="Truck Driving"/&gt;&lt;br&gt; &lt;input type="text" class="text-box" name="cargo" placeholder="Cargo"/&gt;&lt;br&gt; &lt;br&gt; &lt;input type="text" class="text-box" name="depot-leaving" placeholder="Depot Leaving"/&gt;&lt;br&gt; &lt;input type="text" class="text-box" name="city-leaving" placeholder="City Leaving"/&gt;&lt;br&gt; &lt;input type="text" class="text-box" name="country-start" placeholder="Country Starting In"/&gt;&lt;br&gt; &lt;div&gt; Day Start:&lt;br&gt; &lt;select id="dropdown2" name="dropdown2" class="text-box"&gt; &lt;option value=""&gt;Please Select....&lt;/option&gt; &lt;option value="Monday"&gt;Monday&lt;/option&gt; &lt;option value="Tuesday"&gt;Tuesday&lt;/option&gt; &lt;option value="Wednesday"&gt;Wednesday&lt;/option&gt; &lt;option value="Thursday"&gt;Thursday&lt;/option&gt; &lt;option value="Friday"&gt;Friday&lt;/option&gt; &lt;option value="Saturday"&gt;Saturday&lt;/option&gt; &lt;option value="Sunday"&gt;Sunday&lt;/option&gt; &lt;/select&gt; &lt;br&gt; &lt;/div&gt; &lt;div&gt; Time Start:&lt;br&gt; &lt;input type="time" class="text-box" name="time-start"/&gt;&lt;br&gt; &lt;/div&gt; &lt;input type="text" class="text-box" name="mileage-start" placeholder="Mileage Start" onkeypress="return isNumberKey(event)"/&gt;&lt;br&gt; &lt;br&gt; &lt;input type="text" class="text-box" name="depot-arriving" placeholder="Depot Arriving"/&gt;&lt;br&gt; &lt;input type="text" class="text-box" name="city-arriving" placeholder="City Arriving"/&gt;&lt;br&gt; &lt;input type="text" class="text-box" name="country-end" placeholder="Country Finishing In"/&gt;&lt;br&gt; &lt;div&gt; Day End:&lt;br&gt; &lt;select id="dropdown3" name="dropdown3" class="text-box"&gt; &lt;option value=""&gt;Please Select....&lt;/option&gt; &lt;option value="Monday"&gt;Monday&lt;/option&gt; &lt;option value="Tuesday"&gt;Tuesday&lt;/option&gt; &lt;option value="Wednesday"&gt;Wednesday&lt;/option&gt; &lt;option value="Thursday"&gt;Thursday&lt;/option&gt; &lt;option value="Friday"&gt;Friday&lt;/option&gt; &lt;option value="Saturday"&gt;Saturday&lt;/option&gt; &lt;option value="Sunday"&gt;Sunday&lt;/option&gt; &lt;/select&gt; &lt;br&gt; &lt;/div&gt; &lt;div&gt; Time End:&lt;br&gt; &lt;input type="time" class="text-box" name="time-end" placeholder="Time End"/&gt;&lt;br&gt; &lt;/div&gt; &lt;input type="text" class="text-box" name="mileage-end" placeholder="Mileage End" onkeypress="return isNumberKey(event)"/&gt;&lt;br&gt; &lt;div&gt; Cargo Damage:&lt;br&gt; &amp;pound;&amp;nbsp;&lt;input type="text" class="text-box" name="cargo-damage" onkeypress="return isNumberKey(event)"/&gt;&lt;br&gt; &lt;/div&gt; &lt;div&gt; Truck Damage:&lt;br&gt; &amp;pound;&amp;nbsp;&lt;input type="text" class="text-box" name="truck-damage" onkeypress="return isNumberKey(event)"/&gt;&lt;br&gt; &lt;/div&gt; &lt;div&gt; Fuel Cost:&lt;br&gt; &amp;pound;&amp;nbsp;&lt;input type="text" class="text-box" name="fuel-cost" onkeypress="return isNumberKey(event)"/&gt;&lt;br&gt; &lt;br&gt; &lt;/div&gt; &lt;input type="text" class="text-box" name="fuel-amount" placeholder="Fuel Amount (Litres)" onkeypress="return isNumberKey(event)"/&gt;&lt;br&gt; &lt;div&gt; Travel Expenses (Ferry,Toll,Channel Tunnel):&lt;br&gt; &amp;pound;&amp;nbsp;&lt;input type="text" class="text-box" name="travel-expenses" onkeypress="return isNumberKey(event)"/&gt;&lt;br&gt; &lt;/div&gt; &lt;div&gt; Total Cost of Fines:&lt;br&gt; &amp;pound;&amp;nbsp;&lt;input type="text" class="text-box" name="fines-cost" onkeypress="return isNumberKey(event)"/&gt;&lt;br&gt; &lt;br&gt; &lt;/div&gt; &lt;input type="text" class="text-box" name="on-time-or-late" placeholder="On Time/Late"/&gt;&lt;br&gt; &lt;div&gt; Late Fee:&lt;br&gt; &amp;pound;&amp;nbsp;&lt;input type="text" class="text-box" name="late-fee" onkeypress="return isNumberKey(event)"/&gt;&lt;br&gt; &lt;/div&gt; &lt;div&gt; Total Profit:&lt;br&gt; </code></pre> <p>And here is my <strong>PHP Code</strong> which sends the whole form to an email address and sends the data in the text-boxes which become blank to a database. That data is underneath "///PHP TO INSERT DRIVER'S BANK DETAILS INTO BANK DATABASE":</p> <pre><code>&lt;?php ///PHP TO INSERT DRIVER'S BANK DETAILS INTO BANK DATABASE session_start(); $host = ""; // Host name $username = ""; // Mysql username $password = ""; // Mysql password $db_name = ""; // Database name $tbl_name = "jwtdriversbank"; // Table name $un = ""; $usrname = ""; $usrpass = ""; $userID = ""; mysql_connect("$host", "$username", "$password") or die("cannot connect"); mysql_select_db("$db_name") or die("cannot select DB"); if (isset($_SESSION['usrName'])) { $usrname = $_SESSION['usrName']; } else { echo "4"; } //var_dump ($usrname); if (isset($_SESSION['usrPass'])) { $usrpass = $_SESSION['usrPass']; } else { echo "5"; } $sql = "SELECT * FROM jwtdrivers WHERE username='$usrname' and password='$usrpass'"; $result = mysql_query($sql); $rows = mysql_fetch_array($result); $userID = $rows['id']; //var_dump ($userID); if ($userID == "") { echo "3"; } else { $TotalProfitPost = $TotalProfit; $LateFeePost = $LateFee; $FinesCostPost = $FinesCost; $TravelExpensesPost = $TravelExpenses; $FuelCostPost = $FuelCost; $CargoDamagePost = $CargoDamage; $TruckDamagePost = $TruckDamage; var_dump($TruckDamagePost); $sql = "INSERT INTO $tbl_name (DriverID, TotalProfit, LateFee, FinesCost, TravelExpenses, FuelCost, CargoDamage, TruckDamage)VALUES('$userID','$TotalProfitPost','$LateFeePost','$FinesCostPost','$TravelExpensesPost','$FuelCostPost','$CargoDamagePost', '$TruckDamagePost')"; $result = mysql_query($sql); if ($result) { } else { die(mysql_error()); } } ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDanbyization
    1. USDanbyization
    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. POSome text boxes become blank when click on submit
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POSome text boxes become blank when click on submit
      1. This table or related slice is empty.
      1. VTModeratorReview
    1. COfar to much code, only bring what is relevant
      singulars
      1. POSome text boxes become blank when click on submit
      1. USZevi Sternlicht
    2. COsorry it's just i asked a question on here i bought what i thought was relevant but then they just told me to stick everything on so i did, but i shall edit my post now.
      singulars
      1. POSome text boxes become blank when click on submit
      1. USDanbyization
    3. COno problem, its just that more people will look if there is less code. Obviously you still need to bring what is absolutely necessary.
      singulars
      1. POSome text boxes become blank when click on submit
      1. USZevi Sternlicht
 

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