Need help to create a news updater!

Beginners - Learning PHP
#1

Please anyone!

            I am a web development student. I need a help to make a news updater table using php. The updater should contain Edit, delete, comment options. and that can be updated automatically. i need the cording because i am totaly upset with the cording on how to create a news updater with the connection of the database. I am using wamp server. So anyone please help me to create it....!
#2

What do you have so far?

Have you pulled the data for display from the database yet?
Add edit / delete links using the ID of the entry…

Delete
Edit

From delete.php add a confirm page. If yes, execute delete. If no, send them back.
From edit.php create a form with all the information pre-entered into the fields. Then process the edit.

#3
<?php include('db.php'); ?> Untitled Document <?php //query the database $getnews= mysql_query("SELECT * FROM news")or die (mysql_error()) ; echo ""; while ($row=mysql_fetch_array($getnews)) { //get data echo ""; //echo ""; echo ""; echo""; } echo "
News updates
".$row['news_id']."".$row['news_desc']."
"; mysql_close($con); ?>
#4

[php]while ($row=mysql_fetch_array($getnews))
{

//get data

echo "<tr>";
echo '<td>'.$row['news_id'].' <a href="edit.php?id='.$row['news_id'].'">Edit</a> <a href="delete.php?id='.$row['news_id'].'">Delete</a></td>';
echo '<td>'.$row['news_desc'].'</td>';
echo"</tr>";

}[/php]

Then on the edit page, output a form with $row[‘news_desc’] in a text area by using $getnews= mysql_query("SELECT * FROM news WHERE news_id = ‘$_GET[‘id’]’ ")or die (mysql_error()) ;

Then when the form is submitted $getnews= mysql_query("UPDATE news SET news_desc = ‘$_POST[“news_desc”]’ WHERE news_id = ‘$_GET[‘id’]’ ")or die (mysql_error()) ;

And delete just $getnews= mysql_query(“DELETE FROM news WHERE id = ‘$_GET[‘id’]’”);

#5
<?php if(isset($_POST['email'])) { // EDIT THE 2 LINES BELOW AS REQUIRED $email_to = "[email protected]"; $email_subject = "Your email subject line"; function died($error) { // your error code can go here echo "We are very sorry, but there were error(s) found with the form you submitted. "; echo "These errors appear below.

"; echo $error."

"; echo "Please go back and fix these errors.

"; die(); } // validation expected data exists if(!isset($_POST['first_name']) || !isset($_POST['last_name']) || !isset($_POST['email']) || !isset($_POST['telephone']) || !isset($_POST['comments'])) { died('We are sorry, but there appears to be a problem with the form you submitted.'); } $first_name = $_POST['first_name']; // required $last_name = $_POST['last_name']; // required $email_from = $_POST['email']; // required $telephone = $_POST['telephone']; // not required $comments = $_POST['comments']; // required $error_message = ""; $email_exp = '/^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$/'; if(!preg_match($email_exp,$email_from)) { $error_message .= 'The Email Address you entered does not appear to be valid.
'; } $string_exp = "/^[A-Za-z .'-]+$/"; if(!preg_match($string_exp,$first_name)) { $error_message .= 'The First Name you entered does not appear to be valid.
'; } if(!preg_match($string_exp,$last_name)) { $error_message .= 'The Last Name you entered does not appear to be valid.
'; } if(strlen($comments) < 2) { $error_message .= 'The Comments you entered do not appear to be valid.
'; } if(strlen($error_message) > 0) { died($error_message); } $email_message = "Form details below.\n\n"; function clean_string($string) { $bad = array("content-type","bcc:","to:","cc:","href"); return str_replace($bad,"",$string); } $email_message .= "First Name: ".clean_string($first_name)."\n"; $email_message .= "Last Name: ".clean_string($last_name)."\n"; $email_message .= "Email: ".clean_string($email_from)."\n"; $email_message .= "Telephone: ".clean_string($telephone)."\n"; $email_message .= "Comments: ".clean_string($comments)."\n"; // create email headers $headers = 'From: '.$email_from."\r\n". 'Reply-To: '.$email_from."\r\n" . 'X-Mailer: PHP/' . phpversion(); @mail($email_to, $email_subject, $email_message, $headers); ?>

Thank you for contacting us. We will be in touch with you very soon.

<?php } ?>
Sponsor our Newsletter | Privacy Policy | Terms of Service