insert query using ajax drupal 7 -
i have searched internet way use our history database on our drupal 7 site. have database built names, marriage dates, etc. have basic page insert. found site helped code, not working. not programmer, can follow directions. here code have:
on basic page using php code input format,
<script language="javascript" type="text/javascript"> //browser support code function ajaxfunction(){ var ajaxrequest; // variable 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){ // went wrong alert("your browser broke!"); return false; } } } ajaxrequest.onreadystatechange = function(){ if(ajaxrequest.readystate == 4){ var ajaxdisplay = document.getelementbyid("ajaxdiv"); ajaxdisplay.innerhtml = ajaxrequest.responsetext; } } ajaxrequest.open("get", "/sites/all/php/check.php" + querystring, true); ajaxrequest.send(null); } //–> </script> <form name="myform"> <br /> <input type="button" onclick="ajaxfunction()" value="insert" /> </form> <div id="ajaxdiv"></div> then, created php file: mysql_connect("localhost","root","root$1") or die('cannot connect database because: ' . mysql_error()); //specify database ** edit required here ** mysql_select_db("dbname") or die("unable select database"); //select database we're using $data = array( 'name' => 'example', 'mail' => 'm@m.com', 'created' => request_time, ); drupal_write_record('users', $data);
i placed php file in folder called php under /sites/all.
but code not working
can here tell me what's wrong?
thanks
Comments
Post a Comment