Page 1 of 1

MySQL data interchange

Posted: Mon Jan 07, 2019 6:55 pm
by girija.mahapatra
Hi,

I have following requirement
1) Submit data in numerical/varchar format in a form, it is stored in a specific table in local MySQL DB : This is working fine
2) Data captured in MySQL is processed in a local algorithm and the result is written to another table in MySQL : This is working fine
3) Fetch the result from the result table and publish in webpage, by clicking a "Get Result" button: Fails

I used
1. mysqlconnector extension
2. dataviewer extension
3. mysqltableeditor extension

Nothing works. Also there is NO tutorial/usage instruction of any of these extensions in the WB14 User Guide. Neither there is any material available in internet.

Is there any guide/procedure available ? Or a tutorial ?

Re: MySQL data interchange

Posted: Mon Jan 07, 2019 7:02 pm
by Pablo
All my extensions include PDF documentation.
Click the 'Help' button in the proprieties to open the PDF.

Note that these extensions are from my personal collection and I shared them (for free) in case other users find then useful.
They are provided "AS IS". However, the extensions have been successful used by many other users. I would not have shared them if they did not work.
Also, if there were any known issues then I would have already fixed them.

Re: MySQL data interchange

Posted: Tue Jan 08, 2019 11:24 am
by girija.mahapatra
I am using "mysqlconnector extension" with PHP extension "MySQL Extension" and it is throwing the same error

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xxx\index.php:115 Stack trace: #0 {main} thrown in C:\xxx\inxed.php on line 115

My PHP is 7.x version.

Re: MySQL data interchange

Posted: Tue Jan 08, 2019 11:46 am
by WWBman
I think the PHP extension in MySQL Connector Properties should be MySQLi.

Re: MySQL data interchange

Posted: Tue Jan 08, 2019 12:12 pm
by Pablo
WWBman is correct, you should select the MySQLi extension.

Re: MySQL data interchange

Posted: Tue Jan 08, 2019 12:34 pm
by girija.mahapatra
I had checked with MySQLi and it had worked.

I need to use MySQL (mysql.dll) Extension, not MySQLi for certain reasons. The option is there in the drop down but giving error.

Am I missing anything?

Re: MySQL data interchange

Posted: Tue Jan 08, 2019 1:11 pm
by Pablo
maybe PHP on the server is not configured to use MySQL?
Also, note that new versions of PHP no longer support MySQL.

I do not think this has anything to do with the extension.

Re: MySQL data interchange

Posted: Tue Jan 08, 2019 1:18 pm
by girija.mahapatra
Got it. Effective PHP 7, php_mysql.dll is removed from dist.

php_pdo_mysql.dll is the new dll. I think this extension doesn't include the new dll, hence doesn't work with PHP 7.

Re: MySQL data interchange

Posted: Tue May 21, 2019 2:20 pm
by windsurfer
Hello
you'll have to excuse my ignorance but where can i change to mysqli ?

Re: MySQL data interchange

Posted: Tue May 21, 2019 2:26 pm
by WWBman
windsurfer wrote: Tue May 21, 2019 2:20 pm Hello
you'll have to excuse my ignorance but where can i change to mysqli ?
Which extension are you using?

Re: MySQL data interchange

Posted: Tue May 21, 2019 2:30 pm
by windsurfer
I am trying to work with the cms on my local host and i can look at the administration page but the content page shows
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\wamp\www\content.php:54 Stack trace: #0 {main} thrown in C:\wamp\www\content.php on line 54

Re: MySQL data interchange

Posted: Tue May 21, 2019 2:43 pm
by WWBman
If you select PHP 5+ in Page Properties (Advanced) for each CMS page and republish it will use mysqli

Re: MySQL data interchange

Posted: Tue May 21, 2019 3:04 pm
by windsurfer
Thank you

Re: MySQL data interchange

Posted: Tue May 21, 2019 4:53 pm
by windsurfer
i uploaded the demo and i selected several plugins. The plugins are uploaded but when i look at the admin i only see the Plugins drop down and only has the file manager in it.
Am i missing something ?
http://prntscr.com/nri6mv
http://prntscr.com/nri77e

Re: MySQL data interchange

Posted: Tue May 21, 2019 5:18 pm
by Pablo
Not all plugins do have a menu item.

Related tutorial:
http://wysiwygwebbuilder.com/cms_plugins.html