Blog

This code get content from database fields and displays it

Its ok if you don’t understand SQL Queries, all you have to do is access PHP My Admin and go to the table and it allows you to generate the SQL query for you. Just copy and paste the query within mysql_query(‘your-sql-query’);
{code}

$testimonials = mysql_query(‘select * from wp_QuoteRotator’);

while($row=mysql_fetch_array($testimonials)) { ?>

{/code}

This piece of code automatically get all images in a folder and output it to your site. This is very effective for image gallery with many images. Add and remove images from a gallery is simple without touching a piece of code; just add or delete an image in the folder and done!

{code type=codetype)
//Get images from directory
function dirImages($dir) {
$d = dir($dir); //Open Directory
while (false!== ($file = $d->read())) //Reads Directory
{
$extension = substr($file, strrpos($file, ‘.’)); // Gets the File Extension
if($extension == “.jpg” || $extension == “.jpeg” || $extension == “.gif” |$extension == “.png”) // Extensions Allowed
$images[$file] = $file; // Store in Array
}
$d->close(); // Close Directory
asort($images); // Sorts the Array

return $images; //Author: ActiveMill.com
}

$array = dirImages(‘images/gallery/contemporary/’);

foreach ($array as $key => $image) // Display Images
{
?>
Posted in Web development | Leave a comment