Wordpress messing with my db calls on the wordpress pages?

Question

Hey, hows it going everyone? I am having database conflicts I was wanting some help with.

Basically, I have a header that pulls in a random database field. Nothing special. It is in my header in my template and works just fine on non WordPress pages.

$sql = "SELECT * FROM headerslogans ORDER BY RAND() LIMIT 1";
    $result = mysql_query($sql);
    while ($myrow = mysql_fetch_array($result)) {
    echo $myrow['slogan'];
};

I am using the same database, same user name, same password, etc. However, I get this error where the echo should be....

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in <dir name>

So obviously the wordpress connection is "overwriting" the other (wordpress works flawlessly). BUT, I was also confused as to why it doesn't work, although it is connecting to the same database with same username and password.

Can anybody help me out on this?

UPDATE: Posted connection code

$x = mysql_connect($server,$dbuser,$dbpass,true) or die(mysql_error()); mysql_select_db($dbname,$x);

You have this code in your header.php file? If so, you should not be doing that — JohnP
– JohnP, Commented Apr 12, 2011 at 15:45
This kind of code should go in a plugin or at least your functions.php. — JohnP
– JohnP, Commented Apr 12, 2011 at 16:29
I see what you mean. But I need this code to work on OTHER parts of the site that are NOT wordpress driven. This code is in a sitewide inc-header.php include file. Included everywhere, not just wordpress. — NarfFlarf
– NarfFlarf, Commented Apr 12, 2011 at 16:37
Can you post your mysql connection code? That's where the problem lies, not in the sql statement. — Ciaran
– Ciaran, Commented Apr 12, 2011 at 16:58
@Ciaran - Sure. Thanks! Like I said, this works fine on NON-Wordpress pages. Thanks for the help! $x = mysql_connect($server,$dbuser,$dbpass,true) or die(mysql_error()); mysql_select_db($dbname,$x); — NarfFlarf
– NarfFlarf, Commented Apr 12, 2011 at 18:11

Dunhamzzz · Accepted Answer · 2011-04-12 15:48:55Z

1

As you said, the connection is getting overwritten, is the database selection also getting over written? It's probable that actually mysql_select_db() is the thing screwing you over. Fix it by setting you your original connection as a variable, and referencing it in the offending mysql_* functions, eg:

$dbcnct = mysql_connect(...);
mysql_select_db('...', $dbcnct);
mysql_query('...', $dbcnct);

This shouldn't affect your current setup either.

answered Apr 12, 2011 at 15:48

Dunhamzzz

14.8k4 gold badges54 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

Marc B Over a year ago

You can specify a database directly in the queries: SELECT fieldname FROM database.table .... Selecting a default database just removes the need from specifying the database name explicitly.

Dunhamzzz Over a year ago

Exactly, this will plug in to OPs current setup without having to change all the queries...

NarfFlarf Over a year ago

Thanks for the info, but I have tried that. I now get "Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in <dirname>", ONLY on the wordpress pages.

Dunhamzzz Over a year ago

You need to include the mysql_connect on the pages that use your own mysql_query...

NarfFlarf Over a year ago

@Dunhamzzz Well... that worked.... unfortunately. If I declare everything every single time, right before the SQL statement, it works. Which means I have to put the dbname, user, login, etc etc every single time I want to pull data from it. Grrrrr!! :) Surely there is another way? sniff sniff Thanks again!

|

stealthyninja · Accepted Answer · 2011-04-12 16:46:58Z

1

@NarfFlarf: You could just use WordPress queries to get your data --

$sql = "SELECT * FROM headerslogans ORDER BY RAND() LIMIT 1";
$result = $wpdb->get_results($sql);
foreach ($myrow as $result) {
    echo $myrow->slogan;
}

See this WordPress Codex entry for further reference.

Update

Something else you can perhaps try then is to have <img src="slogan.php" alt=""> and within slogan.php:

<?php
/* Instantiate own, non-WP MySQL connection */
/* Run query and retrieve image */

header("Content-type: image/jpeg");
echo file_get_contents('path/to/image/' . $image); // 'dynamic' image!
?>

edited Apr 12, 2011 at 16:46

answered Apr 12, 2011 at 15:58

stealthyninja

10.4k11 gold badges57 silver badges61 bronze badges

3 Comments

NarfFlarf Over a year ago

Hmmmm good idea! Let me throw this wrench in the machine though. I have code EVERYWHERE, on lots of different pages, that makes calls the traditional way to the database. I am really really trying to avoid changing all of those, especially since I am not that proficient with php and mysql connectivity yet.

stealthyninja Over a year ago

@NarfFlarf: See my updated answer which might mean less modification to your existing code.

DeFeNdog Over a year ago

I agree with @stealthyninja to use the wpdb object. I believe you also have to add the following at the top of your file: <?php global $wpdb; ?>

Collectives™ on Stack Overflow

Wordpress messing with my db calls on the wordpress pages?

2 Answers 2

10 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related