Posts

Showing posts from September, 2013

get an input field value from the last row in a table using jquery

$ ( 'table#table1 tr:last input[name=code]' ). val ();

count number of rows in a table using jquery

var rowCount = $ ( '#myTable tr' ). length ;

allow only numeric (0-9) in html inputbox using jquery

jsnya : <script type="text/javascript"> $(document).ready(function(){ //numeric numericOnly('biaya'); numericOnly('OutboundDetail_weight'); function numericOnly(id){ $("#"+id).keydown(function(event) { // Allow: backspace, delete, tab, escape, and enter if ( event.keyCode == 46 || event.keyCode == 8 || event.keyCode == 9 || event.keyCode == 27 || event.keyCode == 13 || // Allow: Ctrl+A (event.keyCode == 65 && event.ctrlKey === true) || // Allow: home, end, left, right (event.keyCode >= 35 && event.keyCode <= 39)) { // let it happen, don't do anything return; } else { // Ensure that it is a number and stop the keypress if (event.shiftKey || (event.keyCode < 48 || event.keyCode > 57) && (event.keyCode <

resetting multi element/controll form using jquery

function resetForm($form) { $form.find('input:text, input:password, input:file, select, textarea').val(''); $form.find('input:radio, input:checkbox') .removeAttr('checked').removeAttr('selected'); } // to call, use: resetForm($('#myform')); // by id, recommended resetForm($('form[name=myName]')); // by name source : http://stackoverflow.com/questions/680241/resetting-a-multi-stage-form-with-jquery

close thickbox popup from code behind asp.net c#

ScriptManager .RegisterStartupScript( this , typeof ( Page ), UniqueID, “self.parent.tb_remove()” , true );

Reset Dropdownlist value using jQuery

$('#name').prop('selectedIndex',0);

Get selected text from dropdownlist using jQuery

$ ( "#yourdropdownid option:selected" ). text ();

cast or convert from varchar to integer in mysql

select convert(id, UNSIGNed integer) as id from tb_test order by id select CAST(id AS UNSIGNED) as id from tb_test order by id

get data from textbox on form pop up using thickbox

cara pertama dengan alt tag:   jsnya :   <script type="text/javascript">         function GetLinks(i,vsid) {           document.getElementById("btn"+i).alt = "packageBookingRes.aspx?vsid="+vsid+"&BPax=" + document.getElementById('txtBookingPax'+ i).value + "&keepThis=true&TB_iframe=true&height=450&width=605";         }     </script>   htmlnya :   <input type=\"button\" id=\"btn" + i.ToString() + "\" onclick='GetLinks(" + i.ToString() + ",\""+vsid+"\")' class=\"thickbox sendbook\" value=\"Booking\" />   ---------------------------------------------   cara kedua dengan tb_show :   jsnya :   <script type="text/javascript">     function GetPax(i, vsid) {       if((document.getElementById('txtBookingPax'+i).value != "0")&&(document.getElementById('t

change cjuidatepicker / jquery datepicker z-index

. date_field { position : relative ; z - index : 100 ;}   jQuery will set the calendar's z-index to 101 (one more than the corresponding element). The position field must be absolute , relative or fixed . jQuery searches for the first element's parent, which is absolute/relative/fixed, and takes its' z-index source : http://stackoverflow.com/questions/11533161/jquery-ui-datepicker-change-z-index
DESCRIBE tb_invoice; show create table tb_invoice; select * from `information_schema`.`tables`   where table_name like 'tb_invoice'