$record = ORM::for_table($this->table_name)->where('id', $id)->find_one();
if(empty($record)){
return false;
}
foreach ($data as $key => $value){
$record->set($key,$value);
}
$result = $record->save();
define('DB_ENCRYPT_KEY','aabbccddeeff');
require_once __DIR__ . '/idiorm.php';
ORM::configure('mysql:host=localhost;dbname=xxxx');
ORM::configure('username', 'yyy');
ORM::configure('password', 'zzz');
ORM::configure('driver_options', [
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
]);
$query = "INSERT INTO {$table_name}(`e_id`,`description`) VALUES(:e_id,AES_ENCRYPT(:description,'xxyyzz'))";
result = ORM::for_table('users')->raw_execute($query,['e_id'=>1,'description'=>'あいうえお']);
$query = "UPDATE {$table_name} SET `description`=AES_ENCRYPT(:description,'xxyyzz') WHERE `e_id` = :e_id";
result = ORM::for_table('users')->raw_execute($query,['e_id'=>1,'description'=>'あいうえお']);
$result = DB::table('users')->insert([
['email' => \DB::raw("AES_ENCRYPT('{$xxx}',SHA2('".env('DB_ENCRYPT_KEY')."',512))"), 'token' => \DB::raw("AES_ENCRYPT('{$yyy}',SHA2('".env('DB_ENCRYPT_KEY')."',512))")]
]);
$record = DB::table('xxx')
->selectRaw("id,AES_DECRYPT(`yyy`,SHA2(:key1,512)) AS shop,AES_DECRYPT(`zzz`,SHA2(:key2,512)) AS token",['key1'=>env('DB_ENCRYPT_KEY'),'key2'=>env('DB_ENCRYPT_KEY')])
->whereRaw("AES_DECRYPT(`yyy`,SHA2(:key,512)) = :yyy", ['key'=>env('DB_ENCRYPT_KEY'),'yyy'=>$yyy])
->first();
define('DB_ENCRYPT_KEY','aabbccddeeff');
require_once __DIR__ . '/idiorm.php';
ORM::configure('mysql:host=localhost;dbname=xxxx');
ORM::configure('username', 'yyy');
ORM::configure('password', 'zzz');
ORM::configure('driver_options', [
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
]);
$email = "xxxx@gmail.com";
ORM::configure('logging', true);
try{
$orm = ORM::for_table('users')->select("id")->select_expr("AES_DECRYPT(`email`,'".DB_ENCRYPT_KEY."')","email")->select_expr("AES_DECRYPT(`name`,'".DB_ENCRYPT_KEY."')","name");
$orm->where_raw("AES_DECRYPT(`email`,?) = ?",array(DB_ENCRYPT_KEY,$email));
$record = $orm->find_one();
}catch (PDOException $e){
return null;
}
echo "<pre>";
var_dump(ORM::get_last_query());
echo "</pre>";
if(!empty($record)) {
echo "<pre>";
echo $record->id;
echo $record->email;
echo $record->name;
echo "</pre>";
}
下記実行
update wp_options set option_value='0' where option_name = 'thumbnail_size_w'; update wp_options set option_value='0' where option_name = 'thumbnail_size_h'; update wp_options set option_value='0' where option_name = 'medium_size_w'; update wp_options set option_value='0' where option_name = 'medium_size_h'; update wp_options set option_value='0' where option_name = 'large_size_w'; update wp_options set option_value='0' where option_name = 'large_size_h'; update wp_options set option_value='0' where option_name = 'medium_large_size_w'; update wp_options set option_value='0' where option_name = 'medium_large_size_h';
functions.phpに下記追加
function disable_image_sizes( $new_sizes ) {
unset( $new_sizes['1536x1536'] );
unset( $new_sizes['2048x2048'] );
unset( $new_sizes['post-thumbnail'] );
unset( $new_sizes['category-thumb'] );
unset( $new_sizes['homepage-thumb'] );
return $new_sizes;
}
add_filter( 'intermediate_image_sizes_advanced', 'disable_image_sizes' );
add_filter( 'big_image_size_threshold', '__return_false' );
public function get_post_by_post_name($post_name, $post_type = '', $post_status = 'publish')
{
global $wpdb;
$sql = array();
$sql[] = "SELECT p.*";
$sql[] = "FROM $wpdb->posts AS p";
$sql[] = "WHERE p.post_name " . $this->__get_sql_for_in($post_name);
if (!empty($post_type))
$sql[] = "AND p.post_type = '$post_type'";
if(!empty($post_status))
$sql[] = "AND p.post_status = '$post_status'";
$result = $wpdb->get_results(implode(' ', $sql));
if (empty($result))
return null;
return is_array($post_name) ? $result : $result[0];
}
protected function __get_sql_for_in($values, $is_number = false)
{
$quote = $is_number ? "" : "'";
$is_array = is_array($values);
$not = ($is_array && is_string($values[0]) && preg_match('/^.*\!=.+$/',$values[0])) || (!$is_array && is_string($values) && preg_match('/^.*\!=.+$/',$values));
$in = $not ? ' NOT IN' : ' IN';
$eq = $not ? '!=' : '=';
if($is_array){
foreach ($values as $i => $value) {
$values[$i] = preg_replace('/^(\!=|=)/', '', esc_sql($value));
$values[$i] = preg_replace('/^ /', '', esc_sql($value));
}
}else{
$values = preg_replace('/^(\!=|=)/','',esc_sql($values));
$values = preg_replace('/^ /','',esc_sql($values));
}
return $is_array && 1 < count($values) ? "{$in} ({$quote}" . implode("{$quote},{$quote}", $values) . "{$quote})" : ($is_array ? "{$eq} {$quote}{$values[0]}{$quote}" : "{$eq} {$quote}$values{$quote}");
}
public function get_url_by_regex($url = null,$replaces = null,$suffix = null)
{
$tmp = explode('?',empty($url) ? $_SERVER['REQUEST_URI'] : $url);
$url = 0<count($tmp) ? array_shift($tmp) : '';
$tmp = 0<count($tmp) ? array_pop($tmp) : '';
$tmp = explode('&',$tmp);
for($i=0;$i<count($replaces);$i+=2){
foreach ($tmp as $j => $q){
$tmp[$j] = preg_replace($replaces[$i],$replaces[$i+1],$q);
}
}
$tmp = array_diff($tmp,array(''));
$is_empty = empty($tmp);
return $url.($is_empty?'':'?'.implode('&',$tmp)) . (is_null($suffix)?'':($is_empty?'?':'&').preg_replace('/^[\?&]/','',$suffix));
}
$csvfile = date('YmdHis') . ".csv";
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename=' . $csvfile);
$fp = fopen('php://output','w');
stream_filter_append($fp, 'convert.iconv.UTF-8/CP932', STREAM_FILTER_WRITE);
fputcsv($fp, array('A','B','C'));
fclose($fp);