WebSite X5Help Center

 
Gorg ..
Gorg ..
User

How to set database in X5 Pro  en

Author: Gorg ..
Visited 4397, Followers 3, Shared 0  

Hi,

can anyone explain how to set database for newslatter subscription, automatic registracion, and for shoping cart too.

What is procedure step by step about that.

I create one MySQL base on my server, set email form to store data into base..but it sad Unable to connect ...

Here is my test page http://www.natsep.2awebdesign.net/

Posted on the
7 ANSWERS
Incomedia
Claudio D.
Incomedia

Hello Gorg,

Are the settings added in step 4 Datamanagement correct like host name, database name, usrname and password?

Many thanks!

Read more
Posted on the from Claudio D.
Gorg ..
Gorg ..
User
Author

Yes it is !

I set database name and database user name and pass correct !

But form didnt comunicate with database, as you see!?

What is value to <name>atrubut - is that same as *Ime* as it is in my form field name, or something ellse....?

What is *Database field name* ...?

Why Incomedia didnt make one short video tuturial *step by step* for that...it is shot way to show us how to do that settings, for mail form and for Shoping cart too !? Isnt it ?

Thanks in advance!

Read more
Posted on the from Gorg ..
Paul M.
Paul M.
Moderator

Hello Gorg,

Your settings don't look like valid MySQL database settings.

If you are getting "Unable to connect" error messages, then your host name, database name, username and password are wrong.  These need to be exactly the same as those specified by your webhost who hosts the MySQL database for you.  These details will be unique to your webhost and won't bear any relation to any WebSite X5 credentials.

If your WebSite X5 project is hosted on the same server as your MySQL database then you should be able to use 'localhost' as the hostname.

The <name> attribute field is only of use when sending data to a script (e.g. PHP) so that doesn't apply in this case.

The Database Field Name option allows you to give your database fields meaningful names which will help you refer to them and work with them.  If you don't give each field in the form a name then the database will still work...  however, WebSite X5 will automatically allocate field names such as Field 0, Field 1, Field 2, etc. which is obviously not as useful.

Kind regards,

Paul

Read more
Posted on the from Paul M.
Gorg ..
Gorg ..
User
Author

Hi Paul,

i use *localhost* but in my server is not that case - I change that and database and form comunicate well - data is stored into base now !!!

Is the same way for shoping cart ?

X5 create all field for me, and stores all data and photos into base? Am I right, or must make some other tweaks for that case!?

All the best,

Read more
Posted on the from Gorg ..
Incomedia
Claudio D.
Incomedia

Hello Gorg,

Yes also for the cart WebSite X5 will create all fields automatically and store the informations.

There's no need for any tweak or adjustment.

Many thanks!

Read more
Posted on the from Claudio D.