MySQL data interchange

Issues related to forms.
Post Reply
girija.mahapatra
 
 
Posts: 31
Joined: Tue Sep 26, 2017 10:22 am

MySQL data interchange

Post by girija.mahapatra » Mon Jan 07, 2019 6:55 pm

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 ?

User avatar
Pablo
 
Posts: 16045
Joined: Tue Mar 28, 2006 12:00 pm
Location: Europe
Contact:

Re: MySQL data interchange

Post by Pablo » Mon Jan 07, 2019 7:02 pm

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
 
 
Posts: 31
Joined: Tue Sep 26, 2017 10:22 am

Re: MySQL data interchange

Post by girija.mahapatra » Tue Jan 08, 2019 11:24 am

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
 
 
Posts: 660
Joined: Fri Jan 08, 2010 6:10 pm

Re: MySQL data interchange

Post by WWBman » Tue Jan 08, 2019 11:46 am

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

User avatar
Pablo
 
Posts: 16045
Joined: Tue Mar 28, 2006 12:00 pm
Location: Europe
Contact:

Re: MySQL data interchange

Post by Pablo » Tue Jan 08, 2019 12:12 pm

WWBman is correct, you should select the MySQLi extension.

girija.mahapatra
 
 
Posts: 31
Joined: Tue Sep 26, 2017 10:22 am

Re: MySQL data interchange

Post by girija.mahapatra » Tue Jan 08, 2019 12:34 pm

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?

User avatar
Pablo
 
Posts: 16045
Joined: Tue Mar 28, 2006 12:00 pm
Location: Europe
Contact:

Re: MySQL data interchange

Post by Pablo » Tue Jan 08, 2019 1:11 pm

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
 
 
Posts: 31
Joined: Tue Sep 26, 2017 10:22 am

Re: MySQL data interchange

Post by girija.mahapatra » Tue Jan 08, 2019 1:18 pm

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
 
 
Posts: 35
Joined: Mon May 13, 2019 9:15 pm

Re: MySQL data interchange

Post by windsurfer » Tue May 21, 2019 2:20 pm

Hello
you'll have to excuse my ignorance but where can i change to mysqli ?
I used to have a photographic memory but i ran out of film !!!

WWBman
 
 
Posts: 660
Joined: Fri Jan 08, 2010 6:10 pm

Re: MySQL data interchange

Post by WWBman » Tue May 21, 2019 2:26 pm

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?

windsurfer
 
 
Posts: 35
Joined: Mon May 13, 2019 9:15 pm

Re: MySQL data interchange

Post by windsurfer » Tue May 21, 2019 2:30 pm

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
I used to have a photographic memory but i ran out of film !!!

WWBman
 
 
Posts: 660
Joined: Fri Jan 08, 2010 6:10 pm

Re: MySQL data interchange

Post by WWBman » Tue May 21, 2019 2:43 pm

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

windsurfer
 
 
Posts: 35
Joined: Mon May 13, 2019 9:15 pm

Re: MySQL data interchange

Post by windsurfer » Tue May 21, 2019 3:04 pm

Thank you
I used to have a photographic memory but i ran out of film !!!

windsurfer
 
 
Posts: 35
Joined: Mon May 13, 2019 9:15 pm

Re: MySQL data interchange

Post by windsurfer » Tue May 21, 2019 4:53 pm

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
I used to have a photographic memory but i ran out of film !!!

User avatar
Pablo
 
Posts: 16045
Joined: Tue Mar 28, 2006 12:00 pm
Location: Europe
Contact:

Re: MySQL data interchange

Post by Pablo » Tue May 21, 2019 5:18 pm

Not all plugins do have a menu item.

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

Post Reply