New at this. Please help.

[Pavlos1316]

Hi to you all,

Big problem. I have my page ready but i need help to create database and connect it with register and login pages. I am using dreamweaver. My friend that was going to help me is abroad for work so I am stuck here.

Can you help me please?

Thank you advance.

[Scott]

To create a database, login to cPanel then click on MySQL Databases. From there you will be presented with an easy walk-through to create the DB. Video on creating a MySQL DB. That video is based on X2 theme but still does the trick

[Pavlos1316]

Thanks a lot mate.

I will check it during the weekend.

[Scott]

No problem. Hope it helps you.

[Pavlos1316]

many thanks.

just today i found time to do it and it was pretty easy.

now can you give me guidelines on how to connect my database with my fields?

Thank you in advance

[lnxcode]

are you talking about connecting locally or external (remote)?

[Pavlos1316]

Hi
Sorry for late replies. I have a lot of work and little time for my web. For now at least.

It is for a local connection. I wrote an update.php file based in my allready written dreamweaver form but it doesn't seem to work. error HTTP 500

Here is what I wrote (for localhost I used localhost. Is it correct??)

<?php
$Name = $_Post['Name'];
$Surname = $_Post['Surname'];
$Birthday = $_Post['Birhday'];
$Phone_No = $_Post['Phone_No'];
$E_mail = $_Post['E_mail'];
$Mail_Address = $_Post['Mail_Address'];
$Username = $_Post['Username'];
$Password = $_Post['Password'];
$Conf_Password = $_Post['Conf_Password'];

mysql_connect ("localhost", "username", "password") or die ('Error: ' . mysql_error());
mysql_select_db ("sonophoe_Registration");

$query="INSETR INTO Register (ID, Name, Surname, Birthday, Phone_No, E_mail, Mail_Address, Username, Password, Conf_Password)VALUES ('NULL','"$Name"','"$Surname"','"$Birthday"','"$Ph one_No"','"$E_mail"','"$Mail_Adrdress"','"$Usernam e"','"$Password"','"$Conf_Password"')";mysql_query ($query) or die ('Error: Not Updated!!!');

echo "Database Update With: ".$Name." ".$Surname." ".$Birthday." ".$Phone_No." ".$E_mail." ".$Mail_Address." ".$Username." ".$Password." ".$Conf_Password."";
?>

Thank you in advance and for your patient.

[Pavlos1316]

Oh

I want to add that I have created mysql database with the above fields using cpanel.

[lnxcode]

Originally Posted by Pavlos1316

Oh

I want to add that I have created mysql database with the above fields using cpanel.

Hello,

What you should do is:

1. cpanel_x3_mysql

[itwasntme]

Originally Posted by Pavlos1316

$query="INSETR INTO Register (ID, Name, Surname, Birthday, Phone_No, E_mail, Mail_Address, Username, Password, Conf_Password)VALUES ('NULL','"$Name"','"$Surname"','"$Birthday"','"$Ph one_No"','"$E_mail"','"$Mail_Adrdress"','"$Usernam e"','"$Password"','"$Conf_Password"')";mysql_query ($query) or die ('Error: Not Updated!!!');

If this is the actual query you are using, you spelled INSERT wrong. That will definitely give you problems, but probably not a 500 error.

By the way, where did you get this code? It's not very secure. This is the second time I have seen something on the forums here very similar.