Skip to content

Instantly share code, notes, and snippets.

@greenspray
greenspray / db.php
Created January 28, 2016 18:29 — forked from luckyshot/db.php
PHP/MySQL (PDO) method with named parameters
/*
PHP/MySQL (PDO) method with named parameters
---------------------------------------------
https://gist.github.com/luckyshot/9477105
$config = [
'mysql' => [
'database' => 'database',
'user' => 'root',
@mvaz
mvaz / cx_oracle_to_pandas.py
Created March 9, 2012 13:24
Example of executing and reading a query into a pandas dataframe
import cx_Oracle
import pandas
connection = cx_Oracle.connect('username/pwd@host:port/dbname')
def read_query(connection, query):
cursor = connection.cursor()
try:
cursor.execute( query )
names = [ x[0] for x in cursor.description]