Thread: Connect to Wordpress Database?

I want to automatically connect to the database and pull data from the tables. Can somebody tell me how to do that? I know PHP & MYSQL so I just need to get the files in order to get the query to work...

I'm working from a theme folder if that's important.

hmm

PHP Code:

<?php
// edit these values to match your database information
$server = "localhost";
$user = "root";
$password = "";
$db = "wp";

$con = mysql_connect($server,$user,$password); 

if (!$con) {
    die("database connection error");
} else {

mysql_select_db($db, $con);

// example query
$result = mysql_query("SELECT * FROM wp_posts
WHERE post_author='1'");

// show all posts by author 1 (admin)
while($row = mysql_fetch_array($result))
  {
    if($row['post_status'] == "publish") {
    echo "".$row['post_title']." <br />";
    }
  }
  
}
mysql_close($con);
?>

that would output something similar to:

Originally Posted by "localhost WP - Aziz

Hello world!
About Us
Lorem Wipsum
Articles
All Articles
Archvies
contact
Links
IRC Chat
Sitemap

I'm building a theme to sell, so I need to be able to use any details that someone has without having to edit the login information. Any ideas?

You mean like this?
Class Reference/wpdb � WordPress Codex

Lol - a little late!

I would believe that after almost 2 1/2 years, he has solved his problem.
Can't believe people come into forums and then hunt for some very old thread to answer as their first post!