Angular2 crud example

app.module.ts

 import { BrowserModule } from '@angular/platform-browser';  
 import { NgModule } from '@angular/core';  
 import { FormsModule } from '@angular/forms';  
 import { RouterModule } from '@angular/router';  
 import { HttpModule } from '@angular/http';  
 import { AppComponent } from './app.component';  
 import { staffComponent } from './staff/staff.component';  
 import { staffService } from "./services/staff.service";  
 import { AddstaffComponent } from './addstaff/addstaff.component';  
 import { EditstaffComponent } from './editstaff/editstaff.component';  
 @NgModule({  
  declarations: [  
   AppComponent,  
   staffComponent,  
   AddstaffComponent,  
   EditstaffComponent,  
  ],  
  imports: [  
   BrowserModule,  
   FormsModule,  
   HttpModule,  
   RouterModule.forRoot([  
   { path: "staff", component: staffComponent },  
   { path: "add_staff", component: AddstaffComponent },  
   { path: "edit_staff/:id", component: EditstaffComponent }]  
  )  
  ],  
  providers: [staffService],  
  bootstrap: [AppComponent]  
 })  
 export class AppModule { }  

staff.service.ts

 import { Inject, Injectable } from '@angular/core';  
 import { Http } from '@angular/http';  
 @Injectable()  
 export class staffService{  
 private staff: Array<any>  
   constructor(private http:Http){  
   }  
   getStaff(){  
   return this.http.get('http://127.0.0.1:8000/api/get_staff').map(data=>{  
     return data.json();  
   })  
        }  
    getStaffbyId(id){  
   return this.http.get('http://127.0.0.1:8000/api/get_staffbyid?id='+id).map(data=>{  
     return data.json();  
   })  
        }  
    registerData(payLoad){  
      return this.http.post('http://127.0.0.1:8000/api/add_staff',payLoad).map(data=>{  
     return data.json();  
    })  
              }   
    updateData(id){  
      return this.http.post('http://127.0.0.1:8000/api/staff_update',id).map(data=>{  
        return data.json();  
      })  
    }  

staff.component.ts

 import { Component } from '@angular/core';  
 import { staffService } from '../services/staff.service'; 
import { NgIf } from '@angular/common'; 
 @Component({  
 selector:'<staff-list></staff-list>',    
 templateUrl:'./staff.component.html'  
 })  
 export class staffComponent {  
 private staff: any[];  
     ngOnInit() {  
        }  
   constructor(private staffSvc:staffService){  
     this.getStaff();   
   }  
   getStaff(){  
      return this.staffSvc.getStaff()  
      .subscribe(result=>{  
        this.staff=result.staff;  
      })    
     }    
 }  

staff.component.html

 <table class="table table-hover">  
  <thead>  
   <th>Id</th>  
   <th>Title</th>  
   <th>Arabic Title</th>  
   <th>Status</th>  
   <th>Action</th>  
   <th class="btn btn-primary"><a routerLink="/add_staff">Add</a></th>  
  </thead>  
   <tbody>  
    <tr *ngFor="let s of staff">  
     <td>{{s.id}}</td>  
     <td>{{s.title}}</td>  
     <td>{{s.ar_title}}</td>  
     <td *ngIf="s.status==1">Active</td>  
     <td *ngIf="s.status!=1">DeActive</td>  
     <td>  
      <a routerLink="/edit_staff/{{s.id}}" class="btn btn-primary">Edit</a>  
       
     </td>  
    </tr>  
   </tbody>  
 </table>  

addstaff.component.ts:

 import { Component, OnInit } from '@angular/core';  
 import { Router } from '@angular/router';  
 import { staffService } from '../services/staff.service';  
 @Component({  
  selector: 'app-addstaff',  
  templateUrl: './addstaff.component.html',  
  styleUrls: ['./addstaff.component.css']  
 })  
 export class AddstaffComponent implements OnInit {  
   private staff: any ={  
    "first_name":'',  
      "last_name":'',  
      "ar_first_name":'',  
      "ar_last_name":''  
   }  
   private staffList : any = [];  
  constructor( private router: Router,private staffSvc:staffService) {  
   }  
  ngOnInit() {  
  }  
  registerData(){  
   console.log(this.staff);  
   this.staffSvc.registerData(this.staff).subscribe(result=>{   
    console.log(result);  
   }  
   )  
  }  
 }  

addstaff.component.html

 <div class="form-horizontal">  
                <div class="close"> </div>  
                          <div class="head">  
                          </div>  
                          <div class="head-info">  
                               <h1>Add Staff</h1>  
                          </div>  
      <div class="form-group">  
       <label class="control-label col-sm-2" >First Name:</label>  
       <div class="col-sm-4">  
       <input type="text" class="form-control"     [(ngModel)]="staff.first_name" placeholder="Enter First Name">  
       </div>          
      </div>  
      <div class="form-group">  
       <label class="control-label col-sm-2" >First Name(Arabic):</label>  
       <div class="col-sm-4">  
       <input type="text" class="form-control"     [(ngModel)]="staff.ar_first_name" placeholder="Enter First Name in Arabic">  
       </div>  
      </div>  
      <div class="form-group">  
       <label class="control-label col-sm-2" >Last Name:</label>  
       <div class="col-sm-4">  
       <input type="text" class="form-control"     [(ngModel)]="staff.last_name" placeholder="Enter Last Name">  
       </div>  
      </div>  
       <div class="form-group">  
       <label class="control-label col-sm-2" >Last Name(Arabic):</label>  
       <div class="col-sm-4">  
       <input type="text" class="form-control"     [(ngModel)]="staff.ar_last_name" placeholder="Enter Last Name in Arabic">  
       </div>  
      </div>  
                          <div class="form-group">   
       <div class="col-sm-offset-2 col-sm-4">  
        <button class="btn btn-primary" (click)="registerData()">Add</button>  
       </div>  
       <div class="col-sm-offset-2 col-sm-4">  
        <button class="btn btn-primary">Back</button>  
       </div>  
      </div>  
 </div>  

editstaff.component.ts

 import { Component, OnInit } from '@angular/core';  
 import {ActivatedRoute, Router , Params } from '@angular/router';  
 import { staffService } from '../services/staff.service';  
 import { Http } from '@angular/http';  
 @Component({  
  selector: 'app-editstaff',  
  templateUrl: './editstaff.component.html',  
  styleUrls: ['./editstaff.component.css']  
 })  
 export class EditstaffComponent implements OnInit {  
 private staff:any = {  
  "first_name":'',  
  "last_name":'',  
  "ar_first_name":'',  
  "ar_last_name":''  
          }  
 private StaffList:any ={}  
 private Params:any={};  
  constructor(private activatedRoute: ActivatedRoute,private staffSvc:staffService) {   
    let params: any = this.activatedRoute.snapshot.params;  
     this.Params = params.id;  
     this.getstaffbyId();  
  }  
  ngOnInit() {  
  }  
  getstaffbyId(){  
   return this.staffSvc.getStaffbyId(this.Params).subscribe(result=>{  
    this.staff=result.staff;  
   })  
  }  
  updateData(){  
   return this.staffSvc.updateData(this.staff).subscribe(result=>{  
    this.staff=result.staff;  
   })  
  }  
 }  

editstaff.component.html

 <div class="form-horizontal">  
                <div class="close"> </div>  
                          <div class="head">  
                          </div>  
                          <div class="head-info">  
                               <h1>Add Staff</h1>  
                          </div>  
      <div class="form-group">  
       <label class="control-label col-sm-2" >First Name:</label>  
       <div class="col-sm-4">  
       <input type="text" class="form-control"     [(ngModel)]="staff.first_name" placeholder="Enter First Name">  
       </div>  
      </div>  
      <div class="form-group">  
       <label class="control-label col-sm-2" >First Name(Arabic):</label>  
       <div class="col-sm-4">  
       <input type="text" class="form-control"     [(ngModel)]="staff.ar_first_name" placeholder="Enter First Name in Arabic">  
       </div>  
      </div>  
      <div class="form-group">  
       <label class="control-label col-sm-2" >Last Name:</label>  
       <div class="col-sm-4">  
       <input type="text" class="form-control"     [(ngModel)]="staff.last_name" placeholder="Enter Last Name">  
       </div>  
      </div>  
       <div class="form-group">  
       <label class="control-label col-sm-2" >Last Name(Arabic):</label>  
       <div class="col-sm-4">  
       <input type="text" class="form-control"     [(ngModel)]="staff.ar_last_name" placeholder="Enter Last Name in Arabic">  
       </div>  
      </div>  
                          <div class="form-group">   
       <div class="col-sm-offset-2 col-sm-4">  
        <button class="btn btn-primary" (click)="updateData()">Update</button>  
       </div>  
      </div>  
 </div>  

04:53 Share:

codeigniter email activation

 
CREATE TABLE IF NOT EXISTS `clist` (
  `sno` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(55) NOT NULL,
  `email` varchar(55) NOT NULL,
  `password` varchar(55) NOT NULL,
  `city` varchar(55) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sno`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

  autoload.php :   
 We have to change in autoload.php as follows,  
  $autoload['libraries'] = array('database','form_validation','uri');   
  $autoload['helper'] = array('html', 'form', 'url');   

register_view.php 

<style type="text/css">   
  table {   
    background:#ADDAF1;   
    border-radius:10px;   
    margin-top:95px;   
  }   
  </style>   
  <title><?php echo $title;?></title>   
  <form action="<?=base_url()?>Register/insert" name="form1" id="form1" method="post" >   
  <table width="200" border="0" align="center">   
  <tr>   
   <td>Name:</td>   
   <td><input type="text" name="name" id="name"> <font color="#FF0000"><?php echo form_error('name');?></font></td>   
  </tr>   
  <tr>   
   <td>Email:</td>   
   <td><input type="text" name="email" id="email"> <font color="#FF0000"><?php echo form_error('email');?></font></td>   
  </tr>   
  <tr>   
   <td>Password:</td>   
   <td><input type="password" name="password" id="password"> <font color="#FF0000"><?php echo form_error('password');?></font></td>   
  </tr>   
  <tr>   
   <td>City:</td>   
   <td><select name="city" id="city">   
   <option value="">Select</option>   
   <option value="bangalore">bangalore</option>   
   <option value="vijayawada">vijayawada</option>   
   </select> <font color="#FF0000"><?php echo form_error('city');?></font></td>   
  </tr>   
  <tr><td colspan="2" align="center"><input type="submit" name="submit" id="submit" value="Register"></td></tr>   
  </table>   
  </form>  
 <script src="<?=base_url()?>/assets/js/jquery-1.11.3.min.js"></script>  
 <script src="<?=base_url()?>/assets/js/bootstrap.min.js"></script>  
 <script src="<?=base_url()?>/assets/js/jquery.validate.min.js"></script>  
  
 <script src="<?=base_url()?>/assets/js/jquery-ui.js"></script>  
 <script>  
 $(function() {  
    
  });  
 (function($,W,D)  
 {  
   var JQUERY4U = {};  
   JQUERY4U.UTIL =  
   {  
     setupFormValidation: function()  
     {  
       $("#form1").validate({  
         rules: {  
                          name: {  
             required: true ,  
                            minlength:2  
                          },  
                     email: {   
                       required: true,  
                               email:true  
                          },  
                          password: {  
                               required: true,  
                               minlength:4,  
                               maxlength:10  
                          }  
                     },  
         messages: {  
                          name: {  
                               required:"<font color='red'>Please Enter Name</font>",  
                               minlength:"<font color='red'>Minimum length is 2</font>"  
                          },  
                     email: {  
                       required:"<font color='red'>Please Enter Email Id</font>",  
                               email:"<font color='red'>Please Enter Valid Email Id</font>"  
                          },  
                          password: {  
                               required:"<font color='red'>Please Enter Password </font>",  
                               minlength:"<font color='red'>Minimum length is 4 </font>",  
                               maxlength:"<font color='red'>Maximum length is 10 </font>"  
                          }  
                     },  
                     submitHandler: function(form) {  
                          form.submit();  
                     }  
                });  
     }  
   }  
   //when the dom has loaded setup form validation rules  
   $(D).ready(function($) {  
     JQUERY4U.UTIL.setupFormValidation();  
   });   
 })(jQuery, window, document);  
 </script>  

 Register.php(Controller)

<?php   
 ob_start();  
  class Register extends CI_Controller {   
    public function __construct(){   
       parent::__construct();   
       $this->load->model("Register_model");   
    }      
    public function index()   
    {   
    $this->insert();      
    }   
    public function insert()   
    {   
       $this->form_validation->set_rules('name', 'Name', 'required');   
       $this->form_validation->set_rules('email', 'Email', 'required');   
       $this->form_validation->set_rules('password', 'Password', 'required|numeric');   
       $this->form_validation->set_rules('city','City','required');   
       if ($this->form_validation->run())   
       {      
       $register=$this->Register_model->insertdata($_POST);   
       if($register){   
            $this->Register_model->Send_Email($this->input->post('email'));  
        echo "<script>alert('Please check Your Email To Activate Account...')</script>";   
         }   
       }   
       $data['title']="Registration";   
     $this->load->view('register_view',$data);      
    }   
    function verify($hash=NULL)  
   {  
     if ($this->Register_model->verifyEmailID($hash))  
     {  
       echo "<script>alert('Account Activated...')</script>";  
     }  
     else  
     {  
       echo "<script>alert('Sorry Something Went Wrong...')</script>";  
      }  
   }  
  }   
  ?>   

 Register_model.php(Model)

<?php   
     class Register_model extends CI_Model {   
    function insertdata($options = array()){   
       if(isset($options['name']))   
         $this->db->set('name',strip_tags($options['name']));   
         if(isset($options['email']))   
         $this->db->set('email',strip_tags($options['email']));   
       if(isset($options['password']))   
         $this->db->set('password',strip_tags($options['password']));   
       if(isset($options['city']))   
         $this->db->set('city',($options['city']));   
         $this->db->insert("clist");   
       return $this->db->insert_id();   
    }   
    public function Send_Email($to_email) {  
     $message = 'Hi,<br /><br />Please Verify http://www.domain.com/Register/verify/' . md5($to_email) . '<br /><br /><br />Thanks<br />Mydomain Team';  
     $this->load->library('email');  
           $this->email->from('fromemail@gmail.com', 'Codetipz');  
           $this->email->to($to_email);        
           $this->email->subject('Email Verification');  
           $this->email->message($message);       
           $this->email->send();  
    }  
    //activate user account  
   function verifyEmailID($key)  
   {  
     $data = array('status' => 1);  
     $this->db->where('md5(email)', $key);  
     return $this->db->update('clist', $data);  
   }  
  }   
  ?>   

04:22 Share:

reset password php

 CREATE TABLE IF NOT EXISTS `employee` (  
  `EMPLOYEE_ID` int(25) NOT NULL,  
  `FIRST_NAME` varchar(255) NOT NULL,  
  `LAST_NAME` varchar(255) NOT NULL,  
  `EMPLOYEE_EMAIL` varchar(255) NOT NULL,  
  `PASSWORD` varchar(50) DEFAULT NULL,  
 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;  
 CREATE TABLE IF NOT EXISTS `TOKEN` (  
  `ID` int(11) NOT NULL AUTO_INCREMENT,  
  `EMPLOYEE_EMAIL` varchar(100) NOT NULL,  
  `TOKEN` varchar(100) NOT NULL,  
  `STATUS` int(11) NOT NULL DEFAULT '0',  
  PRIMARY KEY (`ID`)  
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;  

Step1:
Create Form:

 <form method="post" name="forgot" id="forgot">  
        <!-- Modal -->  
        <div aria-hidden="true" aria-labelledby="myModalLabel" role="dialog" tabindex="-1" id="forgotPass" class="modal fade">  
          <div class="modal-dialog">  
            <div class="modal-content">  
              <div class="modal-header">  
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>  
                <h4 class="modal-title">Forgot Password ?</h4>  
              </div>  
              <div class="modal-body">  
                <p>Enter your e-mail address below to reset your password.</p>  
                <input type="text" name="email2" id="email2" placeholder="Email" autocomplete="off" class="form-control placeholder-no-fix">  
              </div>  
              <div class="modal-footer">  
                <button data-dismiss="modal" class="btn btn-default" type="button">Cancel</button>  
                                     <input type="submit" value="Send" name="send" class="btn btn-success">  
                <!-- <button class="btn btn-success" type="button">Submit</button>-->  
              </div>  
            </div>  
          </div>  
        </div>  
        <!-- modal -->  
      </form>  

Step2:

Checking Entered  Email is Existed or not  and Sent  Reset password mail if mail is already Existed

 <?php  
 $conn=mysql_connect("hostname","username","password")  
 mysql_select_db("databasename",$conn);  
 if(isset($_POST['send'])) {  
 $email=$_POST['email2'];  
  $sql="SELECT EMPLOYEE_ID,EMPLOYEE_EMAIL,PASSWORD from EMPLOYEE where EMPLOYEE_EMAIL='".$email."'";  
 $q=mysql_query($sql);       
  $p=mysql_affected_rows();  
  if($p!=0)   
   {  
   $res=mysql_fetch_array($q);  
  $to=$res['EMPLOYEE_EMAIL'];  
  $token=rand();  
 $q="insert into TOKEN (TOKEN,EMPLOYEE_EMAIL) values ('".$token."','".$email."')";  
 mysql_query($q);  
  $subject=' password Recovery';  
     $from  = 'FAD@imcrinox.com';   // give from email address   
      // mandatory headers for email message, change if you need something different in your setting.   
      $headers = "From: " . $from . "\r\n";   
      $headers .= "Reply-To: ". $from . "\r\n";   
      $headers .= "CC: arundsti@gmail.com\r\n";   
      $headers .= "MIME-Version: 1.0\r\n";   
      $headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";   
  $message = '<html><body>';  
  $message .= '<span style="color:Green;font-size:20px;"> PASSWORD RECOVERY</span> ';  
  $message .= '<table rules="all" border=1 style="border-color: green;" cellpadding="10" align="center">';  
  $message .= "<tr style='background: #eee;'><td><strong>Email:</strong> </td><td>" . strip_tags($res['EMPLOYEE_EMAIL']) . "</td></tr>";  
  $message .= "<tr><td><strong>PASSWORD:</strong> </td><td>" . "<a href='http://website.com/foldername/subfoldername/reset.php?token=$token'>ResetPassword</a>" . "</td></tr>";  
  $message .= "</table>";  
  $message .= "</body></html>";  
  $m=mail($to,$subject,$message,$headers);  
  if($m)  
       {  
        $msg='Check your mail inbox for Reset password ';  
       }  
  else  
       {  
        $msg='Email not found please signup now!!';  
       }  
   }  
    else  
  {  
  $msg='Invalid Email';  
  }  
 }   
 ?>  

Step3:
Checking mail

reset.php

 <?php session_start();  
 $token=$_GET['token'];  
 if(!isset($_POST['password'])){  
  $q="select EMPLOYEE_EMAIL from TOKEN where TOKEN='".$token."' and STATUS=0";  
 $r=mysql_query($q);  
 while($row=mysql_fetch_array($r))  
   {  
 $email=$row['EMPLOYEE_EMAIL'];  
   }  
 If ($email!=''){  
      $_SESSION['EMPLOYEE_EMAIL']=$email;  
 }  
 else die("Invalid link or Password already changed<a href='index.php'>Login here</a>");}  
 $pass=$_POST['password'];  
 $email=$_SESSION['EMPLOYEE_EMAIL'];  
 if(!isset($pass)){  
 echo '<form method="post">  
 enter your new password:<input type="password" name="password" />  
 <input type="submit" value="Change Password">  
 </form>  
 ';}  
 if(isset($_POST['password']))  
 {  
 $q="update EMPLOYEE set PASSWORD='".$pass."' where EMPLOYEE_EMAIL='".$email."'";  
 $r=mysql_query($q);  
 if($r)mysql_query("update TOKEN set STATUS=1 where TOKEN='".$token."'");  
 echo "Your password is changed successfully<a href='index.php'>Login Here</a>";  
 if(!$r)echo "An error occurred";  
      }  
      ?>  

03:17 Share:

php email verification script

This tutorial we will see how to send a activation mail after signup using php

Create table mailinsert

 CREATE TABLE IF NOT EXISTS `mailinsert` (  
  `sno` int(11) NOT NULL AUTO_INCREMENT,  
  `name` varchar(50) NOT NULL,  
  `email` varchar(50) NOT NULL,  
  `password` varchar(50) NOT NULL,  
  `city` varchar(50) NOT NULL,  
  `status` int(11) NOT NULL,  
  `code` varchar(50) NOT NULL,  
  PRIMARY KEY (`sno`)  
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;  

mailact.php

 <?php  
 $con=mysql_connect("hostname","username","password");  
 mysql_select_db("databasename",$con);  
 $name=$_POST['name'];  
 $email=$_POST['email'];  
 $password=$_POST['password'];  
 $city=$_POST['city'];  
 $status=1;  
 $code=rand();  
 if(isset($_POST['submit'])){  
  $sql="insert into mailinsert(sno,name,email,password,city,status,code)values('','$name','$email','$password','$city','$status','$code')";  
 $res=mysql_query($sql);  
 if($res)  
 {  
      echo "inserted";  
 $subject = "Email Verification - Codetipz";  
      $message = "Hi $name<br /> <br />  
      Thankyou for registration with Codetipz. Please <a href='http://yourwebsite.com/verify.php?code=$code'>Click Here to verify your Email ID</a> <br /><br />  
      Best Regards<br />  
      Justcourse  
      ";       
 $cemail="admin@codetipz.blogspot.in";  
      $headers .= 'Content-type: text/html; charset=utf-8' . "\r\n";  
                     // Additional headers  
                     $headers .= 'From: '.$cemail . "\r\n";  
                     $headers .= 'Reply-To: '.$cemail . "\r\n";  
                     $to = $email;  
                     if(mail($to, $subject, $message, $headers))  
                     {  
                     echo "<script>alert('You Have Successfully Registered, An Verification Email Sent To Your Email. Please Verify Your Email And Access Your Account')</script>";  
                     }  
 }  
 }  
 ?>  
 <style type="text/css">  
 table {  
      background:#BADCE0;  
      border-radius:10px;  
      margin-top:150px;  
 }  
 </style>  
 <form method="post" action="">  
 <table width="200" align="center">  
  <tr>  
   <td>Name</td>  
   <td><input type="text" name="name" id="name"></td>  
  </tr>  
  <tr>  
   <td>Email:</td>  
   <td><input type="text" name="email" id="email"></td>  
  </tr>  
  <tr>  
   <td>Password:</td>  
   <td><input type="password" name="password" id="password"></td>  
  </tr>  
  <tr>  
   <td>City:</td>  
   <td><select name="city" id="city">  
   <option value="">Select City</option>  
   <option value="city1">city1</option>  
   <option value="city2">city2</option>  
   <option value="city3">city3</option>  
   <option value="city4">city4</option>  
   </select>  
   </td>  
  </tr>  
  <tr>  
   <td align="center" colspan="2"><input type="submit" name="submit" id="submit" value="Register"></td>  
  </tr>  
 </table>  
 </form>  

verify.php

 <?php  
 $con=mysql_connect("hostname","username","password");  
 mysql_select_db("databasename",$con);  
 $code=$_GET['code'];  
 $sql1 = "select * from mailinsert where code = '$code'";  
       $result = mysql_query($sql1);  
       if(mysql_num_rows($result) != 0)  
       {  
 $sql="update mailinsert set status='0' where code='$code'";  
 $upd=mysql_query($sql);  
 if($upd)  
 {  
         echo "<script><alert><h3>Your Email Has Been Succssfully Verified. Please Login And Access Your Account</h3></alert></script>";  
 }  
 }  
 else  
 {  
 echo "invalid request";       
 }  
 ?>  

09:04 Share:

form validation jquery

    Show encrypted text

21:05 Share:

insert into database php

 CREATE TABLE IF NOT EXISTS `list` (  
 `sno` int(11) NOT NULL,  
  `name` varchar(50) NOT NULL,  
  `email` varchar(50) NOT NULL,  
  `password` varchar(50) NOT NULL,  
  `gender` varchar(10) NOT NULL,  
  `location` varchar(30) NOT NULL  
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;  

dbinsert.php

 <style type="text/css">  
 #register {  
      background:#9DBE78;  
      width:19.5%;  
      margin-left:15px;  
      border:groove  
 }  
 </style>  
 <script type="text/javascript" src="validation.js"></script>  
 <?php  
 $conn=mysql_connect("localhost","root","");  
 mysql_select_db("mytest",$conn);  
 @$name=$_POST['name'];  
 @$email=$_POST['email'];  
 @$password=$_POST['pwd'];  
 @$gender=$_POST['gender'];  
 @$location=$_POST['location'];  
 if(isset($_POST['register']))  
 {  
  $sql="insert into list(sno,name,email,password,gender,location) values('','$name','$email','$password','$gender','$location')";  
 $res=mysql_query($sql);  
 if($res)  
 {  
 echo "Inserted";       
 }  
 else  
 {  
 echo "Not Inserted";       
 }  
 }  
 ?>  
 <div id="register">  
 <form method="post" name="register" action="" onSubmit="return validate()">  
 <table width="200" border="0">  
  <tr>  
   <td>Name:</td>  
   <td><input type="text" name="name" id="name"></td>  
  </tr>  
  <tr>  
   <td>Email:</td>  
   <td><input type="text" name="email" id="email"></td>  
  </tr>  
  <tr>  
   <td>Password:</td>  
   <td><input type="password" name="pwd" id="pwd"></td>  
  </tr>  
  <tr>  
   <td>Gender:</td>  
   <td><input type="radio" name="gender" id="gender" value="male">Male  
   <input type="radio" name="gender" id="gender" value="female">FeMale  
   </td>  
  </tr>  
  <tr>  
   <td>Location:</td>  
   <td><select name="location" >   
   <option value="-1">Select</option>  
   <option value="delhi">Delhi</option>  
   <option value="vijayawada">Vijayawada</option>  
   <option value="bangalore">Bangalore</option>  
   </select>  
   </td>  
  </tr>  
  <tr>  
   <td colspan="2" align="center"><input type="submit" name="register" id="register" value="Insert"></td>  
  </tr>  
 </table>  
 </form>  
 </div>  

validation.js

 function validate()  
 {  
      var d=document.register;  
      if(d.name.value == "")  
      {  
      alert("Please Enter Name");  
      d.name.focus();  
      return false;       
      }  
      if(d.email.value == "")  
      {  
      alert("Please Enter Email");  
      d.email.focus();  
      return false;       
      }  
      if(d.pwd.value == "")  
      {  
      alert("Please Enter Password");  
      d.pwd.focus();  
      return false;       
      }  
      if(d.gender[0].checked == false && d.gender[1].checked == false)  
      {  
      alert("Please Select Gender");  
      return false;       
      }  
      if(d.location.value == -1)  
      {  
           alert("Please Select Location");  
           return false;  
      }  
      return true;  
 }  

Inserted data in database table:

22:26 Share:

php string length

 <?php  
 $string="Hello world,have a nice day";  
 $length=strlen($string);  
 echo "Length is".$string;  
 ?>  

10:05 Share: