Yes, PDO is enabled or disabled in the php.ini file. Just remember to reload Apache (or whatever server software you're using) so that the changes are taken.
phpMyAdmin and MySQL Query Browser are two front-ends to the MySQL RDBMS system. You have to have MySQL installed somewhere (either on your local computer or on a server) and have access to it in order to use it. Otherwise, they're useless applications. If you have that, then they both can equally create databases and tables; however, phpMyAdmin has a better interface for creating tables & databases, while MySQL Admin is better than MySQL Query Browser for creation of databases & tables.
You can ask for help using any editor you like. Just because Roger uses UltraEdit, I use Zend Neon / Edit Plus / Notepad++, and Rod uses Dreamweaver doesn't mean that any of us can't help the other. The application to create the php script is a moot point; it's the code within that script that matters. So you can edit in whatever you like 🙂 Just make sure you're happy with it.
I'm not sure how to use Dreamweaver to create a database or table (as I don't particularly use Dreamweaver) but in phpMyAdmin you'd do the following:
-
Log on to your phpMyAdmin
-
From the home area, there should be a text box in the right pane with a label above it: "Create new database"
-
Fill that with the name of a database you want, I'll call it "testing"
-
Once it's created, you should be in a new page, with the left having what will be a list of tables on the left, and on the right another area that says "Create new table". Fill in the text-box with the table name, and in the "Fields" texbox, put the number of columns to create (we'll use 3 in our example)
-
Create a new table with whatever name you like, I'll call it "test_table"
-
You'll be brought to another screen where you can add and remove columns. In here, you need to add the name of the column, select the type, and then continue over selecting the options you want.
-
Once you're satisfied, click the "Save" button. If you need to add more columns, click the "Go" button which by default will add 1 more column (you can change the number in the text-box from 1 to whatever number and that many columns will be added).
-
That's it
That's the basics. All of those steps usually take about 2 minutes. The longest part is putting all the data-types and default values together in there. That's why MySQL Admin is sometimes easier to create databases with. It's a little more user-friendly.
All of that could easily be accomplished with:
DROP DATABASE IF EXISTS `testing`;
CREATE DATABASE `testing`;
USE `testing`;
DROP TABLE IF EXISTS `test_table`;
CREATE TABLE `test_table` (
`id` int(11) NOT NULL auto_increment,
`column2` VARCHAR(255) NOT NULL DEFAULT '',
`column3` SMALLTEXT NOT NULL,
PRIMARY KEY(`id`)
) ENGINE=InnoDB AUTO INCREMENT=1;
There may be some typos, but that's the general gist of it.
