PHP NewBorn
|
| Posted: 03/26/2002, 9:43 PM |
|
Hey Everyone,
I want to create a registration form for students signing up for my eclasses. I want to place all of their info into my MySQL database which is hosted on the same server as my website.
Everyone keeps telling me to use ACCESS for my database. How? I thought I need to use the database on my webserver. Not my PC. I know some of you may be laughing at me right now, but I am clearly not a programmer.
If I am creating a PHP registration form on my web server and I want the info inserted into a MySQL database on the same server, do I need Access? Do I need ODBC? All the tutorials I read tell me about using ODBC for a REMOTE connection. But I am not using a remote connection, right? I dont want to use access I want to use MySQL, but I dont need to connect remotely.
Can someone please explain it to me like I'm a 6 year old.
I TRULY appreciate all of your help!
-PHP NewBorn
|
|
|
 |
Critical
|
| Posted: 03/26/2002, 10:22 PM |
|
Although I write in whatever the customer asks for, PHP/MySQL is by far (IMHO) the easiest combination to work with, and CodeCharge makes it even easier.
A couple things might help you. First, to create the databases, you'll make life easy by getting one of the many "MySQL helpers" that'll manage/alter/etc. MySQL databases for you. (I won't endorse any here as that could be stepping on toes.)
Also, if you go to mysql.com you can grab the ODBC drivers for MySQL (MyODBC), you can tinker with a MySQL DB using Access as a client. (As well as import and export, a very handy thing when a client hands you an Access DB on a floppy.)
As for your "connecting remotely", you just have to have your DB administrator set that up for you on the server end, and use the ODBC driver during the development phase in CodeCharge. I do that daily and it makes life a breeze.
Codecharge will do the form for you and also create the insertion code, as well as what's left out in many instances...the validation code.
The biggest gain you'll make by trudging though all this seemingly impossible info as a beginner is that you'll wind up with a product that'll run almost anywhere, and where it won't, you can install PHP and MySQL in just a few minutes.
|
|
|
|
Nicole
|
| Posted: 03/27/2002, 1:38 AM |
|
Hello,
I'll try to clarify a little bit...
Create MySQL db on server (or ask admin to do it). CC will generate almost all necessary code for you and establish connection to db on server. But to design site you should connect to MySQL db in design time. For it you need ODBC installed on your machine (not on server). Refer to this tutorial for detailed description of design time connection: http://support.codecharge.com/tutorials/myodbc.html
CC will generate code for connection to db for living site. But you should enter following settings need to connect to db. On Site->Properties->Database tab->Server part fill:
Database Name: db_name
Host: host name or IP
Login: db_login
Password: db_password
Databse Type: MySQL
|
|
|
|
|
