Not connecting to Database? WordPress

Ashley comments:

Here is the code I'm trying to get to work:

<?php


$dbuser="user";
$dbpass="password";
$host="localhost";
$dbname = "namegoeshere";

$chandle = mysql_connect("localhost", $dbuser, $dbpass)
or die("Connection Failure to Database");
echo "Connected to database server<br>";
mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found." . $dbuser);
echo "Database " . $database . " is selected";
mysql_close($chandle);

$leadId = 3;

$query = "SELECT field_number FROM wp_rg_lead_detail WHERE lead_id = '" . $leadId . "'";
$result = mysql_query($query, $sqlLink);

print("Query: $query");

$count = mysql_num_rows($result);

print("Ct: $count");

?>

Ashley comments:

Here is the code I'm trying to get to work:

<?php


$dbuser="user";
$dbpass="password";
$host="localhost";
$dbname = "namegoeshere";

$chandle = mysql_connect("localhost", $dbuser, $dbpass)
or die("Connection Failure to Database");
echo "Connected to database server<br>";
mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found." . $dbuser);
echo "Database " . $database . " is selected";
mysql_close($chandle);

$leadId = 3;

$query = "SELECT field_number FROM wp_rg_lead_detail WHERE lead_id = '" . $leadId . "'";
$result = mysql_query($query, $sqlLink);

print("Query: $query");

$count = mysql_num_rows($result);

print("Ct: $count");

?>

Pippin Williamson comments:

I'm not sure why the database isn't connecting, but why don'y you just put the database you're trying to use inside of the WP database. That way you wouldn't have to worry about connecting to it.

If this is acceptable, I'll give you the appropriate code / resources.

Ashley comments:

I don't care how it works as long as it does!! Whatever it takes is fine with me.

Pippin Williamson comments:

ok, to create a db table within the WP db, do something like this (adjust values for your names and such):


function ss_options_install() {
global $wpdb;

// create the slide show database
if($wpdb->get_var("show tables like YOURTABLENAME") != YOURTABLENAME)
{
// create a table with two colums: fieldnumber and ID
$sql = "CREATE TABLE YOURTABLENAME (
id mediumint(9) NOT NULL AUTO_INCREMENT,
fieldnumber tinytext NOT NULL,
UNIQUE KEY id (id)
);";

require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
dbDelta($sql);

$rows_affected = $wpdb->insert( YOURTABLENAME, array( 'fieldnumber' => 'default') );

}
}


That will create your database. Now, to get info from the database:


<?php foreach ( $wpdb->get_results("SELECT * FROM YOURTABLENAME ORDER BY id DESC LIMIT 1;") as $key => $object)
{
$id = $object->id; // ID of each entry
$fieldnumber = $object->fieldnumber; // field number of each entry

// do stuff here

}?>



This code will retrieve every entry from YOURTABLENAME and set up variables to the two columns inside of the table: fieldnumber and ID.

All of this goes in functions.php or in your main plugin file.

Ashley comments:

Here is the code I'm trying to get to work:

<?php


$dbuser="user";
$dbpass="password";
$host="localhost";
$dbname = "namegoeshere";

$chandle = mysql_connect("localhost", $dbuser, $dbpass)
or die("Connection Failure to Database");
echo "Connected to database server<br>";
mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found." . $dbuser);
echo "Database " . $database . " is selected";
mysql_close($chandle);

$leadId = 3;

$query = "SELECT field_number FROM wp_rg_lead_detail WHERE lead_id = '" . $leadId . "'";
$result = mysql_query($query, $sqlLink);

print("Query: $query");

$count = mysql_num_rows($result);

print("Ct: $count");

?>