Jump to content

iarp

Members
 View Profile  See their activity

  • Posts

    326

  • Joined

  • Last visited

 Content Type 

Everything posted by iarp

  1. iarp
    Ya, just tried that before coming back here. Is what i get now.
  2. iarp
    Same error.
  3. iarp
    Hey, I'm using a class file for access to Amazons S3 service. On my page.php page, i have this code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>S3 tutorial</title> <link href="style.css" rel="stylesheet" type="text/css"> </head> <body> <?php //include the S3 class if (!class_exists('S3'))require_once('S3.php'); //AWS access info if (!defined('awsAccessKey')) define('awsAccessKey', 'key1'); if (!defined('awsSecretKey')) define('awsSecretKey', 'key2'); //instantiate the class $s3 = new S3(awsAccessKey, awsSecretKey); //check whether a form was submitted if(isset($_POST['Submit'])){ //retreive post variables $fileName = $_FILES['theFile']['name']; $fileTempName = $_FILES['theFile']['tmp_name']; //create a new bucket $s3->putBucket("iarp", S3::ACL_PUBLIC_READ); //LINE 29 HERE. //move the file if ($s3->putObjectFile($fileTempName, "iarp", $fileName, S3::ACL_PUBLIC_READ)) { echo "<strong>We successfully uploaded your file.</strong>"; }else{ echo "<strong>Something went wrong while uploading your file... sorry.</strong>"; } } ?> <h1>Upload a file</h1> <p>Please select a file by clicking the 'Browse' button and press 'Upload' to start uploading your file.</p> <form action="" method="post" enctype="multipart/form-data" name="form1" id="form1"> <input name="theFile" type="file" /> <input name="Submit" type="submit" value="Upload"> </form> <h1>All uploaded files</h1> <?php // Get the contents of our bucket $contents = $s3->getBucket("iarp"); foreach ($contents as $file){ $fname = $file['name']; $furl = "http://iarp.s3.amazonaws.com/".$fname; //output a link to the file echo "<a href=\"$furl\">$fname</a><br />"; } ?> </body> </html> But all i get is Is it me or is that code ok? The class file is as follows but php reports no errors coming from this file. <?php /** * $Id$ * * Copyright (c) 2007, Donovan Schonknecht. All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * - Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * - Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE * POSSIBILITY OF SUCH DAMAGE. */ /** * Amazon S3 PHP class * * @link http://undesigned.org.za/2007/10/22/amazon-s3-php-class * @version 0.2.3 */ class S3 { // ACL flags const ACL_PRIVATE = 'private'; const ACL_PUBLIC_READ = 'public-read'; const ACL_PUBLIC_READ_WRITE = 'public-read-write'; private static $__accessKey; // AWS Access key private static $__secretKey; // AWS Secret key /** * Constructor, used if you're not calling the class statically * * @param string $accessKey Access key * @param string $secretKey Secret key * @return void */ public function __construct($accessKey = null, $secretKey = null) { if ($accessKey !== null && $secretKey !== null) self::setAuth($accessKey, $secretKey); } /** * Set access information * * @param string $accessKey Access key * @param string $secretKey Secret key * @return void */ public static function setAuth($accessKey, $secretKey) { self::$__accessKey = $accessKey; self::$__secretKey = $secretKey; } /** * Get a list of buckets * * @param boolean $detailed Returns detailed bucket list when true * @return array | false */ public static function listBuckets($detailed = false) { $rest = new S3Request('GET', '', ''); $rest = $rest->getResponse(); if ($rest->error === false && $rest->code !== 200) $rest->error = array('code' => $rest->code, 'message' => 'Unexpected HTTP status'); if ($rest->error !== false) { trigger_error(sprintf("S3::listBuckets(): [%s] %s", $rest->error['code'], $rest->error['message']), E_USER_WARNING); return false; } $results = array(); //var_dump($rest->body); if (!isset($rest->body->Buckets)) return $results; if ($detailed) { if (isset($rest->body->Owner, $rest->body->Owner->ID, $rest->body->Owner->DisplayName)) $results['owner'] = array( 'id' => (string)$rest->body->Owner->ID, 'name' => (string)$rest->body->Owner->ID ); $results['buckets'] = array(); foreach ($rest->body->Buckets->Bucket as $b) $results['buckets'][] = array( 'name' => (string)$b->Name, 'time' => strtotime((string)$b->CreationDate) ); } else foreach ($rest->body->Buckets->Bucket as $b) $results[] = (string)$b->Name; return $results; } /* * Get contents for a bucket * * If maxKeys is null this method will loop through truncated result sets * * @param string $bucket Bucket name * @param string $prefix Prefix * @param string $marker Marker (last file listed) * @param string $maxKeys Max keys (maximum number of keys to return) * @return array | false */ public static function getBucket($bucket, $prefix = null, $marker = null, $maxKeys = null) { $rest = new S3Request('GET', $bucket, ''); if ($prefix !== null && $prefix !== '') $rest->setParameter('prefix', $prefix); if ($marker !== null && $prefix !== '') $rest->setParameter('marker', $marker); if ($maxKeys !== null && $prefix !== '') $rest->setParameter('max-keys', $maxKeys); $response = $rest->getResponse(); if ($response->error === false && $response->code !== 200) $response->error = array('code' => $response->code, 'message' => 'Unexpected HTTP status'); if ($response->error !== false) { trigger_error(sprintf("S3::getBucket(): [%s] %s", $response->error['code'], $response->error['message']), E_USER_WARNING); return false; } $results = array(); $lastMarker = null; if (isset($response->body, $response->body->Contents)) foreach ($response->body->Contents as $c) { $results[(string)$c->Key] = array( 'name' => (string)$c->Key, 'time' => strToTime((string)$c->LastModified), 'size' => (int)$c->Size, 'hash' => substr((string)$c->ETag, 1, -1) ); $lastMarker = (string)$c->Key; //$response->body->IsTruncated = 'true'; break; } if (isset($response->body->IsTruncated) && (string)$response->body->IsTruncated == 'false') return $results; // Loop through truncated results if maxKeys isn't specified if ($maxKeys == null && $lastMarker !== null && (string)$response->body->IsTruncated == 'true') do { $rest = new S3Request('GET', $bucket, ''); if ($prefix !== null) $rest->setParameter('prefix', $prefix); $rest->setParameter('marker', $lastMarker); if (($response = $rest->getResponse(true)) == false || $response->code !== 200) break; if (isset($response->body, $response->body->Contents)) foreach ($response->body->Contents as $c) { $results[(string)$c->Key] = array( 'name' => (string)$c->Key, 'time' => strToTime((string)$c->LastModified), 'size' => (int)$c->Size, 'hash' => substr((string)$c->ETag, 1, -1) ); $lastMarker = (string)$c->Key; } } while ($response !== false && (string)$response->body->IsTruncated == 'true'); return $results; } /** * Put a bucket * * @param string $bucket Bucket name * @param constant $acl ACL flag * @return boolean */ public function putBucket($bucket, $acl = self::ACL_PRIVATE) { $rest = new S3Request('PUT', $bucket, ''); $rest->setAmzHeader('x-amz-acl', $acl); $rest = $rest->getResponse(); if ($rest->error === false && $rest->code !== 200) $rest->error = array('code' => $rest->code, 'message' => 'Unexpected HTTP status'); if ($rest->error !== false) { trigger_error(sprintf("S3::putBucket({$bucket}): [%s] %s", $rest->error['code'], $rest->error['message']), E_USER_WARNING); return false; } return true; } /** * Delete an empty bucket * * @param string $bucket Bucket name * @return boolean */ public function deleteBucket($bucket = '') { $rest = new S3Request('DELETE', $bucket); $rest = $rest->getResponse(); if ($rest->error === false && $rest->code !== 204) $rest->error = array('code' => $rest->code, 'message' => 'Unexpected HTTP status'); if ($rest->error !== false) { trigger_error(sprintf("S3::deleteBucket({$bucket}): [%s] %s", $rest->error['code'], $rest->error['message']), E_USER_WARNING); return false; } return true; } /** * Create input info array for putObject() * * @param string $file Input file * @param mixed $md5sum Use MD5 hash (supply a string if you want to use your own) * @return array | false */ public static function inputFile($file, $md5sum = true) { if (!file_exists($file) || !is_file($file) || !is_readable($file)) { trigger_error('S3::inputFile(): Unable to open input file: '.$file, E_USER_WARNING); return false; } return array('file' => $file, 'size' => filesize($file), 'md5sum' => $md5sum !== false ? (is_string($md5sum) ? $md5sum : base64_encode(md5_file($file, true))) : ''); } /** * Use a resource for input * * @param string $file Input file * @param integer $bufferSize Input byte size * @param string $md5sum MD5 hash to send (optional) * @return array | false */ public static function inputResource(&$resource, $bufferSize, $md5sum = '') { if (!is_resource($resource) || $bufferSize <= 0) { trigger_error('S3::inputResource(): Invalid resource or buffer size', E_USER_WARNING); return false; } $input = array('size' => $bufferSize, 'md5sum' => $md5sum); $input['fp'] =& $resource; return $input; } /** * Put an object * * @param mixed $input Input data * @param string $bucket Bucket name * @param string $uri Object URI * @param constant $acl ACL constant * @param array $metaHeaders Array of x-amz-meta-* headers * @param string $contentType Content type * @return boolean */ public static function putObject($input, $bucket, $uri, $acl = self::ACL_PRIVATE, $metaHeaders = array(), $contentType = null) { if ($input == false) return false; $rest = new S3Request('PUT', $bucket, $uri); if (is_string($input)) $input = array( 'data' => $input, 'size' => strlen($input), 'md5sum' => base64_encode(md5($input, true)) ); // Data if (isset($input['fp'])) $rest->fp =& $input['fp']; elseif (isset($input['file'])) $rest->fp = @fopen($input['file'], 'rb'); elseif (isset($input['data'])) $rest->data = $input['data']; // Content-Length (required) if (isset($input['size']) && $input['size'] > 0) $rest->size = $input['size']; else { if (isset($input['file'])) $rest->size = filesize($input['file']); elseif (isset($input['data'])) $rest->size = strlen($input['data']); } // Content-Type if ($contentType !== null) $input['type'] = $contentType; elseif (!isset($input['type']) && isset($input['file'])) $input['type'] = self::__getMimeType($input['file']); else $input['type'] = 'application/octet-stream'; // We need to post with the content-length and content-type, MD5 is optional if ($rest->size > 0 && ($rest->fp !== false || $rest->data !== false)) { $rest->setHeader('Content-Type', $input['type']); if (isset($input['md5sum'])) $rest->setHeader('Content-MD5', $input['md5sum']); $rest->setAmzHeader('x-amz-acl', $acl); foreach ($metaHeaders as $h => $v) $rest->setAmzHeader('x-amz-meta-'.$h, $v); $rest->getResponse(); } else $rest->response->error = array('code' => 0, 'message' => 'Missing input parameters'); if ($rest->response->error === false && $rest->response->code !== 200) $rest->response->error = array('code' => $rest->response->code, 'message' => 'Unexpected HTTP status'); if ($rest->response->error !== false) { trigger_error(sprintf("S3::putObject(): [%s] %s", $rest->response->error['code'], $rest->response->error['message']), E_USER_WARNING); return false; } return true; } /** * Puts an object from a file (legacy function) * * @param string $file Input file path * @param string $bucket Bucket name * @param string $uri Object URI * @param constant $acl ACL constant * @param array $metaHeaders Array of x-amz-meta-* headers * @param string $contentType Content type * @return boolean */ public static function putObjectFile($file, $bucket, $uri, $acl = self::ACL_PRIVATE, $metaHeaders = array(), $contentType = null) { return self::putObject(S3::inputFile($file), $bucket, $uri, $acl, $metaHeaders, $contentType); } /** * Put an object from a string (legacy function) * * @param string $string Input data * @param string $bucket Bucket name * @param string $uri Object URI * @param constant $acl ACL constant * @param array $metaHeaders Array of x-amz-meta-* headers * @param string $contentType Content type * @return boolean */ public function putObjectString($string, $bucket, $uri, $acl = self::ACL_PRIVATE, $metaHeaders = array(), $contentType = 'text/plain') { return self::putObject($string, $bucket, $uri, $acl, $metaHeaders, $contentType); } /** * Get an object * * @param string $bucket Bucket name * @param string $uri Object URI * @param mixed &$saveTo Filename or resource to write to * @return mixed */ public static function getObject($bucket = '', $uri = '', $saveTo = false) { $rest = new S3Request('GET', $bucket, $uri); if ($saveTo !== false) { if (is_resource($saveTo)) $rest->fp =& $saveTo; else if (($rest->fp = @fopen($saveTo, 'wb')) == false) $rest->response->error = array('code' => 0, 'message' => 'Unable to open save file for writing: '.$saveTo); } if ($rest->response->error === false) $rest->getResponse(); if ($rest->response->error === false && $rest->response->code !== 200) $rest->response->error = array('code' => $rest->response->code, 'message' => 'Unexpected HTTP status'); if ($rest->response->error !== false) { trigger_error(sprintf("S3::getObject({$bucket}, {$uri}): [%s] %s", $rest->response->error['code'], $rest->response->error['message']), E_USER_WARNING); return false; } $rest->file = realpath($saveTo); return $rest->response; } /** * Get object information * * @param string $bucket Bucket name * @param string $uri Object URI * @param boolean $returnInfo Return response information * @return mixed | false */ public static function getObjectInfo($bucket = '', $uri = '', $returnInfo = true) { $rest = new S3Request('HEAD', $bucket, $uri); $rest = $rest->getResponse(); if ($rest->error === false && ($rest->code !== 200 && $rest->code !== 404)) $rest->error = array('code' => $rest->code, 'message' => 'Unexpected HTTP status'); if ($rest->error !== false) { trigger_error(sprintf("S3::getObjectInfo({$bucket}, {$uri}): [%s] %s", $rest->error['code'], $rest->error['message']), E_USER_WARNING); return false; } return $rest->code == 200 ? $returnInfo ? $rest->headers : true : false; } /** * Set logging for a bucket * * @param string $bucket Bucket name * @param string $targetBucket Target bucket (where logs are stored) * @param string $targetPrefix Log prefix (e,g; domain.com-) * @return boolean */ public static function setBucketLogging($bucket, $targetBucket, $targetPrefix) { $dom = new DOMDocument; $bucketLoggingStatus = $dom->createElement('BucketLoggingStatus'); $bucketLoggingStatus->setAttribute('xmlns', 'http://s3.amazonaws.com/doc/2006-03-01/'); $loggingEnabled = $dom->createElement('LoggingEnabled'); $loggingEnabled->appendChild($dom->createElement('TargetBucket', $targetBucket)); $loggingEnabled->appendChild($dom->createElement('TargetPrefix', $targetPrefix)); // TODO: Add TargetGrants $bucketLoggingStatus->appendChild($loggingEnabled); $dom->appendChild($bucketLoggingStatus); $rest = new S3Request('PUT', $bucket, ''); $rest->setParameter('logging', null); $rest->data = $dom->saveXML(); $rest->size = strlen($rest->data); $rest->setHeader('Content-Type', 'application/xml'); $rest = $rest->getResponse(); if ($rest->error === false && $rest->code !== 200) $rest->error = array('code' => $rest->code, 'message' => 'Unexpected HTTP status'); if ($rest->error !== false) { trigger_error(sprintf("S3::setBucketLogging({$bucket}, {$uri}): [%s] %s", $rest->error['code'], $rest->error['message']), E_USER_WARNING); return false; } return true; } /** * Get logging status for a bucket * * This will return false if logging is not enabled. * Note: To enable logging, you also need to grant write access to the log group * * @param string $bucket Bucket name * @return array | false */ public static function getBucketLogging($bucket = '') { $rest = new S3Request('GET', $bucket, ''); $rest->setParameter('logging', null); $rest = $rest->getResponse(); if ($rest->error === false && $rest->code !== 200) $rest->error = array('code' => $rest->code, 'message' => 'Unexpected HTTP status'); if ($rest->error !== false) { trigger_error(sprintf("S3::getBucketLogging({$bucket}): [%s] %s", $rest->error['code'], $rest->error['message']), E_USER_WARNING); return false; } if (!isset($rest->body->LoggingEnabled)) return false; // No logging return array( 'targetBucket' => (string)$rest->body->LoggingEnabled->TargetBucket, 'targetPrefix' => (string)$rest->body->LoggingEnabled->TargetPrefix, ); } /** * Set object or bucket Access Control Policy * * @param string $bucket Bucket name * @param string $uri Object URI * @param array $acp Access Control Policy Data (same as the data returned from getAccessControlPolicy) * @return boolean */ public static function setAccessControlPolicy($bucket, $uri = '', $acp = array()) { $dom = new DOMDocument; $dom->formatOutput = true; $accessControlPolicy = $dom->createElement('AccessControlPolicy'); $accessControlList = $dom->createElement('AccessControlList'); // It seems the owner has to be passed along too $owner = $dom->createElement('Owner'); $owner->appendChild($dom->createElement('ID', $acp['owner']['id'])); $owner->appendChild($dom->createElement('DisplayName', $acp['owner']['name'])); $accessControlPolicy->appendChild($owner); foreach ($acp['acl'] as $g) { $grant = $dom->createElement('Grant'); $grantee = $dom->createElement('Grantee'); $grantee->setAttribute('xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance'); if (isset($g['id'])) { // CanonicalUser (DisplayName is omitted) $grantee->setAttribute('xsi:type', 'CanonicalUser'); $grantee->appendChild($dom->createElement('ID', $g['id'])); } elseif (isset($g['email'])) { // AmazonCustomerByEmail $grantee->setAttribute('xsi:type', 'AmazonCustomerByEmail'); $grantee->appendChild($dom->createElement('EmailAddress', $g['email'])); } elseif ($g['type'] == 'Group') { // Group $grantee->setAttribute('xsi:type', 'Group'); $grantee->appendChild($dom->createElement('URI', $g['uri'])); } $grant->appendChild($grantee); $grant->appendChild($dom->createElement('Permission', $g['permission'])); $accessControlList->appendChild($grant); } $accessControlPolicy->appendChild($accessControlList); $dom->appendChild($accessControlPolicy); $rest = new S3Request('PUT', $bucket, ''); $rest->setParameter('acl', null); $rest->data = $dom->saveXML(); $rest->size = strlen($rest->data); $rest->setHeader('Content-Type', 'application/xml'); $rest = $rest->getResponse(); if ($rest->error === false && $rest->code !== 200) $rest->error = array('code' => $rest->code, 'message' => 'Unexpected HTTP status'); if ($rest->error !== false) { trigger_error(sprintf("S3::setAccessControlPolicy({$bucket}, {$uri}): [%s] %s", $rest->error['code'], $rest->error['message']), E_USER_WARNING); return false; } return true; } /** * Get object or bucket Access Control Policy * * Currently this will trigger an error if there is no ACL on an object (will fix soon) * * @param string $bucket Bucket name * @param string $uri Object URI * @return mixed | false */ public static function getAccessControlPolicy($bucket, $uri = '') { $rest = new S3Request('GET', $bucket, $uri); $rest->setParameter('acl', null); $rest = $rest->getResponse(); if ($rest->error === false && $rest->code !== 200) $rest->error = array('code' => $rest->code, 'message' => 'Unexpected HTTP status'); if ($rest->error !== false) { trigger_error(sprintf("S3::getAccessControlPolicy({$bucket}, {$uri}): [%s] %s", $rest->error['code'], $rest->error['message']), E_USER_WARNING); return false; } $acp = array(); if (isset($rest->body->Owner, $rest->body->Owner->ID, $rest->body->Owner->DisplayName)) { $acp['owner'] = array( 'id' => (string)$rest->body->Owner->ID, 'name' => (string)$rest->body->Owner->DisplayName ); } if (isset($rest->body->AccessControlList)) { $acp['acl'] = array(); foreach ($rest->body->AccessControlList->Grant as $grant) { foreach ($grant->Grantee as $grantee) { if (isset($grantee->ID, $grantee->DisplayName)) // CanonicalUser $acp['acl'][] = array( 'type' => 'CanonicalUser', 'id' => (string)$grantee->ID, 'name' => (string)$grantee->DisplayName, 'permission' => (string)$grant->Permission ); elseif (isset($grantee->EmailAddress)) // AmazonCustomerByEmail $acp['acl'][] = array( 'type' => 'AmazonCustomerByEmail', 'email' => (string)$grantee->EmailAddress, 'permission' => (string)$grant->Permission ); elseif (isset($grantee->URI)) // Group $acp['acl'][] = array( 'type' => 'Group', 'uri' => (string)$grantee->URI, 'permission' => (string)$grant->Permission ); else continue; } } } return $acp; } /** * Delete an object * * @param string $bucket Bucket name * @param string $uri Object URI * @return mixed */ public static function deleteObject($bucket = '', $uri = '') { $rest = new S3Request('DELETE', $bucket, $uri); $rest = $rest->getResponse(); if ($rest->error === false && $rest->code !== 204) $rest->error = array('code' => $rest->code, 'message' => 'Unexpected HTTP status'); if ($rest->error !== false) { trigger_error(sprintf("S3::deleteObject(): [%s] %s", $rest->error['code'], $rest->error['message']), E_USER_WARNING); return false; } return true; } /** * Get MIME type for file * * @internal Used to get mime types * @param string &$file File path * @return string */ public static function __getMimeType(&$file) { $type = false; // Fileinfo documentation says fileinfo_open() will use the // MAGIC env var for the magic file if (extension_loaded('fileinfo') && isset($_ENV['MAGIC']) && ($finfo = finfo_open(FILEINFO_MIME, $_ENV['MAGIC'])) !== false) { if (($type = finfo_file($finfo, $file)) !== false) { // Remove the charset and grab the last content-type $type = explode(' ', str_replace('; charset=', ';charset=', $type)); $type = array_pop($type); $type = explode(';', $type); $type = array_shift($type); } finfo_close($finfo); // If anyone is still using mime_content_type() } elseif (function_exists('mime_content_type')) $type = mime_content_type($file); if ($type !== false && strlen($type) > 0) return $type; // Otherwise do it the old fashioned way static $exts = array( 'jpg' => 'image/jpeg', 'gif' => 'image/gif', 'png' => 'image/png', 'tif' => 'image/tiff', 'tiff' => 'image/tiff', 'ico' => 'image/x-icon', 'swf' => 'application/x-shockwave-flash', 'pdf' => 'application/pdf', 'zip' => 'application/zip', 'gz' => 'application/x-gzip', 'tar' => 'application/x-tar', 'bz' => 'application/x-bzip', 'bz2' => 'application/x-bzip2', 'txt' => 'text/plain', 'asc' => 'text/plain', 'htm' => 'text/html', 'html' => 'text/html', 'xml' => 'text/xml', 'xsl' => 'application/xsl+xml', 'ogg' => 'application/ogg', 'mp3' => 'audio/mpeg', 'wav' => 'audio/x-wav', 'avi' => 'video/x-msvideo', 'mpg' => 'video/mpeg', 'mpeg' => 'video/mpeg', 'mov' => 'video/quicktime', 'flv' => 'video/x-flv', 'php' => 'text/x-php' ); $ext = strToLower(pathInfo($file, PATHINFO_EXTENSION)); return isset($exts[$ext]) ? $exts[$ext] : 'application/octet-stream'; } /** * Generate the auth string: "AWS AccessKey:Signature" * * This uses the hash extension if loaded * * @internal Signs the request * @param string $string String to sign * @return string */ public static function __getSignature($string) { return 'AWS '.self::$__accessKey.':'.base64_encode(extension_loaded('hash') ? hash_hmac('sha1', $string, self::$__secretKey, true) : pack('H*', sha1( (str_pad(self::$__secretKey, 64, chr(0x00)) ^ (str_repeat(chr(0x5c), 64))) . pack('H*', sha1((str_pad(self::$__secretKey, 64, chr(0x00)) ^ (str_repeat(chr(0x36), 64))) . $string))))); } } final class S3Request { private $verb, $bucket, $uri, $resource = '', $parameters = array(), $amzHeaders = array(), $headers = array( 'Host' => '', 'Date' => '', 'Content-MD5' => '', 'Content-Type' => '' ); public $fp = false, $size = 0, $data = false, $response; /** * Constructor * * @param string $verb Verb * @param string $bucket Bucket name * @param string $uri Object URI * @return mixed */ function __construct($verb, $bucket = '', $uri = '') { $this->verb = $verb; $this->bucket = strtolower($bucket); $this->uri = $uri !== '' ? '/'.$uri : '/'; if ($this->bucket !== '') { $this->bucket = explode('/', $this->bucket); $this->resource = '/'.$this->bucket[0].$this->uri; $this->headers['Host'] = $this->bucket[0].'.s3.amazonaws.com'; $this->bucket = implode('/', $this->bucket); } else { $this->headers['Host'] = 's3.amazonaws.com'; if (strlen($this->uri) > 1) $this->resource = '/'.$this->bucket.$this->uri; else $this->resource = $this->uri; } $this->headers['Date'] = gmdate('D, d M Y H:i:s T'); $this->response = new STDClass; $this->response->error = false; } /** * Set request parameter * * @param string $key Key * @param string $value Value * @return void */ public function setParameter($key, $value) { $this->parameters[$key] = $value; } /** * Set request header * * @param string $key Key * @param string $value Value * @return void */ public function setHeader($key, $value) { $this->headers[$key] = $value; } /** * Set x-amz-meta-* header * * @param string $key Key * @param string $value Value * @return void */ public function setAmzHeader($key, $value) { $this->amzHeaders[$key] = $value; } /** * Get the S3 response * * @return object | false */ public function getResponse() { $query = ''; if (sizeof($this->parameters) > 0) { $query = substr($this->uri, -1) !== '?' ? '?' : '&'; foreach ($this->parameters as $var => $value) if ($value == null || $value == '') $query .= $var.'&'; else $query .= $var.'='.$value.'&'; $query = substr($query, 0, -1); $this->uri .= $query; if (isset($this->parameters['acl']) || !isset($this->parameters['logging'])) $this->resource .= $query; } $url = (extension_loaded('openssl')?'https://':'http://').$this->headers['Host'].$this->uri; //var_dump($this->bucket, $this->uri, $this->resource, $url); // Basic setup $curl = curl_init(); curl_setopt($curl, CURLOPT_USERAGENT, 'S3/php'); curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($curl, CURLOPT_URL, $url); // Headers $headers = array(); $amz = array(); foreach ($this->amzHeaders as $header => $value) if (strlen($value) > 0) $headers[] = $header.': '.$value; foreach ($this->headers as $header => $value) if (strlen($value) > 0) $headers[] = $header.': '.$value; foreach ($this->amzHeaders as $header => $value) if (strlen($value) > 0) $amz[] = strToLower($header).':'.$value; $amz = (sizeof($amz) > 0) ? "\n".implode("\n", $amz) : ''; // Authorization string $headers[] = 'Authorization: ' . S3::__getSignature( $this->verb."\n". $this->headers['Content-MD5']."\n". $this->headers['Content-Type']."\n". $this->headers['Date'].$amz."\n".$this->resource ); curl_setopt($curl, CURLOPT_HTTPHEADER, $headers); curl_setopt($curl, CURLOPT_HEADER, false); curl_setopt($curl, CURLOPT_RETURNTRANSFER, false); curl_setopt($curl, CURLOPT_WRITEFUNCTION, array(&$this, '__responseWriteCallback')); curl_setopt($curl, CURLOPT_HEADERFUNCTION, array(&$this, '__responseHeaderCallback')); // Request types switch ($this->verb) { case 'GET': break; case 'PUT': if ($this->fp !== false) { curl_setopt($curl, CURLOPT_PUT, true); curl_setopt($curl, CURLOPT_INFILE, $this->fp); if ($this->size > 0) curl_setopt($curl, CURLOPT_INFILESIZE, $this->size); } elseif ($this->data !== false) { curl_setopt($curl, CURLOPT_CUSTOMREQUEST, 'PUT'); curl_setopt($curl, CURLOPT_POSTFIELDS, $this->data); if ($this->size > 0) curl_setopt($curl, CURLOPT_BUFFERSIZE, $this->size); } else curl_setopt($curl, CURLOPT_CUSTOMREQUEST, 'PUT'); break; case 'HEAD': curl_setopt($curl, CURLOPT_CUSTOMREQUEST, 'HEAD'); curl_setopt($curl, CURLOPT_NOBODY, true); break; case 'DELETE': curl_setopt($curl, CURLOPT_CUSTOMREQUEST, 'DELETE'); break; default: break; } // Execute, grab errors if (curl_exec($curl)) $this->response->code = curl_getinfo($curl, CURLINFO_HTTP_CODE); else $this->response->error = array( 'code' => curl_errno($curl), 'message' => curl_error($curl), 'resource' => $this->resource ); @curl_close($curl); // Parse body into XML if ($this->response->error === false && isset($this->response->headers['type']) && $this->response->headers['type'] == 'application/xml' && isset($this->response->body)) { $this->response->body = simplexml_load_string($this->response->body); // Grab S3 errors if (!in_array($this->response->code, array(200, 204)) && isset($this->response->body->Code, $this->response->body->Message)) { $this->response->error = array( 'code' => (string)$this->response->body->Code, 'message' => (string)$this->response->body->Message ); if (isset($this->response->body->Resource)) $this->response->error['resource'] = (string)$this->response->body->Resource; unset($this->response->body); } } // Clean up file resources if ($this->fp !== false && is_resource($this->fp)) fclose($this->fp); return $this->response; } /** * CURL write callback * * @param resource &$curl CURL resource * @param string &$data Data * @return integer */ private function __responseWriteCallback(&$curl, &$data) { if ($this->response->code == 200 && $this->fp !== false) return fwrite($this->fp, $data); else $this->response->body .= $data; return strlen($data); } /** * CURL header callback * * @param resource &$curl CURL resource * @param string &$data Data * @return integer */ private function __responseHeaderCallback(&$curl, &$data) { if (($strlen = strlen($data)) <= 2) return $strlen; if (substr($data, 0, 4) == 'HTTP') $this->response->code = (int)substr($data, 9, 3); else { list($header, $value) = explode(': ', trim($data)); if ($header == 'Last-Modified') $this->response->headers['time'] = strtotime($value); elseif ($header == 'Content-Length') $this->response->headers['size'] = (int)$value; elseif ($header == 'Content-Type') $this->response->headers['type'] = $value; elseif ($header == 'ETag') $this->response->headers['hash'] = substr($value, 1, -1); elseif (preg_match('/^x-amz-meta-.*$/', $header)) $this->response->headers[$header] = is_numeric($value) ? (int)$value : $value; } return $strlen; } } ?>
  4. iarp
    Never said i was going to ignore your suggestion, just(to my knowledge) it seems to be more work. Using SUM(IF(yourColumn='yourValue'),1,0) instead of COUNT() in a query? As is my code is: <?php $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE DAmodeo"; $result = mysql_query($query); $dam = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE KArgyros"; $result = mysql_query($query); $kar = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE NBrooks"; $result = mysql_query($query); $nbr = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE RDube"; $result = mysql_query($query); $rdu = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE TField"; $result = mysql_query($query); $tfi = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE HFord"; $result = mysql_query($query); $hfo = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE JHawkins"; $result = mysql_query($query); $jha = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE CMacGregor"; $result = mysql_query($query); $cma = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE BMetler"; $result = mysql_query($query); $bme = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE RMillichamp"; $result = mysql_query($query); $rmi = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE WMoorehead"; $result = mysql_query($query); $wmo = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE KMurray"; $result = mysql_query($query); $kmu = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE DSabatino"; $result = mysql_query($query); $dsa = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE CSerrao"; $result = mysql_query($query); $cse = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE MSnowball"; $result = mysql_query($query); $msn = mysql_fetch_array($result); $query = "SELECT COUNT(*) FROM " . DB_VOTES . " WHERE ZStewart"; $result = mysql_query($query); $zst = mysql_fetch_array($result); ?> <hr /> <table width="100%" height="100%" cellpadding="3" cellspacing="0" border="0"> <p><h1>Results</h1></p> <tr><td width="50%" align="right">Domenic Amodeo</td> <td width="50%" align="left"><?php echo $dam[0]; ?></td></tr> <tr><td width="50%" align="right">Kathy Argyros</td> <td width="50%" align="left"><?php echo $kar[0]; ?></td></tr> <tr><td width="50%" align="right">Nancy Brooks</td> <td width="50%" align="left"><?php echo $nbr[0]; ?></td></tr> <tr><td width="50%" align="right">Ray Dube</td> <td width="50%" align="left"><?php echo $rdu[0]; ?></td></tr> <tr><td width="50%" align="right">Tina Field</td> <td width="50%" align="left"><?php echo $tfi[0]; ?></td></tr> <tr><td width="50%" align="right">Helen Ford</td> <td width="50%" align="left"><?php echo $hfo[0]; ?></td></tr> <tr><td width="50%" align="right">Joel Hawkins</td> <td width="50%" align="left"><?php echo $jha[0]; ?></td></tr> <tr><td width="50%" align="right">Chuck MacGregor</td> <td width="50%" align="left"><?php echo $cma[0]; ?></td></tr> <tr><td width="50%" align="right">Brian Metler</td> <td width="50%" align="left"><?php echo $bme[0]; ?></td></tr> <tr><td width="50%" align="right">Ron Millichamp</td> <td width="50%" align="left"><?php echo $rmi[0]; ?></td></tr> <tr><td width="50%" align="right">Wayne Moorehead</td> <td width="50%" align="left"><?php echo $wmo[0]; ?></td></tr> <tr><td width="50%" align="right">Keith Murray</td> <td width="50%" align="left"><?php echo $kmu[0]; ?></td></tr> <tr><td width="50%" align="right">Debbie Sabatino</td> <td width="50%" align="left"><?php echo $dsa[0]; ?></td></tr> <tr><td width="50%" align="right">Claudio Serrao</td> <td width="50%" align="left"><?php echo $cse[0]; ?></td></tr> <tr><td width="50%" align="right">Marshall Snowball</td> <td width="50%" align="left"><?php echo $msn[0]; ?></td></tr> <tr><td width="50%" align="right">Zach Stewart</td> <td width="50%" align="left"><?php echo $zst[0]; ?></td></tr> </table> ?>
  5. iarp
    I edited the code above: $query = "SELECT * FROM " . DB_VOTES; $result=mysql_query($query); $fields = mysql_list_fields($result); $columns = mysql_num_fields($fields); for ($i = 0; $i < $columns; $i++) { $l = mysql_field_name($fields, $i); $sql1 = "SELECT COUNT('$l') AS cnt FROM " . DB_VOTES; $result1 = mysql_query($sql1); $row = mysql_fetch_array($result1); echo $l; echo $row['cnt']; } But i'm not getting anything outputted.
  6. iarp
    Kind of hard to describe my database table but i have a screenshot. http://files.iarp.ca/images/ss.JPG What i'm trying to do is count how many 1's are in each column. Would i have to do something along the lines of.. $query3 = "SELECT COUNT(DAmodeo), COUNT(KArgyros), COUNT(NBrooks), COUNT(RDube), COUNT(TField), COUNT(HFord), COUNT(JHawkins), COUNT(CMacGregor), COUNT(BMetler), COUNT(RMillichamp), COUNT(WMoorehead), COUNT(KMurray), COUNT(DSabatino), COUNT(CSerrao), COUNT(MSnowball), COUNT(ZStewart) FROM " . DB_VOTES; There must be a simpler way.
  7. iarp
    Hey, download.php <?php # Script 12.10 - download_file.php // This pages handles file downloads through headers. // Check for an upload_id. if (isset($_GET['uid'])) { $uid = (int) $_GET['uid']; } else { // Big problem! $uid = 0; } require_once ('./includes/mysql_connect.php'); // Connect to the database. if ($uid > 0) { // Do not proceed! // Get the information for this file. $query = "SELECT file_name, file_type, file_size FROM " . DB_UPLOADS ." WHERE upload_id=$uid"; $result = mysql_query ($query); list ($fn, $ft, $fs) = mysql_fetch_array ($result, MYSQL_NUM); // Determine the file name on the server. $the_file = './files/' . $uid; // Check if it exists. if (file_exists ($the_file)) { // Send the file. header ("Content-Type: $ft\n"); header ("Content-disposition: attachment; filename=\"$fn\"\n"); header ("Content-Length: $fs\n"); readfile ($the_file); exit(); } else { // File doesn't exist. $page_title = 'File Download'; include ('./includes/header.php'); echo '<p><font color="red">The file could not be located on the server. We apologize for any inconvenience.</font></p>'; include ('./includes/footer.php'); } } include ('./includes/header.php'); $first = TRUE; // Initialize the variable. // Query the database. $query = "SELECT upload_id, file_name, ROUND(file_size/1024) AS fs, description, DATE_FORMAT(date_entered, '%M %e, %Y') AS d FROM " . DB_UPLOADS . " ORDER BY date_entered DESC"; $result = mysql_query ($query); // Display all the URLs. while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) { $bg = ($bg == '#eeeeee' ? '#ffffff' : '#eeeeee'); // If this is the first record, create the table header. if ($first) { echo '<div style="text-align: center;"><small>To use the links below, right click the File Name, Copy link location.<br />When dowloading files, you must SAVE the file with it\'s proper name.</small></div>'; echo '<table border="0" width="100%" cellspacing="3" cellpadding="3" align="center"> <tr> <td align="left" width="20%"><font size="+1">File Name</font></td> <td align="left" width="40%"><font size="+1">Description</font></td> <td align="center" width="20%"><font size="+1">File Size</font></td> <td align="left" width="20%"><font size="+1">Upload Date</font></td> </tr>'; $first = FALSE; // One record has been returned. } // End of $first IF. // Display each record. echo " <tr bgcolor=\"' . $bg . '\"> <td align=\"left\"><a href=\"./download.php?uid={$row['upload_id']}\">{$row['file_name']}</a></td> <td align=\"left\">" . stripslashes($row['description']) . "</td> <td align=\"center\">{$row['fs']}kb</td> <td align=\"left\">{$row['d']}</td> </tr>\n"; } // End of while loop. // If no records were displayed... if ($first) { echo '<div align="center">There are currently no files to be viewed.</div>'; } else { echo '</table>'; // Close the table. } include ('./includes/footer.php'); ?> But if i link to download.php?uid=1 and it links to test.pdf firefox recognizes it as a pdf BUT it's actual download name is download.php I've tried changing $the_file = './files/' . $uid; to $the_file = './files/' . $fn; But still no go.
  8. iarp
    Noted for next time. Thank you.
  9. iarp
    Hey, if (empty($_POST['page_url'])) { $name = $_POST['page_name']; $purl = preg_replace(' ', '-', $name); } else { $purl = escape_data($_POST['page_url']); } $_POST['page_name']; = let's stay... "example one" should that not set $purl = example-one ?
  10. iarp
    rep-rangers isn't a field. /rep-rangers/ /rep-rangers/events.php /rep-rangers/contest.php /rep-rangers/team.php /events/ /forms/index.php /forms/contact.php /tyke-league/ /tyke-league/team.php /tyke-league/events.php /tyke-league/calendar.php The above is how my directory is setup. They are physical files and folders. What i was shooting for was to allow someone to type in the above links and show the information found on /index.php?id=### Rather then have all those physical files in place. That is where i'm getting lost. Because all the tuts online only show ways of allowing /rep-rangers/ to show the pages info but not /tyke-league/
  11. iarp
    Now that you've said that, it sounds more like this wouldn't get the information from index.php?id=123 and display the url as /rep-rangers/
  12. iarp
    Hey, My main problem is... RewriteEngine On RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] That is my .htaccess now i think i may have read most tutorials found on Google over the last 2-3 weeks. Nothing as helped because everything on there helps with static url's like changing index.php?id=2 to /2.html and stuff. http://jonathanleighton.com/blog/keeping-track-of-uris That was the closest i ever got, i get lost at Because i don't understand what is being checked. I realize this is more mod_rewrite focused but no one replies to posts in the forum (on this domain). If finding out how to do this properly costs me, let me know.
  13. iarp
    TinyMCE - http://tinymce.moxiecode.com/ Best thing i've ever used... and free. It basically changes a <textarea> into what your looking for. <html> <head> <script language="javascript" type="text/javascript" src="../includes/tinymce/jscripts/tiny_mce/tiny_mce.js"></script> <script language="javascript" type="text/javascript"> tinyMCE.init({ // General options mode : "textareas", theme : "advanced", plugins : "safari,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template", // Theme options theme_advanced_buttons1 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect", theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor", theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen", theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak", theme_advanced_toolbar_location : "top", theme_advanced_toolbar_align : "left", theme_advanced_statusbar_location : "bottom", theme_advanced_resizing : true, // Drop lists for link/image/media/template dialogs template_external_list_url : "../includes/tinymce/examples/lists/template_list.js", external_link_list_url : "../includes/tinymce/examples/lists/link_list.js", external_image_list_url : "../includes/tinymce/examples/lists/image_list.js", media_external_list_url : "../includes/tinymce/examples/lists/media_list.js",}); </script> </head> <body> <div style="text-align: center; font-weight: bold; font-size: 14px;">Edit page</div> <form action="edit_page.php" class="edit_page" method="post"> <h3>Title</h3><input type="text" class="edit_name" name="page_name" size="15" maxlength="15" value="' . $row[0] . '" /> <br /><br /> <textarea name="content" class="edit_content">' . $row[1] . '</textarea><br /> <p>Last Edited By: ' . $row['2'] . '</p> <input type="submit" name="submit" value="Submit" /> <input type="hidden" name="submitted" value="TRUE" /> <input type="hidden" name="id" value="' . $id . '" /> </form> </body> <html> The example above, will create an advanced form for editing in the <textarea name="content" class="edit_content">' . $row[1] . '</textarea><br /> field. PM for more help if ya need.
  14. iarp
    <input type="submit" name="submit" value="Knowledge Test" />
  15. iarp
    This is completely re-written. You need to change 1 thing, on the form that submits to this page, you need to add: <input type="hidden" name="submitted" value="TRUE" /> Anywhere in between the <form> and </form> i usually put mine just before </form> Final code: <?php function escape_data($data) { if (ini_get('magic_quotes_gpc')){ $data = stripslashes($data); } if(function_exists('mysql_real_escape_string')) { global $dbc; $data = mysql_real_escape_string(trim($data), $dbc); } return $data; } if (isset($_POST['submitted'])) { // Handle the form. require_once ('./includes/mysql_connect.php'); // Connect to the database. //check for email address if (strlen($_POST['email']) <= 40) { if (eregi ('^[[:alnum:]][a-z0-9_\.\-]*@[a-z0-9\.\-]+\.[a-z]{2,4}$', stripslashes(trim($_POST['email'])))) { $e = escape_data($_POST['email']); } else { $e = FALSE; echo '<p><font color="red" size="+1">Please enter a valid email address!</font></p>'; } } else { $e = FALSE; echo '<p>The email address you provided exceeds maximum length of 40 letters</p>'; } // Check for a first name. if (strlen($_POST['firstname']) <= 20) { if (eregi ('^[[:alpha:]\.\' \-]{2,15}$', stripslashes(trim($_POST['firstname'])))) { $fn = escape_data($_POST['firstname']); $fn = ucwords($fn); } else { $fn = FALSE; echo '<p><font color="red" size="+1">Please enter your first name!</font></p>'; } } else { $fn = FALSE; echo '<p>First Name exceeds maximum length of 20 letters</p>'; } // Check for a last name. if (strlen($_POST['lastname']) <= 40) { if (eregi ('^[[:alpha:]\.\' \-]{2,30}$', stripslashes(trim($_POST['lastname'])))) { $ln = escape_data($_POST['lastname']); $ln = ucwords($ln); } else { $ln = FALSE; echo '<p><font color="red" size="+1">Please enter your last name!</font></p>'; } } else { $ln = FALSE; echo '<p>Last Name exceeds maximum length of 40 letters</p>'; } if ($fn && $ln && $e) { // If everything's OK. // Make sure the email address is available. $query = "SELECT * FROM emaillist WHERE email='$e'"; $result = mysql_query ($query) or trigger_error("Query: $query\n<br />MySQL Error: " . mysql_error()); if (mysql_num_rows($result) == 0) { // Available. // Add the user. $query = "INSERT INTO emaillist (email, firstname, lastname) VALUES ('$e', '$fn', '$ln')"; $result = mysql_querry ($query) or trigger_error("Query: $query\n<br />MySQL Error: " . mysql_error()); if (mysql_affected_rows() == 1) { // If it ran OK. // Finish the page. echo 'Welcome to the list, <b>$fn!</b><br />\nYour e-mail address: <b>$e</b> will be included in future e-mails.'; exit(); // exit the rest of the script. } else { // If it did not run OK. echo '<p><font color="red" size="+1">You could not be registered due to a system error. We apologize for any inconvenience.</font></p>'; } } else { // The email address is not available. echo '<p><font color="red" size="+1">That email address has already been registered.</font></p>'; } } else { // If one of the data tests failed. echo '<p><font color="red" size="+1">Please try again.</font></p>'; } mysql_close(); // Close the database connection. } else { echo "You have accessed this page in error!"; } // End of the main Submit conditional. ?> If your coding on your original page is correct, like the mysql querys and everything, i'm pretty sure this should work right off the bat.
  16. iarp
    I use wordpress, and i thought it used mod_rewrite to change my url's from index.php?post=178 to something like /2008/may/<post-name> So i ran into this tut http://www.workingwith.me.uk/articles/scripting/mod_rewrite and it looked promising. I wrote up alice.html http://www.iarp.ca/test/alice.html and i wrote up bob.html http://www.iarp.ca/test/bob.html i set this in .htaccess: RewriteEngine on RewriteRule ^alice.html$ bob.html But it just wouldn't work. So i kept searching and ran into an actual online generator and got this: RewriteEngine On RewriteRule ^([^/]*)\.newb$ /index.php?id=$1 [L] Now that works on another site i have (same host and server) but it's a static www.domain.com/#.html and i'm looking for ways to have links like www.domain.com/rep/home/ rather then www.domain.com/index.php?id=34 (which would change into domain.com/34.html)
  17. iarp
    The way i have it going on right now: <?php $page_title = 'Edit User'; require ('../includes/header.php'); if (isset($_POST['submitted'])) { $errors = array(); if (empty($_POST['site_name'])) { $errors[] = 'You forgot to enter the sites name!'; } else { $sn = $_POST['site_name']; $sn1 = 'site_name'; } if (empty($_POST['site_location'])) { $errors[] = 'The site is located where?'; } else { $sl = $_POST['site_location']; } if (empty($_POST['copyright'])) { $errors[] = 'You need the copyright'; } else { $cr = $_POST['copyright']; } if (empty($errors)) { $query = "UPDATE " . TBL_CONFIG . " SET config_value='$sn' WHERE config_name='$sn1'"; $result = mysql_query($query); //run the query if (mysql_affected_rows() == 1) { // if it ran ok //print a message messages(4); } else {// if it did not run ok echo '<h1> System error</h1> You didn\'t make any changes!'; } } else { //report the errors echo '<h1> Error</h1> <p class="error"> The following errors occured:<br />'; foreach ($errors as $msg) { //print each error echo " - $msg<br />\n"; } echo '</p><p>Plese try again.</p><p><br /></p>'; } } $query = "SELECT config_name,config_value FROM " . TBL_CONFIG; if ($result = mysql_query($query)) { if (mysql_num_rows($result)) { while ($row = mysql_fetch_assoc($result)) { $config[$row['config_name']] = $row['config_value']; } } } echo '<h3> Site Config </h3> <form action="config.php" method="post"> <p>Site Name: <input type="text" name="site_name" value="' . $config['site_name'] . '" /></p> <p>Site Location: <input type="text" name="site_location" value="' . $config['site_location'] . '" /></p> <p> Copyright: <input type="text" name="copyright" value="' . $config['copyright'] . '" /></p> <input type="submit" name="submit" value="Submit!" /> <input type="hidden" name="submitted" value="TRUE" /> </form>'; require('../includes/footer.php'); ?> I've only got the one query because i'm unsure of how to right a loop to do the rest of them.
  18. iarp
    Thanks, that worked very well.. My last thing i'm having a problem with, i have a feeling it'll require some type of loop $query = "UPDATE " . TBL_CONFIG . " SET config_value='$sn' WHERE config_name='$sn1'"; works only for site_name, can't figure out how to change it for all values submitted(which is basically everything)
  19. iarp
    On your IF statements change ad !empty... for example if (!empty($_POST['firstname'])) { ... etc Then add: else { $errors[] = "Error message here"; } to the end of the if's One example: if (!empty($_POST['firstname'])) { if (!preg_match("/^[a-z\\\'\-\s]+$/i", $firstname)) { $errors[] = "Please enter a valid first name."; } elseif (strlen($firstname) < 1) { $errors[] = "Please enter a valid first name."; } else { $firstname2 = $_POST['firstname']; } } else { $errors[] = "No name?"; } P.S. The [ b ] was me trying to bold the text i added, but it failed.
  20. iarp
    <?php $firstname = $_POST['firstname']; $lastname = $_POST['lastname']; $emailaddy = $_POST['email']; $doubleaddycheck = "SELECT * FROM emaillist WHERE email = $emailaddy"; $doubleaddycheck = mysql_query($doubleaddycheck); $insertcontactdata = "INSERT INTO emaillist (email, firstname, lastname) VALUES ('$emailaddy2', '$firstname2', '$lastname2')"; $errors = array(); if ($_POST['email']) { if (!preg_match('/^[^\x00-\x20()<>@,;:\\".[\]\x7f-\xff]+(?:\.[^\x00-\x20()<>@,;:\\".[\]\x7f-\xff]+)*\@[^\x00-\x20()<>@,;:\\".[\]\x7f-\xff]+(?:\.[^\x00-\x20()<>@,;:\\".[\]\x7f-\xff]+)+$/i', $emailaddy)) { $errors[] = "Please enter a valid e-mail address."; } elseif (mysql_num_rows($doubleaddycheck) > 0) { $errors[] = "That e-mail address has already been added!"; } else { $emailaddy2 = $_POST['email']; } } if ($_POST['firstname']) { if (!preg_match("/^[a-z\\\'\-\s]+$/i", $firstname)) { $errors[] = "Please enter a valid first name."; } elseif (strlen($firstname) < 1) { $errors[] = "Please enter a valid first name."; } else { $firstname2 = $_POST['firstname']; } } if ($_POST['lastname']){ if (!preg_match("/^[a-z\\\'\-\s]+$/i", $lastname)) { $errors[] = "Please enter a valid last name."; } elseif (strlen($lastname)< 1) { $errors[] = "Please enter a valid last name."; } else { $lastname2 = $_POST['lastname']; } } if (empty($errors) { //if the array $errors is empty(everything passed) continue with the script and add the person. mysql_query($insertcontactdata); print "Welcome to the list<b> $firstname! </b><br />\n"; print "Your e-mail address: <b> $emailaddy </b>will be included in future e-mails."; } else { //the array has an error in it, print the error. echo 'Error <p>The following errors occured:<br />'; foreach ($errors as $msg) { echo " - $msg\n"; } echo '</p><p>Plese try again.</p>'; } ?> Try that, i had to realign the code alot 0.o i didn't know if it was so far off becuase of this [ code ]... w/e. I use an error array and then check to make sure the array is empty. If not then print the error messages.
  21. iarp
    That only selects the one value for site_name, unless i'm stuck having to do a query for each field.
  22. iarp
    This is the table: CREATE TABLE `GAMER_config` ( `config_id` int(10) unsigned NOT NULL auto_increment, `config_name` varchar(40) NOT NULL default '', `config_value` longtext NOT NULL, `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`config_id`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; -- -- Dumping data for table `GAMER_config` -- INSERT INTO `GAMER_config` VALUES (1, 'site_name', 'Gamer Strategy', 1); INSERT INTO `GAMER_config` VALUES (2, 'copyright', 'Gamer Strategy | Ian R-P', 1); INSERT INTO `GAMER_config` VALUES (3, 'site_location', '/test/', 1); I store some of the values in the database rather then a hardcoded included page because i find it's easier to edit the database values.
  23. iarp
    Maybe a better question would be, how could i select the value from the config_value field where the config_name equals whatever $row is set to? Like if i were to make a page for someone to edit the 2 rows i have listed above on the same page, what query should i use... gettin all confused now i've tired many different things at least to my best ability.
  24. iarp
    I had this snippet of coding below: $query = "SELECT config_value FROM " . TBL_CONFIG; $result = @mysql_query($query); //run the query $num = mysql_num_rows($result); if ($num > 0) { //vaild user id, show the form. //get the user's information. $row = mysql_fetch_array($result, MYSQL_ASSOC); Can i not just call $row['site_name'] rather then $row[0] and have to change MYSQL_ASSOC back to MYSQL_NUM ? I take it ASSOC allows you to use a fields name? In my database i have 2 columns called config_name and config_value and only 2 rows populated config_name config_value site_name iarp location /test/
  25. iarp
    Thank-you.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.