MySQL & PHP References: Cordova MySQL PHP Remote Database functionalities -- SOLVED

Tuesday, October 15, 2019

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.

MySQL & PHP References

Search This Blog

Tuesday, October 15, 2019

Cordova MySQL PHP Remote Database functionalities -- SOLVED

CORDOVA -- CRUD FORM / RESULT PAGE

REMOTE CRUD PHP PAGE

HOPE YOU WILL ENJOY IT!!! PEACE-V

No comments:

Post a Comment

content-wide advt