在Android Studio/PHP/Java中插入数据的问题。

huangapple
go评论123阅读模式
英文:

Problem with inserting data AndroidStudio/PHP/Java

问题

当我向数据库插入数据时，我会得到以下错误：
https://gyazo.com/501ee97212001fc7ffe65c1abc1048c4
“注意：在C:/wampp64/www/wspoladm.php的第3行中未定义变量：$POST”
值已添加，但在第3行中的第一个未添加。
我在每个脚本中都声明了这个变量，我不知道是什么问题。谢谢大家的答复。
PHP脚本：

  1. require "conn.php";
  2. $czy_dane=$POST["czy_dane"]; -- 第3行
  3. $umowa = $_POST["umowa"];
  4. $nazwa=$_POST["nazwa"];
  5. $kategorie=$_POST["kategorie"];
  6. $opis=$_POST["opis"];
  7. $transfer=$_POST["transfer"];
  8. $zabezpieczenia=$_POST["zabezpieczenia"];
  9. $dane=$_POST["dane"];
  10. $mysql_qry1 = "insert into wspoladm_panel(czy_dane,nr_umowy,nazwa,kategorie,opis,transfer,zabezpieczenia,dane)
  11. values('$czy_dane','$umowa','$nazwa','$kategorie','$opis','$zabezpieczenia','$transfer','$dane')";
  12. if($conn->query($mysql_qry1) === TRUE)  {
  13. echo "Pomyslnie dodano dane";
  14. }
  15. else
  16. {echo "Error: " . $mysql_qry1 . "<br" . $conn->error;
  17. }
  18. $conn->close();

BackgroundWorker.java：

  1. if(type.equals("insert")){
  3.         try {
  4.             String czy_dane = params[1];
  5.             String umowa = params[2];
  6.             String nazwa = params[3];
  7.             String kategorie = params[4];
  8.             String opis = params[5];
  9.             String transfer = params[6];
  10.             String zabezpieczenia = params[7];
  11.             String dane = params[8];
  13.             URL url = new URL (insert_url);
  14.             HttpURLConnection httpURLConnection=(HttpURLConnection)url.openConnection();
  15.             httpURLConnection.setRequestMethod("POST");
  16.             httpURLConnection.setDoOutput(true);
  17.             httpURLConnection.setDoInput(true);
  18.             OutputStream outputStream = httpURLConnection.getOutputStream();
  19.             BufferedWriter bufferedWriter = new BufferedWriter(new OutputStreamWriter(outputStream,"UTF-8"));
  20.             String post_data = URLEncoder.encode("czy_dane","UTF-8")+"="+URLEncoder.encode(czy_dane,"UTF-8")+"&amp;"+
  21.                     URLEncoder.encode("umowa","UTF-8")+"="+URLEncoder.encode(umowa,"UTF-8")+"&amp;"
  22.             +URLEncoder.encode("nazwa","UTF-8")+"="+URLEncoder.encode(nazwa,"UTF-8")+"&amp;"
  23.             +URLEncoder.encode("kategorie","UTF-8")+"="+URLEncoder.encode(kategorie,"UTF-8")+"&amp;"
  24.             +URLEncoder.encode("opis","UTF-8")+"="+URLEncoder.encode(opis,"UTF-8")+"&amp;"
  25.             +URLEncoder.encode("transfer","UTF-8")+"="+URLEncoder.encode(transfer,"UTF-8")+"&amp;"
  26.             +URLEncoder.encode("zabezpieczenia","UTF-8")+"="+URLEncoder.encode(zabezpieczenia,"UTF-8")+"&amp;"
  27.                     +URLEncoder.encode("dane","UTF-8")+"="+URLEncoder.encode(dane,"UTF-8");
  28.             bufferedWriter.write(post_data);
  29.             bufferedWriter.flush();
  30.             bufferedWriter.close();
  31.             outputStream.close();
  32.             InputStream inputStream = httpURLConnection.getInputStream();
  33.             BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream,"iso-8859-1")) ;
  34.             String result="";
  35.             String line="";
  36.             while((line = bufferedReader.readLine())!=null) {
  37.                 result+= line;
  38.             }
  39.             bufferedReader.close();
  40.             inputStream.close();
  41.             httpURLConnection.disconnect();
  42.             return result;
  43.         } catch (MalformedURLException e) {
  44.             e.printStackTrace();
  45.         } catch (IOException e) {
  46.             e.printStackTrace();
  47.         }

SecondPan.java：

  1. public class SecondPan extends AppCompatActivity implements AdapterView.OnItemClickListener {
  2. private Spinner sspnOption6, sspn2;
  4. EditText umowa,nazwa,kategorie,opis,zabezpieczenia,dane;
  5. String czy_dane, transfer;
  9. @Override
  10. protected void onCreate(Bundle savedInstanceState) {
  11.     super.onCreate(savedInstanceState);
  12.     setContentView(R.layout.activity_second_pan);
  15.     umowa = (EditText) findViewById(R.id.scnd_txt1);
  16.     nazwa = (EditText) findViewById(R.id.scnd_txt2);
  17.     kategorie = (EditText) findViewById(R.id.scnd_txt3);
  18.     opis = (EditText) findViewById(R.id.scnd_tx4);
  19.     zabezpieczenia = (EditText) findViewById(R.id.scnd_tx6);
  20.     dane = (EditText) findViewById(R.id.scnd_tx7);
  23.     sspnOption6 = findViewById(R.id.sspn);
  24.     ArrayAdapter<CharSequence> FirstAdapter = new ArrayAdapter<CharSequence>(this,android.R.layout.simple_spinner_item, getResources().getStringArray(R.array.tab1));
  25.     FirstAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
  26.     sspnOption6.setAdapter(FirstAdapter);
  29.     sspn2=findViewById(R.id.sspn2);
  30.     ArrayAdapter<CharSequence> Secondadapter = new ArrayAdapter<CharSequence>(this,android.R.layout.simple_spinner_item, getResources().getStringArray(R.array.transfer));
  31.     Secondadapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
  32.     sspn2.setAdapter(Secondadapter);
  33.      czy_dane = sspn2.getSelectedItem().toString();
  35.     transfer = sspnOption6.getSelectedItem().toString();
  38. }
  39. public void onItemClick(AdapterView<?> parent, View view, int position, long l) {
  40.     String text = parent.getItemAtPosition(position).toString();
  41.     Toast.makeText(parent.getContext(), text, Toast.LENGTH_SHORT).show();
  44. }
  48. public void OnInsert(View view ) {
  49.     String str_czy_dane = sspn2.getSelectedItem().toString();
  50.     String str_umowa = umowa.getText().toString();
  51.     String str_nazwa = nazwa.getText().toString();
  52.     String str_kategorie = kategorie.getText().toString();
  53.     String str_opis = opis.getText().toString();
  54.     String str_transfer  = sspnOption6.getSelectedItem().toString();
  55.     String str_zabezpieczenia = zabezpieczenia.getText().toString();
  56.     String str_dane = dane.getText().toString();
  57.     String type = "insert";
  58.     BackgroundWorker backgroundWorker = new BackgroundWorker(this);
  59.     backgroundWorker.execute(type, str_czy_dane,str_umowa, str_nazwa, str_kategorie, str_opis,str_transfer, str_zabezpieczenia, str_dane);
  60. }

}

英文:

when I insert data to my database i get error like below:
https://gyazo.com/501ee97212001fc7ffe65c1abc1048c4
"Notice: Undefined variable: POST in C:/wampp64/www/wspoladm.php on line 3"
Values are added, expect the first one in lane 3.
I declared this varriable in every script and I have no idea what's wrong. Thanks for answer guys.
Php script:

  1. require &quot;conn.php&quot;;
  2. $czy_dane=$POST[&quot;czy_dane&quot;]; -- line 3
  3. $umowa = $_POST[&quot;umowa&quot;];
  4. $nazwa=$_POST[&quot;nazwa&quot;];
  5. $kategorie=$_POST[&quot;kategorie&quot;];
  6. $opis=$_POST[&quot;opis&quot;];
  7. $transfer=$_POST[&quot;transfer&quot;];
  8. $zabezpieczenia=$_POST[&quot;zabezpieczenia&quot;];
  9. $dane=$_POST[&quot;dane&quot;];
  10. $mysql_qry1 = &quot;insert into wspoladm_panel(czy_dane,nr_umowy,nazwa,kategorie,opis,transfer,zabezpieczenia,dane)
  11. values(&#39;$czy_dane&#39;,&#39;$umowa&#39;,&#39;$nazwa&#39;,&#39;$kategorie&#39;,&#39;$opis&#39;,&#39;$zabezpieczenia&#39;,&#39;$transfer&#39;,&#39;$dane&#39;)&quot;;
  12. if($conn-&gt;query($mysql_qry1) === TRUE)  {
  13. echo &quot;Pomyslnie dodano dane&quot;;
  14. }
  15. else
  16. {echo &quot;Error: &quot; . $mysql_qry1 . &quot;&lt;br&quot; . $conn-&gt;error;
  17. }
  18. $conn-&gt;close();

BackgroundWorker.java:

  1. if(type.equals(&quot;insert&quot;)){
  3.         try {
  4.             String czy_dane = params[1];
  5.             String umowa = params[2];
  6.             String nazwa = params[3];
  7.             String kategorie = params[4];
  8.             String opis = params[5];
  9.             String transfer = params[6];
  10.             String zabezpieczenia = params[7];
  11.             String dane = params[8];
  13.             URL url = new URL (insert_url);
  14.             HttpURLConnection httpURLConnection=(HttpURLConnection)url.openConnection();
  15.             httpURLConnection.setRequestMethod(&quot;POST&quot;);
  16.             httpURLConnection.setDoOutput(true);
  17.             httpURLConnection.setDoInput(true);
  18.             OutputStream outputStream = httpURLConnection.getOutputStream();
  19.             BufferedWriter bufferedWriter = new BufferedWriter(new OutputStreamWriter(outputStream,&quot;UTF-8&quot;));
  20.             String post_data = URLEncoder.encode(&quot;czy_dane&quot;,&quot;UTF-8&quot;)+&quot;=&quot;+URLEncoder.encode(czy_dane,&quot;UTF-8&quot;)+&quot;&amp;&quot;+
  21.                     URLEncoder.encode(&quot;umowa&quot;,&quot;UTF-8&quot;)+&quot;=&quot;+URLEncoder.encode(umowa,&quot;UTF-8&quot;)+&quot;&amp;&quot;
  22.             +URLEncoder.encode(&quot;nazwa&quot;,&quot;UTF-8&quot;)+&quot;=&quot;+URLEncoder.encode(nazwa,&quot;UTF-8&quot;)+&quot;&amp;&quot;
  23.             +URLEncoder.encode(&quot;kategorie&quot;,&quot;UTF-8&quot;)+&quot;=&quot;+URLEncoder.encode(kategorie,&quot;UTF-8&quot;)+&quot;&amp;&quot;
  24.             +URLEncoder.encode(&quot;opis&quot;,&quot;UTF-8&quot;)+&quot;=&quot;+URLEncoder.encode(opis,&quot;UTF-8&quot;)+&quot;&amp;&quot;
  25.             +URLEncoder.encode(&quot;transfer&quot;,&quot;UTF-8&quot;)+&quot;=&quot;+URLEncoder.encode(transfer,&quot;UTF-8&quot;)+&quot;&amp;&quot;
  26.             +URLEncoder.encode(&quot;zabezpieczenia&quot;,&quot;UTF-8&quot;)+&quot;=&quot;+URLEncoder.encode(zabezpieczenia,&quot;UTF-8&quot;)+&quot;&amp;&quot;
  27.                     +URLEncoder.encode(&quot;dane&quot;,&quot;UTF-8&quot;)+&quot;=&quot;+URLEncoder.encode(dane,&quot;UTF-8&quot;);
  28.             bufferedWriter.write(post_data);
  29.             bufferedWriter.flush();
  30.             bufferedWriter.close();
  31.             outputStream.close();
  32.             InputStream inputStream = httpURLConnection.getInputStream();
  33.             BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream,&quot;iso-8859-1&quot;)) ;
  34.             String result=&quot;&quot;;
  35.             String line=&quot;&quot;;
  36.             while((line = bufferedReader.readLine())!=null) {
  37.                 result+= line;
  38.             }
  39.             bufferedReader.close();
  40.             inputStream.close();
  41.             httpURLConnection.disconnect();
  42.             return result;
  43.         } catch (MalformedURLException e) {
  44.             e.printStackTrace();
  45.         } catch (IOException e) {
  46.             e.printStackTrace();
  47.         }

SecondPan.java:

  1. public class SecondPan extends AppCompatActivity implements AdapterView.OnItemClickListener {
  2. private Spinner sspnOption6, sspn2;
  4. EditText umowa,nazwa,kategorie,opis,zabezpieczenia,dane;
  5. String czy_dane, transfer;
  9. @Override
  10. protected void onCreate(Bundle savedInstanceState) {
  11.     super.onCreate(savedInstanceState);
  12.     setContentView(R.layout.activity_second_pan);
  15.     umowa = (EditText) findViewById(R.id.scnd_txt1);
  16.     nazwa = (EditText) findViewById(R.id.scnd_txt2);
  17.     kategorie = (EditText) findViewById(R.id.scnd_txt3);
  18.     opis = (EditText) findViewById(R.id.scnd_tx4);
  19.     zabezpieczenia = (EditText) findViewById(R.id.scnd_tx6);
  20.     dane = (EditText) findViewById(R.id.scnd_tx7);
  23.     sspnOption6 = findViewById(R.id.sspn);
  24.     ArrayAdapter&lt;CharSequence&gt; FirstAdapter = new ArrayAdapter&lt;CharSequence&gt;(this,android.R.layout.simple_spinner_item, getResources().getStringArray(R.array.tab1));
  25.     FirstAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
  26.     sspnOption6.setAdapter(FirstAdapter);
  29.     sspn2=findViewById(R.id.sspn2);
  30.     ArrayAdapter&lt;CharSequence&gt; Secondadapter = new ArrayAdapter&lt;CharSequence&gt;(this,android.R.layout.simple_spinner_item, getResources().getStringArray(R.array.transfer));
  31.     Secondadapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
  32.     sspn2.setAdapter(Secondadapter);
  33.      czy_dane = sspn2.getSelectedItem().toString();
  35.     transfer = sspnOption6.getSelectedItem().toString();
  38. }
  39. public void onItemClick(AdapterView&lt;?&gt; parent, View view, int position, long l) {
  40.     String text = parent.getItemAtPosition(position).toString();
  41.     Toast.makeText(parent.getContext(), text, Toast.LENGTH_SHORT).show();
  44. }
  48. public void OnInsert(View view ) {
  49.     String str_czy_dane = sspn2.getSelectedItem().toString();
  50.     String str_umowa = umowa.getText().toString();
  51.     String str_nazwa = nazwa.getText().toString();
  52.     String str_kategorie = kategorie.getText().toString();
  53.     String str_opis = opis.getText().toString();
  54.     String str_transfer  = sspnOption6.getSelectedItem().toString();
  55.     String str_zabezpieczenia = zabezpieczenia.getText().toString();
  56.     String str_dane = dane.getText().toString();
  57.     String type = &quot;insert&quot;;
  58.     BackgroundWorker backgroundWorker = new BackgroundWorker(this);
  59.     backgroundWorker.execute(type, str_czy_dane,str_umowa, str_nazwa, str_kategorie, str_opis,str_transfer, str_zabezpieczenia, str_dane);
  60. }

}

答案1

得分: 1

在你的 PHP 代码中。
使用 $_POST 替代 $POST。

代码

  1. require "conn.php";
  2. $czy_dane = $_POST["czy_dane"]; -- 第 3 行
  3. $umowa = $_POST["umowa"];
  4. $nazwa = $_POST["nazwa"];
  5. $kategorie = $_POST["kategorie"];
  6. $opis = $_POST["opis"];
  7. $transfer = $_POST["transfer"];
  8. $zabezpieczenia = $_POST["zabezpieczenia"];
  9. $dane = $_POST["dane"];
  10. $mysql_qry1 = "insert into wspoladm_panel(czy_dane, nr_umowy, nazwa, kategorie, opis, transfer, zabezpieczenia, dane)
  11. values('$czy_dane', '$umowa', '$nazwa', '$kategorie', '$opis', '$zabezpieczenia', '$transfer', '$dane')";
  12. if ($conn->query($mysql_qry1) === TRUE) {
  13.     echo "Pomyślnie dodano dane";
  14. } else {
  15.     echo "Błąd: " . $mysql_qry1 . "<br>" . $conn->error;
  16. }
  17. $conn->close();

请注意，我已经根据你的要求将代码翻译为中文。如果你需要任何进一步的帮助，请随时告诉我。

英文:

In your php code.
Use $_POST instead of $POST.

Code

  1. require &quot;conn.php&quot;;
  2. $czy_dane=$_POST[&quot;czy_dane&quot;]; -- line 3
  3. $umowa = $_POST[&quot;umowa&quot;];
  4. $nazwa=$_POST[&quot;nazwa&quot;];
  5. $kategorie=$_POST[&quot;kategorie&quot;];
  6. $opis=$_POST[&quot;opis&quot;];
  7. $transfer=$_POST[&quot;transfer&quot;];
  8. $zabezpieczenia=$_POST[&quot;zabezpieczenia&quot;];
  9. $dane=$_POST[&quot;dane&quot;];
  10. $mysql_qry1 = &quot;insert into wspoladm_panel(czy_dane,nr_umowy,nazwa,kategorie,opis,transfer,zabezpieczenia,dane)
  11. values(&#39;$czy_dane&#39;,&#39;$umowa&#39;,&#39;$nazwa&#39;,&#39;$kategorie&#39;,&#39;$opis&#39;,&#39;$zabezpieczenia&#39;,&#39;$transfer&#39;,&#39;$dane&#39;)&quot;;
  12. if($conn-&gt;query($mysql_qry1) === TRUE)  {
  13. echo &quot;Pomyslnie dodano dane&quot;;
  14. }
  15. else
  16. {echo &quot;Error: &quot; . $mysql_qry1 . &quot;&lt;br&quot; . $conn-&gt;error;
  17. }
  18. $conn-&gt;close();

huangapple
  • 本文由 发表于 2020年9月27日 15:17:38
  • 转载请务必保留本文链接：https://go.coder-hub.com/64085879.html
  • android
  • java
  • php
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定