8
rated 0 times
[
13]
[
5]
/ answers: 1 / hits: 18584
/ 12 Years ago, wed, may 2, 2012, 12:00:00
I need some js/ajax/jquery script saving data to database dynamically when I check the check-box.
the checkboxes at the moment or loaded in next to records and change the variable in the database depending if its checked or not.but i have to reload the page after i select one to save it to the database. i can do everything else but understand how to implement the ajax to this so i don't have to submit the query and refresh the page every time. any help is greatly appreciated.
<form name=form1aa method=post action=process.php?fn=<? echo $rows['first']; ?>&class=<?php echo $rows['class']; ?>&last=<?php echo $rows['last']; ?>
&model=<?php echo $rows['model']; ?>&cas=<?php echo $rows['cases']; ?>&upid=<?php echo $id; ?>&group=1 id=form1a >
<select name=type onchange= fill_damage (document.form1aa.type.selectedIndex); >
<option value=Hardware>Hardware</option>
<option value=Software>Software</option>
</select>
<select name=damage>
</select>
<input type=text name=comment placeholder=Comments Box>
<input type=text name=cost placeholder=Cost>
<input type=submit value=Save name=Save>
</form>
<?php
//Job Status
if(isset($_POST['checkbox'])){$checkbox = $_POST['checkbox'];
if(isset($_POST['activate'])?$activate = $_POST[activate]:$deactivate = $_POST[deactivate])
$id = (' . implode( ',', $checkbox ) . '); ;
$sql=UPDATE repairs SET status = '.(isset($activate)?'Completed':'In Progress').' WHERE id=$id ;
$result = mysql_query($sql) or die(mysql_error());
}
//End Job Status
//Payment Status
if(isset($_POST['paycheck'])){$paycheck = $_POST['paycheck'];
if(isset($_POST['paid'])?$paid = $_POST[paid]:$unpaid = $_POST[unpaid])
$id = (' . implode( ',', $paycheck ) . '); ;
$sql=UPDATE repairs SET paid = '.(isset($paid)?'Paid':'Unpaid').' WHERE id=$id ;
$result = mysql_query($sql) or die(mysql_error());
}
//End Payment Status
//Return Status
if(isset($_POST['retcheck'])){$retcheck = $_POST['retcheck'];
if(isset($_POST['ret'])?$ret = $_POST[ret]:$unret = $_POST[unret])
$id = (' . implode( ',', $retcheck ) . '); ;
$sql=UPDATE repairs SET ret = '.(isset($ret)?'Retuned':'In Office').' WHERE id=$id ;
$result = mysql_query($sql) or die(mysql_error());
}
//End Return Status
$sql=SELECT * FROM $tbl_name;
if(isset($_POST['all'])){
$sql=SELECT * FROM $tbl_name;
}
if(isset($_POST['tpc'])){
$sql=select * from $tbl_name WHERE class LIKE '1%';
}
if(isset($_POST['drc'])){
$sql=select * from $tbl_name WHERE class LIKE 'D%';
}
if(isset($_POST['bsc'])){
$sql=select * from $tbl_name WHERE class LIKE 'B%';
}
$result=mysql_query($sql);
?>
<form name=frmactive method=post action=>
<input name=activate type=submit id=activate value=Complete Job />
<input name=paid type=submit id=Payment value=Payment Status />
<input name=ret type=submit id=ret value=Returned 2 Student />
<br />
<a id=displayText href=javascript:toggle();>Show Extra</a>
<div id=toggleText style=display: none>
<br />
<input name=unret type=submit id=unret value=In Office />
<input name=unpaid type=submit id=unpaid value=Not Paid />
<input name=deactivate type=submit id=deactivate value=In Progress /></div>
<table width=1000 border=0 cellpadding=3 cellspacing=1>
<thead>
<th width=67 align=center><strong>Start Date</strong></th>
<th width=50 align=center><strong>Cases</strong></th>
<th width=34 align=center><strong>Type</strong></th>
<th width=120 align=center><strong>Damage</strong></th>
<th width=31 align=center><strong>Comment</strong></th>
<th width=31 align=center><strong>Cost</strong></th>
<th width=90 align=center><strong>Payment Status</strong></th>
<th width=100 align=center><strong>Returned 2 Student</strong></th>
<th width=100 align=center><strong>Job Status</strong></th>
</thead>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td><? echo $rows['start']; ?></td>
<td><? echo $rows['cases']; ?></td>
<td><? echo $rows['type']; ?></td>
<td width=70><? echo $rows['damage']; ?></td>
<td width=70><? echo $rows['comment']; ?></td>
<td><? echo $; echo $rows['cost']; ?></td>
<!--Payment Display(Start)-->
<?php
if($rows['paid']==Paid)
{
?>
<td><input name=paycheck[] type=checkbox id=paycheck[] value=<? echo $rows['id']; ?>>
<? echo $rows['paid'];?>
</td>
<?
}
if($rows['paid']==Unpaid)
{
?>
<td width=21><input name=paycheck[] type=checkbox id=paycheck[] value=<? echo $rows['id']; ?>>
<? echo $rows['paid']; ?>
</td>
<?
}
if($rows['ret']==){
?>
<td width=50>No Data</td>
<?
}
?>
More From » php