Cordova MySQL PHP Remote Database functionalities -- SOLVED

After bang bang & kickass searches and tens of pages & trial and error -- here come simplest solution for CORDOVA - MYSQL - PHP REMOTE SERVER DATABASE CONNECTIVITY for you. Hope you dont have to PULL YOUR HAIR & GO BALD (as am already bald & getting married on 12th December 2019)

CORDOVA -- CRUD FORM / RESULT PAGE

<!DOCTYPE html> <html> <head> <!-- <meta http-equiv="Content-Security-Policy" content="default-src 'self' data: gap: https://ssl.gstatic.com 'unsafe-eval'; style-src 'self' 'unsafe-inline'; media-src *; img-src 'self' data: content:;">--> <meta name="format-detection" content="telephone=no"> <meta name="msapplication-tap-highlight" content="no"> <meta name="viewport" content="initial-scale=1, width=device-width"> <link rel="stylesheet" type="text/css" href="css/index.css"> <title>DFW Taxi App</title> <style> body { padding:40px; text-align: center;} </style> </head> <body> <h1>register now</h1> <input type="text" name="cname" id="cname" value="narendra modi" /> <input type="text" name="cphone" id="cphone" value="9848848450" /> <input type="text" name="cemailid" id="cemailid" value="namo@htmail.com" /> <button id="submit_btn">Register Now</button> <script type="text/javascript" src="cordova.js"></script> <script type="text/javascript" src="js/index.js"></script> <script type="text/javascript" src="js/jquery.js"></script> <script type="text/javascript"> $(document).ready(function(){ //updateList(); $("#submit_btn").on("click", function(){ var xname = $("#cname").val(); var xphone = $("#cphone").val(); var xemailid = $("#cemailid").val(); success: function(data){ var obj = JSON.parse(data); //console.log(data); //alert(data); // var scode = data[0]; // var uid = data[1]; // console.log(uid); // alert(uid); //alert(obj.uid); alert('Your A/c Has Been Successfully Created'); //window.localStorage.setItem('xid',obj.uid); window.location.href="index.html"; } }); }); </script> </body> </html>

REMOTE CRUD PHP PAGE

// DONT NOT FORGET -- 1st and 2nd line header("Access-Control-Allow-Origin: *"); header('Access-Control-Allow-Methods: GET, POST, PATCH, PUT,DELETE, OPTIONS'); // DONT NOT FORGET session_start(); /// NO WORRIES safe in 3rd line date_default_timezone_set("America/Mexico_City"); //data base connection $srv = 'localhost'; $usr = 'SSDFD787SD7FS'; $pwd = 'dKJFAUDIS'; $db = 'usavedmyarse'; $con = mysqli_connect($srv,$usr,$pwd,$db); if (!$con) { die('Could not connect: ' . mysqli_connect_error()); } // FUCK MAJIC --- PURE programing // manipulate the way you want // dont just give a shit -- hit it $booknow = $_POST; mysql_insert_array('usermst', $booknow,$con); // am using function to save row in mysqli table echo json_encode($booknow);

I would like to thank Code Sundar and Yogesh Sharma --- thank you nerds.

HOPE YOU WILL ENJOY IT!!! PEACE-V