I have put a bit of PHP in with Insert PHP and it runs fine. Since it is a database connect, I don’t want it in the page for obvious reasons:<\/p>\n
[insert_php]\n$$db=mysql_connect ("localhost", "USER", "PASSWORD") or die ('I cannot connect to the database because: ' . mysql_error());mysql_select_db ("DATABASE");global $$db;$asql=mysql_query("SELECT * FROM rates WHERE r_id='1'") or die(mysql_error());$arow=mysql_fetch_array($asql);\n[\/insert_php]<\/code><\/pre>\nI want to put it in a file and pull it in, but when I do, it just prints the file contents. I tried this code:<\/p>\n
[insert_php]\n$FileLocation = "\/wp\/dbcon.php";\nreadfile($_SERVER['DOCUMENT_ROOT'].$FileLocation);\n[\/insert_php]<\/code><\/pre>\nThere are additions down the page that print the data, which work fine with the first database connect statement above. For example:<\/p>\n
[insert_php]echo $arow[‘r_reg’];[\/insert_php]<\/p>\n
I have tried making the file with and without the <?php and ?>, same results.<\/p>\n
Any ideas??<\/p>\n
Thanks in advance.<\/p>\n
https:\/\/wordpress.org\/plugins\/insert-php\/<\/p>\n","protected":false},"template":"","class_list":["post-5862543","topic","type-topic","status-closed","hentry","topic-tag-connection","topic-tag-database"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5862543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5862543\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=5862543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}