TechBugie

Saturday 3 December 2016

validation process database connection and sql operation .

<?php
$servername = "localhost";
$username = "root";
$password = "";

try {
    $conn = new PDO("mysql:host=$servername;dbname=login", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
   // echo "Connected successfully";
    }
catch(PDOException $e)
    {
    echo "Connection failed: " . $e->getMessage();
    }
    ?>
    <?php
$username1=$_REQUEST['username'];
$useremail=$_REQUEST['useremail'];
$params=array($username1,$useremail);
$result=$conn->prepare("select * from userdata where user_name=? and user_email=?");
$result->execute($params);
$res=$result->fetchAll();
if($res)
{
    echo json_encode(array('success'=>true));
    //echo "valied user";
}
else
{
    echo json_encode(array('success'=>false));
    //echo "in valied user name and email";
}

?>

user name and email validation .html page and jquery script

<html>
<body>
<head>
<script src="//code.jquery.com/jquery-1.11.2.min.js"></script>
User Longin
</head>
<div id="error" ></div>
<style>
#error{
color:red;
text-align:center;
}
</style>
<form action="userdata.php" id="savedata" method="post"/>
<lable>user name :</lable>
<input type="text" name="username" id="username" /><br>
<lable>user email :</lable>
<input type="text" name="useremail" id="useremail" /><br>
<input type="submit" value="submit" />

<script>
$(function(){
$('#savedata').on('submit',function(e){
        e.preventDefault();
    var fields = $( "form" ).serializeArray();
    $.each( fields, function() {
        if(this.value=="")
            {
            $("#error").empty();
            $("#error").append("Enter User Name: " + this.name + "columns");
            }
            else
            {
                $("#error").empty();
                return true;
            }

        });

    $.ajax({
            type:"POST",
            url:'userdata.php',
            data:$("form").serializeArray(),
            datatype:'json',
            encode:true,
            success:function(data){
                var result=eval('('+data+')');
                if(result.success==true)
                {
                    $("#error").append("valid user");
                }
                else
                {

                    $("#error").append("in valid user");
                }
            }
        });

    });
});

</script>
</body>
</html>

Monday 17 October 2016

File Upload - JQuery Ajax Submission

HTML


<form class="user_event" id="user_events" name="user_events">
 <div class="form-group">
  <label for="name">Event Pamphlet Samples :</label><br><label class="control-label">Select File</label>
  <input id="file" type="file" name="my_name[]"/>
 </div>
 <div class="form-group">
  <button type="submit" class="btn btn-primary pull-right" id="submit">submit</button>
  </div>
 </form>

JQUERY CODE

       
<script>
$(function(){
 $("#user_events").submit(function(event){
 event.preventDefault();
 var value = CKEDITOR.instances['editor1'].getData();
 var formData = new FormData($(this)[0]);
 formData.append('editor1',value);
 $.ajax({
  url:'event_details.php',
      data: formData,
  async: false,
  cache: false,
  contentType: false,
  processData: false,
  type:'POST',
  success:function(result)
  {
   var res=eval('('+result+')');
   $("#display").html("");
   if(res.success==true)
   {
     $( "#display" ).append( "<div><strong>Success</strong></div>" );
   }
   else
   {
    $( "#display" ).append( "<div><strong>Faild</strong></div>" );
   }
  },
  error:function(e)
  {
   console.log(e.message);
  }

 });
});
});
</script>

FORM SUBMISSION

       

<?php
$efile_name=$_FILES['my_name']['name'][0];
$efile_type=$_FILES['my_name']['type'][0];
$efile_temp=$_FILES['my_name']['tmp_name'][0];
$efile_size=$_FILES['my_name']['size'][0];
$file_exe=strtolower(end(explode('.', $_FILES['my_name']['name'][0])));
$file_ty=array("jpg","jpeg","png");
if(in_array($file_exe,$file_ty===false))
{
 $err[]="please select correct file";
}
if($efile_size>1024000)
{
 $err[]="please select minimum size file";
}
if(empty($err==true))
{
 if(move_uploaded_file($efile_temp,"upload/$efile_name"))
  echo json_encode(array('success'=>true,'msg'=>"Success to upload"));
 else
  echo json_encode(array('success'=>false,'msg'=>"Failed to upload"));
}

hi

welcome to techbugie..