- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 3
- Posts with Upvotes
- 2
- Upvoting Members
- 3
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
55 Posted Topics
 | Sir I have installed JAVA 15 windows 7 64bit  I want to ask what Microsoft JDBC Driver for SQLSERVER 2014 should I download. Please  |
| | Sir I have this data  Group by hours Or First value of every hour Please help  |
| | Sir I have these codes <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <style type="text/css"> .box{ margin:0 auto; width:30%; border:2px solid #CCC; height:auto; padding:10px; margin-top:50px; } </style> </head> <?php $my_continent=""; $my_country=""; $my_city=""; $my_zip=""; if(isset($_POST["submit"])){ $my_continent = $_POST['continent']; $my_country = $_POST['country']; $my_city = $_POST['city']; $my_zip = $_POST['zip']; } …  |
| | Dear Sir, I am using following codes on EVERY textbox. private void textBox1_KeyPress(object sender, KeyPressEventArgs e) { char ch = e.KeyChar; decimal x; if (ch == (char)Keys.Back) { e.Handled = false; } else if (!char.IsDigit(ch) && ch != '.' || !Decimal.TryParse(textBox1.Text + ch, out x)) { e.Handled = true; } …  |
| | Sir this is my first post in c# section: I want to apply this format to textbox 123,456,789 What type of textbox should I use? Textbox or MaskedTextbox and how to apply format like this 999,999,999 Is there any specific property in propery window or I should use some procedure? …  |
| | Sir I have these codes <body onload="code.focus()"> <!-------------------------------------> <form name="form" action="<?php $_PHP_SELF;?>" method="post"> <!-------------------------------------> <div id="partybox"> <!--f_date1--> <label for="datepicker-13"> Date </label> <span style="border:1px solid #FFF;border-radius:3px;width:95px;height:20px;"> <input style="background-color:#FFC;border:1px solid #9C6;text-align:center;" type="text" size="9" name="f_date1" required id="datepicker-13" onblur="validatedate(document.form1.f_date1)" value="<?php echo date('d-m-Y', strtotime($f_date1));?>" disabled="disabled"/> </span> <!--vno--> <label for="vno"> V. # </label> <span style="border:1px solid … |
| | Sir I have these codes <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <head> <title>Party Ledger</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta HTTP-EQUIV="Pragma" content="no-cache"> <meta HTTP-EQUIV="Expires" content="-1"> <link href="css/jquery-ui.css" rel="stylesheet" type="text/css"> <style type="text/css"> html,body { height:100%; width:100%; text-align:center; margin:0; padding:5px; } body { overflow:hidden; } #content { max-height: calc(100% - …  |
| | Good morning, On my localhost, suddenly all of my php files are looking like this format  What is this? Is it hacker attack? How to stop this action in future. Please help  |
| | Sir I have this fiddle [Click Here](https://jsfiddle.net/614ft20d/49/) I need When I enter Rate and Qty then it must display Amount automatically. Add and Remove buttons work fine already. Want to know only calculation method. Please help  |
| | Sir, how to make these lines workable echo "<td align='center'><a href='register_edit.php?message=".base64_encode('date='.date('Y-m-d',strtotime($res['date'])).&".base64_encode('vou_no='.$res['vou_no']')> <img src='../images/time.ico' alt='Complet_History' title='Complete_History'></a></td>"; I want to pass two parameters. Please |
| | Sir I have these codes <?php $result = array( array('date'=>'2017-04-17','voucher'=>2,'code'=>'1401001','party'=>'Michael','d1'=>'Payment of services','dr_amount'=>500), array('date'=>'2017-04-18','voucher'=>1,'code'=>'1401002','party'=>'Eric','d1'=>'Payment of goods','dr_amount'=>1000), ); while ($row=mysqli_fetch_array($result)){ echo $row['party']; } ?> the codes display this error message **E_WARNING : type 2 -- mysqli_fetch_array() expects parameter 1 to be mysqli_result, array given -- at line 7** What I am doing … |
| | Sir I have these codes $last_date=""; $last_vno=""; $queryx = "SELECT MAX(t1.date)as mxdate,MAX(t1.vou_no)as mxvno,max(d1)as d1 FROM vouchers t1 WHERE t1.date = (SELECT MAX(t2.date)as date FROM vouchers t2 where vou_type='CP' and dr_amount>0)"; $resultx=sqlsrv_query($con,$queryx)or die("Error". sqlsrv_errors($con)) ; if ($resultx){ while ($rowx = sqlsrv_fetch_array ($resultx)){ $last_date=$rowx['mxdate']; $last_vno=$rowx['mxvno']; $myparty=$rowx['d1']; } }else{ echo "no data found"; … |
| | Sir I have these codes <html> <head> <style type="text/css"> table { font-size: 12px; font-weight: bold; font-family: Verdana, Geneva, sans-serif; } #mytable td { border: 1px solid #CCC; font-size: 14px; } #mytable thead { border: 1px solid #6C3; background-color: #CCC; color: black; line-height: 30px; height: 30px; font-size: 14px; } #mytable input[type="text"] … |
| | Dear Sir, I have these code <html> <head> <style type="text/css"> html, body { height: 100%; width: 100%; margin: 0; padding: 0; } body { overflow: hidden; } #content { max-height: calc(100% - 280px); overflow-y: scroll; padding: 0px 5% 0px 5% !important; margin-top: 10px !important; border: 0px dotted #39F; } </head> … |
| | Sir I have these codes [PHP] <form name="form1" action="<?php $_PHP_SELF ?>" method="post" enctype="multipart/form-data"> <p<Photo</p> <p><input type="file" name="file" id="file" value="<?php echo $myphoto; ?>"></p> <p><input type="submit" value="photo" name="save"></p> </form>[/PHP] and these are codes for submit button [PHP]if(isset($_POST['save'])) { if(isset($_FILES["file"])){ $myphoto=$_FILES["file"]["name"]; echo $myphoto; }else{ echo 'Error'; } } [/PHP] When I press save …  |
| | Sir I am using these codes on login.php session_start(); $query="select * from w_log where email ='".$muser."' and pass='".$mypass."'"; $result=sqlsrv_query($con,$query)or die ("Error". sqlsrv_errors($con)) ; while($res = sqlsrv_fetch_array($result)) { $_SESSION['id']=($res['id']); $_SESSION['sno']=($res['usno']); $_SESSION['user']=($res['name']); $_SESSION['status']=($res['status']); } //header("location:../index.php"); //exit(); echo $_SESSION['status']; $_SESSION['status'] is equal to GENERAL But when I call this variable at the top …  |
| | Sir I have these codes <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <title>Set DIV Height to 100% Using CSS</title> <style type="text/css"> html, body { height: 100%; margin: 0px; position: relative; text-align: center; font-size: 18px; font-weight: bold; overflow: hidden; } .header { background-color: blue; width: 100%; border: 1px solid brown; height: … |
| | Sir I have these codes <div class="menu_box image16"> <div id="small_header">Chart</div> <h4><a href="chart_qt.php" title="Close"> <img src="images/16x16/chart_bar.png" hspace="4">Qty</a> </h4> <h4><a href="chart_wt.php" title="Close"> <img src="images/16x16/server_chart.png" hspace="4">Weight</a> </h4> <h4><a href="chart_at.php" title="Close"> <img src="images/16x16/chart_pie.png" hspace="4">Amount</a> </h4> </div>  when any use click on any <a></a> then his $_SESSION['id'] must save in events table Suppose: … |
| | Sir, I have these codes function date_getFullTimeDifference( $start, $end ) { $uts['start'] = strtotime( $start ); $uts['end'] = strtotime( $end ); if( $uts['start']!==-1 && $uts['end']!==-1 ) { if( $uts['end'] >= $uts['start'] ) { $diff = $uts['end'] - $uts['start']; if( $years=intval((floor($diff/31104000))) ) $diff = $diff % 31104000; if( $months=intval((floor($diff/2592000))) ) $diff … |
| | Sir I have these codes $start_time=$row['start']; //2017-02-09 15:04:09.000 $stop_time=date('Y-m-d H:i:s'); //2017-02-09 16:24:22.000 $duration=$start-$starttime; // it says 2016 but i need result like this //0001:20:13 I mean I need hours in 4 digits minutes in 2 digits and second 2 digits Please help |
| | Sir I am using IIS Manager, as follows  and I have these codes for login.php <?php error_reporting(E_ALL); ini_set('display_errors', 1); require_once("../includes/connectsql.php"); require_once("../includes/functions.php"); $error = false; $cerror=""; $cur_id=0; $cur_user=""; $cur_email=""; $mypass=""; if(isset($_POST['login'])){ $muser=clean($_POST['username']); $mpass=clean($_POST['password']); $mypass=SHA1($mpass); if (!preg_match("/^[a-zA-Z0-9]+$/",$mpass)) { $error = true; $cerror="Password must contain only alphabets and space"; } if(!filter_var($muser,FILTER_VALIDATE_EMAIL)) … |
| | Sir I have following codes on login.php <?php error_reporting(E_ALL); ini_set('display_errors', 1); require_once("../includes/connectsql.php"); require_once("../includes/functions.php"); $error = false; $cerror=""; $cur_id=0; $cur_user=""; $cur_email=""; $mypass=""; if(isset($_POST['login'])){ $muser=clean($_POST['username']); $mpass=clean($_POST['password']); $mypass=SHA1($mpass); if (!preg_match("/^[a-zA-Z0-9]+$/",$mpass)) { $error = true; $cerror="Password must contain only alphabets and space"; } if(!filter_var($muser,FILTER_VALIDATE_EMAIL)) { $error = true; $cerror = "Please Enter Valid Email … |
| | Sir I have following codes function generate() { var doc = new jsPDF('p', 'pt'); doc.setFontSize(18); doc.text('Chart of Accounts', 220, 50); doc.setFontSize(8); doc.setTextColor(100); var res = doc.autoTableHtmlToJson(document.getElementById("mytable")); doc.autoTable(res.columns, res.data, {margin: {top: 70}}); doc.save("chartofaccounts.pdf"); } I am trying to set font size 8 to text so I used this line doc.setFontSize(8); but … |
| | Sir I have these codes <input type="text" size="11" name="f_date1" id="datepicker-13" value="<?php echo date('d-m-Y', strtotime($f_date1));?>"/> <input type="text" size="11" name="t_date1" id="datepicker-133" value="<?php echo date('d-m-Y', strtotime($t_date1));?>"/> <script> var ja = jQuery.noConflict(); ja(document).ready(function() { ja("#datepicker-133").datepicker({dateFormat:'dd-mm-yy'}).on("change",function(){ var f_date1 = $("#datepicker-13").val(); var t_date1 =$("#datepicker-133").val(); var data = { ff_date1: f_date1, tt_date1: t_date1 } alert(data) $.ajax({ url: …  |
| | Sir I have these codes <?php session_start(); if(!isset($_SESSION['user'])) { header("location: admin/login.php"); } include_once("includes/connectsql.php"); $date1=date('Y-m-d'); $t_date1=isset($_POST['t_date1'])?$_POST['t_date1']:$date1; $t_date1=date('Y-m-d',strtotime($t_date1)); //----------------------------------------------------- // find if(isset($_POST['btn_find'])) { $acc_code1='2310001'; $mybalance=0; $mydrcr=''; $query = "select vou_no,acc_code,acc_name,dr_amount,cr_amount,qty,circle from crsalp where date='".$t_date1."' and (SUBSTRING(acc_code,1,2)='32' or SUBSTRING(acc_code,1,2)='33') order by vou_no,acc_code"; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"> <head> <title>Sales … |
| | Sir I have these codes <!doctype html> <html> <head> <meta charset="utf-8"> <title>Untitled Document</title> <style type="text/css"> * { margin: 0; padding: 0; } .box { margin:auto; top:0; left:0; bottom:0; right:0; width:20%; height:200px; border:1px solid silver; padding:30px; position:absolute; box-shadow: 0px 0px 10px 10px #72B3D3; } .fit { background-size:contain; background-repeat:no-repeat; background-position:center center; opacity:0.5; … |
| | Sir I have following codes for Bootstrap header <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Bootstrap Page Header</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta http-equiv="Pragma" content="no-cache" /> <meta http-equiv="Expires" content="-1" /> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="css/bootstrap.min.css"> <script src="js/jquery.min.js"></script> <script src="js/bootstrap.min.js"></script> <style type="text/css"> html { … |
| | Sir I have these codes #header { width: 60%; height:auto; color: #4169E1; font-size: 30px; font-weight: bold; text-align: center; border: 1px solid #39F; margin:0 auto; overflow: hidden; } #header img { margin-right: 15px; float: left; } <body> <div id='header'> <img src="images/wheaticon.jpg" hspace='10' height="200" width="300" > <strong>Dashboard <br /> Wheat + Bardanana<br …  |
| | Sir, I have this header.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel="stylesheet" href="css/css3menu1.css" type="text/css" /> <style type="text/css"> #header1 { width: 100%; color: #FFC; background-image: url(images/header.gif); font-size: 28px; font-weight: bold; font-style: oblique; text-align: left; padding: 5px; position: fixed; } #header1 img { vertical-align: middle; } … |
| | Sir I have these codes <?php $stockdate=""; $queryx = "SELECT max(data.date)as date from ( select max(date)as date from crprp union all select max(date)as date from pouring union all select max(date)as date from product ) as data"; $resultx = sqlsrv_query($con,$queryx)or die ("Error". sqlsrv_errors($con)) ; while ($rowx = sqlsrv_fetch_array ($resultx)){ $stockdate=($rowx['date']); } …  |
| | Sir I have these codes <html> <head> <script type="text/javascript" src="js/jquery.js"></script> <script type="text/javascript" src="js/jquery-ui.js"></script> <link rel="stylesheet" href="css/jquery-ui.css"> <script type="text/javascript"> $(function() { $( "#coding_language" ).autocomplete({ source: 'autocomplete.php' }); }); </script> </head> <body> <div id="wrapper"> <div class="ui-widget"> <p>Code <input type="text" id="PT"></p> <p>Party <input type="text" size="40" id="coding_language"></p> </div> </div> </body> </html> and autocomplete.php has … |
| | Sir, I have these PHP codes while($res = sqlsrv_fetch_array($result)) { echo "<tr>"; $sno=$sno+1; echo "<td align='center'>$sno</td>"; echo "<td align='center'>".($res['acc_code'])."</td>"; $partycode=($res['acc_code']); $query1 = "select code,desc1 from master where code='".$partycode."'"; $result1 = sqlsrv_query($con,$query1) or die ("Error". sqlsrv_errors($con)) ; while($res1 = sqlsrv_fetch_array($result1)) { echo "<td align='left' class='color1'>".($res1['desc1'])."</td>"; } echo "<td align='right'>".($res['dr_amount'] != 0 … |
 | "SELECT ID, Image, imageID, Category FROM gallery WHERE imageID="'.$imageID.'" AND Category="'.$category.'"  |
| | Sir I have following codes <form name="form1" action="<?php $_PHP_SELF;?>" method="post"> <label> Code </label> <input type="text" size="7" name="ppcode" id="ppcode" onblur="myCall()" value="<?php echo $acc_code1;?>"/> </form> //function mycall() function myCall() { var data = $("#ppcode").val(); var request = $.ajax({ url: "party_search.php", type: "Get", data:{"code":data}, dataType: "html" }); request.done(function(msg) { var msg = msg.split("##"); …  |
| | Sir I have these codes $string = ' ab'; echo (strlen($string))."<br>"; // returns 4 $count = mb_strlen($string); echo $count."<br/>"; // returns 4 $length = count(str_split($string)); echo $length."<br/>";// returns 4 All above method return 4 But I need 2 because there are TWO white spaces in the beginning of $string So … |
| | Sir I have these codes global $mybalance; $mybalance=0; $mydrcr=''; $result2 = sqlsrv_query($con,$query) or die ("Error". sqlsrv_errors($con)) ; $sno=0; while($res2 = sqlsrv_fetch_array($result2)) { echo "<tr>"; $mybalance=($res2['balance']); echo'Opening Balance='.number_format($mybalance).'<br>'; if($mybalance=0){ $mydrcr=''; } if($mybalance>0){ $mydrcr='dr'; } if($mybalance<0){ $mydrcr='cr'; } echo'Opening Balance='.number_format($mybalance); The codes PHP Code: echo'Opening Balance='.number_format($mybalance); work fine at line 11 but … |
| | Sir, I am using wamp 3.0 having php 5.6.15 SQLSERVER 2008 is installed on Windows 7 32bit. I want to connect sqlserver with php, So I put required drives in Bin folder as  and made some necessary changes in php.ini as  Finally I have this connection …  |
| | Sir I have this query and result [IMG]http://i66.tinypic.com/4r7oee.jpg[/IMG] Now I want to modify query to get result like this [IMG]http://i65.tinypic.com/11aihzs.png[/IMG] Please help  |
| | Sir I have these codes <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <META HTTP-EQUIV="Pragma" CONTENT="no-cache"> <META HTTP-EQUIV="Expires" CONTENT="-1"> <title>Test Page</title> <style type="text/css"> html { overflow: auto; } body { font-family: Georgia, "Times New Roman", Times, serif; } #container { position: absolute; … |
| | Sir I have these codes <?php session_start(); require_once("includes/connectw.php"); $query = "SELECT distinct(MONTH(date)) AS 'month' FROM arrival order by date" ; echo $query; $result = mysqli_query($con,$query)or die ("Error". mysqli_error($con)) ; if(mysqli_num_rows($result)>0){ echo "<select name='per1' id='per1'>"; echo "<option selected='selected'></option>"; foreach($month as $name) { echo "<option value='".$name."'></option>"; } echo "</select>"; } ?> $result … |
| | Sir I want to generate a query which will convert data from rows to columns I have this table  I want to get this result  [IMG]http://i66.tinypic.com/2hfjep4.png[/IMG] Workers amount will go to column in relevant data Group by code. I wrote this query session_start(); require_once("includes/connectw.php"); $query = … |
| | Sir I have these codes <script> function myCall() { var data = $("#datepicker-13").val(); alert(data) var request = $.ajax({ url: "ajax_arrival.php", type: "Get", data: { "date": data }, dataType: "html" }); request.done(function(msg) { msg = data.split("##"); $("#wh_bg1").val(msg[0]); $("#wh_jt1").val(msg[1]); $("#wh_wt1").val(msg[2]); // alert(msg); }); request.fail(function(jqXHR, textStatus) { alert("Request failed: " + textStatus); }); … |
| | Sir I have these codes in <head> section <meta name="viewport" content="width=device-width, initial-scale=1"> <style type="text/css"> #small_box_r { float:left; width:31.1%; border:1px solid #ccc; border-radius:6px; padding:0px 0px 0px 0px; margin:15px 5px 15px 5px; height:300px; color:#39F; font-weight:bold; text-align:center; overflow:auto; background-size:cover; } @media (min-width: 400px) and (max-width: 800px){ #small_box_r { min-width: 100%; max-width: 100%; } … |
| | Sir I have these 2 tables (Arrival+Pouring) shown in Attachment I create result table with this query select c1.date,sum(nvl(cx.purchase-cx.sold,0)) as opening,c1.purchase,c1.sold,; sum(nvl(cx.purchase-cx.sold,0)) + c1.purchase-c1.sold as closing ; from ; (select NVL(a.date,b.date) as date,CAST(NVL(a.qty,0) as integer) as purchase,; CAST(NVL(b.qty,0) as integer) as sold from purchase a FULL JOIN sold b ON … |
| | Sir, my table look like this  I am using this query to insert data $query = "INSERT INTO history(user, login, logout, duration, user_ip, user_lo) VALUES ('".$muser."','".($date('Y-m-d H:i:s')."','".($date('Y-m-d H:i:s')."',1,'".$_SERVER['SERVER_ADDR']."','myplace')"; But it says: Parse error: syntax error, unexpected ';' in C:\wamp\www\...... I am unable to know what is wrong in … |
| | Dear Experts I use datepicker as <input style="background-color:#FFC;" type="text" size="9" name="date" id="datepicker-13" value="<?php echo date('d-m-Y', strtotime($date));?>"> <script> var j = jQuery.noConflict(); j(document).ready(function(){ j("#datepicker-13"). datepicker({dateFormat:'dd-mm-yy'}); <!-- j( "#datepicker-13" ).datepicker("show"); --> }); </script> This datepicker pick any date but I want it to select date between this ranges $date1='2016-07-01' $date2='2017-06-30' Suppose If … |
| | Sir I have this variable $date="2016-07-18" I want to get DATA from 2016-07-01 to 2016-07-17. In other words I want to get DATA of month given in $date (July) but excluding current date (18) How to write query $query = "select * from arrival where ........; Please help |
| | Dear Experts, I am using these codes <?php require_once("../includes/connectw.php"); require_once("../includes/functions.php"); $error=""; if(isset($_POST['login'])) { $muser=clean($_POST['username']); $mpass=clean($_POST['password']); if(empty($muser)) { $error="User name must not be empty"; } elseif (empty($mpass)) { /*echo ('<script>alert("Password must not be empty")</script>');*/ $error="User name must not be empty"; } else { $query="select * from admin where user ='".$muser."' and … |
| | Sir, I have following codes $host="localhost"; $username="a6354924"; $password="123456"; $db_name="a6354924_abc"; $con=mysqli_connect($host, $username, $password,$db_name); Database and error screen shots are attached. Facing this error Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'a6354924'@'localhost' (using password: YES) in /home/a6354924/public_html/includes/connectw.php on line 8 Please help   |
| | Sir I have following codes <?php if (isset($_POST['submit'])) { $allowedExts = array("gif", "jpeg", "jpg", "png"); $temp = explode(".", $_FILES["file"]["name"]); $extension = end($temp); if ((($_FILES["file"]["type"] == "image/gif") || ($_FILES["file"]["type"] == "image/jpeg") || ($_FILES["file"]["type"] == "image/jpg") || ($_FILES["file"]["type"] == "image/pjpeg") || ($_FILES["file"]["type"] == "image/x-png") || ($_FILES["file"]["type"] == "image/png")) && ($_FILES["file"]["size"] < 20000) … |
The End.