Maya Naga

Ranch Hand

+ Follow

news 79 Posts 20 Threads

since Nov 09, 2009

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Forums and Threads

Recent posts by Maya Naga

Java to JSON Format

This is my sample application which provides result as follows:

Since i have this jQuery Highcharts:

I have to pass ro_count,ro_free_count,etc instead of 'name' in 'series' and 'arr[i][j]' values instead of 'data' place... Am new to JSON Format.

Can any one help me how to convert and pass these values to this chart application.

14 years ago

JSP

Passing array values using Ajax & JSP

Thanks Eric....

14 years ago

HTML Pages with CSS and JavaScript

Passing array values using Ajax & JSP

I have created a chart application using jQuery, JSP and ajax.

using javascript function, am storing the selected listbox values in 'sel_data_value'. I need to pass this selected array values to database to retrieve values regarding selection. How can i do this using ajax. i don know how to pass array values in ajax and retrieve it from database.

if sel_data_value='vehicle reporting' is selected how can i pass this using ajax to database so that i can retrieve array of values and pass it to chart application. I am new to ajax. can anyone help me how to send and retrieve array of values using ajax.

14 years ago

HTML Pages with CSS and JavaScript

JSP Combobox and Java Class

Thanks Bear.. actually it was my mistake to mention as combo box..
Am new to JSP and Servlet..
Please can you give me some example...

14 years ago

JSP

JSP Combobox and Java Class

Hi ranches,
I have developed an application with the combination of html, JSP and Servlet...
i have created a jsp file with 3 combo box....
for first 2 combo boxes am passing value from database..
but for the third combo i need to pass array values from a java file...

the code is as follows:

i need to pass these values to :

How to do that? please i need help.

14 years ago

JSP

jQuery and Java Web Applications

hi ranches,
I am developing a java web application. When i came to know about jQuery i was much impressed by its UI.
I go through some sites about how to integrate jQuery in java applications. But i don't get any idea on how to do it.
can any know how to use jQuery in java applications? if possible please give me few examples about that.
thank you.

14 years ago

HTML Pages with CSS and JavaScript

PHP - MySQL query

any one please give some idea on how to solve the above issues..
thanks

14 years ago

Web Services

PHP - MySQL query

i have another issue.
how to pass variable values to next page using post method..
i have done using get method and am passing values such as:

echo "<a href=\"outgoing.php?optSingle=".$c."&beg=".$frmDate."&datEnd=".$toDate."&inTxt=".$incoming."&flr=".$flr."&page=1\" ></a>";

how to change to post method?
can please someone help me to solve above 2 issues?

14 years ago

Web Services

PHP - MySQL query

hi ranches..
i have done application which retrieves result from mysql table according to user extension and date's..
i did pagination to display the result. i try to print the result as ' Showing 1-10 records of 100'.
but my problem is am getting same as '90-100 of 100 records' rather than '94-100 of 100 records ' though the page has only 6 records..
how to solve this problem...

i have attached my code..

$rowsPerPage = '10';
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
$query="SELECT * FROM calldetail WHERE (";
for($i=0;$i<count($r);$i++)
{
if ($r[$i][1]==null)
{
if ($i>0)
$query.=" OR";
$query.=" (CallTermination ='".$r[$i][0]."')";
}
else
{
if ($i>0)
$query.=" OR";
$query.=" (CallTermination BETWEEN '".$r[$i][0]."' AND '".$r[$i][1]."')";
}
} // end of for loop
$query.=") and CallFlag='L' AND CallDate BETWEEN '".$frmDate1."' AND '". $toDate1."' ORDER BY ";
if ($dat=='CallDate desc' or $dat=='CallDate asc')
$query.=$dat;
$query.=" LIMIT $offset, $rowsPerPage";
$c1='&optDat';
tab($query,$connection,$frmDate,$toDate,$incoming,$dat,$c1,$offset,$rowsPerPage,$pageNum,$row['CallFlag'],$dial,$receive);
$query="SELECT count(CallDate) as numrows FROM calldetail WHERE (";
for($i=0;$i<count($r);$i++) {
if ($r[$i][1]==null)
{
if ($i>0)
$query.=" OR";
$query.=" (CallTermination ='".$r[$i][0]."')";
}
else
{
if ($i>0)
$query.=" OR";
$query.=" (CallTermination BETWEEN ".$r[$i][0]." AND ".$r[$i][1].")";
}
} //end of for loop
$query.=")and CallFlag='L' AND CallDate BETWEEN '".$frmDate1."' AND '". $toDate1."' ORDER BY CallTermination ASC";
// how many rows we have in database
$result = mysql_query($query) or die('database query error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
}
//echo $numrows;
//echo "Total Records: " . $numrows . '<br/>';
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
$nav = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nav .= " $page "; // no need to create a link to current page
}
else
{
$nav .= " <a href=\"$self?beg=".$frmDate."&datEnd=".$toDate."&inTxt=".$incoming."&page=$page\">$page</a> ";
}
}// end of for loop
//echo "Total Pages:" . $page;
// creating previous and next link plus the link to go straight to the first and last page
if ($pageNum > 1) {
//this is activated from page 2
$page = $pageNum - 1;
$prev = " <a href=\"$self?beg=".$frmDate."&datEnd=".$toDate."&inTxt=".$incoming."&page=$page\"><img style='border-style:none' src='img/previous.gif'></a> ";
$first = " <a href=\"$self?beg=".$frmDate."&datEnd=".$toDate."&inTxt=".$incoming."&page=1\"><img style='border-style:none' src='img/firstenable.gif'></a> ";
//echo '<center>';
//echo $first . $prev;
//echo '<center/>';
}
else {
//this is for first page
$prev = '<img style="border-style:none" src="img/previous.gif">'; //1st page; we're on page one, don't print previous link
$first = '<img style="border-style:none" src="img/firstdisable.gif">'; // nor the first page link
}
if ($pageNum < $maxPage) {
$page = $pageNum + 1;
$next = " <a href=\"$self?beg=".$frmDate."&datEnd=".$toDate."&inTxt=".$incoming."&page=$page\"><img style='border-style:none' src='img/next.gif'></a> ";
$last = " <a href=\"$self?beg=".$frmDate."&datEnd=".$toDate."&inTxt=".$incoming."&page=$maxPage\"><img style='border-style:none' src='img/lastenable.gif'></a> ";
}
else {
$next = '<img style="border-style:none" src="img/next.gif">'; // we're on the last page, don't print next link
$last = '<img style="border-style:none" src="img/lastdisable.gif">'; // nor the last page link
}
// print the navigation link
echo '<br/><center>';
echo $first . $prev . $next . $last;
// and close the database connection
echo "<p >" .'Showing <font color="red">'. ($offset+1) . " - " . ($offset+$rowsPerPage) . "</font>   of   ". $numrows . " Records" ."</p>";
}

thanks

14 years ago

Web Services

Passing values between PHP pages without navigation

Name Number
-------- -----------
ravi 5678
devi 8907
sam 2323,4567

say for an example the billing_numbers table will contain data similar as above. in my homepage i'll list the combobox with the name values which is retrieved using query. when the user selects 'ravi' from combobox i need to pass '5678' to the textfield value. this is what i did. since we cannot do this in single page, is it possible to retrieve the value '5678' from another php page where the query result exists without navigating to that page.

am i clear now?

14 years ago

HTML Pages with CSS and JavaScript

Passing values between PHP pages without navigation

Hi all...
As i am new to php, i have the following doubt.
Say for an example, i have homepage form with few textfields and radio buttons. i have assigned method='get' where am passing values to another page . My doubt is am going to include a combo box with items such as Ravi, Devi, etc. when the user selects any item, it want to load relevant numbers (ravi->3456, devi->6789,5534) into the textfield. i have developed a code to retrieve the value but the form's method value should be 'POST'. i know it is not possible to use both get and post method at the same time. but how can i solve this problem. is it possible to send the selected item value to another page and retrieve the numbers '3456','6789' without navigating to another page.
my sample code for combo box:

<body>
<form method="post" name="form">
<p>
<label for="Group">Group</label> </p>
<?php
$dbname='callreader';
$db_user='root';
$db_pass='';
$host='localhost';
$conn = mysql_connect($host, $db_user, $db_pass);
mysql_select_db($dbname);
$query="select distinct Name from billing_numbers";
$result=mysql_query($query,$conn) or die(mysql_error());
echo "<select id='Name' name='Name' onchange='PrintCombo();'>";
while($row=mysql_fetch_array($result))
{
echo '<option value="'.$row['Name'].'">'.$row['Name'].'</option>';
}
echo '</select>';
?>
<?php
if(isset($_POST['Name']))
{
$var=$_POST['Name'];
echo $var;
$array=array();
$query="select Number from billing_numbers where Name='".$_POST['Name']."'";
$result=mysql_query($query,$conn) or die(mysql_error());
if($result)
{
while($row=mysql_fetch_assoc($result))
{
$array[]=$row['Number'];
}
$total_numbers = implode(',', $array);
}
}
?>
Extension: <input type="text" name="numbers" size="30" value="<?php echo $total_numbers; ?>" />
<a href="outgoing.php">
<img src="phone.png" name="callBtn" style="border-style: none"id ="callBtn"/>
</a>
</form>
</body>
<script>
function PrintCombo()
{
document.form.submit();
}
</script>

i have included it into my homepage as follows: it works successfully but problem is , when i enter other textfields and select this combo value it automatically refreshes the other fields and fields become empty.

<html>
<head>
<title>Informations</title>
</head>
<body onload=top()>
<?php
$dbname='callreader';
$db_user='root';
$db_pass='';
$host='localhost';
$conn = mysql_connect($host, $db_user, $db_pass);
mysql_select_db($dbname);
$query="select distinct Name from billing_numbers";
$result=mysql_query($query,$conn) or die(mysql_error());
?>
<center>
// here the method should be get as i have to pass the field values to another
// page which wont work for combo box
<form name=callsubm method="post">
<table border="0" >
<tr >
<td align="right">
From Date</td>
<td align="center" > 
<input style="border-style: none;" type="text" name="beg" id="beg" size="15" ></td>
<td><img src="calender" alt="C" id='img1'>
<script language=javascript type="text/javascript">
var cal = new Zapatec.Calendar.setup({
inputField:"beg",
ifFormat:"%d-%m-%Y ",
button:"img1",
showsTime:false
});
</script>
</td>
</tr>
<tr>
<td>
End Date</td>
<td > 
<input style="border-style: none;" type="text" name="datEnd" id="datEnd" size="15" ></td>
<td><img src="calender" alt="C" id='img2'>
<script language=javascript type="text/javascript">
var cal = new Zapatec.Calendar.setup({
inputField:"datEnd",
ifFormat:"%d-%m-%Y ",
button:"img2",
showsTime:false
});
</script>
</td>
</tr>
<tr>
<td>
Time</td>
<td > 
<input style="border-style: none;" name=time id=time type="text" size="15"></td>
<td><input type="image" id=time name=time src="Time.png"></td>
</tr>
<?php
if($result)
{
?>
<tr>
<td>Group:</td>
<td> 
<select name="Name" id="Name" onchange='PrintCombo();' >
<?php
while($row=mysql_fetch_assoc($result))
{
echo '<option value="'.$row['Name'].'">'.$row['Name'].'</option>';
}
}
?>
</select>
<?php
if(isset($_POST['Name']))
{
echo '<script type="javascript"> alert("hi");</script>';
$array=array();
$query="select Number from billing_numbers where Name='".$_POST['Name']."'";
$result=mysql_query($query,$conn) or die(mysql_error());
if($result)
{
while($row=mysql_fetch_assoc($result))
{
$array[]=$row['Number'];
}
$total_numbers = implode(',', $array);
}
}
?>
</td>
</tr>
<tr>
<td>
Extension</td>
<td > 
<input style="border-style: none;" name=inTxt id=inTxt type="text"
size="15" value="<?php echo $total_numbers;?>"></td>
<td><a href="outgoing.php"><img style='border-style:none' src='phone.png'></a>
</td>
</tr>
</table>
<br/>
<table>
<tr align="center">
<td align="center">Single </td>
<td><input class="submit" type=radio id=optSingle name=optSingle onclick=selectpage(name)>
</td>
<td>Datewise </td>
<td><input class="submit" type=radio checked id=optDat name=optDat onclick=selectpage(name)>
</td>
</tr>
</table>
<input TYPE=HIDDEN NAME="pageNum" value="1">
<input TYPE=HIDDEN NAME="rowsPerPage" value="10">
</form>
</center>
</body>
<script type="text/javascript">
function PrintCombo()
{
document.callsubm.submit();
}
function DoSubmit()
{
if(document.callsubm.datEnd.value=="")
{
document.callsubm.datEnd.value=document.callsubm.beg.value;
}
if (document.callsubm.inTxt.value=="")
{
alert ("Extension field cannot be empty");
document.callsubm.inTxt.focus();
return false;
}
else
{
return true;
}
}
function selectpage(value)
{
if(value=='optSingle')
{
callsubm.optDat.checked=!callsubm.optDat.checked;
}
if(value=='optDat')
{
callsubm.optSingle.checked=!callsubm.optSingle.checked;
}
}
</script>
</html>

any ideas. please some one guide me some sample codes on how to do it.

14 years ago

HTML Pages with CSS and JavaScript

Javascript and PHP

thanks eric..
i solved this problem by just giving document.form.submit();
its just works fine....

14 years ago

HTML Pages with CSS and JavaScript

Javascript and PHP

thanks eric..
but when i used to pass the variable $total_numbers through onchange function, the alert results as "hi undefined"...
how to pass the result value $total_numbers to textbox through onchange function.. here is my code which shows result in textbox when submit button is cliked..
please is any other way to solve this?

15 years ago

HTML Pages with CSS and JavaScript

Javascript and PHP

hi ranches...

my doubt is whether we can pass the query result '$no' directly to javascript variable to fill in the textbox using onchange() function. i dono how to pass this value. i tried the below code but its not working. please someone say how to proceed. i need the query result value to be displayed in textfield when user selects item from combobox.

15 years ago

HTML Pages with CSS and JavaScript

Javascript and PHP

hi ,
i have solved getting the selected combo value and passing it to another mysql query. am getting the result.
but now i need to pass these values to textfield.
here is my code;

<html>
<head><title> Testing </title> </head>
<body>
<form method="post">
<p> Choose group </p>
<p>
<label for="Group">Group</label>
<?php
$dbname='callreader';
$db_user='root';
$db_pass='';
$host='localhost';
$conn = mysql_connect($host, $db_user, $db_pass);
mysql_select_db($dbname);
$query="select distinct Name from billing_numbers";
$result=mysql_query($query,$conn) or die(mysql_error());
if($result)
{
?>
<select id="Name" name="Name">
<?php
while($row=mysql_fetch_assoc($result))
{
echo '<option value="'.$row['Name'].'">'.$row['Name'].'</option>';
}
?>
</select>
<?php
}
?>
<input type="submit" value="submit" />
</p>
</form>
<?php
if(isset($_POST['Name']))
{
$query="select Number from billing_numbers where Name='".$_POST['Name']."'";
$result=mysql_query($query,$conn) or die(mysql_error());
echo '<b>';
echo "Group Name:" . $_POST['Name'] . "\n<br/>";
echo "Numbers:\n<br/>";
echo '<b/>';
if($result)
{
while($row=mysql_fetch_assoc($result))
{
echo $row['Number']."<br/>";
}
}
}
?>
</body>
</html>

actually this is a part of my application. my home page code would be as follows:

<html>
<head>
<title>Call Reader</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link type="text/css" rel="stylesheet" href="calendar.css">
<link rel="stylesheet" type="text/css" media="all" href="themes/aqua.css" title="Calendar Theme-aqua.css" >
<script type="javascript" src="choosedate.js"></script>

<script type="text/javascript" src="src/utils.js"></script>
<script type="text/javascript" src="src/calendar.js"></script>

<script type="text/javascript" src="lang/calendar-en.js"></script>


<script type="text/javascript" src="src/calendar-setup.js"></script>
</head>
<body onload=top()>
<center>
<form name=callsubm method="get" onsubmit="return DoSubmit();" action="outgoing.php" >
<table border="0" >
<tr >
<td align="right">
From Date</td>
<td align="center" > 
<input style="border-style: none;" type="text" name="beg" id="beg" size="15" ></td>
<td><img src="calender" alt="C" id='img1'>
<script language=javascript type="text/javascript">
var cal = new Zapatec.Calendar.setup({
inputField:"beg",
ifFormat:"%d-%m-%Y ",
button:"img1",
showsTime:false
});
</script>
</td>
</tr>
<tr>
<td>
End Date</td>
<td > 
<input style="border-style: none;" type="text" name="datEnd" id="datEnd" size="15" ></td>
<td><img src="calender" alt="C" id='img2'>
<script language=javascript type="text/javascript">
var cal = new Zapatec.Calendar.setup({
inputField:"datEnd",
ifFormat:"%d-%m-%Y ",
button:"img2",
showsTime:false
});
</script>
</td>
</tr>
<tr>
<td>
Time</td>
<td > 
<input style="border-style: none;" name=time id=time type="text" size="15"></td>
<td><input type="image" id=time name=time src="Time.png"></td>
</tr>
<tr>
<td>
Extension</td>
<td > 
<input style="border-style: none;" name=inTxt id=inTxt type="text" size="15"></td>
<td><input type="image" id=callBtn name=callBtn src="phone.png" ></td>
</tr>
</table>
//here is were i need to implement that code and have to pass the result to above textfield 'inTxt'
<?php
$dbname='callreader';
$db_user='root';
$db_pass='';
$host='localhost';
$conn = mysql_connect($host, $db_user, $db_pass);
mysql_select_db($dbname);
//$result = mysql_query($query, $connection) or die('Dynamic query function: error making query');
$sql = mysql_query("SELECT distinct Name FROM billing_numbers ",$conn);
?>
<select class="style01" style="width:9em;" id="intercom" name="intercom" onchange="PrintCombo(document.forms[0])" style="font-size:12px;color:#006699;font-weight: bold;font-family:verdana;background-color:#ffffff;" >
<?php
while ($row = mysql_fetch_array($sql))
{
echo "<option value='$row[Name]'>$row[Name]";
echo $_GET['Name']==$row['Name'] ? 'selected' : '';
echo '</option>';
$var=$row[Name];
}
?>
</select>
<br/><br/>
<table>
<tr align="center">
<td align="center">Single </td>
<td><input class="submit" type=radio id=optSingle name=optSingle onclick=selectpage(name)>
</td>
<td>Datewise </td>
<td><input class="submit" type=radio checked id=optDat name=optDat onclick=selectpage(name)>
</td>
</tr>
</table>
<input TYPE=HIDDEN NAME="pageNum" value="1">
<input TYPE=HIDDEN NAME="rowsPerPage" value="10">
</form>
</center>
</body>
<script type="text/javascript">
function PrintCombo(form) {
//If you use the options value attribute for course fees
var item=form.intercom.selectedIndex;
var Result=form.intercom.options[item].text;
//var view=form.course.value;
//alert($view);
// document.write(resu);
form.inTxt.value = Result;
//location.href="SampleValidate.php?Result=" + Result;
}
function DoSubmit()
{
if(document.callsubm.datEnd.value=="")
{
document.callsubm.datEnd.value=document.callsubm.beg.value;
}
if (document.callsubm.inTxt.value=="")
{
alert ("Please enter extension number");
document.callsubm.inTxt.focus();
return false;
}
else
{
return true;
}
}
function selectpage(value)
{
if(value=='optSingle')
{
callsubm.optDat.checked=!callsubm.optDat.checked;
}
if(value=='optDat')
{
callsubm.optSingle.checked=!callsubm.optSingle.checked;
}
}
</script>
</html>

can anyone help how to pass the result value to textfield...[is it possible without using ajax]
thanks in advance.

15 years ago

HTML Pages with CSS and JavaScript