RE: pg_insert tyro question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



To further append the previous note,

if you want to insert the array, you need to serialize it (www.php.net/serialize) to make the array db safe

if you want to insert the individual specific values, you will need to implode the array with separators (and check the data in the correct order for the field list) or you will need to supply a field list that matches the array list to ensure the data elements are placed into the correct columns

Bastien


From: Jon Crump <jjcrump@xxxxxxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject:  pg_insert tyro question
Date: Mon, 22 Aug 2005 14:34:03 -0700 (PDT)

Being a tyro, I'm sure I'm missing something obvious about handling the array $_POST. I hope wiser heads can point me in the right direction.

This fails:

<?php
$db = pg_connect( "dbname=foo user=bar" );

if( $db )
{
  print "Successfully connected to port: " . pg_port($db) ."<br/>\n";
} else {
  print pg_last_error ($db);
  exit;
}

$res = pg_insert($db, 'vracore', $_POST);
if ($res) {
	echo "You're a Genius";
} else {
  print_r ($_POST);
  exit;
}

pg_Close( $db );
?>

The connection string works fine. If I insert each field in $_POST separately, that works fine too eg.

$value1=$_POST['value1'];
$value1=$_POST['value2'];
etc...

$query = "insert into foo (columnname1, columnname2, etc...) values ($value1, $value2, etc...);";

$result = pg_exec($db, $query);

But if I try pg_insert($db, 'foo', $_POST);

it fails. I note that print_r ($_POST) returns a list of values that includes [addentry] => Add Entry from the submit button. Is that what's screwing it up?

Any clues would be much appreciated.

Jon

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux