[SOLVED] Edit entry and overwrite existing string

[FridayRain]

I've accomplished half of what I want to do. I have an 'edit' link on blog entries and writing pieces for my upcoming site, and clicking it brings up the piece within a form so I can make changes. Now the only trouble is processing the form and having PHP and MySQL make the changes. I'm having trouble figuring out exactly how to replace or overwrite an entire string.

 

I came across the Locate command, but I was under the impression it was useful to search for text to replace, not necessarily (or efficient) for replacing an entire string. Also, does the fopen command work with MySQL queries?

[effigy]

Why not replace the whole record/field?

[Fadion]

As previously suggested u can replace the whole text with the UPDATE command:

 

if(isset($_POST['editfield'])){
     $id = $_SESSION['id']; //just assuming
     $edit = $_POST['editfield'];
     $results = mysql_query("UPDATE table SET article='$edit' WHERE id='$id'") or die(mysql_error());
}

[FridayRain]

Ah, the update command. Thanks.

[FridayRain]

What's the syntax for multiple strings possibly being replaced? I also have a title field available for edit. This is about as close as I've come:

 

<?php

$query = mysql_query("UPDATE $table SET title='$title' text='$edittext' WHERE id='$id'") or die(mysql_error());

?>

[lemmin]

Here is the documenation for UPDATE: http://dev.mysql.com/doc/refman/5.1/en/update.html

[roopurt18]

From the MySQL documentation:

http://dev.mysql.com/doc/refman/5.0/en/update.html

UPDATE [LOW_PRIORITY] [iGNORE] tbl_name
    SET col_name1=expr1 [, col_name2=expr2 ...]
    [WHERE where_condition]
    [ORDER BY ...]
    [LIMIT row_count]

 

(Note the comma!)

[FridayRain]

Sweet. I seem to have gotten it to work, but how do I update the entry without changing the timestamp?

[FridayRain]

Nevermind. I just pulled the original timestamp and put it into a variable.

[FridayRain]

Although, is there a more automatic way to prevent it from auto-updating?

[effigy]

Yes.

 

1. Don't use TIMESTAMP, use DATETIME.

2. Read more about TIMESTAMP.

[FridayRain]

Yes.

 

1. Don't use TIMESTAMP, use DATETIME.

 

Why's that? Other than being the same format and such. When I insert a new entry, how do I get it to automatically populate the DATETIME column?

[roopurt18]

Insert the new entry and set that column to the value of NOW().

[FridayRain]

I can't get the NOW() function to work. Each time I try, the entry gets all 0s for the datetime.

 

I Googled and apparently it's not a function of PHP, but only of MySQL. so I tried this:

 

    $query = mysql_query("INSERT INTO $table(id, title, text, date, year) VALUES ('$id', '$title', '$text', 'NOW()', '$year')") or die (mysql_error());

 

And still all 0s.

[roopurt18]

Remove the single quotes from around NOW().

[FridayRain]

Ah. Thanks!

[FridayRain]

Er, one more thing. Using the DATETIME function, I'm converting the time information into a readable format to show each blog entry's time of posting. But the format is 00:00, so if the hour is one digit, the 0 appears in front of it. How can I remove the 0 from the resulting string?

[effigy]

DATE_FORMAT: %k or %l.

[FridayRain]

Ah. I had 'h' in there before. Thanks!

[FridayRain]

Actually, it didn't work. It's displaying some different time. Here's the code I'm using:

 

echo date('h:ia', strtotime($r[date]));

 

(07:56pm)

 

Where DATE is a datetime type.

[FridayRain]

'Eh? Should I make a new topic?