Page 2 of 2

Re: HBTIP, PHP, MySQL and ofcourse HMG

Posted: Wed Feb 04, 2009 5:41 am
by Rathinagiri
So, by this way, we can filter the usage of sql.

Thanks for the nice code Raumi. :)

Re: HBTIP, PHP, MySQL and ofcourse HMG

Posted: Wed Feb 04, 2009 11:53 am
by Roberto Lopez
rathinagiri wrote:Here is a small sample to connect to a MySQL database through a small PHP script using HBTIP.
<...>
I've give a deeper look and tested your program.

It's a really nice piece of code!

The better of this model, is that you can have web and desktop clients using the same simple, standard server infrastructure.

Congratulations.

Regards,

Roberto.

Re: HBTIP, PHP, MySQL and ofcourse HMG

Posted: Thu Feb 05, 2009 3:42 am
by Rathinagiri
Thanks a lot Roberto.

Re: HBTIP, PHP, MySQL and ofcourse HMG

Posted: Wed Jul 22, 2009 2:29 pm
by Roberto Lopez
rathinagiri wrote:Here is a small sample to connect to a MySQL database through a small PHP script using HBTIP.

This is acutally a preliminary one. Don't try this in live data.
<...>
I'm working again with MySql and I've found two problems:

The server refuses to execute a PHP script when it is invoked from an HMG applications (like yours) with a 403 error. It previously worked fine on this host (ByetHost). I've solved trying another free service and worked, but the server automatically added HTML at the beginning and to the end to the data sent by the script, creating a problem (the data should be filtered).

Had you experienced such problems?

There is any way to avoid (both) them.

TIA.

Regards,

Roberto.

Re: HBTIP, PHP, MySQL and ofcourse HMG

Posted: Wed Jul 22, 2009 3:05 pm
by Roberto Lopez
Roberto Lopez wrote:
rathinagiri wrote:Here is a small sample to connect to a MySQL database through a small PHP script using HBTIP.

This is acutally a preliminary one. Don't try this in live data.
<...>
I'm working again with MySql and I've found two problems:

The server refuses to execute a PHP script when it is invoked from an HMG applications (like yours) with a 403 error. It previously worked fine on this host (ByetHost). I've solved trying another free service and worked, but the server automatically added HTML at the beginning and to the end to the data sent by the script, creating a problem (the data should be filtered).

Had you experienced such problems?

There is any way to avoid (both) them.

TIA.

Regards,

Roberto.
I've solved the first problem (html content returned). It was my mistake (using hbtip, not a server problem).

Regarding the http error 403 trying to execute scripts from applications (working fine from browser) stills unsolved.

Regards,

Roberto.

Re: HBTIP, PHP, MySQL and ofcourse HMG

Posted: Wed Jul 22, 2009 3:41 pm
by Rathinagiri
I will try today and come with the results, Roberto.

Re: HBTIP, PHP, MySQL and ofcourse HMG

Posted: Wed Jul 22, 2009 4:07 pm
by Roberto Lopez
rathinagiri wrote:I will try today and come with the results, Roberto.
Thanks!

Regards,

Roberto.

Re: HBTIP, PHP, MySQL and ofcourse HMG

Posted: Thu Jul 23, 2009 1:16 am
by Roberto Lopez
rathinagiri wrote:I will try today and come with the results, Roberto.
Well... I've tested other servers and the problem not occurred again.

I guess that the problem could be related to byethost only. Maybe they check for client browser name and version.

This is the only explanation that comes to me right now...

Sorry to disturb you with this.

Regards,

Roberto.

Re: HBTIP, PHP, MySQL and ofcourse HMG

Posted: Thu Jul 23, 2009 3:09 am
by Rathinagiri
No problem Roberto.

I too had checked with my host. It doesn't give any problem here.
Maybe they check for client browser name and version.
In that case, what can we do?!

Re: HBTIP, PHP, MySQL and ofcourse HMG

Posted: Thu Jul 23, 2009 1:12 pm
by Roberto Lopez
rathinagiri wrote:No problem Roberto.

I too had checked with my host. It doesn't give any problem here.
Maybe they check for client browser name and version.
In that case, what can we do?!
I don't know.

I have not enough free time now, but we'll should start reviewing HBTIP code, maybe the answer be there.

Regards,

Roberto.