ricmetal 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? Link to comment https://forums.phpfreaks.com/topic/147816-span-content-to-mysql/ Share on other sites More sharing options...
ricmetal 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 Link to comment https://forums.phpfreaks.com/topic/147816-span-content-to-mysql/#findComment-775968 Share on other sites More sharing options...
aseaofflames 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; Link to comment https://forums.phpfreaks.com/topic/147816-span-content-to-mysql/#findComment-776000 Share on other sites More sharing options...
ricmetal 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 Link to comment https://forums.phpfreaks.com/topic/147816-span-content-to-mysql/#findComment-776419 Share on other sites More sharing options...
aseaofflames 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. Link to comment https://forums.phpfreaks.com/topic/147816-span-content-to-mysql/#findComment-776970 Share on other sites More sharing options...
ricmetal 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 Link to comment https://forums.phpfreaks.com/topic/147816-span-content-to-mysql/#findComment-777390 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.