WebSite X5Help Center

 
Mike L.
Mike L.
User

What are the steps for setting up a Database also a Login and Password steps  en

Autor: Mike L.
Visitado 1729, Followers 1, Compartido 0  

What are the steps for setting up a Database also a Login and Password steps?

Publicado en
10 RESPUESTAS
Andre E
Andre E
Moderator
Usuario del mes EN

Paul,

Leer más
Publicado en de Andre E
Mike L.
Mike L.
User
Autor

Hi there thanks for the help, But I allready looked at the instructions in the f1 command. It is very plain.. Is there a way to see screen shots so I know what to look for and step by step to create a database? Also is there something I need to put in my Host were my files are stored?

Thanks

Mike

Leer más
Publicado en de Mike L.
Andre E
Andre E
Moderator
Usuario del mes EN

This window opens from the Add... command in the Data Management window, and you can define settings for a new database to link to the current project.

The Database Settings that you need to specify are:

Description: give the database a name so that you can identify it more easily.

Host Name: enter the URL address  of the SQL server where the database is stored online. The database is usually stored on the same server which hosts the website it is linked to, and so "localhost" is often used. Check with your provider that the database and website are on the same server.

Database Name: enter the name of the database you want to work on (you can obtain this from your provider).Username: enter the username (that your provider gives you) needed to access the online database.

Password: enter the password (that your provider gives you) needed to access the online database.


What's steps from the above helpfile does not help you ?

Maybe the host name part?

You need to login to your panel of your provider and create a database, that info, loginname, password an adress needs to be set in x5. Like described.

Hope this helps.

Leer más
Publicado en de Andre E
Mike L.
Mike L.
User
Autor

Thanks for the help..

I have a question.. The Host gave me a Code to put in my website.. This another spot I am lost in were to put it.

Leer más
Publicado en de Mike L.
Andre E
Andre E
Moderator
Usuario del mes EN

I don't know what code untill I see where it is related to.

You get a code for connection to your website address. (ftp adress with code)

And if you create a database you also get a password, login and database name.

You usually also get a code for connection to your acces panel of your hosting company.

But with "my host gave me a code" I can't do much. PLease add the full text that came with the code here, and replace the actual code witx xxx or something.

Thanks.

Leer más
Publicado en de Andre E
Mike L.
Mike L.
User
Autor

This is the code I am talking about. They want this on my website.

 <?php
$link = mysql_connect('mlynch68.ipagemysql.com', 'mikelynch_1', '*password*');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_select_db(dfs_newmembers_database);
?>

Below is part of the instructions I am lost on. THis came from my Host control panel

  1. In the Generate Code dialog, select the language for which you wish to create the connection string - Perl, PHP, ASP or Python
  2. As soon as you make your selection, the code window appears. It contains the connection string and other code necessary to connect to your database.
  3. Select all the code in the window and Ctrl-C to copy it
  4. Ctrl-V to paste this code into the appropriate place on your site, where you wish to connect to the database
Leer más
Publicado en de Mike L.
Andre E
Andre E
Moderator
Usuario del mes EN

this seems to be your username: mikelynch_1

mlynch68 your database name ?

fill these with password in x5 datamanagement.

I still miss 1 answer on a question;

Mike L.

Mike this is difficult to say if I don't know what you want.

You ussually don't need coding for standard x5 apps.

Leer más
Publicado en de Andre E
Mike L.
Mike L.
User
Autor

Andre,

I will try this and see if it works in a few days. What I wanted is a better explanation on Database.I think you gave it to me..Thanks for the help

MIke

Leer más
Publicado en de Mike L.