Newby Questions...

[php?]

Heres a couple of newb questions i have: 

 

-How do i create a database?

-How do i import a file into a database?

-How do i find out my database username and password?

[Link]

Are you using phpMyAdmin?

[Daniel0]

1.

CREATE TABLE table_name_here;

 

2. Use something like phpMyAdmin or if you have a .sql file just run it (via mysql on command line or again via phpMyAdmin).

 

3. If you've lost your password, too bad... the passwords are encrypted. Create a new account.

[purefan]

php + mysql = Love!

hehe, heres a good starting point: http://php-mysql-tutorial.com for working with databases from php but CPanel and phpmyadmin are great tools for administering databases

 

[php?]

im using winmysqladmin..... and its bs, you cant edit anything. U can't create anything at all...

 

 

I downloaded a program called xampp... that gave me a ton of junk for this. Ive never even made a password for a database.  ???

[php?]

Where to download myphpadmin

[Daniel0]

If you didn't choose a password, then perhaps the root password is empty or perhaps the default password is written in some documentation file or readme file.

 

phpMyAdmin: http://phpmyadmin.net

[php?]

well what the hell... i downloaded phpMyAdmin junk... and now what. Just a ton of stupid pointless files

[Daniel0]

It's a web script. It's designed to be run on a web server running PHP. You should have figured that out when you saw the .php extensions.

[php?]

Well how do i put it on a web server...

[Daniel0]

Make a folder in your document root and put the files in it. You also need to configure the config file. Read phpMyAdmin's documentation.

[php?]

Makes no freakin sense at all... nothing about any of this stupid useless crap does, they need to give extra information... not everyone in the world is a lifeless nerd

[php?]

Where is my "webserver's document root" ... or how do i find out what my freakin web server is... apache?

[Daniel0]

Hmm... I really don't wish to help you anymore when you ask where your "freakin web server is" and things doesn't "make freakin sense" and when you call people trying to help you "lifeless nerds". Things aren't bullshit or crap just because you can't figure out how to use it. Go RTMF.

 

Apache manual: http://httpd.apache.org/docs/

phpMyAdmin manual: http://www.phpmyadmin.net/home_page/docs.php

MySQL: http://dev.mysql.com/doc/

PHP manual: http://php.net/manual

 

Now you'll have to figure things out yourself.

[Daniel0]

Oh, read this as well: http://catb.org/~esr/faqs/smart-questions.html

[php?]

-LISTEN-

 

Im not trying to be mean.

 

I DONT UNDERSTAND THOSE MANUELS!

 

I am new to php/mySQL ... And don't tell me to read anything else unless it makes sense to someone that isn't on their computer for more then 2 hours a day.

[Daniel0]

Have you installed Apache, MySQL and PHP on your computer? You can do it manually by downloading the software from the web pages or you can use a bundled package, on Windows that'll be called a WAMP and on Linux it'll be a LAMP.

 

Here is a comparison of WAMPs: http://en.wikipedia.org/wiki/Comparison_of_WAMPs

 

Your document root of your web server is the folder in which you place your files. It can be something like C:\apache2\htdocs, /var/www or /home/somebody/public_html.

[Barand]

I suggest you take time out to learn how to read.

 

When you've accomplished that, learn how to learn from what you are reading. You can't have done more than just glance at the manuals and give up. If you aren't prepared to put in any effort, why should we waste our time on you?

 

And it won't make you a "lifeless nerd", just smarter.

 

 

Warning: I'm getting fed up with seeing the "Started by" column fill up with new "php?" entries, each of the topics on the same whinging theme.

[php?]

First of all i already have php, apache and mysql installed... i have everything i need.. the guides don't explain stuff in "English" more like computer language. And i can read very well, reading is not understanding. Btw you can't "Learn to Learn" without learning first. Exactly why i can't learn until i have learned how to set up phpMYadmin

[Daniel0]

Exactly why i can't learn until i have learned how to set up phpMYadmin

 

I already told you how to install it. You asked what the document root is and I answered that as well.

[php?]

Yes, thank-you daniel... i have those errors fixed, now im only getting these:

 

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\va162.php\game\includes\rightmenu.php on line 19

 

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\va162.php\game\includes\rightmenu.php on line 23

 

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\va162.php\game\includes\rightmenu.php on line 27

[php?]

I don't think my database is set up right... see i downloaded a test text-based game... Tryin to make it run, the main page loads but it has 3 errors and when i try to register it says those same errors..

[Daniel0]

You probably has to create a database for it and configure some file in that game.

[php?]

"Please create web server writable folder config in phpMyAdmin toplevel directory " what exactly is a web server writable folder config?

[Daniel0]

It's just a folder which the server is able to write to. "config" is probably what they want you to call it.