Conecar no Mysql erro :

[juniorsatanas]

Estou seguindo um tutorial da net, para conectar no banco mysql mas nao funciona alguém ja fez isso ?

1. CREATE TABLE `people` ( 2. `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , 3. `name` VARCHAR( 100 ) NOT NULL , 4. `sex` BOOL NOT NULL DEFAULT '1', 5. `birthyear` INT NOT NULL 6. )

[code] 1.
<?php
2.
mysql_connect("host","username","password");
3.
mysql_select_db("PeopleData");
4.

5. $q=mysql_query(“SELECT * FROM people WHERE birthyear>’”.$_REQUEST[‘year’]."’");

6. while($e=mysql_fetch_assoc($q))

7.     $output[]=$e;
   

9. print(json_encode($output));

11. mysql_close();

12. ?>
    [/code]

[code] 1.
String result = “”;
2.
//the year data to send
3.
ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
4.
nameValuePairs.add(new BasicNameValuePair(“year”,“1980”));
5.

6. //http post

7. try{

8.     HttpClient httpclient = new DefaultHttpClient();
   

9.     HttpPost httppost = new HttpPost("http://example.com/getAllPeopleBornAfter.php");
   

10.     httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
    

11.     HttpResponse response = httpclient.execute(httppost);
    

12.     HttpEntity entity = response.getEntity();
    

13.     InputStream is = entity.getContent();
    

14. }catch(Exception e){

15.     Log.e("log_tag", "Error in http connection "+e.toString());
    

16. }

17. //convert response to string

18. try{

19.     BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8);
    

20.     StringBuilder sb = new StringBuilder();
    

21.     String line = null;
    

22.     while ((line = reader.readLine()) != null) {
    

23.             sb.append(line + "\n");
    

24.     }
    

25.     is.close();
    

27.     result=sb.toString();
    

28. }catch(Exception e){

29.     Log.e("log_tag", "Error converting result "+e.toString());
    

30. }

32. //parse json data

33. try{

34.     JSONArray jArray = new JSONArray(result);
    

35.     for(int i=0;i<jArray.length();i++){
    

36.             JSONObject json_data = jArray.getJSONObject(i);
    

37.             Log.i("log_tag","id: "+json_data.getInt("id")+
    

38.                     ", name: "+json_data.getString("name")+
    

39.                     ", sex: "+json_data.getInt("sex")+
    

40.                     ", birthyear: "+json_data.getInt("birthyear")
    

41.             );
    

42.     }
    

43. }

44. }catch(JSONException e){

45.     Log.e("log_tag", "Error parsing data "+e.toString());
    

46. }
    [/code]>