Add data into database in php mysql

Adding data into database


<?php
session_start();
include('includes/config.php');
error_reporting(1);
if(strlen($_SESSION['login'])==0)
  { 
header('location:index.php');
}
else{

if(isset($_POST['submit']))
{
$category=$_POST['category'];
$description=$_POST['description'];
$status=1;
$query=mysqli_query($con,"Insert into tblcategory(CategoryName,Description,Is_Active)values('$category','$description','$status')");     
if($query)
{
$msg="Category created";
}
else{
$error="Something went wrong. Please try again.";    
} 
}


?>












Comments

Post a Comment

Popular posts from this blog

Create table in mysql database in phpmyadmin panel

DROP TABLE IF EXISTS `tablename`; CREATE TABLE IF NOT EXISTS `tablename` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `AdminUserName` varchar(255) NOT NULL,   `AdminPassword` varchar(255) NOT NULL,   `AdminEmailId` varchar(255) NOT NULL,   `Is_Active` int(11) NOT NULL,   `CreationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,   `UpdationDate` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,   PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbladmin` -- INSERT INTO `tbladmin` (`id`, `AdminUserName`, `AdminPassword`, `AdminEmailId`, `Is_Active`, `CreationDate`, `UpdationDate`) VALUES (1, 'admin', 'password', 'admin@email.com', 1, '2019-02-10 17:51:00', '2019-02-15 08:52:44');
Read more

Flutter Scratch Card

Image
 pubspec name :  extravote description :  A new Flutter project. publish_to :  'none'   version :  1.0.0+1 environment :    sdk :  ">=2.7.0 <3.0.0" dependencies :    flutter :      sdk :  flutter    http :  ^0.12.2    cached_network_image :  ^2.5.0    webview_flutter :  ^1.0.7         cupertino_icons :  ^1.0.2        workmanager :  ^0.2.3       flutter_local_notifications :  ^1.4.4+2    scratcher :  "^1.4.0"       confetti :  ^0.5.4+1 dev_dependencies :    flutter_test :      sdk :  flutter    integration_test :      sdk :  flutter flutter :    uses-material-design :  true    assets :     -  lib/as...
Read more