{"id":10488,"date":"2022-09-23T21:34:36","date_gmt":"2022-09-23T16:04:36","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/"},"modified":"2022-09-23T21:34:36","modified_gmt":"2022-09-23T16:04:36","slug":"solved-ajax-update-php-variable-from-input-box-without-submitting-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/","title":{"rendered":"[Solved] ajax update php variable from input box without submitting [closed]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

Alright I get what your asking for now. The javascript below will make a call from your page to an external script (ajax\/myscripthere.php) which will handle the SQL.<\/p>\n

In the php script, we simply handle our SQL like we normally would if this was not an AJAX call.<\/p>\n

Please accept answer if this is correct to your expectations \ud83d\ude42<\/p>\n

javascript:<\/p>\n

<script>\n    var xmlHttpReq = false;\n\n    \/\/ Set ID Equal to your input box ID\n    input_box_value = document.getElementById(\"inputboxvariable\").value;\n\n    if(window.XMLHttpRequest) {\n        self.xmlHttpReq = new XMLHttpRequest();\n    }\n    else if(window.ActiveXObject) {\n        self.xmlHttpReq = new ActiveXObject(\"Microsoft.XMLHTTP\");\n    }\n\n    \/\/ Set filename equal to your PHP script\n    self.xmlHttpReq.open('POST', \"ajax\/myscripthere.php\", true);\n\n    self.xmlHttpReq.onreadystatechange = function()\n    {\n        if(self.xmlHttpReq.readyState == 4)\n        {\n            \/\/ Update is complete\n        }\n    };\n\n    self.xmlHttpReq.send(\"value=\"+input_box_value);\n<\/script>\n<\/code><\/pre>\n
PHP:<\/p>\n
<?php\nif(isset($_POST['value']))\n{\n    $conn = new mysqli(\"host\", \"username\", \"password\", \"db_name\")\n                 or die ('Error: '.mysqli_connect__error());\n\n    \/\/ Make Correct SQL Query (i dont know your DB)\n    $query = \"UPDATE table_name SET col=\".$_POST['value'].\" WHERE xxxxxx;\";\n\n    $result = @$conn->query($query);\n\n    $conn->close();\n?>\n<\/code><\/pre>\n<\/p><\/div>\n
<\/div>\n<\/div>\n
            <\/span> <\/p><\/div>\n<\/div>\n
[ad_2]<\/p>\n
solved ajax update php variable from input box without submitting [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"
[ad_1] Alright I get what your asking for now. The javascript below will make a call from your page to an external script (ajax\/myscripthere.php) which will handle the SQL. In the php script, we simply handle our SQL like we normally would if this was not an AJAX call. Please accept answer if this is … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[334,2886,339,366],"class_list":["post-10488","post","type-post","status-publish","format-standard","hentry","category-solved","tag-ajax","tag-inputbox","tag-php","tag-variables"],"yoast_head":"\n[Solved] ajax update php variable from input box without submitting [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] ajax update php variable from input box without submitting [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Alright I get what your asking for now. The javascript below will make a call from your page to an external script (ajax\/myscripthere.php) which will handle the SQL. In the php script, we simply handle our SQL like we normally would if this was not an AJAX call. Please accept answer if this is ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-23T16:04:36+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] ajax update php variable from input box without submitting [closed]\",\"datePublished\":\"2022-09-23T16:04:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/\"},\"wordCount\":86,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"ajax\",\"inputbox\",\"php\",\"variables\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/\",\"name\":\"[Solved] ajax update php variable from input box without submitting [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-23T16:04:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] ajax update php variable from input box without submitting [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] ajax update php variable from input box without submitting [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] ajax update php variable from input box without submitting [closed] - JassWeb","og_description":"[ad_1] Alright I get what your asking for now. The javascript below will make a call from your page to an external script (ajax\/myscripthere.php) which will handle the SQL. In the php script, we simply handle our SQL like we normally would if this was not an AJAX call. Please accept answer if this is ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/","og_site_name":"JassWeb","article_published_time":"2022-09-23T16:04:36+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] ajax update php variable from input box without submitting [closed]","datePublished":"2022-09-23T16:04:36+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/"},"wordCount":86,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["ajax","inputbox","php","variables"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/","name":"[Solved] ajax update php variable from input box without submitting [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-23T16:04:36+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-ajax-update-php-variable-from-input-box-without-submitting-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] ajax update php variable from input box without submitting [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/10488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=10488"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/10488\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=10488"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=10488"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=10488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}