MySQL data interchange

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

MySQL data interchange

Post 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 ?
User avatar
Pablo
 
Posts: 21574
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: MySQL data interchange

Post 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.
girija.mahapatra
 
 
Posts: 8
Joined: Tue Sep 26, 2017 10:22 am

Re: MySQL data interchange

Post 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.
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Re: MySQL data interchange

Post by WWBman »

I think the PHP extension in MySQL Connector Properties should be MySQLi.
User avatar
Pablo
 
Posts: 21574
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: MySQL data interchange

Post by Pablo »

WWBman is correct, you should select the MySQLi extension.
girija.mahapatra
 
 
Posts: 8
Joined: Tue Sep 26, 2017 10:22 am

Re: MySQL data interchange

Post 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?
User avatar
Pablo
 
Posts: 21574
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: MySQL data interchange

Post 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.
girija.mahapatra
 
 
Posts: 8
Joined: Tue Sep 26, 2017 10:22 am

Re: MySQL data interchange

Post 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.
windsurfer
 
 
Posts: 181
Joined: Mon May 13, 2019 9:15 pm

Re: MySQL data interchange

Post by windsurfer »

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

Re: MySQL data interchange

Post 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?
windsurfer
 
 
Posts: 181
Joined: Mon May 13, 2019 9:15 pm

Re: MySQL data interchange

Post 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
I used to have a photographic memory but i ran out of film !!!
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Re: MySQL data interchange

Post by WWBman »

If you select PHP 5+ in Page Properties (Advanced) for each CMS page and republish it will use mysqli
windsurfer
 
 
Posts: 181
Joined: Mon May 13, 2019 9:15 pm

Re: MySQL data interchange

Post by windsurfer »

Thank you
I used to have a photographic memory but i ran out of film !!!
windsurfer
 
 
Posts: 181
Joined: Mon May 13, 2019 9:15 pm

Re: MySQL data interchange

Post 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
I used to have a photographic memory but i ran out of film !!!
User avatar
Pablo
 
Posts: 21574
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: MySQL data interchange

Post by Pablo »

Not all plugins do have a menu item.

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