- android php mysql从app插入多行到数据库数据库
-
我的应用程序包含学生ID号码，姓名和成绩列表，我想将整个列表插入 一个数据库。 每个学生应该连续（id-name-grade，in a row）。 </ p>
我正在使用AsyncTask将我的信息发送到数据库，并想问我如何一次发送多行（每行包含多个变量）？ 如果我需要将它们全部作为一个JSONObject发送，我该如何将它们分成不同的学生？ </ p>
我用来创建我的应用程序的教程：
http://www.mybringback.com/android-sdk/13193/android-mysql-php-json-part-5-developing -the-android-application /
http://www.androidhive.info/2012/05/how-to-connect-android-with-php-mysql/ </ p>我也有 发现以前的答案处理PHP方面的东西，但因为我是新来的PHP我没有真正得到它插入多个mysql行php Android </ p>
</ div>
展开原文
原文
My app holds a list of student id numbers, their names and grades, and I want to insert the entire list into a database. Each student should be in a row (id-name-grade, in one row).
I am using AsyncTask to send my info to the DB, and wanted to ask how can I send multiple rows (each one containing multiple variables)at once? If I need to send them all as one JSONObject how do I separate them back into the different students?
The tutorials I use to create my app: http://www.mybringback.com/android-sdk/13193/android-mysql-php-json-part-5-developing-the-android-application/ http://www.androidhive.info/2012/05/how-to-connect-android-with-php-mysql/
I have also found previous answers that deal with the php side of things but as I am new to php I didn't really get it inserting multiple mysql rows php Android
On your server side, send the data as an array of JSON objects, then insert objects in a foreach loop, try something like this (this untested, but should get you started):
<?php
//your sample input may look something like this:
//$json_input_string = '{0:["id":123,"name":"Jon Doe","grade":"A"],1:[...]}';
$input_data = json_decode($json_input_string);
foreach($input_data->data as $item)
{
//$item->id, $item->name, $item->grade all accessible here
//insert each record here in loop
}
?>
Make sure you are using using prepared statements
Ok so pesky grey rabbit answered the php side (thanks for that!), but for some reason encoding the JSONArray on the android side was not really working for me. It is probably not the neatest way to do things but I used @UncleIstvan 's answer to figure it out: INSERT multiple entries from Android -> PHP -> MYSQL
I deleted the "upload fishes" part of the json_string because (again, for some reason) it wouldn't get decoded. @UncleIstvan if I could upvote you, I would
往数据库新增一条记录insert into之前,先查询判断一下字段里面是否有重复值，怎么实现？_course
2015-04-28如题，写到这里不知道怎么实现了，请各位大侠指点。 Private Sub Button13_Click(sender As Object, e As EventArgs) Handles Button13.Click If TextBox1.Text = "" Then MessageBox.Show("Please input code请输入编号") Else mycn.ConnectionString = "server=localhost;database=kos;uid=sa;pwd=0000;" mycommand.CommandText = "SELECT goodsID from goods where goodsID = " & TextBox1.Text & " " mycommand.Connection = mycn Try mycn.Open() Dim mysqlreader As Data.SqlClient.SqlDataReader = mycommand.ExecuteReader mysqlreader.Read() If mysqlreader.GetInt32(0) = 0 Then '怎么用插入语句实现？？ 放到表GOODS里面，感谢！！！！ Else MessageBox.Show("编号重复") End If Catch ex As Exception Finally mycn.Close() End Try End If End Sub End Class
Postparameter报错误信息_course
2013-01-29我建了一个app，在应用程序中，当点击按钮时就发送一个字符串给下一个activity，在第二个activity中我用这个值从数据库中检索数据。 下边是代码 Intent myIntent = getIntent(); // 从前一个activity中获得值 myIntent.getStringExtra("lbl_name"); postParameters = new ArrayList<NameValuePair>(); postParameters.add(new BasicNameValuePair("product", lbl_name//传递name给database .getText().toString())); 问题是它不会继承lbl_name 我在网上找了很久，但是都没有找到解决方法。麻烦告诉我一下这么做对不对？ 传递值的代码. Intent myIntent = new Intent(SinglePlaceActivity.this,RecoProd.class); myIntent.putExtra("lbl_name", "lbl_name"); SinglePlaceActivity.this.startActivity(myIntent); 访问数据库的代码. public class RecoProd extends Activity { EditText pd; TextView error; ArrayList<NameValuePair> postParameters; /** 当activity第一次被创建的时候调用 */ @Override public void onCreate(Bundle savedInstanceState) { try { Class<?> strictModeClass = Class.forName("android.os.StrictMode", true, Thread.currentThread() .getContextClassLoader()); Class<?> threadPolicyClass = Class.forName("android.os.StrictMode$ThreadPolicy", true, Thread .currentThread().getContextClassLoader()); Class<?> threadPolicyBuilderClass = Class.forName("android.os.StrictMode$ThreadPolicy$Builder", true, Thread.currentThread().getContextClassLoader()); Method setThreadPolicyMethod = strictModeClass.getMethod("setThreadPolicy", threadPolicyClass); Method detectAllMethod = threadPolicyBuilderClass.getMethod("detectAll"); Method penaltyMethod = threadPolicyBuilderClass.getMethod("penaltyLog"); Method buildMethod = threadPolicyBuilderClass.getMethod("build"); Constructor<?> threadPolicyBuilderConstructor = threadPolicyBuilderClass.getConstructor(); Object threadPolicyBuilderObject = threadPolicyBuilderConstructor.newInstance(); Object obj = detectAllMethod.invoke(threadPolicyBuilderObject); obj = penaltyMethod.invoke(obj); Object threadPolicyObject = buildMethod.invoke(obj); setThreadPolicyMethod.invoke(strictModeClass, threadPolicyObject); } catch (Exception ex) { String TAG = null; Log.w(TAG, ex); } super.onCreate(savedInstanceState); setContentView(R.layout.recomain); Intent myIntent = getIntent(); // 从前一个activity中获得值 String lbl_name= myIntent.getStringExtra("lbl_name");//< 从intent中获得 pd = (EditText) findViewById(R.id.name); error = (TextView) findViewById(R.id.showresult); postParameters = new ArrayList<NameValuePair>(); postParameters.add(new BasicNameValuePair("product", lbl_name )); // String valid = "1"; DownloadWebPageTask dw = new DownloadWebPageTask(); dw.execute(""); } private class DownloadWebPageTask extends AsyncTask<String, Void, String> { @Override protected String doInBackground(String... urls) { String response = null; for (String url : urls) { try { response = CustomHttpClient.executeHttpPost("http://192.168.1.7/abc/check2.php", postParameters); String res = response.toString(); // res = res.trim(); res = res.replaceAll("\\s+", ""); // error.setText(res); try{ res = ""; JSONArray jArray = new JSONArray(res); for(int i=0;i<jArray.length();i++){ JSONObject json_data = jArray.getJSONObject(i); Log.i("prod_id","id: "+json_data.getInt("prod_id")+ ", prod_name: "+json_data.getString("prod_name")+ ", prod_category: "+json_data.getString("prod_category")+ ", prod_cost: "+json_data.getDouble("prod_cost") ); //在屏幕输出 res += "\n" + json_data.getInt("prod_id") + " -> "+ json_data.getString("prod_name"); } } catch(JSONException e){ Log.e("log_tag", "Error parsing data "+e.toString()); } try{ error.setText(res); } catch(Exception e){ Log.e("log_tag","Error in Display!" + e.toString());; } } catch (Exception e) { Log.e("log_tag","Error in http connection!!" + e.toString()); } } return response; } @Override protected void onPostExecute(String result) { } } }
Android Studio错误org.apache.http.conn.HttpHostConnectException：拒绝连接到http://10.0.2.2:8080_course
2014-12-19<div class="post-text" itemprop="text"> <p>I have Android Studio with wamp server. I am trying to use a php file to access MySql database on phpmyadmin. I have tried the emulator and Android Device. I am always getting this error : </p> <pre><code>org.apache.http.conn.HttpHostConnectException: Connection to http://10.0.2.2:8080 refused </code></pre> <p>This is my MainActivity.jav file</p> <pre><code>public class MainActivity extends ActionBarActivity { private TextView responseTView; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); this.responseTView = (TextView) findViewById(R.id.response); new getDetails().execute(new SqlConnector()); } private void setTextToTextView(JSONArray jsonArray) { String s = ""; for(int i=0; i<jsonArray.length();i++) { JSONObject obj = null; try { obj = jsonArray.getJSONObject(i); s = s + "ID: " + obj.getString("id") + "Customer Name:" + obj.getString("Customer"); } catch(JSONException e) { e.printStackTrace(); } } this.responseTView.setText(s); } private class getDetails extends AsyncTask<SqlConnector,Long,JSONArray> { @Override protected JSONArray doInBackground(SqlConnector... params) { return params[0].getDetailsinJson(); } @Override protected void onPostExecute(JSONArray jsonArray) { setTextToTextView(jsonArray); } } </code></pre> <p>}</p> <p>And this is my SqlConnector.java file</p> <pre><code>public class SqlConnector { public JSONArray getDetailsinJson() { String url = "http://10.0.2.2:8080/D:/Database/main1.php"; HttpEntity httpEntity = null; try { DefaultHttpClient httpClient = new DefaultHttpClient(); HttpGet httpGet = new HttpGet(url); Log.d("This is inside HTTP try block.","No error.."); HttpResponse httpResponse = httpClient.execute(httpGet); //Using Logs, it's this line that brings on the error. That's my understanding. httpEntity=httpResponse.getEntity(); } catch(ClientProtocolException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } Log.d("Inside SqlConnector Class", "ajsdhlk"); JSONArray jsonArray = null; if(httpEntity != null) { try { String response= EntityUtils.toString(httpEntity); Log.e("This is the response", response); jsonArray = new JSONArray(response); } catch(JSONException e) { Log.d("This is inside Catch block.","Error in JSONArray"); e.printStackTrace(); } catch(IOException e) { Log.d("This is inside catch block.","IOException"); e.printStackTrace(); } } return jsonArray; } </code></pre> <p>}</p> <p>I have read many posts on Stackoverflow over similar problems. But, I am not able to get past this error after trying many things. I tried changing the IP I have used but it doesn't help. Please help. I am quite new to Android Studio, so please explain the solutions. Thanks a lot for help.</p> </div>
Android Studio 将数据发送到 MySql 数据库的问题_course
2015-07-06<div class="post-text" itemprop="text"> <p>我想从我的 android 应用程序中保存一些数据到服务器上的 mysql 数据库中。问题是一切看起来都很完美，我得到的信息是我的数据已经成功发送，但是我的数据库没有收到任何信息。我有以下文件：</p> <pre><code>main.java // setup a dialog window alertDialogBuilder.setCancelable(false) .setPositiveButton("OK", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int id) { // Drawing the marker in the Google Maps drawMarker(point); // Drawing the circle drawCircle(point); //Add proximity alert addProximAlert(point); StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build(); StrictMode.setThreadPolicy(policy); InputStream is = null; // add values to the database String name = "" + editText1.getText(); String description = "" + editText2.getText(); String latitude = "" + Double.toString(point.latitude); String longitude = "" + Double.toString(point.longitude); List<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>(5); nameValuePairs.add(new BasicNameValuePair("name", name)); nameValuePairs.add(new BasicNameValuePair("description", description)); nameValuePairs.add(new BasicNameValuePair("latitude", latitude)); nameValuePairs.add(new BasicNameValuePair("longitude", longitude)); nameValuePairs.add(new BasicNameValuePair("user","Someone")); try { HttpClient httpClient = new DefaultHttpClient(); HttpPost httpPost = new HttpPost("XXXXX/data2.php"); httpPost.setEntity(new UrlEncodedFormEntity(nameValuePairs)); HttpResponse response = httpClient.execute(httpPost); HttpEntity entity = response.getEntity(); is = entity.getContent(); String msg = "Data has been sent successfully"; Toast.makeText(getApplicationContext(), msg, Toast.LENGTH_LONG).show(); } catch (ClientProtocolException e) { Log.e("ClientProtocol", "Log_Tag"); e.printStackTrace(); String msg2 = "Log_Tag"; Toast.makeText(getApplicationContext(), msg2, Toast.LENGTH_LONG).show(); } catch (IOException e) { Log.e("Log_Tag", "IOException"); e.printStackTrace(); String msg3 = "IOException"; Toast.makeText(getApplicationContext(), msg3, Toast.LENGTH_LONG).show(); } } }) .setNegativeButton("Cancel", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int id) { dialog.cancel(); } }); </code></pre> <p>我的PHP文件如下：</p> <pre><code><?php function createNewProduct() { $response = array(); $name=$_POST['name']; $description=$_POST['description']; $latitude=$_POST['latitude']; $longitude=$_POST['longitude']; $user=$_POST['user']; //$db = new DbConnect(); $connection = mysqli_connect('localhost', 'XXXXXXXXX', 'XXXX','XXXX'); $query = "INSERT INTO pois(name,description,lat,longit,created_by) VALUES('$name','$description','$latitude','$longitude','$user')"; $result = mysqli_query($connection, $query) or die(mysql_error()); if ($result) { $response["error"] = false; $response["message"] = "OK!"; } else { $response["error"] = true; $response["message"] = "Failed!"; } // echo json response echo json_encode($response); } createNewProduct(); ?> </code></pre> <p>有什么解决办法吗？</p> <p>更新：谢谢大家的帮助！ 我发现了错误所在。这样说很可惜，但是我在我的 php 文件中发送了错误的密码，现在一切正常。</p> </div>
在android中使用JSON传递数据数组_course
2012-12-18<div class="post-text" itemprop="text"> <p>I need to pass data from MYSQL database to android application by creating JSON object. I am able to pass only the first value from MYSQL database. How to pass all the values together to android application. (My database contains Latitude and Longitude values of more than 10 locations.)</p> <p>Following is my code for passing only the first row value from database to android app.</p> <pre><code> try { HttpClient client = new DefaultHttpClient(); URI website = new URI("http://192.168.1.15/latlonret1.php"); HttpGet request = new HttpGet(); request.setURI(website); HttpResponse response = client.execute(request); in = new BufferedReader(new InputStreamReader(response .getEntity().getContent())); StringBuffer sb = new StringBuffer(""); String l = ""; String nl = System.getProperty("line.separator"); while ((l = in.readLine()) != null) { sb.append(l + nl); } in.close(); data = sb.toString(); // return data; } catch (Exception e) { Log.e("log_tag", "Error converting result " + e.toString()); } try { String returnString; String returnString1; JSONArray jArray = new JSONArray(data); for (int i = 0; i < jArray.length(); i++) { JSONObject json_data = jArray.getJSONObject(i); JSONObject json_data1 = jArray.getJSONObject(i); returnString=json_data.getString("lat") + " "; returnString1=json_data1.getString("lon") + " "; System.out.println(returnString); System.out.println(returnString1); Intent viewIntent =new Intent(Androidmap.this,Mapview.class); Bundle bundle = new Bundle(); bundle.putString("stuff", returnString); viewIntent.putExtras(bundle); Bundle bundle1 = new Bundle(); bundle1.putString("stuff1", returnString1); viewIntent.putExtras(bundle1); startActivity(viewIntent); } </code></pre> <p>This is my Server side coding :</p> <pre><code><?php ob_start(); $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="manu"; // Table name mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql = "select lat , lon from manu "; $result=mysql_query($sql); if(! $result ) { die('Could not get data: ' . mysql_error()); } while($row=mysql_fetch_array($result , MYSQL_ASSOC)) { $output[]=$row; } echo json_encode($output); mysql_close(); ?> </code></pre> </div>
将Android应用程序的数据库与Web服务器数据库同步_course
2014-11-24<div class="post-text" itemprop="text"> <p>I am a noob in android development, I developed an android application using sqlite database. I have same application on web server in php using mysql database. I want to sync the changes of whole database(including all six tables) on web server with my android app database. How do I do it? I need to know how do i check if there is some updation in web server database and if there is some updation then how do i get those updations to my android database automatically.</p> <p>Is there a way to do it without GCM and SyncAdapter?</p> </div>
将Android设备上的数据库同步到远程主数据库_course
2012-05-30<div class="post-text" itemprop="text"> <p>I have a SQLite database on an Android Device and a MySQL remote master database. The Android device user can modify the database (i.e add, delete, modify) records. What I want is to automatically sync the database on the Android device to the master database whenever the Android device is online. After syncing the records on the master database should reflect all the addition, deletion or in some cases modification that has taken place.</p> <p>Okay so here's what Im thinking of doing. In the Databasehelper class that I've created, I am going to add code in each method so that each time a method is called and the corresponding query executed in the local android database, that query string which was executed gets stored in a simple text file. So changes can keep happening in the local database and query strings will keep getting stored in the file. It'll basically create a SQL Dump (right?). Now when I write my JDBC MySQL connection code on the client side, I'll get it to read one line at a time from that file and execute the queries on the master MySQL server. How does it sound? I guess it takes care of deletion too.</p> <p>But the following doubts emerge:</p> <p>1) Will JDBC Connector for MySql work on an Android device? I've browsed on the net and found conflicting answers. Some say it doesn't work. Some says you just have to add the external jar file mysql-connector-java-3.0.17-ga-bin to the build properties of the project. Really confused about this. Have no idea of PHP so I wish this works.</p> <p>2) After connecting, I don't think I need any results back from the MySql master database. I just need to execute the sql dump ive stored in the text file on the master database. Sounds easy enough right?</p> <p>3) Now for the other way sync. The good thing I found on Sqlite is that even they accept SQL queries. So for the other way sync, I'll need to get the Android device to download a Sql Dump file in a particular folder and then get the database adapter ive created to read from the downloaded file and execute the queries. This is sounding far tougher. Any ideas to do this? One thing is sure that the SQLite database will not allow connection to a remote server.</p> <p>Some of the doubts may seem poor but I really need your help guys. As you can see I'm a noob in Databases.</p> </div>
Android可以在没有PHP的情况下直接连接MySQL吗？_course
2015-03-14<div class="post-text" itemprop="text"> <ol> <li>I want to connect to MySQL remote database from android <strong>but</strong> I don't want to send request to php, I want a straight connection to MySQL without making request to php, so in my opinion it will be more fast and I will get everything i need from mysql remote db table, but as far as I google only tutorials on how to connect through request to php. Is it even possible to do what I want?</li> <li>If the first one isn't possible, could Android have local database SQLite in which straight away in android code I can wire queries to that db, but is it possible to write queries inside android code to remote mysql database?</li> </ol> </div>
Android | PHP | MySql - 将表情符号从Android保存到Mysql服务器_course
2016-05-24<div class="post-text" itemprop="text"> <p>How can I send text with <strong>emoji</strong> from Android app to server and save it correctly in MySql database?</p> <p>In Android app I've pass some parametres with post method to php server, then I save it in to MySql database. But I've 2 problems with emoji
意外的状态行：在HttpURLConnection上使用getInputStream（）时的Y������_course
2019-04-14<div class="post-text" itemprop="text"> <p>I am trying to connect to a mysql database using an HTTP request. I have created a class which extends AsyncTask ad takes care of making the http post request and retrieving the data. Here's my code:</p> <pre><code>public class AttemptLogin extends AsyncTask { String mUserName; String mPassword; String un = "admin01"; String pass = "admin01"; Connection con; Context context; AlertDialog dialog ; public AttemptLogin(Context context, String mUserName, String Password) { this.context = context; this.mUserName = mUserName; this.mPassword = Password; } @Override protected void onPreExecute(){ dialog = new AlertDialog.Builder(context).create(); dialog.setTitle("Login Status"); } protected void onPostExecute(String s){ dialog.setMessage(s); dialog.show(); } @Override protected Object doInBackground(Object[] objects) { try{ Log.d(tag, "Debut do in background"); String constr = "http://000.000.0.00:3306/login.php"; URL url = new URL(constr); HttpURLConnection http = (HttpURLConnection)url.openConnection(); http.setDoInput(true); http.setDoOutput(true); http.setUseCaches(false); http.setRequestMethod("POST"); http.setRequestProperty("Connection", "close"); OutputStream ops = http.getOutputStream(); BufferedWriter writer = new BufferedWriter(new OutputStreamWriter(ops,"UTF-8")); String data = URLEncoder.encode("username", "UTF-8") + "=" + URLEncoder.encode(mUserName, "UTF-8") + " & " + URLEncoder.encode("password", "UTF-8") + "=" + URLEncoder.encode(mPassword, "UTF-8"); writer.write(data); writer.flush(); writer.close(); ops.close(); String result = ""; String line = ""; InputStream ips = http.getInputStream(); BufferedReader reader = new BufferedReader(new InputStreamReader(ips,"ISO-8859-1")); while ((line = reader.readLine()) != null){ result += line; } Log.d(tag, "Result = " + result); reader.close(); ips.close(); http.disconnect(); onPostExecute(result); return result; } catch (Exception e) { Log.w("Error connection","" + e.getMessage()); e.printStackTrace(); } return null; } } </code></pre> <p>Of course, the IP I've placed is just to hide my real IP. Anyway, the line at getInputStream() is returning the following error: Unexpected status line: Y������</p> <p>I've tried many things incuding setting the "Connection" property to "close" but it didn't work out.</p> <p>Any help would be appreciated as I've been stuck for some time now. Thank you!</p> </div>
ANDROID - 如何在android studio中将数据库mysql php的值显示到textview中_course
2016-10-18<div class="post-text" itemprop="text"> <p>I've been looking some references to display my value database into android using JSON, but i have a trouble about the keyword to find it, here is all my code to try, please CMIIW, i have put my code and DB into hostinger to make it easy <a href="http://zxccvvv.cuccfree.com/" rel="nofollow">here</a></p> <h1>php code</h1> <blockquote> <p>dbconfig.php</p> </blockquote> <pre><code>$servername = "localhost"; $username = "root"; $password = ""; $dbname = "data_kuesioner"; </code></pre> <blockquote> <p>send_data.php</p> </blockquote> <pre><code><?php include 'dbconfig.php'; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM pertanyaan"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row[] = $result->fetch_assoc()) { $json = json_encode($row); } } else { echo "0 results"; } echo $json; $conn->close(); ?> </code></pre> <h1>android code</h1> <blockquote> <p>MainActivity.java</p> </blockquote> <pre class="lang-js prettyprint-override"><code>package flix.yudi.okhttp; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.view.View; import android.widget.EditText; import android.widget.TextView; import java.io.IOException; import java.util.concurrent.ExecutionException; import okhttp3.MediaType; import okhttp3.OkHttpClient; import okhttp3.Request; import okhttp3.RequestBody; import okhttp3.Response; public class MainActivity extends AppCompatActivity { private EditText edtText; private TextView outputText; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); edtText = (EditText) findViewById(R.id.editText1); outputText = (TextView) findViewById(R.id.textView1); } public void downloadUrl(View view) { String url = "http://" + edtText.getText().toString(); OkHttpHandler handler = new OkHttpHandler(); String result = null; try { result = handler.execute(url).get(); } catch (InterruptedException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (ExecutionException e) { // TODO Auto-generated catch block e.printStackTrace(); } outputText.append(result + " "); } } </code></pre> <blockquote> <p>OkHttpHandler.java</p> </blockquote> <pre class="lang-js prettyprint-override"><code>package flix.yudi.okhttp; import android.os.AsyncTask; import okhttp3.OkHttpClient; import okhttp3.Request; import okhttp3.Response; public class OkHttpHandler extends AsyncTask<String, Void, String> { OkHttpClient client = new OkHttpClient(); @Override protected String doInBackground(String... params) { Request.Builder builder = new Request.Builder(); builder.url(params[0]); Request request = builder.build(); try { Response response = client.newCall(request).execute(); return response.body().string(); } catch (Exception e) { } return null; } } </code></pre> <p>but when i run the program, the app display another interface below</p> <p><a href="https://i.stack.imgur.com/1uyLX.png" rel="nofollow"><img src="https://i.stack.imgur.com/1uyLX.png" alt="Pic"></a></p> </div>
通过JSON从mysql数据库中获取BLOB映像_course
2015-05-16<div class="post-text" itemprop="text"> <p>I have an image stored as BLOB in my MySQL database. I am returning the image back to the android app via PHP JSON array like this: <code>$row_array['image'] = base64_encode($row['image']);</code> Now I am getting the value in android like this <code>String image = c.getString(TAG_IMAGE);</code> where c is a JSON Object. Then I tried decoding it </p> <pre><code>byte[] b = Base64.decode(image, 0); Bitmap bmp = BitmapFactory.decodeByteArray(b, 0, b.length); </code></pre> <p>But this just gives me a null pointer exception and crashes. What am I doing wrong here?</p> <p>Logcat: </p> <pre><code>05-16 15:40:47.469: E/AndroidRuntime(30925): FATAL EXCEPTION: main 05-16 15:40:47.469: E/AndroidRuntime(30925): java.lang.NullPointerException 05-16 15:40:47.469: E/AndroidRuntime(30925): at com.example.shareity.ListNew$JSONParse.onPostExecute(ListNew.java:254) 05-16 15:40:47.469: E/AndroidRuntime(30925): at com.example.shareity.ListNew$JSONParse.onPostExecute(ListNew.java:1) 05-16 15:40:47.469: E/AndroidRuntime(30925): at android.os.AsyncTask.finish(AsyncTask.java:631) 05-16 15:40:47.469: E/AndroidRuntime(30925): at android.os.AsyncTask.access$600(AsyncTask.java:177) 05-16 15:40:47.469: E/AndroidRuntime(30925): at android.os.AsyncTask$InternalHandler.handleMessage(AsyncTask.java:644) 05-16 15:40:47.469: E/AndroidRuntime(30925): at android.os.Handler.dispatchMessage(Handler.java:99) 05-16 15:40:47.469: E/AndroidRuntime(30925): at android.os.Looper.loop(Looper.java:137) 05-16 15:40:47.469: E/AndroidRuntime(30925): at android.app.ActivityThread.main(ActivityThread.java:4745) 05-16 15:40:47.469: E/AndroidRuntime(30925): at java.lang.reflect.Method.invokeNative(Native Method) 05-16 15:40:47.469: E/AndroidRuntime(30925): at java.lang.reflect.Method.invoke(Method.java:511) 05-16 15:40:47.469: E/AndroidRuntime(30925): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:786) 05-16 15:40:47.469: E/AndroidRuntime(30925): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553) 05-16 15:40:47.469: E/AndroidRuntime(30925): at dalvik.system.NativeStart.main(Native Method) </code></pre> </div>
使用php将android连接到mysql数据库：多用户支持？_course
2012-04-24<div class="post-text" itemprop="text"> <p>I am trying to develop an android application. In the application the user can search some data from the database that is on the server side. For that, I use a php script that is on the server side along with mysql database. I give it a call from the android app and the php code connects with the database and returns a json result which I decode and use it as I want. </p> <p>My question is this. Can this support multiple users at the same time? For example 2 different users use at the same time the search function for retrieving data from the database. I know that the database itself can handle this kind of requests, but what about the php service?</p> <p>Here is an example of the php code:</p> <pre><code><?php mysql_connect("host","username","password"); mysql_select_db("Deal"); $sql=mysql_query("select * from CITY where CITY_NAME like 'A%'"); while($row=mysql_fetch_assoc($sql)) $output[]=$row; print(json_encode($output)); mysql_close(); ?> </code></pre> </div>
将Android应用程序连接到MySQL数据库[关闭]_course
2014-10-26<div class="post-text" itemprop="text"> <p>I've designed an android app connected to remote MySQL database using PHP for the purpose of inserting data from the app to the database.</p> <p>Currently I put PHP file in a local server XAMPP but in this case the server has to be always available so the application could work correctly.</p> <p>Is there <strong>any other places</strong> to put or upload the PHP file to be online so anyone can test the application without the need for my local Server to be available.</p> <p>Note that I can not upload it on the same MySQL database server because it already designed before.</p> </div>
将Android Studio连接到Web服务到SQL Server_course
2015-11-02<div class="post-text" itemprop="text"> <p>i heard that the best way to connect android to sql server database is by creating web service around it. Is there any specific tutorial to create the web service? </p> <ol> <li>Do we need install server like xampp for mysql or it will be just fine with sql server management studio?</li> <li>What is exactly a web service? Connecting via post method to php is a web service?</li> <li><p>What software i must use to make it work?</p> <p>-android studio</p> <p>-sql server management studio</p> <p>-php written in notepad (?)</p> <p>-apache tomcat?</p> <p>anything else?</p></li> </ol> <p>Sorry for bad english, Thanks</p> </div>
如果在数据库中插入数据，如何在android中接收通知[关闭]_course
2016-08-29<div class="post-text" itemprop="text"> <p>I have a mySQL database, and I created a simple android app that can display the data from the database using json. And I want to add the function wherein if a data is inserted in my database, the android app will be notified.</p> <p>For example.I have two android app(App "A" and "B"). App "A" can Insert Data, and "B" can Display the data. I'm thinking of, everytime that App "A" Inserts a data, App "B" will be notified, and can refresh the current displayed data. I am thinking of refresh the list every certain time(5-10sec), but it seems to add more process time, and I think maybe refreshing it only when a data is inserted in the database would be better. Is there a way to do this? Hope that you can provide me some knowledge on how to do this. And if possible some example codes. Thank you.</p> </div>
在ListView中从php服务器检索mysql数据到android_course
2011-11-25<div class="post-text" itemprop="text"> <p>I would like to know if there is any way to retrieve or load database from MySql to the Android app? So far most of them includes JSON etc. Is it a must to involve JSON? Is there any alternative way? </p> <p>I am able to post data to the database. I would like to know if I can view the table of the database or any info from the database from the Android app directly.</p> <p>My aim is to view all directory and files available in the web server. User can enter the directory or file while browsing. It would be good if it is listed in ListView etc?</p> </div>
Android应用程序连接到PHPMyAdmin或PHP_course
2015-02-25<div class="post-text" itemprop="text"> <p>Good Day Everyone!</p> <p>I am working on something that is new to me and that is to get data from my phpmyadmin and display it in an android application using XAMPP and JSON. I was wondering what could be the steps that must be taken to make this connection possible. For now, I have a php file that inserts data into a database stored in phpMyAdmin and it works. I am looking to display or add data from an android application. Could somebody please give me steps on how to start this or a link that will help me with this issue. Thanks. Here's my php file right now.</p> <pre><code><?php $server = 'localhost'; $user = 'root'; $password = ''; $database = 'testdb'; $productName = $_POST["txtProductName"]; $price = $_POST["txtPrice"]; $db = mysql_connect($server, $user, $password); $db_select = mysql_select_db ($database, $db); $query = "Insert into products (name, price) Value ('$productName' , '$price')"; if (!$db) { die('Could not connect to database'); } enter code here if (!mysql_select_db($database, $db)) die("Could not open products database"); if (!($result = mysql_query($query , $db))) { print("Could not execute query<br/>"); die(mysql_error()); } mysql_close($db); ?> </code></pre> </div>
将Android应用程序连接到MySQL的最佳方法是什么？_course
2016-10-29<div class="post-text" itemprop="text"> <p>I would like to write an Android App (with Android Studio) which uses a MySQL database.</p> <p>What's the best way to implement it? <br></p> <p>I have found on internet that I should write php files which send queries to the database. Then the php page return a JSON object which should be processed by the Android App (or something like that...). <br> Is this solution safe? Because I have to handle sensitive data like emails or GPS position.</p> <p>Or else, are there other safe ways to let Android App connect to and retrieve information from the database?</p> </div>
5.30MB滴滴萌猫跳一跳辅助(安卓))
2020-10-20按提示开无障碍服务，给悬浮窗权限，然后打开跳一跳游戏，打开软件，切回游戏画面，拖动顶部栏往下让软件的半透明区域把猫覆盖完，可以点击右上角数字修改为1.6。使用方法:从猫的位置按住往第二个方块上滑动，松
软件测试2小时入门
2018-10-10本课程内容系统、全面、简洁、通俗易懂，通过2个多小时的介绍，让大家对软件测试有个系统的理解和认识，具备基本的软件测试理论基础。 主要内容分为5个部分： 1 软件测试概述，了解测试是什么、测试的对象、原则、流程、方法、模型； 2.常用的黑盒测试用例设计方法及示例演示； 3 常用白盒测试用例设计方法及示例演示； 4.自动化测试优缺点、使用范围及示例‘； 5.测试经验谈。
C语言及程序设计初步
2015-01-05课程针对没有任何程序设计基础的初学者，全面介绍C语言及利用C语言进行程序设计的方法。课程注重知识的传授，更关注学习者能够通过实践的方式，真正学会利用C语言解决问题，奠定程序设计的基础。为此，专门设计了实践方案，指导学习者在听讲的同时，有效完成实践。讲课中还适时穿插进行学习指导，帮助初学者尽快掌握程序设计的学习方法。
9.61MBUniBeast 7.1.zip
2019-08-09用于制作mac os Sierra 10.12 启动u盘，在普通电脑上安装。
2KB中信银行计算机类笔试
2012-04-12中信银行计算机类笔试题75道单项选择题，需要的同学何以参考一下，希望能帮到你
42KB81个Python爬虫源代码
2018-12-1381个Python爬虫源代码，内容包含新闻、视频、中介、招聘、图片资源等网站的爬虫资源
- 学院 saprk大数据分析与实战-zookeeper
- 下载 输电线路电压／电流的计算机保护设计与实现
- 下载 不同版本IE使用不同css(css条件注释语句用法)
- 下载 ASP.NET学习路线图浅谈
- 博客 k8s通过yaml文件创建第一个pod容器
- 博客 Servlet
- 学院 项目管理工具箱
- 博客 pytorch：对比clone、detach以及copy_等张量复制操作
- 博客 给定一个整数数组 nums 和一个目标值 target，请你在该数组中找出和为目标值的那 两个 整数， * 并返回他们的数组下标。
- 下载 jsp中使用jstl导入html乱码问题解决方法
- 博客 安装idea后下载maven
- 下载 CSS绘制五角星
- 博客 ssm框架整合----js前端页面的全选和反选
- 下载 不断创新成就客户价值－中兴通讯UMTS“Uni-RAN”解决方案
- 下载 555时基电路应用和工作原理
- 博客 牛客每日一题 飞扬的小鸟
- 下载 IP语音：合理的解决方案
- 博客 PATB 1016 部分A+B
- 学院 Java微信小程序珠宝首饰购物商城 大学生毕业设计教学视频
- 学院 Windows脚本bat-文件批处理基础教程
- 博客 逻辑回归 Logistic Regression
- 下载 微功耗数据采集系统的开发应用
- 下载 asp.net中生成缩略图并添加版权实例代码
- 下载 ijkplayer支持https
- 下载 浅析Js中的单引号与双引号问题
- 学院 Cocos Creator 飞机大战微信小游戏开发
- 学院 Android开发 - kotlin + jetpack + mvvm
- 下载 ARM程序优化及其在嵌入式TCP/IP协议实现中的应用
- 下载 h264数据回调sdk
- 博客 第9章 绘图和可视化