Posts Tagged ‘MySQL’
July 7th, 2011
Using the power of PHP’s var_dump() displays structured information about one or more expressions that includes its type and value. By definition var_dump() is a debugging tool, which displays structured information about any PHP variable. Below is a handy bit of code using var_dump() to test and verify that a SQL query contains data and view the contents using PHP:
$sql = mysql_query("SELECT * FROM your_table WHERE key = 'value'");
$assoc = mysql_fetch_assoc($sql);
// Dump variable containing the result of the MySQL query
var_dump($assoc);
(more…)
Tags: How To, MySQL, PHP, SQL, var_dump
Posted in Coding | 1 Comment »
March 17th, 2010
WordPress is driven by a MySQL database which makes updating content cake once in the database. All of the WordPress data such as posts, comments, categories, and settings are stored within the MySQL database.
If you needed to change some information site wide, going through each and every record would prove a very time consuming task and also be prone to human error. By executing a SQL query against your WordPress database however, you can make the necessary changes quickly and efficiently.
We will show some SQL queries that can be of great assistance to you when using WordPress.
(more…)
Tags: database, localhost, MySQL, reset password, URLs, WordPress
Posted in Coding | 12 Comments »
My Guy Solutions, LLC 
