i have code written php (pdo) -> sql server. throws no error, won't return db. have tried running sql outputs in sql server management studio , works perfect. also, outputting parameters bind make sure looks , does. reason on execution binds preventing sql running properly. there wrong method? possible bind in array loops trying here? code below, in advance.
public function insertstaff( $table, $param ) { $qstr = ''; foreach( $_post $k => $v ) { if( $k == 'dummy' || $v == '' ) { $qstr .= ''; } else { $qstr .= '?,'; } } $qstr = rtrim( $qstr, ',' ); $sql = "insert ? ($qstr) values ($qstr)"; $stmt = $this->c->prepare( $sql ); //bind table $stmt->bindvalue( 1, $table, pdo::param_str ); $output = ''; $x = 2; foreach( $_post $k => $v ) { if( $k !== 'dummy' && $v !== '' ) { $stmt->bindvalue( $x, $k, pdo::param_str ); $output .= '<hr>'.$x.' => '.$k; $x++; } } foreach( $_post $k => $v ) { if( $k !== 'dummy' && $v !== '' ) { $stmt->bindvalue( $x, $v, pdo::param_str ); $output .= '<hr>'.$x.' => '.$v; $x++; } } //return $output; if( $stmt->execute() ) { return 'success'; } else { return 'fail'; } }
Comments
Post a Comment