Skip to content

Instantly share code, notes, and snippets.

@RSquaredSoftware
RSquaredSoftware / gist:1976308
Created March 5, 2012 03:29
<?php
//connect to the xml and create an xml object from it
$session = curl_init('http://www.chinabuye.com/mivec/rss/data/apple.xml');
curl_setopt($session, CURLOPT_RETURNTRANSFER,true);
$xml = new SimpleXMLElement(curl_exec($session));
//craete the csv file
$apple = "apple.csv";
$handle = fopen($apple, 'a');
@RSquaredSoftware
RSquaredSoftware / gist:2364129
Created April 12, 2012 01:37
<?php
//create a PDO object to interface with the database
try {
$dbh = new PDO('mysql:localhost:3306', 'root', '');
}
catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
}
@RSquaredSoftware
RSquaredSoftware / gist:2373918
Created April 13, 2012 05:23
<?php
echo ' <link href="common/style.css" rel="stylesheet" type="text/css" />';
echo "<body onLoad='document.getElementById('song').select();'>";
//create a PDO object to interface with the database
try {
$dbh = new PDO('mysql:localhost:3306', 'root', '');
}
catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
@RSquaredSoftware
RSquaredSoftware / gist:2374074
Created April 13, 2012 05:33
try{
$dbh->exec("USE isp5;");
$order = 'song';
$sth = $dbh->prepare("SELECT * FROM songs ORDER BY $order");
$sth->execute();
$result = $sth->fetchAll(PDO::FETCH_ASSOC);
echo "<form action='' method='POST'>";
echo "<table><tr><th><a href=''>Song</a></th><th><a href=''>Artist</a></th><th><a href=''>Votes</a></th><th></th></tr>";
foreach($result as $r){
@RSquaredSoftware
RSquaredSoftware / gist:2374238
Created April 13, 2012 06:03
<?php
echo ' <link href="common/style.css" rel="stylesheet" type="text/css" />';
echo "<body onLoad='document.getElementById('song').select();'>";
//create a PDO object to interface with the database
try {
$dbh = new PDO('mysql:localhost:3306', 'root', '');
}
catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
@RSquaredSoftware
RSquaredSoftware / gist:2374322
Created April 13, 2012 06:16
<?php
echo ' <link href="common/style.css" rel="stylesheet" type="text/css" />';
echo "<body onLoad='document.getElementById('song').select();'>";
//create a PDO object to interface with the database
try {
$dbh = new PDO('mysql:localhost:3306', 'root', '');
}
catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
@RSquaredSoftware
RSquaredSoftware / gist:2374585
Created April 13, 2012 06:55
$state=array(song=>FALSE, artist=>FALSE, votes=>FALSE);
$order = 'song';
if (isset($_GET['order'])){
$order = $_GET['order'];
echo $order;
echo $state[$order];
$state[$order]=!$state[$order];
}
@RSquaredSoftware
RSquaredSoftware / gist:2374675
Created April 13, 2012 07:05
$state=array('song'=>'FALSE', 'artist'=>'FALSE', 'votes'=>'FALSE');
$order = 'song';
if (isset($_GET['order'])){
$order = $_GET['order'];
echo $state[$order]." ";
$state[$order] = ! $state[$order];
echo $state[$order]." ";
}
@RSquaredSoftware
RSquaredSoftware / gist:2396213
Created April 16, 2012 03:24
<?php
require('lotto.Class.php');
$handle = new lotto();
$handle->printpick3();
?>
@RSquaredSoftware
RSquaredSoftware / gist:2396214
Created April 16, 2012 03:24
<?php
Class lotto{
require('File.Class.php');
function init(){
$dbName = lotto;
try {