Skip to main content

Posts

Showing posts from 2015

PHP CRUD Operations

Table Query ___________________________________________________________________ CREATE TABLE IF NOT EXISTS `emp` (   `id` int(11) NOT NULL,   `name` varchar(50) DEFAULT NULL,   `salary` int(11) DEFAULT NULL,   `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; config.php ________________________________________________________________________________ <?php $server = "localhost"; $user = "root"; $password = ""; $dbname = "newdb"; $conn =  new mysqli($server,$user,$password,$dbname); if($conn->connect_error) { die("connection failed:".$conn->connect_error); } ?> index.php ___________________________________________________________________ <?php include 'config.php'; ?> <html> <head> </head> <style> table, th, td  { padding: 8px;     border: 1px solid black...
Post a Comment
Read more

HTML 5 pattern validation

<!DOCTYPE html> <html> <head> <title>html5 patterns val</title> </head> <body> <form action=""> Email :   <input type="email" name="email" pattern="[a-z0-9._%+-]+@[a-z0-9.-]+\.[a-z]{2,3}$" required> Min Char:  <input type="password" name="pw" pattern="(?=.*\d)(?=.*[a-z])(?=.*[A-Z]).{8,}" title="Must contain at least one number and one uppercase and lowercase letter, and at least 8 or more characters" required> Search: <input type="search" name="search" pattern="[^'\x22]+" title="Invalid input" required> Password:   <input type="password" name="pw" pattern=".{6,}" title="Six or more characters" required> Country code: <input type="text" name="country_code" pattern="[A-Za-z]{3}" title="Three let...
1 comment
Read more

Indian Rupee Symbol in PHP or HTML

Rupee Symbol &#8377; OR  &#x20A8; 
Post a Comment
Read more

PHP Mail

<?php     if(isset($_POST['send']))    {       $name     =$_POST['name'];       $email    =$_POST['email'];       $ number    =$_POST[' number '];       $comments =$_POST['comments'];              $to="test@domain.com";                           $subject  = "Enquiry";          $message  = "<h3>Enquiry from example.com</h3>";          $message .= "<h4>Name        : $name</h4>";          $message .= "<h4>Email       : $email</h4>";          $message .= "<h4>Contact No  : $contact</h4>";          $message .= "<h4>Comments ...
Post a Comment
Read more

send a id by GET method

db.php _________________________________________________________________ <?php  $query=mysql_query("INSERT INTO employee VALUES ('$id','$name')"); if($query)  {      header('location:index.php?msg'); }?> _________________________________________________________________ index.php _________________________________________________________________ <?php if(isset($_GET['msg'])) {  $comp = $_GET['msg']; ?>     <div class="alert alert-success">           Thank you, this is message by GET id      </div> <?php } ?> _________________________________________________________________
Post a Comment
Read more

session to send a text or data

db.php _____________________________________________________ <?php  $query=mysql_query("INSERT INTO employee VALUES ('$id','$name')"); if($query)  {      $_SESSION['msg']="inserted successfully";      header('location:index.php'); }?> _____________________________________________________ index.php _____________________________________________________ <?php if (isset($_SESSION['msg'])) { ?>       <div class="alert alert-info">            <?php echo $_SESSION['msg'];?>       </div> <?php unset($_SESSION['msg']);   }  ?> _____________________________________________________
Post a Comment
Read more

typeahead static auto suggest

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Typeahead</title> <script  type="text/javascript" src="jquery.min.js"></script> <script  type="text/javascript" src="typeahead.js"></script> <script type="text/javascript"> $(document).ready(function(){ $('input.typeahead').typeahead({ name: 'accounts', local: ["Bangalore","Bidar","Ganagapur","Gulbarga","Raichur"] }); });   </script> <style type="text/css"> .bs-example{ font-family: sans-serif; position: relative; margin: 100px; } .typeahead, .my-query, .my-hint { border: 1px solid #CCCCCC; border-radius: 8px; font-size: 18px; height: px; line-height: 20px; outline: medium none; padding: 8px 12px; width: 240px; } .typeahead { background-color...
Post a Comment
Read more

auto hide div

<script type="text/javascript">     setTimeout(function() {     $('#msg').fadeOut('fast');     }, 4000); //four seconds </script>  _______________________________________________ <div id="msg"> This alert div auto hide in 4 seconds </div>
Post a Comment
Read more

Page loader

<html> <head> <style> .no-js #loader { display: none;  } .js #loader { display: block; position: absolute; left: 100px; top: 0; } .preload { position: fixed; left: 0px; top: 0px; width: 100%; height: 100%; z-index: 9999; background: url(load.gif) center no-repeat #fff; } </style> </head> <body> <div class="preload"></div> <script src="js/jquery.min.js"></script> <script type="text/javascript"> //paste this code under head tag or in a seperate js file. // Wait for window load $(window).load(function() { // Animate loader off screen $(". preload ").fadeOut("slow");; }); </script> </body> </html>
Post a Comment
Read more

Onload Popup in HTML

<html> <head>     <link rel="stylesheet" href="css/bootstrap.css" type="text/css" media="screen" /> </head> <body>   <div class="modal fade" id="myModal" style="padding-top:50px;">     <div class="modal-dialog" >         <div class="modal-content">              <div class="modal-header">                 <button type="button" class="close" data-dismiss="modal">&times;</button>                 <h3><span>Description:</span></h3>              </div>              <div class="modal-body" id="myModal" align="center">                 <p>Lorem Ipsum is simply dummy text of the printing and typesetting indus...
Post a Comment
Read more

transparent css

body {   font-family: 'Open Sans', sans-serif;   font-size: 14px;   line-height: 45px;   /*color: #666;*/   color: black;   background-color: #fff; } :hover {   text-decoration: none;   outline: none } .form-control {   background-color: transparent;   border-color: black;   height: 50px;   border-radius: 0;   box-shadow: none; } textarea.form-control {   min-height: 180px;   resize:none; } .form-group {   margin-bottom: 30px; } .contact-info {   padding-left:70px;   font-weight: 300; } ul.address {   margin-top: 30px;   list-style: none;   padding: 0;   margin: 0; } .btn-submit {   display: block;   padding: 12px;   width: 100%;   background:transparent;   color: #4985C6;   border:1px solid black;   margin-top: 40px; } .btn-submit:hover {   display: block;   padding: 12px; ...
Post a Comment
Read more