Abhishek Roychoudhury

I am developing a web-app in Visual Studio code, which takes input from an user into a form and registers the values into a MYSQL database. The code is as follows:


HTML code (basically fetching the values from a form and sending them to the php script):

function submit(n,i,p,e,img){        alert(n+""+i+""+p+""+""+e+""+img);        $.ajax({            type : "POST",  //type of method            url  : "/database_registration.php",              data : { name_1 : n, email_1 : e, image : img, org_number_1: i, ph_number_1: p },            success: function(){                                                                      alert("success!!");                    }        });                }        const dForm = document.getElementById('details');              dForm.addEventListener('submit', function(e) {        e.preventDefault()        submit(nme,id,phone,email,img);    });        var arr=document.cookie.split(';')    for(var i=0; i<arr.length; i++){            var c=arr[i].split('=');        if (c[0].trim()=='name'){            var nme=c[1];            document.getElementsByName("name_1")[0].innerHTML=nme;        }        else if(c[0].trim()=='ID No'){            var id=c[1];            document.getElementsByName("org_number_1")[0].innerHTML=id;        }        else if(c[0].trim()=='Mobile No'){            var phone=c[1];            document.getElementsByName("ph_number_1")[0].innerHTML=phone;        }        else if(c[0].trim()=='Email'){            var email=c[1];            document.getElementsByName("email_1")[0].innerHTML=email;        }    }        const image = localStorage.getItem("Image");    var img=image;    document.getElementsByName("image")[0].src=image;

php script (Storing the values into a MYSQL database):

<?php    header("Access-Control-Allow-Origin: *");    header("Access-Control-Allow-Methods: GET, POST, OPTIONS");        $servername = "localhost";          $username = "root";          $password = "";        $date = date("Y-m-d");        echo 'Post variables:<br />';    print_r($_POST);        if (isset($_POST["name_1"]))        $name=$_POST['name_1'];    if (isset($_POST["org_number_1"]))        $org_number=$_POST['org_number_1'];    if (isset($_POST["ph_number_1"]))        $ph_number=$_POST['ph_number_1'];    if (isset($_POST["email_1"]))        $email=$_POST['email_1'];    if (isset($_POST["image"]))        $image=$_POST['image'];        $conn = new mysqli($servername,                  $username, $password, "Employee_information");          if ($conn->connect_error) {        die("Connection failure: "            . $conn->connect_error);    }            $sql="CREATE TABLE IF NOT EXISTS Employees(Sl_no int AUTO_INCREMENT PRIMARY KEY, Full_name varchar(30) NOT NULL,          ID_no INT(2) NOT NULL UNIQUE, Contact INT(10) NOT NULL UNIQUE, Email varchar(30) NOT NULL UNIQUE, registration_date DATE,          ID_preview blob(10M))";    $conn -> query($sql);        $stmt = $conn->prepare("INSERT INTO Employees (Full_name, ID_no, Contact, Email,                                        registration_date, ID_preview)                                        VALUES (?, ?, ?, ?, ?, ?)");    $stmt->bind_param("siissb", $name, $org_number, $ph_number, $email, $date, $image);    $stmt->execute();        if($stmt->execute())        echo "records inserted";    else        echo $stmt->error;          $stmt->close();    $conn->close();    ?>

Error:

Failed to load resource: the server responded with a status of 405 (Method not allowed)  

How do I fix this? Please help me.

Hi, I wanted to enter input from the user from a JSP page and send those inputs to a java class which will store them in a MongoDB database. Here is my code for the java class:

import com.mongodb.*; public class storage { public static void main(String args[]) { MongoClient mc=new MongoClient("localhost",27017); System.out.println("Connected successfully"); } }

I have added the MongoDB java driver 3-12.7.jar in my project build path, as you can see in the pictures given.

Now when I run the application, I get this error:

Exception in thread "main" java.lang.NoClassDefFoundError: com/mongodb/MongoClient at abhishek.storage.main(storage.java:8) Caused by: java.lang.ClassNotFoundException: com.mongodb.MongoClient at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581) at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522) ... 1 more


Why am I getting this error? I have imported all the mongoDB projects. Where am I going wrong? Please help me.