Jump to content

xml edit not editing xml

Zeradin

By Zeradin
in PHP Coding Help

 Share

Recommended Posts

Zeradin Regular Member

Zeradin

Posted
Posted

I get the form populated and everything, but when I hit submit when it is at upalbum.php?action=edit&id=71 I get the "you edited!" line but the file it says i edited is null like "reviews/xml/.xml"

Thanks in advance

// open connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");

// create query
$mquery = 'SELECT * FROM users';
    // execute query
    $mresult = mysql_query($mquery) or die ("Error in query: $mquery. ".mysql_error());

// close connection
    mysql_close($connection);
$eid = $_GET['id'];
$action = $_GET['action'];

//if it is an upload not an edit
if ($eid == NULL && $action != "edit" && $_POST['albumedit'] == NULL) {
if(!isset($_POST['albumsubmit'])) { ?>
<!-- Upload Form -->
		  <span class="newstitle"><u>Album Upload</u></class><br /><br />
		    <form method="POST" action="<?php $_SERVER['PHP_SELF']?>">
				<strong>Poster</strong><br />
				<select  size="1"  name="poster">
				<?php 
				while(list($id, $username)  = mysql_fetch_row($mresult)) {
				echo '<option value="'.$id.'">'.$username.'</option>';
				} ?>
				</select><br /><br />
				<strong>Title</strong><br />
				<input type="text" name="title" size="20"><br />
				<strong>Subtitle</strong><br />
				<input type="text" name="subtitle" size="20"><br />
				<br />
				<strong>Image Location</strong><br />
				<input type="text" name="image" size="20"><br />
				<strong>Release Date</strong><br />
				<input type="text" name="rdate" size="20"><br />
				<br />
				<strong>Record Label</strong><br />
				<input type="text" name="rcomp" size="20"><br />
				<br />
				<strong>Link1 address</strong><br />
				<input type="text" name="add1" size="20"><br />
				<strong>Link1 text</strong><br />
				<input type="text" name="text1" size="20"><br />
				<br /><br />
				<strong>Review</strong><br />
				<textarea rows="20" name="review" cols="80"></textarea>
				<br />
				<br />
				<input type="submit" value="Submit" name="albumsubmit" class="btn"  onmouseover="this.className='btn btnhov'" onmouseout="this.className='btn'"/>
			</form><br />
<!-- End Upload Form -->
<?php
}
if(isset($_POST['albumsubmit']) && $action != "edit") {

$title = $_POST['title'];
$stitle = $_POST['subtitle'];
$rdate = $_POST['rdate'];
$rcomp = $_POST['rcomp'];
$image = $_POST['image'];
$add1 = $_POST['add1'];
$text1 = $_POST['text1'];
$info = $_POST['review'];
$poster = $_POST['poster'];

//get poster names and ids
// set database server access variables:
$host = "localhost";
$user = "hypboard_hyp";
$pass = "d31373";
$db = "hypboard_hypnet";

// open connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");

// create query
$mquery = 'SELECT * FROM users WHERE id = "'.$poster.'"';
    // execute query
    $mresult = mysql_query($mquery) or die ("Error in query: $mquery. ".mysql_error());
$row = mysql_fetch_assoc($mresult);
$postername= $row['username'];

// create query
$query = "INSERT INTO reviews (title, reviewer, type) VALUES ('$title', '$postername', 'album')";
    // execute query
    $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
    

$file = "../reviews/xml/".mysql_insert_id().".xml";
// open file
$fh = fopen($file, 'w') or die('Could not open file!');


$output = '<?xml version="1.0"?>';
$output.= "<album>\n";
$output.= "<title>".$title."</title>\n";
$output.= "<subtitle>".$stitle."</subtitle>\n";
$output.= "<image>".$image."</image>\n";
$output.= "<rdate>".$rdate."</rdate>\n";
$output.= "<rcomp>".$rcomp."</rcomp>\n";
$output.= "<links>\n";
$output.= "<add1>".$add1."</add1>\n";
$output.= "<text1>".$text1."</text1>\n";
$output.= "</links>\n";
$output.= "<info>".$info."</info>\n";
$output.="</album>\n";

fwrite($fh, $output);

// close file
fclose($fh);

echo "you uploaded an album!! (id=".$file." now what? I haven't really added anything else to this yet";

    
    // close connection
    mysql_close($connection);
}
}

//------------------------------------------------------------------------------------EDIT------------------------------------------------------------------------------------//
//edit mode!
else {
if(!isset($_POST['albumedit'])) {
$file = "../reviews/xml/".$eid.".xml";

$xml = simplexml_load_file($file) or die ("Unable to load XML file!");

//<!-- Upload Form -->
		  echo '<span class="newstitle"><u>Game Review Upload</u></class><br /><br />
		    <form method="POST" action="'.$_SERVER['PHP_SELF'].'">
				<strong>Title</strong><br />
				<input type="text" name="title" size="20" value="'.$xml->title.'"><br />
				<strong>Subtitle</strong><br />
				<input type="text" name="subtitle" size="20" value="'.$xml->subtitle.'"><br />
				<br />
				<strong>Image Location</strong><br />
				<input type="text" name="image" size="20" value="'.$xml->image.'"><br />
				<strong>Release Date</strong><br />
				<input type="text" name="rdate" size="20" value="'.$xml->rdate.'"><br />
				<br />
				<strong>Record Company</strong><br />
				<input type="text" name="rdate" size="20" value="'.$xml->rcomp.'"><br />
				<br />
				<strong>Link1 address</strong><br />
				<input type="text" name="add1" size="20" value="'.$xml->links->add1.'"><br />
				<strong>Link1 text</strong><br />
				<input type="text" name="text1" size="20" value="'.$xml->links->text1.'"><br />
				<br /><br />
				<strong>Review</strong><br />
				<textarea rows="30" name="info" cols="100">';
				echo $xml->info;
				echo '</textarea>
				<br />
				<br />
				<input type="submit" value="Submit" name="albumedit" class="btn"  onmouseover="this.className=\'btn btnhov\'" onmouseout="this.className=\'btn\'"/>
			</form><br />';
// <!-- End Upload Form -->

}
else {
$title = $_POST['title'];
$stitle = $_POST['subtitle'];
$image = $_POST['image'];
$rdate = $_POST['rdate'];
$rcomp = $_POST['rcomp'];
$add1 = $_POST['add1'];
$text1 = $_POST['text1'];
$info = $_POST['info'];
$poster = $_POST['poster'];


$file2 = "../reviews/xml/".$eid.".xml";
echo $eid;
echo $file2;
// open file
$fh2 = fopen($file2, "w+") or die('Could not open file!');

$output = '<?xml version="1.0"?>';
$output.= "<album>\n";
$output.= "<title>".$title."</title>\n";
$output.= "<subtitle>".$stitle."</subtitle>\n";
$output.= "<image>".$image."</image>\n";
$output.= "<rdate>".$rdate."</rdate>\n";
$output.= "<rcomp>".$rcomp."</rcomp>\n";
$output.= "<links>\n";
$output.= "<add1>".$add1."</add1>\n";
$output.= "<text1>".$text1."</text1>\n";
$output.= "</links>\n";
$output.= "<info>".$info."</info>\n";
$output.="</album>\n";

fwrite($fh2, $output2);

// close file
fclose($fh2);

echo $eid;
echo "you edited an album review!! (id=".$file2." now what? I haven't really added anything else to this yet";

}
}	
?>

Link to comment
Share on other sites
Zeradin Regular Member

Zeradin

Posted
  • Author
Posted

ok i decided to not edit the xml file, let it create the new one, and just delete out the SQL entry for it.

but... it's not deleting the old entry and it's not grabbing the username from the old entry.

So I've determined that it doesn't get the $eid, but it should? what the hell

 

<?php



// open connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");

// create query
$mquery = 'SELECT * FROM users';
    // execute query
    $mresult = mysql_query($mquery) or die ("Error in query: $mquery. ".mysql_error());

// close connection
    mysql_close($connection);
$eid = $_GET['id'];
$action = $_GET['action'];

//if it is an upload not an edit
if ($eid == NULL && $action != "edit" && !isset($_POST['albumedit'])) {
if(!isset($_POST['albumsubmit'])) { ?>
<!-- Upload Form -->
		  <span class="newstitle"><u>Album Upload</u></class><br /><br />
		    <form method="POST" action="<?php $_SERVER['PHP_SELF']?>">
				<strong>Poster</strong><br />
				<select  size="1"  name="poster">
				<?php 
				while(list($id, $username)  = mysql_fetch_row($mresult)) {
				echo '<option value="'.$id.'">'.$username.'</option>';
				} ?>
				</select><br /><br />
				<strong>Title</strong><br />
				<input type="text" name="title" size="20"><br />
				<strong>Subtitle</strong><br />
				<input type="text" name="subtitle" size="20"><br />
				<br />
				<strong>Image Location</strong><br />
				<input type="text" name="image" size="20"><br />
				<strong>Release Date</strong><br />
				<input type="text" name="rdate" size="20"><br />
				<br />
				<strong>Record Label</strong><br />
				<input type="text" name="rcomp" size="20"><br />
				<br />
				<strong>Link1 address</strong><br />
				<input type="text" name="add1" size="20"><br />
				<strong>Link1 text</strong><br />
				<input type="text" name="text1" size="20"><br />
				<br /><br />
				<strong>Review</strong><br />
				<textarea rows="20" name="review" cols="80"></textarea>
				<br />
				<br />
				<input type="submit" value="Submit" name="albumsubmit" class="btn"  onmouseover="this.className='btn btnhov'" onmouseout="this.className='btn'"/>
			</form><br />
<!-- End Upload Form -->
<?php
}
if(isset($_POST['albumsubmit'])) {

$title = $_POST['title'];
$stitle = $_POST['subtitle'];
$rdate = $_POST['rdate'];
$rcomp = $_POST['rcomp'];
$image = $_POST['image'];
$add1 = $_POST['add1'];
$text1 = $_POST['text1'];
$info = $_POST['review'];
$poster = $_POST['poster'];


// open connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");

// create query
$mquery = 'SELECT * FROM users WHERE id = "'.$poster.'"';
    // execute query
    $mresult = mysql_query($mquery) or die ("Error in query: $mquery. ".mysql_error());
$row = mysql_fetch_assoc($mresult);
$postername= $row['username'];

// create query
$query = "INSERT INTO reviews (title, reviewer, type) VALUES ('$title', '$postername', 'album')";
    // execute query
    $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
    

$file = "../reviews/xml/".mysql_insert_id().".xml";
// open file
$fh = fopen($file, 'w') or die('Could not open file!');


$output = '<?xml version="1.0"?>';
$output.= "<album>\n";
$output.= "<title>".$title."</title>\n";
$output.= "<subtitle>".$stitle."</subtitle>\n";
$output.= "<image>".$image."</image>\n";
$output.= "<rdate>".$rdate."</rdate>\n";
$output.= "<rcomp>".$rcomp."</rcomp>\n";
$output.= "<links>\n";
$output.= "<add1>".$add1."</add1>\n";
$output.= "<text1>".$text1."</text1>\n";
$output.= "</links>\n";
$output.= "<info>".$info."</info>\n";
$output.="</album>\n";

fwrite($fh, $output);

// close file
fclose($fh);

echo "you uploaded an album!! (id=".$file." now what? I haven't really added anything else to this yet";

    
    // close connection
    mysql_close($connection);
}
}

//------------------------------------------------------------------------------------EDIT------------------------------------------------------------------------------------//
//edit mode!
else {
if(!isset($_POST['albumedit'])) {
$file = "../reviews/xml/".$eid.".xml";

$xml = simplexml_load_file($file) or die ("Unable to load XML file!");

//<!-- Upload Form -->
		  echo '<span class="newstitle"><u>Game Review Upload</u></class><br /><br />
		    <form method="POST" action="'.$_SERVER['PHP_SELF'].'">
				<strong>Title</strong><br />
				<input type="text" name="title" size="20" value="'.$xml->title.'"><br />
				<strong>Subtitle</strong><br />
				<input type="text" name="subtitle" size="20" value="'.$xml->subtitle.'"><br />
				<br />
				<strong>Image Location</strong><br />
				<input type="text" name="image" size="20" value="'.$xml->image.'"><br />
				<strong>Release Date</strong><br />
				<input type="text" name="rdate" size="20" value="'.$xml->rdate.'"><br />
				<br />
				<strong>Record Company</strong><br />
				<input type="text" name="rcomp" size="20" value="'.$xml->rcomp.'"><br />
				<br />
				<strong>Link1 address</strong><br />
				<input type="text" name="add1" size="20" value="'.$xml->links->add1.'"><br />
				<strong>Link1 text</strong><br />
				<input type="text" name="text1" size="20" value="'.$xml->links->text1.'"><br />
				<br /><br />
				<strong>Review</strong><br />
				<textarea rows="20" name="review" cols="80">';
				echo $xml->info;
				?></textarea><br /><br />
				<input type="submit" value="Submit" name="albumedit" class="btn"  onmouseover="this.className='btn btnhov'" onmouseout="this.className='btn'"/>
			</form><br />
<?php				
// <!-- End Upload Form -->

}
else {
$title = $_POST['title'];
$stitle = $_POST['subtitle'];
$image = $_POST['image'];
$rdate = $_POST['rdate'];
$rcomp = $_POST['rcomp'];
$add1 = $_POST['add1'];
$text1 = $_POST['text1'];
$info = $_POST['info'];


// open connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");

$uquery = 'SELECT * FROM reviews WHERE id = "'.$eid.'"';
$uresult = mysql_query($uquery) or die ("Error in query: $dquery. ".mysql_error());
$urow = mysql_fetch_assoc($uresult);
$postername = $urow['reviewer'];

// create delete query
$dquery = 'DELETE FROM reviews WHERE id = "'.$eid.'"';
// execute delete query
$dresult = mysql_query($dquery) or die ("Error in query: $dquery. ".mysql_error());

// create query
$query = "INSERT INTO reviews (title, reviewer, type) VALUES ('$title', '$postername', 'album')";
    // execute query
    $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

$file = "../reviews/xml/".mysql_insert_id().".xml";
// open file
$fh = fopen($file, "w") or die('Could not open file!');

$output = '<?xml version="1.0"?>';
$output.= "<album>\n";
$output.= "<title>".$title."</title>\n";
$output.= "<subtitle>".$stitle."</subtitle>\n";
$output.= "<image>".$image."</image>\n";
$output.= "<rdate>".$rdate."</rdate>\n";
$output.= "<rcomp>".$rcomp."</rcomp>\n";
$output.= "<links>\n";
$output.= "<add1>".$add1."</add1>\n";
$output.= "<text1>".$text1."</text1>\n";
$output.= "</links>\n";
$output.= "<info>".$info."</info>\n";
$output.="</album>\n";

fwrite($fh, $output);

// close file
fclose($fh);

echo $eid;
echo "you edited an album review!! (id=".$file." now what? I haven't really added anything else to this yet";

}
}	
?>

 

i know there's some extra code in there. I just want to get this working and then i'm gonna go back and clean everything up. Thanks.

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.