Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Write to MySQL database using JavaScript onClick event/PHP

Posted on 2009-02-22
4
Medium Priority
?
21,236 Views
1 Endorsement
Last Modified: 2013-12-12
All I am looking to do is have a custom button (a modified DIV) post updates to my MySQL table using a JavaScript onClick event and PHP.  I have come up with the following code to perform such a task but I can't figure out why it's not working.  The bottom-most code is working code I've been using to send messages using a form/button.

I'm fairly confident I could create another button to post updates to a different table but I'm still new to PHP/MySQL and looking for a way to write to my database in other ways than a form/button.  For UI simplicity I want the user to be able to click within a DIV to post status updates without having to reload the page (as is the case with buttons).
<script language="Java Script" type="text/javascript">
function something(){
	<?php
            mysql_query("INSERT into members (name,userStatus) values('$name', '2')") or die("Could not insert message");
	?>
}
</script>
 
<div onClick="something()">Click Me</div>
 
 
 
=======Working Code=========
 
<?php
require_once('auth.php');
include "connect.php";
 
if(isset($_POST['submit'])){ //if submit button push has been detected
   $message=$_POST['message'];
   $strFirst_Name =$_SESSION['SESS_FIRST_NAME'];
   $strSpace = " ";
   $strLast_Name =$_SESSION['SESS_LAST_NAME'];
   $strName = $strFirst_Name.$strSpace.$strLast_Name;
   $name=$strName;
   if(strlen($message)<1){
      print "You did not input a message";
   } else {
      $message=strip_tags($message);
      $IP=$_SERVER["REMOTE_ADDR"]; //grabs poster's IP
      $checkforbanned="SELECT IP from ipbans where IP='$IP'";
      $checkforbanned2=mysql_query($checkforbanned) or die("Could not check for banned IPS");
      if(mysql_num_rows($checkforbanned2)>0){ //IP is in the banned list
         print "You IP is banned from posting.";
      } else {
         $thedate = date("U"); //grab date and time of the post
         $insertmessage="INSERT into chatmessages (name,IP,postime,message) values('$name','$IP','$thedate','$message')";
         mysql_query($insertmessage) or die("Could not insert message");
      }
   }
}
?>
 
<form action='submit.php' method='post' name='form'>
  <div align="center">
    <p>
      <textarea name='message' id='messageo' cols='30' rows='1' wrap="soft" style="height:35px;"></textarea>
      <input type='submit' id='submito' name='submit' value='Send' style="height:35px; width:100px; vertical-align:top;">
    </p>
    <p>&nbsp;</p>
  </div>
</form>

Open in new window

1
Comment
Question by:CauseLs
  • 3
4 Comments
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 23705950
Here is the "ultra-simple" explanation of AJAX, which I think might have been written my Rasmus Lerdorf a few years ago.  Everything is built off this foundation, so your task is then to add the appropriate "back-and-forth" data fields and name the DIVs correctly.

Best, ~Ray
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 23705954

I find a lot of this AJAX stuff a bit of a hype.  Lots of people have
been using similar things long before it became "AJAX".  And it really
isn't as complicated as a lot of people make it out to be.  Here is a
simple example from one of my apps.  
 
First the Javascript:
 
function createRequestObject() {
    var ro;
    var browser = navigator.appName;
    if(browser == "Microsoft Internet Explorer"){
        ro = new ActiveXObject("Microsoft.XMLHTTP");
    }else{
        ro = new XMLHttpRequest();
    }
    return ro;
}
 
var http = createRequestObject();
 
function sndReq(action) {
    http.open('get', 'rpc.php?action='+action);
    http.onreadystatechange = handleResponse;
    http.send(null);
}
 
function handleResponse() {
    if(http.readyState == 4){
        var response = http.responseText;
        var update = new Array();
 
        if(response.indexOf('|' != -1)) {
            update = response.split('|');
            document.getElementById(update[0]).innerHTML = update[1];
        }
    }
}
 
This creates a request object along with a send request and handle
response function.  So to actually use it, you could include this js in
your page.  Then to make one of these backend requests you would tie it
to something.  Like an onclick event or a straight href like this:
 
  <a href="javascript:sndReq('foo')">[foo]</a>
 
That means that when someone clicks on that link what actually happens
is that a backend request to rpc.php?action=foo will be sent.
 
In rpc.php you might have something like this:
 
  switch($_REQUEST['action']) {
    case 'foo':
      / do something /
      echo "foo|foo done";
      break;
    ...
  }
 
Now, look at handleResponse.  It parses the "foo|foo done" string and
splits it on the '|' and uses whatever is before the '|' as the dom
element id in your page and the part after as the new innerHTML of that
element.  That means if you have a div tag like this in your page:
 
  <div id="foo">
  </div>
 
Once you click on that link, that will dynamically be changed to:
 
  <div id="foo">
  foo done
  </div>
 
That's all there is to it.  Everything else is just building on top of
this.  Replacing my simple response "id|text" syntax with a richer XML
format and makine the request much more complicated as well.  Before you
blindly install large "AJAX" libraries, have a go at rolling your own
functionality so you know exactly how it works and you only make it as
complicated as you need.  Often you don't need much more than what I
have shown here.
 
Expanding this approach a bit to send multiple parameters in the
request, for example, would be really simple.  Something like:
 
  function sndReqArg(action,arg) {
    http.open('get', 'rpc.php?action='+action+'&arg='+arg);
    http.onreadystatechange = handleResponse;
    http.send(null);
  }
 
And your handleResponse can easily be expanded to do much more
interesting things than just replacing the contents of a div.
 
-Rasmus

Open in new window

0
 

Accepted Solution

by:
CauseLs earned 0 total points
ID: 23706187
This appears to be exactly what I needed:  http://www.geekpedia.com/tutorial145_PHP-and-Javascript-Dynamic-update-with-MySQL.html

Thank you very much for your answer though, Ray!  I will consider that approach when updating DIV content.
1
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 23706190
Cool!  Good luck with it, ~Ray
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses how to create an extensible mechanism for linked drop downs.
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses
Course of the Month20 days, 21 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question