The simple code below gets data from a Location field and puts them into a lisbox. What I want to do is to be able to select one from the list and run a new function. How to get $areasearch valid?
Thanks in advance for any help
F - <html>
-
<body>
-
<h3>List Box Form Data</h3>
-
<p>Form data passed from the form</p>
-
<?php
-
require("./resources/globals.php") ;
-
$query="SELECT DISTINCT * FROM Garant GROUP BY Location";
-
$stmt= substr($query, 0, strlen($query)-4) ;
-
// Connect to the Database
-
$link=mysql_connect($location,$userName,$password) or die (mysql_error());
-
mysql_select_db($dbname) or die (mysql_error());
-
$result=mysql_query($query) or die (mysql_error());
-
// Select the Database
-
if (!mysql_select_db($dbname, $link)) {
-
DisplayErrMsg(sprintf("Error in selecting %s database", $dbname)) ;
-
DisplayErrMsg(sprintf("error:%d %s", mysql_errno($link), mysql_error($link))) ;
-
exit() ;
-
}
-
-
// Execute the Statement
-
if (!($result =mysql_query($query, $link))) {
-
DisplayErrMsg(sprintf("Error in executing %s stmt", $query)) ;
-
DisplayErrMsg(sprintf("error:%d %s", mysql_errno($link), mysql_error($link))) ;
-
exit() ;
-
}
-
echo '<select name="areasearch" onchange="return dropdown(this)">';
-
-
while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
-
echo "<option value=$nt[Town]>$nt[Location]</option>";
-
}
-
echo"</select>";
-
echo" </form>";
-
echo $areasearch;
-
-
mysql_free_result($result) ;
-
-
Function onSelection($areasearch){
-
echo "<here>";
-
}
-
?>
-
-
</body>
-
</html>
13  1803  @phobia1
hard to tell because you didn’t tell what the form action is. the main point is that the function should be run after the user selects something (is that a form submission?) on the client side. So it is either something you do while processing the form or processing the form with AJAX.
note: $nt[Location] should be $nt["Location"], otherwise consider this example - define("Location", 12345);
-
$nt[Location] // is the same as $nt[12345]
and you have at least notice reporting off…
Thanks for the reply.. I have made a few changes and it is trying to work, so I hope that the correction is possibly minor:-) - // Generate the SQL command for doing a select from the Database
-
1. $query="SELECT DISTINCT * FROM Garant GROUP BY Location";
-
-
2. $stmt= substr($query, 0, strlen($query)-4) ;
-
-
// Connect to the Database
-
3. $link=mysql_connect($location,$userName,$password) or die (mysql_error());
-
4. mysql_select_db($dbname) or die (mysql_error());
-
5. $result=mysql_query($query) or die (mysql_error());
-
-
// Select the Database
-
6. if (!mysql_select_db($dbname, $link)) {
-
7. DisplayErrMsg(sprintf("Error in selecting %s database", $dbname)) ;
-
8. DisplayErrMsg(sprintf("error:%d %s", mysql_errno($link), mysql_error($link))) ;
-
9. exit() ;
-
10.}
-
-
-
// Execute the Statement
-
11.if (!($result =mysql_query($query, $link))) {
-
12. DisplayErrMsg(sprintf("Error in executing %s stmt", $query)) ;
-
13. DisplayErrMsg(sprintf("error:%d %s", mysql_errno($link), mysql_error($link))) ;
-
14. exit() ;
-
15.}
-
-
16, echo "<form>";
-
-
17. echo '<select name="areasearch" onChange="submit();">';
-
// printing the list box select command
-
-
18. while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
-
19. echo "<option value=$nt[Town]>$nt[Location]</option>";
-
/* Option values are added by looping through the array */
-
20.}
-
21.echo "</select>";// Closing of list box
-
-
-
22.echo "</form>";
-
23.echo $areasearch;
-
-
-
24.output_array($areasearch); //$pricelow and $pricehigh correct BUT...
-
-
25.Function output_array($areasearch){
some questions - what is the error/misbehaviour you encounter?
- where does $areasearch come from?
- where do you submit the form to?
- what does output_array() do exactly?
and some remarks - $nt[Location] should be $nt["Location"], Location is not a string but a constant, and due to the lack of the appropriate constant definition, PHP tries the constant’s name as string.
- the form’s required action attribute is missing
PS. please use [code] tags when posting code, makes it far easier to read.
:-)
The error is that the onchange action gives me Veliko everytime..no matter what I select.
areasearch ooooo that doesn't get passed from the listbox...oops
The form I just submit it back to itself..maybe should be with PHP-SELF action.
Function output array displays a set of pictures and does work correctly. All I need is the value for areasearch or in other words the text in the selection..for example if I select Leeds...then I want the $areasearch to be Leeds.
I can send you the full page if you like.The problem is that I haven't worked with PHP and HTML for about 2 years and have forgotten so much.
Best
F
@phobia1
technically that’s not an error, you just specified "veliko" to be the return value for every <option>.
More than likely:-)
Obviously I am out of depth for the time being with this problem. Ill do some reading to figure out How I can make the idea to work. To my mind the hardest part works...populating the listbox. Now I have to figure out how to get the text value of the selected item.
Thanks very much for what you tried to tell me.
Best
F
what about setting text value and element value alike? - echo "\n\t<option value='", $nt["Location"], "'>", $nt["Location"], "</option>";
although it is a good idea to re-read the manual from time to time…
:-) Superstar
That fixes the problem. Syntax and understanding of anything takes much time. I just do this stuff for a hobby.
I'll keep reading as have many things that I would like to be able to.
Many thanks again
Fred
I really really do appreciate the help you gave me. Perhaps one day I can return the favour
Some nitpicking: use single quotes where you are not expecting to have variables parsed inside the string. Double quotes will parse the string for variables (extra overhead, although not much).
I think I'll run some benchmarks to see how much of a difference there is.
@Markus
I’d be interested in the results. $foo['bar'] vs. $foo[bar] is a difference of about 700%
Sign in to post your reply or Sign up for a free account.
Similar topics
by: |
last post by:
I am hoping a mixed ASP- Javascript programmer could help me with this
scenario:
I have a list box populated with randomized records (NewID()) from a Broker
(Salesperson) sql server table.
...
|
by: Lee Mundie |
last post by:
Hi there,
Simple problem here but can't seem to fix it!
Okay, I have a select list from which people choose avatars...
the list is option values ie. <option>Worm</option> ...
|
by: Zeebra3 |
last post by:
Here goes: I have a web form with several asp:dropdownlists, with
which, when selection is changed I want to fire an event defined in
some clientside js.
The content of the clientside code is...
|
by: jab3 |
last post by:
Hello. I"m new to this group, and to JavaScript in general, so please
forgive me if I breach local etiquette. I'm trying to implement some
client-side 'dynamic' validation on a form. I'm having...
|
by: Peter |
last post by:
Does anyone know how to trap SelectedIndexChanged event on the client side
for the following control?
http://www.metabuilders.com/Tools/ComboBox.aspx
I have tried...
|
by: lowslyn |
last post by:
hi,
can someone please help me with javascript...
i have this code that checks a text field when the user overrides the value to blank/space. if it is blank/space, i need to change the value...
|
by: giandeo |
last post by:
Hello Experts.
Could you find a solution for this problem please!
I have the following tables in Access Database
Table Name: origin
Fields Names: country, countrycode
Table Name: make...
|
by: ALT75 |
last post by:
Hi all,
I'm after some guidance for a friend of a friend so to speak, JavaScript isn't my thing so i can't help but i'm hoping someone can. The email i recieved is as follows;
I have a drop down...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| | |
