mySQL data editing using ajax

[macneato]

Hi,

So basically I have a php file that fetches database records and displays it. Now i would like to add the ability to edit each record using lightbox.

here is the main file

<?php
$username="root";
$password="";
$database="lhs_anniversary_banquet";

mysql_connect("localhost",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM students";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>

	<script type="text/javascript">
		$(document).ready(function() {
			$(".dialog_link").fancybox({
				'titlePosition'		: 'inside',
				'transitionIn'		: 'fade',
				'transitionOut'		: 'fade'
			});	
		
			var variblevalue = $('.dialog_link').attr('href');
			var variblefixed = variblevalue.substr(1);

			$("#form_submit"+variblefixed).submit(function() {
			// we want to store the values from the form input box, then send via ajax below

			
			var id     = $('.id').attr('value');
			var email     = $('#email'+variblefixed).attr('value');
			alert(email);
			var cell     = $('#cell'+variblefixed).attr('value');
				$.ajax({
					type: "POST",
					cache	: false,
					url: "ajax.php",
					data: "email="+ email +"& cell="+ cell +"& id="+ id,
					success: function(){
						$('#form_submit'+variblefixed).hide(function(){$('div.success').fadeIn();});
					}
				});
			return false;
			
			
		});	
	});		

	</script>

<table border="0" cellspacing="0" cellpadding="0">
	<tr>
		<th>Name</th>
		<th>Surname</th>
		<th>Nickname</th>
		<th>Class</th>
		<th>Email</th>
		<th>Cell</th>
		<th></th>
	</tr>

	<?php
	$i=0;
	while ($i < $num) {
	
	$f1=mysql_result($result,$i,"id");
	$f2=mysql_result($result,$i,"Name");
	$f3=mysql_result($result,$i,"Surname");
	$f4=mysql_result($result,$i,"Nickname");
	$f5=mysql_result($result,$i,"Class");
	$f6=mysql_result($result,$i,"Email");
	$f7=mysql_result($result,$i,"Cell");
	?>

	<tr>
		<td><?php echo $f2; ?></td>
		<td><?php echo $f3; ?></td>
		<td><?php echo $f4; ?></td>
		<td><?php echo $f5; ?></td>
		<td><?php echo $f6; ?></td>
		<td><?php echo $f7; ?></td>
	<td>

		<a href="#<?php echo $f1; ?>" class="dialog_link">Edit</a>
		<div style="display: none;">
			<div id="<?php echo $f1; ?>" title="Update this record" style="width:400px;height:160px;overflow:auto; border: 4px solid #ff5501; padding:10px">
			<h2><?php echo $f2; ?> <?php echo $f3; ?></h2>
			<p>Fill in the information below and click save changes</p>
			<br/>
			<form id="form_submit<?php echo $f1; ?>" method="post">
					<fieldset>
						<input name="id" value="<?php echo $f1; ?>" class="id">
						<table cellpadding="0" cellspacing="0">
							<tr>
								<td><label for="email<?php echo $f1; ?>">Email Address:</label>
								</td>
								<td><input id="email<?php echo $f1; ?>" class="text" name="email" size="20" type="text" value="<?php echo $f6; ?>">
								</td>
							</tr>
							<tr>
								<td><label for="cell<?php echo $f1; ?>">Cell:</label>
								</td>
								<td><input id="cell<?php echo $f1; ?>" class="text" name="cell" size="20" type="text" value="<?php echo $f7; ?>">
								</td>
							</tr>						
						</table>
						<br/>
						<input type="submit" name="mysubmit" value="Save Changes" class="button"> 
					</fieldset>
			</form>		
			<div class="success" style="display: none;">This record has been updated.</div> 
			</div>
		</div>

	</td>


</tr>

<?php
$i++;
}
?>

Onsubmit i use the following;

<?php

	$username="root";
	$password="";
	$database="lhs_anniversary_banquet";
	
	mysql_connect("localhost",$username,$password);
	@mysql_select_db($database) or die( "Unable to select database");

	// CLIENT INFORMATION
	$id        = $_POST['id'];
	$email        = $_POST['email'];
	$cell        = $_POST['cell'];

    $updateuser  = "UPDATE students SET Email='$email', Cell='$cell' WHERE id='$id'";
    echo $updateuser;

    mysql_query($updateuser) or die(mysql_error());
?>

Now this works perfectly with one record. Think it might be an ID issue. Not too sure though. Any help would be great. Thanks

[macneato]

Guessing the issue had something to do with the ID. Nevertheless, what i have did was. Change my lightbox to be launched from a ajax window (passing the variable via url) then ran the script from there. Worked like a charm.

Think i will get a Solved Threads point for solving my own? :)