AppGini Community Forums

Code: Select all

<?php

$currDir=dirname(__FILE__);
	include("$currDir/lib.php"); //needed for a few things
	include("$currDir/config.php"); //needed to get database variables to log in
	
	$mid = getLoggedMemberID(); //gets member id to use to lookup details
	
	// routine to connect to database - uses variables from config.php
	mysql_connect($dbServer, $dbUsername, $dbPassword) or die(mysql_error()); 
 mysql_select_db($dbDatabase) or die(mysql_error());
 
 
// section to get unique variable from database which identifies the pkValue associated with that user.
	$result1 = mysql_query("SELECT * FROM membership_userrecords WHERE memberID = '$mid' and tableName = 'your_employee_info_tablename'") or die(mysql_error()); //pulls record from the database table
	
while($row1 = mysql_fetch_array($result1)){

$p1 = $row1["pkValue"];

// membership_userrecords is a Appgini created table do not change this name!!!
// your_employee_info_tablename is your created table - change this to match your tablename
}

// section to get employee info from the employee info table
$result2 = mysql_query("SELECT * FROM your_employee_info_tablename WHERE id = '$p1'") or die(mysql_error()); //query to get single record which contains info you wish to use

$info = array(); //variable to hold the array to send data later

while($row2 = mysql_fetch_array($result2)){ //gets data from above query

$f1 = $row2["first_name"];  //field one - I left my field names in place as an example only

$f2 = $row2["last_name"]; //field two - I left my field names in place as an example only

$f3 = ($f1 . " " . $f2); // combines first and last names of employee together - as an example of how to do this

$f4 = $row2["employeeid"]; //some other value - as an example

$info = array('name' => $f3, 'empid' => $f4); // puts records into the array to bring into other table. Assign unique names - I left name and empid in as examples only. You can make up your own.
}
echo json_encode($info); //converts info array into format need to import with javascript code.

?>

Code: Select all

document.observe('dom:loaded', function () {
		var x = document.getElementById("name").value; //change name to match the field you wish to check to see if any data present
	if(!x.match(/\S/)){ // checks for content in field
		getdata(); // if no content in the field it runs the next function.
		return true;	
	}
	});

function getdata(){  //this is the referenced function in the above code
	var http_request = new XMLHttpRequest();  
	try{
		// Opera 8.0+, Firefox, Safari
		http_request = new XMLHttpRequest();
	} catch (e){
		// Internet Explorer Browsers
		try{
			http_request = new ActiveXObject("Msxml2.XMLHTTP");
		} catch (e) {
			try{
				http_request = 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
	http_request.onreadystatechange = function(){
		if(http_request.readyState == 4){
			var data = JSON.parse(http_request.responseText);
			
			document.getElementById("name").value = data.name;  //notice these names match the names in the array created in the php file
			document.getElementById("location_of_incident").value = data.empid;
		}
	}
	http_request.open("GET", "empdetails.php",true);  //this gets the info from the php file
	http_request.send();

}