php - SQL Server Prepared Statement saying invalid column count -


so i'm working on project here , i"m trying prepared statement can handle odd objects slashes , not raw data comes through. however, when go execute statement provides same error on , on again:

sqlstate: 07002 code: 0 message: [microsoft][sql server native client 11.0]count field incorrect or syntax error

it says field count incorrect, checked variables , made sure supposed there, is. i'm little confused guess. note first time working sqlsrv prepared statements, awesome!

here code below:

<?php     $servername = "localhost";      $connectioninfo = array( "database"=>"devel", "uid"=>"root", "pwd"=>"");     $conn = sqlsrv_connect( $servername, $connectioninfo);     $error_message = "";     $xml = trim(file_get_contents('/file.xml'));     $xml = new simplexmlelement($xml);     $truck_number;     $date_time;     $speed;     $heading;     $gps_quality;     $latitude;     $longitude;     $location;     $fix_type;     $ignition;     $gps_odometer;     $gps_rolling_odometer;     $performx_odometer;     $performx_fuel;     $performx_speed;     $performx_idle;     $packet_id;       sqlsrv_begin_transaction($conn);     $error_count = 0;     $q = "insert eagle_devel.dbo.people_net (truck_number, date_time, speed, heading, gps_quality, latitude, longitude, location, fix_type, ignition, gps_odometer, gps_rolling_odometer,                  performx_odometer, performx_fuel, performx_speed, performx_idle, packet_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";            $stmt = sqlsrv_prepare($conn, $q, array(&$truck_number, &$date_time, &$speed, &$heading, &$gps_quality, &$latitude, &$longitude, &$location, &$fix_type, &$ignition, &$gps_odometer, &$gps_rolling_odometer, &$performx_odometer, &$performx_fuel, &$performx_speed, &$performx_idle, &$packet_id));     foreach($xml->loc_history $loc_history){             $truck_number = $loc_history->truck_number;             $date_time = $loc_history->datetime;             $speed = $loc_history->speed;             $heading = $loc_history->heading;             $gps_quality = $loc_history->gps_quality;             $latitude = $loc_history->latitude;             $longitude = $loc_history->longitude;             $location = $loc_history->location;             $fix_type = $loc_history->fix_type;             $ignition = $loc_history->ignition;             $gps_odometer = $loc_history->gps_odometer;             $gps_rolling_odometer = $loc_history->gps_rolling_odometer;             $performx_odometer = $loc_history->performx_odometer;             $performx_fuel = $loc_history->performx_fuel;             $performx_speed = $loc_history->performx_speed;             $performx_idle = $loc_history->performx_idle;             $packet_id = $xml->packet_id;                  if(sqlsrv_execute($stmt) === false){                 $error_count++;                 if(($errors = sqlsrv_errors()) != null){                     foreach($errors $error){                         $error_message .= "sqlstate: ".$error['sqlstate']."<br>";                         $error_message .= "code: ".$error['code']."<br>";                         $error_message .= "message: ".$error['message']."<br><br>";                     }                 }             }     }     if($error_count)         sqlsrv_rollback($conn);     else         sqlsrv_commit($conn);      print $error_message; ?>

update : told try , initialize variables before hand did , this.

sqlstate: imssp code: -16 message: invalid php type parameter 1 specified.

i have no idea means i'm researching.


Comments

Post a Comment

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

i working on custom magento extension. working around adminhtml part , i've created custom form there. here form code: <?php class vivasindustries_smsnotification_block_adminhtml_sms_sendmass_edit_form extends mage_adminhtml_block_widget_form { public function _preparelayout() { $extensionpath = mage::getmoduledir('js', 'vivasindustries_smsnotification'); $head = $this->getlayout()->getblock('head'); $head->addjs('jquery.js'); $head->addjs('vivas.js'); return parent::_preparelayout(); } protected function _prepareform() { $form = new varien_data_form(array( 'id' => 'edit_form', 'action' => $this->geturl('*/*/save', array('id' => $this->getrequest()->get...
Read more

php - Bypass Geo Redirect for specific directories -

i'm trying bypass redirect specific url within site. wondering if might able help. the code below code use, original urls replaces example.com i'd able access http://example.com/admin without redirect occuring. is there way this, , there way using own ip? function country_geo_redirect() { $country = getenv('http_geoip_country_code'); if ($country == "us" ) { wp_redirect("http://usa.example.com/"); exit; } else if ($country == "gb" ) { wp_redirect("http://uk.example.com/"); exit; } } add_action('init', 'country_geo_redirect'); you can bypass redirection code if server found ip address. if ip address == <my ip address> ' nothing here else country_georedirect() end if
Read more

php - .htaccess mod_rewrite for dynamic url which has domain names -

i want convert url ex:( example.com/link.php?url=facebook.com ) ( example.com/facebook.com.php ) how can using .htaccess. or there other process make job easier ? i tried adding script .htaccess file options +followsymlinks rewriteengine on rewriterule url-(.*)\.htm$ link.php?url=$1 but converting url adding "url-" ( example.com/url-facebook.com.php ) i want remove "url-" , want make ( example.com/facebook.com.php ) rewriteengine on rewritecond %{the_request} ^get.*link\.php\?url\= [nc] rewritecond %{request_uri} !/system/.* [nc] rewriterule (.*?)link\.php\?url\=/*(.*) /$1$2 [r=301,ne,l] not sure how above work edit of used use remove index.php url
Read more