File: templates/show_data_db.php


<?php

/*

:: Retrieve and display all posts from a Wordpress blog

*/

function GetPosts()

{

    $con = mysql_connect('localhost','username','password');

    mysql_select_db('wp-database-name',$con);

    $query = mysql_query("SELECT post_title FROM wp_posts",$con);

    

    $html = '';

    while($row = mysql_fetch_assoc($query))

        $html .= '<p><strong>'.$row['post_title'].'</strong></p>';



    return $html;

}

?>



<div>

    <h2> {title} </h2>



    <?php echo GetPosts(); ?>

</div>

For more information send a message to :
info at phpclasses dot org.

Copyright (c) Icontem 1999-2009	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products

	Classes of Costin T	>	AbsTemplate	>	templates/show_data_db.php

File: templates/show_data_db.php

Contents