How can I create tables for my mySQL Database?

[nyakerz]

I have a website that will utilize mySQL database.

I've watched the video tutorial and I learn how to create database online but, the video doesn't cover how to create tables for my database.

Any help would be greatly appreciated.

-nyakerz

[akkudreamz]

login to your cpanel
under the databases section you'll find phpmyadmin click on it
from there you can create your tables and do other stuff to your database....

[neteater]

as i now tables are created automaticaly am i right

[akkudreamz]

as i now tables are created automaticaly am i right

yeah!! when you are working with a CMS or another similar tool that comes with an installation script that installs the tables for you
not otherwise :P

[freecrm]

Either use CMS or get to grips with myphpadmin, which allows you create whatever tables you want, with any field definition.

I always prefer to use myphpadmin to do back-end work.

[nyakerz]

Hey guys, thanks for the tips. I found it now.


**EDIT**

I just wanted to ask a follow up question.

1. ASP.NET and mySQL needs OdbcConnector for the web application to connect to the database. Is there an OdbcConnector on the server? If there is, what is the version?

I use odbc connector 3.51.27 that's why I'm thinking if ever, version will make them incompatible.

2. I wanted to make a site that sends emails to my friends. I've read about several tutorials and tried on my own but none of them works for me. I saw that we, members, have our own mailing system (or whatsoever it is called). How can I utilize that into my ASP.NET 3.5 web application?

**EDIT**

I think I'm going to use one of these mail servers:

Outgoing Mail Server: mail.nyakerz.x10hosting.com (server requires authentication) port 25
Outgoing Mail Server: (SSL) stoli.x10hosting.com (server requires authentication) port 465

Most likely the one with the port 25.

I found a tutorial in the internet about sending email with ASP.NET

Here is the code:

web.config:

<system.net>
<mailSettings>
<smtp from="test@foo.com">
<network host="mail.nyakerz.x10hosting.com" port="25" userName="username" password="password" defaultCredentials="true" />
</smtp>
</mailSettings>
</system.net>

Main code:

Try
Dim message As MailMessage = New MailMessage
message.From = New MailAddress("geng@nyakerz.x10hosting.com")
message.To.Add(New MailAddress(txtEmail.Text))
message.Subject = "Nyakerz"
message.Body = "Nyakerz"

Dim client As SmtpClient = New SmtpClient
client.Send(message)
Catch ex As Exception
MsgBox("Sending Failed " & ex.Message)
End Try

Error:

Sending Failed Failure sending mail.

[freecrm]

Can I ask why you are using ASP instead of the usual php?

php connects naturally with MySQL. ASP ( I Believe) partners naturally with SQL

If you use php, you don't need to go down the ODBC connector route at all.

And yes, you can have a php site that sends e-mails to your friends. My site does this as part of user function. (Its Free!)

[nyakerz]

Good question.

Projects I created usually are desktop applications and I use Visual Basic 6.0 or Visual Basic .NET. This is the first time I will create a web site. I found out that ASP.NET uses codebehind in which I can choose what language to use there whether it is Visual Basic or C#. Then I tried and found it very useful and easy for me since I'm used to coding VB.NET. This is also my first time to use mySQL. I've learned that mySQL is the usual database management system used by most of the websites so I used it, though I usually use SQL Server 2005. One advantage I can see with ASP.NET againt PHP is that ASP.NET is versatile in scripting than PHP. PHP is pure server-side while ASP.NET can be a server-side or client-side. All procedures that need to be done in client are done there and what needs to be done in server is done with the server(I notice that some scripts are converted into javascript). So yeah, in short, I find ASP.NET easier.

[freecrm]

If you're this knowledgable, I would definately recommend using myphpadmin as you can customise each table and field to suit your application.

As you've pointed out, php is server-side and tends to be supplemented with JS for client side processes.

Unfortunately, I have little knowledge of ASP and can't assist with your ODBC connector.

There is a bunch of info on the forums at mysql.com

[nyakerz]

Thanks for the reply.

I think I will have a hard time for this and now another problem arises.
Server error when I run my aspx file on the server which run days ago without error.