So this form is pretty basic, it has a select box (list box) filled with possible values. You can select all or some of the values and then submit it to the server via Ajax. The problem was when I grabbed the value from the select box I only got the last value selected, not each. Regardless of if I was using POST or GET I still had to build the parameter list since that’s how XMLHttpRequest works. So I looped through the list and tried using the same parameter name for each, then on the PHP end I had the same result — each parameter overwrote the previous one and I saw only the last result. It wasn’t until I stumbled upon this post that someone gave a decent suggestion, which was to put a [] at the end of each parameter name when building the query string and PHP would automatically interpret it as an array. Since his code was somewhat over complicated I thought I’d share my version of it:
test-utility.php
<html>
<head>
<title>Test Utility</title>
<script type="text/javascript" src="test-utility.js"> </script>
</head>
<body>
<h1 align='center'>Test Utility</h1>
<center>
<p style="width:450px; text-align:justify;<?php if($error) echo "color:red;" ?>">
<?php if($error) { ?>
<strong>Error:</strong> <?php echo $error; ?>
<?php } ?>
</p>
<form name='frmTestUtility' id='frmTestUtility' method='post' action=''>
<table cellpadding="2" cellspacing="2" border="0">
<tr>
<td>
Listbox(s):<br><br>
<div style="font-size:smaller">(Hold CTRL to<br>select multiple)</div>
</td>
<td align="center">
<select name='listbox[]' id='listbox' multiple="multiple">
<option value='123'>123</option>
<option value='abc'>abc</option>
<option value='alpha'>alpha</option>
<option value='beta'>beta</option>
<option value='gamma'>gamma</option>
</select>
<br>
<input type="button" name="all" value="All" onClick='javascript:select_all();'>
<input type="button" name="none" value="None" onClick='javascript:select_none();'>
</td>
</tr>
<tr>
<td colspan="2">
<input type="button" name="submit" onclick="javascript:run_queries();" value="Run SQL" />
</td>
</tr>
</table>
</form>
<div id="ajax_results">
</div>
</center>
</body>
</html>
test-utility.js
function select_all() {
var d = document.getElementById(“listbox”);
for(var i=0;i
<?php // As you can see PHP displays it as an array if($_GET} print_r($_GET); ?>
I know it’s an old post, but I just recently stumbled across your blog. I’m just starting to learn PHP and stuff, so this article interested me. However, trying it out, I noticed a few problems with it.
1: The variable “url” in run_queries() is never initialized, but then appended to, causing it to end up as “undefined&lb[]=…”
2: The request string doesn’t have a question mark to separate the URL from the parameters.
3: The request is sent using GET, but then test-utility-ajax.php checks POST. It should use _GET or _REQUEST to get those parameters.
4: Two minor syntax errors, an extra /pre tag on test-utility:js:18 and a curly brace instead of parenthesis in test-utility-ajax.php:3.
Still, very informative. Thank you for the article. It’s always enjoyable to learn new things. ^_^
Hey, thanks for the comment. You’re right, this is an old post, and I can’t remember what I was working on when I came up with it. This example was a real world scenario which was then stripped down and any business specific code removed, and a few extra layers of stuff such as Smarty. During that process a few things were missed or in the case of the tags just snuck their way in there. I’ve gone ahead and added your corrections.
really works