[SOLVED]How to update 2 tables at once
Posted: Thu Jul 01, 2004 11:47 pm
OK I have 2 table one is meminfo the other memdata when I update id#3 on meminfo I want to update memdata on masterid #3 I have the script made but I don't believe I am using the where statement properly any help or hints would be appreciated. Here is the code
Code: Select all
<?php
<body background="../flash/images/backgrnd.gif">
<?
// Upload processor script
// At this point your script would determine what storage server to connect to
// I'm just going to hardcode it here
// mysql_select_db(storage1, admin, password);
$Storage_IP = "localhost";
$Storage_Port = 3306;
$Storage_User = "Admin";
$Storage_Passwd = "password";
$Storage_DB = "covfiles";
$picid = $_GET['recordID'];
//$memalias = $_POST['alias'];
//$memname = $_POST['name'];
//$memprof = $_POST['profile'];
//$memage = $_POST['age'];
//$memweapon = $_POST['weapon'];
//$memquote = $_POST['quote'];
//$connectto = $Storage_IP . ":" . $Storage_Port;
if (!$linkid = @mysql_connect($connectto, $Storage_User, $Storage_Passwd)) {
die("Unable to connect to storage server!");
}
if (!mysql_select_db($Storage_DB, $linkid)) {
die("Unable to connect to storage database!");
}
// Init values - these are used incase you want to upload multiple files, you just
// add them to the source form as file1, file2, file3, etc.
$STARTFILE = 1;
$ONFILE = "file" . $STARTFILE;
while (isset($HTTP_POST_FILES["$ONFILE"])) {
// Try!
$SrcPathFile = $HTTP_POST_FILES["$ONFILE"]["tmp_name"];
$SrcFileType = $HTTP_POST_FILES["$ONFILE"]["type"];
$DstFileName = $HTTP_POST_FILES["$ONFILE"]["name"];
clearstatcache();
$time = filemtime($SrcPathFile);
$storedate = date("Y-m-d H:i:s", $time);
// File Processing
if (file_exists($SrcPathFile)) {
// Insert into file table
$SQL = "update into meminfo (datatype, name, size, filedate) values ('";
$SQL .= $SrcFileType . "', '" . $DstFileName . "', " . filesize($SrcPathFile);
$SQL .= ", '" . $storedate . "' where id = $picid)";
if (!$RES = mysql_query($SQL, $linkid)) {
die("Failure on insert to Member table!");
}
$fileid = mysql_insert_id($linkid);
// Insert into the filedata table
$fp = fopen($SrcPathFile, "rb");
while (!feof($fp)) {
// Make the data mysql insert safe
$binarydata = addslashes(fread($fp, 65535));
$SQL = "update into memdata (masterid, filedata) values (";
$SQL .= $fileid . ", '" . $binarydata . "' where masterid = $picid)";
if (!mysql_query($SQL, $linkid)) {
die("Failure to update picture!");
}
}
fclose($fp);
}
$STARTFILE ++;
$ONFILE = "file" . $STARTFILE;
}
//echo "Upload Complete";
?>
<div align="center"><font color="#CC6600" size="7">Update Complete</font></div>
?>