How to insert data and edit data from same page and create function file
1 Create insert form in php
2 Create table for fatch data from database
3 create table in database name is movie ----- and table fields are name, length, rating, screen.
// Code for index page where insert and update operation done //
<body>
<?php
include"config.php";
$length = '';
$movie = '';
$screen = '';
$rating = '';
//echo $_POST['Submit'] ;
if(isset($_POST['editid']) and !empty($_POST['editid']))
{
$fde ="select * from movie where id ='".$_POST['editid']."'";
$update1=mysql_query($fde);
while($data1= mysql_fetch_array($update1))
{
$movie = $data1['name'];
$screen = $data1['screen'];
$length = $data1['length'];
$rating = $data1['rating'];
$updateid = $data1['id'];
}
}
?>
<div id="wrapper">
<!----->
<nav class="navbar-default navbar-static-top" role="navigation">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<h1> <a class="navbar-brand" href="index.html">Cinestar Admin </a></h1>
</div>
<div class=" border-bottom">
<div class="full-left">
<section class="full-top">
<button id="toggle"><i class="fa fa-arrows-alt"></i></button>
</section>
<form class=" navbar-left-right">
<input type="text" value="Search..." onFocus="this.value = '';" onBlur="if (this.value == '') {this.value = 'Search...';}">
<input type="submit" value="" class="fa fa-search">
</form>
<div class="clearfix"> </div>
</div>
<!-- Brand and toggle get grouped for better mobile display -->
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="drop-men" >
<ul class=" nav_1">
<li class="dropdown at-drop">
<a href="#" class="dropdown-toggle dropdown-at " data-toggle="dropdown"><i class="fa fa-globe"></i> <span class="number">5</span></a>
<ul class="dropdown-menu menu1 " role="menu">
<li><a href="#">
<div class="user-new">
<p>New user registered</p>
<span>40 seconds ago</span>
</div>
<div class="user-new-left">
<i class="fa fa-user-plus"></i>
</div>
<div class="clearfix"> </div>
</a></li>
<li><a href="#">
<div class="user-new">
<p>Someone special liked this</p>
<span>3 minutes ago</span>
</div>
<div class="user-new-left">
<i class="fa fa-heart"></i>
</div>
<div class="clearfix"> </div>
</a></li>
<li><a href="#">
<div class="user-new">
<p>John cancelled the event</p>
<span>4 hours ago</span>
</div>
<div class="user-new-left">
<i class="fa fa-times"></i>
</div>
<div class="clearfix"> </div>
</a></li>
<li><a href="#">
<div class="user-new">
<p>The server is status is stable</p>
<span>yesterday at 08:30am</span>
</div>
<div class="user-new-left">
<i class="fa fa-info"></i>
</div>
<div class="clearfix"> </div>
</a></li>
<li><a href="#">
<div class="user-new">
<p>New comments waiting approval</p>
<span>Last Week</span>
</div>
<div class="user-new-left">
<i class="fa fa-rss"></i>
</div>
<div class="clearfix"> </div>
</a></li>
<li><a href="#" class="view">View all messages</a></li>
</ul>
</li>
<?php include"include/menu.php"; ?>
</div><!-- /.navbar-collapse -->
<div class="clearfix">
</div>
<div class="navbar-default sidebar" role="navigation">
<div class="sidebar-nav navbar-collapse">
<?php include "include/sidemenu.php";?>
</div>
</div>
</nav>
<div id="page-wrapper" class="gray-bg dashbard-1">
<div class="content-main">
<!--banner-->
<div class="banner">
<h2>
<a href="index.html">Home</a>
<i class="fa fa-angle-right"></i>
<span>Movies</span>
<i class="fa fa-angle-right"></i>
<span>Current Movies</span>
</h2>
</div>
<!--//banner-->
<!--faq-->
<div class="blank">
<div class="blank-page">
<p><h3 id="forms-example" class="">Current Movies</h3> <br>
<form action="function.php" method="post" enctype="multipart/form-data">
<div class="form-group">
<label for="inputEmail3" class="col-sm-2 control-label hor-form">Movie Name</label>
<div class="col-sm-10"> <div class="input-group"><span class="input-group-addon"> <i class="fa fa-camera-retro"></i>
</span>
<input type="text" value="<?php echo $movie; ?>" id="name" name="name" class="form-control" placeholder="Movie Name" required=""></div>
</div>
</div>
<div class="form-group">
<label for="inputEmail3" class="col-sm-2 control-label hor-form">Movie Length</label>
<div class="col-sm-10"> <div class="input-group"><span class="input-group-addon"> <i class="fa fa-film "></i>
</span>
<input type="text" value=" <?php echo $length; ?>" id="length" name="length" class="form-control" placeholder="Movie Length" required=""></div>
</div>
</div>
<div class="form-group">
<label for="inputEmail3" class="col-sm-2 control-label hor-form">Movie Rating</label>
<div class="col-sm-10">
<div class="input-group"><span class="input-group-addon"> <i class="fa fa-pencil"></i>
</span> <input type="text" value="<?php echo $rating; ?>" id="rating" name="rating" class="form-control" placeholder="Movie Rating" required=""></div>
</div>
</div>
<div class="form-group">
<label for="selector1" class="col-sm-2 control-label">Screen</label>
<div class="col-sm-8"><select name="screen" value="<?php echo $screen; ?>" id="screen" class="form-control1">
<option>Screen</option>
</select></div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
<?php
if(isset($_POST['Submit']) && ($_POST['Submit']=='Edit'))
{ $value = 'Update'; } else { $value = 'Submit'; } ?>
<input type="submit" name="submit" class="btn btn-default" id="submit" placeholder="Movie Length" value="<?php echo $value; ?>" >
<input type="hidden" name="updateid" class="btn btn-default" id="updateid" value="<?php echo $updateid; ?>" >
</div>
</div>
</form>
<!--<div class="row show-grid">-->
<table width="100%" border="1">
<tr>
<td>Movie Name</td>
<td>Movie Length</td>
<td>Rating</td>
<td>Screen</td>
<td>Action</td>
</tr>
</div>
<?php
$fatch = "select * from movie";
$row=mysql_query($fatch);
while($data=mysql_fetch_array($row))
{
?>
<div class="row show-grid">
<tr>
<td><?php echo $data['name'];?></td>
<td> <?php echo $data['length'];?></td>
<td> <?php echo $data['rating'];?></td>
<td><?php echo $data['screen'];?></td>
<td> <form action="current_movies.php" method="post" name="Edit" enctype="multipart/form-data">
<input name="Submit" id="submit" type="submit" value="Edit">
<input name="editid" id="editid" type="hidden" value="<?php echo $data['id']; ?>">
</form></td>
</tr>
<?php
}
?>
</table>
<!-- Add the extra clearfix for only the required viewport
<div class="clearfix visible-xs-block"></div>
<div class="col-xs-6 col-sm-3"></div>
<div class="col-xs-6 col-sm-3"></div>
</div></p>
</div>
</div>-->
<!--//faq-->
<div class="copy">
<p> © 2016 Minimal. All Rights Reserved | Design by <a href="http://w3layouts.com/" target="_blank">W3layouts</a> </p> </div>
</div>
</div>
<div class="clearfix"> </div>
</div>
<!---->
<!--scrolling js-->
<script src="js/jquery.nicescroll.js"></script>
<script src="js/scripts.js"></script>
<!--//scrolling js-->
</body>
// Code for function.php ///
<?php
//function for add movie
print_r($_POST);
include "config.php";
if(isset($_POST['submit']) && !empty($_POST['submit']=='Submit'))
{
$sql = "insert into movie(name, length, rating, screen) values('".$_POST['name']."', '".$_POST['length']."', '".$_POST['rating']."', '".$_POST['screen']."')";
$run=mysql_query($sql);
}
if(isset($_POST['submit']) && !empty($_POST['submit']=='Update'))
{
$sql = "UPDATE `movie` SET `name` = '".$_POST['name']."', `length` = '".$_POST['length']."', `rating` = '".$_POST['rating']."', `screen` = '".$_POST['screen']."' WHERE `movie`.`id` = '".$_POST['updateid']."';";
$run=mysql_query($sql);
}
header ("location:current_movies.php");
?>
Comments
Post a Comment