[php]
\n$DBServer = ‘mysql-blog.c9snva5j3asb.us-west-2.rds.amazonaws.com’; \/\/ e.g ‘localhost’ or ‘192.168.1.100’
\n$DBUser = ‘gg86e77e40d2d’;
\n$DBPass = ‘FFAD57DA-F833-41BE-A5E7-568A85BFEB2C’;
\n$DBName = ‘gg86e77e40d2d’;
\n$conn = new mysqli($DBServer, $DBUser, $DBPass, $DBName);<\/p>\n
\/\/ check connection
\nif ($conn->connect_error) {
\necho ‘Database connection failed’;
\n}<\/p>\n
$poststring= “SELECT ID,post_title, post_name FROM wp_posts WHERE (post_type = ‘post’) AND post_status=’publish’ ” ;<\/p>\n
$posts=$conn->query($poststring);<\/p>\n
if($posts === false) {
\n trigger_error(‘Wrong SQL: ‘ . $poststring . ‘ Error: ‘ . $conn->error, E_USER_ERROR);
\n} else {
\n $rows_returned = $posts->num_rows;
\n}<\/p>\n
$posts->data_seek(0);
\nwhile($single = $posts->fetch_assoc()){<\/p>\n
\t$slug_base = $single[‘post_name’];
\necho $slug_base.”[br]”;<\/p>\n
}
\n\t$posts->free();<\/p>\n
[\/php]<\/p>\n","protected":false},"excerpt":{"rendered":"
[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 = […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-11860","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n