All posts by
.Input Boxes
Input box types Text Background text Text that vanished when you start typing into the box Feel free to comment if you can add help to this page or point out iss Numeric Integer values Allow values with decimal places Specifying A Value Automatically Submit On Enter Key Pressed Read Only Password Entry “password” will cause […]
Refil Form Values
//Allow form to be refilled if there is an error foreach($_POST as $key=>$value) { $$key = $value; }
Base64 Encoding
base64_encode $my_source_text = ‘{ Blah Blah ] }’; $my_base64_encoded_doc = base64_encode($my_source_text);
Upload A File From A Form
Basic Upload With Page Hanging Until Upload Completes <?php include_once('config.php'); require 'awssdk/aws.phar'; //<SDK so we can access S3 storage global $AwsS3BucketName; global $AwsS3AccessKeyId; global $AwsS3AccessSecretKey; $sdk = new Aws\Sdk([ 'version' => 'latest', 'region' => 'eu-west-1', //<<<<< REGION 'credentials' => [ 'key' => $AwsS3AccessKeyId, //<<<<< S3 ACCESS KEY ID 'secret' => $Aw if (isset($_POST[‘submit’])) { //—– […]
Adding Message To PHP Error Log
bool error_log (“Some message”, 0);
Querying Across Tables
This is PHP4 Code! Using IN Within A Normal SELECT Query You can select from within another tables results really easily like this: SqlCommand1->CommandText = "SELECT ProjectId \ FROM tblMyTable1 \ WHERE ProjectIsActive='TRUE' AND ProjectId IN (SELECT ProjectId FROM tblMyTable2 WHERE ProjectUsersAll='TRUE' OR UserId=@UserId) \ ORDER BY ProjectStartDate DESC"; Simple Find Name From Another Table […]
Searching An Entire Database
To search every row in every table in a database for a value Use the phpmyadmin ‘Search’ feature. Select your database (be sure you do have a DB selected and not a table) Click ‘Search’ tab Choose the search term you want Choose the tables to search
LIMIT Results
WHERE
Where value is in an array