How to set database in X5 Pro 
Author: Gorg ..
Visited 5478,
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
Author
Here is my settings for newslatter sub. form;
[IMG]http://i.imgur.com/5zMvguv.jpg[/IMG]
[IMG]http://i.imgur.com/I8hyfoC.jpg[/IMG]
Author
Step 2
[URL=http://imgur.com/okMEdhm][IMG]http://i.imgur.com/okMEdhm.jpg[/IMG][/URL]
Hello Gorg,
Are the settings added in step 4 Datamanagement correct like host name, database name, usrname and password?
Many thanks!
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!
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
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,
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!