PHP MySQL Test Script...

snpo123

Hey, I have just installed php, mysql, and apache and i am pretty sure they are all working, but I need a simple test script to truly prove that they are.

So far in PhpMyAdmin, I have set a username (root) and a password for root. However, I have not yet created a database. I was wondering if someone could write me a fairly simple php script that would create a mysql database and add some rows to it or something. I am fairly new to php and mysql and cannot do this by myself. If this test script works I will know for sure that they are al working. If someone could write me the script I would greatly appreciate it.

LordShryku

No ones going to write it for you. If you search the forums, you'll find plenty of examples.

newdles

First, be sure to start mysql.

If you have installed mySQL, then do it yourself. It's extremely simple. A link to mySQL monitor should be in Start > all programs > mysql. If it's not, do the following:

Start > run type cmd and hit enter.

At the command promt, type c: and hit enter. (this is taking into effect that you installed mysql to the c: drive.

Now, type the following command:
cd mysql/bin and then hit enter

cd means change directory. If you installed mysql to c:\mysql then the above command is correct for your case. If you installed to c:\web\mysql then the command would change to:
cd web/mysql/bin

Once you've done this, you're now able to start mysql monitor from the command line. To do so, type mysql and hit enter.

Now, if everything goes right and you have mysql actually running, you should see the command line change to mysql>

Here, type: create database databasename;

Substitute databasename to whatever you wish to call your database.

Now once you've created the database, type use databasename;

After that, create a table with the required fields. To do so, type the following:

create table tablename (field1 (type), field2 (type), field3 (type));

Rename tablename to whatever you wish to call your table.
Rename field1 to whatever you wish to call the first field.
Rename field2 and field3 the same way.

Now... type is where you have to learn. You need to know what type of field you'll be creating whether it be a char, varchar, int, etc... I won't tell you how to do that. I don't have the time nor the patience to type and explain all that would need to be done in order for you to learn it.

Here is where you need to read and learn or uninstall mysql, apache, and everything else server/database related and go play a video game. If you're truly interested in doing this, I suggest you get a book. Apache, mySQL, and PHP web development for dummies is a great learners book. I have that book and still refer to it quite often as it's not just for dummies.

If you don't get the book, that's fine. But you'll have to do tons of reading on your computer monitor. http://www.mysql.com is a great site to learn from for creating and maintaining databases with mysql.

Enjoy.