.png)
@@@@@@@@ CREARE FILE INDEX.PHP@@@@@@@@ <?php $hostname= "localhost";$username= "root";$password= "";$database= "test"; $con= mysqli_connect($hostname,$username,$password,$database) or die("couldn't connect to database"); //del if($_GET['del_id']!=''){ $delSql="DELETE FROM mtype WHERE mtype_id='".@$_GET['del_id']."'"; $delQuery=mysqli_query($con,$delSql) or die('del query failed'); if($delQuery){ echo "data deleted successfully"; }}?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>insert multiple checkbox</title> <link rel="stylesheet" href="css/bootstrap.min.css" type="text/css"> <link rel="stylesheet" href="css/bootstrap.css" type="text/css"> <link rel="stylesheet" href="style.css" type="text/css"></head><body> <form action="index.php" method="post"> <fieldset><div><input type="hidden" name="mtype_id" value="<?php @$_GET['uid']?> > </div> <label>Favorite Pet?</label> <input type="checkbox" name="interest[]" value="Cats" ><label style="margin-left: 5px;" for="">Cats</label> <input type="checkbox" name="interest[]" value="Cats" ><label style="margin-left: 5px;" for="">Cats</label> <input type="checkbox" name="interest[]" value="RAT" ><label style="margin-left: 5px;" for="">RAT</label> <input type="checkbox" name="interest[]" value="Dogs" ><label style="margin-left: 5px;" for="">Dogs</label> <input type="checkbox" name="interest[]" value="Birds" ><label style="margin-left: 5px;" for="">Birds</label> <input type="checkbox" name="interest[]" value="lie" ><label style="margin-left: 5px;" for="">lie</label> </fieldset> <br> <input type="submit" name="submit" value="Submit"> </form></body></html><?php if(isset($_POST['mtype_id'])){ $ar=$_POST['interest']; // echo $ar; die(); $Chst = implode("," ,$ar); $SQL= "insert into mtype(interest) values('$Chst')"; $Query =mysqli_query($con,$SQL) or die('query failed insert'); if($Query){ echo '<div style"text-align:center; font-weight:900;font-size:32px"> data inserted successfully</div>';}} //data display $disSQL="select *from mtype "; $dQuery=mysqli_query($con,$disSQL) or die('dis quer falied'); ?><table width="100%"> <thead><tr> <th style="text-align: center;">#</th> <th style="text-align: center;"></>ID</th> <th style="text-align: center;"></>CHECHBOX</th> <th style="text-align: center;"></>operation</th> </tr></thead><tbody> <?php $abe=1; foreach($dQuery as $key=>$value){ ?><tr> <td style="text-align: center;"><?php echo $abc++ ;?></td> <td style="text-align: center;"><?php echo $value['mtype_id']?></td> <td style="text-align: center;"><?php echo $value['interest'] ?></td> <td style="text-align: center;"> <a href="update.php?uid=<?php echo $value['mtype_id'] ?>" style="background: green;padding: 5px;color: white;"<input type='submit' value='Update' class='update'> update</a> <a href="index.php?del_id=<?php echo $value['mtype_id'] ?>" style="padding=5px; font-size:20px ;background:red; color:white font_weight:900">delete</a></td> </tr><?php } ?></tbody></table> @@@@@@@@ CREARE FILE UPDATE.PHP@@@@@@@@ <?php $hostname= "localhost";$username= "root";$password= "";$database= "test"; $con= mysqli_connect($hostname,$username,$password,$database) or die("couldn't connect to database"); //fetch if(@$_GET['uid']!=''){ // echo $_GET['uid']; die(); $fetSql = "select *from mtype where mtype_id='".@$_GET['uid']."'"; $fetQuery=mysqli_query($con,$fetSql) or die ('failed fetquery'); $editData=mysqli_fetch_assoc($fetQuery); $ST=$editData['interest']; $AR=explode(',',$ST); }?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>insert multiple checkbox</title> <link rel="stylesheet" href="css/bootstrap.min.css" type="text/css"> <link rel="stylesheet" href="css/bootstrap.css" type="text/css"> <link rel="stylesheet" href="style.css" type="text/css"></head> <body><form action='' method="post"><fieldset> <input type="checkbox" name="interest[]" value="Cats" <?php if(in_array('Cats', $AR)) {echo "checked";}?> ><label style="margin-left: 5px;" for="">Cats</label> <input type="checkbox" name="interest[]" value="RAT" <?php if(in_array('RAT', $AR)) {echo "checked";}?> ><label style="margin-left: 5px;" for="">RAT</label> <input type="checkbox" name="interest[]" value="Dogs" <?php if(in_array('Dogs', $AR)) {echo "checked";}?> ><label style="margin-left: 5px;" for="">Dogs</label> <input type="checkbox" name="interest[]" value="Birds"<?php if(in_array('Birds',$AR)) {echo "checked";}?> ><label style="margin-left: 5px;" for="">Birds</label> <input type="checkbox" name="interest[]" value="lie" <?php if(in_array('lie', $AR)) {echo "checked";}?> ><label style="margin-left: 5px;" for="">lie</label> <div class="text-left"> <br> <input type="hidden" value="<?php echo $_GET['uid'] ?>" name="mtype_id"> <!-- <input type="submit" value="update" class="btn" name="edit"> --> <input type="submit" name="edit" value="update"></div> </div></fieldset></form></body></html><?php // update // if(@$_POST['mtype_id']!=''){ if(isset($_POST['edit'])){ $id=$_GET['uid']; // echo $_GET['uid']; die(); $mtype_id = mysqli_real_escape_string($con, $_GET["mtype_id"]); $Ar = $_POST['interest']; $D = implode(", ",$Ar); $UPSql ="UPDATE mtype SET interest='$D' WHERE mtype_id='$id' "; // echo $UPSql; exit(); $UPQuery = mysqli_query($con,$UPSql) or die('update query failed'); if($UPQuery){ echo 'data updated successfully!!!!!!!!!!!!'; }else{ echo 'data not updated'.mysqli_connect_error();}}?>
September-04-2024 09:18:37
August-11-2024 11:31:12
August-02-2024 23:22:25
May-12-2024 02:44:34
.png)
May-10-2024 20:14:30