How to set database in X5 Pro
Autor: Gorg ..
Visitado 5420,
Followers 3,
Compartido 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/
Publicado en
Autor
Here is my settings for newslatter sub. form;
[IMG]http://i.imgur.com/5zMvguv.jpg[/IMG]
[IMG]http://i.imgur.com/I8hyfoC.jpg[/IMG]
Autor
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!
Autor
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
Autor
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!