[php] $DBServer = ‘mysql-blog.c9snva5j3asb.us-west-2.rds.amazonaws.com’; // e.g ‘localhost’ or ‘192.168.1.100’ $DBUser = ‘gg86e77e40d2d’; $DBPass = ‘FFAD57DA-F833-41BE-A5E7-568A85BFEB2C’; $DBName = ‘gg86e77e40d2d’; $conn = new mysqli($DBServer, $DBUser, $DBPass, $DBName); // check connection if ($conn->connect_error) { echo ‘Database connection failed’; } $poststring= “SELECT ID,post_title, post_name FROM wp_posts WHERE (post_type = ‘post’) AND post_status=’publish’ ” ; $posts=$conn->query($poststring); if($posts === false) { trigger_error(‘Wrong SQL: ‘ . $poststring . ‘ Error: ‘ . …
Continue reading
