MySQL data interchange

[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 ?

[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.

[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.

[WWBman]

I think the PHP extension in MySQL Connector Properties should be MySQLi.

[Pablo]

WWBman is correct, you should select the MySQLi extension.

[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?

[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.

[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.

[windsurfer]

Hello
you'll have to excuse my ignorance but where can i change to mysqli ?

[WWBman]

Hello
you'll have to excuse my ignorance but where can i change to mysqli ?

Which extension are you using?

[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

[WWBman]

If you select PHP 5+ in Page Properties (Advanced) for each CMS page and republish it will use mysqli

[windsurfer]

Thank you

[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

[Pablo]

Not all plugins do have a menu item.

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