Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <? php
- function connectDB() {
- $hostname = 'xxxxxxxx';
- $db = 'xxxxxxx';
- $user = 'xxxxxxxx';
- $pass = 'xxxxxxx';
- $dbh = new PDO("mysql:host=$hostname; dbname=$db; charset=utf8", $user, $pass, array(PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
- $sql = "//my query";
- $query = $dbh->prepare($sql);
- $query->execute(array('//value','//value'));
- $query->setFetchMode(PDO::FETCH_ASSOC);
- while ($r = $query->fetch()):
- $var1 = $r['column1'];
- $var2 = $r['column2'];
- $var3 = $r['column3'];
- $var4 = $r['column4'];
- $var5 = $r['column5'];
- endwhile;
- }
- ?>
- <?php
- include 'functions.php';
- ?>
- <?php
- try {
- connectDB();
- echo 'You are connected to Database';
- echo $var1;
- $dbh = null;
- }
- catch(PDOException $e) {
- echo $e -> getMessage();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement