#!/usr/bin/php -q 
<?php

/* (c)opyright Arc90; Ben Sgro aka sk; bens[@]arc90.com[.]com
 *
 * Usage: insertPDF -f /path/to/file
 */

/* Script Constants: Change this for your server. You'd probably
 * also want to change the SQL INSERT as well. 
 */
$DB_NAME  = 'databasename';
$DB_TABLE = 'tablename';
$DB_DSN   = 'server:port';
$DB_USER  = 'dbadmin';
$DB_PASS  = 'secret';


/*********************
 	MAIN
*********************/


$argvSet = getopt('f:');
if ( count($argvSet) != 1 )
{
	print "\nUsage: ./insertPDF.php -f /path/to/file\n";
	exit;
}

/* Fetch the command line param. */
$fileName = $argvSet['f'];

/* Check to see if the file exists. */
if ( !file_exists($fileName) )
{
	print "\nError: File does not exist.\n";
	exit;
}

/* Connect to the database. */
$dbHandle = mssql_connect($DB_DSN, $DB_USER, $DB_PASS);
if ( $dbHandle == FALSE )
{
	print "\nError: Cannot connect to db.\n";
	exit;
}

/* Select the database. */
mssql_select_db($DB_NAME, $dbHandle);

/* Set the textsize to the largest possible. */
$sqlStr = "SET textsize 2147483647";
if ( mssql_query($sqlStr, $dbHandle) == FALSE )
{
	print "\nError: Cannot set textsize.\n";
	exit;
}

/* Get the binary data of the file. */
$fHandle = fopen($fileName, 'r');
$rawData = fread($fHandle, filesize($fileName));

/* Unpack the binary data, accoring to the pack( ) chart. */
$unpackedData = unpack("H*index", $rawData);
$pdfBinary    = $unpackedData['index'];

/* Attempt to insert the pdfBinary into the database. 
 * NOTE: the use of 0x before $pdfBinary. 
 * NOTE: You *MUST* change this query to match your table struct.
 */
$sqlStr = "INSERT INTO $DB_TABLE (ownerUser, organizationId, categoryId, xmlContent, binaryContent)"
        . " VALUES ('ixdoc', 'hw', 'pdf', '<xml/>', 0x$pdfBinary)";

if ( mssql_query($sqlStr, $dbHandle) == FALSE )
{
	print "\nError: Unable to insert binary data.\n";
	exit;
}
print "\nStatus: PDF inserted.\n";

?>