javascript - To apply css to the elements retrieved from database based on their value in database -
here trying do- have mysql table fields namely- clientname, urgent, complete.and displaying values fields have html table fields- clientname,urgent , complete.each row consist of clientname ,button urgent , button complete.if click on button urgent in table row button's color changes red , if again click on button again attains original color. in short,it toggles between 2 classes.at moment ,in database urgent field value gets updated 0(initial value) 1.now when reload page want display urgent button value 1 in red color.i.e. want apply css elements based on value in database. able toggle classes change color of urgent button on click , update value refresh page again attains default color.please let me know how able retain color if value in database 1 ,even if refresh page. jquery code-
$(".u").click(function () { $(this).toggleclass("urgent"); var id = $(this).attr('id'); $.ajax({ type:"post", url:"urgent.php", data:{'keyid': id}, cache: false, success: function(html){ $("#clientsheet").after(html); } });return false; });
html code-
<td style='text-align:center;'><button id=".$row['id']." class='u'>u</button></td>
please let me know if need more info. in advance. edited- how retrieving html table data database-
<?php include('db.php'); $fetch= mysqli_query($conn,"select * pendingwork order clientname asc"); while($row=mysqli_fetch_array($fetch)){ $id = $row['id']; $newname = $row['clientname']; echo "<tr id=".$row['id']."class='edit_tr'>"; echo " <td class='edit' id=".$id." name=".$newname.">".$row['clientname']."</td> <td style='text-align:center;'><button id=".$row['id']." class='u'>u</button></td> <td></td> <td style='text-align:center;'><button id=".$row['id']." class='del'>del</button></td> </tr>"; }
something like:
echo " <td class='edit' id=".$id." name=".$newname.">".$row['clientname']."</td> <td style='text-align:center;'><button id=".$row['id']." class='".($row["urgent"] == 1 ? "class1" : "class2")."'>u</button></td> <td></td> <td style='text-align:center;'><button id=".$row['id']." class='del'>del</button></td> </tr>";
this bit key:
($row["urgent"] == 1 ? "class1" : "class2")
it checks value of "urgent" , determines class use. if "urgent" 1, class1 applied, otherwise class2. replace class names appropriate application.
Comments
Post a Comment