problem with pear library

medicalboy · August 16, 2011

i read an article in ibm about parsing xml data as an html table and insert them into db;http://www.ibm.com/developerworks/opensour...excel/#ibm-pconbut i want to know if there is there is another method to assign an array to sql statement mysql_query to insert data into dbwithout using pear libraryjust i want a normal snippet instead of pear snippet to do the same jobcode:

<?phprequire_once( "db.php" );$data = array();$db =& DB::connect("mysql://root@localhost/names", array());if (PEAR::isError($db)) { die($db->getMessage()); }function add_person( $first, $middle, $last, $email ){ global $data, $db; $sth = $db->prepare( "INSERT INTO names VALUES( 0, ?, ?, ?, ? )" ); $db->execute( $sth, array( $first, $middle, $last, $email ) ); $data []= array(   'first' => $first,   'middle' => $middle,   'last' => $last,   'email' => $email );}if ( $_FILES['file']['tmp_name'] ){ $dom = DOMDocument::load( $_FILES['file']['tmp_name'] ); $rows = $dom->getElementsByTagName( 'Row' ); $first_row = true; foreach ($rows as $row) {   if ( !$first_row )   {	 $first = "";	 $middle = "";	 $last = "";	 $email = "";	 $index = 1;	 $cells = $row->getElementsByTagName( 'Cell' );	 foreach( $cells as $cell )	 {	   $ind = $cell->getAttribute( 'Index' );	   if ( $ind != null ) $index = $ind;	   if ( $index == 1 ) $first = $cell->nodeValue;	   if ( $index == 2 ) $middle = $cell->nodeValue;	   if ( $index == 3 ) $last = $cell->nodeValue;	   if ( $index == 4 ) $email = $cell->nodeValue;	   $index += 1;	 }	 add_person( $first, $middle, $last, $email );   }   $first_row = false; }}?><html><body>These records have been added to the database:<table><tr><th>First</th><th>Middle</th><th>Last</th><th>Email</th></tr><?php foreach( $data as $row ) { ?><tr><td><?php echo( $row['first'] ); ?></td><<td><?php echo( $row['middle'] ); ?></td><<td><?php echo( $row['last'] ); ?></td><<td><?php echo( $row['email'] ); ?></td><</tr><?php } ?></table>Click <a href="list.php">here</a> for the entire table.</body></html>

the snippet that i mean is:

 $sth = $db->prepare( "INSERT INTO names VALUES( 0, ?, ?, ?, ? )" ); $db->execute( $sth, array( $first, $middle, $last, $email ) );

thanks in advance

justsomeguy · August 16, 2011

There's not a native way to do that with a single function, but you can write your own function that uses vsprintf to build the query.http://www.php.net/manual/en/function.vsprintf.php

Sign In

problem with pear library

Recommended Posts

medicalboy

Link to comment

Share on other sites

justsomeguy

Link to comment

Share on other sites

Archived

Browse

Activity