hi.
ich mache es mal kurz. könnt ihr aus meinem code erkennen warum keine daten in meine sql-datenbank geschrieben werden?
PHP CODE:
also die login-infos sind korrekt. habe es schon mit anderen php-skripten versucht.
ich mache es mal kurz. könnt ihr aus meinem code erkennen warum keine daten in meine sql-datenbank geschrieben werden?
PHP CODE:
Code:
<?php
// Database Settings
define('DB_HOST','*****'); // MySQL Server Host
define('DB_USER','****'); // MySQL User
define('DB_PASS','******'); // MySQL Password
define('DB_NAME','*******'); //The name of the database
//Connect to the database or throw a nasty error
$db = mysql_connect(DB_HOST,DB_USER,DB_PASS) or die(mysql_error());
mysql_select_db(DB_NAME,$db) or die(mysql_error());
switch(strtoupper($_REQUEST['command'])){
case 'STORE':
cmd_store($_REQUEST);
break;
default:
echo ("Invalid Command Requested");
}
//close the database connection
mysql_close($db);
//stop execution
die();
function cmd_store($params){
// Check for required parameters
$req = array('slname','slid','sllocation','sl_n1','sl_n2');
foreach($req as $rkey){
$$rkey = mysql_real_escape_string($params[$rkey]);
}
//create and execute the query
$sql = "INSERT INTO lslstore (name, id, location, num1, num2) VALUES ('$name', '$id', '$location', '$num1', '$num2', NOW())";
$result = mysql_query($sql) or die(mysql_error());
echo 'Store successful.';
}
}
?>
Code:
key requestOfServerStatusRequestid;
key saveData;
string serverStatus="no_status_received";
string name;
key currentUser;
string location;
string n1;string n2;string n3;string n4;string n5;string n6;
default
{
state_entry()
{
}
touch_start(integer number)
{
name = llDetectedName(0);
currentUser = llDetectedKey(0);
location = "Home";
n1="1";
n2="2";
string urlStore = "http://xxx.xxx.com/datei.php?command=store&slname="+name+"&slid="
+(string)currentUser+"&sllocation="+location+"&sl_n1="+n1+"&sl_n2="+n2;
saveData = llHTTPRequest(urlStore,[HTTP_METHOD,"GET"],"");
}
http_response(key request_id, integer status, list metadata, string body)
{
if (request_id == saveData)
{
// The response to save of status should be "Store successful."
llWhisper(0, "Response to store attempt: " + body);
}
else if (request_id == requestOfServerStatusRequestid)
{
// The response to server status request is the server status
llWhisper(0, "Response to server status request: " + body);
serverStatus = body;
}
else
{
llSay(0,(string)status+" error");
}
}
}
also die login-infos sind korrekt. habe es schon mit anderen php-skripten versucht.