Allison Nighswander

This site includes academic coursework, my resume, and projects I have done for work. This also serves as a place to post code and other programming-related information that I have found useful.

Update the Year in a DATETIME field (Mysql)

October 22, 2008

UPDATE tablename SET column=column-INTERVAL YEAR(column) YEAR+INTERVAL new year YEAR WHERE ID="ID";

Fatal error: Uncaught SCA_RuntimeException: Instantiation of unknown type (PHP)

September 03, 2008

Fatal error: Uncaught SCA_RuntimeException: Instantiation of unknown type :http://Reward Reseller thrown in C:\...\Reward\SCA\Bindings\local\Proxy.php on line 138
This error is generated when using SCA for PHP. The cause of this error is most likely due to missing targetNamespace="http://Reward" in the xsd file

Backup an entire database to a file (Mysql)

July 14, 2008

mysqldump --opt -u username -p database name > backup.sql

Fatal error: Call to a member function bind_param() on a non-object (PHP)

July 01, 2008

The cause of this error is most likely due to the statement object returning false when attempting to be created. The cause of the statement object returning false is that the SQL statement is incorrect. Try running the same SQL command line and see if you get errors there.


$updateStatement = "UPDATE $db_table SET refID = ? WHERE trans_num = ?";

$stmt = $mysqli->prepare($updateStatement);

if(!$stmt) echo "error"; //Will print "error"

$stmt->bind_param("ss", $newTransNum, $originalTransNo); //This fails

//The SQL statement is wrong (there is no field trans_num in the table)

Format to two decimal places (PHP)

June 18, 2008

I was looking all around for this and even tried to do it manually, but I found this function number_format. I used it to make sure that a dollar amount was to have two decimal places. Original amount: 5.3
$newAmount = number_format(5.3, 2)
$newAmount = 5.30.

http://us3.php.net/manual/en/function.number-format.php

Firefox 3 Released (Browsers)

June 17, 2008

Today marks the launch of Firefox 3 (10 AM Pacific Time). Mozilla is trying to break a world record for the most downloads. My co-worker is hosting a launch party today at 7PM at his apartment at RIT.

http://seanhayes.name/2008/06/17/firefox-3-launch-party-rit/