|
I haven't touched any programming language in almost 10 years. I have a small project that I am working on and I have run into a small snag that I haven't been able to figure out. I have a form that contains several elements and 5 of these are drop down boxes that get populated from a database. They are dependant on each other. I have been able to successfully update my drop downs from the information in the database depending on what is selected in each box.
The problem that I am running into is that if I have information entered in any of the textboxes on the form and then use the drop down, that information is lost. I want to keep this information on the form until the submit button is hit. I have included my existing code. Any suggestions would be greatly appreciated.
I'm not sure why posting this has converted my < and > to extended characters.
<pre>
<?php
include("functions.php");
// server info
$server = "";
$user = "";
$password = "";
$db = "";
// server connection string
$dbconnect = mssql_connect($server, $user, $password)
or die("Couldn't connect to the Heat server.");
// db select string
$selectdb = mssql_select_db($db, $dbconnect)
or die("Coudn't open the Heat database.");
?>
<html>
<head>
<title>Heat Legacy : Advanced Search</title>
<link rel="stylesheet" href="css/heat.css" type="text/css" media="screen" />
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/jquery.searchbox.js"></script>
<script type="text/javascript">
function depReload(form)
{
var val1=form.dep.options[form.dep.options.selectedIndex].value;
self.location='form_search.php?dep=' + val1 ;
}
function d1Reload(form)
{
var val1=form.dep.options[form.dep.options.selectedIndex].value;
var val2=form.d1.options[form.d1.options.selectedIndex].value;
self.location='form_search.php?dep=' + val1 + '&d1=' + val2 ;
}
function d2Reload(form)
{
var val1=form.dep.options[form.dep.options.selectedIndex].value;
var val2=form.d1.options[form.d1.options.selectedIndex].value;
var val3=form.d2.options[form.d2.options.selectedIndex].value;
self.location='form_search.php?dep=' + val1 + '&d1=' + val2 + '&d2=' + val3 ;
}
function d3Reload(form)
{
var val1=form.dep.options[form.dep.options.selectedIndex].value;
var val2=form.d1.options[form.d1.options.selectedIndex].value;
var val3=form.d2.options[form.d2.options.selectedIndex].value;
var val4=form.d3.options[form.d3.options.selectedIndex].value;
self.location='form_search.php?dep=' + val1 + '&d1=' + val2 + '&d2=' + val3 +
'&d3=' + val4 ;
}
</script>
</head>
<body class='aformbody'>
<?php
@$dep = $_GET['dep'];
@$d1 = $_GET['d1'];
@$d2 = $_GET['d2'];
@$d3 = $_GET['d3'];
// Call Type drop down.
$query1=mssql_query("SELECT DISTINCT calltype FROM calltype order by calltype");
// Query to displays Drop1 based off of CallType
if(isset($dep)){
$query2=mssql_query("SELECT DISTINCT drop1 FROM drop1 where calltype='$dep' order by
drop1");
}
// Query to displays Drop2 based off of Drop1
if(isset($d1)){
$query3=mssql_query("SELECT DISTINCT drop2 FROM drop2 where drop1='$d1' order by
drop2");
}
// Query to displays Drop3 based off of Drop2
if(isset($d2)){
$query4=mssql_query("SELECT DISTINCT drop3 FROM drop3 where drop2='$d2' order by
drop3");
}
// Query to displays Drop4 based off of Drop1
if(isset($d3)){
$query5=mssql_query("SELECT DISTINCT drop4 FROM drop4 where drop1='$d1' order by
drop4");
}
echo "<h1> Advanced Search </h1>";
echo "<a href='index.php'>Back to Main Search</a> <br /><br />";
echo "<form method='post' name='advanced' class='aform' action='form_search.php'>";
?>
<table class="atable">
<tr>
<td>Account:</td>
<td colspan="2">Firm Name:</td>
<td>Primary Contact:</td>
<td>City</td>
<td>State</td>
</tr>
<tr>
<td><input type="text" name="account" maxlength="6" /></td>
<td colspan="2"><input type="text" name="firmname" maxlength="255" size="44"
/></td>
<td><input type="text" name="primarycontact" maxlength="50" /></td>
<td><input type="text" name="city" maxlength="25" /></td>
<td><input type="text" name="state" maxlength="3" /></td>
</tr>
<tr>
<td>Main Phone #:</td>
<td>Addtional Phone #:</td>
<td>Fax #:</td>
<td>Technical Rep:</td>
<td>Network:</td>
<td>Users:</td>
</tr>
<tr>
<td><input type="text" name="mainphone" maxlength="22" /></td>
<td><input type="text" name="addphone" maxlength="22" /></td>
<td><input type="text" name="fax" maxlength="22" /></td>
<td><input type="text" name="techrep" maxlength="25" /></td>
<td><input type="text" name="network" maxlength="29" /></td>
<td><input type="text" name="users" maxlength="5" /></td>
</tr>
<tr>
<td colspan="3">Technical Note:</td>
<td>Tax Rep:</td>
<td>Center:</td>
<td>Password:</td>
</tr>
<tr>
<td colspan="3"><input type="text" name="technote" maxlength="95" size="68"
/></td>
<td><input type="text" name="taxrep" maxlength="20" /></td>
<td><input type="text" name="center" maxlength="3" /></td>
<td><input type="text" name="password" maxlength="10" /></td>
</tr>
<tr>
<td colspan="6">Account Note:</td>
</tr>
<tr>
<td colspan="6"><input type="text" name="technote" maxlength="255" size="140"
/></td>
</tr>
<tr>
<td colspan="6"><hr width="800" align="left" /></td>
</tr>
<tr>
<td>Received by:</td>
<td><input type="text" name="recby" /></td>
<td><input type="text" name="recbydate" /></td>
<td><input type="text" name="recbytime" /></td>
</tr>
<tr>
<td>Last Mod by:</td>
<td><input type="text" name="modby" /></td>
<td><input type="text" name="modbydate" /></td>
<td><input type="text" name="modbytime" /></td>
</tr>
<tr>
<td colspan="6"><hr width="800" align="left" /></td>
</tr>
<tr>
<td style="text-align: right;">Call Contact:</td>
<td><input type="text" name="contact" /></td>
<td style="text-align: right;">Dept:</td>
<td>
<?php
// Populate the CallType drop down.
echo "<select name='dep'
onchange=\"depReload(this.form)\"><option value='one'>Select one</option>";
while($depart = mssql_fetch_array($query1))
{
if($depart['calltype']==@$dep)
{
echo "<option selected
value='$depart[calltype]'>$depart[calltype]</option>"."<BR>";
} else {
echo "<option
value='$depart[calltype]'>$depart[calltype]</option>";
}
}
echo "</select>";
?>
</td>
<td style="text-align: right;">Status:</td>
<td><input type="text" name="status" /></td>
</tr>
<tr>
<td style="text-align: right;">Received From:</td>
<td><input type="text" name="from" /></td>
<td style="text-align: right;">Dept:</td>
<td><input type="text" name="dept" /></td>
<td style="text-align: right;">Reason:</td>
<td><input type="text" name="reason" /></td>
</tr>
<tr>
<td colspan="6"><hr width="800" align="left" /></td>
</tr>
<tr>
<td colspan="5">Problem:</td>
<td>Solution ID:</td>
</tr>
<tr>
<td colspan="5"><textarea rows="4" cols="99" name="problem"></textarea></td>
<td><input type="text" name="solid" /></td>
</tr>
<tr>
<td colspan="6">Error Msg:</td>
</tr>
<tr>
<td colspan="6"><input type="text" name="error" size="140" /></td>
</tr>
<tr>
<td>
<?php
// Populate Drop1
echo "<select name='d1'
onchange=\"d1Reload(this.form)\"><option value=''>Select one</option>";
while($drop1 = mssql_fetch_array($query2))
{
if ($drop1['drop1']==@$d1)
{
echo "<option selected
value='$drop1[drop1]'>$drop1[drop1]</option>"."<BR />";
} else {
echo "<option
value='$drop1[drop1]'>$drop1[drop1]</option>";
}
}
echo "</select>";
?>
</td>
<td>
<?php
// Populate Drop2
echo "<select name='d2'
onchange=\"d2Reload(this.form)\"><option value=''>Select one</option>";
while($drop2 = mssql_fetch_array($query3))
{
if ($drop2['drop2']==@$d2)
{
echo "<option selected
value='$drop2[drop2]'>$drop2[drop2]</option>"."<BR />";
} else {
echo "<option
value='$drop2[drop2]'>$drop2[drop2]</option>";
}
}
echo "</select>";
?>
</td>
<td>
<?php
// Populate Drop3
echo "<select name='d3'
onchange=\"d3Reload(this.form)\"><option value=''>Select one</option>";
while($drop3 = mssql_fetch_array($query4))
{
if ($drop3['drop3']==@$d3)
{
echo "<option selected
value='$drop3[drop3]'>$drop3[drop3]</option>"."<BR />";
} else {
echo "<option
value='$drop3[drop3]'>$drop3[drop3]</option>";
}
}
echo "</select>";
?>
</td>
<td colspan="3">
<?php
// Populate Drop 4
echo "<select name='d4'><option value=''>Select one</option>";
while($drop4 = mssql_fetch_array($query5))
{
echo "<option
value='$drop4[drop4]'>$drop4[drop4]</option>";
}
echo "</select>";
?>
</td>
</tr>
<tr>
<td colspan="6">Resolution:</td>
</tr>
<tr>
<td colspan="6"><textarea rows="4" cols="120"
name="resolution"></textarea></td>
</tr>
<tr>
<td><input type="submit" value="Submit"></td>
</tr>
</form>
</table>
</body>
</html>
<?php
// close the connection to the db
mssql_close($dbconnect);
?>
</pre>
|
|
|
|
|
Hey All,
I'm just trying to configure an IIS mapping from one machine to another using:
iis://machine.domain.com/W3SVC/625275872/ROOT/RSS
How can I 'view' the contents of the RSS virtual dir from another machine in order to confirm that this address is actually correct?
Cheers,
|
|
|
|
|
Hello
I need an application for calling from my webapplication to Phone or Mobile.I think by using API or using IVR (Interactive Voice Response) it is possible.
Give me an idea about how to do it...
Urgently needed........
|
|
|
|
|
Pradeep kumar.V wrote: Give me an idea about how to do it...
Did you try searching Google?
Pradeep kumar.V wrote: Urgently needed........
Well, you need to work fast.
|
|
|
|
|
Searched more...
But i can't reach the correct requirement.
Example:www.call-center-tech.com
They can't provide dynamic Phone number change...and how to integrate with my web application(JSP/Servlet)?
Help needed....
|
|
|
|
|
You want the server to make a phone call for you ? Why ? Where would the speech come from for this phone call ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hiiii
Here Recorded sound will be treated as the message...
How these all to be integrate with Java application thats the real matter....
|
|
|
|
|
Isn't this the same question that you posted yesterday (21 Oct)? It is generally regarded as bad form to post the same question multiple times to the same forum.
|
|
|
|
|
Hii everyone.. I wanted to know if it is possible to access all the print-specific CSS properties of a webpage using java script.. What I mean to say is many pages have @media print properties that apply to elements only when printed.. I want a collection of those properties.. Is there any way to access the same ?
|
|
|
|
|
Hi All,
What are different ways to send voice message to the phone(land phone/mobile) from java/jsp applications as a remainder in a scheduled time.How it can be implemented.Whether any source code is available for that.
Thanks you
Sanuji
|
|
|
|
|
sanuji wrote: Whether any source code is available for that.
See here[^].
|
|
|
|
|
I'm in need of a "global" type timer that will allow me to basically run a clock the entire time someone is on my site, no matter what pages they go to.
I've played around with the timer available for forms but I didn't see a way to make it continue to run after someone left that page.
The effect I'm attempting to create is for a timer to start whenever someone hits my site, then every X minutes an event will trigger. This event should happen no matter where they are on the site.
I've read a couple articles on timers but to be honest I'm fairly new to VB and I didn't know if I really needed to learn about 'threading' etc, to get a timer to work.
Links to code or articles would be very appreciated.
Thanks
P.S. I'm using .Net 3.5 in VB, but if you have something in C# I'm sure I can make do 
|
|
|
|
|
I'm by no means sure of this, and I won't have time to play with it today... but you might have a look at Global.asax. Maybe if you instanciated a timer object in that code, it would address your needs?
|
|
|
|
|
Hi ,
There is an issue of ie8 on JavaScript.When I call a button click on ie8 , postback is occuring.It is working fine with ie7.How to prevent it from happening a postback
With Warm regards.
|
|
|
|
|
onclick="return false;"
The above javascript should do it. So if you had a function call in your onclick:
onclick="yourfunction(); return false;"
you may also want to:
Disable the Enter Key[^]
|
|
|
|
|
I hope your issue has been resolved 
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Hai Folks....
If anybody looking for to send SMS from your php page or jsp or from any other web scripts
no need to create any hectic code. i got a solution for you. ust use the given ling (URL) to send sms from your php / jsp application.All you needed is an account in way2sms (http://site2.way2sms.com/content/index.html)
all rite.. Hope Now you have an account in way2sms with USERNAME and PASSWORD
All you need to do is call this url from ur php/jsp application with parameters
* You have to pass 4 parameters along with the URL to send SMS
http://www.hashsolutions.in/demo/sendsms/sendsms.php?rec=94xxxxxxxx&message=messagebody&user=9400xxxxxxxx&password=sujidivakar
Let me Explain
rec="The receiver num to whom you want sens sms"
message="Body of the message that you wanna send"
user="Your way2sms username(phone num)"
password="password of your way2sms account"
Now Check it out and enjoy... Happy coding folks....
If you friends think this link is helpfull please give a like to our FACEBOOK link given below
https://www.facebook.com/hashsolutions
Friends.........,For your any valuable suggestion and doubts please feel to write Me @
sujidivakar@gmail.com
Ma FB account
https://www.facebook.com/sujidivakar
Hash Solutions, Cochin
http://www.hashsolutions.in/
|
|
|
|
|
Thanks for replay..
Then say how can i get such web service to send SMS.For phone dialing the web service is needed?.
Thanks you
Sanuji Pillai
|
|
|
|
|
You need to ask question in proper thread.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Hi All,
I need method for sending free SMS from our JSP code.I tried my level best but no result.And im looking for java code for telephone dialing from our jsp web application.
If anyone have an idea pls help me.
Thank you
Sanuji Pillai
|
|
|
|
|
sanuji wrote: If anyone have an idea pls help me.
The first thing you need to do, is think about what you're asking. There's no SMS code in jsp. There's only web services which send SMSs in different regions, for different fees. There is no guarentee that a free service exists in your area. I don't see why there would be one.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Thanks for replay..Then say how can i get such web service to send SMS.For phone dialing the web service is needed?.
Thanks you
Sanuji Pillai
|
|
|
|
|
Hi,
I am facing the same problem that how to send sms from jsp page by using web services.
Please help.
Thanks
Islam
|
|
|
|
|
Hai Folks....
If anybody looking for to send SMS from your php page or jsp or from any other web scripts
no need to create any hectic code. i got a solution for you. ust use the given ling (URL) to send sms from your php / jsp application.All you needed is an account in way2sms (http://site2.way2sms.com/content/index.html)
all rite.. Hope Now you have an account in way2sms with USERNAME and PASSWORD
All you need to do is call this url from ur php/jsp application with parameters
* You have to pass 4 parameters along with the URL to send SMS
http://www.hashsolutions.in/demo/sendsms/sendsms.php?rec=94xxxxxxxx&message=messagebody&user=9400xxxxxxxx&password=sujidivakar
Let me Explain
rec="The receiver num to whom you want sens sms"
message="Body of the message that you wanna send"
user="Your way2sms username(phone num)"
password="password of your way2sms account"
Now Check it out and enjoy... Happy coding folks....
If you friends think this link is helpfull please give a like to our FACEBOOK link given below
https://www.facebook.com/hashsolutions
Friends.........,For your any valuable suggestion and doubts please feel to write Me @
sujidivakar@gmail.com
Ma FB account
https://www.facebook.com/sujidivakar
Hash Solutions, Cochin
http://www.hashsolutions.in/
|
|
|
|
|
its nt working with my jsp page.it says invalid login
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
