Saturday, June 29, 2013

move_uploaded_file To Current Path - PHP

$uploadfile = './' . basename($_FILES['file']['name']);

if (move_uploaded_file($_FILES['file']['tmp_name'], $uploadfile)) {
echo "File was successfully uploaded.\n";
} else {
echo "There was an issue uploading the file.\n";
}

Friday, June 28, 2013

View In Use and Will Not DROP - MySQL

I had several views in my MySQL database that were showing "In Use" and phpmyadmin would not let me drop them through the interface.

The solution:
Open the MySQL in terminal and "DROP VIEW yourView;"

Include Array From File - PHP

file.php
<?php
return array('item1','item2');
?>

Your php code:

<?php
$thisVariable = include('file.php');
print_r($thisVariable); //prints the array
?>

Sunday, June 16, 2013

Don't Use Nested IFNULL, Use COALESCE - MySQL

If you're looking for how to do a nested IFNULL, you probably need to be looking at how to use COALESCE instead. It returns the first non-null item in a list.

Example:
SELECT COALESCE(NULL,1);

Returns 1

IFNULL - MySQL

IFNULL(`field1`, `field2`)

That returns field1 if it's not null. However, it will return field2 if it is null.

Notes On JOIN - MySQL


  • If your INNER join is returning too few values and duplicates, you're probably using the wrong kind of join. Try a LEFT join.
  • INNER JOIN is the same as JOIN
  • http://i.stack.imgur.com/GbJ7N.png (diagram explaining joins)
  • LEFT JOIN is used - this will return ALL rows from Table1, regardless of whether or not there is a matching row in Table2. 

Indexes Help... A Lot

I just brought 4 queries from 15 seconds to less than 1 second by adding indexes to the columns in the ON() portion on the join.

Indexes help... A lot.

Saturday, June 15, 2013

Yii-Booster Incorrect Width

Set public $responsiveCss = false; to public $responsiveCss = true;

Thursday, June 13, 2013

group_concat - MySQL

http://mahmudahsan.wordpress.com/2008/08/27/mysql-the-group_concat-function/

This seems like it will be super useful.

If you're using "group by" and you still want to get data out of the grouped rows, then you can use this to combine multiple rows into a single row.

Wednesday, June 12, 2013

Looping Through Associative Array - PHP

http://stackoverflow.com/questions/1951690/php-how-to-loop-through-a-associative-array-and-get-the-key-name

This was totally not very intuitive. I was expecting something like this:

foreach($array as $sub) {
echo(key($sub));
}

Instead, it's this:

foreach ($decodedOutput as $key => $value) {
echo $key;
}