insert + delete different records one process?

Hello friends, its been a while.
Hopefully somebody will be nice to me here, ive asked this question in two others forums, one with no responce and the other responce was almost insulting.

Im using php and dreamweaver, what i would like to do is make a psuedo update page.

I copy everything from one record expect one feild to another record, so the user see's this as a sort of edit page, its easy to do, just make a update record with the wizard, take out the update code and put a insert record behavior in. What i would like to do is when the user inserts the new copyed record, have the original one delete, if possible in one process.

Is this possible? any tips would be greatfully recieved
x

[Free WordPress Themes]

just use "replace" and not "update" to do that job, anyway that will be your first hand coding job in DW (btw. great code editor)

Yes, but..

I cant get the replace to work on the file upload, and to make it worse it's an dw extension and the case is rather, the update behavior does not work, and there is absolutely no support on the developers forum.

I have done quite a bit of hand coding, i started just makin sites in notebook yeeeears ago and then concentrated on photoshop, but more recently ive made my own cms system with some cool database joins, so im not a total noob , but yes, i did pay for a extension to upload the files for me.

[Free WordPress Themes]

haha you're only a few steps away to stop working with DW extensions

try

Code:

if (!empty($_POST['your_rec_id'])) {
  // validat first that all fields are filled
  mysql_query("DFELETE FROM tabel WHERE id =".(int)$_POST['your_rec_id']);
  // place here the insert statement, maybe you should reuse the old rec id
}

btw. I don't understand why you can't update a record together with a file upload?

check my upload class:
http://www.finalwebsites.com/snippets.php?id=7

there is also an example on how to upload and insert a db record

Thanx man, thats one tasty script, i wish i knew about that 

I think im getting an error due to this line

Code:

$query_rs_copy = sprintf("SELECT * FROM rooms WHERE idroom = %s", GetSQLValueString($colname_rs_copy, "int"));

[Free WordPress Themes]

Thanx man, thats one tasty script, i wish i knew about that 

I think im getting an error due to this line

Code:

$query_rs_copy = sprintf("SELECT * FROM rooms WHERE idroom = %s", GetSQLValueString($colname_rs_copy, "int"));

what is the error?

Call to undefined function: getsqlvaluestring() in line 118
($query_rs_copy = sprintf("SELECT * FROM rooms WHERE idroom = %s", GetSQLValueString($colname_rs_copy, "int"))

bah

Code:

<?php require_once('../Connections/conn_wedgewood.php'); ?>
<?php require_once('../ScriptLibrary/incPureUpload.php'); ?>
<?php

error_reporting(E_ERROR | E_WARNING | E_PARSE);

// PHP exntension start
if (isset($HTTP_GET_VARS['GP_upload'])) {
$ppu = new pureFileUpload();
$ppu->path = "../images/user_upload";
$ppu->extensions = "GIF,JPG,JPEG,BMP,PNG";
$ppu->formName = "form1";
$ppu->storeType = "file";
$ppu->sizeLimit = "250";
$ppu->nameConflict = "over";
$ppu->requireUpload = "true";
$ppu->minWidth = "";
$ppu->minHeight = "";
$ppu->maxWidth = "";
$ppu->maxHeight = "";
$ppu->saveWidth = "";
$ppu->saveHeight = "";
$ppu->timeout = "600";
$ppu->progressBar = "";
$ppu->progressWidth = "";
$ppu->progressHeight = "";
$ppu->checkVersion("2.1.3");
$ppu->doUpload();
}
$GP_uploadAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  if (!eregi("GP_upload=true", $HTTP_SERVER_VARS['QUERY_STRING'])) {
$GP_uploadAction .= "?".$HTTP_SERVER_VARS['QUERY_STRING']."&GP_upload=true";
} else {
$GP_uploadAction .= "?".$HTTP_SERVER_VARS['QUERY_STRING'];
}
} else {
  $GP_uploadAction .= "?"."GP_upload=true";
}
//PHP extension end

//Sugestion
if (!empty($_POST['idroom'])) {

  mysql_query("DELETE FROM rooms WHERE id =".(int)$_POST['idroom']);
  
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if (isset($editFormAction)) {
  if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  if (!eregi("GP_upload=true", $HTTP_SERVER_VARS['QUERY_STRING'])) {
     $editFormAction .= "&GP_upload=true";
}
  } else {
    $editFormAction .= "?GP_upload=true";
  }
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO rooms (roomName, roomDesc, roomPrice, roomImg) VALUES (%s, %s, %s, %s)",
                       GetSQLValueString($_POST['roomName'], "text"),
                       GetSQLValueString($_POST['roomDesc'], "text"),
                       GetSQLValueString($_POST['roomPrice'], "int"),
                       GetSQLValueString($_POST['fileField'], "text"));

  mysql_select_db($database_conn_wedgewood, $conn_wedgewood);
  $Result1 = mysql_query($insertSQL, $conn_wedgewood) or die(mysql_error());
}
  $insertGoTo = "close.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));

if (!function_exists("GetSQLValueString"))

$colname_rs_copy = "-1";
if (isset($_GET['idroom'])) {
  $colname_rs_copy = $_GET['idroom'];
}
}
//Sugestion end

mysql_select_db($database_conn_wedgewood, $conn_wedgewood);
$query_rs_copy = sprintf("SELECT * FROM rooms WHERE idroom = %s", GetSQLValueString($colname_rs_copy, "int"));
$rs_copy = mysql_query($query_rs_copy, $conn_wedgewood) or die(mysql_error());
$row_rs_copy = mysql_fetch_assoc($rs_copy);
$totalRows_rs_copy = mysql_num_rows($rs_copy);
?>

[Free WordPress Themes]

this is strange...remove this if clause:

if (!function_exists("GetSQLValueString")) {

above the function plus the curly bracket after the function

No errors but the page skips to close.php, the page after the insertfeild form

Bump
Any further suggestions?
I had a parse error caused by a }, i took that out and now we just skip to the finished upload page

[Join us @ facebook]

Thought you solved this. What's the problem now?

When i go to this 'edit' page, the page just skips to the finish page that appiers at the end of the process, so i dont actually get to upload a new file.

Now i get this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1


there is no " on line 1, what gives?

[Join us @ facebook]

What is the query that you run?

OK forget the last problem, i've had a week playing Call to Duty 4 online so i came back and done this page from scratch.

Alas still no joy but i have this error on the last line of the script with olafs suggestion last time :
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /admin/newroomimg.php on line 165

That line being: <?php mysql_free_result($rs_copydel);?>

Sorry for draggin this up again, It seems a simple thing to do, but im obvislouy blindly fumbling around with code here.. 


Here the fresh code:

Code:

<?php require_once('../Connections/conn_wedgewood.php'); ?>
<?php require_once('../ScriptLibrary/incPureUpload.php'); ?>
<?php
error_reporting(E_ERROR | E_WARNING | E_PARSE);

//Suggestion start
if (!empty($_POST['idroom'])) {
  // validat first that all fields are filled
  mysql_query("DELETE FROM rooms WHERE idroom =".(int)$_POST['idroom']);
  // place here the insert statement, maybe you should reuse the old rec id

// Pure PHP Upload 2.1.3
if (isset($HTTP_GET_VARS['GP_upload'])) {
$ppu = new pureFileUpload();
$ppu->path = "../images/user_upload";
$ppu->extensions = "GIF,JPG,JPEG,BMP,PNG";
$ppu->formName = "form1";
$ppu->storeType = "file";
$ppu->sizeLimit = "250";
$ppu->nameConflict = "over";
$ppu->requireUpload = "true";
$ppu->minWidth = "";
$ppu->minHeight = "";
$ppu->maxWidth = "";
$ppu->maxHeight = "";
$ppu->saveWidth = "";
$ppu->saveHeight = "";
$ppu->timeout = "600";
$ppu->progressBar = "";
$ppu->progressWidth = "";
$ppu->progressHeight = "";
$ppu->checkVersion("2.1.3");
$ppu->doUpload();
}
$GP_uploadAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  if (!eregi("GP_upload=true", $HTTP_SERVER_VARS['QUERY_STRING'])) {
$GP_uploadAction .= "?".$HTTP_SERVER_VARS['QUERY_STRING']."&GP_upload=true";
} else {
$GP_uploadAction .= "?".$HTTP_SERVER_VARS['QUERY_STRING'];
}
} else {
  $GP_uploadAction .= "?"."GP_upload=true";
}
  
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
case "text":
  $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  break;    
case "long":
case "int":
  $theValue = ($theValue != "") ? intval($theValue) : "NULL";
  break;
case "double":
  $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
  break;
case "date":
  $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  break;
case "defined":
  $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
  break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if (isset($editFormAction)) {
  if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  if (!eregi("GP_upload=true", $HTTP_SERVER_VARS['QUERY_STRING'])) {
     $editFormAction .= "&GP_upload=true";
}
  } else {
    $editFormAction .= "?GP_upload=true";
  }
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO rooms (roomName, roomDesc, roomPrice, roomImg) VALUES (%s, %s, %s, %s)",
                       GetSQLValueString($_POST['roomName'], "text"),
                       GetSQLValueString($_POST['roomDesc'], "text"),
                       GetSQLValueString($_POST['roomPrice'], "int"),
                       GetSQLValueString($_POST['roomimg'], "text"));

  mysql_select_db($database_conn_wedgewood, $conn_wedgewood);
  $Result1 = mysql_query($insertSQL, $conn_wedgewood) or die(mysql_error());

  $insertGoTo = "close.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

if (!function_exists("GetSQLValueString")) 

$colname_rs_copydel = "-1";
if (isset($_GET['idroom'])) {
  $colname_rs_copydel = $_GET['idroom'];
}
mysql_select_db($database_conn_wedgewood, $conn_wedgewood);
$query_rs_copydel = sprintf("SELECT * FROM rooms WHERE idroom = %s", GetSQLValueString($colname_rs_copydel, "int"));
$rs_copydel = mysql_query($query_rs_copydel, $conn_wedgewood) or die(mysql_error());
$row_rs_copydel = mysql_fetch_assoc($rs_copydel);
$totalRows_rs_copydel = mysql_num_rows($rs_copydel);
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
<script language='JavaScript' src='../ScriptLibrary/incPureUpload.js' type="text/javascript"></script>
</head>

<body>
<form action="<?php echo $editFormAction; ?>" method="post" enctype="multipart/form-data" name="form1" id="form1" onsubmit="checkFileUpload(this,'GIF,JPG,JPEG,BMP,PNG',true,250,'','','','','','');return document.MM_returnValue">
  <table align="center">
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Idroom:</td>
      <td><?php echo $row_rs_copydel['idroom']; ?></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">RoomName:</td>
      <td><input type="text" name="roomName" value="<?php echo htmlentities($row_rs_copydel['roomName'], ENT_COMPAT, 'UTF-8'); ?>" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right" valign="top">RoomDesc:</td>
      <td><textarea name="roomDesc" cols="50" rows="5"><?php echo htmlentities($row_rs_copydel['roomDesc'], ENT_COMPAT, 'UTF-8'); ?></textarea>
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">RoomPrice:</td>
      <td><input type="text" name="roomPrice" value="<?php echo htmlentities($row_rs_copydel['roomPrice'], ENT_COMPAT, 'UTF-8'); ?>" size="5" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">RoomImg:</td>
      <td><label>
        <input name="roomimg" type="file" id="roomimg" onchange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG',true,250,'','','','','','')" value="<?php echo $row_rs_copydel['roomImg']; ?>" />
      </label></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">&nbsp;</td>
      <td><input type="submit" value="Update record" /></td>
    </tr>
  </table>
  <input type="hidden" name="MM_insert" value="form1" />
</form>
<p>&nbsp;</p>
</body>
</html>