Clay Hopf chopf
chopf
/ reportemailcron.php dump
Created
September 8, 2015 20:40
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ubuntu@master:~/crons$ php reportemailcron.php | |
| September 8, 2015, 4:27 pm | |
| Checking ah_turnkey.... | |
| Checking alphaflightservices_brisbane0.... | |
| Checking angadc_angadl0.... | |
| Checking angelstadium_angelstadium0.... |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| COMMANDS | |
| MySQL PDO Notes | |
| $result = mysql_query($queryStr) $pdoStatement = $pdo->query($queryStr) | |
| mysql_fetch_array($result,$type = MYSQL_BOTH) $pdoStatement->fetch($type = PDO::FETCH_BOTH) | |
| mysql_error() NO EXACT EQUIVALENT $pdo->errorInfo() returns an array, [0=>ErrorCode,1=>Driver specific error code,2=>driver specific error message] | |
| mysql_insert_id() $pdo->lastInsertId() | |
| mysql_free_cursor() NO EXACT EQUIVALENT $pdoStatement->closeCursor() is similar but on statement not PDO | |
| mysql_select_db($dbName) NO EQUIVALENT PDO does not allow databases to be changed, you must create a new PDO connection, or if the info is the same you an use dot notation to query a different database | |
| mysql_real_escape_string($stringToEscape) $pdo->quote($stringToEscape) PDO::quote will add the quotes for you!!!! | |
chopf
/ rollout.dump
Created
August 15, 2015 19:27
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| deployment steps | |
| backed up SoniCloud | |
| removed all laravel tables from SoniCloud | |
| sudo php ~/sonicucode/laravel.php --update --branch='master' | |
| - failed due to lack of SoniCloud.sonicu_companies | |
| imported sql from test server. | |
| sudo php ~/sonicucode/laravel.php --update --branch='master' | |
| removed sonicu_companies table | |
| php artisan migrate | |
| php artisan db:seed |