{"id":1753,"date":"2019-04-13T12:29:26","date_gmt":"2019-04-13T04:29:26","guid":{"rendered":"http:\/\/people.utm.my\/ajune\/?p=1753"},"modified":"2019-04-13T12:52:24","modified_gmt":"2019-04-13T04:52:24","slug":"writing-php-mysql-phonegap","status":"publish","type":"post","link":"https:\/\/people.utm.my\/ajune\/2019\/04\/13\/writing-php-mysql-phonegap\/","title":{"rendered":"PhoneGap\u00a0PHP MySQL example"},"content":{"rendered":"

Step By Step Guide:<\/strong><\/h4>\n
    \n
  1. MySQL Database Creation<\/li>\n
  2. Writing PHP code for Serverside<\/strong><\/li>\n
  3. Writing Jquery code for PhoneGap \/ Apache Cordova side<\/strong><\/li>\n<\/ol>\n

    1. Connecting Database Server (db.php<\/code>)<\/strong><\/h4>\n
    <?php<\/span>\r\n header<\/span>(<\/span>\"Access-Control-Allow-Origin: *\"<\/span>)<\/span>;<\/span>\r\n $con<\/span> =<\/span> mysqli_connect<\/span>(<\/span>\"localhost\"<\/span>,<\/span>\"root\"<\/span>,<\/span>\"\"<\/span>,<\/span>\"test\"<\/span>)<\/span> or<\/span> die<\/span> (<\/span>\"could not connect database\"<\/span>)<\/span>;<\/span>\r\n?><\/span><\/span><\/code><\/pre>\n
    NOTE<\/p>\n
    header(\"Access-Control-Allow-Origin: *\");<\/code>\u00a0use to allow cross domains<\/p>\n
    2. Insert data into MySQL database using PHP (insert.php<\/code>)<\/strong><\/h4>\n
    This code will receive data from the mobile \u00a0\/ PhoneGap Apache Cordova using\u00a0POST<\/code>\u00a0method & It\u2019ll insert data to MySQL, If it is successful it will return\u00a0ok<\/code>\u00a0as output otherwise\u00a0error<\/code>\u00a0as output<\/p>\n
    <?php<\/span>\r\n include<\/span> \"db.php\"<\/span>;<\/span>\r\n if<\/span>(<\/span>isset<\/span>(<\/span>$_POST<\/span>[<\/span>'insert'<\/span>]<\/span>)<\/span>)<\/span>\r\n {<\/span>\r\n $title<\/span>=<\/span>$_POST<\/span>[<\/span>'title'<\/span>]<\/span>;<\/span>\r\n $duration<\/span>=<\/span>$_POST<\/span>[<\/span>'duration'<\/span>]<\/span>;<\/span>\r\n $price<\/span>=<\/span>$_POST<\/span>[<\/span>'price'<\/span>]<\/span>;<\/span>\r\n $q<\/span>=<\/span>mysqli_query<\/span>(<\/span>$con<\/span>,<\/span>\"INSERT INTO `course_details` (`title`,`duration`,`price`) VALUES ('$title','$duration','$price')\"<\/span>)<\/span>;<\/span>\r\n if<\/span>(<\/span>$q<\/span>)<\/span>\r\n  echo<\/span> \"success\"<\/span>;<\/span>\r\n else<\/span>\r\n  echo<\/span> \"error\"<\/span>;<\/span>\r\n }<\/span>\r\n ?><\/span><\/span><\/code><\/pre>\n
    3.Update Database using PHP (update.php<\/code>)<\/h4>\n
    This code will receive data from the mobile \u00a0\/ PhoneGap \/ Apache Cordova using\u00a0POST<\/code>\u00a0method & It\u2019ll Update data to MySQL with respect to course_id, If it is successful it will return\u00a0ok<\/code>\u00a0as output otherwise\u00a0error<\/code>\u00a0as output<\/p>\n
    <?php<\/span>\r\n include<\/span> \"db.php\"<\/span>;<\/span>\r\n if<\/span>(<\/span>isset<\/span>(<\/span>$_POST<\/span>[<\/span>'update'<\/span>]<\/span>)<\/span>)<\/span>\r\n {<\/span>\r\n $id<\/span>=<\/span>$_POST<\/span>[<\/span>'id'<\/span>]<\/span>;<\/span>\r\n $title<\/span>=<\/span>$_POST<\/span>[<\/span>'title'<\/span>]<\/span>;<\/span>\r\n $duration<\/span>=<\/span>$_POST<\/span>[<\/span>'duration'<\/span>]<\/span>;<\/span>\r\n $price<\/span>=<\/span>$_POST<\/span>[<\/span>'price'<\/span>]<\/span>;<\/span>\r\n $q<\/span>=<\/span>mysqli_query<\/span>(<\/span>$con<\/span>,<\/span>\"UPDATE `course_details` SET `title`='$title',`duration`='$duration',`price`='$price' where `id`='$id'\"<\/span>)<\/span>;<\/span>\r\n if<\/span>(<\/span>$q<\/span>)<\/span>\r\n echo<\/span> \"success\"<\/span>;<\/span>\r\n else<\/span>\r\n echo<\/span> \"error\"<\/span>;<\/span>\r\n }<\/span>\r\n ?><\/span><\/span><\/code><\/pre>\n
    4. Delete data from Database using PHP (delete.php<\/code>)<\/strong><\/h4>\n
    This code will receive data from the mobile \u00a0\/ PhoneGap \/ Apache Cordova using\u00a0POST<\/code>\u00a0method & It\u2019ll delete data to MySQL with respect to course_id, If it is successful it will return\u00a0ok<\/code>\u00a0as output otherwise\u00a0error<\/code>\u00a0as output<\/p>\n
    <?php<\/span>\r\n include<\/span> \"db.php\"<\/span>;<\/span>\r\n if<\/span>(<\/span>isset<\/span>(<\/span>$_GET<\/span>[<\/span>'id'<\/span>]<\/span>)<\/span>)<\/span>\r\n {<\/span>\r\n $id<\/span>=<\/span>$_GET<\/span>[<\/span>'id'<\/span>]<\/span>;<\/span>\r\n $q<\/span>=<\/span>mysqli_query<\/span>(<\/span>$con<\/span>,<\/span>\"delete from `course_details` where `id`='$id'\"<\/span>)<\/span>;<\/span>\r\n if<\/span>(<\/span>$q<\/span>)<\/span>\r\n echo<\/span> \"success\"<\/span>;<\/span>\r\n else<\/span>\r\n echo<\/span> \"error\"<\/span>;<\/span>\r\n }<\/span>\r\n ?><\/span><\/span><\/code><\/pre>\n
    5. Displaying Data using JSON (json.php<\/code>)<\/strong><\/h4>\n
    For displaying data from MySQL database to Phonegap \/ Apache Cordova, we need to create json based output. we can display JSON data to phonegap using Jquery getJSON or AJAX method.<\/p>\n
    <?php<\/span>\r\ninclude<\/span> \"db.php\"<\/span>;<\/span>\r\n$data<\/span>=<\/span>array<\/span>(<\/span>)<\/span>;<\/span>\r\n$q<\/span>=<\/span>mysqli_query<\/span>(<\/span>$con<\/span>,<\/span>\"select * from course_details\"<\/span>)<\/span>;<\/span>\r\nwhile<\/span> (<\/span>$row<\/span>=<\/span>mysqli_fetch_object<\/span>(<\/span>$q<\/span>)<\/span>)<\/span>{<\/span>\r\n $data<\/span>[<\/span>]<\/span>=<\/span>$row<\/span>;<\/span>\r\n}<\/span>\r\necho<\/span> json_encode<\/span>(<\/span>$data<\/span>)<\/span>;<\/span>\r\n?><\/span><\/span><\/code><\/pre>\n
    Writing Jquery code for PhoneGap \/ Apache Cordova Side<\/b><\/h3>\n
    1. Insert data using Phonegap \/ Apache Cordova (insert.html<\/code>) | jquery.js<\/a><\/strong><\/h4>\n
    <<\/span>html><\/span><\/span><\/span>\r\n<<\/span>head><\/span><\/span><\/span>\r\n <<\/span>link rel<\/span>=<\/span>\"<\/span>stylesheet\"<\/span><\/span> type<\/span>=<\/span>\"<\/span>text\/css\"<\/span><\/span> href<\/span>=<\/span>\"<\/span>css\/ionic.css\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>script type<\/span>=<\/span>\"<\/span>text\/javascript\"<\/span><\/span> src<\/span>=<\/span>\"<\/span>js\/jquery.js\"<\/span><\/span>><\/span><\/span><\/span><\/<\/span>script><\/span><\/span><\/span>\r\n <<\/span>script type<\/span>=<\/span>\"<\/span>text\/javascript\"<\/span><\/span>><\/span><\/span><\/span>\r\n $(<\/span>document)<\/span>.<\/span>ready<\/span>(<\/span>function<\/span>(<\/span>)<\/span>\r\n {<\/span>\r\n $(<\/span>\"#insert\"<\/span>)<\/span>.<\/span>click<\/span>(<\/span>function<\/span>(<\/span>)<\/span>{<\/span>\r\n var<\/span> title=<\/span>$(<\/span>\"#title\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>)<\/span>;<\/span>\r\n var<\/span> duration=<\/span>$(<\/span>\"#duration\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>)<\/span>;<\/span>\r\n var<\/span> price=<\/span>$(<\/span>\"#price\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>)<\/span>;<\/span>\r\n var<\/span> dataString=<\/span>\"title=\"<\/span>+<\/span>title+<\/span>\"&duration=\"<\/span>+<\/span>duration+<\/span>\"&price=\"<\/span>+<\/span>price+<\/span>\"&insert=\"<\/span>;<\/span>\r\n if<\/span>(<\/span>$.<\/span>trim<\/span>(<\/span>title)<\/span>.<\/span>length><\/span>0<\/span> &<\/span> $.<\/span>trim<\/span>(<\/span>duration)<\/span>.<\/span>length><\/span>0<\/span> &<\/span> $.<\/span>trim<\/span>(<\/span>price)<\/span>.<\/span>length><\/span>0<\/span>)<\/span>\r\n {<\/span>\r\n $.<\/span>ajax<\/span>(<\/span>{<\/span>\r\n type:<\/span> \"POST\"<\/span>,<\/span>\r\n url:<\/span>\"http:<\/span>\/\/localhost\/payment\/insert.php\",<\/span>\r\n data:<\/span> dataString,<\/span>\r\n crossDomain:<\/span> true<\/span>,<\/span>\r\n cache:<\/span> false<\/span>,<\/span>\r\n beforeSend:<\/span> function<\/span>(<\/span>)<\/span>{<\/span> $(<\/span>\"#insert\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>'Connecting...'<\/span>)<\/span>;<\/span>}<\/span>,<\/span>\r\n success:<\/span> function<\/span>(<\/span>data)<\/span>{<\/span>\r\n if<\/span>(<\/span>data==<\/span>\"success\"<\/span>)<\/span>\r\n {<\/span>\r\n alert<\/span>(<\/span>\"inserted\"<\/span>)<\/span>;<\/span>\r\n $(<\/span>\"#insert\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>'submit'<\/span>)<\/span>;<\/span>\r\n }<\/span>\r\n else<\/span> if<\/span>(<\/span>data==<\/span>\"error\"<\/span>)<\/span>\r\n {<\/span>\r\n alert<\/span>(<\/span>\"error\"<\/span>)<\/span>;<\/span>\r\n }<\/span>\r\n }<\/span>\r\n }<\/span>)<\/span>;<\/span>\r\n }<\/span>return<\/span> false<\/span>;<\/span>\r\n }<\/span>)<\/span>;<\/span>\r\n }<\/span>)<\/span>;<\/span>\r\n <\/<\/span>script><\/span><\/span><\/span>\r\n<\/<\/span>head><\/span><\/span><\/span>\r\n<<\/span>body><\/span><\/span><\/span>\r\n <<\/span>div class<\/span>=<\/span>\"<\/span>bar bar-header bar-positive\"<\/span><\/span> style<\/span>=\"<\/span>margin-bottom<\/span>:<\/span>80<\/span>px;<\/span><\/span>\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>h1 class<\/span>=<\/span>\"<\/span>title\"<\/span><\/span>><\/span><\/span><\/span>Insert Database<\/<\/span>h1><\/span><\/span><\/span>\r\n <<\/span>a class<\/span>=<\/span>\"<\/span>button button-clear\"<\/span><\/span> href<\/span>=<\/span>\"<\/span>readjson.html\"<\/span><\/span>><\/span><\/span><\/span>Read JSON<\/span><\/<\/span>a><\/span><\/span><\/span>\r\n <\/<\/span>div><\/span><\/span><\/span><<\/span>br\/><\/span><\/span><\/span><<\/span>br\/><\/span><\/span><\/span>\r\n <<\/span>div class<\/span>=<\/span>\"<\/span>list\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>input type<\/span>=<\/span>\"<\/span>hidden\"<\/span><\/span> id<\/span>=<\/span>\"<\/span>id\"<\/span><\/span> value<\/span>=<\/span>\"<\/span>\"<\/span><\/span>\/><\/span><\/span><\/span>\r\n <<\/span>div class<\/span>=<\/span>\"<\/span>item\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>label><\/span><\/span><\/span>Title<\/<\/span>label><\/span><\/span><\/span>\r\n <<\/span>input type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> id<\/span>=<\/span>\"<\/span>title\"<\/span><\/span> value<\/span>=<\/span>\"<\/span>\"<\/span><\/span>\/><\/span><\/span><\/span>\r\n <\/<\/span>div><\/span><\/span><\/span>\r\n <<\/span>div class<\/span>=<\/span>\"<\/span>item\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>label><\/span><\/span><\/span>Duration<\/<\/span>label><\/span><\/span><\/span>\r\n <<\/span>input type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> id<\/span>=<\/span>\"<\/span>duration\"<\/span><\/span> value<\/span>=<\/span>\"<\/span>\"<\/span><\/span>\/><\/span><\/span><\/span>\r\n <\/<\/span>div><\/span><\/span><\/span>\r\n <<\/span>div class<\/span>=<\/span>\"<\/span>item\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>label><\/span><\/span><\/span>Price<\/<\/span>label><\/span><\/span><\/span>\r\n <<\/span>input type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> id<\/span>=<\/span>\"<\/span>price\"<\/span><\/span> value<\/span>=<\/span>\"<\/span>\"<\/span><\/span>\/><\/span><\/span><\/span>\r\n <\/<\/span>div><\/span><\/span><\/span>\r\n <<\/span>div class<\/span>=<\/span>\"<\/span>item\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>input type<\/span>=<\/span>\"<\/span>button\"<\/span><\/span> id<\/span>=<\/span>\"<\/span>insert\"<\/span><\/span> class<\/span>=<\/span>\"<\/span>button button-block\"<\/span><\/span> value<\/span>=<\/span>\"<\/span>Insert\"<\/span><\/span>\/><\/span><\/span><\/span>\r\n <\/<\/span>div><\/span><\/span><\/span>\r\n <\/<\/span>div><\/span><\/span><\/span>\r\n<\/<\/span>body><\/span><\/span><\/span>\r\n<\/<\/span>html><\/span><\/span><\/span><\/code><\/pre>\n
    2. Display \/ Reading JSON data using PhoneGap \/ Apache Cordova (readjson.html<\/code>)<\/strong><\/h4>\n
    It\u2019ll display list the data from the server as a\u00a0link. when you click the link, it\u2019ll redirect you to form.html. you can update data from form.html<\/p>\n
    <<\/span>html><\/span><\/span><\/span>\r\n<<\/span>head><\/span><\/span><\/span>\r\n <<\/span>link rel<\/span>=<\/span>\"<\/span>stylesheet\"<\/span><\/span> type<\/span>=<\/span>\"<\/span>text\/css\"<\/span><\/span> href<\/span>=<\/span>\"<\/span>css\/ionic.css\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>script type<\/span>=<\/span>\"<\/span>text\/javascript\"<\/span><\/span> src<\/span>=<\/span>\"<\/span>js\/jquery.js\"<\/span><\/span>><\/span><\/span><\/span><\/<\/span>script><\/span><\/span><\/span>\r\n <<\/span>script type<\/span>=<\/span>\"<\/span>text\/javascript\"<\/span><\/span>><\/span><\/span><\/span>\r\n $(<\/span>document)<\/span>.<\/span>ready<\/span>(<\/span>function<\/span>(<\/span>)<\/span>\r\n {<\/span>\r\n var<\/span> url=<\/span>\"http:<\/span>\/\/localhost\/payment\/json.php\";<\/span>\r\n $.<\/span>getJSON<\/span>(<\/span>url,<\/span>function<\/span>(<\/span>result)<\/span>{<\/span>\r\n console.<\/span>log<\/span>(<\/span>result)<\/span>;<\/span>\r\n $.<\/span>each<\/span>(<\/span>result,<\/span> function<\/span>(<\/span>i,<\/span> field)<\/span>{<\/span>\r\n var<\/span> id=<\/span>field.<\/span>id;<\/span>\r\n var<\/span> title=<\/span>field.<\/span>title;<\/span>\r\n var<\/span> duration=<\/span>field.<\/span>duration;<\/span>\r\n var<\/span> price=<\/span>field.<\/span>price;<\/span>\r\n $(<\/span>\"#listview\"<\/span>)<\/span>.<\/span>append<\/span>(<\/span>\"<a class='item' href='form.html?id=\"<\/span>+<\/span>id+<\/span>\"&title=\"<\/span>+<\/span>title+<\/span>\"&duration=\"<\/span>+<\/span>duration+<\/span>\"&price=\"<\/span>+<\/span>price+<\/span>\"'><span class='item-note'>$\"<\/span>+<\/span>price+<\/span>\"<\/span><h2>\"<\/span>+<\/span> title +<\/span> \" <\/h2><p>\"<\/span>+<\/span> duration +<\/span>\"<\/p><\/a>\"<\/span>)<\/span>;<\/span>\r\n }<\/span>)<\/span>;<\/span>\r\n }<\/span>)<\/span>;<\/span>\r\n }<\/span>)<\/span>;<\/span>\r\n <\/<\/span>script><\/span><\/span><\/span>\r\n<\/<\/span>head><\/span><\/span><\/span>\r\n<<\/span>body><\/span><\/span><\/span>\r\n <<\/span>div class<\/span>=<\/span>\"<\/span>bar bar-header bar-positive\"<\/span><\/span> style<\/span>=\"<\/span>margin-bottom<\/span>:<\/span>80<\/span>px;<\/span><\/span>\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>a href<\/span>=<\/span>\"<\/span>index.html\"<\/span><\/span> class<\/span>=<\/span>\"<\/span>button button-clear\"<\/span><\/span>><\/span><\/span><\/span>Home<\/<\/span>a><\/span><\/span><\/span>\r\n <<\/span>h1 class<\/span>=<\/span>\"<\/span>title\"<\/span><\/span>><\/span><\/span><\/span>Read Database (<\/span>JSON<\/span>)<\/span><\/<\/span>h1><\/span><\/span><\/span>\r\n <\/<\/span>div><\/span><\/span><\/span><<\/span>br\/><\/span><\/span><\/span><<\/span>br\/><\/span><\/span><\/span>\r\n <<\/span>ul class<\/span>=<\/span>\"<\/span>list\"<\/span><\/span> id<\/span>=<\/span>\"<\/span>listview\"<\/span><\/span>><\/span><\/span><\/span>\r\n <\/<\/span>ul><\/span><\/span><\/span>\r\n<\/<\/span>body><\/span><\/span><\/span>\r\n<\/<\/span>html><\/span><\/span><\/span><\/code><\/pre>\n
    3. Updating MySQL database from Phonegap \/ Apache Cordova (form.html<\/code>)<\/strong><\/h4>\n
    This example shows how to update data and delete data from database using Phonegap \/ Apache Cordova<\/p>\n
    <<\/span>html><\/span><\/span><\/span>\r\n<<\/span>head><\/span><\/span><\/span>\r\n <<\/span>link rel<\/span>=<\/span>\"<\/span>stylesheet\"<\/span><\/span> type<\/span>=<\/span>\"<\/span>text\/css\"<\/span><\/span> href<\/span>=<\/span>\"<\/span>css\/ionic.css\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>script type<\/span>=<\/span>\"<\/span>text\/javascript\"<\/span><\/span> src<\/span>=<\/span>\"<\/span>js\/jquery.js\"<\/span><\/span>><\/span><\/span><\/span><\/<\/span>script><\/span><\/span><\/span>\r\n <<\/span>script type<\/span>=<\/span>\"<\/span>text\/javascript\"<\/span><\/span> src<\/span>=<\/span>\"<\/span>js\/geturi.js\"<\/span><\/span>><\/span><\/span><\/span><\/<\/span>script><\/span><\/span><\/span>\r\n <<\/span>script type<\/span>=<\/span>\"<\/span>text\/javascript\"<\/span><\/span>><\/span><\/span><\/span>\r\n $(<\/span>document)<\/span>.<\/span>ready<\/span>(<\/span>function<\/span>(<\/span>)<\/span>{<\/span>\r\n var<\/span> id =<\/span> decodeURI<\/span>(<\/span>getUrlVars<\/span>(<\/span>)<\/span>[<\/span>\"id\"<\/span>]<\/span>)<\/span>;<\/span>\r\n var<\/span> title =<\/span> decodeURI<\/span>(<\/span>getUrlVars<\/span>(<\/span>)<\/span>[<\/span>\"title\"<\/span>]<\/span>)<\/span>;<\/span>\r\n var<\/span> duration =<\/span> decodeURI<\/span>(<\/span>getUrlVars<\/span>(<\/span>)<\/span>[<\/span>\"duration\"<\/span>]<\/span>)<\/span>;<\/span>\r\n var<\/span> price =<\/span> decodeURI<\/span>(<\/span>getUrlVars<\/span>(<\/span>)<\/span>[<\/span>\"price\"<\/span>]<\/span>)<\/span>;<\/span>\r\n $(<\/span>\"#id\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>id)<\/span>;<\/span>\r\n $(<\/span>\"#title\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>title)<\/span>;<\/span>\r\n $(<\/span>\"#duration\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>duration)<\/span>;<\/span>\r\n $(<\/span>\"#price\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>price)<\/span>;<\/span>\r\n $(<\/span>\"#update\"<\/span>)<\/span>.<\/span>click<\/span>(<\/span>function<\/span>(<\/span>)<\/span>{<\/span>\r\n var<\/span> id=<\/span>$(<\/span>\"#id\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>)<\/span>;<\/span>\r\n var<\/span> title=<\/span>$(<\/span>\"#title\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>)<\/span>;<\/span>\r\n var<\/span> duration=<\/span>$(<\/span>\"#duration\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>)<\/span>;<\/span>\r\n var<\/span> price=<\/span>$(<\/span>\"#price\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>)<\/span>;<\/span>\r\n var<\/span> dataString=<\/span>\"id=\"<\/span>+<\/span>id+<\/span>\"&title=\"<\/span>+<\/span>title+<\/span>\"&duration=\"<\/span>+<\/span>duration+<\/span>\"&price=\"<\/span>+<\/span>price+<\/span>\"&update=\"<\/span>;<\/span>\r\n $.<\/span>ajax<\/span>(<\/span>{<\/span>\r\n type:<\/span> \"POST\"<\/span>,<\/span>\r\n url:<\/span>\"http:<\/span>\/\/localhost\/payment\/update.php\",<\/span>\r\n data:<\/span> dataString,<\/span>\r\n crossDomain:<\/span> true<\/span>,<\/span>\r\n cache:<\/span> false<\/span>,<\/span>\r\n beforeSend:<\/span> function<\/span>(<\/span>)<\/span>{<\/span> $(<\/span>\"#update\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>'Updating...'<\/span>)<\/span>;<\/span>}<\/span>,<\/span>\r\n success:<\/span> function<\/span>(<\/span>data)<\/span>{<\/span>\r\n if<\/span>(<\/span>data==<\/span>\"success\"<\/span>)<\/span>\r\n {<\/span>\r\n alert<\/span>(<\/span>\"Updated\"<\/span>)<\/span>;<\/span>\r\n $(<\/span>\"#update\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>\"Update\"<\/span>)<\/span>;<\/span>\r\n }<\/span>\r\n else<\/span> if<\/span>(<\/span>data==<\/span>\"error\"<\/span>)<\/span>\r\n {<\/span>\r\n alert<\/span>(<\/span>\"error\"<\/span>)<\/span>;<\/span>\r\n }<\/span>\r\n }<\/span>\r\n }<\/span>)<\/span>;<\/span>\r\n \r\n }<\/span>)<\/span>;<\/span>\r\n $(<\/span>\"#delete\"<\/span>)<\/span>.<\/span>click<\/span>(<\/span>function<\/span>(<\/span>)<\/span>{<\/span>\r\n var<\/span> id=<\/span>$(<\/span>\"#id\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>)<\/span>;<\/span>\r\n var<\/span> dataString=<\/span>\"id=\"<\/span>+<\/span>id+<\/span>\"&delete=\"<\/span>;<\/span>\r\n $.<\/span>ajax<\/span>(<\/span>{<\/span>\r\n type:<\/span> \"GET\"<\/span>,<\/span>\r\n url:<\/span>\"http:<\/span>\/\/localhost\/payment\/delete.php\",<\/span>\r\n data:<\/span> dataString,<\/span>\r\n crossDomain:<\/span> true<\/span>,<\/span>\r\n cache:<\/span> false<\/span>,<\/span>\r\n beforeSend:<\/span> function<\/span>(<\/span>)<\/span>{<\/span> $(<\/span>\"#delete\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>'Deleting...'<\/span>)<\/span>;<\/span>}<\/span>,<\/span>\r\n success:<\/span> function<\/span>(<\/span>data)<\/span>{<\/span>\r\n if<\/span>(<\/span>data==<\/span>\"success\"<\/span>)<\/span>\r\n {<\/span>\r\n alert<\/span>(<\/span>\"Deleted\"<\/span>)<\/span>;<\/span>\r\n $(<\/span>\"#delete\"<\/span>)<\/span>.<\/span>val<\/span>(<\/span>\"Delete\"<\/span>)<\/span>;<\/span>\r\n }<\/span>\r\n else<\/span> if<\/span>(<\/span>data==<\/span>\"error\"<\/span>)<\/span>\r\n {<\/span>\r\n alert<\/span>(<\/span>\"error\"<\/span>)<\/span>;<\/span>\r\n }<\/span>\r\n }<\/span>\r\n }<\/span>)<\/span>;<\/span>\r\n \r\n }<\/span>)<\/span>;<\/span>\r\n }<\/span>)<\/span>;<\/span>\r\n <\/<\/span>script><\/span><\/span><\/span>\r\n<\/<\/span>head><\/span><\/span><\/span>\r\n<<\/span>body><\/span><\/span><\/span>\r\n <<\/span>div class<\/span>=<\/span>\"<\/span>bar bar-header bar-positive\"<\/span><\/span> style<\/span>=\"<\/span>margin-bottom<\/span>:<\/span>80<\/span>px;<\/span><\/span>\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>a href<\/span>=<\/span>\"<\/span>index.html\"<\/span><\/span> class<\/span>=<\/span>\"<\/span>button button-clear\"<\/span><\/span>><\/span><\/span><\/span>Home<\/<\/span>a><\/span><\/span><\/span>\r\n <<\/span>h1 class<\/span>=<\/span>\"<\/span>title\"<\/span><\/span>><\/span><\/span><\/span>Update Database<\/<\/span>h1><\/span><\/span><\/span>\r\n <<\/span>a class<\/span>=<\/span>\"<\/span>button button-clear\"<\/span><\/span> href<\/span>=<\/span>\"<\/span>readjson.html\"<\/span><\/span>><\/span><\/span><\/span>Read JSON<\/span><\/<\/span>a><\/span><\/span><\/span>\r\n <\/<\/span>div><\/span><\/span><\/span><<\/span>br\/><\/span><\/span><\/span><<\/span>br\/><\/span><\/span><\/span>\r\n <<\/span>div class<\/span>=<\/span>\"<\/span>list\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>input type<\/span>=<\/span>\"<\/span>hidden\"<\/span><\/span> id<\/span>=<\/span>\"<\/span>id\"<\/span><\/span> value<\/span>=<\/span>\"<\/span>\"<\/span><\/span>\/><\/span><\/span><\/span>\r\n <<\/span>div class<\/span>=<\/span>\"<\/span>item\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>label><\/span><\/span><\/span>Title<\/<\/span>label><\/span><\/span><\/span>\r\n <<\/span>input type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> id<\/span>=<\/span>\"<\/span>title\"<\/span><\/span> value<\/span>=<\/span>\"<\/span>\"<\/span><\/span>\/><\/span><\/span><\/span>\r\n <\/<\/span>div><\/span><\/span><\/span>\r\n <<\/span>div class<\/span>=<\/span>\"<\/span>item\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>label><\/span><\/span><\/span>Duration<\/<\/span>label><\/span><\/span><\/span>\r\n <<\/span>input type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> id<\/span>=<\/span>\"<\/span>duration\"<\/span><\/span> value<\/span>=<\/span>\"<\/span>\"<\/span><\/span>\/><\/span><\/span><\/span>\r\n <\/<\/span>div><\/span><\/span><\/span>\r\n <<\/span>div class<\/span>=<\/span>\"<\/span>item\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>label><\/span><\/span><\/span>Price<\/<\/span>label><\/span><\/span><\/span>\r\n <<\/span>input type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> id<\/span>=<\/span>\"<\/span>price\"<\/span><\/span> value<\/span>=<\/span>\"<\/span>\"<\/span><\/span>\/><\/span><\/span><\/span>\r\n <\/<\/span>div><\/span><\/span><\/span>\r\n <<\/span>div class<\/span>=<\/span>\"<\/span>item\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>input type<\/span>=<\/span>\"<\/span>button\"<\/span><\/span> id<\/span>=<\/span>\"<\/span>update\"<\/span><\/span> class<\/span>=<\/span>\"<\/span>button button-block\"<\/span><\/span> value<\/span>=<\/span>\"<\/span>Update\"<\/span><\/span>\/><\/span><\/span><\/span>\r\n <<\/span>input type<\/span>=<\/span>\"<\/span>button\"<\/span><\/span> id<\/span>=<\/span>\"<\/span>delete\"<\/span><\/span> class<\/span>=<\/span>\"<\/span>button button-block\"<\/span><\/span> value<\/span>=<\/span>\"<\/span>Delete\"<\/span><\/span>\/><\/span><\/span><\/span>\r\n <\/<\/span>div><\/span><\/span><\/span>\r\n <\/<\/span>div><\/span><\/span><\/span>\r\n \r\n<\/<\/span>body><\/span><\/span><\/span>\r\n<\/<\/span>html><\/span><\/span><\/span><\/code><\/pre>\n
    geturi.js<\/strong><\/p>\n
    this code is used for getting value from URL.like site.com\/file?<\/p>\n
    E.g http:\/\/localhost\/file.html?name=sundar&country=india<\/p>\n
    if you want to get name and URL, you can use like this<\/p>\n
    var name = gerUrlVars()[\u201cname\u201d];<\/p>\n
    var country = gerUrlVars()[\u201ccountry\u201d];<\/p>\n
    >> geturi.js<\/em><\/p>\n
    function<\/span> getUrlVars<\/span>(<\/span>)<\/span> {<\/span>\r\n var<\/span> vars =<\/span> [<\/span>]<\/span>,<\/span> hash;<\/span>\r\n var<\/span> hashes =<\/span> window.<\/span>location.<\/span>href.<\/span>slice<\/span>(<\/span>window.<\/span>location.<\/span>href.<\/span>indexOf<\/span>(<\/span>'?'<\/span>)<\/span> +<\/span> 1<\/span>)<\/span>.<\/span>split<\/span>(<\/span>'&'<\/span>)<\/span>;<\/span>\r\n for<\/span> (<\/span>var<\/span> i =<\/span> 0<\/span>;<\/span> i <<\/span> hashes.<\/span>length;<\/span> i++<\/span>)<\/span> {<\/span>\r\n hash =<\/span> hashes[<\/span>i]<\/span>.<\/span>split<\/span>(<\/span>'='<\/span>)<\/span>;<\/span>\r\n vars.<\/span>push<\/span>(<\/span>hash[<\/span>0<\/span>]<\/span>)<\/span>;<\/span>\r\n vars[<\/span>hash[<\/span>0<\/span>]<\/span>]<\/span> =<\/span> hash[<\/span>1<\/span>]<\/span>;<\/span>\r\n }<\/span>\r\n return<\/span> vars;<\/span>\r\n}<\/span><\/code><\/pre>\n
    COMMON MISTAKES<\/h3>\n
      \n
    • localhost won\u2019t work in mobile devices, If you\u2019re testing on device you need to host your file or you need to connect with IP address<\/li>\n
    • Make sure you\u2019ve included\u00a0geturi.js<\/em><\/li>\n
    • Download the files and try<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
      Step By Step Guide: MySQL Database Creation Writing PHP code for Serverside Writing Jquery code for PhoneGap \/ Apache Cordova side 1. Connecting Database Server (db.php) <?php header(“Access-Control-Allow-Origin: *”); $con = mysqli_connect(“localhost”,”root”,””,”test”) or die (“could not connect database”); ?> NOTE header(“Access-Control-Allow-Origin: *”);\u00a0use to allow cross domains 2. Insert data into MySQL database using PHP (insert.php) […]<\/p>\n","protected":false},"author":542,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1753","post","type-post","status-publish","format-standard","hentry","category-teaching","entry"],"_links":{"self":[{"href":"https:\/\/people.utm.my\/ajune\/wp-json\/wp\/v2\/posts\/1753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.utm.my\/ajune\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.utm.my\/ajune\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.utm.my\/ajune\/wp-json\/wp\/v2\/users\/542"}],"replies":[{"embeddable":true,"href":"https:\/\/people.utm.my\/ajune\/wp-json\/wp\/v2\/comments?post=1753"}],"version-history":[{"count":9,"href":"https:\/\/people.utm.my\/ajune\/wp-json\/wp\/v2\/posts\/1753\/revisions"}],"predecessor-version":[{"id":1763,"href":"https:\/\/people.utm.my\/ajune\/wp-json\/wp\/v2\/posts\/1753\/revisions\/1763"}],"wp:attachment":[{"href":"https:\/\/people.utm.my\/ajune\/wp-json\/wp\/v2\/media?parent=1753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.utm.my\/ajune\/wp-json\/wp\/v2\/categories?post=1753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.utm.my\/ajune\/wp-json\/wp\/v2\/tags?post=1753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}