Title: Database Connect
Last modified: August 22, 2016
---
# Database Connect
* [njaknjak](https://wordpress.org/support/users/njaknjak/)
* (@njaknjak)
* [11 years, 2 months ago](https://wordpress.org/support/topic/database-connect/)
* 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:
* ```
[insert_php]
$$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);
[/insert_php]
```
* I 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:
* ```
[insert_php]
$FileLocation = "/wp/dbcon.php";
readfile($_SERVER['DOCUMENT_ROOT'].$FileLocation);
[/insert_php]
```
* There are additions down the page that print the data, which work fine with the
first database connect statement above. For example:
* [insert_php]echo $arow[‘r_reg’];[/insert_php]
* I have tried making the file with and without the , same results.
* Any ideas??
* Thanks in advance.
* [https://wordpress.org/plugins/insert-php/](https://wordpress.org/plugins/insert-php/)
Viewing 2 replies - 1 through 2 (of 2 total)
* [nhoa88](https://wordpress.org/support/users/nhoa88/)
* (@nhoa88)
* [11 years, 2 months ago](https://wordpress.org/support/topic/database-connect/#post-5862868)
* I have a connection with a database in my file. I use this way:
* In WP page use this:
* ```
[insert_php]
include("./myFile.php");
[/insert_php]
```
* And then the connection in the file is:
* ```
Estación
stmt_init();
$stmt->prepare('SELECT col1,col2 FROM table_name');
if(!$stmt->execute()){
throw new Exception('No se pudo realizar la consulta:' . $stmt->error);
}
else{
$stmt->store_result();
$number_rows = $stmt->num_rows;
if($number_rows>0){
$stmt->bind_result($col1,$col2);
while($stmt->fetch()){
echo('Colum1: '.$col1);
echo('Colum2: '.$col2);
}
}
}
$stmt->close();
?>
```
* I hope this could help you! Good luck!
* Thread Starter [njaknjak](https://wordpress.org/support/users/njaknjak/)
* (@njaknjak)
* [11 years, 2 months ago](https://wordpress.org/support/topic/database-connect/#post-5862909)
* Thanks so much nhoa88. That worked.
Viewing 2 replies - 1 through 2 (of 2 total)
The topic ‘Database Connect’ is closed to new replies.
* 
* [Woody Code Snippets – Insert PHP, CSS, JS, and Header/Footer Scripts](https://wordpress.org/plugins/insert-php/)
* [Frequently Asked Questions](https://wordpress.org/plugins/insert-php/#faq)
* [Support Threads](https://wordpress.org/support/plugin/insert-php/)
* [Active Topics](https://wordpress.org/support/plugin/insert-php/active/)
* [Unresolved Topics](https://wordpress.org/support/plugin/insert-php/unresolved/)
* [Reviews](https://wordpress.org/support/plugin/insert-php/reviews/)
## Tags
* [connection](https://wordpress.org/support/topic-tag/connection/)
* [database](https://wordpress.org/support/topic-tag/database/)
* 2 replies
* 2 participants
* Last reply from: [njaknjak](https://wordpress.org/support/users/njaknjak/)
* Last activity: [11 years, 2 months ago](https://wordpress.org/support/topic/database-connect/#post-5862909)
* Status: not resolved