<?php

$name = $_POST["name"];
$designation=$_POST['designation'];
$company=$_POST['company'];
$email = $_POST["email"];
$mobile=$_POST['mobile'];
$workno=$_POST['workno'];
$address=$_POST['address'];
$association=$_POST['association'];
$password = $_POST["password"];
$username = $_POST["username"];
$code=intval($_POST['code']);
$id = 0;

   while($row = mysqli_fetch_array($res)){
   $id = $row['id'];
    }

    $image = $_POST['image'];



    $path = "uploads/$id.png";


    $actualpath = "http://sumitmehra.esy.es/$path";

$insertquery = mysqli_prepare($con , "INSERT INTO yoring ( name ,designation , company, email, mobile, workno, address, association, password,username,code,pic) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)");

    mysqli_stmt_bind_param($insertquery , "ssssiissssis", $name, $designation , $company, $email  ,$mobile, $workno, $address, $association, $password,$username,$code,$actualpath);
mysqli_stmt_execute($insertquery);

    file_put_contents($path,base64_decode($image));
mysqli_stmt_close($insertquery);
mysqli_close($con);