sql - Merge Insert Into TABLE with an PHP ARRAY and for loop -

-

i have php array, coming database. array want insert different db/table. 2 fields (webinv_id,hostname) unique. update these table daily per script. if entry exist, must skip insert , should use update. that's working well. if run in php loop, insert or update first entry of array new table use 

merge table ...

for that. input array:

[0] => array     (         [ci_id] => 39778         [nodealias] => rt-2         [node] => 10.1.2.3         [serialnumber] => 8374378584         [vendorname] => cisco         [status] => active     )  [1] => array     (         [ci_id] => 72909         [nodealias] => rt-1         [node] => 10.1.1.3         [serialnumber] => 1276731237         [vendorname] => cisco         [status] => active     )...

here loop try insert or update of devices.

for ($i = 0; $i < count($router); $i++) {      $sql = "merge devices using ( select "             . "'" . $router[$i]['ci_id'] . "' webinv_id,"             . "'" . $router[$i]['nodealias'] . "' device_name,"             . "'" . $router[$i]['node'] . "' node,"             . "'" . $router[$i]['serialnumber'] . "' serialnumber,"             . "'" . $router[$i]['vendorname'] . "' vendorname,"             . "'" . $router[$i]['status'] . "' status,"             . "current_timestamp device_insert dual     ) s on ('" . $router[$i]['ci_id'] . "' = s.webinv_id          or '" . $router[$i]['nodealias'] . "' = s.device_name)     when matched update set status = '" . $router[$i]['status'] . "', device_update = current_timestamp     when not matched insert(webinv_id,device_name,node,serialnumber,vendorname,status,device_insert)     values ('" . $router[$i]['ci_id'] . "',"             . "'" . $router[$i]['nodealias'] . "',"             . "'" . $router[$i]['node'] . "',"             . "'" . $router[$i]['serialnumber'] . "',"             . "'" . $router[$i]['vendorname'] . "',"             . "'" . $router[$i]['status'] . "',"             . "current_timestamp)";      $stid = oci_parse($gnedb, $sql);     oci_execute($stid);  // executes , commits }

i've tried same code "oci_bind_by_name", result same, first entry used array. idea?

if using oci_bind_by_name understand use oracle database.

maybe should this:

$insert_query = "insert "; foreach($router $record) {   $fields = "";   $values = "";   foreach($record $field => $value) {     $fields .= $field . ($field != 'status' ? ',' : ""); // if in array last field status - if not might try figure out last column diferently or remove last ',' differently     $values .= "'" . $value . "'" . ($field != 'status' ? ',' : ""); // if in array last field status - if not might try figure out last column diferently or remove last ',' differently   }   $insert_query .= " devices (" . $fields . ") values (" . $values . ") "; }

the above create query $insert_query , need send database. additional thing need figure out fields should quoted , doesn't. quoted of them, since oracle should able cast values correctly - need double check (i have no oracle available check :) )

the sql construction use can found here.


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