[android-beginners] Re: connecting to a remote database tutorial/example?
hi jbrohan,
I am new in android as well as no java programming experienced. I had
tried the example provided here. however, it doesnt work for me as it
just return error. Can you provide me some guidance?
On Oct 25, 3:29 am, jbrohan jbro...@gmail.com wrote:
Hello
I need to look up a database in my app. I'll be doing it next week I
expect. For the moment the php just returns a constant.
?php
$do = $_REQUEST['do'];
if ($do == groupphone){
$phone=trim($_REQUEST['phone']);
$phone=str_replace(array('.','(',')','-',' ','+'),'',$phone);
if (substr($phone,0,1) == '1') $phone = substr($phone,1); // remove
'1'
echo error; // initial testing}elseif($do == startgroup){
echo xyz;
...
the java that does the call to the php program on the server is...
public String callWebPage(String URLstring, String parameters){
String s;
try {
URL updateURL = new URL(URLstring+parameters);
URLConnection conn = updateURL.openConnection();
InputStream is = conn.getInputStream();
BufferedInputStream bis = new BufferedInputStream(is);
ByteArrayBuffer baf = new ByteArrayBuffer(50);
Log.e(SettingsDialog, after the call to web);
int current = 0;
while((current = bis.read()) != -1){
baf.append((byte)current);
}
Log.e(SettingsDialog, back from web page+parameters);
/* Convert the Bytes read to a String. */
s = new String(baf.toByteArray());
Log.e(SettingsDialog, String.format(in callWebPage =
%s ,s));
return s;
} catch (Exception e) {
Log.e(SettingsDialog, exception in callWebPage);
}
return error;
}
And the setup of the URLstring is...s = callWebPage(Constants.WebCall,
?do=groupphonephone=+s); what the php script echoed is in s.
It seems to be very reliable.
It's worthwhile running your script from a browser first to make sure
that it works.
Good Luck
John
On Oct 24, 11:21 am, gmseed gms...@gmail.com wrote:
Hi
I'm developing an application to connect to a database on my website.
Does anyone know of a link to an example/tutorial in which this kind
of operation is performed?
Thanks
Graham
--
You received this message because you are subscribed to the Google
Groups Android Beginners group.
To post to this group, send email to android-beginners@googlegroups.com
To unsubscribe from this group, send email to
android-beginners+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-beginners?hl=en
[android-beginners] Re: connecting to a remote database tutorial/example?
Hi
Thanks for explaining how you connect. I too use PHP, so I'll give it
a go.
I was wondering if anyone had seen an example of using the URI
connection string in connecting to a database such as MySQL an using
Java's JDBC. That way, connecting direct to the database.
Cheers
Graham
On 25 Oct, 11:29, jbrohan jbro...@gmail.com wrote:
Hello
I need to look up a database in my app. I'll be doing it next week I
expect. For the moment the php just returns a constant.
?php
$do = $_REQUEST['do'];
if ($do == groupphone){
$phone=trim($_REQUEST['phone']);
$phone=str_replace(array('.','(',')','-',' ','+'),'',$phone);
if (substr($phone,0,1) == '1') $phone = substr($phone,1); // remove
'1'
echo error; // initial testing}elseif($do == startgroup){
echo xyz;
...
the java that does the call to the php program on the server is...
public String callWebPage(String URLstring, String parameters){
String s;
try {
URL updateURL = new URL(URLstring+parameters);
URLConnection conn = updateURL.openConnection();
InputStream is = conn.getInputStream();
BufferedInputStream bis = new BufferedInputStream(is);
ByteArrayBuffer baf = new ByteArrayBuffer(50);
Log.e(SettingsDialog, after the call to web);
int current = 0;
while((current = bis.read()) != -1){
baf.append((byte)current);
}
Log.e(SettingsDialog, back from web page+parameters);
/* Convert the Bytes read to a String. */
s = new String(baf.toByteArray());
Log.e(SettingsDialog, String.format(in callWebPage =
%s ,s));
return s;
} catch (Exception e) {
Log.e(SettingsDialog, exception in callWebPage);
}
return error;
}
And the setup of the URLstring is...s = callWebPage(Constants.WebCall,
?do=groupphonephone=+s); what the php script echoed is in s.
It seems to be very reliable.
It's worthwhile running your script from a browser first to make sure
that it works.
Good Luck
John
On Oct 24, 11:21 am, gmseed gms...@gmail.com wrote:
Hi
I'm developing an application to connect to a database on my website.
Does anyone know of a link to an example/tutorial in which this kind
of operation is performed?
Thanks
Graham
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups Android Beginners group.
To post to this group, send email to android-beginners@googlegroups.com
To unsubscribe from this group, send email to
android-beginners+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-beginners?hl=en
-~--~~~~--~~--~--~---
[android-beginners] Re: connecting to a remote database tutorial/example?
Hi Again
I came across the following link:
http://forums.devshed.com/java-help-9/jdbc-connecting-to-web-database-647416.html
which discusses connecting to a remote database using JDBC, with the
author noting that remote access had to be enabled with his web
hoster.
Cheers
Graham
On 26 Oct, 13:43, gmseed gms...@gmail.com wrote:
Hi
Thanks for explaining how you connect. I too use PHP, so I'll give it
a go.
I was wondering if anyone had seen an example of using the URI
connection string in connecting to a database such as MySQL an using
Java's JDBC. That way, connecting direct to the database.
Cheers
Graham
On 25 Oct, 11:29, jbrohan jbro...@gmail.com wrote:
Hello
I need to look up a database in my app. I'll be doing it next week I
expect. For the moment the php just returns a constant.
?php
$do = $_REQUEST['do'];
if ($do == groupphone){
$phone=trim($_REQUEST['phone']);
$phone=str_replace(array('.','(',')','-',' ','+'),'',$phone);
if (substr($phone,0,1) == '1') $phone = substr($phone,1); // remove
'1'
echo error; // initial testing}elseif($do == startgroup){
echo xyz;
...
the java that does the call to the php program on the server is...
public String callWebPage(String URLstring, String parameters){
String s;
try {
URL updateURL = new URL(URLstring+parameters);
URLConnection conn = updateURL.openConnection();
InputStream is = conn.getInputStream();
BufferedInputStream bis = new BufferedInputStream(is);
ByteArrayBuffer baf = new ByteArrayBuffer(50);
Log.e(SettingsDialog, after the call to web);
int current = 0;
while((current = bis.read()) != -1){
baf.append((byte)current);
}
Log.e(SettingsDialog, back from web page+parameters);
/* Convert the Bytes read to a String. */
s = new String(baf.toByteArray());
Log.e(SettingsDialog, String.format(in callWebPage =
%s ,s));
return s;
} catch (Exception e) {
Log.e(SettingsDialog, exception in callWebPage);
}
return error;
}
And the setup of the URLstring is...s = callWebPage(Constants.WebCall,
?do=groupphonephone=+s); what the php script echoed is in s.
It seems to be very reliable.
It's worthwhile running your script from a browser first to make sure
that it works.
Good Luck
John
On Oct 24, 11:21 am, gmseed gms...@gmail.com wrote:
Hi
I'm developing an application to connect to a database on my website.
Does anyone know of a link to an example/tutorial in which this kind
of operation is performed?
Thanks
Graham
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups Android Beginners group.
To post to this group, send email to android-beginners@googlegroups.com
To unsubscribe from this group, send email to
android-beginners+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-beginners?hl=en
-~--~~~~--~~--~--~---
[android-beginners] Re: connecting to a remote database tutorial/example?
Hello
I need to look up a database in my app. I'll be doing it next week I
expect. For the moment the php just returns a constant.
?php
$do = $_REQUEST['do'];
if ($do == groupphone){
$phone=trim($_REQUEST['phone']);
$phone=str_replace(array('.','(',')','-',' ','+'),'',$phone);
if (substr($phone,0,1) == '1') $phone = substr($phone,1); // remove
'1'
echo error; // initial testing
}elseif($do == startgroup){
echo xyz;
...
the java that does the call to the php program on the server is...
public String callWebPage(String URLstring, String parameters){
String s;
try {
URL updateURL = new URL(URLstring+parameters);
URLConnection conn = updateURL.openConnection();
InputStream is = conn.getInputStream();
BufferedInputStream bis = new BufferedInputStream(is);
ByteArrayBuffer baf = new ByteArrayBuffer(50);
Log.e(SettingsDialog, after the call to web);
int current = 0;
while((current = bis.read()) != -1){
baf.append((byte)current);
}
Log.e(SettingsDialog, back from web page+parameters);
/* Convert the Bytes read to a String. */
s = new String(baf.toByteArray());
Log.e(SettingsDialog, String.format(in callWebPage =
%s ,s));
return s;
} catch (Exception e) {
Log.e(SettingsDialog, exception in callWebPage);
}
return error;
}
And the setup of the URLstring is...s = callWebPage(Constants.WebCall,
?do=groupphonephone=+s); what the php script echoed is in s.
It seems to be very reliable.
It's worthwhile running your script from a browser first to make sure
that it works.
Good Luck
John
On Oct 24, 11:21 am, gmseed gms...@gmail.com wrote:
Hi
I'm developing an application to connect to a database on my website.
Does anyone know of a link to an example/tutorial in which this kind
of operation is performed?
Thanks
Graham
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups Android Beginners group.
To post to this group, send email to android-beginners@googlegroups.com
To unsubscribe from this group, send email to
android-beginners+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-beginners?hl=en
-~--~~~~--~~--~--~---
[android-beginners] Re: connecting to a remote database tutorial/example?
I have never tried connecting to a hosted DB within android app. maybe you should consider using a webservice either SOAP or RESTful. On Sat, Oct 24, 2009 at 11:21 AM, gmseed gms...@gmail.com wrote: Hi I'm developing an application to connect to a database on my website. Does anyone know of a link to an example/tutorial in which this kind of operation is performed? Thanks Graham --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Android Beginners group. To post to this group, send email to android-beginners@googlegroups.com To unsubscribe from this group, send email to android-beginners+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-beginners?hl=en -~--~~~~--~~--~--~---
