wpManoj Posted February 26, 2013 Share Posted February 26, 2013 i have a big problem this script seems working properly but data base looks so badly. just like his-------------------------|word |initial |logic|-------------------------|ansion | 1 | a ||ncel | 1 | a ||tree | 1 | a || bandege | 1 | a |-------------------------but i want words mansion, cancel, bigtree, bandage. every time no problem how many rows here last row working exactly what i want. please help me. am using wamp php 5.4 mysql 5.5 and apache 2.22.22.//php script<?php$words= array('mansion','cancel','bigtree','bandege');foreach( $words as $key => $word ){$initial = "1";$logic = "a";$obj = new en_word( array("word"=> isset( $word ) ? (string) $word :"","initial"=> isset( $initial ) ? (string) $initial :"","logic"=> isset( $logic ) ? (string) $logic :"") );$obj->insert();}?>//en_word class<?phpclass en_word extends DataObject {protected $data = array("word" => "","initial" => "","logic" => "");public function insert() {$conn = parent::connect();$sql = "INSERT INTO " . TBL_EN_WORD . " (word,initial,logic) VALUES (:word,:initial,:logic)";try {$st = $conn-> prepare( $sql );$st-> bindValue( ":word", $this->data["word"], PDO::PARAM_STR );$st-> bindValue( ":initial", $this->data["initial"], PDO::PARAM_STR );$st-> bindValue( ":logic", $this->data["logic"], PDO::PARAM_STR );$st-> execute();parent::disconnect( $conn );} catch ( PDOException $e ) {parent::disconnect( $conn );die( "Query failed: " . $e-> getMessage() );}}}?>//dataobject class<?phpabstract class DataObject {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 = "";}} ?>//mysql en_word table structureword VARCHAR(50) NOT NULL UNIQUE,initial VARCHAR(25) NOT NULL,logic TEXT NOT NULL Quote Link to comment https://forums.phpfreaks.com/topic/274961-php-mysql-insert-multiple-row-data-problem/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.