HBTIP, PHP, MySQL and ofcourse HMG

HMG Samples and Enhancements

Moderator: Rathinagiri

User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: HBTIP, PHP, MySQL and ofcourse HMG

Post by Rathinagiri »

So, by this way, we can filter the usage of sql.

Thanks for the nice code Raumi. :)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: HBTIP, PHP, MySQL and ofcourse HMG

Post 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.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: HBTIP, PHP, MySQL and ofcourse HMG

Post by Rathinagiri »

Thanks a lot Roberto.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: HBTIP, PHP, MySQL and ofcourse HMG

Post 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.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: HBTIP, PHP, MySQL and ofcourse HMG

Post 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.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: HBTIP, PHP, MySQL and ofcourse HMG

Post by Rathinagiri »

I will try today and come with the results, Roberto.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: HBTIP, PHP, MySQL and ofcourse HMG

Post by Roberto Lopez »

rathinagiri wrote:I will try today and come with the results, Roberto.
Thanks!

Regards,

Roberto.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: HBTIP, PHP, MySQL and ofcourse HMG

Post 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.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: HBTIP, PHP, MySQL and ofcourse HMG

Post 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?!
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: HBTIP, PHP, MySQL and ofcourse HMG

Post 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.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
Post Reply