Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question
il faut que j'ajoute le driver de mysql (mysql_connector_jar)
<?php if (isset($_POST['username'])&& (isset($_POST['password']))) { $un=$_POST['username']; $pw=$_POST['password']; //connect to the db $user = 'root'; $pswd = ''; $db = 'database'; $conn = mysql_connect('localhost', $user, $pswd); if($conn==true){ echo "connexion au serveur est etablie"; } else echo "connexion au serveur n'est pas etablie"; $base =mysql_select_db($db, $conn); if($base==true){ echo "connexion à la base de donnée est etablie"; }else echo "connexion à la base de donnée n'est pas etablie"; //run the query to search for the username and password the match $query "SELECT * FROM auth_table WHERE username '$un' AND password = '$pw'"; $result = mysql_query($query) or die("Unable to verify user because : " . mysql_error()); //this is where the actual verification happens if(mysql_num_rows($result)){ echo 1;} // for correct login response else { echo 0; // for incorrect login response } } ?>
<?php $un = isset($_POST['username']) ? $_POST['username'] : ''; $pw = isset($_POST['password']) ? $_POST['password'] : ''; //connect to the db $conn = mysql_connect('localhost', 'root', ''); mysql_select_db('algerietelecom', $conn); $query "SELECT username,password FROM compte1 WHERE username '".$un."' AND password = '".$pw."'"; $result = mysql_query($query) or die("Unable to verify user because : " . mysql_error()); if(mysql_num_rows($result) > 0) echo 1; // for correct login response else echo 0; // for incorrect login response ?>
package com.example.login2; import java.io.BufferedReader; import java.io.IOException; import java.io.InputStreamReader; import java.net.URI; import java.util.ArrayList; import org.apache.http.HttpResponse; import org.apache.http.NameValuePair; import org.apache.http.client.HttpClient; import org.apache.http.client.entity.UrlEncodedFormEntity; import org.apache.http.client.methods.HttpGet; import org.apache.http.client.methods.HttpPost; import org.apache.http.conn.params.ConnManagerParams; import org.apache.http.impl.client.DefaultHttpClient; import org.apache.http.params.HttpConnectionParams; import org.apache.http.params.HttpParams; // import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; // public class CustemHttpClient { /** The time it takes for our client to timeout */ public static final int HTTP_TIMEOUT = 30 * 1000; // milliseconds /** Single instance of our HttpClient */ private static HttpClient mHttpClient; /** * Get our single instance of our HttpClient object. * * @return an HttpClient object with connection parameters set */ private static HttpClient getHttpClient() { if (mHttpClient == null) { mHttpClient = new DefaultHttpClient(); final HttpParams params = mHttpClient.getParams(); HttpConnectionParams.setConnectionTimeout(params, HTTP_TIMEOUT); HttpConnectionParams.setSoTimeout(params, HTTP_TIMEOUT); ConnManagerParams.setTimeout(params, HTTP_TIMEOUT); } return mHttpClient; } /** * Performs an HTTP Post request to the specified url with the * specified parameters. * * @param url The web address to post the request to * @param postParameters The parameters to send via the request * @return The result of the request * @throws Exception */ public static String executeHttpPost(String url, ArrayList postParameters) throws Exception { BufferedReader in = null; try { HttpClient client = getHttpClient(); HttpPost request = new HttpPost(url); UrlEncodedFormEntity formEntity = new UrlEncodedFormEntity(postParameters); request.setEntity(formEntity); HttpResponse response = client.execute(request); in = new BufferedReader(new InputStreamReader(response.getEntity().getContent())); StringBuffer sb = new StringBuffer(""); String line = ""; String NL = System.getProperty("line.separator"); while ((line = in.readLine()) != null) { sb.append(line + NL); } in.close(); String result = sb.toString(); return result; } finally { if (in != null) { try { in.close(); } catch (IOException e) { e.printStackTrace(); }}}} public static String executeHttpGet(String url) throws Exception { BufferedReader in = null; try { HttpClient client = getHttpClient(); HttpGet request = new HttpGet(); request.setURI(new URI(url)); HttpResponse response = client.execute(request); in = new BufferedReader(new InputStreamReader(response.getEntity().getContent())); StringBuffer sb = new StringBuffer(""); String line = ""; String NL = System.getProperty("line.separator"); while ((line = in.readLine()) != null) { sb.append(line + NL); } in.close(); String result = sb.toString(); return result; } finally { if (in != null) { try { in.close(); } catch (IOException e) { e.printStackTrace(); }}}}}
package com.example.login2; import java.util.ArrayList; import org.apache.http.NameValuePair; import org.apache.http.message.BasicNameValuePair; import android.app.Activity; import android.content.Intent; import android.os.Bundle; import android.view.View; import android.widget.Button; import android.widget.EditText; import android.widget.TextView; public class login2 extends Activity { EditText un,pw; TextView error; Button ok; /** Called when the activity is first created. */ public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); un=(EditText)findViewById(R.id.et_un); pw=(EditText)findViewById(R.id.et_pw); ok=(Button)findViewById(R.id.btn_login); error=(TextView)findViewById(R.id.tv_error); ok.setOnClickListener(new View.OnClickListener() { public void onClick(View v) { // TODO Auto-generated method stub ArrayList<NameValuePair> postParameters = new ArrayList<NameValuePair>(); postParameters.add(new BasicNameValuePair("username", un.getText().toString())); postParameters.add(new BasicNameValuePair("password", pw.getText().toString())); //String valid = "1"; String response = null; try { //response = CustemHttpClient.executeHttpPost("http://engiguide.com/check.php", postParameters); //Enetr Your remote PHP,ASP, Servlet file link response = CustemHttpClient.executeHttpPost("http://10.0.2.2/at/fin/check3.php", postParameters);//il faut donner le chemin de la page php String res=response.toString(); error.setText("okkkk"); res = res.trim(); res= res.replaceAll("\\s+",""); error.setText(res); if(res.equals("1")) error.setText("Correct Username or Password"); else error.setText("Sorry!! Incorrect Username or Password"); } catch (Exception e) { //un.setText(e.toString()); error.setText("ereeeeeur"); }} }); } }
@Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); List nameValuePairs = new ArrayList(1); nameValuePairs.add(new BasicNameValuePair("Nom","Bennour")); nameValuePairs.add(new BasicNameValuePair("Prenom","Mohamed")); //http post try{ HttpClient httpclient = new DefaultHttpClient(); HttpPost httppost = new HttpPost("http://192.168.1.67/androServ.php"); httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs)); HttpResponse response = httpclient.execute(httppost); HttpEntity entity = response.getEntity(); InputStream is = entity.getContent(); Log.i("postData", response.getStatusLine().toString()); } catch(Exception e) { Log.e("log_tag", "Error in http connection "+e.toString()); } }
<?php if(isset($_POST) && !empty($_POST)){ extract($_POST); echo $Nom." ".$Prenom; } else{ echo "les données ne sont pas arrivées"; } ?>
je lance la page web coté serveur