Alex Rusin Blog

PHP MySQL Development

Upload to FTP with PHP
Byalexrusin April 29, 2018April 29, 2018

$fp = fopen(‘https://www.example.com/pdfdoc’, ‘r’); $user = “sammy”; $pass = “password”; $ftp_server = “192.168.10.10”; //should be wrapped in try catch to properly handle errors $ftp_conn = ftp_ssl_connect($ftp_server); $login = ftp_login($ftp_conn, $user, $pass); ftp_chdir($ftp_conn, ‘path/to/folder’); //can also use ftp_pwd ftp_pasv($ftp_conn, true); //passive mode ftp_fput($ftp_conn, “mydocument.pdf”, $fp, FTP_BINARY); fclose($fp); ftp_close($ftp_conn); Above code can be used to upload a…

Read More Upload to FTP with PHP
System Administration

Finding Directories And Files And Changing Permissions
Byalexrusin April 6, 2018

I always forget how to do this: find /var/www/html -type d -exec chmod 755 {} \; find /var/www/html -type f -exec chmod 644 {} \;

Read More Finding Directories And Files And Changing Permissions
System Administration

Node.js App on AWS EC2 Instance
Byalexrusin March 31, 2018March 31, 2018

To get started let’s spin up an Ubuntu 16.4 LTS instance on AWS. After instance is up and running, we need to add port 80 to the instance’s security group inbound rules. There should be at least two ports open: 22, and 80. Now we can ssh into the instance and install Nginx, Node, and…

Read More Node.js App on AWS EC2 Instance
Laravel

Using Local and Public Disks
Byalexrusin February 25, 2018February 25, 2018

Having vagrant run on Windows host machine may cause some problems with symbolic links. After trying to make symbolic links to work and failing, I decided to use public disk in development and local disk in production. php artisan storage:link makes symbolic link from “public/storage” to “storage/app/public”. When developing on windows-vagrant this command will not work properly,…

Read More Using Local and Public Disks
Laravel | PHP MySQL Development | System Administration

Laravel Jenkins CI
Byalexrusin November 26, 2017

This article covers installation of Jenkins on Ubuntu server and its usage to continuously integrate a Laravel application. Besides LAMP/LEMP stack we need to install Java, Git, Composer, and Node to successfully use Jenkins. Before starting to install this software, let’s take care of miscellaneous stuff. Miscellaneous (can skip this). Create mysql user and database….

Read More Laravel Jenkins CI
Laravel

Laravel: Getting Authenticated User Early in the Controller
Byalexrusin October 31, 2017April 29, 2020

Sometimes there is a need to access the authenticated user in your controller. If you do it in several methods in your controller, it makes sense to put the code in the constructor. Unfortunately, the code below will not work. This happens because the request is not injected into the controller at the time of…

Read More Laravel: Getting Authenticated User Early in the Controller
Laravel | PHP MySQL Development

Composer: Path Repositories
Byalexrusin October 30, 2017July 15, 2019

When working on a php package it is inconvenient to push the package to github (or other repository) and then wait for the package to update using composer update. For package development, composer has such feature as path repositories. Let’s imagine we have a two folders on the same level: my-app and package. my-app is an app — a test…

Read More Composer: Path Repositories
Laravel | System Administration

Adding Virtual Box Bridged Network Adapter to Laravel Homestead
Byalexrusin September 16, 2017September 16, 2017

Vagrant allows you to configure bridged network adapter, so your vagrant(homestead) box can be seen on local network. I order to make this possible by adding a line of code to homestear.rb script in scripts folder. I opted to add this line after the following code. if settings.has_key?(“networks”) settings[“networks”].each do |network| config.vm.network network[“type”], ip: network[“ip”], bridge: network[“bridge”]…

Read More Adding Virtual Box Bridged Network Adapter to Laravel Homestead
Laravel | PHP MySQL Development

Running Artisan Command as a Separate PHP Process in Laravel
Byalexrusin September 9, 2017September 9, 2017

In Laravel framework you can create commands and call them from php application. One command can call another command, and another command, and so on. But if an exception is thrown in one of the commands in this chain the whole chain breaks. In order to avoid this problem and run each artisan command as…

Read More Running Artisan Command as a Separate PHP Process in Laravel
PHP MySQL Development | WordPress Development

Create WordPress User with Admin Privileges in MySQL
Byalexrusin July 23, 2017July 23, 2017

INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`) VALUES (‘admin’, MD5(‘password’), ‘User Admin’, ‘user@admin.com’, ‘0’); INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’); INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_user_level’, ’10’);

Read More Create WordPress User with Admin Privileges in MySQL