Yun & Compatible

Details

Written by Sonny Yu

• Languages and Yun
• Datalog and DB

opkg update
opkg install php5-cli php5-mod-pdo-pgsql

nano pgsql2.php

#!/usr/bin/php-cli
<?php
try
{
    $db = new PDO('pgsql:dbname=mypgdatabase;host=192.168.0.240','postgres','password');
    # Send errors as exceptions
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    # Run a query
    $sql = "select username, password from login;";
    $results = $db->query($sql);
    foreach($results as $row)
    {
        var_dump($row);
    }
} catch(\Exception $e)
{
    echo $e->getMessage();
}
?>

chmod 755 pgsql2.php

./pgsql2.php
array(4) {
  ["username"]=>
  string(7) "sonnyyu"
  [0]=>
  string(7) "sonnyyu"
  ["password"]=>
  string(8) "password"
  [1]=>
  string(8) "password"
}

Details

Written by Sonny Yu

• Languages and Yun
• Datalog and DB

opkg update
opkg install php5-cli php5-mod-pgsql

nano pgsql.php

#!/usr/bin/php-cli
<?php
$db = pg_connect("host='192.168.0.240' user='postgres' password='password' dbname='mypgdatabase'");
$grab_people = pg_query("select username, password from login");
$person = pg_fetch_assoc($grab_people);
print_r($person);
print pg_last_error();
pg_free_result($grab_people);
pg_close($db);
?>

chmod 755 pgsql.php

./pgsql.php
Array
(
    [username] => sonnyyu
    [password] => password
)

Details

Written by Sonny Yu

• Languages and Yun
• Datalog and DB

opkg update
opkg install python-psycopg

nano postgre.py

#!/usr/bin/python
# -*- coding: utf-8 -*-
import psycopg
try:
    conn = psycopg.connect("dbname='mypgdatabase' user='postgres' host='192.168.0.240' password='password'")
except:
    print "I am unable to connect to the database"
cur = conn.cursor()
cur.execute("select username,password from login")
rows = cur.fetchall()
print "\nShow me the databases:\n"
for row in rows:
    print "   ", row[0], "   ", row[1]

chmod 755 postgre.py

./postgre.py