mysql - Using awk on sql database to change all iframe "width" and "height" sizes -

-

i have wordpress database thousands of posts in it. need regex , awk command go through database (after mysql dump it) , change sizes uniform size width="600" height="350"

currently looks this:

some paragraph text here, description [tab:short code here] <iframe width="200" height="180" src="https://www.youtube.com/embed/ad4grqxzpfg" frameborder="0" allowfullscreen></iframe> [tab:different short code here] <iframe src="http://other-videohost.com/embed-ksq9vn3gwc16.html" frameborder=0 marginwidth=0 marginheight=0 scrolling=no width=250 height=300></iframe>

result in database should this:

some paragraph text here, description [tab:short code here] <iframe width="600" height="350" src="https://www.youtube.com/embed/ad4grqxzpfg" frameborder="0" allowfullscreen></iframe> [tab:different short code here] <iframe src="http://other-videohost.com/embed-ksq9vn3gwc16.html" frameborder=0 marginwidth=0 marginheight=0 scrolling=no width=600 height=350></iframe>

so additional information:

i'm going dump database mysqldump run successful command regex change target pattern without affecting images or other elements not iframes. fine target iframes since iframes used on site video embeds.

the server running wordpress on ubuntu 14.04

take notice width , height in cases behind src , in others in front of src such in example. want make non-case-sensitive.

suggestions , solutions welcome. thank guys.

with gnu awk gensub() , word boundaries (\<):

$ awk -v w=600 -v h=350 -v ignorecase=1 '{       $0 = gensub(/\<(width="?)[0-9]+("?)/,"\\1"w"\\2","g")       $0 = gensub(/\<(height="?)[0-9]+("?)/,"\\1"h"\\2","g")   } 1' file paragraph text here, description [tab:short code here] <iframe width="600" height="350" src="https://www.youtube.com/embed/ad4grqxzpfg" frameborder="0" allowfullscreen></iframe> [tab:different short code here] <iframe src="http://other-videohost.com/embed-ksq9vn3gwc16.html" frameborder=0 marginwidth=0 marginheight=0 scrolling=no width=600 height=350></iframe>

Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more