Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ######################## LOGIN DATA ################################################
- $username = "egabocom_blog2";
- $password = "#cpa_3x$";
- $database = "egabocom_wrdp1";
- $host = "localhost";
- ############################# CONSTANT #############################################
- ######################### LOGIN ACTION #############################################
- $connect = mysql_connect($host, $username, $password);
- mysql_query('SET NAMES utf8');
- @mysql_select_db($database) or die("Unable to select database"); //generate error message
- mysql_query('SET NAMES utf8');
- echo mysql_error(); //show error message
- ############################### SELECT DB ###########################################
- if (!mysql_select_db("egabocom_wrdp1")) {
- echo "Unable to select db: " . mysql_error();
- exit;
- }
- ############################### SELECT QUERY ########################################
- $sql = "
- SELECT wp_posts.post_title
- FROM wp_posts, wp_term_relationships, wp_terms
- WHERE wp_posts.ID = wp_term_relationships.object_id
- and wp_term_relationships.term_taxonomy_id = wp_terms.term_id
- and wp_terms.name like 'ТЕХНОЛОГИИ'
- and wp_posts.post_status = 'publish'
- and wp_posts.post_type = 'post'
- ORDER BY wp_posts.ID DESC
- LIMIT 6
- ";
- ############################### GET QUERY ##########################################
- $result = mysql_query($sql); // get
- if (!$result) { // error check
- echo "Could not successfully run query ($sql) from DB: " . mysql_error();
- exit;
- }
- if (mysql_num_rows($result) == 0) { // error check
- echo "No rows found";
- exit;
- }
- ##################################### RESULT FETCH ################################
- while ($row = mysql_fetch_assoc($result)) {
- ######################### ECHO ROWS - HTML ########################################
- // TITLE;
- echo $row['wp_posts.post_title'];
- }
- mysql_free_result($result);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement