Kiler Media Development Group

Looking for a few, quick PHP+MySQL tips? You found some.

List all tables in the pre-set database:

SHOW TABLES;

Always, always, always use an auto-incrementing unique ID:

CREATE TABLE table_name (
id INT NOT NULL AUTO_INCREMENT,
table_field1 varchar(250) NOT NULL default ”,
PRIMARY KEY (id)
);

Adding to an auto-incrementing table:

@mysql_query(”insert into table_name values(NULL,’My Field’)”);

There’s actually three different PHP API’s which you can use:

• The C Language API:
  Link your app. with the libmysqlclient.so library that is usually installed automatically when you compile MySQL from source. (We will actually be creating several tutorials about the C PHP API soon here.)
• The Perl API:
  Using the Database Interface (DBI) and a Database Driver (DBD) you can use this API.
• The PHP API:
  The most popular MySQL API is the PHP API. It is pre-packaged with PHP versions below 5. (Of course, we’ll be creating several tutorials very soon about the PHP API, and it’s new brother, MySQLi.)

Need to take a quick dump?

mysqldump –user=ben –password=mypassword \ mydb > dumpfile.sql

That’s all for now folks! We’ll be writing a lot here in the very near future. Stay tuned!

This entry was posted on Tuesday, March 4th, 2008 at 1:45 am and is filed under MySQL, PHP, Web Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.