Hi,
I'm new to the world of mysql and i'm having alot of trouble with it.
All i want to do is create a page with a response form, e.g. name etc
and some radio buttons (part of a uni project, but i'm a chemist!) and
a submit button to save the data in a database.
I installed iss microsoft web server and php and the mysql database.
Php works fine, i could write to a text file, and using phpinfo(); it
says everythings ok and a mysql section is there, so i'm guessing
mysql is installed ok.
The php script to insert info etc in to databases seems easy enough,
but i have no idea how to create a database!
I searched everywhere, but could find nothing, most mysql tutorials
just brush past it and go onto the editing of a databse, but i have no
database!
Can anybody help me to how to create a simple mysql database, i.e. 1
table with a few forms in.
Also, this database is being used as a survey, so its sorta essential
that i can extract the data afterwards, again, could find no info!
Any help would be very much appreciated!
Thanks, Jon 4 4152
> I searched everywhere, but could find nothing, most mysql tutorials just brush past it and go onto the editing of a databse, but i have no database!
Can anybody help me to how to create a simple mysql database, i.e. 1 table with a few forms in.
Maybe you missed the MySQL Documentation: http://www.mysql.com/documentation/m...l#Database_use
> I searched everywhere, but could find nothing, most mysql tutorials just brush past it and go onto the editing of a databse, but i have no database!
Can anybody help me to how to create a simple mysql database, i.e. 1 table with a few forms in.
Maybe you missed the MySQL Documentation: http://www.mysql.com/documentation/m...l#Database_use
Hi, thanks for your help. I found that but couldnt make much sense of
it, mainly since the:
mysql -h host -u user -p
Enter password: ********
bit in the shell didnt work, it says:
Error 2005: Unknown Mysql server Host host (11001).
the documentation says:
To connect to the server, you'll usually need to provide a MySQL user
name when you invoke mysql and, most likely, a password. If the server
runs on a machine other than the one where you log in, you'll also
need to specify a hostname. Contact your administrator to find out
what connection parameters you should use to connect (that is, what
host, user name, and password to use). Once you know the proper
parameters, you should be able to connect like this:
shell> mysql -h host -u user -p
Enter password: ********
not to sure whats the program with the host/user or what to put. my
p.c is part of a 5 comuter student house/home network. I.e. 1 server
running internet connection sharing to the 4 rooms.
I thinks thats my problem now.
Again, any more help would be much appreciated, Jon
Hi, thanks for your help. I found that but couldnt make much sense of
it, mainly since the:
mysql -h host -u user -p
Enter password: ********
bit in the shell didnt work, it says:
Error 2005: Unknown Mysql server Host host (11001).
the documentation says:
To connect to the server, you'll usually need to provide a MySQL user
name when you invoke mysql and, most likely, a password. If the server
runs on a machine other than the one where you log in, you'll also
need to specify a hostname. Contact your administrator to find out
what connection parameters you should use to connect (that is, what
host, user name, and password to use). Once you know the proper
parameters, you should be able to connect like this:
shell> mysql -h host -u user -p
Enter password: ********
not to sure whats the program with the host/user or what to put. my
p.c is part of a 5 comuter student house/home network. I.e. 1 server
running internet connection sharing to the 4 rooms.
I thinks thats my problem now.
Again, any more help would be much appreciated, Jon This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: lkrubner |
last post by:
I have a webserver through Rackspace. I create a domain. I create an
FTP user. I upload some files. I create a database called
testOfSetupScript and then I create a database user named setup.
I...
|
by: w_curtis |
last post by:
I'm an Access user, and I'm trying to learn MySQL and then PHP so I can make
some web databases. But it just isn't clicking.
I've followed some tutorials, and picked up a book, but just getting...
|
by: Mike Chirico |
last post by:
Interesting Things to Know about MySQL
Mike Chirico (mchirico@users.sourceforge.net)
Copyright (GPU Free Documentation License) 2004
Last Updated: Mon Jun 7 10:37:28 EDT 2004
The latest...
|
by: MLH |
last post by:
I am having failures processing the following command and I wonder
if you can tell me what I must do in order to have success. When I try
to run source mysql_dump.sql.txt ==> it is a problem...
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to...
|
by: jrs_14618 |
last post by:
Hello All,
This post is essentially a reply a previous post/thread
here on this mailing.database.myodbc group titled:
MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode
I was...
|
by: mistral |
last post by:
Need php script to create mySQL database programmatically; since
hosting configuration may not allow create database from script, script
also need eliminate/rewrite all restrictions in appropriate...
|
by: Ben |
last post by:
I don't know whether anyone can help, but I have an odd problem. I have
a PSP (Spyce) script that makes many calls to populate a database. They
all work without any problem except for one...
|
by: Marijn |
last post by:
Hello everybody,
I am new to PHP and working on extending my knowledge of OOP. The
posts in this group concerned with whether or not to use an OO
approach when programming in PHP is not what I...
|
by: Atli |
last post by:
You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t.
In situations where your PHP application...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |