.png)
<?php //1 CONNECTUON $servername="localhost"; $username="root"; $password=""; $dbname="test"; $con= mysqli_connect($servername,$username,$password,$dbname) or die('database connection failed'); //3 delete if(@$_GET['del_id']!=''){ $delquery="DELETE FROM radiotype WHERE each_id='".@$_GET['del_id']."'"; $rundel=mysqli_query($con,$delquery); if($rundel){ echo '<div class="alert alert-success text-center"> delete success</div>'; } } //2 insert if(isset($_POST['each_id'])){ // if(isset($_POST['submit'])){ if($_POST['each_id']==""){ // print_r($_POST); $EACH = @$_POST['EACH']; $insQuery="INSERT INTO radiotype (take_one) VALUES('$EACH')"; // echo $insQuery; die(); $Runins= mysqli_query($con,$insQuery); if($Runins){ echo '<div class="alert alert-success text-center"> insert success</div>'; }else{ echo '<div class=alert alert-danger> not uploaded</div>';}}} // 5 update if(@$_POST['each_id']!=''){ // $EACH = @$_POST['EACH']; // $upQuery="UPDATE INTO radiotype SET take_one='$EACH' WHERE each_id ='".@$_GET['each_id']."'"; $upQuery="UPDATE radiotype SET take_one ='".@$_POST['EACH']."' WHERE each_id = '".@$_POST['each_id']."' "; // echo $upQuery; die(); $runupdateQ = mysqli_query($con,$upQuery); if($runupdateQ){ echo '<div class="alert alert-success text-center"> update success</div>'; }else{ echo '<div class="alert alert-success text-center"> update success</div>';}} //fetcch data for updation if(@$_GET['uid']!=''){ $editQuery= "SELECT *FROM radiotype WHERE each_id ='".@$_GET['uid']."'"; $runEditQ= mysqli_query($con,$editQuery); $editData= mysqli_fetch_assoc($runEditQ); // print_r($editData) ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>RADIO TYPE INSERT IN PHP</title> <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> <legend class=" text-center">SELECT ONE INSERT IN PHP:</legend><center><div><div> <input type="hidden" name="each_id" value="<?php echo @$_GET['uid'] ?>" /> <input type="radio" name="EACH" value="HTML" <?php if('HTML'==@$editData['take_one']) echo 'checked="checked"'; ?> /> <label for="huey">HTML</label></div><div> <input type="radio" name="EACH" value="CSS" <?php if('CSS'==@$editData['take_one']) echo 'checked="checked"'; ?> /><label>CSS</label> </div><div> <input type="radio" name="EACH" value="LARAVEL" <?php if('LARAVEL'==@$editData['take_one']) echo 'checked="checked"'; ?> /> <label>LARAVEL</label></div> <input type="submit" name="SUBMIT" value="Submit" /></center></div></fieldset> </form> <table style="width: 100%;" border="1"> <thead> <tr><th>SR</th> <th>RADIO</th><th>OPERATION</th></tr> </thead><tbody> <?php //select query for fetching data frim databas $Disdata= "SELECT* FROM radiotype"; $RunDisdata=mysqli_query($con,$Disdata); if(mysqli_fetch_row($RunDisdata)>0){ // echo 'Row found'; $abc=1; foreach($RunDisdata as $key=> $value) {?><tr><td><?php echo $abc++ ?></td> <td><?php echo $value['take_one']?></td> <td><a href="index.php?uid=<?php echo $value['each_id'] ?>" class="btn btn-primary">Edit</a> <a href="index.php?del_id=<?php echo $value['each_id'] ?>" class="btn btn-danger">Delete</a> </td></tr> <?php } }else{ ?><?php echo ' <tr><td colsapn="10">ROW NOT FOUND</td></tr> '; }?> </tbody> </table></body></html>
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