Blog Spot!


Complete copy - paste SQL table from one database to another

Backup or copy - paste SQL table to another database.

"CREATE TABLE db_name.`table_name` SELECT * FROM old_db_name.`old_table_name`"

You can also use:

"CREATE TABLE IF NOT EXISTS ..."

If you don't want to do this if table is already copied or backed up!

Added on 14.Dec.2015
Tags: mysql sql backup copy move

Rename a table in MySQL

Renaming a table in MySQL

RENAME TABLE `users` TO `member`;

Added on 14.Dec.2015
Tags: sql query

Extract Icons from EXE Files in Ubuntu Linux

sudo apt-get install icoutils
wrestool -x -t 14 source.exe > output.ico

The above should result in a multi-layered file but it’s quicker and easier to open this proprietary Microsoft Windows .ICO in GIMP, select which icon you’d like to use then export it as a non-proprietary .PNG file to retain transparency.

Note: It seems that 64-bit executable binaries are not supported. I’m uncertain if that’s from structural differences or missing libs to add support, such as ia32-libs .

alastair

Added on 13.Dec.2015
Tags: linux ico wine

Scale up low resolution programs to fit screen, linux

...to get your screen to be filled up by applications.

xrandr --output LVDS1 --set "scaling mode" "Full"

forum.winehq.org

Added on 12.Dec.2015
Tags: cmd linux strech scale fullscreen xrandr monitor

PHP Database Access: Are You Doing It Correctly?

PDO, or PHP Data Objects, provides a more powerful API that doesn't care about the driver you use; it's database agnostic. Further, it offers the ability to use prepared statements, virtually eliminating any worry of SQL injection.

tutsplus

Added on 12.Dec.2015
Tags: mysql pdo php tutorial

Search


PHP Libraries


Carbon lib / docs
Idiorm lib / docs
Image Workshop lib / docs
lorenzos/Minixed lib / docs
Parsedown lib / docs
PHP Paginator lib / docs
PHP Redis lib / docs
QrCode lib / docs
Requests lib / docs
Slim lib / docs
Spyc lib / docs
TWIG lib / docs
Upload lib / docs
Validation lib / docs
Zebra Image lib / docs

JS Libraries


AJV lib / docs
BackboneJS lib / docs
Bootstrap Notify lib / docs
C3.js lib / docs
ChartJS lib / docs
FastMD5 lib / docs
HighlightJS lib / docs
jQuery-Storage lib / docs
JS-Cookie lib / docs
Leaflet JS lib / docs
LowDB lib / docs
Marked lib / docs
NeedlyJS lib / docs
ParcelJS lib / docs
RequireJS lib / docs
Swig lib / docs
Toastr lib / docs
Underscore lib / docs
ValidateJS lib / docs
top