我正在尝试使用PHP连接到MySQL,并从Android传递数据库连接参数。我不想对连接参数进行硬编码,也不想将它们存储在单独的文件中。当我在PHP中有数据库参数时,我的代码工作得很好,但现在不工作了,因为我试图用下面的名称-值对将它们从Java传递到PHP。
除了PHP连接使用传递的变量而不是硬编码外,什么都没有改变,所以我怀疑存在一些格式或REGEX问题,但找不到任何解决方案。非常感谢您的帮助!
根据VolkerK的协助解决的问题。请参阅原始PHP代码并在下面进行更新。
原始SQLQuery.php:
<?php
mysql_connect($_REQUEST['url'],$_REQUEST['username'],$_REQUEST['password']);
mysql_select_db($_REQUEST['database']);
$q=mysql_query($_REQUEST['SQL']);
while($e=mysql_fetch_assoc($q))
$output[]=$e;
print(json_encode($output));
mysql_close();
?>
工作SQLQuery.php:
<?php
if (get_magic_quotes_gpc()) {
$process = array(&$_GET, &$_POST, &$_COOKIE, &$_REQUEST);
while (list($key, $val) = each($process)) {
foreach ($val as $k => $v) {
unset($process[$key][$k]);
if (is_array($v)) {
$process[$key][stripslashes($k)] = $v;
$process[] = &$process[$key][stripslashes($k)];
} else {
$process[$key][stripslashes($k)] = stripslashes($v);
}
}
}
unset($process);
}
define('DEBUGLOG', true);
$output = array();
$mysql = mysql_connect($_REQUEST['url'],$_REQUEST['username'],$_REQUEST['password']);
if ( !$mysql ) {
$output['status']='Error';
$output['errormsg']='MySQL connect error';
if ( defined('DEBUGLOG') && DEBUGLOG ) {
$output['errordetails'] = array(
'msg'=>mysql_error(),
'url'=>$_REQUEST['url'],
'username'=>$_REQUEST['username'],
'password'=>$_REQUEST['password']
);
}
}
else if ( !mysql_select_db($_REQUEST['database']) ) {
$output['status']='Error';
$output['errormsg']='Database select error';
if ( defined('DEBUGLOG') && DEBUGLOG ) {
$output['errordetails'] = array(
'msg'=>mysql_error(),
'url'=>$_REQUEST['url'],
'database'=>$_REQUEST['database']
);
}
}
else if ( false===($q=mysql_query($_REQUEST['SQL'])) ) {
$output['status']='Error';
$output['errormsg']='Query error';
if ( defined('DEBUGLOG') && DEBUGLOG ) {
$output['errordetails'] = array(
'msg'=>mysql_error(),
'url'=>$_REQUEST['url'],
'SQL'=>$_REQUEST['SQL']
);
}
}
else {
while( $e=mysql_fetch_assoc($q) ) {
$output[]=$e;
}
}
print(json_encode($output));
摘录自我的安卓代码(详细信息更改以保护无辜者!):
String phpDBURL = "mysqlserver.blah.com:3306";
String phpURL = "http://www.blah.com/php/";
String dbname ="dbref_Evaluate";
String username = "dbref_admin";
String password = "password";
String SQL = "SELECT ID, ShortDesc FROM User WHERE Account = 'myname@gmail.com'";
//the query to send
ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
nameValuePairs.add(new BasicNameValuePair("url",phpDBURL));
nameValuePairs.add(new BasicNameValuePair("username",username));
nameValuePairs.add(new BasicNameValuePair("password",password));
nameValuePairs.add(new BasicNameValuePair("database",dbname));
nameValuePairs.add(new BasicNameValuePair("SQL",SQL));
Log.v("Common.SQLQuery", "Passing parameters: " + nameValuePairs.toString());
//http post
try{
HttpClient httpclient = new DefaultHttpClient();
HttpPost httppost = new HttpPost(phpURL + "SQLQuery.php");
httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
HttpResponse response = httpclient.execute(httppost);
HttpEntity entity = response.getEntity();
InputStream is = entity.getContent();
//convert response to string
等等。
在php文件
您需要更多错误处理。任何mysql_*函数都可能失败,您的代码必须对此做出反应。
粗略示例:
<?php
define('DEBUGLOG', true);
$output = array();
$mysql = mysql_connect($_REQUEST['url'],$_REQUEST['username'],$_REQUEST['password']);
if ( !$mysql ) {
$output['status']='error';
$output['errormsg']='database error';
if ( defined('DEBUGLOG') && DEBUGLOG ) {
$output['errordetails'] = array(
'msg'=>mysql_error(),
'url'=>$_REQUEST['url'],
'username'=>$_REQUEST['username'],
'password'=>$_REQUEST['password']
);
}
}
else if ( !mysql_select_db($_REQUEST['database']) ) {
$output['status']='error';
$output['errormsg']='database error';
if ( defined('DEBUGLOG') && DEBUGLOG ) {
$output['errordetails'] = array(
'msg'=>mysql_error(),
'url'=>$_REQUEST['url'],
'database'=>$_REQUEST['database']
);
}
}
else if ( false===($q=mysql_query($_REQUEST['SQL'])) ) {
$output['status']='error';
$output['errormsg']='database error';
if ( defined('DEBUGLOG') && DEBUGLOG ) {
$output['errordetails'] = array(
'msg'=>mysql_error(),
'url'=>$_REQUEST['url'],
'SQL'=>$_REQUEST['SQL']
);
}
}
else {
while( $e=mysql_fetch_assoc($q) ) {
$output[]=$e;
}
}
print(json_encode($output));