A day to said

switching php version(downgrade/upgrade

noreply@blogger.com (Unknown) — Mon, 14 Aug 2023 06:39:00 +0000

mac(local) switching php version(downgrade/upgrade)

*sample downgrade from 8.2 to 8.1

1. -install new desired php version,

brew install php@8.1

2. -unlink current php version

brew unlink php@8.2

3. -create symlink to the new php version

brew link php@8.1

4. -check if switch successfull

php -v

mysql brew terminal

noreply@blogger.com (Unknown) — Tue, 04 Apr 2023 01:21:00 +0000

brew install mysql@5.7

echo 'export PATH="/opt/homebrew/opt/mysql@5.7/bin:$PATH"' >> ~/.zshrc

exec zsh

chmod -R 777 /usr/local/var/mysql/

sql table filesize

noreply@blogger.com (Unknown) — Tue, 21 Mar 2023 08:22:00 +0000

SELECT TABLE_SCHEMA AS `Database`,
TABLE_NAME AS `Table`,
ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
FROM information_schema.TABLES
ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;

SELECT TABLE_SCHEMA AS `Database`,
TABLE_NAME AS `Table`,
ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
FROM information_schema.TABLES

where TABLE_SCHEMA = 'databasename'

ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;

TIME OVER LAPPING START

noreply@blogger.com (Unknown) — Mon, 13 Mar 2023 07:57:00 +0000

/* TIME OVER LAPPING START */
    $overlapping_time = false;
    // push weekday & time then sort
    $day_time_arrs = array();
    foreach($weekdays as $kwd => $wd){
        $day_time_arrs[date("N", strtotime($wd))] = array(
            $start_time[$kwd], $end_time[$kwd],[$kwd]
        );
    }
    ksort($day_time_arrs);
    $date_time_arrs = array();
    foreach($day_time_arrs as $kdta => $dta){
        $days_cur = $dta;
        $dcur = date("Y-m-d", strtotime("1989-09-19 +{$kdta} day"));
        $st = date("Y-m-d h:i", strtotime("{$dcur} {$dta[0]}"));
        $et = date("Y-m-d h:i", strtotime("{$dcur} {$dta[1]}"));
        if(strtotime($dta[1]) < strtotime($dta[0])){
            $et = date("Y-m-d h:i", strtotime("{$et} +1 day"));
        }
        $date_time_arrs[] = array($st, $et, $kdta);
    }
    p($date_time_arrs);
    $last_dtta = end($date_time_arrs);
    foreach($date_time_arrs as $kdtta => $dtta){
        if($kdtta == 0){
            $st_prev = date("Y-m-d h:i", strtotime($last_dtta[0]));
            $et_prev = date("Y-m-d h:i", strtotime($last_dtta[1]));
            if($last_dtta[2] == 7 && $dtta[2] == 1){
                $dd = date("Y-m-d", strtotime("{$dtta[0]} -1 day"));
                $dd_2 = date("Y-m-d", strtotime("{$dtta[0]}"));
                $st_prev = date("{$dd} h:i", strtotime($last_dtta[0]));
                $et_prev = date("Y-m-d h:i", strtotime($last_dtta[1]));
                $a_st_prev = date("A", strtotime($last_dtta[0]));
                $a_et_prev = date("A", strtotime($last_dtta[1]));
                if($a_st_prev == "PM" && $a_et_prev == "AM"){
                    $et_prev = date("{$dd_2} h:i", strtotime($last_dtta[1]));
                }
                else{
                    $et_prev = date("{$dd} h:i", strtotime($last_dtta[1]));
                }
            }
        }
        else{
            $dtta_prev = $date_time_arrs[$kdtta - 1];
            $st_prev = date("Y-m-d h:i", strtotime($dtta_prev[0]));
            $et_prev = date("Y-m-d h:i", strtotime($dtta_prev[1]));
        }
        $st = $dtta[0];
        $et = $dtta[1];
        if($st_prev <= $et && $st <= $et_prev){
            echo "over lap on prev : [$dtta[2]] {$st} - {$et}<br>";
        }
    }
    exit;

download laravel vue csv

noreply@blogger.com (Unknown) — Tue, 07 Mar 2023 22:40:00 +0000

<template>
    <vue-csv-downloader
        :data="data"
        :fields="fields"
    >
    </vue-csv-downloader>
</template>

<script>
import VueCsvDownloader from 'vue-csv-downloader';

export default {
    components: {
        VueCsvDownloader,
    },
    data() {
        return {
            data: [
                {id: 1, fruit: 'Apple', price: 4.50, unit: 'lb'},
                {id: 2, fruit: 'Blueberry', price: 3.00, unit: 'lb'},
                {id: 3, fruit: 'Pineapple', price: 5.15, unit: 'each'},
            ],
            fields: ['fruit', 'price', 'unit'],
        };
    },
};
</script>

how to run laravel

noreply@blogger.com (Unknown) — Mon, 06 Feb 2023 00:15:00 +0000

1 php artisan serve

2 npm run dev

install laravel + github

noreply@blogger.com (Unknown) — Mon, 30 Jan 2023 06:44:00 +0000

npm install // clone bago repo
npm run dev
php artisan serve

VITE v4.0.4 ready in 663 ms

➜ Local: http://localhost:5173/
➜ Network: use --host to expose
➜ press h to show help

Composer

Php -version
composer install

Install php on terminal common
A. Brew install php

jquery disable readonly datepicker

noreply@blogger.com (Unknown) — Mon, 23 Jan 2023 05:42:00 +0000

jQuery.datepicker.setDefaults({ beforeShow: function (i) {

if (jQuery(i).attr("readonly")) { return false; }

}

});

how to install laravel

noreply@blogger.com (Unknown) — Thu, 05 May 2022 00:54:00 +0000

laravel 9 installation
 
https://laravel.com/docs/9.x#installation-via-composer
 
 
-install php 8.1.4
brew install php
 
-install composer
https://getcomposer.org/download/
 
-after installation composer, run on terminal
sudo mv composer.phar /usr/local/bin/composer
 
export PATH="$HOME/.composer/vendor/bin:$PATH"
 
cd boost-web-portal
php artisan serve
 
brew install mysql@5.7
 
echo 'export PATH="/opt/homebrew/opt/mysql@5.7/bin:$PATH"' >> ~/.zshrc
 
exec zsh
 
chmod -R 777 /usr/local/var/mysql/
 
mysql.server start
mysql.server stop

css transition margin lefts

noreply@blogger.com (Unknown) — Thu, 27 Feb 2020 08:25:00 +0000

transition: margin-left .2s;
-webkit-transition: margin-left .2s; / Safari 3.1 to 6.0 /{tag_menu}

install laravel with error

noreply@blogger.com (Unknown) — Wed, 19 Feb 2020 05:44:00 +0000

 composer create-project --prefer-dist laravel/laravel test

conflict jquery on boostrap tooltips

noreply@blogger.com (Unknown) — Wed, 19 Feb 2020 01:56:00 +0000

codeigniter wild card routing

noreply@blogger.com (Unknown) — Tue, 11 Feb 2020 09:17:00 +0000

set codeigniter routing

if you want a url to be

test.com/1/folder/controller/function

i.e test.com/1/settings/profile/update_profile
instead of
test.com/settings/profile/update_profile

$route['(:any)+/(.*)'] = "$2";
$route['([A-Za-z0-9_.])+/(.*)'] = "$2";

custom post type add tags wp

noreply@blogger.com (Unknown) — Mon, 28 Oct 2019 07:23:00 +0000

add this line to the section you register_post_type in functions.php in your theme folder

'taxonomies' => array('category', 'post_tag')

The full code is looks like this

add_action( 'init', 'create_post_type' );
function create_post_type() {
register_post_type( 'posttypename',
        array(
            'labels' => array(
                'name' => __( 'PostTypeName' ),
                'singular_name' => __( 'PostTypeName' )
            ),
            'public' => true,
            'has_archive' => true,
            'rewrite' => array('slug' => 'posttypename'),
            'supports' => array( 'title', 'editor', 'excerpt', 'custom-fields', 'thumbnail' ),
            'taxonomies' => array('category', 'post_tag') // this is IMPORTANT
        )
    
https://stackoverflow.com/questions/10245071/show-tag-panel-in-custom-post-type

Contact form 7 callback jquery

noreply@blogger.com (Unknown) — Sat, 12 Oct 2019 01:38:00 +0000

In version 3.3 new jQuery custom event triggers were introduced:

New: Introduce 5 new jQuery custom event triggers

wpcf7:invalid
wpcf7:spam
wpcf7:mailsent
wpcf7:mailfailed
wpcf7:submit

You can use wpcf7:invalid like the example below:

$(".wpcf7").on('wpcf7:invalid', function(event){
  // Your code here
});

add_filter( 'wpcf7_ajax_json_echo', array(&amp;$this, 'ajax_results_append') );

public function ajax_results_append($items, $results){

    global $wpcf7_contact_form;

    $items['onSubmit'] =     $wpcf7_contact_form-&gt;additional_setting( 'on_submit', false );

    // send it back because it's a filter

    return $items;

}

Search in all fields from every table of a MySQL database

noreply@blogger.com (Unknown) — Thu, 19 Sep 2019 04:47:00 +0000

SELECT
    CONCAT('SELECT * FROM ', A.TABLE_SCHEMA, '.', A.TABLE_NAME,
           ' WHERE ', A.COLUMN_NAME, ' LIKE \'%stuff%\';')
FROM INFORMATION_SCHEMA.COLUMNS A
WHERE
            A.TABLE_SCHEMA != 'mysql'
AND     A.TABLE_SCHEMA != 'innodb'
AND     A.TABLE_SCHEMA != 'performance_schema'
AND     A.TABLE_SCHEMA != 'information_schema'
AND
        (
            A.DATA_TYPE LIKE '%text%'
        OR
            A.DATA_TYPE LIKE '%char%'
        )
;

SQL copy field on database and put it in new field

noreply@blogger.com (Unknown) — Tue, 14 May 2019 08:02:00 +0000

update message
set new_columnname = message

codeigniter paypal

noreply@blogger.com (Unknown) — Mon, 08 Apr 2019 03:13:00 +0000

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
/**
* Disbursement
*
* @category Controller
* @version 1.0
* @author Christopher Cuizon
*/
class Paypal_test extends CI_Controller {

    var $enableSandbox;

    public function __construct(){

        parent::__construct();
        $this->enableSandboxoption = false; // if true sandbox iyaha if false kay live paypal

    }

    public function test(){
        $enableSandbox = $this->enableSandboxoption;
        $data['title'] = "TITLE";
        $paypalUrl      = $enableSandbox ? 'https://www.sandbox.paypal.com/cgi-bin/webscr' : 'https://www.paypal.com/cgi-bin/webscr';
        if ( $this->input->post('submit') ) {
            $inputs = [];
            foreach ($_POST as $key => $value) {
                $inputs[$key] = stripslashes($value);
            }
            $inputs['business']         = "paypal@payer.com";    // email merchant mao ning atoa
            $inputs['no_shipping']      = "1";
            $inputs['cancel_return']    = stripslashes(base_url("/test/devtools/paypal_test/cancel_return")); // cancel ang return landing page
            $inputs['return']           = stripslashes(base_url("/test/devtools/paypal_test/success/3"));     // return url success page
            $inputs['notify_url']       = stripslashes(base_url("test/devtools/paypal_test/ipn"));            // ipn used for callback and returns on paypal
            $inputs['currency_code']    = "PHP";                        // Currency USD , PHP
            $inputs['description']      = "paypal weee";                  // create your description
            $inputs['quantity']         = "1";                          // Quantity for 1 only
            $queryString                = http_build_query($inputs);    // Generate URL-encoded query string
            header('location:' . $paypalUrl . '?' . $queryString);      // redirect to paypal
            exit();
        }
        $this->load->view("pages/devtools/paypal_test_view", $data);


    }


    public function success(){
        echo "SUCCESS PAYMENT!!";
        p($_REQUEST);

    }

    /**
     * CALLBACK TO SAVE DATA FROM PAYPAL
     */
    public function ipn(){
        $f = array(
            "desc"              => json_encode($this->input->post()),
            'item_name'         => $this->input->post('item_name'),
            'item_number'       => $this->input->post('item_number'),
            'payment_status'    => $this->input->post('payment_status'),
            'payment_amount'    => $this->input->post('mc_gross'),
            'payment_currency' => $this->input->post('mc_currency'),
            'txn_id'            => $this->input->post('txn_id'),
            'receiver_email'    => $this->input->post('receiver_email'),
            'payer_email'       => $this->input->post('payer_email'),
            'custom'            => $this->input->post('custom'),
            'qty'               => $this->input->post('quantity')
        );
        if ($this->verifyTransactions($_POST)) {
            esave("confirm_paypal", $f);
        }
    }

    /**
     * USE TO VERIFY TRANSACTION BETWEEN PAYPAL AND SERVER
     * @param object $data
     * @return boolean
     */
    public function verifyTransactions($data) {
        global $paypalUrl;
        $enableSandbox = $this->enableSandboxoption;

        $paypalUrl = $enableSandbox ? 'https://www.sandbox.paypal.com/cgi-bin/webscr' : 'https://www.paypal.com/cgi-bin/webscr';
        $req = 'cmd=_notify-validate';
        foreach ($data as $key => $value) {
            $value = urlencode(stripslashes($value));
            $value = preg_replace('/(.*[^%^0^D])(%0A)(.*)/i', '${1}%0D%0A${3}', $value); // IPN fix
            $req .= "&$key=$value";
        }

        $ch = curl_init($paypalUrl);
        curl_setopt($ch, CURLOPT_HTTP_VERSION, CURL_HTTP_VERSION_1_1);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $req);
        curl_setopt($ch, CURLOPT_SSLVERSION, 6);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1);
        curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
        curl_setopt($ch, CURLOPT_FORBID_REUSE, 1);
        curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 30);
        curl_setopt($ch, CURLOPT_HTTPHEADER, array('Connection: Close'));
        $res = curl_exec($ch);

        if (!$res) {
            $errno = curl_errno($ch);
            $errstr = curl_error($ch);
            curl_close($ch);
            throw new Exception("cURL error: [$errno] $errstr");
        }

        $info = curl_getinfo($ch);

        // Check the http response
        $httpCode = $info['http_code'];
        if ($httpCode != 200) { // dapat 200 ang return kay para dili bug
            throw new Exception("PayPal responded with http code $httpCode");
        }
        curl_close($ch);
        return $res === 'VERIFIED';
    }
}

view

<?php
       for($x = 1; $x <= 2; $x++){
             echo form_open_multipart();?>
                    <div class="panel price panel-red">
                        <input type="hidden" name="cmd" value="_xclick">
                        <input type="hidden" name="item_name" value="Bogarts Company <?php echo $x * .001;?>">
                        <input type="hidden" name="item_number" value="1111asdsd">
                        <input type="text" name="amount" value="<?php echo $x;?>000"> PHP
                            <h1>Price php <?php echo $x;?></h1>
                        <div class="panel-footer">
                            <input type="submit" name="submit" value="submit">
                        </div>
                    </div>
       <?php

               echo form_close();
       }

SQL select ñ

noreply@blogger.com (Unknown) — Tue, 05 Jun 2018 05:39:00 +0000

Try to use a BINARY operator to compare strings in binary way -

SELECT FIRST_NAME FROM CONTACT WHERE FIRST_NAME LIKE BINARY '%ñ%'

google iframe on share link

noreply@blogger.com (Unknown) — Wed, 21 Feb 2018 14:55:00 +0000

function gmap_embed(GoogleMapsURL)
{
    var coords = /\@([0-9\.\,\-a-zA-Z]*)/.exec(GoogleMapsURL);
    if(coords!=null)
    {
        var coordsArray = coords[1].split(',');
        return "https://www.google.com/maps/embed?pb=!1m14!1m12!1m3!1d20000!2d"+coordsArray[1]+"!3d"+coordsArray[0]+"!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!5e0!3m2!1sen!2suk!4v1486486434098";
    }
}

var x = "https://www.google.com.au/maps/place/Facebook+Sweden+AB/@59.3342921,-17.7954993,3z/data=!4m8!1m2!2m1!1sfacebook!3m4!1s0x465f9d5debf700a1:0xd882b8edb1c7e5a7!8m2!3d59.3342921!4d18.0638757";

alert( gmap_embed(x));

youtube removing suggested on iframe

noreply@blogger.com (Unknown) — Wed, 29 Nov 2017 04:37:00 +0000

just add this on the url
&iv_load_policy=3

https://www.youtube.com/embed/12312313?rel=0&controls=0&showinfo=0&iv_load_policy=3

or if you are using a javascript then add this

function youtube_video(str, ctr){
    if(str.search("youtube") > -1){
       jQuery(".pop-image").html("<div id='ivid_twopops' ctr='"+ctr+"'></div>");
       yt_thumb = str.split("/embed/");
       yt_thumb = yt_thumb[yt_thumb.length - 1];
       yt_thumb = yt_thumb.replace('"','');

       //yt_thumb = 'https://img.youtube.com/vi/'+yt_thumb+'/maxresdefault.jpg';
       player = new YT.Player('ivid_twopops', {
           width : '100%',
           height : '100%',
           videoId : yt_thumb,
           playerVars: { 'autoplay': 1,rel: 0 ,showinfo:0, 'fs' : 0, iv_load_policy:3},
           events : {
               'onReady' : virtual_start_video,
               'onStateChange' : virtual_end_video
           }
       });
    }else if(str.search("vimeo") > -1){
       jQuery(".pop-image").html("<iframe id='ivid_twopops' ctr='"+str+"' src='"+str+"?api=1&player_id=vplayer&autoplay=1'></div>");
       //<iframe src="'+bi.find(".embed iframe").attr("src")+'" width="225" height="125" frameborder="0" data-autoplay="'+bi_autoplay+'" data-loop="'+bi_loop+'"></iframe>
       vimeo_generator('#ivid_twopops');

    }
}

youtube resizing banner script

noreply@blogger.com (Unknown) — Tue, 28 Nov 2017 12:56:00 +0000

jQuery(window).resize(function(){

var x = jQuery(".wrapmytube");
    if(x.length){
        var vw = 16,
            vh = 9, d, w = jQuery(window).width(), h;

        //get dimension
        if(vw > vh){
            d = vw / vh;
        }else{
            d = vh / vw
        }

        //get height
        h = w / d;
        console.log('height = '+h);
        //jQuery("#with-banner-video .slides-wrap ul.slides li").css({"height":h});
        //jQuery("#banner-home").css({"height":h});
        x.find("iframe").css("height",h);
    }

});

html

<div class="wrapmytube"><iframe src="" width="100%" height="100%" frameborder="0"></iframe></div>

jvascript iframe youtube code

function youtube_video(str, ctr){
    if(str.search("youtube") > -1){
        jQuery(".pop-image").html("<div id='ivid_twopops' ctr='"+ctr+"'></div>");
        yt_thumb = str.split("/embed/");
        yt_thumb = yt_thumb[yt_thumb.length - 1];
        yt_thumb = yt_thumb.replace('"','');

        //yt_thumb = 'https://img.youtube.com/vi/'+yt_thumb+'/maxresdefault.jpg';
        player = new YT.Player('ivid_twopops', {
            width : '100%',
            height : '100%',
            videoId : yt_thumb,
            playerVars: { 'autoplay': 1,rel: 0 ,showinfo:0},
            events : {
                'onReady' : virtual_start_video,
                'onStateChange' : virtual_end_video
            }
        });
    }else if(str.search("vimeo") > -1){
        jQuery(".pop-image").html("<iframe id='ivid_twopops' ctr='"+str+"' src='"+str+"?api=1&player_id=vplayer&autoplay=1'></div>");
        //<iframe src="'+bi.find(".embed iframe").attr("src")+'" width="225" height="125" frameborder="0" data-autoplay="'+bi_autoplay+'" data-loop="'+bi_loop+'"></iframe>

    }
}

jQuery Popup center

noreply@blogger.com (Unknown) — Sun, 12 Nov 2017 13:09:00 +0000

$.fn.center = function() {
    this.css("position", "fixed");
    this.css("top", ($(window).height()/2 - this.height()/2) + "px");
    this.css("left", ($(window).width()/2 - this.width()/2) + "px");
    return this;
}

And use as described.

$(".twopoops").center();

php validate date YMD

noreply@blogger.com (Unknown) — Wed, 11 Oct 2017 01:19:00 +0000

function checkDateFormat($date)
{
 //match the format of the date
 if (preg_match ("/^([0-9]{4})-([0-9]{2})-([0-9]{2})$/", $date, $parts))
 {
  //check weather the date is valid of not
  if(checkdate($parts[2],$parts[3],$parts[1]))
   return true;
  else
  return false;
 }
 else
  return false;
}

PHP Create folder

noreply@blogger.com (Unknown) — Sun, 01 Oct 2017 03:50:00 +0000

unmasked(0);
to fix default of 22
0777
to 0755