Reply to thread

Message: <blockquote data-quote="wpmanoj" data-source="post: 14509429" data-attributes="member: 318958">am trying to insert multiple raw data using foreach and for loop. script work properly. am using pdo insert data to mysql.insert work properly but have a big problem. no error reporting. php 5.4 mysql 5.5var1 = 'man', var2 = '1', var3 = 'a'var1 = 'gt', var2 = '1', var3 = 'a'var1 = 'cook', var2 = '1', var3 = 'a'//mysql tablevar1 varchar(50) not null unique,var2 varchar(50) not null,var3 tinytext not null//am supposevar1 var2 var3man 1 agt 1 acook 1 a//but its works like this <space> mean just spacevar1 var2 var3<space> 1 a<space> 1 acook 1 alast one inserting properly. others not working. help me//script php$words = array('man','pan','can');foreach($words as $var1){var2 = 1;var3 = a;$obj = new myclass( array("var1"=> isset( $var1 ) ? (string) $var1 :"","var2"=> isset( $var2 ) ? (string) $var2 :"","var3"=> isset( $var3 ) ? (string) $var3 :"",) );$obj->insert();}//class myclassclass myclass extends DObject {protected $data = array("var1" => "","var2" => "","var3" => "");public function insert() {$conn = parent::connect();$sql = "INSERT INTO " . TBL_MYTBL . " (var1,var2,var3) VALUES (:var1,:var2,:var3)";try {$st = $conn-> prepare( $sql );$st-> bindValue( ":var1", $this-> data["var1"], PDO:: PARAM_STR );$st-> bindValue( ":var2", $this-> data["var2"], PDO:: PARAM_STR );$st-> bindValue( ":var3", $this-> data["var3"], PDO:: PARAM_STR );$st-> execute();parent::disconnect( $conn );} catch ( PDOException $e ) {parent::disconnect( $conn );die( "Query failed: " . $e-> getMessage() );}}}//dobject classabstract class DObject {protected $data = array();public function __construct( $data ) {foreach ( $data as $key => $value ) {if ( array_key_exists( $key, $this-> data ) ) $this-> data[$key] = $value;}}protected static function connect() {try {$conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );$conn-> setAttribute( PDO::ATTR_PERSISTENT, true );$conn-> setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );} catch ( PDOException $e ) {die( "Connection failed: " . $e-> getMessage() );}return $conn;}protected static function disconnect( $conn ) {$conn = "";}}</blockquote>

Verification: Awruddata maasa keeyada?

Top Bottom