1. Create .php file for example custom.php
2. Add following script
<?php
/*
Template Name: Custom Page
*/
?>
//start your php script
<?php
$user_checks = $wpdb->get_results(
"
SELECT pemilik, kunci
FROM {$wpdb->prefix}creds ORDER BY pemilik
"
);
foreach ( $user_checks as $user_check )
{
echo '"';
echo $user_check->pemilik;
echo '"';
echo ':';
echo '"';
echo $user_check->kunci;
echo '"';
echo '<br/>';
}
?>
3. Upload the file in theme folder
4. the best is in child theme folder
5. Go to the wordpress, add new page
6. Look at the right side, you will find a tab with name 'custom'