mysql | EscapeQuotes

Yii2: create helper

How to create a new helper in Yii2 framework: Create a new file “Utils.php” in “app-basic\helpers” or in other folder, location is up to you, but keep things organized!

&lt;?php
namespace yii\helpers;
use Yii;
class Utils
{
public static function pre($mixed_data)
{ 
print '&lt;pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; 
white-space: -o-pre-wrap; 
background: #faf8f0; border: 1px solid silver; 
padding: 2px; font-weight: normal; font-family: Monospace, Courier"&gt;';
print_r($mixed_data);
<span style="line-height: 1.1em;">print '&lt;/pre&gt;'; 
</span><span style="line-height: 1.1em;">}
</span><span style="line-height: 1.1em;">public static function code($mixed_data)
</span><span style="line-height: 1.1em;">{
<span style="line-height: 1.1em;">
print '&lt;code style=" display: block; 
padding: 0.5em 1em; border: 1px solid #bebab0;"&gt;';
</span></span><span style="line-height: 1.1em;">print_r($mixed_data);
</span><span style="line-height: 1.1em;">print '&lt;/code&gt;';
</span><span style="line-height: 1.1em;">} 
</span>}

<?php

namespace yii\helpers;

use Yii;

class Utils

{

public static function pre($mixed_data)

{

print '<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap;

white-space: -o-pre-wrap;

background: #faf8f0; border: 1px solid silver;

padding: 2px; font-weight: normal; font-family: Monospace, Courier">';

print_r($mixed_data);

print '</pre>';

}

public static function code($mixed_data)

{

print '<code style=" display: block;

padding: 0.5em 1em; border: 1px solid #bebab0;">';

print_r($mixed_data);

print '</code>';

}

}

In this helper we have 2 functions to display raw

mysqld Option/Variable Reference

This table that lists every MySQL Server option or variable, what version it was introduced or deprecated in, whether it’s dynamic or not, whether variables have session/global/both scope, and links to the version-specific documentation for that variable. Name Intr Depr

MySQL Trigger – after insert trigger

I want to populate automaticaly another table when new data is inserted: For table “source_table” define a after insert trigger

DELIMITER $$
CREATE TRIGGER `source_table_AINS` AFTER INSERT ON `source_table` FOR EACH ROW
-- Edit trigger body code below this line. Do not edit lines above this one
begin 
insert into dest_table set source_id=NEW.id; 
end

DELIMITER $$

CREATE TRIGGER `source_table_AINS` AFTER INSERT ON `source_table` FOR EACH ROW

-- Edit trigger body code below this line. Do not edit lines above this one

begin

insert into dest_table set source_id=NEW.id;

end

The “NEW” alias contains all inserted fields into table “source_table”; After “insert” event on table “source_table”, we set the

MySQL Utilities – Brief overview of command-line utilities

MySQL Utilities This is a brief overview of the MySQL command-line utilities. See their respective manual pages for further details and examples: mysqlauditadmin Monitor the audit log. Copy, rotate, and configure the audit log mysqlauditgrep Search the audit log. Output results to

MySQL replication: PURGE BINARY LOGS and RESET MASTER

On MySQL master, “RESET MASTER” command, deletes all binary log files listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. This statement is intended to be used only

MySQL replication – master slave schema

Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous – slaves need not be connected permanently to receive updates from the master. This means

Save Apache log in MySQL database

Apache webserver can be configured to save access logs into database via Apache Module mod_log_config. This module provides for flexible logging of client requests. Logs are written in a customizable format, and may be written directly to a file, or to

mysql: –i-am-a-dummy

This option prevents MySQL from performing update operations unless a key constraint in the WHERE clause and / or a LIMIT clause are provided.

mysql --i-am-a-dummy -uroot test

1	mysql --i-am-a-dummy -uroot test

For beginners, a useful startup option is –safe-updates (or –i-am-a-dummy, which has the same effect).

Getting Started With CodeIgniter

If you are familiar with php, a good practice is to use a php framework to build your applications. One choice is CodeIgniter. CodeIgniter is based on the Model-View-Controller development pattern. MVC is a software approach that separates application logic

Hello world!

First article! Definitely must be a “Hello World” examples article. A “Hello World” program is a computer program which prints out “Hello, world!” on a display device. It is used in many introductory tutorials for teaching a programming language. It