5 replies to this topic

[.CJ]

Hi all,

For hours now I've been trying to make a select form update the database when a 'onchange' occurs. I'm using Prototype instead of custom AJAX, as I prefer it, also I'm using PHP in the back end.

Can anyone be a kind soul and let me know any any code or tutorials that tell me how to update a database using an 'onchange' command and using PHP in the back end.

Thanks all, hope to hear from you soon.

Chris.

[rc69]

It'd probably be easier if you show us what you have so far and tell us whats going on, then have us help you fix it. I doubt you'll find a single tutorial that will do this for you, a mix maybe, but not one individual tutorial.

[.CJ]

Ok.

HTML/PHP

echo('
		  <select name="brand" onchange="changeBrand('.$row['id'].'); return false">
			');
			// query
			$group_query = mysql_query("SELECT * FROM ibf_groups, ibf_members WHERE ibf_groups.g_id = ibf_members.id AND g_id IN(3, 4, 6, 7)");
			// fetch data
			while($groups = mysql_fetch_array($group_query)) {
			$selected = $row['mgroup'] == $groups['g_id'] ?  'selected' : '';
			echo('
			<option value="'.$groups['g_id'].'" '.$selected.'>'.$groups['g_title'].'</option>
			');
			}
			echo('
		  </select>
');

JS

// Update roster brand
function changeBrand(id) {
	new Ajax.Updater('brandChange', 'js/brand.php?id=' + id + '&mgroup=' + document.form.brand.options[document.form.brand.selectedIndex].value);
}

PHP

<?php
// functions
include("../include/functions.php");
// MySQL connection
connect();

if(isset($_GET['id'])) {
	mysql_query("UPDATE ibf_members SET
		mgroup = '".$_GET['mgroup']."'
	WHERE id = '".$_GET['id']."'");
}

// close MySQL
mysql_close();
?>

I'd like to point out just that I'm not really a newbie, nor am I a guru and have used Prototype and got it working bang on, but using it with SELECT form's has baffled me.

[Demonslay]

What part of it isn't working?

You can get the value of the select element just like any other form element with Prototype.

$F('brand')

I would assign the select menu an ID also, as JavaScript tends to use to use that more than the name attribute.

Other than that, I don't get what you would want to update with a select element. What exactly do you think you can update in the element?

Your method just doesn't make sense to me, lol.

Just use a regular Ajax.Request method, and it'll be just fine.

Edited by Demonslay, 09 March 2007 - 10:10 PM.

[.CJ]

Yeah, really, 'tis rather gibberish, I guess I find it hard to explain. I did try Ajax.Request, wasn't sure how to code the PHP though, I guess not too different from what I use above.

[Demonslay]

Ajax.Request is the very core of anything Prototype uses for Ajax actions, so it's the exact same thing pretty much. Just read the Documentation for more information.