quick question, this is probably stupid, I have a wordpress site I am working on, but on the front page, I want content from multiple plugins in the database to build a custom home page that has content from multiple plugins displayed on the front page.
to do a simple connect, my password contains a period in it. PHP seems to get screwed up with that period. I tried both single quotes and double quotes, anyone know how to get around this problem I am having?
02-14-2013, 08:20 PM
Are you talking about the main WordPress login, or something else? If "something else," we'll need to see the relevant code to help you figure out what's wrong.
02-14-2013, 11:41 PM
Here is an example. lets say my username is admin, and password is pass.word.
mysql_connect('localhost', 'admin', 'pass.word');
AFter the '.' in pass.word it won't do anything past that. Any way of getting past this without actually having to make changes to the db?
02-15-2013, 01:10 AM
Okay, so you are trying to submit that as the MySQL password for MySQL user named "admin". Does your MySQL installation on that host in fact have a user defined with that name and password, and if so, how did you create it?
02-15-2013, 09:39 AM
Yes eveything is correct. Even if I dnt do a query it won't echo that there is a connection or not like I told it to
02-15-2013, 10:58 PM
I figured out in wordpress, you don't have to sign into database with php, you can just get it by using $wpdb.
Another problem arises though, for some reason when writing a query, I either just get a count or I get a result with a bunch of extra stuff from the query like the column name and table name and what not. here is the code I put in that is only giving me a count. I also tried echo, but echo won't give me any results at all.
$myrows = $wpdb->query( "SELECT * FROM wp_users WHERE display_name='pdiddledor';" );