Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
15
Erster Beitrag:
vor 7 Monaten, 2 Wochen
Letzter Beitrag:
vor 3 Monaten, 1 Woche
Beteiligte Autoren:
Yogi Yang, Firetox / Emidev, firetox, Emidev, Emidev / Firetox

PHP4WD & PHP4WM version 9.1.0.0

Startbeitrag von Emidev / Firetox am 04.01.2017 11:08

hello everybody

happy new year for all and this year 2017 can give you what you want.

this year i have work on php4WD and php4WM
i create videos (but only in french for the time) for looking how it's works

the project has been modified for working qith ADO and ODB now it's possible to connect android and IOS on every bases works with php (MySQL, SQLserver, PostGreSQL, Oracle, SQLite and all of bases accesible with ADO)

i have created a youtube video for demonstating how it's work :https://www.youtube.com/channel/UCRCQH7SEudK1duTH7mIauuA
in french but if anyone want to make video in english or another language why not

best regards on all
and don't forget that the best way to have a response is to post question on the official forum or here

Firetox : Emprin Frederic (or EMIDEV on the net)

Antworten:

Re: PHP4WD & PHP4WM version 9.1.0.0

Hello,

From where can I download this new version?

TIA

Yogi Yang

von Yogi Yang - am 12.01.2017 04:56

Re: PHP4WD & PHP4WM version 9.1.0.0

hello

from here : PHP4WD / PHP4WM

best regards

von Firetox / Emidev - am 12.01.2017 16:56

Re: PHP4WD & PHP4WM version 9.1.0.0

Oh!! For W21..!!! That is bad news for me.

Any chance of releasing the new version or WD 20?

TIA

Yogi Yang

von Yogi Yang - am 13.01.2017 10:47

Re: PHP4WD & PHP4WM version 9.1.0.0

hello

no look in the page you have the version for windev 19, 20 and 21
the script php (coonect.php and php4wd.php are the same for all verions of windev ) the class too but i have mde the class in windev 19 and juste open it on 20 et 21 then the code is the same but the version of windev change

Télécharger PHP4WD 8.6.0.0 (scripts + Classe windev 20 (c_PHP4WD.wdc) et Windev Mobile 20 (c_PHP4WM.wdc) ) : PHP4WD-VM 8.6.0.0-20
Télécharger PHP4WD 8.6.0.0 (scripts + Classe windev 19 (c_PHP4WD.wdc) et Windev Mobile 19 (c_PHP4WM.wdc) ) : PHP4WD-VM 8.6.0.0-19

then choose your version

best regards
Firetox

von Firetox / Emidev - am 13.01.2017 10:55

Re: PHP4WD & PHP4WM version 9.1.0.0

Hello

for windev 22 you have just to get the version for windev21 and add classes in your project (i do the same thing for version 20 et 21 with getting the windev 19 version of the classes)

best regards

von Firetox / Emidev - am 13.01.2017 10:57

Re: PHP4WD & PHP4WM version 9.1.0.0

Quote
Firetox / Emidev
Télécharger PHP4WD 8.6.0.0 (scripts + Classe windev 20 (c_PHP4WD.wdc) et Windev Mobile 20 (c_PHP4WM.wdc) ) : PHP4WD-VM 8.6.0.0-20
Télécharger PHP4WD 8.6.0.0 (scripts + Classe windev 19 (c_PHP4WD.wdc) et Windev Mobile 19 (c_PHP4WM.wdc) ) : PHP4WD-VM 8.6.0.0-19

Yes. But this is version 8.6.0.0 and not 9.1.0.0

TIA

Yogi Yang

von Yogi Yang - am 13.01.2017 14:20

Re: PHP4WD & PHP4WM version 9.1.0.0

hello

yes because the version 9.1.0.0 is for windev 21
and for no making mystake about version the windev 20 et 19 are named 8.6.0.0
but the script php are in 9.1.0.0 for all

the version 8.6.0.0 are made because lot of user demand it and i did'nt want to have the same number for the new version : the 9.1.0.0 was the only one active and for windev 21 and more

best regards

von Firetox / Emidev - am 13.01.2017 14:27

Re: PHP4WD & PHP4WM version 9.1.0.0

Hello,

Oh! Ok!

Thanks for sharing your hard work. I have used your lib in one instance and have started loving it!

Regards,

Yogi Yang

von Yogi Yang - am 16.01.2017 04:25

Re: PHP4WD & PHP4WM version 9.1.0.0

Hello,
I think there i a bug in PHP4WM. I have not tested the other.

The Bug is that if we set UTF8Mode property to true then we stop getting any data and no error is also generated.

AccessMySQL is c_Php4WM()
AccessMySQL.UTF8Mode = True


If we set the UTF8Mode property to False everything works well.

But then we cannot get UNICODE content from MySQL because all text comes as ????? (question marks) only.

TIA,

von Yogi Yang - am 09.04.2017 15:02

Re: PHP4WD & PHP4WM version 9.1.0.0

hello

no utf8mode is for only certain configuration (perhaps the names is not adequate)
for your porblem you must use in the last version you have to use the member alphabet and the windev correct code in windev like the video for this on youtube : https://www.youtube.com/watch?v=l5eQwQs6lRA

attention on the line in php4wd.php :
header ('Content-type:text/html; charset=utf-8');

if not exists this line take thios an test for look if it's work or take the good charset for your base ans make sur that you have the same reulst in ineternet explorer with le line test (http:// ................./ php4wd.php?test=OUI) but if you are in windev 19 or 20 or 21 the classes and scripts are having the good code in this version

PHP4WD 9.1.0.0 contain this for having or modify what you want to work

von Emidev - am 09.04.2017 17:19

Re: PHP4WD & PHP4WM version 9.1.0.0

Hello,

I am getting following output in Firefox
Quote

version script : 9.1.0.1 du 10/01/2016
ERREUR CONNEXION : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


TIA

von Yogi Yang - am 10.04.2017 12:09

Re: PHP4WD & PHP4WM version 9.1.0.0

hello
you must have to change this in php4wd.php for the mode test

/***********************************************************************************************/
/* pour test du fichier en ligne de commande a mettre en commentaire avant passage a windev */
/***********************************************************************************************/
if($_GET['test']=='OUI'){
error_reporting($e & (E_ALL -E_WARNING -E_NOTICE));
$typeBase = 'ADO';
$cmds[] = 'SELECT * FROM dbo.CONTACTS';
echo "version script : 9.1.0.1 du 10/01/2016";
}
/***********************************************************************************************/


$typeBase = 'MYSQL';
choosing your base for mySQL for example

$cmds[] = 'SELECT * FROM dbo.CONTACTS';
for the query executing in the test mode you can change (here the query for SQLserver)

best regards

von firetox - am 11.04.2017 07:40

Re: PHP4WD & PHP4WM version 9.1.0.0

Hello,

Thank you for the instructions.

I changed the code as follows:

$typeBase = 'MYSQL';
$cmds[] = 'SELECT * FROM faq';


Here is the output that I am getting:
Quote

version script : 9.1.0.1 du 10/01/2016
--DEBUTSQL--PHP4WDSEPfaq_idPHP4WDSEPfaq_questionPHP4WDSEPfaq_answerPHP4WDSEP--LIGNES--PHP4WDSEP1PHP4WDSEPQ1PHP4WDSEP

Ans 1

Para 2.
PHP4WDSEP--BINDVARIABLE--PHP4WDSEP--FINSQL--PHP4WDSEP


TIA

von Yogi Yang - am 11.04.2017 13:26

Re: PHP4WD & PHP4WM version 9.1.0.0

Hello Again,

I have defined the Data Structure of MySQL Database Table as follows to store Mobile Identifier values:

CREATE TABLE `push_service` (
`ps_id` int(11) NULL,
`ps_mobile_id` text NULL,
`ps_service_type` int(11) NULL,
`ps_custom_info` text NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


Yet following code will not save data in MySQL why?

sSql = "INSERT INTO `push_service`(`ps_mobile_id`, `ps_service_type`) VALUES ('%1','%2')"
sSql = StringBuild(sSql,bufIdentifier,typeAndroidService) //Data in varialbe - bufIdentifier - is binary

bRetCode = AccessMySQL.mySQLExec(sSql, 0)


If I modify above code and encode the variable (bufIdentifier) content using URLEncode the I am able to save the record in MySQL not otherwise. But then encoding converts the bufIdentifier to the same string representation on all mobiles that I tested. I tested on LG, Samsung, Mi and Gionee smart mobiles. So there seems to be some other problem here which I am not able to understand here.

In MySQL if I set the field type of ps_mobile_id as binary then its length can only be of 255.

If I want to store bigger size content then I have to set it to either Blob or Text type.

What mistake am I making ? Can someone please help?

PS. I am using WM20 in this particular case.

TIA

von Yogi Yang - am 06.05.2017 04:48
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.