I have this form code which returns the editable data:
Code: Select all
$rows = pg_num_rows($result);
for ($k = 0; $k < $rows; $k++)
{
for ($j = 0; $j < $i; $j++) {
$fieldname = pg_field_name($res, $j);
$retu = pg_fetch_result($result,$k,$j) ;
if ($fieldname == "gid")
echo '<td class="hr">'. htmlspecialchars($retu) ;
else
echo '<td class="hr"><input name="'.$fieldname.$k. '" type="text" value="'. $retu .'">';
Code: Select all
$norows = pg_num_rows($res);
$i = pg_num_fields($res);
if(isset($_POST['update']))
{
$r = 0;
while ($r < $norows)
{
$sql1 = 'UPDATE'." $editable SET ";
for ($j = 0; $j < $i; $j++)
{ $type .= pg_field_type($res, $j);
$fieldname = pg_field_name($res, $j);
if ($j==$i-1 )
{
$sql1 .= " $fieldname = ".@$_POST.'[ \''. $fieldname.$r.'\' ] ';
}
else
{
$sql1 .= " $fieldname = ".@$_POST.'[ \''. $fieldname.$r.'\' ] '.', ' ;
}
}
$s = ($r+1) ;
$sql1 .= "WHERE gid=$s".'; ';
//$result1= pg_query($conn,$sql1);
echo "$sql1";
++$r;
}
}
elseUPDATE material_parameters SET gid = Array[ 'gid0' ] , name = Array[ 'name0' ] , manning = Array[ 'manning0' ] , eqrough = Array[ 'eqrough0' ] , hazenwilliam = Array[ 'hazenwilliam0' ] , darcyweisbach = Array[ 'darcyweisbach0' ] WHERE gid=1; etc etc