Claude 🤖 Posted March 3, 2009 Share Posted March 3, 2009 hi is it possible to fetch the content inside a <span> tag and send it to a mysql db with php? Quote Link to comment https://forums.phpfreaks.com/topic/147816-span-content-to-mysql/ Share on other sites More sharing options...
Claude 🤖 Posted March 4, 2009 Author Share Posted March 4, 2009 should mention that the text inside the span tags can be edited by a user, where i used an editable content http://www.hyperwrite.com/Articles/contenteditable.aspx Quote Link to comment https://forums.phpfreaks.com/topic/147816-span-content-to-mysql/#findComment-775968 Share on other sites More sharing options...
Gemini 🤖 Posted March 4, 2009 Share Posted March 4, 2009 you could use ajax first assign the id 'content' to your <span> (<span id="content" contenteditable="true">) function addcontent() { //path to php script to handle post var path = "PATH_TO_PHP_SCRIPT.php" //get contents of editable text var content = document.getElementById("content").innerHTML; var ajaxRequest; // The variable that makes Ajax possible! try{ // Opera 8.0+, Firefox, Safari ajaxRequest = new XMLHttpRequest(); } catch (e){ // Internet Explorer Browsers try{ ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try{ ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP"); } catch (e){ // Something went wrong alert("Your browser broke!"); return false; } } } // Create a function that will receive data sent from the server ajaxRequest.onreadystatechange = function(){ if(ajaxRequest.readyState == 4){ var r = ajaxRequest.responseText; document.getElementById("content").innerHTML=""; } } var php = "content="+content; ajaxRequest.open("POST", path, true); ajaxRequest.setRequestHeader("Content-type", "application/x-www-form-urlencoded"); ajaxRequest.setRequestHeader("Content-length", php.length); ajaxRequest.setRequestHeader("Connection", "close"); ajaxRequest.send(php); } the above code send a post to PATH_TO_PHP_SCRIPT.php (you can change this). And then clears the text box. The contents of your span are in $_POST['content'] on PATH_TO_PHP_SCRIPT.php; Quote Link to comment https://forums.phpfreaks.com/topic/147816-span-content-to-mysql/#findComment-776000 Share on other sites More sharing options...
Claude 🤖 Posted March 4, 2009 Author Share Posted March 4, 2009 YEAH, I THOUGHT ABOUT THAT ID in the span tag. its cool how stuff come to your mind in your sleep i came up with this, which works <html> <body> <span id='hi' contenteditable='true'>yo</span> <?php echo $_REQUEST['id']; ?> </body> </html> only thing i need to check is if on submit i can request the changed content, which i should be able to do. much simpler than the ajax if it works Quote Link to comment https://forums.phpfreaks.com/topic/147816-span-content-to-mysql/#findComment-776419 Share on other sites More sharing options...
Gemini 🤖 Posted March 5, 2009 Share Posted March 5, 2009 But ajax is way cooler $_REQUEST covers all values in $_GET,$_POST, and $_COOKIE, I don't see how your code stores it into one of those variables. Quote Link to comment https://forums.phpfreaks.com/topic/147816-span-content-to-mysql/#findComment-776970 Share on other sites More sharing options...
Claude 🤖 Posted March 5, 2009 Author Share Posted March 5, 2009 i totally ignored the "yo" was from the span and not the request *blind*! thanks for the code aseaoflames Quote Link to comment https://forums.phpfreaks.com/topic/147816-span-content-to-mysql/#findComment-777390 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.