php - CodeIgniter: first query runs successfully, second fails to change the database. Same value, different tables -

-

$customer_number being grabbed xml file and, due new code i've added, being sanitized ensure indeed int (i trying narrow down causes).

it's sanitized stored in aforementioned variable name (if echo variable, number displayed). placed 2 arrays 2 separate queries targeting exp_store_orders , exp_members tables respectively.

the first query executes without hitch. account_number updated fine value of $customer_number within exp_store_order table.

however, second smaller query fails update account_number field in exp_members table @ all.

if replace variable in $updatedata2 array simple number, such '1', second query supposed do. account_number field updated in exp_members.

i don't what's going on truth told.. don't how can int , work in first array\first query absolutely nothing (with no error!) in second.

any appreciated.

//searches , grabs xml files within directory. parses elements , stores values in variables. foreach(glob("/random/directory/listing/*xml") $filename) {     $xml= simplexml_load_file($filename);      $order_id = $xml->order_id;      $hash = $xml->hash;      $timestamp = $xml->timestamp;     $date = $xml->date;     $time = $xml->time;     $customer_number = $xml->customer_number;     $customer_number = filter_var($customer_number, filter_sanitize_number_int);     $member_id = $xml->member_id;     $shipping_account = $xml->shipping_account;     $shipping_carrier = $xml->shipping_carrier;     $shipping_tracking = $xml->shipping_tracking;     $response = $xml->response;     $response = filter_var($response, filter_sanitize_string);     $status_update = time();       //places variables within arrays fed queries.    $updatedata = array(        'response' => "$response",        'order_custom2' => "$shipping_account",        'order_custom3' => "$shipping_carrier",        'shipping_tracking' => "$shipping_tracking",        'order_completed_date' => "$timestamp",        'order_status_updated' => "$status_update",        'order_status_name' => "shipping",        'account_number' => "$customer_number"    );     $updatedata2 = array(        'account_number' => "$customer_number"    );     //update database values xml file, exp_store_orders , exp_members tables.    $qry = $this->ee->db->where('id = '.$order_id.'')                         ->update('exp_store_orders', $updatedata);      $qry2 = $this->ee->db->where('member_id = '.$member_id.'')                         ->update('exp_members', $updatedata2);      //remove files directory.    //unlink($filename);  }

edit: when change code , this: 

$updatedata2 = array(        'as400_account_number' => $xml->customer_number //$customer_number    );

i following error:

error number: 1064

you have error in sql syntax; check manual corresponds mysql server version right syntax use near 'where member_id = 1' @ line 1

update exp_members set as400_account_number = member_id = 1

   $updatedata2 = array(        'account_number' => $customer_number    );

remove quotes around $customer_number


Comments

Post a Comment

Popular posts from this blog

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

-
i read alot other solution still confused should mine... #include <opencv2/objdetect/objdetect.hpp> #include <opencv2/highgui/highgui.hpp> #include <opencv2/imgproc/imgproc.hpp> #include <iostream> #include <stdio.h> using namespace std; using namespace cv; int main(int argc, const char** argv) { //create cascade classifier object used face detection cascadeclassifier face_cascade; //use haarcascade_frontalface_alt.xml library face_cascade.load("haarcascade_frontalface_alt.xml"); //setup video capture device , link first capture device videocapture capturedevice; capturedevice.open(0); //setup image files used in capture process mat captureframe; mat grayscaleframe; //create window present results namedwindow("outputcapture", 1); //create loop capture , find faces while (true) { //capture new image frame capturedevice >> captureframe; ...
Read more

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

The canvas has been tainted by cross-origin data in chrome only -

-
uncaught securityerror: failed execute 'getimagedata' on 'canvasrenderingcontext2d': canvas has been tainted cross-origin data i getting above error in chrome. code(following) works fine in mozilla. have not corss domain issue. why above error in chrome? var wheel_canvas, wheel_context, can_w, can_h, wheel_grd; var large_radius = 160; var small_radius = 120; var wheel_canvas = document.getelementbyid('wheel_canvas'); var wheel_context = wheel_canvas.getcontext('2d'); var can_w = $(wheel_canvas).width(); var can_h = $(wheel_canvas).height(); var centerx = can_w / 2, centery = can_h / 2; var wheel_grd = null; test('#ff0000'); function test(hex) { $('#clrpicker').css({'left': 210, 'top': 210 }); inverted = hexbw(hex); $('#color_val_show').val(hex); current_color_hex_val_selected = hex; $('#color_val_show').css({'color':inverted,'background':hex}); fillgradient...
Read more